Bank Reconciliation in QuickBooks Online: Workflow and Common Problems

2026-03-02 · 7 min read

QuickBooks Online has a built-in Reconcile tool, and most of the frustration people have with it comes from the same handful of causes: a wrong beginning balance, bank-feed transactions that were auto-added without review, or a fix made after a prior period was already reconciled. Here is how the QBO workflow works and where it typically goes wrong.

Where the Reconcile tool lives

In QuickBooks Online, Reconcile sits under Accounting > Reconcile (or Transactions > Reconcile in some layouts). You pick an account, enter the statement ending date and ending balance from your bank statement, and QuickBooks shows every uncleared transaction in that account so you can tick off what appears on the statement.

The QBO reconcile workflow

Open Reconcile and select the bank or credit card account.
Enter the statement ending date and the ending balance exactly as shown on the statement.
Check off every transaction that appears on the statement: deposits and other credits on one side, checks and payments on the other.
Watch the difference at the bottom of the screen. It should move toward zero as you check items off; if it does not reach zero, something is missing, duplicated, or entered for the wrong amount.
When the difference hits $0.00, select Finish now to lock those transactions.

Exporting the register for a second opinion

If the in-app tool is not converging, it often helps to step outside it: open the account register (Accounting > Chart of Accounts > the account > View register), export the transaction list for the period, and compare it line by line against a CSV export from your bank's online portal. The free bank reconciliation tool accepts CSV from both sides and will show you exactly which lines have no match, with a reason, rather than a single unexplained difference figure.

The four problems that come up constantly

Wrong beginning balance

QuickBooks carries the ending balance from your last completed reconciliation forward as the new beginning balance. If someone edited, deleted, or unreconciled a transaction from a prior, already-closed period, the beginning balance on this reconciliation will not match the actual bank statement, and no amount of checking off current-period transactions will bring the difference to zero. The fix is to find what changed in the prior period, not to keep re-checking the current one.

Bank feed auto-add without review

QuickBooks Online can auto-categorize and add bank feed transactions using rules. This is convenient until a rule silently miscategorizes or duplicates something, most often around recurring transfers between your own accounts, which can get entered on both sides and recorded as income or expense instead of a transfer.

Duplicate transactions from feed plus manual entry

If a bill is entered manually and then the same payment also comes in through the bank feed and gets added rather than matched to the existing entry, the account balance is now double the real cash movement. QuickBooks' matching only works if you use "Match" instead of "Add" for anything you already entered by hand.

Voided or deleted checks after the fact

Voiding a check that was written in a closed period changes that period's numbers after the fact. QuickBooks will warn about this, but the warning is easy to dismiss without reading it. If a reconciliation that used to balance suddenly does not, check whether anything in that period was edited since.

Credit card sign conventions

Charges on a credit card statement are typically listed as positive amounts (increasing what you owe), while your ledger tracks the card as a liability that increases with a credit entry. This trips people up during import more than any other single issue; see the credit card reconciliation guide for the sign-flip rule.

A faster second opinion

Export the QBO register and your bank's CSV, then run both through the bank reconciliation tool. It matches by reference and amount first, then by amount within a date window, and shows every unmatched line with a reason, which pinpoints the actual mismatch far faster than staring at QuickBooks' single running difference figure.

Reconciliation reports worth keeping

The Reconciliation Report QuickBooks generates after each Finish, showing cleared and uncleared items.
The bank statement PDF or CSV itself.
A note of any adjusting journal entries made as a result of the reconciliation.

Keep all three together, by period, as your audit trail. If a period ever needs to be revisited, this is what makes the investigation take minutes instead of hours. For the general mechanics that apply regardless of which accounting software you use, see how to do a bank reconciliation.