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
| Input | Value |
|---|---|
| Opening unspent restricted balance | 10,000 |
Grant periods in order
| Additional restricted budget | Eligible spending |
|---|---|
| 5,000 | 7,000 |
| 2,000 | 4,000 |
| Result | Value |
|---|---|
| Closing restricted balance | 6,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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Opening unspent restricted balance | 10,000 | 11,000 | Closing restricted balance | 6,000 | 7,000 |
| Additional restricted budget (row 1) | 5,000 | 5,500 | Closing restricted balance | 6,000 | 6,500 |
| Eligible spending (row 1) | 7,000 | 7,700 | Closing restricted balance | 6,000 | 5,300 |
