A surprising number of profitable businesses still run out of cash at the wrong moment. Knowing your numbers and knowing your cash timing are two very different things. Building a cash flow projection is how you close that gap and stop being surprised by your own bank balance.
TLDR:
- According to SCORE.org, 82% of small business failures tie back to cash flow problems, making projections a survival tool.
- The core formula is simple: Opening Cash Balance + Cash Inflows minus Cash Outflows = Closing Cash Balance, chained forward each period.
- Build your projection using the direct method, mapping cash by when it moves, not when invoiced, to avoid timing errors.
- Six mistakes drive most projection failures: overestimating inflows, ignoring payment timing, skipping seasonal variation, missing one-time expenses, treating revenue as cash, and not updating monthly.
- Double's AI assistant generates forward-looking cash flow forecasts as structured Excel outputs, so finance teams skip manual spreadsheet modeling.
What Is a Cash Flow Projection?
A cash flow projection estimates how much cash will move in and out of a business over a future period. Instead of reporting what already happened, it forecasts what is likely to happen: expected customer payments, payroll runs, rent, loan payments, and other cash movements mapped out week by week or month by month.
This differs from a cash flow statement, which records actual cash activity that already occurred alongside the income statement and balance sheet, all outputs of the month-end close process. A projection uses historical patterns, signed contracts, and known obligations to estimate a future cash position.
Projections typically cover 12 months, though some businesses build them out to 3 years or narrow them to a rolling 13-week view when cash is tight.
Why Cash Flow Projections Matter
Cash flow problems drive most small business failures. According to SCORE.org, 82% of failures tie back to cash flow problems, meaning a profitable business can still miss payroll. According to the Federal Reserve Banks' 2025 Report on Employer Firms, 51% of small employer firms cited uneven cash flows as a financial challenge. A projection puts predictable gaps like seasonal dips or tax payments on the calendar before they become emergencies, giving you time to adjust spending or line up financing on normal terms, the same discipline behind variance accounting analysis.
Cash Flow Projection vs. Cash Flow Forecast
Most people use "cash flow projection" and "cash flow forecast" as if they mean the same thing, and in casual conversation, they usually do. The distinction that matters shows up in how the numbers get used.
A cash flow projection tends to describe a hypothetical future scenario. New businesses build projections into a business plan to show lenders or investors how cash will behave once operations start, often based on assumptions instead of live transaction history.
A cash flow forecast is the ongoing version. Existing businesses update it weekly or monthly with real bank balances, actual receivables, and current obligations, refining the estimate as new data comes in instead of setting it once and moving on.
In practice, the two overlap enough that either term works for most planning purposes.
Types of Cash Flow Projections
Cash flow projections come in three time horizons, and picking the right one depends on how close to the edge your cash position sits.
- Short-term (weekly, up to 13 weeks): Used when cash is tight or unpredictable. A rolling 13-week view catches problems fast enough to act on them, which is why turnaround situations and lenders monitoring covenant compliance rely on this cadence.
- Medium-term (monthly, 12 months): The standard for annual budgeting and day-to-day planning. Most businesses building a projection for the first time start here, mapping cash by month against known obligations and expected receipts.
- Long-term (annual, 3 to 5 years): Built for strategic planning, fundraising, and business plans. Precision matters less than direction, since investors want to see the trend, not the exact dollar.
Projections also split by method. The direct method lists cash receipts and payments line by line. The indirect method starts from projected net income and adjusts for non-cash items and working capital changes, similar in structure to a month end close checklist that sequences every reconciliation step. Most small businesses pick the direct method since it is easier to build without full financial statements.
The Cash Flow Projection Formula
The core formula behind every cash flow projection is simple: Opening Cash Balance + Cash Inflows − Cash Outflows = Closing Cash Balance.
Opening cash balance is whatever sits in the bank on day one of the period. Cash inflows cover everything expected to come in: customer payments, loan proceeds, asset sales, investor funding. Cash outflows cover everything expected to go out: payroll, rent, inventory purchases, loan payments, taxes. The closing balance becomes next period's opening balance, so the formula chains forward month after month.
Say a business starts the month with $20,000 in the bank. It expects $45,000 in customer payments and $5,000 from a small loan draw, for total inflows of $50,000. Outflows include $30,000 in payroll, $8,000 in rent and utilities, and $12,000 in inventory, for total outflows of $50,000. Net cash flow for the month is zero, and the closing balance stays at $20,000, which then opens the next period.
How to Build a Cash Flow Projection Step by Step
- Choose your projection period. Weekly, monthly, or annual, based on how tight cash runs.
- Gather historical data. Pull 6 to 12 months of bank statements, sales records, and payables and receivables aging.
- Project cash inflows. List customer payments, financing, and other receipts as separate lines.
- Estimate cash outflows. Split fixed costs, variable costs, and one-time expenses.
- Time payments correctly. Shift entries to when cash actually moves, not when invoiced.
- Calculate net cash flow. Subtract outflows from inflows each period.
- Roll the balance forward. Add net cash flow to the opening balance to set next period's starting figure.
Cash Flow Projection Example
Just as important as the columns you build is the story they tell together. In this cash flow projection example for small business, the negative February balance is the entire point: it converts a future problem into a present decision. A projection that never flags a shortfall is not more optimistic, it is less useful. Build yours to surface bad news early, since that is the only version worth acting on. Pair it with a process for managing accruals in Excel so the underlying data stays clean.
Cash Flow Projection Templates: Formats and Options
Cash flow projection templates come in a few formats, each suited to a different use case. A template excel free download version works well for teams that want rolling formulas and quick edits. A cash flow projection template google sheets option suits teams needing shared, live updates. PDF versions fit lender packets, while a cash flow projection template word fits business plan narratives.
Format | Best For |
|---|---|
Excel | Formulas, rolling 13-week builds |
Google Sheets | Shared, live team updates |
Static lender or investor packets | |
Word | Business plan narrative sections |
A useful template needs five columns at minimum: opening balance, cash inflows by source, cash outflows by category, net cash flow, and closing balance, tracked weekly or monthly.
Stick with a monthly cash flow projection template when cash is stable. Switch to a weekly cash flow template once margins tighten. A 3-year cash flow projection template adds annual summary columns and written assumptions behind each line, since precision fades further out.
Cash Flow Projections for New and Small Businesses
Without historical bank data, a startup cannot forecast the way a mature business does. The fix is a bottom-up build: estimate unit sales from market research and comparable business benchmarks instead of a top-down revenue target picked to look impressive.
A credible sample cash flow projection for small business lenders will accept typically includes startup costs, a conservative sales ramp, fixed overhead from day one, and a cushion for the accounts receivable lag most new businesses underestimate. Since every input is an assumption and not a confirmed fact, build three scenarios, conservative, expected, and optimistic, and label the assumptions behind each line item directly in the template.
Investors and loan officers read assumptions before they read numbers. Showing your math, customer acquisition cost, expected close rate, average contract value, builds more trust than a polished total with no visible logic behind it. The same principle applies to general ledger reconciliation practices that underpin reliable projections.
Common Cash Flow Projection Mistakes to Avoid
Six mistakes account for most of the gap between a projection and reality.
- Overestimating inflows. Sales pipelines look better on paper than in the bank. Build inflows from signed contracts and historical close rates, not hoped-for deals.
- Ignoring payment timing. A $10,000 invoice due in 30 days is not cash today. Map every inflow to the date it actually clears, not the invoice date.
- Treating revenue as cash. Accrual profit and cash balance are different numbers. A profitable month can still show a negative closing balance if collections lag.
- Skipping seasonal variation. Flat monthly assumptions miss the slow quarter that drains reserves. Layer in last year's seasonal pattern before finalizing outflows.
- Missing one-time expenses. Insurance renewals, annual software fees, and equipment repairs get left out because they do not repeat monthly. List them on a separate annual calendar and drop them into the months they hit.
- Not updating regularly. A projection built once in January is stale by March. Refresh it monthly against actual bank activity so the numbers stay usable, not decorative.
How to Improve Cash Flow Projection Accuracy
Four practices separate a projection you can trust from one that just looks tidy.
Switch to a rolling forecast instead of a fixed 12-month block. Add a new month to the end as each month closes, so the projection always looks 12 months ahead and never shrinks toward a fixed year-end.
Build three scenarios for every period: best case, base case, and downside. Vary the assumptions that matter most, collection speed and sales timing, not every line item, a logic shared with flux analysis when explaining period-over-period swings.
Tie inflow timing to actual accounts receivable aging instead of invoice due dates. A customer with a 45 day payment history will not suddenly pay in 30 days because the invoice says so, which is why teams rely on accounting reconciliation software to track real payment patterns.
Set a fixed review cadence, weekly if cash is tight, monthly if stable, and compare projected numbers against actual bank activity each time. Per the JPMorgan Chase Institute, the median small business holds 27 cash buffer days, which leaves little room for a projection that drifts from reality.
How Double Supports Cash Flow Visibility for Finance Teams
A projection is only as reliable as the transaction data behind it. Double's AI assistant generates forward-looking financial projections and cash flow statement forecasts as structured Excel outputs through conversational chat, so controllers and CFOs building cash runway analyses skip the manual spreadsheet modeling this guide covers. Ask Double, Double's practice-wide AI assistant, is grounded in your ledger data and can generate multi-period projections, scenario analyses, and forecast workpapers on demand through natural-language chat, with full audit logging so human oversight stays intact. It is available on Core, Plus, and Scale plans, with transaction creation via chat on the Scale tier for QuickBooks Online clients.
For accounting firms building advisory services around cash flow planning, capacity comes first. Autoclose by Double hands the repetitive work of the close to AI agents that pull bank and card statements, code bank feeds, and reconcile accounts on the firm's schedule, so your team starts every close at review and signs off on each one. Autoclose is a firm-level add-on and works best with QuickBooks Online today. Pairing it with AI accounting software capabilities like accruals management and AI flux analysis clears the manual data work that otherwise eats the hours a projection review needs, shifting the conversation from reporting the past to projecting what happens next.
Final Thoughts on Making Cash Flow Projections Work for You
A projection that never shows a negative balance is not a good sign, it just means the assumptions are too optimistic. Build yours to surface the hard months, keep it updated, and treat every gap it flags as a decision point, not a dead end. Book a demo to see how Double generates structured cash flow projections through conversational chat, so your team spends time acting on the numbers instead of building them.


