Open calculator ↗

Restricted grant spending balance by period · Calculation guide

Track one grant’s spendable budget from opening balance through additions and eligible expenditures.

Calculation guide

A negative balance flags excess spending.

balance = opening + Σ(added − spent)

Inputs

Opening unspent restricted balance

Example entry 10000.0 (in the selected currency).

Additional restricted budget

Example entry 5000.0 (in the selected currency).

Eligible spending

Example entry 7000.0 (in the selected currency).

Worked example

InputValue
Opening unspent restricted balance10,000

Grant periods in order

Additional restricted budgetEligible spending
5,0007,000
2,0004,000
ResultValue
Closing restricted balance6,000

Interpreting the result

Use the running balance to identify the first period in which eligible spending consumes the restricted budget.

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Opening unspent restricted balance10,00011,000Closing restricted balance6,0007,000
Additional restricted budget (row 1)5,0005,500Closing restricted balance6,0006,500
Eligible spending (row 1)7,0007,700Closing restricted balance6,0005,300
Restricted grant spending balance by period →

Sources