CashfulnessCashfulness
Download Cashfulness
Lesson 7

Bank reconciliation: Anna's $18 and how to explain a difference

27 October 202620 min

In short

Bank reconciliation is the line-by-line comparison between the transactions you've recorded and your bank statement. You tick the transactions that appear in both; every difference left over must have a name: an omitted transaction, a duplicate, a wrong amount, a different date or an unrecognised transaction. Mistakes are corrected with a real entry; identified timing differences are ticked the following month.

This page accompanies lesson 7 of the free video course "Double-entry bookkeeping, step by step". The amounts are examples: they come from the story of Anna's family, which we follow throughout the course, and they're the same ones you see in the video.

Watch the lesson

The lesson is about ten minutes long. Below you'll find Anna's ticking with her three numbers, the two correcting entries, what changes in her March, the five names of a difference and, at the end, the March statement to tick yourself, with the solution, and the transcript.

Eighteen dollars that don't add up

Early April. Anna has her March bank statement in front of her: the document where the bank lists the month's transactions. She takes her own books and ticks, one line at a time, everything she also finds on the statement.

Going by the ticked lines, she should get to $6,370. The bank says $6,352. She's $18 short.

You don't adjust a difference: you explain it

You don't adjust those $18. You explain them. That's bank reconciliation. You put your books next to the statement and look for the reason your balance doesn't match the bank's.

You don't tweak the numbers to make them fit. You find the missing fact, give it a name and record it.

What you need from the statement

Anna reconciles once a month, when the statement arrives: there are only a few lines, and they're still fresh in her mind. She needs three things from the statement.

From the March statementValue
Opening balance on 1 March$5,000.00
The list of the month's transactions
Closing balance on 31 March$6,352.00

The opening balance matters: you always start from a number that's already been checked. The $5,000 is the same number Anna's books started from on 1 March, the checking account's opening balance from lesson 6.

Ticking, one line at a time

Then comes the ticking. Anna puts her transactions next to the bank's and ticks the ones she finds on both sides.

March · the ticked transactions on the checking account

TransactionAmount
Anna's salary+$2,000.00
Luca's salary+$1,500.00
Ticked money in+$3,500.00
Luca's gym−$80.00
Supermarket, nine purchases−$720.00
Mortgage payment−$650.00
Car loan payment−$300.00
Electricity and gas−$120.00
Fuel and bus pass−$160.00
Pizza nights and coffee shop−$100.00
Ticked money out−$2,130.00

Start from $5,000, add $3,500, take away $2,130: $6,370.

The lines here are grouped for readability: on a real statement every purchase is its own line, and March's groceries come in nine purchases. At the bottom of the page you'll find the statement line by line.

The third number

Here Anna notices something. On her checking account's page, the balance isn't $6,370: it's $6,280. There's a gap of $90.

It's the water bill, paid by bank transfer on the evening of 31 March. Anna recorded it that day. The bank only processes it on 1 April: that's when it actually goes through the account. It isn't on the March statement.

So there are three numbers, not two.

On 31 MarchAmountWhat it is
In Anna's books$6,280.00the checking account balance, water bill transfer included
Ticked$6,370.00the opening balance plus the transactions also found on the statement
Bank statement$6,352.00the closing balance the bank gives

Between the first and the second there's $90: the bank transfer. Between the second and the third there's $18, and those don't have a name yet.

Mistake or timing?

The bank transfer isn't a mistake: it's a timing difference. And above all, it's identified. Anna knows what it is, how much it is, and when it will turn up.

That's why she leaves it unticked: she'll find it on the April statement and tick it there.

MistakeTiming difference
What it isa fact recorded wrongly, or not recorded at alla fact recorded correctly, which the bank records on a different day
What you docorrect it with a real entryleave it unticked and tick it the following month
In Anna's storythe $18, still to be foundthe water bill transfer, $90

The $18 get a name

So Anna works the other way round: she looks for lines on the statement that aren't in her books. She finds two, on 31 March.

On the statement, not in Anna's booksAmount
31 March · Monthly account fee−$12.00
31 March · Debit card fee−$6.00
Total−$18.00

