How to reconcile a bank statement in QuickBooks Online
Published September 10, 2026
Convert a PDF statement to .qbo → Free for 25 pages a month.
The short answer: open Reconcile from the gear icon, choose the account, and enter the statement's ending date and ending balance. QuickBooks fills in the beginning balance from your last reconciliation — check it against the statement's opening balance before anything else. Then tick every transaction that appears on the statement until the Difference reads 0.00, and click Finish now. If it won't reach zero, the table below says where to look.
Before you start
- Every transaction for the period is in QuickBooks and added — not sitting in For Review. Anything still waiting there won't appear on the reconcile screen. If months are missing entirely, upload the statements first.
- You have the statement itself, with its opening balance, closing balance and closing date.
- You reconcile in order. Oldest unreconciled statement first, one statement at a time. A skipped month hides its errors inside the next one.
Step by step
- Open Reconcile. Gear icon → Reconcile (also in the Transactions or Accounting menu, depending on your navigation).
- Choose the account — the bank or credit card account this statement belongs to.
- Check the beginning balance. It must equal the statement's opening balance. If it doesn't, go to the troubleshooting table before continuing.
- Enter the ending balance and ending date exactly as printed on the statement.
- Tick the transactions. Work down the statement and tick each matching deposit and payment. Sorting by date or amount makes the matching quicker.
- Get the Difference to 0.00. Anything else means the books and the statement disagree about something specific.
- Finish now. Keep the reconciliation report QuickBooks produces — it's the record that this period was checked.
When the difference won't go to zero
| What you see | Likely cause | Where to look |
|---|---|---|
| Difference equals one transaction's amount | A statement line missing from QuickBooks, or an extra one in QuickBooks | Compare statement and screen line by line; missing lines usually never got imported |
| Difference is twice a transaction's amount | That transaction was entered with the wrong sign | A deposit recorded as a payment, or a card charge recorded as a payment |
| Difference divides evenly by 9 | Transposed digits — 48.20 entered as 84.20 | Amounts you typed or edited by hand |
| Two identical transactions ticked, or one left over | A duplicate from overlapping imports (feed plus upload) | Sort by amount; check the dates where the feed and uploaded files overlap |
| Beginning balance doesn't match the statement | A previously reconciled transaction was edited, deleted or unmarked | The account's reconciliation history, against the last statement you reconciled |
Don't force it with an adjustment
When the difference won't close, QuickBooks will let you finish anyway by posting an adjustment for the gap. It's tempting on a small amount. Resist it: the adjustment doesn't fix the error, it books an unexplained amount so the screen balances, and next month starts from a number that isn't real. Find the transaction instead — the table above narrows it to a handful of places.
Reconciling history you imported from PDF statements
When a cleanup brings in months of history from PDF statements, the conversion itself is the first place people suspect. Our PDF to QBO converter rules that out up front: every conversion is checked against the statement's own printed balances — opening balance plus transactions must equal the closing balance — and flagged if it doesn't close. So when a converted statement won't reconcile in QuickBooks, the cause is on the QuickBooks side: a duplicate from the feed, a transaction edited after import, or one added to the wrong account.
Reconciling outside QuickBooks — before a migration, or for an account that isn't in the books? Use the free bank reconciliation template, which lays out the same logic in Excel.
Questions people ask
- Where is Reconcile in QuickBooks Online?
- Under the gear icon (Settings) → Reconcile. Depending on which navigation your company file uses, it's also in the Transactions or Accounting menu. Pick the account, enter the statement's ending date and ending balance, and start.
- What if the beginning balance doesn't match my statement?
- Stop and fix that first — no amount of ticking will close the difference. It means a transaction from a period you already reconciled was edited, deleted or unmarked since. Compare the account's reconciliation history against the last statement you reconciled to find which one moved.
- Why won't my QuickBooks reconciliation difference go to zero?
- The usual causes: a transaction on the statement that never got into QuickBooks, one in QuickBooks that isn't on the statement (often a duplicate from overlapping imports), an amount entered with the wrong sign, or a transposed digit. If the difference divides evenly by 9, look for transposed digits first.
- Should I finish a reconciliation with an adjustment?
- Only as a last resort, and never to make a real error disappear. QuickBooks will let you finish with a difference by posting an adjustment, but that books an unexplained amount to your accounts — the error is still there, just hidden, and it resurfaces at year end.
- Do I reconcile credit card accounts the same way?
- Yes: same screen, using the card statement's closing balance and closing date. The signs are the thing to watch — charges increase what you owe, so a file that imported charges as payments will never reconcile.
This guide is about file conversion and bookkeeping tooling — it isn't tax, accounting, or legal advice. Verify converted data against the source statement before filing or posting it.