Bank Reconciliation Calculator
Adjust the bank and book balances for outstanding items to confirm both adjusted balances match (difference = 0).
Input Data
Results
At a glance:Bank reconciliation aligns the cash book with the bank statement. Adjusted bank = bank statement + deposits in transit - outstanding checks. Adjusted book = book balance + interest earned - bank charges - NSF checks. The two adjusted balances should match (difference = 0). A non-zero difference means a missing item or error — investigate line by line. Reconcile monthly; good books also support Hong Kong profits-tax filing with the IRD.
Formula
Adjusted bank balance = bank statement balance + deposits in transit - outstanding checks.
Adjusted book balance = book balance + interest earned - bank charges - NSF checks.
Unreconciled difference = adjusted bank balance - adjusted book balance (should be 0).
$$$Bank_{adj}=Bank + DIT - OC$$$$$$Book_{adj}=Book + Interest - Charges - NSF$$$$$$Diff = Bank_{adj}-Book_{adj}$ ( 0)$$How to Use
- Enter the bank statement and book balances.
- Enter deposits in transit and outstanding checks (bank side).
- Enter interest, charges and NSF checks (book side).
- View the two adjusted balances and the difference.
FAQ
What are deposits in transit and outstanding checks?
Deposits in transit are recorded by the firm but not yet by the bank (added to the bank side). Outstanding checks are issued but not yet cleared (subtracted from the bank side). Both are timing differences, not errors.
Why does the difference matter?
If the two adjusted balances do not match, something is missing or wrong — a forgotten bank fee, unrecorded interest, a wrong amount, even fraud. The difference is the signal to investigate. A zero difference means the books and bank agree and the figure is the true cash available.
How do I find a non-zero difference?
Tick every item on the statement against the book and vice versa; check for omitted charges, interest, NSF checks; verify amounts and duplicates. Common culprits: bank fees, direct debits, timing of deposits/checks. The difference amount often points straight to the missing item (e.g. a -620 difference = a HK$620 fee not booked).
How often should I reconcile?
Monthly is standard for most firms; high-volume or weaker-control businesses should reconcile more often (weekly or even daily for key accounts). Regular reconciliation catches errors and fraud early and keeps cash visibility accurate.
Any Hong Kong compliance notes?
Proper books and records are required under the Inland Revenue Ordinance (a business must keep sufficient records for profits-tax assessment, generally 7 years). Bank reconciliation is a key internal control that supports accurate accounts and tax filing. Handle bank and customer data under the Personal Data (Privacy) Ordinance. This tool is for calculation; consult an accountant for filing.
Related Tools
References
Content review: Calculatorism Finance Team. Results are for reference only; please refer to the relevant authorities for the official figures.