Why 13 weeks
13 weeks is one quarter. It is short enough to plan payments by name and long enough to see a problem in advance and act. Unlike a monthly forecast, a weekly forecast shows "peak" days such as tax payments on the 15th and 20th of the month.
Step 1: opening balance
Add up the cash in all bank accounts and the cash desk. Set aside blocked or restricted funds.
Step 2: receipts
- Receivables: the expected payment week for each customer. Use the customer's actual payment habits, not the contract terms.
- New sales: sales plan × the customer's average payment period.
- Other: loans, capital increases, asset sales.
Step 3: payments
- Salaries and related taxes: insurance contributions by the 15th of the following month, income tax by the 20th.
- Suppliers: payables and new purchases, with their payment terms.
- Taxes: VAT, simplified tax, profit tax advance payments. Dates: tax calendar 2026.
- Fixed payments: rent, utilities, subscriptions.
- Loan payments and planned investments.
Step 4: balance and minimum level
Closing balance for the week = opening + receipts − payments
Next week's opening = previous week's closing balance
Set a minimum balance for the company, for example one week of fixed costs. Weeks when the balance falls below this level are highlighted in red: these are the weeks that need action.
Step 5: update every week
A forecast built once and forgotten is of little use. Every Monday, enter last week's actual figures, note the differences from plan with their reasons, and roll the forecast forward one week. After a few weeks the forecast becomes much more accurate.
Ready-made template with formulas: 13-week cash flow forecast (Excel). For an annual cash flow statement: cash flow statement template.