Where can I find a free cash flow forecast template for Excel, and how do I actually use one?

A cash flow forecast template for Excel is free to build yourself in under an hour, and doing so is often better than downloading a generic one — but downloaded templates remain useful as starting points. This guide covers where to find them, how to build and use one properly, and where spreadsheets stop being enough for a growing small business.

The Direct Answer: Where to Get a Template

Also worth reading: How Can an AI Cash Forecast Help SMBs Predict Weekly Cash Needs? · How Can Small Businesses Build a Reliable Week-by-Week Cash Forecast? · How Should an SMB Forecast Cash Runway in 2026?

You can get a working cash flow forecast template from three main places as of September 2026: Microsoft's own template gallery (search "cash flow forecast" inside Excel or at create.microsoft.com), free versions published by accounting software vendors and financial education sites, or a blank workbook you build yourself. Microsoft's built-in templates are the safest starting point because they open cleanly in Excel, use standard formulas, and don't require macros or third-party add-ins that could pose security risks. Small business publications like NerdWallet and Small Business Trends regularly publish free template roundups alongside their budgeting guides, and those are generally vetted for basic accuracy.

The honest caveat: a downloaded template is a starting structure, not a finished forecast. Every template ships with placeholder categories — "Sales," "Operating Expenses," "Other Income" — that you must replace with your actual chart of accounts and realistic figures. A template downloaded and filled with guesses is worse than useless because it creates false confidence. Budget roughly two to four hours for initial setup if you download, and three to five hours if you build from scratch, plus 30 to 60 minutes weekly to maintain it.

How a Cash Flow Forecast Actually Works

A cash flow forecast predicts the movement of actual cash in and out of your business over a future period, usually 13 weeks (one quarter) for operational purposes or 12 months for planning. It is not a profit forecast. Profit is measured on an accrual basis — revenue when earned, expenses when incurred. Cash flow is measured when money actually hits or leaves your bank account. A business can be profitable on paper and still fail because a customer paying 60 days late means payroll can't be met this Friday. This distinction is the single most important concept in small business cash management, and it's where most template users go wrong: they forecast revenue at the point of sale rather than the point of collection.

The core structure is simple. Each column represents a week or month. Each row is either an inflow category or an outflow category. You start with your opening bank balance, add projected inflows (customer collections, loans, asset sales), subtract projected outflows (rent, payroll, supplier payments, tax, loan repayments), and arrive at a closing balance that becomes the next period's opening balance. Excel handles this with basic SUM formulas and cell references — no advanced skills required. The closing balance row is what you watch: if it dips below your minimum safety threshold, you've found a problem before it happens.

Building Your Own Template: Step by Step

Start with a 13-week weekly forecast, which is the standard operating horizon recommended in most small business finance guides including NerdWallet's budgeting framework. In row one, put week-ending dates. In row two, your opening cash balance. Then create inflow rows: cash sales, customer collections (split by payment terms if your customers pay at different speeds), and other income. Below that, outflow rows: payroll, rent, suppliers, tax, loan repayments, and a discretionary or buffer row.

The step most people skip is mapping collections to payment terms. If you invoice £10,000 in week one with 30-day terms, that cash belongs in week five, not week one. Use Excel's payment-terms logic by physically placing the collection in the correct week's column, or use an offset formula. On the outflow side, match VAT/GST/sales tax to its actual payment date, not the date of the underlying sale, because tax remittances create large lumpy outflows that regularly surprise businesses. Finally, add a "net position" row (closing balance) and a simple conditional format that turns the cell red when it drops below your minimum buffer — typically one to two months of fixed costs, or 10 to 15 percent of annual revenue for service businesses with thin reserves.

Free Download Options Compared

Here is how the main routes compare. Note that we at GlassJarr provide an AI-assisted cashflow coach, so treat the spreadsheet comparison as genuinely neutral: for many businesses under roughly $1M in revenue with simple operations, a spreadsheet is genuinely adequate.

