Many profitable small businesses still run into trouble because cash runs out at the wrong moment: rent is due, but customers haven’t paid yet. A simple cash flow forecast shows you months ahead when money will be tight, so you can act early.
Download the free cash flow forecast template (.xlsx)

What is inside
| Section | What it does |
|---|---|
| Cash in | Cash sales, customer payments, loans or investment, other income |
| Cash out | Rent, salaries, stock, utilities, marketing, loan repayments, taxes/VAT, equipment |
| Monthly summary | Opening balance, net cash flow and closing balance for 12 months |
| Warnings | Months below your minimum balance turn red, and the lowest balance is shown at the top |
| Automatic months | Enter the first month once, and all 12 headers update |
The sample data shows a typical pattern: two quieter months (months 8 and 9) push the balance below the warning level. That’s exactly what a forecast is for.
How to use it
- Set up: enter the first month, your current bank balance and the minimum cash you want to keep.
- Forecast cash in: when do you expect customers to actually pay? Use your sales history as a guide.
- Forecast cash out: fixed costs (rent, salaries) first, then variable costs (stock, marketing), then one-off payments (VAT, equipment).
- Check the warnings: look for red months and the lowest balance.
- Update monthly: replace forecasts with actual figures and add a new month at the end.
How a 12-month cash flow forecast works
Every month follows the same simple sum:
Opening balance + cash in − cash out = closing balance
and this month’s closing balance becomes next month’s opening balance.
Example for a small café:
| Month | Opening | Cash in | Cash out | Closing |
|---|---|---|---|---|
| Month 1 | 5,000 | 12,000 | 11,000 | 6,000 |
| Month 2 | 6,000 | 10,500 | 11,200 | 5,300 |
| Month 3 (quiet) | 5,300 | 7,000 | 10,800 | 1,500 |
If the café set a minimum balance of 2,000, month 3 would turn red in the template, two months ahead, giving the owner time to cut costs, chase customer payments or arrange finance.
Cash flow forecast vs cash flow projection
The two terms are used for the same thing: an estimate of the money coming in and going out over the next months. Some people use “projection” for longer, what-if plans and “forecast” for the realistic short-term view. This template works for both: start with your realistic numbers, then copy the sheet to try a “bad month” scenario.
What to do if cash looks tight
- Get paid faster: send invoices immediately, ask for deposits, and offer easy payment links.
- Chase overdue invoices every week.
- Time big purchases for stronger months.
- Negotiate longer payment terms with suppliers.
- Talk to your bank early about a credit line, before you need it.
Profit vs cash flow
Profit is sales minus costs over a period. Cash flow is when money actually enters and leaves your bank. A business can be profitable on paper and still run out of cash if customers pay late. That’s why you need both. Learn the basics in bookkeeping basics for small businesses.
FAQ
How accurate does it need to be?
A realistic estimate is enough. Being a little cautious (lower income, higher costs) is safer than being optimistic.
Does it work in Google Sheets?
Yes. Import it with File → Import → Upload.
How do I make a 12-month cash flow forecast?
List your expected cash in and cash out for each month, start from today’s bank balance, and let the template carry each closing balance into the next month. Update it monthly with actual figures.
What is a good minimum cash balance?
Many small businesses aim to keep at least one to three months of fixed costs (rent, salaries, loan payments) in the bank. Set that number as your warning level.