Reconciliation is the single most useful habit in bookkeeping. It proves that what is in QuickBooks matches what actually happened in your bank. Here's how to do it, and what to do when the numbers won't agree.

What you need before you start

  • Your bank statement for the month, with its opening and closing balances
  • All transactions for that month already entered or matched in QuickBooks
  • The previous month's reconciliation completed

Always reconcile months in order. If last month isn't reconciled, start there.

Step 1: Open the Reconcile page

In QuickBooks Online, you can find Reconcile in the left-hand menu under your transactions or bookkeeping section. You can also reach it from the gear icon. Intuit moves menu items from time to time, so if you can't see it, search for "Reconcile" in QuickBooks.

Step 2: Choose the account and check the beginning balance

Select the bank account you want to reconcile. QuickBooks shows a beginning balance. It must match the opening balance on your bank statement.

If it doesn't match, stop. A transaction from a month you already reconciled has been changed or deleted. Fix that first (see "Common problems" below), or every later month will be wrong too.

Step 3: Enter the statement details

Enter the ending date and ending balance exactly as they appear on your statement. If the statement shows bank fees or interest that aren't in QuickBooks yet, you can enter them here too. Then click Start reconciling.

Step 4: Tick off each transaction

Work down your statement line by line. For each item, find the matching transaction in QuickBooks and tick it. Using the Payments and Deposits filters makes this faster.

As you tick, QuickBooks updates the difference at the top of the screen.

Step 5: Investigate anything that doesn't match

  • On the statement but not in QuickBooks: add the missing transaction, then tick it.
  • In QuickBooks but not on the statement: this may be a timing difference, such as a check that hasn't cleared yet. Leave it unticked. If it's a duplicate or an error, correct it.
  • Amounts that differ: compare the original document with what was entered.

Step 6: Finish when the difference is 0.00

When the difference shows 0.00, click Finish now. Save or download the reconciliation report and keep it with your statement.

If you try to finish with a difference, QuickBooks will offer to post an adjustment entry. Avoid this. It hides the problem instead of fixing it.

Common problems and how to fix them

  • The beginning balance doesn't match. Someone edited, deleted or un-ticked a transaction in a period you had already reconciled. Open the reconciliation history for the account and compare the last report with the current figures to find the changed item.
  • Duplicate transactions. These usually come from accepting a bank feed item as new instead of matching it to a transaction that already existed. Delete the duplicate.
  • Transfers recorded on one side only. A transfer from checking to savings must appear in both accounts. Record it as a transfer, not as an expense or income.
  • Grouped deposits. Your bank may show one deposit while QuickBooks shows several customer payments. Group them into a single deposit in QuickBooks so they match the statement.

How often should you reconcile?

At least monthly. Businesses with many transactions often reconcile weekly. Reconcile every bank account, credit card and loan, not just your main checking account.