Calculation guide
Add deposits in transit and subtract outstanding payments on the bank side. Adjust the ledger for unrecorded bank credits and debits. A zero residual means both adjusted balances agree.
Inputs
Bank statement balance
Example entry 10000 (in the selected currency).
Deposits in transit
Example entry 1500 (in the selected currency).
Outstanding payments
Example entry 800 (in the selected currency).
Book balance
Example entry 10720 (in the selected currency).
Unbooked bank credits
Example entry 30 (in the selected currency).
Unbooked bank charges and debits
Example entry 50 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Bank statement balance | 10,000 |
| Deposits in transit | 1,500 |
| Outstanding payments | 800 |
| Book balance | 10,720 |
| Unbooked bank credits | 30 |
| Unbooked bank charges and debits | 50 |
| Result | Value |
|---|---|
| Unreconciled difference | 0 |
| Adjusted bank balance | 10,700 |
| Adjusted book balance | 10,700 |
Calculation steps
Unreconciled difference = (((Bank statement balance + Deposits in transit) − Outstanding payments) − ((Book balance + Unbooked bank credits) − Unbooked bank charges and debits))
(((10,000 + 1,500) − 800) − ((10,720 + 30) − 50)) = 0
Adjusted bank balance = ((Bank statement balance + Deposits in transit) − Outstanding payments)
((10,000 + 1,500) − 800) = 10,700
Adjusted book balance = ((Book balance + Unbooked bank credits) − Unbooked bank charges and debits)
((10,720 + 30) − 50) = 10,700
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Bank statement balance | 10,000 | 11,000 | Unreconciled difference | 0 | 1,000 |
| Deposits in transit | 1,500 | 1,650 | Unreconciled difference | 0 | 150 |
| Outstanding payments | 800 | 880 | Unreconciled difference | 0 | -80 |
| Book balance | 10,720 | 11,792 | Unreconciled difference | 0 | -1,072 |
| Unbooked bank credits | 30 | 33 | Unreconciled difference | 0 | -3 |
| Unbooked bank charges and debits | 50 | 55 | Unreconciled difference | 0 | 5 |
