A simple cash flow forecast: 4 columns, 15 minutes a week
By Evandro Gonçalves · October 13, 2026 · 2 min read
A simple cash flow forecast has 4 columns: date, money in, money out and balance. You list what you expect to receive and pay over the next 4 weeks and update it once a week. If the balance turns negative on any date, you find out in advance and gain time to negotiate, collect or cut.
Where is your company losing money?
Answer the questions and instantly see your score and your main bottleneck. About 7 minutes, no sign-up to start. Full report with an action plan and a 30-minute debrief with Evandro: R$ 197.
Take the Alto Impacto DiagnosticBank statements show the past. A cash flow forecast shows the future.
Your bank statement tells you what already happened. By the time the balance shows negative there, it is late: the bill is due, payroll is coming, and there is little room to negotiate.
A cash flow forecast does the opposite: it shows the problem before it arrives. And running out of cash is not a detail. In Sebrae's 2020 business survival study in Brazil, 22% of owners who closed their business named lack of working capital as the main factor.
The 4 columns
| Date | Money in | Money out | Balance |
|---|---|---|---|
| Mar 1 | $18,000 | ||
| Mar 5 | $12,000 | $9,500 | $20,500 |
| Mar 10 | $4,000 | $22,000 | $2,500 |
| Mar 15 | $6,000 | $11,000 | −$2,500 |
| Mar 20 | $15,000 | $3,000 | $9,500 |
Illustrative numbers. Each balance is the previous balance + money in − money out. The March 15 line is the warning: you are $2,500 short in ten days.
How to fill it in
- Opening balance: what the business has in its accounts today.
- Money in on the date it actually lands, not the date of the sale. Card sales count on the settlement date; invoices on their due date.
- Money out on the due date: suppliers, payroll, taxes, rent, loan payments, the owner's pay.
- A 4-week horizon. Short enough to be accurate, long enough to give you time to act.
The 15-minute routine
Every week, on the same day:
- Check the real balance and correct the opening balance.
- Mark what actually came in and went out, and move anything that slipped.
- Add a new week at the end, always keeping 4 weeks ahead.
- Scan the balance column for the first negative number.
What to do when the balance goes negative
You have bought time. Use it in this order:
- Negotiate: asking a supplier for more time before the due date is far easier than after.
- Collect with discipline: chase overdue receivables first; only finance card or invoice receivables when you know what it costs.
- Cut or postpone: purchases and expenses that can wait a week.
When to level up
Once the routine is solid, extend the horizon to 13 weeks and split outflows by category. That is when the forecast stops being a defense and becomes a decision tool. In the Alto Impacto Method, it belongs to the Financial Management pillar.
Where is your company losing money?
Answer the questions and instantly see your score and your main bottleneck. About 7 minutes, no sign-up to start. Full report with an action plan and a 30-minute debrief with Evandro: R$ 197.
Take the Alto Impacto DiagnosticFrequently asked questions
Is a cash flow forecast the same as an income statement?
No. The income statement shows whether the business made a profit in the period, on an accrual basis. The cash flow forecast shows when money comes in and goes out. A business can be profitable on paper and still run out of cash.
Spreadsheet or software?
Start with a spreadsheet. What matters is the weekly routine. When the number of entries grows, move to software that pulls data from your bank.
How often should I update it?
Once a week, always on the same day. Twice a week when cash is tight.