Money basics

Walking a bank statement against your ledger line by line

A methodical way to compare a statement with your own records, with a tick system that makes missing and extra entries obvious.

Editorial illustration for Walking a bank statement against your ledger line by line

The purpose of the walk

A bank statement is the bank’s account of what happened. Your ledger is yours. Walking one against the other, line by line, shows where they disagree. Disagreements are not always errors on your side; sometimes the bank has posted something late, charged a fee or processed a payment you forgot. In every case, the walk converts a vague worry into a short list of facts.

What you need

The statement for the period, either as a file or on paper, and your ledger entries for the same account and dates. If possible, sort both by date. Have a pen or a way to mark lines.

Know your opening balances: the statement’s opening balance should equal the previous month’s closing balance in your ledger.

The tick method

Go down the statement one line at a time. For each line, find the matching entry in your ledger and mark both as matched. When a statement line has no match, circle it. When a ledger entry has no statement line, underline it.

At the end, three sets exist: matched, statement-only and ledger-only. Only the last two need attention.

What the unmatched lines usually are

  • Statement-only items: bank fees, interest, standing instructions you forgot, direct debits, small automatic charges and credits from refunds.
  • Ledger-only items: payments initiated but not yet cleared, cheques not presented, scheduled transfers not yet processed and entries you made in error.

Each line needs a decision: add to the ledger, wait for clearing, correct, or query with the bank.

A worked example

Opening balance 20,000. Ledger shows four payments totalling 6,800 and two receipts totalling 9,500, giving 22,700. The statement closes at 22,100.

SourceAmountReason
Ledger closing22,700-
Statement fee not in ledger-150Add to ledger
Payment initiated, not yet cleared-450Wait, note date
Adjusted ledger22,100Agrees with statement

The difference of 600 splits into two explainable pieces. The walk has turned a puzzle into a small to-do list.

Dealing with timing differences

Payments made late on the last day of a month may appear on the statement in the next. Receipts may take a day. These are normal. Mark them as timing items and check them off next month. If one is still missing after a reasonable time, query it.

Keep a short list of outstanding items with dates. A timing item that lingers is a candidate for investigation.

Spotting problems

Look for duplicates, amounts that do not match what you expected, unfamiliar merchants and payments on dates you were not active. Compare amounts exactly, not approximately; a swapped pair of digits is a classic mistake.

If you find something you do not recognise, do not ignore it. Check with household members first, then with the bank. Early notice of an unauthorised payment gives you the best chance of resolving it.

Recording the result

At the end of the walk, write a short note: date done, statement period, opening and closing balances, items outstanding and actions taken. Attach the statement to the period folder.

Do this for each account every month. Over time the walk becomes quick, and months with no differences become common. That is the quiet reward of a ledger you can trust.

When the bank and the app disagree on dates

A transaction that you entered on the 30th may appear on the statement dated the 2nd. If you walk the statement without allowing for this, the line looks missing at first. Allow a few days of tolerance on either side, and match on amount and description rather than date alone.

For recurring items such as subscriptions, the same amount appears each month, so be careful to match each month’s item to the right month, not simply to any line with the same figure.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports