Free tool
Bank reconciliation calculator
Put your bank statement balance and your cash book balance side by side, adjust each for what the other hasn’t recorded yet, and see whether they agree.
Bank statement side
Cash book side
Reconciled: both sides agree.
Not reconciled yet: a difference of
Check for items recorded twice or not at all, swapped digits, or charges you haven’t recorded.
The figures filled in are an example. Replace them with your own.
How to use it
-
1
Enter both closing balances
The closing balance on your bank statement, and the bank balance in your own books on the same date.
-
2
List what only one side has
Deposits and payments you’ve recorded that the bank hasn’t shown yet; bank charges and interest the bank has that you haven’t recorded.
-
3
Check the difference
When the adjusted balances agree, you’re reconciled. Record any bank charges and interest in your books.
In Zivobooks: Bank reconciliation software · Bank statement converter
Bank reconciliation questions
Can’t find what you’re looking for? Ask us directly, and a person will answer.
What is a bank reconciliation?
Checking that the balance on your bank statement and the balance in your own books (the cash book) agree once you allow for items only one of them has recorded yet. Doing it every month catches missed payments, bank charges, duplicates and errors early.
What are deposits in transit and unpresented cheques?
Deposits in transit are money you have recorded as received that the bank hasn’t shown yet. Unpresented cheques and payments are amounts you have recorded as paid that haven’t left the account yet. Both are timing differences, so they adjust the bank statement balance.
Why don’t my balances agree?
Look for a payment or receipt recorded twice or not at all, an amount typed with two digits swapped (the difference then divides exactly by 9), a bank charge or interest you haven’t recorded, or a figure from the wrong date.
Is what I type saved?
No. The calculator works in your browser, and the amounts you enter are never sent to us.
Give your business the back office it deserves.
Try every feature free for 30 days. No card, no contract, and your data is always yours to export.
30 days free · Then from $5 a month · Cancel any time · Works on phone, tablet and computer