Cash flow forecast template
Cash flow surprises don't kill bad businesses. They kill perfectly decent ones that didn't see it coming. This free cash flow forecast template gives SMBs a fast, practical way to project cash inflows and outflows, with pre-built formulas for Excel and Google Sheets and step-by-step instructions to get started today.
Download your free cash flow forecast template
No sign-up required, just click and go! The cash flow projection template includes everything needed for both short-term and monthly cash flow forecasting:
Monthly cash flow forecast tab: 12-month rolling view covering operating inflows, outflows, and net cash position
Weekly cash flow forecast tab: 13-week view for short-term cash visibility
Pre-built formula rows: cash inflows (revenue, receivables, loans/financing), cash outflows (payroll, rent/overhead, vendor payments, loan repayments, taxes), net cash position, and opening/closing cash balance
Color-coded variance column: actual vs. forecast, so discrepancies are visible at a glance
Instructions tab: built into the file, no separate guide needed
Both the monthly and weekly cash flow forecast templates work in Excel and Google Sheets. No macros or complicated setup.
What is cash flow forecasting?
Understanding cash flow forecasting starts with knowing which type of forecast fits the situation. There are two main approaches, and most businesses need both:
Short-term forecasting (typically a 13-week rolling view) tracks cash week by week and is essential for spotting near-term shortfalls before they become emergencies
Longer-term forecasting (a 12-month rolling view) is better suited to planning hires, capital purchases, or financing decisions
The free template above includes tabs for both.
The stakes are real. According to SCORE, 82% of small businesses that fail do so because of cash flow problems, not bad products or lack of customers. And PYMNTS reports that 60% of SMBs actively struggle with cash flow management. A cash flow forecasting model doesn't eliminate risk, but it does mean fewer surprises and more time to act when one's coming.
Common cash flow forecasting mistakes and how to avoid them
A simple cash flow forecast template only works if the inputs are honest and the habits are consistent. The following are the mistakes that undermine even well-built forecasts.
Only forecasting once a year
An annual forecast is better than nothing, but it goes stale fast. A business cash flow forecast needs to reflect what's actually happening, not what was true six months ago. Rolling monthly or 13-week forecasts that get updated regularly are far more useful than a static model revisited at year-end.
Confusing profit with cash
A business can be profitable on paper and still run out of cash. If receivables are slow and payables are immediate, the gap between profit and available cash can be significant. Cash forecasting is specifically about timing: when money actually arrives and when it actually leaves, rather than when it's earned or owed.
Using optimistic revenue assumptions
Forecast based on what's contracted or highly probable, not best-case scenarios. Overstating inflows is one of the most common reasons cash flow projections turn out to be wrong. A simple cash flow forecast with conservative inputs beats an optimistic one that sets false expectations.
Ignoring timing
When cash arrives matters as much as how much arrives. A payment due in 60 days doesn't help cover payroll next week. Build payment timing into every forecast, covering both when customers are expected to pay and when vendor and overhead payments fall due.
Treating the template as set-and-forget
A forecast only works if it gets updated. Actuals need to be reconciled against projections regularly: weekly for the 13-week view, monthly for the 12-month view. That reconciliation is what turns a cash flow forecasting model into an early warning system.
Make cash flow forecasting faster and more accurate
The biggest weakness in any spreadsheet-based cash flow forecast is that the expense data feeding it is always out of date. When transactions are exported manually, receipts are reconciled at month-end, or actuals are pieced together from bank statements, the forecast is already working with yesterday's numbers.
Expensify fixes that with the following:
Realtime expense tracking means actuals update continuously, not just when someone runs a report
SmartScan automatically captures and categorizes receipts as they happen, so nothing falls through the cracks before it reaches the forecast
Direct card feeds and corporate card reconciliation sync transactions from 10,000+ banks automatically, eliminating manual data pulls entirely
Spend management gives finance teams realtime visibility by department, project, and cost center, so the inputs feeding the forecast stay accurate
Near-realtime sync to accounting tools (QuickBooks, NetSuite, Xero, Sage Intacct, and 30+ others) means expense data flows directly into the books without double entry
Custom financial reporting lets teams drill down into exactly the categories and time periods that matter most for forecasting accuracy
The template gives any business a solid starting point for cash flow projection. Expensify makes sure the numbers flowing into it reflect what's actually happening.
FAQs about cash flow forecast templates
-
Cash flow forecasting is the process of projecting how much cash will flow into and out of a business over a set period, typically weekly (13-week view) or monthly (12-month rolling).
The goal is to identify future shortfalls or surpluses before they occur, so the business can act in advance rather than react in crisis. It's distinct from a cash flow statement, which records historical cash movements. A forecast looks forward; a statement looks back.
-
Start with two sections: cash inflows and cash outflows.
Inflows typically include revenue from sales, receivables collections, loans, and any other financing.
Outflows cover payroll, rent, vendor payments, loan repayments, taxes, and overhead.
For each line item, enter expected amounts by time period (weekly or monthly depending on the forecast horizon). Add a net cash position row (inflows minus outflows) and an opening/closing balance row to track the running cash position. The free template on this page has all of this pre-built, including the variance column to track actuals against forecast.
-
The core formula is straightforward:
Net cash flow = Total cash inflows − Total cash outflows
Closing cash balance = Opening cash balance + Net cash flow
From there, each line item in the inflows and outflows sections gets its own formula pulling from actual or projected figures. The 12-month cash flow forecast template and weekly cash flow forecast template above include these formulas pre-built, so there's no need to construct them from scratch.
-
The process has four steps:
List all expected cash inflows for the period: contracted revenue, expected collections from outstanding invoices, any planned financing
List all expected cash outflows: payroll, rent, utilities, vendor payments, taxes, loan repayments
Calculate net cash flow by subtracting outflows from inflows for each period
Carry the closing balance from one period forward as the opening balance for the next
Review against actuals regularly and update the forecast as conditions change. For a deeper look at the underlying financials, bookkeeping for small business covers the foundations.
-
A cash flow statement is a historical record that shows how cash actually moved through the business over a past period. A cash flow forecast is forward-looking, as it estimates how cash will move over a future period based on expected inflows and outflows.
Both are useful, but they serve different purposes. The statement tells you what happened; the forecast tells you what's coming. For businesses managing growth or navigating tight margins, the forecast is the more operationally critical of the two.
