What this calculator does
Bank reconciliation works out reconciles your cash book balance against the bank statement balance. Enter your own figures above and the answer updates as you type: nothing is fixed in the code, so the result reflects exactly the numbers you supply.
The formula this calculator evaluates is printed under the tool and explained below, so you can check the working by hand or reuse it in a spreadsheet.
The formula
FormulaAdjusted bank balance = Statement balance + Deposits in transit − Outstanding cheques; Adjusted book balance = Book balance + Interest earned − Bank charges − NSF cheques
The inputs explained
| Field | What to enter |
|---|---|
| Bank statement balance ($) | A number, measured in your currency. Starts at 15420. |
| Deposits in transit ($) | A number, measured in your currency. Starts at 1200. |
| Outstanding cheques ($) | A number, measured in your currency. Starts at 850. |
| Cash book balance ($) | A number, measured in your currency. Starts at 15680. |
| Interest earned (per bank) ($) | A number, measured in your currency. Starts at 15. |
| Bank charges / fees ($) | A number, measured in your currency. Starts at 25. |
| NSF (bounced) cheques ($) | A number, measured in your currency. Starts at 0. |
Worked examples
Every figure in the tables below is produced by this page’s own calculator at build time, so the numbers and the tool always agree. Select any row to load that scenario.
How the answer changes with bank statement balance
Every other input is held at the calculator’s starting values while bank statement balance varies. Select any row to load that scenario into the calculator.
How the answer changes with bank statement balance
| Bank statement balance ($) | Adjusted bank balance | Adjusted book balance | Unreconciled difference |
|---|---|---|---|
| 7,710 | $8,060.00 | $15,670.00 | −$7,610.00 |
| 11,565 | $11,915.00 | $15,670.00 | −$3,755.00 |
| 15,420 | $15,770.00 | $15,670.00 | $100.00 |
| 23,130 | $23,480.00 | $15,670.00 | $7,810.00 |
| 30,840 | $31,190.00 | $15,670.00 | $15,520.00 |
| 46,260 | $46,610.00 | $15,670.00 | $30,940.00 |