One warning on downloads: avoid templates requiring "enable macros" or executable files. Macro-enabled templates from unknown sources are a known malware vector. Stick to .xlsx files from Microsoft, established financial publications, or recognized institutions. Business Insider's coverage of Excel for small businesses has noted that many SMBs overpay for software when a well-built spreadsheet covers their needs — that's fair up to roughly the point where you're spending more than five hours a month maintaining the file manually.

The Five Most Common Mistakes

First, forecasting sales instead of collections. The classic killer: a business books a $50,000 contract in month one, forecasts the cash in month one, but the client pays in month three — after the business has already committed to spending it. Second, ignoring seasonality. If 40 percent of your revenue lands in November and December, a flat monthly forecast is fiction. Use at least 12 months of history to build a seasonality factor, even a crude percentage per month.

Third, omitting irregular outflows. Annual insurance premiums, quarterly tax payments, equipment purchases, and owner draws are the items that break forecasts because they don't appear every week and get forgotten. List every non-monthly obligation from the last 12 months and schedule them explicitly. Fourth, no variance review. A forecast you never compare to actuals stays wrong forever. Each week, spend ten minutes comparing last week's projection to what actually happened and adjusting your assumptions — after six to eight weeks your accuracy typically improves from ±20 percent to ±10 percent or better. Fifth, single-scenario thinking. Keep at least a base case and a downside case (say, collections delayed 30 days and sales down 15 percent) so you know your break-even runway before a crisis, not during one.

When a Spreadsheet Stops Being Enough

A manual Excel forecast has real failure modes that get worse with scale. Every data update is manual, which means updates get skipped under pressure — exactly when you need the forecast most. Formula links break silently. There's no audit trail showing who changed an assumption. If you have more than roughly 30–50 active invoices moving through different payment cycles, manually mapping collections becomes error-prone and consumes an afternoon per month. Enterprise tools like Microsoft Dynamics 365 have pushed advanced forecasting with accountability features for years, but that tier of software is overkill for most SMBs.

The middle ground — where AI-assisted tools like GlassJarr sit — connects to your bank and accounting data, automates the collection mapping, and flags projected shortfalls early, while keeping the underlying logic transparent rather than a black box. The sensible decision rule: if forecasting takes you more than two to three hours per month, or you've ever been surprised by a cash shortfall you should have seen coming, move beyond the manual spreadsheet. If your cash pattern is simple — subscription revenue, predictable payroll, no long debtor cycles — the free Excel template is genuinely all you need, and there is no shame in that.

Timing: When to Start and How Often to Update

Start forecasting immediately if you have less than three months of fixed costs in reserve; you are in the highest-risk category for cash surprises. Even a rough 13-week forecast built this weekend beats none. If you're planning a hire, a big purchase, a loan application, or a price change in the next six months, the forecast is how you test affordability before committing — lenders increasingly ask for 12-month cash flow projections with loan applications, so having a maintained forecast shortens that process materially.

Update weekly at minimum during normal conditions. Move to twice weekly if your closing balance is projected to fall below one month of fixed costs at any point, or if you're in a high-volatility period like a seasonal peak, a major customer transition, or a recessionary stretch. Review assumptions quarterly: payment terms, gross margins, and expense inflation all drift, and a forecast built on year-old assumptions can be off by 15–25 percent. The discipline matters more than the precision — a rough forecast maintained weekly beats a perfect one built once and abandoned in March.

Bottom Line

Download a free Excel cash flow forecast template from Microsoft's gallery or a reputable financial publication, spend two to four hours replacing placeholders with your real numbers and payment terms, and update it weekly. Watch the closing balance row against a buffer of one to two months of fixed costs. Graduate to an automated or AI-assisted tool when maintenance exceeds a few hours a month or when your invoice volume makes manual collection mapping unreliable. The template costs nothing; the cash crisis it prevents typically costs a business its survival.