Cash Flow Forecast Template: Free 12-Month Excel, Direct Method

A profitable business can run out of cash, and it usually happens in a month nobody was watching. Revenue was booked, customers had not paid yet, payroll landed three times, and the quarterly tax payment came due in the same four weeks.

A cash flow forecast is how you see that month coming. This one is free, built in Excel, and set up the way we build them for clients: twelve months, direct method, cash counted on the day the bank sees it.

Download the template (.xlsx) →

It opens in Excel, Google Sheets and Numbers, and there is no form to fill in first.

What is a cash flow forecast template?

A cash flow forecast template is a spreadsheet that projects the cash coming into and going out of a business, month by month, so you can see the lowest point in your bank balance before it arrives. The direct method lists actual expected receipts and payments, rather than starting from net income and adjusting it.

That distinction matters because profit and cash run on different clocks. Your P&L records revenue when you invoice and expenses when you incur them. Your bank account records them when money moves. A forecast built from the P&L tells you whether the business makes money. A forecast built from receipts and payments tells you whether you can make payroll in March.

exact_ builds and reviews cash forecasts like this one every month for founder-led, multi-location and PE-backed businesses, as part of its fractional CFO engagements. The template uses the same structure, in four tabs:

• Forecast: twelve months of cash in, cash out and closing cash, with a status flag on any month that falls below your minimum buffer.
• Collections: turns invoiced sales into cash received, using the pattern your customers actually pay on.
• Variance: forecast against actual for any month, so the forecast gets more accurate every time you use it.
• How to use: the setup steps, in order.

How to fill in the cash flow forecast template, in order

1. Start from the bank, not the books. Opening cash is the balance in your operating accounts on the first day of the forecast. If the books disagree with the bank, the bank is right for this purpose and the difference is a reconciliation job.
2. Build the collection pattern from history. On the Collections tab, enter the share of each month’s invoices you collect in the same month, one month later, two months later and three months later. Take it from what your receivables actually did over the last six to twelve months. Your payment terms say net 30. Your customers may not.
3. Enter receivables already on the books in the months you expect them to arrive, so the first quarter is not understated.
4. Enter the fixed payments next: rent, salaried payroll, software, insurance premiums and loan payments. These are the rows you can forecast with near certainty, so get them right first.
5. Then the variable payments: suppliers and inventory, hourly payroll, commissions. Tie them to the sales line where you can.
6. Set a minimum cash buffer. One number: the balance below which you would start making decisions you would rather not make. The Status row flags every month that closes under it, and the bottom of the Forecast tab shows the lowest month of the year and when it lands.

Five rows where a do-it-yourself cash forecast goes wrong

Most forecasts we inherit are not wrong because of the math. They are wrong because a payment sits in the wrong month or is missing entirely. These are the five we fix most often.

Collections forecast at terms instead of behaviour

A forecast that assumes every customer pays on day 30 is optimistic every month, and the error grows with sales, because more of your revenue is sitting in receivables at any moment. Use the collection pattern, and revisit it each quarter.

The months with three paydays

A business that pays every two weeks runs 26 payrolls a year, not 24. That puts three paydays into two months of most years. A forecast that divides annual payroll by twelve misses both of them, and those months are often where the low point sits.

Payments that arrive once a quarter or once a year

Insurance premiums, estimated income tax, annual software renewals, property tax and the year-end bonus are spread evenly across the P&L. In the bank they land all at once. Put each one in the month it is actually paid.

Sales tax that was never yours

Sales tax collected from customers arrives with your receipts and has to go back out on the filing schedule. If the forecast counts it on the way in and forgets it on the way out, closing cash is overstated by exactly the amount you owe the state. The template carries a Sales tax remitted row for this reason.

Cash that leaves without touching the P&L

Loan principal, equipment purchases and owner distributions never appear as expenses, which is why a business can show a profit and a shrinking bank balance in the same month. Each has its own row in the template. Leave none of them blank by accident.

Can’t our team just run the forecast ourselves?

Often, yes. If your books close on time, your bookkeeper can produce actuals by the second week of the month, and someone owns the variance review, this template will carry a business a long way. Plenty of owners run it themselves for years.

A spreadsheet stops being enough when the forecast starts driving decisions with real consequences:

• You are deciding whether to hire, and the answer depends on what cash looks like six months out.
• A lender, investor or board is asking for a forecast and will hold you to it.
• You run more than one location or entity, and cash needs forecasting per unit and consolidated.
• Revenue is growing fast enough that receivables and inventory are absorbing the cash the growth produces.
• The books are behind, so there are no reliable actuals to compare against.

That is the point where the forecast needs an owner with finance judgement, not just a file. exact_’s fractional CFO services include building the forecast, running the monthly variance review with you, and modelling the scenarios behind the big calls: a hire, a new location, a line of credit, a raise. You get CFO-level clarity without the full-time CFO salary. If what you need first is closer to clean books and a reliable close, our CFO vs controller comparison sets out which role to bring in first.

Run the variance review every month

A cash flow forecast is only as good as the last time someone compared it with what happened. Once a month, open the Variance tab, choose the month and enter the actuals from the bank. Read the biggest variance first and explain it in one sentence: a customer paid late, a supplier invoice came early, a hire started a month ahead of plan.

Then fix the assumption that caused it, not just the number. If collections ran behind for the third month running, the collection pattern is wrong, and every future month is wrong with it. Roll the forecast forward one month so it always looks a full year ahead.

The variance review is the part most businesses skip, and it is the part that makes the forecast worth having. A forecast nobody checks gets less accurate every month it is used.

Monthly forecast or 13-week forecast?

A monthly cash forecast is a planning tool: it shows whether the year works and where the pressure points are. A 13-week forecast is a liquidity tool, weekly and shorter, built for the stretch when cash is genuinely tight and the timing of individual payments decides what you can do. Most growing businesses need the monthly view all the time and the weekly view some of the time. Start with this template, and move to a weekly forecast when the Status row starts flagging months below your buffer.

Frequently asked questions

Is a cash flow forecast the same as a budget?

No. A budget is a plan for revenue and expenses, usually built on the P&L, and it answers whether the business will be profitable. A cash flow forecast tracks when money actually enters and leaves the bank. A business can hit its budget and still run short of cash, which is why it needs both.

How far ahead should a small business forecast cash?

Twelve months, rolled forward every month so a full year is always in view. Switch to a weekly view for any stretch where the forecast shows cash falling toward your minimum buffer.

Does the cash flow forecast template work in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas, status flags and variance tab all carry over.

How can I get visibility into cash flow without hiring a full-time CFO?

Three things, in this order. First, get the books closed on a fixed schedule, ideally within the first two weeks of the following month, because a forecast compared against late or unreconciled actuals teaches you nothing. Second, run a rolling twelve-month forecast like this one and review the variance every month. Third, give someone the job of owning it and acting on what it shows.

For many growing businesses that someone is a fractional CFO: a senior finance leader who works with you part of the month, builds the forecast and the scenarios, and sits in on the decisions they inform. You pay for the hours the business needs instead of a full-time executive salary, and the accounting and tax work can sit with the same team once the business is ready for it.

Should I bring in a fractional CFO or a controller first when cash is tight?

If cash is tight because the numbers are late, wrong or incomplete, start with the accounting side: accurate books and a dependable month-end close, which is what our outsourced accounting team runs. If the numbers are right and cash is still tight, the problem is decisions about pricing, spending, financing or growth, and that is CFO work.

See CFO services →