The monthly account fee, $12, is what the bank charges every month to keep the account open. The debit card fee is $6. That makes $18. Anna hadn't recorded them.

Two real entries

She puts it right with two real entries, one for each fee, dated 31 March.

31 March · R1, monthly account fee

AccountDebitCredit
Bank fees (expense, goes up)$12.00
Checking account (asset, goes down)$12.00
Total$12.00$12.00

31 March · R2, debit card fee

AccountDebitCredit
Bank fees (expense, goes up)$6.00
Checking account (asset, goes down)$6.00
Total$6.00$6.00

Two lines each, and the Debit side matches the Credit side: $18 in Debit, $18 in Credit.

The sign and the rule

Why exactly like this? Bank fees is an expense account, and expenses grow on the Debit side. The checking account is an asset, and an asset written on the Credit side goes down.

Account typeIncreases inDecreases inIn Anna's correction
AssetsDebitCreditChecking account, $18.00 in Credit: goes down
LiabilitiesCreditDebit
EquityCreditDebit
IncomeCreditDebit
ExpensesDebitCreditBank fees, $18.00 in Debit: goes up

Anna's checking account doesn't pay her any interest: through the lens of lesson 5 it's an Assets− item, something that doesn't earn her anything. For bookkeeping it's still an asset, and the rule is the one for assets.

In Cashfulness, the app I built to keep household accounts in double entry, the Debit line carries a plus sign and the Credit line a minus. That's a convention of the app. Whether the account goes up or down, though, depends on the type of account, not on the sign.

Reconciled doesn't mean equal

After the two entries the ticked total reaches $6,352, the same as the bank. Anna's checking account, in her books, goes from $6,280 to $6,262.

And here's the point: $6,262 is not the bank's number. There are still $90 between them, and they have a name: the water bill transfer. The account is reconciled all the same.

Reconciliation statement on 31 March

ItemAmount
Statement balance$6,352.00
Water bill transfer, processed by the bank on 1 April−$90.00
Balance in Anna's books$6,262.00

No line with a question mark: every dollar of the gap has its name.

Anna's March, revised

The correction doesn't only touch the account. The two fees are March expenses, and they go through the income statement.

On 31 MarchAs recordedAfter reconciliationDifference
Checking account$6,280.00$6,262.00−$18.00
March expenses$1,500.00$1,518.00+$18.00
March profit$2,000.00$1,982.00−$18.00
Net worth$99,200.00$99,182.00−$18.00

The month's profit, meaning what's left of income after expenses, goes down from $2,000 to $1,982: income stays at $3,500. Net worth, meaning what the family owns minus what it owes, goes down by $18: assets go from $234,480 to $234,462, liabilities stay at $135,280.

Eighteen dollars isn't much. But the fees come back every month.

What balancing can't see

In lesson 1 we saw that balancing checks every entry, but it can't see a transaction you forgot. Anna's fees were exactly that. No entry was out of balance, because there was no entry at all. Only the comparison with the bank found them.

BalancingReconciliation
What it comparesDebit and Credit in every entryyour books and the bank statement
What it findswhat you've recorded wronglywhat you haven't recorded, or recorded differently from the bank

You can do it without double entry too

Reconciling isn't exclusive to double entry. With a spreadsheet, or with an app that only tracks spending, you'd find the $18 just the same.

The difference comes afterwards. With the spreadsheet, you usually just correct the balance and stop there. In double entry the correction carries its counterpart account with it, meaning the other account in the entry: Bank fees. So the explanation stays on record, and March's profit tells the story.

Just the balanceDouble entry
The correctionthe balance goes from 6,280 to 6,262the balance goes from 6,280 to 6,262
Where the explanation staysnowhereBank fees +$18.00, in March
March profitdoesn't noticegoes down to $1,982.00

Five names for a difference

Differences almost always have one of five names.

NameWhat it isIn Anna's story
Omissiona transaction missing from your booksthe two fees
Duplicatethe same transaction recorded twice by you, or charged twice by the bank
Wrong amounttwo digits swapped, a decimal point in the wrong place
Different datethe same transaction, on two different daysthe water bill transfer
Unrecognised transactiona line on the statement you can't explain

