Skip to main content
Early accessBeta, invite only since 1 Nov 2026. A person reads every application.Apply for an invite
Demystify OS

How do I do a bank reconciliation for my small business, step by step?

Take the bank statement and your books for the same period, check each opening balance against last month's closing, and tick off every matching line, allowing for clearing dates. List what is in the books but not yet in the bank, and the reverse. After those timing differences, the two balances should agree. Anything left is an error to find.

Who asks this: An accounts person, owner or bookkeeper at a small Indian business who has never been shown how to reconcile the bank, or who does it every month and still ends with a difference nobody can explain.

The steps

  1. 1. Collect the same period from both sides

    Download the bank statement for the month and print or export the bank ledger from your books for the same dates. If you have more than one account, do each separately. The person doing this should not be the one who authorises payments, so one person cannot hide an error.

  2. 2. Check the opening balances first

    The statement's opening balance should equal last month's statement closing balance, and the opening balance in your books should equal last month's closing balance in the books. The two will differ from each other by last month's outstanding items, and that is normal: those items carry forward onto this month's list. If either opening balance is not last month's closing, an old entry was changed or last month was not finished, and nothing this month will agree until that is fixed. Do not carry an old difference forward silently.

  3. 3. Tick off matching lines

    Go down the statement and the ledger together and mark each line that appears in both, matching on amount and reference. The dates may differ: a cheque recorded on 31 October can clear on 2 November, and a deposit can reach the bank a day or two after it is booked. Clear last month's carried-forward items first, as they appear on this statement. Use two colours, one for each side. Most of the work is this step, and a good reference on each payment makes it quick.

  4. 4. List what is in the books but not in the bank

    These are timing items: cheques you issued that the supplier has not yet banked, and deposits you made that the bank has not yet cleared, including any carried from last month that are still open. Write each with its date and amount. They explain a difference without being an error, but a cheque that stays uncleared for months needs attention.

  5. 5. List what is in the bank but not in the books

    These are items you have not recorded: bank charges, interest, direct credits from customers, standing instructions and loan instalments. Pass these to your accountant to post. They are real, so the books change, not the bank.

  6. 6. Work out the adjusted balance and the difference

    Start from the bank balance, add deposits not yet cleared and subtract cheques not yet presented. Compare this with the books balance after posting the unrecorded items. The two should be equal. If a difference remains, check for a transposed digit, a double entry or a wrong date.

  7. 7. Sign it off and keep it

    Write the date, the name of the person who did it and the name of the person who reviewed it on the reconciliation. File it with the statement. A reconciliation that no one reviews is only half a control.

A worked example

illustrative

A coaching institute in Pune finds its books show four lakh seventy-six thousand rupees in the bank on 31 October, while the statement shows four lakh ninety-one thousand. Ticking off lines reveals two cheques of eighteen thousand and nine thousand not yet banked, a deposit of eleven thousand recorded but cleared on 2 November, and bank charges of one thousand never posted. Statement balance plus the eleven thousand deposit, less the twenty-seven thousand of cheques, is four lakh seventy-five thousand. Books balance less the one thousand of charges is also four lakh seventy-five thousand.

What goes wrong

  • The opening balances are not checked against last month's closing, and last month's outstanding items are lost, so an old difference follows every month.
  • The same person records and reconciles payments, so an error or a fraud stays hidden.
  • Uncleared cheques are ignored for months and the supplier never gets paid.
  • A difference is forced to zero with a plug entry rather than traced.
  • Bank charges, interest and loan instalments are not posted, so the books are always a little wrong.
  • The reconciliation is done once a quarter, when too many items have accumulated to trace.

How Demystify OS helps

  • Close the counter honestlyAvailable

    Shows the day's takings by cash, UPI and other tenders closing in one report, which is the sales side that the bank credits are checked against.

  • Weekly summaryEarly access

    A weekly summary of open items gives a regular place to list reconciling items that are still unexplained.

  • Mysty WorkersEarly access

    Mysty Workers can be set up with you to read the statement and the bank ledger you export, pair the lines, list the unmatched ones with a likely cause and ask one question per item. A reconciliation routine is not yet a standard catalogue entry.

What it does not do. Demystify OS does not log in to your bank, post adjusting entries or sign off a reconciliation; it prepares the match from files you share and your accountant approves what goes into the books.

Questions people ask

How often should a small business reconcile its bank?

Monthly at the least, and weekly if you have many transactions. A small number of items is quick to trace, while a quarter of them is a long evening. A routine on a fixed day each month is the easiest to keep.

What if the difference will not go to zero?

Look for a transposed digit, a payment entered twice, a wrong date or a missing item. Divide the difference by nine; if it divides evenly, a transposition is likely. If you cannot find it, ask your accountant rather than adding a plug entry.

Does reconciliation need accounting software?

No. A spreadsheet with the statement on one side and the ledger on the other works for a small business. Software helps when there are many lines, because matching is repetitive, but the thinking is the same.

What is a cheque that has not been presented?

It is a cheque you issued and recorded, which the supplier has not yet deposited. The bank shows the money still there. It is a timing difference, but follow up if it stays out for weeks, and ask your accountant about cheques that become stale.

Who should review the reconciliation?

Someone other than the person who prepared it, ideally the owner or a manager. They need not redo it; they need to look at the unexplained items and the old uncleared cheques and sign that they have done so.

Apply for the beta.

Demystify OS is invite only, and a person reads every application.

Apply for the beta