Skip to main content

How do I reconcile QuickBooks vendor bills against bank disbursements?

Run QuickBooks Online's own reconciliation workflow against the bank feed, then specifically verify every bill a workflow created shows up as a matched disbursement. Enter the statement's ending balance and date, check off matching transactions until the difference reads $0.00, and treat any workflow-created bill missing from that match set as a sync gap to investigate, not a normal exception.

Zuny FesterBy Zuny Fester, Head of Operations and Marketing
Reviewed by Zuny Fester
Published Last reviewed Editorial policy

Part of the finance integrations guide.

Where this happensQuickBooks Online's built-in Reconcile screen, run against the bank/credit card feed
Pass conditionThe Difference field reads $0.00 after all transactions are checked off
Workflow-specific checkEvery bill created through a Loopfour workflow should appear as a matched disbursement in that period
If a workflow bill is missingTreat it as a sync gap — see the phantom-liability diagnostic for the specific broken-sync failure mode
CadenceRoutine, periodic practice — not only triggered by a known break

This is routine verification, not incident response

A separate page on this site walks through one specific, named failure mode: a phantom AP liability where a bill's payment silently fails to sync back from an AP automation tool, leaving a paid bill looking open. That page is what to read once something's already visibly wrong. This page is the routine practice that's supposed to catch problems — including that one — before they reach period close: periodically reconciling every vendor bill a Loopfour workflow created against what actually left the bank.

How QuickBooks Online's reconciliation actually works

QuickBooks Online's Reconcile screen starts with the ending balance and ending date from the bank or credit card statement. From there, the workflow is a checklist: select the checkbox next to each QuickBooks transaction that matches a line on the statement, and keep going until the Difference field reads $0.00 — that's the platform's own definition of a balanced account. If it doesn't hit zero on the first pass, QuickBooks lets you edit the entered ending balance and date rather than forcing you to abandon the session.

What to check specifically for workflow-created bills

The generic reconciliation workflow above treats every transaction the same way. The workflow-specific addition is narrower: pull the list of vendor bills a Loopfour workflow created and paid in the period, and confirm each one has a corresponding checked-off line in that same reconciliation pass. A bill that was genuinely paid but doesn't appear as a matched disbursement is exactly the shape of a broken payment-sync — the bill exists, the payment happened, but the two records never connected.

Why this has to be a habit, not a one-time check

A mapping or sync issue that caused one workflow-created bill to desync doesn't announce itself — the bill still looks normal in AP aging, and nothing about the vendor relationship changes. The only way to catch it before close is to make the workflow-bill-versus-bank-disbursement check part of every regular reconciliation pass, not something reserved for when a vendor complains about a payment or a number already doesn't tie.

Next step

Map the finance workflow with the most exposure and prove the automation path.

Bring the invoice, contract, payment reconciliation, or customer finance workflow you have to defend at audit. Loopfour can map the trigger, controls, integrations, and approval loop.

Book a workflow review

Checklist

Workflow-bill reconciliation checklist

  1. Pull every vendor bill created by a Loopfour workflow in the statement period
  2. Open QuickBooks Online's Reconcile screen and enter the statement's ending balance and date
  3. Check off matching transactions until the Difference field reads $0.00
  4. Cross-reference: every bill from step 1 should be among the checked-off, matched transactions
  5. Any bill from step 1 that isn't matched is a sync gap to investigate immediately, not at close

Frequently Asked Questions

That page is a specific diagnosis for one already-broken sync (a Bill.com payment that never synced back). This page is the routine, periodic check that's meant to catch that and similar gaps before they reach close.

As often as the account is reconciled generally — most teams do this monthly at minimum, and more frequently at higher transaction volume, since a gap sitting unresolved for a full month is harder to trace back to its cause.

That's possible if the missing bill's amount happened to be offset by an unrelated discrepancy elsewhere — a balanced Difference field confirms totals match, not that every individual transaction you expected is present. The workflow-bill cross-reference in step 4 is a separate check for exactly this reason.

Sources

Related