When you don't know what it is

Here the rule is strict. A difference you don't understand doesn't get left for the next statement: it stays open, and you look into it straight away. The only thing you wait for is a timing difference you've already identified.

And if you find a transaction on the statement that you don't recognise, you don't record it to make the numbers match. You report it to the bank, without waiting: it could be a mistake, or someone using your card.

Your turn

The $90 bank transfer that isn't on the March statement: is it a mistake to correct, or a timing difference?

Try to answer before you read on.

It's timing, and it's identified: Anna knows what it is and when it will arrive. It gets ticked in April. No new entry is needed: the bank transfer is already recorded.

But if the statement showed a charge that Anna didn't recognise, she wouldn't wait for April. She'd call the bank.

The line to take away

The right balance isn't the one that matches the bank. It's the one where you can explain every dollar.

How Cashfulness does it

In the lesson, Anna reconciles in Cashfulness from a single screen. The path below is the one on a computer.

  • Where to find it. In the Tools section of the sidebar there's Reconciliation: you choose the Checking account row.
  • The two figures from the statement. In Statement Date Anna picks 31 March, in Statement Amount she types 6,352. The app doesn't read the lines of the statement: it needs the date and the closing balance.
  • Automatic ticking. The Auto-Match button ticks every transaction up to that date, bank transfer included. The Reconciled balance is 6,280.00, the Difference 72.00, and the result says Not balanced. Below the button the app says there's still a difference and adds: "Untick the entries that are not on the statement, or record the ones that are missing."
  • Unticking what isn't there. Under Money out, Anna unticks "Water bill (bank transfer)": the reconciled balance goes up to 6,370.00 and the difference down to 18.00. The 72 dollars were the 90 of the bank transfer minus the 18 of the fees.
  • Recording what's missing. Once the two fees of 31 March are recorded, the reconciled balance is 6,352.00, the difference 0.00 and the result Balanced. Only now does the Reconcile button light up.
  • After Reconcile. On the Checking account page the reconciled lines have a green tick next to the date. Under each line you can read its counterpart account: for the two fees, Bank fees. The water bill transfer stays unticked: it's waiting for April. The account balance is 6,262.00 and net worth 99,182.00.

What is a general principle and what is a Cashfulness choice

General principles

  • Reconciliation compares your books with an outside source, the bank statement. You can do it with any tool, even a spreadsheet or an app that only tracks spending.
  • Every entry has at least two lines, and total Debit equals total Credit. Expenses grow in Debit, assets go down in Credit.
  • What double entry adds is that the correction carries its counterpart account with it, here Bank fees, and so its effect on the period's profit.
  • Reconciled doesn't mean equal to the bank: the gap that's left must have a name. You only wait for an identified timing difference; an unrecognised transaction gets reported to the bank.

Cashfulness choices

  • The sign of the line: plus for Debit and minus for Credit. It's a convention of the app: whether an account goes up or down depends on its type.
  • On the checking account, balancing is checked against the statement balance, and Auto-Match ticks every transaction up to the statement date: anything that isn't on the statement has to be unticked by hand.
  • The Assets+ and Assets− lens: does it earn you anything or not. Here Anna's checking account, which pays no interest, is Assets−.

Choices for whoever keeps the books

  • When to reconcile: Anna does it once a month, when the statement arrives.
  • What to call the account for the fees: here Bank fees. Double entry doesn't prescribe the name.

Transactions are grouped for readability in the body of the page; in the exercise at the end every transaction is its own line. The amounts are examples and serve to isolate the mechanism.

Frequently asked questions

Should my bank balance and my books show the same number after reconciling?

No. They should only differ by transactions that have a name. In Anna's example, after the correction the bank says $6,352 and her books $6,262: the gap is a $90 bank transfer made on the evening of 31 March and processed on 1 April.

If I can't find the cause of a difference, should I wait for next month's statement?

No. The only thing you wait for is a timing difference you've already identified, like a transfer sent at the end of the month. A difference you don't understand stays open and you look into it straight away: go through the ticking again and look for omissions, duplicates and amounts copied wrongly.

