Guide

How to reconcile a bank statement, step by step

A step-by-step bank reconciliation: match the statement to your ledger, explain every difference and book the fixes. The manual method, then how AI does it.

By the Keelhand team4 min read

A bank reconciliation checks that your books and your bank agree. You take the bank statement for a period, match each line to an entry in your bank ledger, and explain every line that does not match. When you are done, the reconciled balance in your books equals the balance on the statement, after allowing for items still in transit.

This guide walks through the manual method first, so you know what good looks like, and then shows how an AI finance team does the same work.

What you need before you start

You need the bank statement for the period, ideally as a spreadsheet rather than a PDF, and your bank ledger for the same dates. Make sure every receipt and payment you know about has been recorded first; a reconciliation done on incomplete books just finds the entries you have not posted yet.

How to reconcile a bank statement manually

  1. Start from the opening balance

    Check that the opening balance on the statement equals last month’s reconciled balance. If it does not, last month’s reconciliation needs another look first.

  2. Match the easy lines

    Tick off every statement line that has a ledger entry with the same amount, the same direction and a close date. Most lines match this way.

  3. Look for split and combined entries

    One payment in your books may appear as several lines on the statement, or the other way round. Match these as groups.

  4. Explain what is left on the statement

    Lines on the statement with no entry in your books are usually bank charges, interest, or receipts and payments nobody recorded.

  5. Explain what is left in the books

    Entries in your books with no statement line are usually cheques not yet cleared or deposits in transit. They should clear early next month.

  6. Fix the books

    Book the bank charges and missing entries, and correct anything posted with the wrong amount. Never adjust the statement; adjust your books.

  7. Prove the balance

    Your ledger balance, plus or minus the items in transit, should now equal the statement’s closing balance. Record who reconciled it and when.

Common reasons a line does not match

Almost every unmatched line falls into one of a few groups. Timing: the entry is on both sides but the dates are too far apart, such as a cheque that cleared after month-end. Missing posting: the bank has it and the books do not. Bank charges: the bank’s own fees or tax, not yet booked. Wrong amount: the entry exists but with a different amount or direction. Knowing the group tells you the fix.

A worked example

Suppose October’s statement has 1,187 lines and your bank ledger has 1,187 entries. After matching, 1,184 lines are ticked off on both sides. Three statement lines and three ledger entries are left.

The first statement line is a bank charge of Rs 1,250 that nobody booked: you post it to bank charges. The second is a supplier payment of Rs 9,000 that is in your books as Rs 9,900: you correct the entry. The third is a customer deposit of Rs 84,000 that the bank shows on 31 October and you recorded on 2 November: a timing difference, so you match the two. The last ledger entry is a cheque you issued on 30 October that the supplier has not banked yet: it is in transit and will clear next month.

Once the charge is booked and the wrong amount corrected, your ledger balance minus the uncleared cheque equals the statement balance. The figures here are illustrative.

How to keep reconciliations easy

Reconcile little and often. A week of statement lines takes minutes; a quarter takes days, and by then nobody remembers what a payment was for. Use clear references on every payment and receipt, so the bank line and the ledger entry carry the same reference and match on sight.

Your bank reconciliation checklist

  • Opening balance agrees with last month’s reconciled balance
  • All known receipts and payments recorded first
  • Simple matches ticked off
  • Split and combined entries matched as groups
  • Bank charges and interest booked
  • Missing receipts and payments recorded
  • Wrong amounts corrected in the books
  • Items in transit listed
  • Reconciled balance equals the statement
  • Reconciliation signed off and dated

How does the AI finance team in Keelhand do it?

In Keelhand you import the statement as an Excel or CSV file with date, description, reference, debit, credit and balance columns; headings such as Narration, Particulars, Withdrawal and Deposit are recognised.

The AI finance team then matches each line to your bank ledger by amount, direction and date, including entries the bank split into several lines. Every line it cannot match is given a reason from the groups above. Where an entry is missing, such as a bank charge, it drafts the entry for a person to approve. Nothing reaches the ledger until someone approves it.

Frequently asked questions

How often should I reconcile my bank account?

At least every month, as part of the close. Busy businesses reconcile weekly, so differences are found while they are still easy to explain.

What if the reconciled balance still does not match?

Check the opening balance first, then look for a line matched to the wrong entry, an entry recorded twice, or an amount typed with digits swapped.

Should I ever change the bank statement?

No. The statement is the bank’s record. Every correction goes into your own books.

More questions and answers

See how the AI finance team reconciles the bank.

AI bank reconciliation
More guides

Keep reading

See it on documents like yours.

Free onboarding on annual plans.