What the template includes
- Settings for the start date, opening balance and minimum balance.
- Week dates are built automatically.
- Receipts: customer payments, new sales, other.
- Payments: suppliers, salaries, taxes and insurance contributions, rent, loan, other.
- Net cash flow, opening and closing balance, warnings for weeks below the minimum.
How to use it
- Enter receivables by customer in the week you expect payment. Use the customer's actual payment habits, not the contract terms.
- Enter salaries, taxes and loan payments in their exact week. Insurance contributions are due by the 15th of the month, income tax and VAT by the 20th: tax calendar 2026.
- Plan actions for the red weeks: collecting debts, splitting payments, postponing purchases.
- Every Monday, enter the actual figures and roll the forecast forward one week.
Full explanation: how to build a cash flow forecast. To find the cause of a gap: cash gap calculator.