Free Excel download β’ Use online β’ Print or share
A Cashflow Forecast Monthly is a structured financial planning document that projects a business's expected cash inflows, outflows, and net cash position for each month of a defined operating period β most commonly 12 months. Unlike a profit and loss statement, which records revenue and expenses on an accrual basis, a cashflow forecast operates on a strict cash basis: every entry reflects when money physically enters or leaves the business's bank account, not when the underlying transaction was earned or incurred. The document is built from an opening cash balance, broken into operating, investing, and financing cash movements, and produces a closing balance for each month that carries forward to the next.
More businesses fail from cash shortfalls than from unprofitability β and a monthly cashflow forecast is the primary tool that separates businesses that see a crisis coming from those that discover it at the bank. Without a forward-looking cash model, a profitable month on paper can still result in a missed payroll if customer receipts are delayed, a large supplier payment falls due, or a quarterly tax installment arrives unplanned. Banks and SBA lenders require a completed 12-month cashflow forecast for most loan applications; investors use it to evaluate burn rate and runway before committing capital. Beyond external reporting, the monthly variance column β comparing forecast to actuals β gives operators an early-warning system to catch collection delays, cost overruns, and timing mismatches before they become existential. This template gives you the structure to build that forecast correctly the first time, present it credibly to lenders and investors, and use it as a live management tool throughout the year.
| If your situation is⦠| Use this template |
|---|---|
| Projecting cash weekly for a business with tight liquidity | Cashflow Forecast Weekly |
| Planning cash at an annual strategic level for board reporting | Annual Cash Flow Projection |
| Modeling a 3-to-5-year cash outlook alongside a business plan | Financial Projections (12 Months) |
| Tracking actual cash receipts and payments against forecast | Cash Flow Statement |
| Presenting integrated P&L, balance sheet, and cash flow to investors | Business Plan Financial Model |
| Managing project-based cash inflows and milestone payments | Project Budget Template |
| Forecasting cash for a new business before launch | Startup Financial Projections |
Why it matters: Recording revenue when invoiced but expenses when paid creates an artificially optimistic cash picture β you appear to have cash from sales you have not yet collected while deferring the visibility of what you owe.
Fix: Apply the cash basis consistently throughout: revenue enters the forecast in the month the customer payment clears, and expenses enter in the month the payment leaves your account.
Why it matters: Annual insurance renewals, quarterly tax installments, and semi-annual equipment maintenance payments are easy to overlook when building a monthly template β but a single missed $15,000 quarterly tax payment can turn a comfortable month into a crisis.
Fix: Review the prior 12 months of bank statements line by line before finalizing the template and add a calendar reminder for every non-monthly recurring payment.
Why it matters: Flat-lining revenue across 12 months ignores known seasonal patterns, contracted payment milestones, and growth-related ramp-ups β producing a forecast that is demonstrably wrong before the first month ends.
Fix: Model each revenue stream separately and apply known seasonality factors, contracted milestone dates, and growth assumptions month by month rather than averaging.
Why it matters: A cashflow forecast treated as a static document rather than a live planning tool loses its value after Month 1. A March variance that signals a structural shortfall in collections goes unaddressed until it becomes a Q3 cash crisis.
Fix: Schedule a fixed monthly review β ideally within five business days of month-end β to enter actuals, calculate variances, and reforecast the remaining months based on updated assumptions.
Why it matters: A single-scenario forecast that assumes all revenue arrives on time and no unexpected costs occur gives lenders and investors false confidence β and gives you no early-warning system if conditions deteriorate.
Fix: Build a second scenario at 70β80% of projected revenue, keeping expenses constant, to show the minimum cash position under realistic adverse conditions.
Why it matters: A forecast that shows operating cash flows only will understate total outflows if a loan repayment falls due, or overstate available cash if a planned drawdown has not been captured.
Fix: Create a dedicated financing section covering all loan drawdowns, repayments, equity injections, and dividend payments β even if these are flagged as conditional on approval.
In plain language: States the verified cash position at the first day of the forecast period, drawn from the most recent bank reconciliation.
Opening Cash Balance β [MONTH] [YEAR]: $[AMOUNT] (per bank reconciliation dated [DATE], Account No. [XXXX]).
Common mistake: Using an unreconciled book balance instead of the bank-confirmed figure. A discrepancy of even a few hundred dollars compounds across 12 months and makes the entire forecast unreliable.
In plain language: Lists each distinct revenue stream β product sales, service fees, subscription receipts, licensing β with the expected monthly cash receipt for each.
Product Sales Receipts: $[AMOUNT] | Service Fee Receipts: $[AMOUNT] | Subscription Revenue: $[AMOUNT] | Total Revenue Inflows: $[AMOUNT].
Common mistake: Recording revenue on an accrual basis (when invoiced) rather than a cash basis (when received). A Net 30 invoice issued on March 1 generates a cash inflow in April, not March.
In plain language: Captures non-operating receipts such as asset disposal proceeds, grants, tax refunds, loan drawdowns, and equity contributions.
Loan Drawdown β [LENDER NAME]: $[AMOUNT] | Equipment Disposal Proceeds: $[AMOUNT] | Government Grant Receipt: $[AMOUNT] | Total Other Inflows: $[AMOUNT].
Common mistake: Omitting a pending loan drawdown or equity injection because it is 'not confirmed yet.' If it is part of the operating plan, include it with a note on conditionality β lenders and investors need to see the full picture.
In plain language: Line-itemizes recurring cash payments for wages, rent, utilities, marketing, insurance, and other overhead β timed to when they are actually paid, not when they are incurred.
Payroll and Wages: $[AMOUNT] | Rent and Occupancy: $[AMOUNT] | Marketing and Advertising: $[AMOUNT] | Utilities: $[AMOUNT] | Insurance Premiums: $[AMOUNT] | Total Operating Outflows: $[AMOUNT].
Common mistake: Spreading annual expenses like insurance premiums evenly across 12 months when the actual payment is quarterly or annual. This understates cash outflow in the payment month and overstates it in non-payment months.
In plain language: Records cash paid to suppliers, manufacturers, or subcontractors for direct costs β timed to payment due dates, not to when goods were received or revenue was recognized.
Supplier Payments β [SUPPLIER NAME], Net [30/60]: $[AMOUNT] | Raw Materials Purchases: $[AMOUNT] | Subcontractor Payments: $[AMOUNT] | Total COGS Outflows: $[AMOUNT].
Common mistake: Matching COGS payments to the same month as the related revenue. If you pay suppliers 30 days after delivery, the cash outflow lags the revenue inflow by a full month β failing to reflect this creates a false liquidity picture.
In plain language: Records planned cash payments for the purchase of equipment, vehicles, leasehold improvements, or other long-term assets.
Equipment Purchase β [DESCRIPTION]: $[AMOUNT] payable [DATE] | Leasehold Improvements β [LOCATION]: $[AMOUNT] payable [DATE] | Total Capex Outflows: $[AMOUNT].
Common mistake: Excluding capital expenditures from the cashflow forecast because they are 'balance sheet items.' Capex is a real cash outflow regardless of how it is classified for accounting purposes.
In plain language: Captures scheduled debt repayments β principal and interest β as well as dividend payments and any share buybacks.
Loan Repayment β [LENDER NAME], Principal: $[AMOUNT] | Interest Payment: $[AMOUNT] | Dividend Payment: $[AMOUNT] | Total Financing Outflows: $[AMOUNT].
Common mistake: Including only the interest component of a loan repayment and omitting principal repayment. Both are cash outflows; omitting principal materially overstates the closing cash balance.
In plain language: Calculates total inflows minus total outflows for the month, then adds the result to the opening balance to produce the closing cash balance carried to the next month.
Total Cash Inflows: $[AMOUNT] | Total Cash Outflows: $[AMOUNT] | Net Cash Movement: $[AMOUNT] | Closing Cash Balance: $[AMOUNT].
Common mistake: Failing to carry the closing balance forward as the next month's opening balance. This breaks the chain of the forecast and produces an inaccurate cumulative picture.
In plain language: States the minimum cash buffer the business must maintain β typically equivalent to 4β8 weeks of operating expenses β and flags any month where the projected balance falls below it.
Minimum Operating Cash Reserve: $[AMOUNT] (equivalent to [X] weeks of operating expenses). Months below reserve threshold: [LIST MONTHS OR 'None'].
Common mistake: Not setting a minimum threshold at all. Without one, a forecast that shows a positive closing balance every month can mask a month where cash dips dangerously low mid-period.
In plain language: Provides a column alongside each monthly projection for recording actual figures at month-end, calculating the variance, and noting the cause of any significant deviation.
Forecast: $[AMOUNT] | Actual: $[AMOUNT] | Variance: $[AMOUNT] ([+/-X]%) | Variance Explanation: [REASON, e.g., delayed customer receipt, unplanned repair cost].
Common mistake: Completing the variance column only at year-end during audit preparation. Monthly variance review is the primary value of the forecast β catching a negative trend in Month 3 allows corrective action; catching it in Month 11 does not.
Pull the verified closing cash figure from your most recent bank reconciliation and enter it as the Month 1 opening balance. Do not use an unreconciled book balance.
π‘ If you have multiple bank accounts, consolidate all liquid balances β operating, savings, and petty cash β into a single opening figure unless your forecast is account-specific.
For each revenue category, estimate when cash will actually arrive in your account based on your standard payment terms. A Net 30 invoice issued on the 1st generates a receipt around the 30th or in the following month.
π‘ Pull your accounts-receivable aging report to calibrate realistic collection timing β if 20% of invoices are paid late, build that into your inflow timing.
Enter each expense line with the calendar date the payment leaves your account β not the accrual date. Group them into payroll, rent, utilities, marketing, and other overhead.
π‘ Check your bank statements for the last three months to catch recurring payments you may have overlooked, such as software subscriptions or quarterly insurance premiums.
For each supplier, enter the expected payment amount in the month it is actually due β factoring in your agreed payment terms (Net 30, Net 60, or COD).
π‘ If you are growing rapidly, model COGS payments on a rolling basis tied to projected sales volume in the prior period, not a fixed monthly figure.
Enter scheduled loan repayments (principal plus interest separately), planned equipment purchases, and any other non-operating cash payments by their due dates.
π‘ Pull your loan amortization schedule directly into the forecast rather than estimating β one missed principal payment distorts every subsequent month.
Sum all inflows and all outflows for each month, subtract outflows from inflows to get net cash movement, and add it to the opening balance to produce the closing balance. Carry the closing balance forward as the next month's opening figure.
π‘ Use a formula link rather than retyping the closing balance β a copy-paste error breaks the chain and is surprisingly easy to miss in a 12-column spreadsheet.
Calculate your minimum operating reserve β typically 4β8 weeks of total monthly outflows β and highlight any month where the projected closing balance falls below it.
π‘ Color-code months below the threshold in red so the warning is visible at a glance during monthly review meetings.
At each month-end, enter actual cash receipts and payments alongside the forecasts, calculate the variance for each line, and note the reason for any deviation exceeding 10%.
π‘ A variance of more than 15% on two consecutive months is a signal to reforecast β do not simply update the actuals and ignore the trend.
A monthly cashflow forecast is a financial document that projects a business's expected cash receipts and payments for each month of a defined period β typically 12 months β and calculates the resulting cash balance at the end of each month. It differs from a profit and loss statement by focusing exclusively on when cash actually moves rather than when revenue is earned or expenses are incurred.
Profitable businesses fail because they run out of cash β not because they lack customers. A monthly cashflow forecast lets you see upcoming cash shortfalls weeks or months in advance, giving you time to arrange a credit line, delay a purchase, or accelerate collections. It is also a required document for most bank loan applications and investor due diligence packages.
A profit and loss statement records revenue when earned and expenses when incurred, regardless of when cash changes hands. A cashflow forecast records only actual cash receipts and payments, timed to when they occur. A business can be profitable on its P&L while simultaneously running out of cash if customers pay slowly or suppliers require early payment. The forecast captures what the P&L cannot.
Twelve months is the standard planning horizon for operational and financing purposes β it covers a full seasonal cycle and satisfies most lender requirements. Businesses in high-growth or high-volatility situations often maintain a 13-week (rolling weekly) forecast alongside the annual monthly view for tighter liquidity management. Beyond 12 months, forecasts are typically integrated into a broader financial model or business plan.
A complete monthly cashflow forecast includes an opening cash balance, cash inflows broken down by revenue category and other sources (loans, grants, asset sales), cash outflows covering operating expenses, COGS payments, capital expenditures, and financing repayments, a net cash movement calculation, and a closing cash balance. A minimum cash reserve threshold and a variance column for tracking actuals are also best practice.
Most business lenders β including SBA-backed lenders in the US and high-street banks in Canada, the UK, and the EU β require a 12-month cashflow forecast as part of a loan application. The forecast demonstrates that projected cash flows are sufficient to service the debt. Forecasts must typically be accompanied by historical financial statements and a narrative explanation of the key assumptions.
No forecast is perfectly accurate. The goal is to identify the direction and magnitude of cash movements with enough precision to make informed decisions. A variance of 5β10% on individual line items is generally acceptable. Variances exceeding 15% on a consistent basis signal that the underlying assumptions need to be reviewed and the forecast rebaselined against actual data.
A cash flow statement is a historical accounting document β it records actual cash movements that have already occurred, typically prepared monthly or quarterly for financial reporting. A cashflow forecast is forward-looking β it projects expected movements for future periods. Both use the same structure (operating, investing, and financing activities), but the forecast is a planning tool while the statement is a reporting tool.
A Word template works well for documenting the structure, assumptions, and narrative around a cashflow forecast β and for producing a lender-ready or board-ready presentation. For the underlying calculations, most businesses use a linked Excel or Google Sheets model. Business in a Box's template provides both the formatted document and the structure you need to present findings clearly to external audiences.
A cash flow statement is a historical accounting report documenting actual cash movements in a completed period. A monthly cashflow forecast is a forward-looking planning document projecting future movements. The statement tells you what happened; the forecast tells you what is likely to happen and whether you will have enough cash when you need it.
A 12-month financial projection typically integrates a P&L, balance sheet, and cash flow into a single model β used primarily for investor presentations and business plans. A standalone monthly cashflow forecast is narrower in scope, focused entirely on cash timing, and is better suited for day-to-day liquidity management and bank loan applications.
A budget sets targets for revenue and expenditure over a period β typically on an accrual basis β and is used for departmental planning and performance management. A cashflow forecast converts those budget figures into expected cash movements, adjusting for payment timing differences. A budget without a cashflow overlay will not reveal a liquidity problem even when every budget line is on target.
A profit and loss statement measures profitability by matching revenue earned against expenses incurred, regardless of cash timing. A cashflow forecast measures liquidity by tracking when money physically enters and leaves the business. A company can show strong profit on its P&L while running out of cash β the forecast is the document that catches this disconnect.
Seasonal revenue peaks require month-by-month inflow modeling; inventory payment timing lags sales receipts by 30β60 days and must be modeled separately.
Progress billing milestones and retainage holdbacks mean cash receipts lag completion significantly; subcontractor payment timing creates parallel outflow complexity.
Monthly recurring revenue provides predictable inflows, but high burn rates from payroll and cloud infrastructure make closing balance visibility critical for runway planning.
Collections risk on large invoices and variable monthly billings make accounts-receivable timing assumptions the most consequential input in the forecast.
Long supplier payment cycles and large raw-material purchases create significant lag between production outflows and customer receipt inflows β working capital timing is the core challenge.
Daily cash receipts and weekly payroll cycles require tight weekly-to-monthly translation; seasonal occupancy or covers-per-day assumptions drive the entire inflow model.
SBA lenders typically require a 12-month cashflow projection as part of the 7(a) and 504 loan application packages. Projections must be accompanied by written assumptions and, for loans above $350K, reviewed by a CPA. State-level tax payment schedules β quarterly estimated payments, sales tax remittances β should be reflected in the outflow timing.
BDC and major chartered banks require a 12-month cashflow forecast for most business loan applications. GST/HST remittances (monthly, quarterly, or annually depending on revenue thresholds) must be included as outflows. Quebec businesses should ensure French-language versions are available when submitting to provincially regulated institutions.
UK high-street banks and the British Business Bank require cashflow forecasts for Growth Guarantee Scheme and start-up loan applications. VAT return payment timing (quarterly for most businesses) must appear as a discrete outflow. HMRC's Making Tax Digital requirements mean forecasts should align with the digital record-keeping framework.
EU member state development banks and the European Investment Fund require cashflow forecasts for SME financing programs. VAT payment schedules vary by country β monthly in France and Germany for larger businesses, quarterly for smaller ones. Cross-border businesses must account for currency conversion timing if operating in non-euro countries such as Poland or Sweden.
| Path | Best for | Cost | Time |
|---|---|---|---|
| Use the template | Small business owners, startups, and operators preparing internal forecasts or standard bank loan applications | Free | 2β4 hours to complete the first forecast |
| Template + legal review | Businesses seeking SBA loans over $350K, presenting to institutional investors, or operating in regulated industries | $300β$800 for a CFO or accountant review of assumptions and model integrity | 1β3 days |
| Custom drafted | Complex multi-entity businesses, cross-border operations with currency exposure, or capital raises above $1M requiring integrated three-statement models | $1,500β$5,000+ for a financial advisor or fractional CFO engagement | 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.
Free Forever PlanΒ Β·Β No credit card required
