The 13-week cash flow forecast for small companies, and how to keep it current
A 13-week cash flow forecast shows, week by week, whether you will have enough cash for the next quarter. Here is how to build one in an afternoon and keep it honest.
Mark Holleman7 min read
Working on this yourself? Talk to Mark, our co-founder. We’re here to solve it with you.
On this page
A 13-week cash flow forecast is a week-by-week table of the cash you expect to receive and pay over the next quarter, starting from today's bank balance. It answers one question that your profit and loss cannot: will there be enough money in the account every single week?
If you run a growing company, you probably check the bank balance more often than you would like to admit. The balance tells you where you are today. It says nothing about the Friday in six weeks when payroll, the VAT payment and a large supplier invoice land in the same few days.
That is the gap a 13-week forecast fills. It is not a budget and not a financial model. It is a short, practical tool that you update every week and actually use to make decisions.
Why 13 weeks?
Thirteen weeks is one quarter. That is long enough to see the big payments coming, such as a quarterly VAT return, the holiday allowance in May or a loan repayment, and short enough that you can predict most of the numbers with reasonable confidence.
Weekly granularity matters more than the horizon. A monthly cash forecast can look fine while hiding a week in the middle where you go below zero. Salaries go out on one day, customers pay on others, and monthly totals average that away.
How is a 13-week cash flow forecast structured?
Every week in the forecast has the same five lines.
- Opening balance. The closing balance of the previous week. For week one, your actual bank balance today, across all business accounts.
- Receipts. Money you expect to come in that week.
- Payments. Money you expect to go out that week.
- Closing balance. Opening balance plus receipts minus payments.
- Minimum buffer. The lowest balance you are comfortable with. Any week below it is a warning.
Receipts and payments are split into a handful of rows. For most small companies that is enough.
- Customer receipts, ideally split into your largest customers and the rest
- Other receipts, such as a VAT refund, a grant or a loan drawdown
- Net salaries
- Wage tax and social contributions
- VAT payments
- Rent and other fixed costs
- Supplier payments
- Loan repayments and interest
- One-offs, such as equipment, a bonus or a deposit
This is the direct method, where you forecast the actual cash movements. Accountants also use an indirect method that starts from profit and adjusts for non-cash items. For a weekly view of a small company, the direct method is simpler and easier to trust.
How do you build one, step by step?
You can build the first version in an afternoon with a spreadsheet and access to your ledger.
Start from the bank, not the books
Take the actual balance of every business bank account this morning. Not the ledger balance, which may be behind. The forecast is about money you can spend, so it starts with money you have.
Forecast receipts from your open invoices
List every open sales invoice with its amount and due date. Then do the most important adjustment in the whole forecast: move each invoice to the week you actually expect the money, not the week it is due. If a customer always pays ten days late, put their invoice ten days after the due date. Your payment history tells you who those customers are.
Then add sales you have not invoiced yet but expect to, such as recurring contracts and projects close to delivery. Be conservative here. Revenue you hope for is not cash.
Forecast payments from what you already know
Most payments are more predictable than receipts. Salaries, rent, leases and subscriptions are fixed. Supplier payments follow from your open purchase invoices and their due dates, plus an estimate for invoices still to come.
Then add the tax dates. In the Netherlands, a quarterly VAT return is usually due, and paid, by the end of the month after the quarter. Wage tax for a monthly payroll is generally due by the end of the following month. Holiday allowance, by law generally at least 8% of gross salary, is usually paid in May or June. These amounts are large and easy to forget. Check the exact dates and amounts that apply to your company with your accountant or payroll provider.
Set your buffer
Decide the lowest balance you want to see in any week. A common starting point is one month of fixed costs, so you can absorb a late customer without panic. The exact number is a judgement call. What matters is that you write it down.
What does a 13-week forecast look like in practice?
Here is an illustrative forecast for a 25-person services company, starting the week of 6 April with €61,000 in the bank and a minimum buffer of €40,000.
Most weeks look comfortable. Two weeks do the damage.
In the week of 27 April, the company pays the Q1 VAT return of €17,600, wage tax of €11,500, rent of €6,500 and €8,600 to suppliers.
- Opening balance €58,100
- Receipts €26,500
- Payments €44,200
- Closing balance €40,400, just above the buffer
In the week of 18 May, net salaries and the holiday allowance go out together.
- Opening balance €63,800
- Receipts €20,000
- Payments €66,800, made up of €42,000 net salaries, €16,000 holiday allowance and €8,800 suppliers
- Closing balance €17,000, well below the buffer
Over the full quarter, receipts are €292,000 and payments are €325,000, so the balance drops from €61,000 to €28,000. The business is not in trouble. It simply has a quarter in which seasonal payments outweigh what comes in.
The point is that the owner sees this in April, not in the third week of May. With seven weeks of notice there are good options: invoice a project milestone earlier, ask two slow customers to pay on time, move a planned equipment purchase to July, or arrange a short credit line before you need it. In the week itself, the only option left is a stressful phone call.
How do you keep the forecast current?
A forecast that is updated once is a document. A forecast that is updated every week is a tool. The routine takes about thirty minutes if your books are up to date.
- Replace the oldest week with actuals. Put in the real receipts, payments and closing balance for the week that just ended.
- Compare forecast with actual. Look at the two or three biggest differences and ask why. A customer paid late, a supplier invoice was bigger than expected, a payment you forgot.
- Add a new week at the end. The forecast always looks thirteen weeks ahead.
- Update receipts and payments from the latest open invoices, new orders and anything you learned this week.
- Check the buffer. If a week drops below it, decide what you will do now, while you still have options.
Step two is where the forecast gets better over time. If you are always too optimistic about one customer, change the assumption. If supplier payments are always higher than forecast, there are probably invoices arriving that you do not see in time.
Why do cash forecasts go stale?
Almost always because the inputs are behind. A forecast is only as current as the books it is built from. If sales invoices are booked weekly and purchase invoices sit in someone's inbox for two weeks, your receipts and payments are both wrong before you start.
The second reason is effort. Rebuilding the forecast by hand every Monday is the kind of task that slides the moment the week gets busy, which is exactly the week you need it most.
How does AI change cash forecasting?
Both causes are things software can now take away, and the work it takes over is specific.
- Predicting when customers actually pay. An agent learns each customer's payment behaviour from your bank history and moves their open invoices to the week the money will most likely arrive, instead of trusting the due date.
- Seeing payments before they are booked. Supplier invoices still waiting in a mailbox or for approval already belong in next month's payments. An agent that reads them on arrival puts them in the forecast straight away.
- Keeping the calendar of fixed payments. Salaries, rent, loan instalments, VAT and wage tax follow patterns in the ledger. The agent carries them forward, including the holiday allowance in May, so nobody has to remember them.
- Explaining the variance. Every Monday it compares last week's forecast with the bank and tells you, in a sentence, why the two differ.
- Answering what-if questions. "What happens to the lowest week if we hire two people in June?" becomes a question you ask in plain language, not an afternoon in a spreadsheet.
What stays with you is the judgement. Which customer to call, whether to delay a purchase, when to talk to the bank.
At Thred, bank and payment transactions are matched and booked as they come in, so the forecast starts from a current ledger rather than last month's. You can ask for a forecast or a scenario in the chat, and the Treasurer agent watches cash and funding so a dip below your buffer surfaces weeks ahead instead of on the day.
If you are a founder who wants that kind of visibility without building a finance team, see how Thred works for businesses. If you are a finance lead who wants to keep your current ledger, Thred Layer runs on top of it.
Whichever way you build it, start this week. A rough forecast updated every Monday beats a perfect one you never open again.
Frequently asked questions
What is the difference between a cash flow forecast and a budget?
A budget plans income and costs for a year, usually by month and based on when they are earned or incurred. A cash flow forecast shows when money actually enters and leaves the bank. A profitable month can still be a month in which you run short of cash.
Should a 13-week cash flow forecast use the direct or indirect method?
For a small company, the direct method is usually the better choice. You forecast actual receipts and payments, such as customer payments, salaries and VAT, which are easy to check against the bank each week. The indirect method, which starts from profit, is more common in annual cash flow statements.
How much cash buffer should a small business keep?
A common starting point is one month of fixed costs, such as salaries, rent and loan payments. Businesses with seasonal income or a few large customers often keep more. The right level is a judgement call, but it should be written down so the forecast can flag any week that drops below it.
Which Dutch tax payments should be in a cash flow forecast?
At least VAT, wage tax and any provisional corporate or income tax assessments. Quarterly VAT is usually due by the end of the month after the quarter, and monthly wage tax by the end of the following month. Holiday allowance, typically paid in May or June, is not a tax but is a large payment to include. Confirm the dates for your company with your accountant.
How often should you update a cash flow forecast?
Weekly. Each week, replace the week that just ended with actual figures, compare them with what you forecast, add a new week at the end and update receipts and payments from the latest open invoices. The comparison is what makes the forecast more accurate over time.
Sources
Read next
- Cash flow forecasting for Xero: what Xero does, the add-ons, and how to keep a forecast current
- Thred vs Float: a Float alternative that keeps your cash view current from your Xero books
- Current ratio
- Days sales outstanding (DSO)
- Cash flow statement: the direct and indirect method explained, with a worked example
Where Thred comes in
For finance leaders who want more capacity without more headcount.



