Money basics

What is reconciliation? Matching your records to the bank statement

What is reconciliation? Learn the three steps to match your own records with a bank statement, with a small made-up month and one missing UPI payment.

Editorial illustration for What is reconciliation? Matching your records to the bank statement

Reconciliation means checking that what you recorded matches what the bank recorded, and explaining every difference. In practice it takes three steps: confirm the opening balance, tick off each matching entry, then find the reason for whatever is left over. You can do it for a personal account in about fifteen minutes a month.

Why bother matching your records to a statement?

Your own notes miss things: a UPI payment made in a hurry, a bank charge, a refund that came back days later. The statement is the bank's record, so it is the reference. When the two agree you can trust your monthly totals; when they do not, you have found either a missing entry or a mistake worth catching early.

The three steps

  1. Opening balance: the balance at the start of the period on the statement should equal the closing balance you carried from last month. If not, fix that first, because every later figure inherits the error.
  2. Tick off matches: go through the statement line by line and mark the entry in your records that matches it, by date, amount and description. Do the reverse as well, marking anything in your records that the statement does not show.
  3. Explain the leftovers: every unmarked line on either side needs a reason. Add it, correct it, or note that it is pending.

A made-up month with one missing UPI entry

Say the statement for the month opens at ₹42,000. Credits: salary ₹60,000. Debits listed: rent ₹18,000, groceries ₹9,500, electricity ₹2,300, fuel ₹3,000 and a UPI payment of ₹1,500 to a plumber. The statement's debits add up to 18,000 + 9,500 + 2,300 + 3,000 + 1,500 = ₹34,300, so the closing balance is 42,000 + 60,000 − 34,300 = ₹67,700.

Your own records have everything except the plumber. Your debits are ₹32,800, so your calculated closing balance is 42,000 + 60,000 − 32,800 = ₹69,200. The difference is 69,200 − 67,700 = ₹1,500, which is exactly the missing UPI payment. Add it, and both sides read ₹67,700.

CheckStatementYour recordsGap
Opening balance₹42,000₹42,000₹0
Total credits₹60,000₹60,000₹0
Total debits₹34,300₹32,800₹1,500
Closing balance₹67,700₹69,200₹1,500

What usually causes a difference?

  • A missing entry, such as a UPI payment or an ATM withdrawal you did not log.
  • Timing: a cheque you wrote that has not cleared yet, or a card payment that posts a day or two later.
  • A duplicate you entered twice, or the same statement imported twice.
  • A bank charge or interest credit you never noticed.
  • Typing slips: a transposed pair of digits such as 1,950 recorded as 1,590 gives a gap of 360, and any such gap is divisible by 9, which is a handy clue.

Can the same idea work for cash?

Yes. Count the cash in your wallet or drawer, compare it with what your records say should be there, and write down the difference. A small gap you cannot explain is normal for cash; a growing one is a sign to log spends the day they happen.

Where a tracker helps with this

If you upload statements to SpendixAI as PDF, CSV or Excel, the rows are shown for review before they are saved, and possible duplicate imports are flagged, which removes two common causes of differences. Cash and anything not on the statement can be added by hand. It does not match entries against a bank for you, so the three steps above still apply.

Next step: pick last month, find the closing balance on the statement, and run the three steps once. Write down any difference you could not explain, so next month's check starts clean.

SPENDIXAI JOURNAL

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

Explore your reports