Bank reconciliation from outstanding items · Calculation guide

Reconcile bank and ledger balances at a single cutoff.

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.

difference = (bank+deposits-outstanding)-(ledger+credits-debits) · adjustedbank = bank+deposits-outstanding · adjustedbook = ledger+credits-debits

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

InputValue
Bank statement balance10,000
Deposits in transit1,500
Outstanding payments800
Book balance10,720
Unbooked bank credits30
Unbooked bank charges and debits50
ResultValue
Unreconciled difference0
Adjusted bank balance10,700
Adjusted book balance10,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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Bank statement balance10,00011,000Unreconciled difference01,000
Deposits in transit1,5001,650Unreconciled difference0150
Outstanding payments800880Unreconciled difference0-80
Book balance10,72011,792Unreconciled difference0-1,072
Unbooked bank credits3033Unreconciled difference0-3
Unbooked bank charges and debits5055Unreconciled difference05
Bank reconciliation from outstanding items →