There's a charge on my statement I don't recognise: should I record it?

No, not to make the numbers match. Report it to your bank straight away. The rules and deadlines for disputing an unauthorised payment depend on your country and on how you paid, and some deadlines are short: don't wait for the next statement.

Transcript of the lesson

The text of lesson 7, word for word. The numbers are the same as in the video.

Early April. Anna has her March bank statement in front of her: the document where the bank lists the month's transactions. She takes her own books and ticks, one line at a time, everything she also finds on the statement. Going by the ticked lines, she should get to 6,370 dollars. The bank says 6,352. She's 18 dollars short.

You don't adjust those 18 dollars. You explain them. That's bank reconciliation. You put your books next to the statement and look for the reason your balance doesn't match the bank's. You don't tweak the numbers to make them fit. You find the missing fact, give it a name and record it. Now let's follow Anna as she looks for it.

Anna reconciles once a month, when the statement arrives: there are only a few lines, and they're still fresh in her mind. She needs three things from the statement. The opening balance: 5,000 dollars on the 1st of March, the same number her books started from. The closing balance: 6,352 dollars on the 31st of March. And in between, the list of transactions. The opening balance matters: you always start from a number that's already been checked.

Then comes the ticking. Anna puts her transactions next to the bank's and ticks the ones she finds on both sides. The two salaries, 3,500 dollars in all. Luca's gym, the groceries, the mortgage and car loan payments, electricity and gas, fuel and the bus pass, pizza nights and the coffee shop: 2,130 dollars going out. Start from 5,000, add 3,500, take away 2,130: 6,370.

Here Anna notices something. On her checking account's page, the balance isn't 6,370: it's 6,280. There's a gap of 90 dollars. It's the water bill, paid by bank transfer on the evening of the 31st of March. Anna recorded it that day. The bank only processes it on the 1st of April: that's when it actually goes through the account. It isn't on the March statement.

The bank transfer isn't a mistake: it's a timing difference. And above all, it's identified. Anna knows what it is, how much it is, and when it will turn up. That's why she leaves it unticked: she'll find it on the April statement and tick it there. That leaves the 18 dollars, and those don't have a name yet.

So Anna works the other way round: she looks for lines on the statement that aren't in her books. She finds two, on the 31st of March. The monthly account fee, 12 dollars: what the bank charges every month to keep the account open. And the debit card fee: 6 dollars. That makes 18. She hadn't recorded them.

She puts it right with two real entries, one for each fee, dated the 31st of March. Bank fees, 12 dollars on the Debit side. Checking account, 12 dollars on the Credit side. Then the same again for the 6 dollars. Two lines each, and the Debit side matches the Credit side.

Why exactly like this? Bank fees is an expense account, and expenses grow on the Debit side. The checking account is an asset, and an asset written on the Credit side goes down. In Cashfulness, the app I built to keep household accounts in double entry, the Debit line carries a plus sign and the Credit line a minus. That's a convention of the app. Whether the account goes up or down, though, depends on the type of account, not on the sign.

Now the ticked total reaches 6,352, the same as the bank. Anna's checking account, in her books, goes from 6,280 to 6,262. And here's the point: 6,262 is not the bank's number. There are still 90 dollars between them, and they have a name: the water bill transfer. The account is reconciled all the same.

The correction doesn't only touch the account. March expenses go up from 1,500 to 1,518 dollars. The month's profit, meaning what's left of income after expenses, goes down from 2,000 to 1,982. And net worth, meaning what the family owns minus what it owes, isn't 99,200 on the 31st of March: it's 99,182. Eighteen dollars isn't much. But the fees come back every month.

In the first lesson I told you that balancing checks every entry, but it can't see a transaction you forgot. Anna's fees were exactly that. No entry was out of balance, because there was no entry at all. Only the comparison with the bank found them.

Reconciling isn't exclusive to double entry. With a spreadsheet, or with an app that only tracks spending, you'd find the 18 dollars just the same. The difference comes afterwards. With the spreadsheet, you usually just correct the balance and stop there. Here the correction carries its counterpart account with it, meaning the other account in the entry: Bank fees. So the explanation stays on record, and March's profit tells the story.

