Cash flow — not profit — is the lifeblood of a small business. A company can be profitable on paper while simultaneously running out of cash to pay employees, suppliers, or rent. Building a cash flow forecast lets you see problems coming before they arrive and make proactive decisions instead of reactive ones.
This article explains what a cash flow forecast is, why it matters, and how to build one for your business — step by step.
What Is a Cash Flow Forecast?
A cash flow forecast is a projection of the cash moving into and out of your business over a future period — typically monthly, though weekly or quarterly forecasts have their uses.
It answers the fundamental question: Will you have enough cash in your bank account to meet your obligations?
It’s different from a profit and loss (P&L) statement, which measures revenue and expenses on an accrual basis (when they’re earned or incurred). A cash flow forecast focuses on actual timing — when money arrives in your account and when it leaves.
Why the distinction matters:
– You invoice a client for $10,000 in October. That appears as revenue in October on your P&L — but if the client pays in January, the cash arrives in January. Your P&L looks fine in October; your bank account may not be.
– You make a $5,000 annual insurance payment in January. Cash flow shows a large outflow in January; the P&L spreads it as $417/month.
Why Every Small Business Needs a Cash Flow Forecast
Predict shortfalls before they happen. A forecast lets you see, months in advance, that you may run short of cash in a particular month. This gives you time to arrange a line of credit, delay non-essential spending, or accelerate receivables.
Plan for seasonal patterns. Many businesses have predictable seasonal cash flow fluctuations. Knowing when cash will be tight helps you build reserves during strong periods.
Support loan applications. Lenders often ask for cash flow projections to assess your ability to repay. A well-built forecast demonstrates financial sophistication.
Make better hiring and investment decisions. Deciding whether to hire, buy equipment, or expand requires knowing your cash position, not just your profitability.
Manage vendor and payroll commitments. Payroll is non-negotiable. A forecast ensures you can always meet it.
The Two Components: Cash Inflows and Cash Outflows
A cash flow forecast has two sides:
Cash Inflows (money coming in):
– Sales receipts (adjusted for payment terms — if net 30, revenue received 30 days after invoice)
– Loan proceeds
– Investment capital
– Asset sales
– Tax refunds
– Other income
Cash Outflows (money going out):
– Payroll and employer taxes
– Rent/mortgage
– Utilities
– Supplier payments (adjusted for your payment terms with vendors)
– Loan repayments (principal + interest)
– Insurance premiums
– Marketing and advertising
– Professional services (accountant, attorney, etc.)
– Equipment purchases
– Tax payments
– Owner draws or distributions
Step-by-Step: Building Your Forecast
Step 1: Choose Your Time Period and Frequency
For most small businesses, a 12-month rolling forecast updated monthly is the right starting point. This gives enough visibility to plan while remaining manageable.
For businesses with tight cash or seasonal variability, a weekly forecast for the next 90 days can supplement the monthly view.
Step 2: Set Your Opening Cash Balance
Your opening balance is the cash you currently have in your business bank accounts at the start of the forecast period. This is the foundation.
Step 3: Forecast Cash Inflows by Month
For each month in your forecast, estimate:
Sales receipts:
Start with your expected sales for each month. Then adjust for your payment terms:
– If you’re paid immediately (retail, cash sales), the receipt matches the sale.
– If you invoice with net-30 terms and 80% of clients pay on time, 80% of January invoices arrive in February; the other 20% drift later or become bad debt.
Practical approach for forecasting sales:
– Use your historical data as a baseline.
– Adjust for known factors: a new contract starting in month 3, seasonal slowdowns in July, a marketing campaign launching in month 6.
– Be conservative. It’s better to be pleasantly surprised than to plan based on optimistic projections.
Other inflows:
Add any expected loan draws, investment receipts, or one-time income in the months they’re expected.
Step 4: Forecast Cash Outflows by Month
List every category of outflow and estimate the amount and timing for each month.
Fixed expenses (consistent month to month): Rent, loan payments, insurance, subscription services. These are easy — just enter the same number each month.
Variable expenses (tied to activity level): Cost of goods sold, shipping, sales commissions, some utilities. Forecast these as a percentage of sales or based on your expected activity level.
Irregular but predictable expenses: Annual insurance payments, quarterly tax estimates, biannual equipment maintenance. Map these to the specific months they occur — don’t average them.
Payroll: This is usually the largest outflow. Include employer-side payroll taxes (FICA, FUTA, SUTA) in addition to gross wages. Note whether you run payroll twice a month or biweekly — biweekly sometimes results in three payroll runs in a month.
Step 5: Calculate Net Cash Flow
For each month:
Net Cash Flow = Total Cash Inflows − Total Cash Outflows
A positive net means you’re adding to your cash balance. A negative net means you’re drawing it down.
Step 6: Calculate Closing Cash Balance
Closing Balance = Opening Balance + Net Cash Flow
The closing balance for January becomes the opening balance for February, and so on.
This running balance shows you exactly how much cash you’ll have at the end of each month — and when (or if) you’ll go negative.
Step 7: Identify Gaps and Plan for Them
Look at your monthly closing balances. If you see months where the balance goes negative or falls below your minimum comfort level (which should be at least one to two months of operating expenses), you have identified a gap to plan for.
Options for addressing projected gaps:
– Draw from a line of credit: If you don’t have one, now is the time to establish it — before you need it.
– Delay non-essential capital expenditures.
– Accelerate receivables: Invoice earlier, offer small discounts for early payment, follow up more aggressively on overdue invoices.
– Extend payables: Negotiate longer payment terms with vendors (without damaging relationships).
– Reduce variable expenses: Cut discretionary spending in tight months.
A Simple Template Structure
| Jan | Feb | Mar | Apr | May | Jun | |
|---|---|---|---|---|---|---|
| Opening Balance | $X | |||||
| INFLOWS | ||||||
| Sales Receipts | ||||||
| Other Income | ||||||
| Total Inflows | ||||||
| OUTFLOWS | ||||||
| Payroll | ||||||
| Rent | ||||||
| Supplier Payments | ||||||
| Loan Repayment | ||||||
| Other Expenses | ||||||
| Total Outflows | ||||||
| Net Cash Flow | ||||||
| Closing Balance |
Build this in a spreadsheet (Excel or Google Sheets) with formulas so it recalculates automatically as you update assumptions.
Maintaining Your Forecast
A cash flow forecast is only useful if it’s kept current.
- Update monthly: Replace projected figures with actual figures as each month closes and extend the forecast another month.
- Compare projected vs. actual: Where were you wrong? Understanding forecast errors helps you forecast more accurately in the future.
- Revise assumptions when things change: A major new client, a lost contract, or a change in payment terms should immediately update your forecast.
The forecast improves with each iteration. After a year of forecasting, you’ll have historical patterns that make future projections significantly more accurate.
Final Thoughts
A cash flow forecast isn’t a complicated tool — it’s a disciplined habit. Building one for the first time takes a few hours. Maintaining it takes 30–60 minutes a month. The visibility it provides, and the crises it helps you avoid, make it one of the most valuable practices a small business owner can establish.
If your business is growing or complex, working with an accountant to build your first forecast is worth the investment. Once the structure is in place, you can maintain it yourself.