Reconcile Your Bank Account in QuickBooks, Step by Step

Reconciliation is the monthly check that proves your books agree with the bank. QuickBooks gives you a dedicated screen for it, but the software cannot judge accuracy on your behalf. This guide walks through the process in QuickBooks Online, notes where Desktop differs, and covers the two problems we see most often: a beginning balance that will not match and a difference that will not clear.

Before you start

You need three things: the statement’s ending balance, its closing date, and a quiet half hour. Enter or import every transaction for the period first. Reconciling before the books are complete means doing the same work twice, so finish data entry before you begin.

How do you start a reconciliation in QuickBooks Online?

1. Open Settings, then choose Reconcile under Tools.
2. Select the bank or credit card account.
3. Check the beginning balance against your last reconciliation. Enter the statement’s ending balance and ending date. Add any service charge or interest the statement shows.
4. Select Start reconciling.
5. Work through the statement line by line. Tick each transaction only after you find it on the statement. The payments, deposits, and all filters help, and so does the search box.
6. Watch the summary bar at the top. Your target is a difference of 0.00.
7. When the difference reads zero, choose Finish now. Run the summary and detail reports, then save both.

Does QuickBooks Desktop work the same way?

Mostly. Desktop puts the starting point under the Banking menu as Reconcile. The opening window asks for the same figures: beginning balance, ending balance, and statement date. You mark items cleared until the difference reaches zero, then choose to reconcile now. The screens differ between products; the discipline does not.

What should you do when the beginning balance does not match?

A changed beginning balance almost always means someone edited, deleted, or added a transaction inside an already reconciled period. QuickBooks builds that figure from every previously cleared entry, so a change there flows straight into it. Pull your last reconciliation report and compare its cleared transactions against the ledger. One edited amount or one deleted check is usually the whole story. Correct the entry, and the beginning balance corrects itself.

Should you adjust a small leftover difference?

Sometimes a few cents or a few dollars remain after every line is matched. An adjusting entry can force the difference to zero, and QuickBooks offers that route. Treat it as a last resort. Small leftovers often hide a duplicate entry, a mistyped amount, a fee posted on the wrong side, or a transaction dated into the wrong period. Find the cause first. Adjust only when the amount is genuinely immaterial, and record why you accepted it.

Habits that keep reconciliations short

• Reconcile each statement the week it arrives, while the period is fresh.
• Never edit or delete a reconciled transaction casually. If a finished month must be redone, work from the account’s reconciliation history rather than unticking entries one by one.
• A connected bank feed speeds up entry, but matched in the feed is not the same as reconciled. The statement check still happens here.
• Save the report every month. That file is your audit trail when a balance question surfaces later.

Pull your latest statement now, note the ending balance and closing date, and run the reconciliation while the numbers are still easy to remember. If the beginning balance disagrees with your records, stop and compare against last month’s saved report before you tick a single box.