Reconciling Accounts and Correcting Bookkeeping Errors

Compare your books with independent records, explain differences and correct entries without hiding their history.

Part 7 of 10 | Bookkeeping for Small Businesses

Learning goals

You will reconcile an account, distinguish a missing book entry from a timing difference and prepare an unresolved-item log. You will also recognise why matching totals alone do not prove that every underlying transaction is correct.

Before you begin

Allow about an hour. Use the fictional cashbook and statement figures below, with the same period end. Do not share real account numbers or download another person's statement. The exercise assumes the statement is complete for that period and contains only the described reconciling item.

Compare like with like

Choose one account and one cutoff date. Confirm the opening balance and compare each receipt and payment with the independent account record. A wallet, bank and physical cash box require separate reconciliations. Do not compare a combined business balance with a single bank statement or a live balance that includes a different day's transactions.

Match references, dates and amounts. Tick each matched item in a copy or reconciliation worksheet. Two different payments for the same amount should not be treated as interchangeable. If you cannot establish which invoice a receipt belongs to, record that allocation question even when the account total is correct.

Work through a missing fee

The practice bank cashbook starts at GMD 2,000, records receipts of GMD 1,200 and payments of GMD 700. Its calculated closing balance is GMD 2,500. The statement closes at GMD 2,475 and shows a GMD 25 account charge that was not entered in the book. The charge is fictional and is not a current bank tariff.

After checking that charge, enter one GMD 25 payment with the appropriate fee category and statement reference. The adjusted cashbook becomes GMD 2,475 and matches the statement. Do not change the opening balance or reduce a customer's receipt to make the figures agree. The correction should describe what actually caused the difference.

Handle timing differences carefully

In another independent example, the books show a GMD 300 payment instruction near the period end, but the bank has not yet processed it. Before calling this an error, establish the transaction's actual status and your recording convention. A reconciliation may list a genuine outstanding payment as a timing item; it should not invent a second expense.

Follow outstanding items into the next period and clear them only when the evidence supports it. A pending transfer can fail, be cancelled or complete later. Do not leave it indefinitely as a convenient explanation for a mismatch. Ask the provider about uncertain status without repeatedly sending the money again.

Investigate cash differences

For physical cash, count the denominations and total them, then compare with the cashbook. Recount before accepting a shortage or surplus. Check whether money was moved to a wallet, taken by the owner, received from a customer or paid for a small purchase without an entry. These are possible explanations to investigate, not conclusions.

Do not record an unexplained surplus automatically as a sale or charge a shortage to a worker without establishing the facts. Keep the discrepancy and evidence on an issues log and follow the business's review process. If a loss is confirmed, its final accounting and other treatment may require advice. An honest unresolved balance is better than a fabricated transaction.

Make corrections traceable

Suppose a real practice invoice was GMD 460 but the books show GMD 640. The overstatement is GMD 180. Correct the affected record with the source reference and date of discovery. Check whether the error also affected a supplier balance, stock entry or report. Fixing only one place can leave the records inconsistent.

For digital records, keep an adjustment or revision history; for paper records, leave the original legible and explain the change. If a completed period or filed return was affected, obtain guidance on the appropriate correction procedure. Do not quietly rewrite an already issued report and pretend it was always correct.

Finish with a review record

Write the date, account, period, book balance, external balance, adjustments and unresolved items. Name the preparer and reviewer where practical. A sole owner can revisit the reconciliation later with fresh eyes or ask a trusted adviser to review a redacted copy. Keep credentials out of the review pack.

Even a perfect match can hide errors that offset each other, such as one omitted receipt and one omitted payment of the same amount. That is why checking individual entries and source documents matters. The aim is an explained balance supported by transactions, not just two identical totals.

Guided exercise

1. Recreate the opening GMD 2,000, receipts GMD 1,200 and payments GMD 700 cashbook. Calculate the closing balance.

2. Compare it with the GMD 2,475 statement and post the verified GMD 25 charge once.

3. Write a separate timing-item note for the GMD 300 instruction, including the next check and the fact that it is not yet confirmed settled.

4. Correct the GMD 640 entry to GMD 460 and calculate the GMD 180 difference. Identify other records that could be affected.

5. Complete a reconciliation cover note and list one reason matching totals may still need transaction-level review.

Knowledge check

1. What is the adjusted cashbook balance in the fee example?

2. Is every unmatched statement item proof of fraud?

3. Should a timing difference be cleared without evidence?

Answer guide

1. GMD 2,475 after the GMD 25 charge.

2. No. Errors, missing entries and timing differences must be investigated before concluding a cause.

3. No. Confirm its actual completion, cancellation or other outcome.

Completion standard

Produce the correct fee reconciliation, traceable amount correction and follow-up note for the pending item. Explain why both totals and individual transactions require review.

Sources and verification notes

Original bookkeeping explanations and fictional worked examples. Simplified management records do not establish statutory accounts or tax treatment.