QuickBooks Online Reconciliation: A Step-by-Step Troubleshooting Guide

Reconciliation confirms that the transactions recorded in QuickBooks Online match what actually happened in the bank or credit card account. Doing it monthly, without exception, is what makes every other number downstream of it trustworthy. Skipping a month doesn't just delay the work — it lets small discrepancies compound into a much harder problem to untangle later.

The basic steps

1. Gather the bank or credit card statement for the period you're reconciling.
2. In QuickBooks Online, go to Accounting, then Reconcile.
3. Select the account, and enter the statement ending date and ending balance exactly as shown on the statement.
4. Match each transaction in QuickBooks against the corresponding line on the statement, checking them off as they match.
5. Investigate anything that doesn't have a match — a transaction in QuickBooks with nothing on the statement, or a statement line with nothing recorded.
6. Confirm the difference shown is $0.00 before finishing the reconciliation. Do not finish with a non-zero difference to "deal with later."

The most common reasons it won't balance

• Duplicate transactions — the bank feed auto-added a transaction that was also entered manually, creating two records for one real transaction.
• Missing transactions — something posted at the bank but hasn't synced into QuickBooks yet, especially near month-end.
• Timing differences — an outstanding check or a deposit in transit that the bank hasn't processed yet, which is normal and not actually an error.
• Previously reconciled transactions that were edited or deleted after the fact — this is the one that causes the most confusion, because it silently breaks a reconciliation that was already correct in a prior period.
• Miscategorized transactions that still net to the right balance but throw off matching, since QuickBooks is trying to match by amount and date, not just category.

Troubleshooting a stubborn out-of-balance amount

1. Check the beginning balance first — it should match the ending balance from the last successful reconciliation exactly. If it doesn't, something in a prior period was changed.
2. Run the Reconciliation Discrepancy report, which specifically flags transactions that were modified or deleted after being reconciled.
3. Look for a transaction entered twice — sort by amount to spot duplicates quickly.
4. Resist the urge to force it to zero with a plug or adjustment entry. That hides the actual error instead of fixing it, and the same discrepancy tends to reappear next month.

A habit that prevents most of this

Reconcile monthly, not quarterly. The gap between when an error happens and when it's caught is what determines how hard it is to fix — a duplicate or miscategorized transaction found the same month takes minutes to correct. The same error found three months later, buried under two more months of transactions, takes considerably longer.