13-week cash flow forecast template (Excel)
Working on this yourself? Talk to Mark, our co-founder. We’re here to solve it with you.
Excel (.xlsx), 13 weeks, example data in euros
Free, no sign-up, no email address.
How to use the template
Enter the Monday of the first week in the start date cell. The template fills in the dates of the other twelve weeks. Then enter the opening bank balance: the balance of all your business accounts together on that Monday morning.
Fill in the receipts per week. Start with your open sales invoices, placed in the week you expect each customer to pay, which is not always the due date. Use your DSO or each customer's history to judge it. Add expected new revenue, other receipts and a VAT refund if you expect one.
Then fill in the payments: salaries and payroll taxes on their fixed dates, rent, supplier invoices in the week you plan to pay them, the VAT return, loan repayments and interest, and other costs. The blue cells are inputs, the rest are formulas.
Credit line and buffer
Enter your overdraft or credit line and the minimum balance you want to keep. The template shows the room you have left each week, closing cash plus the credit line, and highlights every week in which closing cash falls below your buffer. Those are the weeks to act on now: chase a large invoice, move a payment or talk to your bank.
Common mistakes
Most forecasts go wrong in the same places. Customers are assumed to pay on the due date, while many pay one or two weeks later. Payments that come back once a quarter or once a year, such as insurance, annual software licences or the corporate income tax, are forgotten. And the forecast is made once and then left alone, so after a month it says nothing anymore.
Keep it rolling
A forecast is only useful when it is current. Update it every week: replace the forecast of the week that has passed with the actual figures, compare them, and add a new week at the end. The differences teach you where your forecast is too optimistic, usually in when customers pay.
Thirteen weeks is long enough to see a problem coming and short enough to forecast from real invoices and commitments. For the months behind you, use the cash flow statement template.
Frequently asked questions
Why 13 weeks?
Thirteen weeks is one quarter. It is short enough to forecast from invoices and commitments you already know, and long enough to spot a cash shortfall while you can still do something about it. Banks and restructuring advisers use the same horizon.
Do I include VAT?
Yes. Cash moves including VAT, so enter receipts and payments including VAT, and the VAT return as a separate payment or refund.
How often should I update the forecast?
Every week. Replace the past week with actual figures and add a new week at the end, so the forecast always looks thirteen weeks ahead.
Is the template free?
Yes. No sign-up and no email address. Download it and use it as you like.
More free tools
- Month-end close checklist
- DSO calculator
- Dutch statutory interest and collection costs calculator
- Liquidity and solvency ratio calculator
- UK late payment interest calculator
- Cash flow statement template (Excel)
- Management report template (Excel)
- Month-end close checklist (Excel template)
- UK management accounts template (Excel)
Where Thred comes in
Finance agents running on top of your existing ledger. You set the rules, approve the work and handle the exceptions. No migration.
