How to Reconcile a Bank Account in QuickBooks Online

Reconciling a bank account means comparing the transactions in your accounting records with the bank statement for the same period. The goal is not simply to make a difference disappear; it is to understand why the difference exists and confirm that the books reflect the actual activity. A good reconciliation process normally starts with the statement's ending balance and then works through uncleared items, duplicates, missing transactions, timing differences and bank fees. In QuickBooks Online, reconciliation becomes much easier when transactions have been categorized consistently before the reconciliation is started.

1. Start with the ending balance

Enter the statement ending date and ending balance exactly as they appear on the bank statement. Avoid guessing. A small opening or ending balance error can make an otherwise correct reconciliation appear out of balance.

2. Review uncleared transactions

Look for checks, deposits, transfers or card transactions that remain uncleared for unusually long periods. Old uncleared items are often where duplicate entries or missing transactions surface.

3. Match transactions carefully

Compare date, description and amount. Transfers between accounts deserve particular attention because recording a transfer as an expense can distort both the income statement and the balance sheet.

4. Investigate differences

Common causes include duplicate entries, bank fees, missing transactions, incorrect dates, incorrect amounts and transactions posted to the wrong account.

5. Complete and document the reconciliation

Once the difference is zero, save the reconciliation report and note any legitimate timing items that remain. A documented close process makes the next reconciliation faster and more reliable.