How to Create a Cash Flow Forecast for a Small Business
Learn how to create a cash flow forecast for a small business, including a 13-week example, formulas, payment timing, and practical tips.
A business can make sales, record a profit, and still find itself struggling to pay bills. If the income statement shows the business is profitable, shouldn't there be enough money in the bank? Not necessarily. Profit and cash answer different questions — profit measures financial performance over a period, while cash flow focuses on when money actually enters and leaves the business. A customer may owe you $10,000 today, but if they don't pay for another 45 days, that $10,000 increases your accounts receivable without increasing the cash available to pay this week's expenses.
This is where a cash flow forecast becomes valuable. Instead of asking only "how much did we make?", you begin asking how much cash you have now, what's expected to come in and go out, and whether a shortage could appear before the next major customer payment arrives. The purpose isn't to predict the future perfectly — it's to see potential cash pressure early enough to make better decisions.
💡 Finance Made Simple Insight: Cash flow problems are often timing problems, not profitability problems. A profitable sale doesn't mean cash is available today.
What Is a Cash Flow Forecast?
A cash flow forecast is a forward-looking estimate of the cash a business expects to receive and pay during a future period. If you're new to the underlying concept, start with our guide to what cash flow means and how money moves into and out of a business. A simple forecast is built around four figures: opening cash, cash inflows, cash outflows, and closing cash — using the formula:
Closing Cash = Opening Cash + Cash Inflows − Cash Outflows
For example, a business begins the week with $8,000, expects $6,000 of total inflows and $6,000 of total outflows. Closing cash = $8,000 + $6,000 − $6,000 = $8,000. The calculation is simple, but its usefulness comes from timing — if that $5,000 customer receipt were delayed two weeks, the business could have a very different cash position even though the sale had already been made.
Cash Flow Forecast vs. Cash Flow Statement
A cash flow statement looks backward and reports actual historical cash movements. A cash flow forecast looks forward and estimates what may happen next. The two work together: your historical cash flow information helps you make better assumptions about future receipts and payments, while the forecast alerts you to potential problems before they appear in the actual statement.
Cash Flow Forecast vs. Profit Forecast
Suppose a consulting business completes a $20,000 project in September but the customer has 60 days to pay. The business may recognize revenue before receiving the cash — revenue ≠ cash received. A profitable income statement doesn't automatically tell you whether the business can comfortably meet next month's payments. This is especially important for businesses with customers who pay on credit, large supplier bills, payroll obligations, tax payments, and seasonal or irregular income.
Why Small Businesses Need Cash Flow Forecasting
A business owner looking at $20,000 in the bank might feel comfortable — but that $20,000 may need to cover $7,000 payroll, $4,000 supplier payment, $2,500 rent, $1,500 tax payment, $3,000 loan repayment, and $5,000 inventory purchase, all in the coming weeks. The bank balance alone doesn't tell the whole story. A forecast changes the question from "how much money do we have today?" to "how much are we likely to have when each payment becomes due?"
The Early-Warning Value of a Forecast
The biggest benefit of forecasting isn't a perfect number — it's early warning. If a major $20,000 customer payment historically arrives 30 days late, and $12,000 of payroll and supplier payments are due in the next two weeks, a forecast can reveal the gap before it becomes urgent, giving the owner time to follow up on overdue invoices, delay a non-essential purchase, or review financing options.
A Simple 13-Week Cash Flow Forecast
A rolling 13-week forecast — roughly one quarter — is a practical short-term approach for small businesses. Weekly periods reveal timing that a monthly forecast would hide: a monthly view might just say "cash should be positive in October," while a weekly view could show cash dipping below the safe buffer during the second week before a large receipt arrives.
| Week | Opening Cash | Inflows | Outflows | Closing Cash |
|---|---|---|---|---|
| Week 1 | $10,000 | $6,000 | $5,000 | $11,000 |
| Week 2 | $11,000 | $3,000 | $8,000 | $6,000 |
| Week 3 | $6,000 | $2,000 | $7,000 | $1,000 |
| Week 4 | $1,000 | $10,000 | $5,000 | $6,000 |
The business doesn't have a problem simply because cash becomes positive again in Week 4 — the important question is whether $1,000 in Week 3 is enough to operate safely. A forecast shouldn't focus only on the final number; the lowest projected cash point is often just as important.
Building Your Forecast, Step by Step
Step 1 — Start With Opening Cash
This is the cash your business actually has available at the start of the period — bank accounts, savings available for operations, and cash on hand. That number becomes the starting point for the first forecast period, and each week's closing cash becomes the next week's opening cash.
Step 2 — Forecast Cash Inflows Using Expected Timing, Not Sale Dates
Sales are not the same as cash receipts. A $5,000 sale on September 12 with 30-day terms is expected to arrive in cash around October 12 — that's the number that belongs in the forecast, not the invoice date. Divide customers into groups: those who pay immediately, within 7–14 days, within 30 days, and those with uncertain or historically late payment timing (treat these more conservatively).
Step 3 — Include Other Expected Inflows Carefully
Owner contributions, loan proceeds, and tax refunds can be included — but only when there's a reasonable basis for expecting the cash. A forecast shouldn't become artificially optimistic by treating a hoped-for, unapproved loan as certain cash. Distinguish between confirmed, likely, and uncertain inflows.
Step 4 — Forecast Cash Outflows
List supplier payments, payroll, rent, utilities, loan repayments, taxes, insurance, subscriptions, inventory, equipment, and owner drawings — again placed in the period when cash is actually expected to leave, not simply when the expense is recorded.
Step 5 — Separate Regular and Irregular Payments
Regular payments (payroll, rent, subscriptions) are easy to predict. Irregular payments (annual insurance, tax payments, equipment purchases, large inventory orders) are just as important because they can create sudden cash dips that don't show up when looking only at average monthly expenses.
Step 6 — Put Inflows and Outflows Into One Forecast
Combine everything week by week using Net Cash Flow = Inflows − Outflows and Closing Cash = Opening Cash + Net Cash Flow. A negative weekly net cash flow doesn't automatically mean trouble — it simply means outflows exceeded inflows that week, and the business can still operate normally if its opening cash balance is strong enough.
Step 7 — Find the Lowest Projected Cash Balance
Across a set of weekly closing balances, identify the minimum. That's the point that deserves the closest attention — not necessarily a problem, but the moment worth double-checking your assumptions against.
Step 8 — Set a Minimum Cash Buffer
Decide on a minimum cash level you don't want the business to fall below, based on essential operating costs, upcoming payroll, rent, loan obligations, and your own risk tolerance. If projected closing cash is $4,200 against a $5,000 buffer, that's an $800 shortfall — a warning, not necessarily insolvency.
Step 9 — Investigate Before Reacting
If projected cash suddenly falls, ask whether a customer payment is expected too late, a large supplier payment is due, payroll is higher this week, or an annual bill was forgotten — before assuming you need financing.
A Complete 13-Week Example: BrightPath Design Studio
BrightPath, a fictional design and digital services business, starts Week 1 with $12,000. Reviewing outstanding invoices, supplier commitments, payroll, taxes, and subscriptions produces the following 13-week forecast:
| Week | Opening | Inflows | Outflows | Net | Closing |
|---|---|---|---|---|---|
| 1 | $12,000 | $6,000 | $4,300 | $1,700 | $13,700 |
| 2 | $13,700 | $4,500 | $5,300 | −$800 | $12,900 |
| 3 | $12,900 | $3,500 | $5,800 | −$2,300 | $10,600 |
| 4 | $10,600 | $7,000 | $8,300 | −$1,300 | $9,300 |
| 5 | $9,300 | $5,500 | $4,100 | $1,400 | $10,700 |
| 6 | $10,700 | $2,500 | $4,400 | −$1,900 | $8,800 |
| 7 | $8,800 | $6,000 | $5,300 | $700 | $9,500 |
| 8 | $9,500 | $4,000 | $5,300 | −$1,300 | $8,200 |
| 9 | $8,200 | $7,500 | $6,100 | $1,400 | $9,600 |
| 10 | $9,600 | $3,500 | $5,100 | −$1,600 | $8,000 |
| 11 | $8,000 | $5,000 | $5,900 | −$900 | $7,100 |
| 12 | $7,100 | $8,000 | $6,800 | $1,200 | $8,300 |
| 13 | $8,300 | $4,500 | $5,700 | −$1,200 | $7,100 |
Total inflows across the 13 weeks are $65,500; total outflows are $70,400 — a net reduction of $4,900. The business never runs out of cash (the lowest point is $7,100 in Weeks 11 and 13), but the declining trend from $12,000 to $7,100 deserves attention. If the business's minimum buffer is $5,000, it still has $2,100 of room at the lowest point — but an unexpected payment could close that gap quickly.
An important catch: if BrightPath knows a $10,000 annual insurance payment is due in Week 14 — just outside this forecast window — looking only at the Week 13 balance of $7,100 would be misleading. $7,100 − $10,000 = −$2,900. A cash forecast is only useful when it includes the commitments that matter, even ones just beyond the current horizon.
What Makes a Forecast Realistic vs. Merely Optimistic
An optimistic forecast assumes every customer pays exactly on time, sales stay strong, and no surprises occur — it may look great, but it provides false confidence. A practical forecast assumes some customers pay late, includes known large payments and taxes, and treats uncertain income cautiously. It may look less impressive, but it's far more useful for decisions.
Scenario Analysis: Conservative, Base, and Strong Case
When uncertainty is high, one number isn't enough. Build three scenarios around your base case:
| Scenario | Assumption | Projected Week 13 Cash |
|---|---|---|
| Strong case | Customers pay earlier, some expenses lower | $9,100 |
| Base case | Customers pay approximately as expected | $7,100 |
| Conservative case | Some payments delayed, one expense higher | $4,600 |
The purpose isn't to predict the future perfectly — it's to understand how sensitive your cash position is to changes in assumptions.
Common Cash Flow Forecasting Mistakes
Treating sales as cash — a $20,000 sale doesn't mean $20,000 is in the bank today.
Ignoring late customers — assuming perfect on-time payment when history says otherwise makes the forecast too optimistic.
Forgetting large one-time payments — annual insurance, taxes, and equipment purchases create real cash movements that need including.
Averaging instead of timing — spreading a $12,000 annual payment across 12 months hides the real week it actually leaves the bank.
Forgetting the opening balance — without it, you can't determine a projected closing balance.
Ignoring the minimum cash buffer — a business shouldn't wait until it reaches zero before taking action.
Never updating the forecast — a forecast becomes less useful once actual information changes but the spreadsheet doesn't.
Making the forecast look better than reality — an uncomfortable forecast that shows tightening cash is far more valuable than a flattering one.
Improve Accuracy With Variance Analysis
Compare what you forecast with what actually happened. If you forecast $8,000 of customer receipts but only $6,500 arrived, that's a $1,500 unfavorable variance worth investigating — a late customer, a cancelled order, or an unrealistic assumption. Doing this consistently is what turns a rough first forecast into an increasingly reliable one, since patterns emerge over time (a customer who always pays five days late, a supplier who always invoices early).
Turning the 13-Week Forecast Into a Rolling Forecast
As Week 1 finishes, replace the estimate with actual results and add Week 14. As Week 2 finishes, add Week 15. This keeps roughly 13 weeks of forward visibility at all times, rather than creating a forecast once a quarter and leaving it unchanged while the future keeps moving.
A Simple Cash Flow Forecast Checklist
Starting position: correct opening cash balance, all relevant accounts included.
Cash inflows: realistic payment dates, late-paying customers accounted for, uncertain income excluded from guaranteed cash.
Cash outflows: payroll, suppliers, rent, subscriptions, taxes, loan repayments, insurance, planned purchases, and owner withdrawals all included.
Calculations: total inflows, total outflows, net cash flow, and closing cash calculated correctly, with each week's closing cash carried forward as the next week's opening cash.
Risk review: lowest projected balance identified, checked against your minimum buffer, and a conservative scenario considered.
Ongoing management: forecast vs. actual compared regularly, variances investigated, and the rolling window extended.
Frequently Asked Questions
What is a cash flow forecast? A forward-looking estimate of the cash a business expects to receive and pay during a future period, using expected inflows and outflows to project future cash balances.
How far ahead should a small business forecast cash flow? A 13-week forecast provides roughly one quarter of practical short-term visibility; longer-term monthly forecasts can support broader planning.
What is the most important number in a cash flow forecast? There's no single universal number, but the lowest projected cash balance is particularly important since it shows when cash pressure may be greatest.
Can a profitable business still have a cash flow problem? Yes — profit and cash aren't the same. A business can make profitable sales while waiting for customers to pay, creating a short-term cash shortage.
How often should I update my cash flow forecast? Weekly is a useful starting point for most small businesses; more volatile cash movements may call for more frequent monitoring.
What should I do if my forecast shows negative cash? Investigate the cause first — customer collections, upcoming payments, discretionary spending, inventory, and financing needs — rather than assuming you need to borrow immediately.
Do I need accounting software to create a cash flow forecast? No — a spreadsheet is sufficient for a simple forecast, though accounting software can make the process easier by providing invoice, bill, and bank-balance data.
What's the difference between a cash flow forecast and a budget? A budget sets expectations for revenue, expenses, and financial performance over a future period; a cash flow forecast focuses specifically on when cash is expected to enter and leave the business.
Key Takeaways
Cash is about timing — a profitable sale doesn't necessarily mean cash is available today. Start with your actual opening cash balance, forecast receipts and payments based on realistic timing rather than sale or invoice dates, and use Closing Cash = Opening Cash + Inflows − Outflows consistently. Watch the lowest projected balance, not just the final one. Set a practical minimum cash buffer, use conservative scenarios when assumptions are uncertain, and compare forecast results against actual results to keep improving. Update the forecast regularly, and look beyond the current forecast horizon for known large commitments. The biggest benefit isn't knowing exactly how much cash you'll have 13 weeks from now — it's knowing when cash could become tight, why, and how much time you have to respond.
Finance Made Simple: The goal isn't to predict the future perfectly — it's to see it early enough to prepare for it.
Continue Your Financial Learning
- Financial Analysis Explained
- Financial Ratios Explained
- Cash Flow Statement Explained
- Profit vs. Cash Flow
- Financial Statements Resource Center
- Working Capital Explained
- Cash Conversion Cycle Explained
- Budget vs. Actual Analysis — coming soon
About the Author
Ishara Vithana is a senior finance professional with over two decades of experience in accounting, bookkeeping, and small business finance. He is a Xero Certified Advisor and Partner, Dext Certified Expert, Fathom Advisor, and Tally Prime expert. Through Finance Made Simple, he helps small business owners and DIY bookkeepers understand accounting, bookkeeping, and business finance with practical, easy-to-follow guides. Connect with Ishara →
Comments
Post a Comment