Free download β’ Use as a template β’ Print or share
A Cash Flow Forecast is a structured financial document that projects every expected cash inflow and outflow over a defined future period β typically 13 weeks or 12 months β and calculates the resulting cash balance at the end of each period. Unlike a profit-and-loss statement, which records revenue and expenses on an accrual basis when they are earned or incurred, a cash flow forecast tracks only when cash physically enters or leaves the business. It covers operating receipts from customers, non-operating inflows such as loan drawdowns, and all outflows β payroll, rent, supplier payments, capital expenditure, and debt repayments β timed to the specific dates they are due.
A profitable business can still run out of cash if customers pay slowly, large outflows cluster in the same week, or a growth phase requires inventory investment before revenue arrives. Without a forward-looking cash forecast, these events only become visible when the bank balance hits zero β at which point the options are expensive and reactive. A completed cash flow forecast makes the problem visible 4 to 13 weeks in advance, giving you time to accelerate collections, defer a capital purchase, draw on a credit line, or renegotiate a supplier payment date before a shortfall becomes a crisis. Banks and lenders require one for most loan applications above $150K because it demonstrates you understand your cash cycle. Investors expect it in any data room. This template gives you a step-by-step structure β from opening balance to variance tracking β so you can produce a credible, maintainable forecast without starting from a blank spreadsheet.
| If your situation is⦠| Use this template |
|---|---|
| Weekly operational monitoring during a cash-tight period | 13-Week Cash Flow Forecast |
| Annual financial planning alongside a P&L budget | 12-Month Cash Flow Forecast |
| Supporting a bank loan or SBA financing application | Cash Flow Projection (Bank Format) |
| Investor pitch supporting a capital raise | Financial Projections (12 Months) |
| Tracking actuals against forecast each period | Budget vs. Actual Report |
| Scenario planning for a new product launch or expansion | Business Expansion Plan |
| High-level internal planning for a startup with limited history | One-Page Business Plan |
Why it matters: Revenue recognized in Month 1 under Net 45 terms does not become cash until Month 2 or later. Overstating Month 1 cash creates a false sense of liquidity that masks an impending shortfall.
Fix: Always apply your actual collection lag β derived from accounts-receivable aging data β to convert revenue into expected cash receipt dates before entering any inflow figure.
Why it matters: The accounting book balance includes uncleared cheques and pending transactions that have not yet settled. Starting from an artificially high balance shifts every closing balance upward and can hide a real-world overdraft.
Fix: Reconcile your bank statement before starting the forecast and use the confirmed cleared balance. Note any large in-flight items as a memo line.
Why it matters: Payroll, rent, and tax payments hit on specific dates. Spreading them evenly across 4 weeks hides intra-month cash dips that can trigger overdraft fees or missed payment defaults.
Fix: Map every recurring outflow to its actual payment date. Even a simple calendar of fixed payment dates β entered before variable items β eliminates this error.
Why it matters: A single-scenario forecast gives lenders and boards no insight into downside risk. When actuals come in below plan, there is no pre-planned response β decisions are made reactively.
Fix: Build at least one downside scenario alongside the base case. Identify the period where the downside scenario first produces a negative or minimum-breach balance, and prepare a contingency action for that event.
Why it matters: A forecast that is never compared to actuals provides no feedback loop. Systematic errors in collection rates or payment timing compound over time and make future forecasts increasingly unreliable.
Fix: Schedule a fixed weekly update β 30 minutes maximum β to enter actuals, calculate variances, and adjust the forward assumptions if a pattern emerges.
Why it matters: A $50,000 equipment purchase buried in a month of otherwise ordinary outflows can push a healthy-looking closing balance negative with no prior warning in the forecast.
Fix: Maintain a separate capex line in the outflow section. Link it to a planned capex schedule so every approved purchase appears in the forecast before the cash leaves the account.
Decide whether you need weekly (13-week), monthly (12-month), or a hybrid. Cash-tight businesses need weekly detail for the first 13 weeks; stable businesses can use monthly periods for a 12-month view.
π‘ A 13-week rolling format updated every Monday gives management the highest-fidelity early warning of a cash problem.
Pull the confirmed cash balance from your most recent bank reconciliation β not your accounting software book balance. Reconcile any uncleared items before entering the figure.
π‘ If you bank with multiple institutions, sum all accounts but track each one separately in a supporting tab to spot concentration or minimum-balance issues.
Start with outstanding receivables aged by due date, apply a realistic collection rate (not 100%), then add expected new sales receipts timed to your payment terms. Separate operating inflows from loan proceeds or asset sales.
π‘ Use the last 3 months of actual collection data to set your collection rate β if customers average 38 days to pay on Net 30 terms, model 38 days, not 30.
Map each payment to the specific date cash leaves the account β payroll date, rent date, supplier due date. Sort outflows into three buckets: operating, capital expenditure, and financing.
π‘ Export your accounts-payable aging report and your payroll calendar side by side β this catches 90% of operating outflows in 15 minutes.
Subtract total outflows from total inflows for each period to get net movement, then add to the opening balance. The closing balance becomes the next period's opening balance.
π‘ Apply conditional formatting (red fill) to any closing balance below your target minimum β typically 4β6 weeks of average operating outflows.
Record every significant assumption in the assumptions register: collection rate, payment terms, revenue growth rate, seasonality adjustments, and any one-time items. Date-stamp each assumption.
π‘ Assumptions that drive more than 10% of a period's cash movement deserve a sensitivity row β show what a 10% miss on that assumption does to the closing balance.
Copy the base-case forecast and adjust two or three key drivers adversely β revenue at 75β80% of plan, collections delayed by 10β15 days, one large outflow accelerated. Identify in which period the downside scenario first creates a negative balance.
π‘ The gap between your base-case and downside closing balances is your effective liquidity buffer β if it is less than one month of outflows, you need a contingency plan.
At the end of each week or month, record actual cash movements against the forecast, calculate the variance, and note the cause for any item more than 5% off. Use this to re-calibrate assumptions for future periods.
π‘ A forecast that is never updated against actuals is a budget, not a management tool β schedule a fixed weekly 30-minute update as a calendar block.
A cash flow forecast is a financial document that projects all expected cash inflows and outflows over a defined future period β typically weekly or monthly β to show the projected cash balance at the end of each period. Unlike a profit-and-loss statement, it tracks only actual cash movements, not accrued revenues or expenses. It is the primary tool businesses use to anticipate shortfalls before they become crises.
A cash flow statement is a historical document β it records cash movements that have already occurred in a past accounting period. A cash flow forecast is forward-looking β it projects future movements based on assumptions about inflows and outflows. Both follow the same structure (operating, investing, and financing activities), but a forecast requires you to model assumptions rather than report actuals.
The right horizon depends on your situation. Cash-constrained businesses typically use a 13-week rolling forecast updated weekly for maximum operational visibility. Stable businesses preparing for a loan application or annual planning use a 12-month forecast. Startups raising capital often build an 18β24 month model. The shorter the period, the more granular and accurate the forecast should be.
A 13-week cash flow forecast covers exactly one quarter of weekly cash movements β a format widely used by lenders, turnaround advisors, and private equity firms because it provides enough detail to manage near-term liquidity without the noise of long-range assumptions. At 13 weeks, most outstanding receivables and payables are known with reasonable certainty, making the forecast highly actionable.
The most damaging errors are: (1) forecasting revenue instead of actual cash receipts β which ignores your real collection lag; (2) using an unreconciled book balance as the opening figure; (3) smoothing irregular payments like payroll and rent evenly across periods instead of pinning them to specific dates; and (4) never updating the forecast with actuals, which eliminates any learning about forecast accuracy over time.
No. A well-structured template in Word or Excel is sufficient for most small businesses and startups. Accounting software integrations (QuickBooks, Xero) can pull opening balances and receivables aging automatically, which saves time β but the analytical judgment about collection rates, payment timing, and scenario assumptions cannot be automated and must be applied manually regardless of the tool.
Banks and SBA lenders use the cash flow forecast to assess whether a borrower generates enough operating cash to service proposed debt payments without running out of liquidity. They look specifically at the minimum closing balance in any period, the consistency between the forecast assumptions and historical trading patterns, and whether the business has a credible plan for periods where cash dips close to zero. A realistic, variance-tracked forecast signals financial discipline.
A rolling forecast always looks a fixed number of periods ahead β for example, 13 weeks β regardless of the calendar date. Each week, the oldest period is dropped, actuals are recorded, and a new future week is added at the far end. This contrasts with a static forecast that ends at a fixed year-end date and progressively shortens as the year passes. Rolling forecasts are more useful for ongoing cash management.
Build at least two scenarios alongside your base case: an upside scenario (10β15% better collections, accelerated sales) and a downside scenario (collections slow by 10β15 days, revenue at 75β80% of plan). Document the assumptions that drive each scenario. Identify the earliest period in which the downside scenario produces a negative or minimum-breach balance, and prepare a specific contingency action β a credit line draw, a deferred capex item, or an accelerated receivables campaign β for that event.
A financial projections template produces a full three-statement model β P&L, balance sheet, and cash flow β designed primarily for investor or lender presentations. A cash flow forecast focuses exclusively on cash timing and closing balance, updated regularly against actuals. Use financial projections to raise capital; use a cash flow forecast to manage the business week to week.
A budget vs. actual report compares historic period revenues and expenses against a pre-set annual budget. A cash flow forecast is forward-looking and tracks only cash movements, not accrual-basis income. The two documents complement each other: the budget vs. actual report diagnoses past performance; the cash flow forecast directs near-term decisions.
A business plan provides the full strategic, operational, and financial narrative for an organization over 3β5 years, including market analysis and competitive positioning. A cash flow forecast is a narrow, operationally focused tool concerned solely with when cash moves in and out. The cash flow forecast is typically one exhibit inside a broader business plan, not a replacement for it.
A P&L statement reports revenue earned and expenses incurred on an accrual basis for a historical period β regardless of when cash changed hands. A cash flow forecast tracks only actual cash receipts and payments as they occur. A business can show a profit on its P&L while simultaneously running out of cash if receivables are slow to collect or large payments cluster in a single period.
Seasonal inventory build-ups create predictable cash dips 6β8 weeks before peak trading periods, making a monthly forecast essential for timing supplier payments against expected sales receipts.
Progress billing tied to project milestones and subcontractor payment schedules create highly irregular cash flows that require week-by-week forecasting to avoid running out of cash mid-project.
Burn rate and runway tracking are the primary outputs, with MRR growth, annual contract prepayments, and infrastructure spend as the key forecast drivers reviewed by investors every board cycle.
Billable hour timing and client invoice collection lags β often 45β60 days for corporate clients β mean revenue recognition and actual cash receipts can differ by a full billing cycle.
Large raw-material purchase orders, extended supplier credit terms, and bulk customer payment schedules create wide intra-month cash swings that require daily or weekly cash position tracking.
High fixed costs, daily cash sales, and weekly payroll create a cash cycle that can shift from positive to negative within a single slow trading week, making a rolling 13-week forecast a survival tool.
| Path | Best for | Cost | Time |
|---|---|---|---|
| Use the template | Small business owners, startup founders, and finance managers building or maintaining a standard 13-week or 12-month forecast | Free | 2β4 hours to build; 30 minutes per week to maintain |
| Template + professional review | Businesses preparing a forecast for a bank loan application, investor data room, or board presentation | $300β$800 for an accountant or CFO-for-hire review session | 1β3 days |
| Custom drafted | Turnaround situations, complex multi-entity structures, or businesses requiring a lender-covenant compliance model integrated with live accounting data | $1,500β$5,000+ for a financial consultant or fractional CFO build | 1β3 weeks |
This document is one of 3,000+ business & legal templates included in Business in a Box.
Access over 3,000+ business and legal templates for any business task, project or initiative.
Customize your ready-made business document template and save it in the cloud.
Share your files and folders with your team. Create a space of seamless collaboration.
"Fantastic value! I'm not sure how I'd do without it. It's worth its weight in gold and paid back for itself many times."
"I have been using Business in a Box for years. It has been the most useful source of templates I have encountered. I recommend it to anyone."
"It has been a life saver so many times I have lost count. Business in a Box has saved me so much time and as you know, time is money."
Stop downloading documents. Start operating with clarity. Business in a Box gives you the Business Operating System used by over 250,000 companies worldwide to structure, run, and grow their business.
Start freeΒ Β·Β No credit card required