Differences almost always have one of five names. Omission: a transaction that's missing, like the fees. Duplicate: the same transaction recorded twice by you, or charged twice by the bank. Wrong amount: two digits swapped, a decimal point in the wrong place. Different date: like the water bill transfer. And the unrecognised transaction: a line on the statement you can't explain.

Here the rule is strict. A difference you don't understand doesn't get left for the next statement: it stays open, and you look into it straight away. The only thing you wait for is a timing difference you've already identified. And if you find a transaction on the statement that you don't recognise, you don't record it to make the numbers match. You report it to the bank, without waiting: it could be a mistake, or someone using your card.

Here's where Anna ends up in Cashfulness. The checking account, the statement on the 31st of March, 6,352 dollars. The reconciled balance is the same, the difference is zero, and the screen says Balanced. Only one line is left unticked: the water bill transfer.

Now the gesture, on March as it was before the correction. Anna picks the statement date and types in the bank's balance. One button ticks every transaction up to that date for her, bank transfer included: the difference is 72 dollars. Anna unticks the water bill, and it drops to 18. The app spells it out for her: untick what isn't there, or record what's missing.

Once the two fees are recorded, the difference goes back to zero and the Reconcile button lights up. Anna presses it. On the account's page, next to the date of each checked transaction, a green tick appears. Under the fee's line you can read its counterpart account: Bank fees. The water bill transfer stays unticked. It's waiting for April.

A question for you. The 90-dollar bank transfer that isn't on the March statement: is it a mistake to correct, or a timing difference? Take a moment to think.

It's timing, and it's identified: Anna knows what it is and when it will arrive. It gets ticked in April. But if the statement showed a charge that Anna didn't recognise, she wouldn't wait for April. She'd call the bank.

In the end, the right balance isn't the one that matches the bank. It's the one where you can explain every dollar. On the checking account, every difference is a fact: a missing line, or a date. On an investment it isn't: the value changes even when not a single dollar comes in. How do you record that? We'll see with Anna's ETF, in the next lesson.

Meanwhile, the link to this lesson's page is in the description. Anna's March statement is there in a table, with the solution hidden. Try ticking it yourself before you look.

The previous lesson

Lesson 6 · What do you really own? The net worth survey, step by step. Anna doesn't need to rebuild ten years of receipts: she takes a snapshot of 1 March. Every item with a source and a date, the seven opening entries and a savings account found in April.

The next lesson

Lesson 8 · ETFs and unrealised gains: +$800 without cashing in a cent. On the checking account every difference is a fact, a missing line or a date. On an investment it isn't: on 30 April Anna's ETF is worth $800 more, but nothing has come into her account. Is she richer or not?

Tick it yourself: Anna's March statement

Below are the two March lists: the bank statement and the checking account in Anna's books. Tick the lines you find on both sides, then fill in the worksheet. The solution is hidden at the bottom: only look at it afterwards.

The bank statement, March

Opening balance on 1 March: $5,000.00.

DateDescription on the statementAmountTick
2 MarchAutomatic payment, gym−$80.00
2 MarchDebit card, supermarket−$32.00
3 MarchDebit card, bus pass−$45.00
5 MarchIncoming transfer, Anna's salary+$2,000.00
5 MarchIncoming transfer, Luca's salary+$1,500.00
6 MarchDebit card, supermarket−$85.00
7 MarchDebit card, fuel station−$60.00
8 MarchDebit card, pizzeria−$42.00
9 MarchDebit card, supermarket−$74.20
10 MarchMortgage payment−$650.00
12 MarchDebit card, coffee shop−$18.00
13 MarchDebit card, supermarket−$48.60
15 MarchCar loan payment−$300.00
16 MarchDebit card, supermarket−$91.30
18 MarchAutomatic payment, electricity−$65.00
20 MarchDebit card, supermarket−$66.90
21 MarchDebit card, fuel station−$55.00
22 MarchDebit card, pizzeria−$40.00
23 MarchDebit card, supermarket−$112.40
25 MarchAutomatic payment, gas−$55.00
27 MarchDebit card, supermarket−$58.70
30 MarchDebit card, supermarket−$150.90
31 MarchMonthly account fee−$12.00
31 MarchDebit card fee−$6.00

