Calculation guide
Opening balance is immediately available. Out-of-horizon entries are excluded and counted.
Weekly close = prior close + dated receipts − dated payments
Inputs
First day of week one
Enter the calendar date in the date field.
Opening cash
Example entry 1000 (in the selected currency).
Cash date
Enter the calendar date in the date field.
Cash receipts
Example entry 200 (in the selected currency).
Cash payments
Example entry 150 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| First day of week one | 2026-01-01 |
| Opening cash | 1,000 |
Dated cash movements
| Cash date | Cash receipts | Cash payments |
|---|---|---|
| 2026-01-01 | 200 | 100 |
| 2026-01-12 | 100 | 300 |
| Result | Value |
|---|---|
| Closing cash after thirteen weeks | 900 |
| Lowest opening or weekly closing balance | 900 |
| Entries outside forecast | 0 |
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 |
|---|---|---|---|---|---|
| First day of week one | 2026-01-01 | 2026-01-02 | Closing cash after thirteen weeks | 900 | 800 |
| Opening cash | 1,000 | 1,100 | Closing cash after thirteen weeks | 900 | 1,000 |
| Cash date (row 1) | 2026-01-01 | 2025-12-31 | Closing cash after thirteen weeks | 900 | 800 |
| Cash receipts (row 1) | 200 | 220 | Closing cash after thirteen weeks | 900 | 920 |
| Cash payments (row 1) | 100 | 110 | Closing cash after thirteen weeks | 900 | 890 |
