Open calculator ↗

Thirteen-week cash forecast from dated receipts · Calculation guide

Group dated receipts and payments into 13 consecutive seven-day periods from the start date.

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

InputValue
First day of week one2026-01-01
Opening cash1,000

Dated cash movements

Cash dateCash receiptsCash payments
2026-01-01200100
2026-01-12100300
ResultValue
Closing cash after thirteen weeks900
Lowest opening or weekly closing balance900
Entries outside forecast0

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
First day of week one2026-01-012026-01-02Closing cash after thirteen weeks900800
Opening cash1,0001,100Closing cash after thirteen weeks9001,000
Cash date (row 1)2026-01-012025-12-31Closing cash after thirteen weeks900800
Cash receipts (row 1)200220Closing cash after thirteen weeks900920
Cash payments (row 1)100110Closing cash after thirteen weeks900890
Thirteen-week cash forecast from dated receipts →

Sources