Bank overdraft versus cash presentation reconciliation · Calculation guide

For cash-flow reconciliation include only bank overdrafts repayable on demand and integral to cash management.

Calculation guide

Enter balances already classified by these criteria. Balance-sheet cash is shown gross assuming no offset rights.

net = cash-eligible · debt = eligible+other · gross = cash

Inputs

Positive cash and cash equivalents

Example entry 50000 (in the selected currency).

Qualifying on-demand overdrafts

Example entry 10000 (in the selected currency).

Other bank overdrafts

Example entry 7000 (in the selected currency).

Worked example

InputValue
Positive cash and cash equivalents50,000
Qualifying on-demand overdrafts10,000
Other bank overdrafts7,000
ResultValue
Cash flow statement cash balance40,000
Total overdraft liabilities17,000
Gross balance-sheet cash50,000

Calculation steps

Cash flow statement cash balance = (Positive cash and cash equivalents − Qualifying on-demand overdrafts)

(50,000 − 10,000) = 40,000

Total overdraft liabilities = (Qualifying on-demand overdrafts + Other bank overdrafts)

(10,000 + 7,000) = 17,000

Gross balance-sheet cash = Positive cash and cash equivalents

50,000 = 50,000

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Positive cash and cash equivalents50,00055,000Cash flow statement cash balance40,00045,000
Qualifying on-demand overdrafts10,00011,000Cash flow statement cash balance40,00039,000
Other bank overdrafts7,0007,700Total overdraft liabilities17,00017,700
Bank overdraft versus cash presentation reconciliation →

Sources