Businesses do not close for lack of profit: they close because one Tuesday there is nothing to pay the payroll with. A cash flow forecast looks at the money going in and out, not at what has been invoiced. Thirteen weeks is one quarter — the horizon in which you can still react if you see the hole coming.
Open the cash flow calculatorThe formula
The forecast is built week by week, adding the net flow and subtracting one-off payments when they fall due:
Balance in week N = opening balance + (cash in − cash out) × N − one-off payments already due
The lowest balance of the quarter is the lowest value in that series, and the week it happens is the one to watch. The buffer needed is the gap between zero and that low point when it is negative: the money missing to stay out of overdraft.
It is a linear projection, not a surprise: it assumes you collect and pay roughly the same every week. It is enough to see the effect of one large payment and to decide whether you need financing before it arrives.
Worked example
A business with €3,000 in the bank, collecting €2,200 and paying €2,000 every week, facing a €5,000 payment in week 6.
| Week | Balance | What happens |
|---|---|---|
| 1 | €3,200.00 | normal flow (+€200) |
| 5 | €4,000.00 | last balance before the payment |
| 6 | −€800.00 | €5,000 payment |
| 9 | −€200.00 | still negative |
| 10 | €0.00 | back to zero |
| 13 | €600.00 | end of the quarter |
These are the calculator's default values and the numbers match what it shows on screen. Change your figures and the result updates instantly.
The summary: a low of −€800.00 in week 6, four weeks in the red and a buffer of €800.00. On normal flow the closing balance after thirteen weeks would be €600.00, so the payment does not endanger the quarter: it endangers four weeks of it. That is exactly the nuance an annual account never shows you.
When the projection breaks
With the same inflows and outflows, moving the one-off payment changes everything. If it falls in week 1, the low balance drops to −€1,800.00 and the weeks in the red go from four to nine. Without the payment, the quarter would close at €5,600.00 with no overdraft at all.
| Scenario | Lowest balance | Weeks in the red | Buffer needed |
|---|---|---|---|
| €5,000 payment in week 6 | −€800.00 | 4 | €800.00 |
| Same payment in week 1 | −€1,800.00 | 9 | €1,800.00 |
| No one-off payment | €3,200.00 | 0 | €0.00 |
| €2,000 weekly income, payment in week 6 | −€2,000.00 | 8 | €2,000.00 |
Two lessons: bringing a payment forward costs more than the payment itself, because it eats the weeks of margin; and a €200 drop in weekly income weighs more than many spending decisions.
What it leaves out
The calculator is honest about what it measures and what it does not:
- Seasonality. Inflows and outflows are spread evenly. If your business is seasonal, use the quarter's average and adjust by hand with the real milestones.
- Tax. Collected tax is not yours and paid tax is deductible. Mixing tax-inclusive amounts makes the cash position look roomier than it is: work with amounts before tax or with the real figures of each return.
- Late payers and bad debt. A customer paying at 60 days instead of 30 shows up as a payment that never arrives. That is precisely the scenario worth simulating before signing a large contract.
- Annual bonuses, insurance and settlements. Enter them as one-off payments, one by one, in the week they fall.
How to actually use it
The average flow tells you whether you need financing. To manage, do the opposite: take the real calendar for the next thirteen weeks, list the invoices you are going to issue with their likely collection date, the fixed payments with their dates and the one-offs. If the low point is negative, you have three levers, in this order:
- Bring collections forward: early-payment discounts, card or direct debit, reminders before the due date.
- Delay payments at no cost: agree new due dates with suppliers before they arrive, not after.
- Finance the gap: a credit line or a loan for the size of the buffer, not for more.
The five costliest mistakes
- Confusing cash with profit. A sale on 60-day terms is profit today and zero euros in the account until March.
- Looking only at the closing balance. The figure that matters is the low point and the week it lands.
- Leaving out one-off payments. They are what breaks the projection: tax, annual bonus, insurance, a special levy, a refurbishment.
- Projecting with twelve months of guaranteed income. Cash is calculated with what actually comes in, not with what should.
- Reacting in week 12. When the low point is three weeks away there is still room; in the week it crosses, all that is left is asking.
Frequently asked questions
Why thirteen weeks and not a year?
Because it is the horizon in which a decision still changes the outcome. A year is too long to correct and too short to be accurate; thirteen weeks match a quarter, which is how many taxes are settled and how payment plans are negotiated.
What is the difference between cash flow and profit?
Profit is what you earn according to the accounts; cash flow is the money in the bank. An issued invoice adds profit and adds no cash until it is collected. That is why a profitable business can run out of money.
What do I put in weekly cash in and cash out?
The average of the thirteen weeks you want to analyse: total expected collections divided by thirteen, and the same for payments. If one payment or one collection breaks that average, separate it as a one-off and place it in its week.
What if I have a large collection mid-quarter?
The calculator only models a one-off payment, so the way to approximate it is conservatively: leave the collection out of the average and calculate the worst case. If the balance survives the bad scenario, the good one will not surprise you.
Does it include tax?
Not specifically. The right approach is to project amounts before tax and add the quarter's tax settlement as a one-off payment when it falls, or to use the real amounts of each due date if you work on a cash basis.
What do I do if the low point is negative?
First, know how much: that is the buffer needed. Then decide the order of levers: bringing collections forward, delaying payments agreed in advance, or financing exactly that gap. What you should not do is wait to see it at the bank.
Is it only for freelancers?
It works for any business with money coming in and going out at different times. In a small company it is even more useful, because a single large payment can be the difference between carrying on and not.
Run your own numbers
Enter the cash balance, the average weekly inflows and outflows and the one-off payment that worries you. The calculator tells you the quarter's low point, the week it arrives and how much buffer you need. No sign-up and nothing sent to any server.
More calculators
- Savings goal calculator
- Discounts and sales calculator
- Break-even point calculator
- Calculadora de tesorería (en español)
Arithmetic on the amounts you enter: a linear projection with one one-off payment, without seasonality, taxes or late payments. It is not an accounting forecast or individual financial advice. Last reviewed: November 2026.