Calculation guide
Full rollover, including overspending. Enter reimbursements only if they return to this envelope.
roll = start+add-spent+refund; available = roll+next
Inputs
Opening balance
Example entry 80 (in the selected currency).
This month’s allocation
Example entry 450 (in the selected currency).
Spending
Example entry 400 (in the selected currency).
Refunds
Example entry 20 (in the selected currency).
Next month’s allocation
Example entry 450 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Opening balance | 80 |
| This month’s allocation | 450 |
| Spending | 400 |
| Refunds | 20 |
| Next month’s allocation | 450 |
| Result | Value |
|---|---|
| Balance carried forward | 150 |
| Next month’s available budget | 600 |
Calculation steps
Balance carried forward = (((Opening balance + This month’s allocation) − Spending) + Refunds)
(((80 + 450) − 400) + 20) = 150
Next month’s available budget = (Balance carried forward + Next month’s allocation)
(150 + 450) = 600
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 balance | 80 | 88 | Balance carried forward | 150 | 158 |
| This month’s allocation | 450 | 495 | Balance carried forward | 150 | 195 |
| Spending | 400 | 440 | Balance carried forward | 150 | 110 |
| Refunds | 20 | 22 | Balance carried forward | 150 | 152 |
| Next month’s allocation | 450 | 495 | Next month’s available budget | 600 | 645 |
