THE NUMBERS, EXPLAINED
How to use this calculator.
One bank account and one statement date. Reconciling items are independently verified; differences identify unresolved entries rather than an automatic posting.
Start with your inputs
Enter statement closing bank balance (currency), deposits in transit (currency), outstanding issued payments (currency), ledger cash balance (currency), unrecorded bank charges (currency), unrecorded bank credits (currency). Keep amounts in the units shown on each field. The example is a starting point, not a recommended value.
| Input | Example value |
|---|---|
| Statement closing bank balance (currency) | 5000 |
| Deposits in transit (currency) | 500 |
| Outstanding issued payments (currency) | 800 |
| Ledger cash balance (currency) | 4800 |
| Unrecorded bank charges (currency) | 100 |
| Unrecorded bank credits (currency) | 0 |
A worked example
With the example inputs above, adjusted bank balance (currency) is 4,700. Change the inputs to explore your own scenario.
| Result | Example answer |
|---|---|
| Adjusted bank balance (currency) | 4,700 |
| Adjusted ledger balance (currency) | 4,700 |
| Unreconciled difference (currency) | 0 |
How this is calculated
Adjusted bank balance (currency)
Add deposits in transit and deduct outstanding payments.
Adjusted ledger balance (currency)
Record known bank charges and credits in the cash ledger.
Unreconciled difference (currency)
Subtract adjusted ledger balance from adjusted bank balance.
Symbols and units
- a
- Statement closing bank balance (currency)
- b
- Deposits in transit (currency)
- c
- Outstanding issued payments (currency)
- d
- Ledger cash balance (currency)
- e
- Unrecorded bank charges (currency)
- f
- Unrecorded bank credits (currency)
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions and limits
One bank account and one statement date. Reconciling items are independently verified; differences identify unresolved entries rather than an automatic posting.
Calculations use the values you enter. Blank or invalid inputs show an error instead of silently substituting zero. Results are displayed to useful precision; calculations retain the underlying numeric precision.
Questions about this tool
What does the result tell me?
Adjusted bank balance (currency); Adjusted ledger balance (currency); Unreconciled difference (currency). The result applies to the method and inputs described above. Check the units and assumptions before using it in a decision.
Why might another calculator differ?
Differences in units, rounding, timing or model definitions can produce different answers. Compare the input definitions and the method, rather than only the final number. For this tool: One bank account and one statement date. Reconciling items are independently verified; differences identify unresolved entries rather than an automatic posting.
Are my inputs stored or sent to AI?
Calculations on this page happen in your browser. The separate AI question finder sends its submitted conversation to OpenAI; these calculator fields are not sent. Favourites and recent tool names are stored locally. A shared link contains the inputs you choose to include.
Further reading
OpenStax: Purpose and Preparation of a Bank Reconciliation ↗
Background reading; this does not imply endorsement or independent review of SumFizz.
Review status
Software example and browser checks are recorded in our quality report. No external expert review is claimed. Created with coding assistance; calculations run as ordinary browser code.
Read the quality report →