How to Reconcile Bank Accounts in QuickBooks Online and Desktop (Year-End Checklist)
Reconciling means checking that every transaction in QuickBooks matches your bank or credit card statement, so the balance in your books equals the balance the bank reports. Do it every month, for every bank and credit card account. At year-end it matters most: your accountant, your tax return and any loan application all rely on those balances.
Before you start
- Have the statement for the month (PDF or paper) with its ending date and ending balance.
- Make sure all transactions for the month are in QuickBooks: bank feed items reviewed and added, checks and deposits entered. A bank feed that disconnected can leave a silent gap; see Getting missing transactions in below.
- Reconcile months in order. You can’t skip ahead: each reconciliation starts where the last one ended.
Reconcile in QuickBooks Online
According to Intuit’s help article (updated August 2026):
- Go to All apps → Accounting → Reconcile (in some layouts: Settings ⚙ → Reconcile). If it’s the first time, select Get started.
- From the Account dropdown, choose the bank or credit card account.
- Enter the Ending balance and Ending date exactly as printed on the statement. Check the last statement ending date shown: this statement should start the day after it.
- Select Start reconciling.
- Tick each transaction that also appears on the statement. Watch the Cleared balance change.
- Keep going until the Difference is $0.00, then select Finish now and Done.
If the account doesn’t balance, use Edit info to correct a mistyped ending balance or date first, the most common cause.
QuickBooks saves a reconciliation report each time. To find old ones, open the Reconcile page and select History by account.
Reconcile in QuickBooks Desktop
- Banking → Reconcile, choose the account.
- Enter the Statement Date and Ending Balance, plus any service charge or interest earned shown on the statement, then Continue.
- Mark each deposit and payment that appears on the statement as cleared.
- When Difference shows 0.00, click Reconcile Now and save or print the report.
Previous reports are under Reports → Banking → Previous Reconciliation. If the beginning balance has changed since last month, Locate Discrepancies in the Begin Reconciliation window opens the Reconciliation Discrepancy report, which lists cleared transactions that were edited, deleted or added after that reconciliation.
When the difference won’t go to $0.00
Work through these in order:
- Ending balance or date typed wrong. Compare with the statement again.
- Transposed or mistyped amounts. A difference divisible by 9 (for example $27 or $450) often means two digits were swapped, as in $54 entered as $45.
- A transaction is on the statement but not in QuickBooks. Bank fees, interest, a transfer, a deposit added straight from the feed to the wrong account.
- A transaction is in QuickBooks twice. Typically one from the bank feed and one entered by hand, or a deposit recorded and then matched again. Check amounts that appear twice around the same date. See how to find and fix duplicate transactions.
- Something cleared in an earlier month was changed. The beginning balance no longer matches last month’s ending balance. In Desktop, run the discrepancy report above. In QuickBooks Online, compare the earlier reconciliation report in History by account with the register to find the changed item.
- The opening balance was never entered (first reconciliation). Intuit has a separate help article for this case; the fix is an opening balance entry dated before your first statement.
Avoid “forcing” a reconciliation with an adjustment entry unless you understand what the difference is. An unexplained adjustment usually just hides a missing or duplicate transaction until it surfaces again.
Undoing a reconciliation: in Desktop, Banking → Reconcile → Undo Last Reconciliation (one period at a time; back up first). In QuickBooks Online, undoing an entire reconciliation is done from your accountant’s QuickBooks Online Accountant account; you can also remove individual transactions from a reconciliation in the account register.
Missing transactions in the bank feed
Bank feeds usually only go back about 90 days when you connect or reconnect an account, and a feed that drops silently for a few weeks leaves a gap you only notice when the reconciliation won’t balance. To fill it:
- Download the missing date range from your bank’s website, as QuickBooks Web Connect (.qbo) if offered, otherwise CSV or QFX.
- Convert if needed: CSV to QBO or QFX to QBO. Both run in your browser, so the statement is never uploaded.
- Upload it: QuickBooks Online Banking → Link account ▾ → Upload from file; Desktop File → Utilities → Import → Web Connect Files.
- Start the file the day after the last transaction QuickBooks already has, so nothing is duplicated.
Want to compare the bank’s file with your books line by line? Open a .qbo or .qfx download as a spreadsheet with QBO to Excel and sort by date or amount.
For the full import options, see how to import bank and credit card transactions into QuickBooks.
Year-end checklist
- Every bank, savings, credit card and loan account reconciled through the December statement (check the statement’s ending date, it may not be Dec 31).
- PayPal, Stripe, Square or Shopify clearing accounts reconciled to each platform’s year-end balance (PayPal, Stripe).
- Old uncleared checks and deposits reviewed: anything months old needs a decision (voided, reissued, or genuinely outstanding).
- No transactions left in For review / Bank Feeds Center for the year.
- Reconciliation reports for December saved as PDF for your accountant.
- Books closed so last year can’t change by accident: QuickBooks Online Settings ⚙ → Account and settings → Advanced → Accounting → Close the books; Desktop Edit → Preferences → Accounting → Company Preferences → Set Date/Password.
Related
- Missing bank transactions in QuickBooks: import last year’s gaps
- How to find and fix duplicate transactions in QuickBooks
- How to import bank and credit card transactions into QuickBooks
- QuickBooks bank feed errors 102, 103, 324 and 9999
- QuickBooks Desktop bank feeds not working
- Convert a PDF bank statement to Excel