Bank Reconciliation in QuickBooks Online: A Practical Guide

Bank reconciliation is the most underrated bookkeeping discipline. Done monthly and done right, it catches data entry errors, missed transactions, and bank-side mistakes before they compound. Skipped or done sloppily, it creates the kind of mess that takes days to untangle six months later.

This guide covers reconciliation in QuickBooks Online specifically — the workflow, the common problems, and how to handle the situations where the numbers don't tie.

When to reconcile

Monthly, after the bank statement closes. Don't reconcile mid-month — you won't have a clean cutoff. Don't wait three months — the harder reconciliation gets, the harder it gets.

The basic workflow

To reconcile a bank account in QBO:

1. Go to Bookkeeping → Reconcile
2. Pick the bank account you're reconciling
3. Enter the statement's ending date and ending balance
4. Click Start reconciling
5. QBO shows you all uncleared transactions. Check each one that appears on the statement.
6. As you check items, the "Difference" at the top updates. The goal is to get it to $0.00.
7. If the difference is $0.00, click Finish now. If it's not zero, investigate before finishing.

That's the basic flow. Steps 5 and 7 are where reconciliation either takes 10 minutes or 2 hours.

Matching cleared transactions

Every transaction that appears on the bank statement should have a matching entry in QBO. The matching is usually obvious:

• Same date, same amount: Easy match.
• Same amount, different date by a day or two: Usually fine — bank posting dates differ from transaction dates.
• Same date, slightly different amount: Investigate. Could be a fee included on one side but not the other.

Items that don't have a match: either the QBO entry is missing (you forgot to record it) or the bank statement entry is wrong (rare but happens).

Handling outstanding checks and deposits in transit

Some QBO entries don't appear on the current bank statement because they haven't cleared yet:

• Outstanding checks: Checks you wrote but the recipient hasn't deposited yet. Leave them unchecked in this month's reconciliation; they'll clear in a future month.
• Deposits in transit: Deposits you recorded in QBO but the bank hasn't credited yet. Leave them unchecked.

The reconciled balance accounts for these — QBO knows that the difference between book balance and bank balance can be the sum of outstanding items.

When the difference won't go to zero

The reconciliation looks correct, every cleared item is checked, but the Difference says $14.62 or something similar. Here's how to find it:

Step 1: Verify the statement ending balance

Re-enter it. Typos here cause many "doesn't reconcile" situations.

Step 2: Verify the statement ending date

If you entered the wrong date, QBO is comparing your books against a different point in time than the statement shows.

Step 3: Sort by amount and look for duplicates

In the QBO reconciliation screen, sort by amount. Look for any pair of transactions with the same amount — could be a duplicate entry or a transfer recorded twice.

Step 4: Check for outstanding items older than 60 days

An "outstanding check" from six months ago is probably never going to clear. Either the check was lost (void it and reissue) or it was never cashed (void it). Stale outstanding items inflate the unreconciled balance.

Step 5: Compare cleared totals

Sum the amounts of items you've checked. Compare to the bank statement's total deposits and withdrawals. If they don't match, one or more items are mis-checked.

The "I'll just adjust" trap

QBO offers a "discrepancy adjustment" option that lets you finish reconciliation even when the difference isn't zero. Avoid this except as a last resort. Adjustments paper over real problems and accumulate over time. If you can't find the discrepancy, leave the reconciliation unfinished and come back to it.

The only legitimate use of the discrepancy adjustment is when the amount is small (under $1), the bank statement is clearly the authoritative source, and you've documented why you're adjusting.

What to do if reconciliation has been skipped for months

If you inherit books that haven't been reconciled for 6+ months, don't try to reconcile all of them at once. Start with the most recent month and work backward. The most recent month is the easiest to reconcile because the bank statement is fresh and items haven't been forgotten.

For deep catch-up engagements with extensive unreconciled periods, see our catch-up bookkeeping playbook.

The relationship between reconciliation and PDF conversion

If you're converting PDF bank statements to import into QBO (rather than using bank feeds), reconciliation is even more critical — the conversion step is error-prone, and reconciliation catches the errors. Some bank statement converters reconcile the converted file before you download, which catches errors earlier in the process. See our converter buying guide.