Most business owners open the reconcile screen in QuickBooks Online, see a difference of a few hundred shillings, panic, and close the tab. Weeks pass. The gap grows. By the time someone calls me about it, three months have gone unreconciled and nobody trusts the numbers on the balance sheet anymore.

Reconciliation is not complicated. It is tedious, and it punishes shortcuts, but the process itself is mechanical once you understand what QuickBooks is actually checking. This is the walkthrough I give clients before I ever touch their books.

What Reconciliation Actually Confirms

Reconciling a bank account means matching every transaction in QuickBooks against every transaction on your bank statement for the same period, so that the ending balance in QuickBooks equals the ending balance the bank reports.

It is not about whether your books "look right." A bank account can be fully reconciled and still contain a miscategorized expense sitting in the wrong account. Reconciliation only confirms that the money moving in and out matches what the bank recorded. Categorization is a separate job, done afterward.

This distinction matters because owners often assume a clean reconciliation means clean books. It means clean cash. That is still valuable, but it is not the whole picture.

Step 1: Gather the Right Statement

Before opening QuickBooks, get the actual bank or credit card statement for the exact period you are reconciling. If you are reconciling June, you need the statement showing the closing balance on June 30, not a screenshot of your current balance in July.

Note two figures from the statement: the beginning balance and the ending balance. You will need both.

Step 2: Open the Reconcile Tool

In QuickBooks Online, go to Accounting > Reconcile (or search "Reconcile" in the search bar). Select the account you are working on from the dropdown.

QuickBooks will show a beginning balance it has calculated from your books. This should match the beginning balance on your statement. If it does not, stop here. Something from a prior period was not reconciled correctly, and fixing this month will not solve that. I come back to this problem later in this article.

Step 3: Enter the Statement Ending Balance and Date

QuickBooks asks for the ending balance and ending date from your statement. Type these in exactly as they appear on the statement, not what you estimate the balance should be.

This step trips people up more than any other. If your statement says $82,315.60 and you type $82,315, QuickBooks will show a small unexplained difference at the end that has nothing to do with your transactions and everything to do with a typo.

Step 4: Match Transactions One by One

QuickBooks now shows two columns: deposits and payments, pulled from what has already been entered into your books. Your job is to tick off every transaction that also appears on the bank statement.

Work through this systematically rather than jumping around:

  • Go line by line down the statement, not down the QuickBooks list.
  • For each statement line, find its match in QuickBooks and click the checkbox.
  • If a transaction on the statement has no match in QuickBooks, it has not been recorded yet. Stop and add it before continuing.
  • If a transaction in QuickBooks has no match on the statement, it likely has not cleared yet, or it was entered in error.

Do not tick anything you have not personally verified. I have seen bookkeepers tick everything just to make the difference hit zero, which defeats the purpose entirely and buries the real problem one layer deeper.

Step 5: Watch the Difference Field

As you tick transactions, a "Difference" figure updates at the top or bottom of the screen. This is the number you are working toward zero. It represents the gap between what you have matched so far and what the statement says should be true.

When the difference reaches zero, every transaction is accounted for and the account is reconciled. Click Finish Now.

What to Do When the Difference Is Not Zero

This is where most reconciliations actually go wrong, and where owners give up. A nonzero difference almost always comes from one of these five causes.

Missing Transactions

A bank charge, an credit card transaction fee, or a small interest credit that never made it into QuickBooks. Banks are particularly fond of small recurring charges — ledger fees, excise duty on transfers, SMS alert charges — that owners forget to record because no invoice triggers them. Add these directly from the reconcile screen using the "Add" button, then match them.

Duplicate Entries

A payment entered twice, once manually and once through a bank feed import. Search for the transaction in the register and delete the duplicate, not both copies.

Wrong Amount Entered

A payment recorded as $ 45,000 when the bank cleared it at $ 54,000. This usually comes from a transposition error at data entry. Open the transaction, correct the figure, and the match should fall into place.

Transactions Dated in the Wrong Period

A payment made on May 31 but recorded on June 1 will not appear on the May statement, throwing off both months. Check the transaction date against the actual value date on the bank statement, not the date the cheque or invoice was written.

A Prior Period That Was Never Properly Reconciled

If your beginning balance did not match the statement in Step 2, this is your answer. Someone edited, deleted, or added a transaction in a period that was already reconciled, and QuickBooks quietly shifted the opening balance for every month since. This is the most time-consuming problem to fix because it requires going back to the last period you are confident was correct and working forward from there.

A Habit Worth Building

Reconcile every account monthly, within the first week after the statement closes. The longer a discrepancy sits, the more transactions pile up on top of it, and the harder it becomes to isolate which one caused the original gap. A $ 500 difference found the same week takes ten minutes to trace. Found four months later, it can take an entire afternoon of comparing statements line by line.

When to Stop Doing This Yourself

If you have gone through the five causes above and the difference still will not clear, or if you are looking at several unreconciled months and do not know where the trail went wrong, that is usually the point where continuing to poke at it costs more in time than it would to have someone sort it out properly.

If your accounts have reached that stage, or you would rather hand reconciliation off every month and never look at a Difference field again, get in touch and I will take it from here.