Closing balance on 31 March: $6,352.00.

Anna's books: the checking account, March

Balance on 1 March: $5,000.00.

DateDescriptionAmountTick
2 MarchLuca's gym−$80.00
2 MarchGrocery shopping−$32.00
3 MarchSofia's bus pass−$45.00
5 MarchAnna's salary+$2,000.00
5 MarchLuca's salary+$1,500.00
6 MarchBig grocery shop−$85.00
7 MarchFuel−$60.00
8 MarchPizza night−$42.00
9 MarchGrocery shopping−$74.20
10 MarchMortgage payment−$650.00
12 MarchCoffee shop−$18.00
13 MarchGrocery shopping−$48.60
15 MarchCar loan payment−$300.00
16 MarchGrocery shopping−$91.30
18 MarchElectricity bill−$65.00
20 MarchGrocery shopping−$66.90
21 MarchFuel−$55.00
22 MarchPizza night−$40.00
23 MarchGrocery shopping−$112.40
25 MarchGas bill−$55.00
27 MarchGrocery shopping−$58.70
30 MarchGrocery shopping−$150.90
31 March, eveningWater bill (bank transfer)−$90.00

Balance on 31 March: $6,280.00.

The descriptions are simplified: on a real statement they're often more cryptic, and recognising a line is part of the job.

The worksheet

ItemAmount
Statement opening balance$5,000.00
+ ticked money in
− ticked money out
= ticked balance
Statement closing balance$6,352.00
Difference to explain
Its name, line by line
Solution

The lines left unticked

WhereLineAmountName of the differenceWhat you do
Only on the statement31 March, monthly account fee−$12.00omissionrecord it: Bank fees in Debit, Checking account in Credit
Only on the statement31 March, debit card fee−$6.00omissionrecord it: Bank fees in Debit, Checking account in Credit
Only in Anna's books31 March evening, water bill (bank transfer)−$90.00different dateleave it unticked and tick it on the April statement

All the other lines get ticked: 22 on one side and 22 on the other.

The worksheet, filled in

ItemAmount
Statement opening balance$5,000.00
+ ticked money in$3,500.00
− ticked money out$2,130.00
= ticked balance$6,370.00
Statement closing balance$6,352.00
Difference to explain$18.00
Its name, line by linemonthly account fee $12.00 + debit card fee $6.00

After the two correcting entries, Anna's checking account goes down from $6,280.00 to $6,262.00. The reconciliation statement: $6,352.00 on the statement minus $90.00 of bank transfer not yet processed makes $6,262.00. Every dollar has a name.

A trap: the coffee shop on 12 March costs exactly $18.00, the same as the difference. But it's on both sides, so it gets ticked. A difference is explained by the lines that don't find their match, not by an amount that looks like it.

I built Cashfulness to keep household accounts in double entry. If you'd rather reconcile without redoing the ticking by hand, Reconciliation ticks the transactions up to the statement date, tells you how much is missing and when it's Balanced, and keeps the counterpart account of every correction on record.

Discover Cashfulness

Sources

  • Consumer Financial Protection Bureau, Regulation E, § 1005.6, Liability of consumer for unauthorized transfers (United States, electronic transfers and debit cards): an unauthorised transfer that appears on a periodic statement must be reported within 60 days of the statement being sent.
  • Consumer Financial Protection Bureau, Regulation Z, § 1026.13, Billing error resolution (United States, credit cards): an unauthorised charge is a billing error, to be notified within 60 days of the first statement that shows it.
  • The Payment Services Regulations 2017, regulation 74 (United Kingdom): an unauthorised or incorrectly executed payment must be notified without undue delay, and in any event no later than 13 months after the debit date.
  • The examples come from the story of Anna's family, built for the course "Double-entry bookkeeping, step by step": every entry is checked, with total Debit equal to total Credit.

Vittorio Giusti is an economist and psychologist, and he built Cashfulness.

— Vittorio Giusti