Accounting Share · Cash flow & bookkeeping
Bank Reconciliation Calculator
Reconcile the bank statement and cash-book balances independently, then identify any remaining difference. Outstanding cheques reduce the bank-side balance.
The interactive calculator requires JavaScript. The formula and worked example below remain available.
01 / Enter your figures
Make the numbers yours.
Use one currency and consistent time periods. Amounts are shown in your input currency units; no currency conversion is performed.
02 / See the working
Your calculation
Enter your figures, then choose Calculate. Or load the worked example.
03 / Understand the method
Formula and method
Adjusted bank = Bank + Transit deposits − Outstanding cheques + Bank correction; Adjusted books = Books + Credits − Debits + Book correction
Reconcile the bank statement and cash-book balances independently, then identify any remaining difference. Outstanding cheques reduce the bank-side balance.
How to use this calculator
- Collect the figures for the same entity, currency and reporting period.
- Enter each input using its label and unit. For percentages, enter 15 to mean 15%.
- Choose Calculate, inspect the breakdown and compare the result with your assumptions.
- Change one input to explore a scenario. Recalculate after edits; display rounding does not round the underlying calculation.
Inputs at a glance
- Bank statement ending balance: May be positive, zero or negative; the sign changes its effect in the displayed formula.
- Deposits in transit: A nonnegative numeric input in the units specified by the label.
- Outstanding cheques: A nonnegative numeric input in the units specified by the label.
- Signed bank-error adjustment: May be positive, zero or negative; the sign changes its effect in the displayed formula.
- Cash-book ending balance: May be positive, zero or negative; the sign changes its effect in the displayed formula.
- Unrecorded bank credits: A nonnegative numeric input in the units specified by the label.
- Unrecorded bank debits and charges: A nonnegative numeric input in the units specified by the label.
- Signed book-error adjustment: May be positive, zero or negative; the sign changes its effect in the displayed formula.
Worked example
Follow one calculation.
- Bank statement ending balance
- 10000
- Deposits in transit
- 2000
- Outstanding cheques
- 1500
- Signed bank-error adjustment
- 0
- Cash-book ending balance
- 10800
- Unrecorded bank credits
- 0
- Unrecorded bank debits and charges
- 300
- Signed book-error adjustment
- 0
- Calculated result
- 10,500
The two adjusted balances reconcile.
Assumptions and interpretation
Signed error adjustments mean add a positive correction or subtract a negative one. Avoid counting the same bank charge or transaction twice.
The output is a model based on the figures entered. Check source records and use the accounting or contractual definitions relevant to your task before relying on a result.
Questions about this tool
What does the bank reconciliation calculation measure?
Reconcile the bank statement and cash-book balances independently, then identify any remaining difference. Outstanding cheques reduce the bank-side balance.
Which assumptions can change the result?
Signed error adjustments mean add a positive correction or subtract a negative one. Avoid counting the same bank charge or transaction twice.
Why can displayed totals differ slightly from my spreadsheet?
Calculations use the unrounded input values. Only the display is rounded. Use four or six decimal places to inspect small differences, and check the timing, sign conventions and rounding policy in your spreadsheet.
Reference and further learning
Financial accounting study reference. These original learning examples apply the displayed formula; the reference does not certify or endorse this calculator.
Look up an accounting term · Practise with accounting questions
Formula and worked example checked 4 November 2026. Calculations run in your browser without sending the entered figures to Accounting Share. Report a calculation issue with the tool name, example inputs and expected result; avoid sharing confidential records.
