ManyHand logoManyHand ← Account Book

Bank Reconciliation

Tick each line of your bank book as you find it on the bank's statement, and see what explains the difference between the two balances.

Home

Where things stand
This month
Income and expenses, month by month
IncomeExpenses
See the numbers
Where the money went
Latest entries

    Why the two balances differ

    Your book and the bank rarely show the same balance on the same day, even when both are right. A cheque you wrote last week may not have been presented yet. Cash paid in on Saturday may reach the statement on Monday. And the bank may have taken a charge, or added interest, that you have not entered. Reconciling means going through both until every difference has a reason.

    Reconciling here

    1. Get the bank's statement up to a recent date — on paper, as a PDF, or on the bank's own app.
    2. Open Reports and tap Check against a bank statement.
    3. Choose the bank account and the statement's last day.
    4. Tick each line of your book that you can see on the statement. A tick is kept: next month the list starts from what was left.
    5. Type the statement's closing balance.

    The sheet shows four figures as you go:

    FigureWhat it is
    Balance in your bookThe bank account's balance on that day, from your entries
    Money in the bank has not shown yetUnticked amounts received — taken off
    Money out the bank has not shown yetUnticked amounts paid — added back
    The statement should showThe three above, worked out

    When the balance you typed matches that last figure, the sheet says the statement agrees with your book. When it does not, it says by how much.

    A worked example

    Your book shows 43,000 in the bank. You have ticked everything except a cheque for 10,000 paid to a supplier and 5,000 of cash paid in yesterday. The statement should therefore show 43,000 − 5,000 + 10,000 = 48,000. If it does, you are done: the two items will appear on next month's statement.

    When the figures still differ

    Use Show only the lines not ticked yet to see just what is outstanding. Old unticked lines deserve a second look: a cheque nobody has presented for months, or a deposit the bank never credited.

    What this tool does not do

    It does not sign in to your bank, read a statement file, or match lines by itself: you tick them. Ticks can be made and removed at any time — even in a part of the book that has been closed, since a tick records what the bank has shown and changes no figure.

    Where the book is kept

    There is no account to make and nothing is sent anywhere: the whole book is kept in this browser, on this device. Books → Export everything saves all of it as one file, and Import from a file on another phone or computer opens it there — which is how the book moves, how it reaches your accountant, and how it is kept safe. Installing the page as an app (the Install app button at the top) lets it open from the home screen and work with no internet. The main guide covers setting up, tax, stock, closing a year and everything else.

    Questions
    What is bank reconciliation?

    It is checking your own record of a bank account against the bank's statement, line by line, until every difference between the two balances is explained — usually by payments and deposits the bank has not processed yet, or charges you have not entered.

    Do I have to give my bank login?

    No. The tool never connects to a bank. You look at your statement and tick the matching lines yourself.

    How often should I reconcile?

    Once a month, when the statement is complete, suits most small businesses. A business with many bank payments may prefer every week.

    Are my ticks saved?

    Yes. A tick stays on its line, so each month you only deal with new lines and whatever was outstanding last time. If you change an entry's amount, its tick is removed, because it no longer matches what the bank showed.

    Can I reconcile more than one bank account?

    Yes. Add each bank account under Books, and choose which one to check at the top of the sheet.

    More about the Account Book

    More tools: Shop Billing Counter · GST Calculator · Job Quote & Bill Maker · Salary Slip Maker

    Install the appIt takes three taps, and nothing comes from an app store.

    Installed, it opens in a window of its own with your business's name at the top, starts at once and works with no internet. Your book stays on this device.

    How this goes into the accounts

    Opening balancesWhat the business had and owed at the start of the day the book begins.

    Check the bankTick each line you can see on the bank's statement.