Many profitable businesses still run out of money. The reason is timing: customers pay late, bills arrive early, and the bank balance hits zero before the next invoice is paid. A cash flow forecast is the tool that shows you this problem weeks or months before it happens. This guide explains what a cash flow forecast is and how to build one in six easy steps, with a worked example you can copy into a spreadsheet.
You do not need an accounting degree. You need your bank statements, a list of regular bills, and an honest estimate of when customers will pay. If you are still setting up your company, pair this guide with our walkthrough on how to write a business plan, since a forecast is usually a key part of one.
Table of Contents
What Is a Cash Flow Forecast?
A cash flow forecast is a table that predicts how much money will come into your business and go out of it over a future period, usually the next 3, 6 or 12 months. It ends with your expected bank balance at the end of each month.
It is different from a profit and loss statement. Profit counts a sale when you make it. Cash flow counts it when the money actually arrives. If you deliver work in March but the customer pays in May, March shows a profit but your bank account stays empty until May.
Cash Flow Forecast vs Budget
- A budget is your plan for how you want to spend and earn.
- A cash flow forecast is your best prediction of what will really happen to the money in the bank, including delays.
Use both. The budget sets targets, and the forecast warns you when reality may not meet them.
Why Every Small Business Needs a Cash Flow Forecast
- Avoid surprises. You see shortfalls early enough to act.
- Plan big purchases. You can tell whether a new laptop, hire or marketing campaign is affordable this quarter.
- Negotiate better. Lenders and investors expect to see one, and it helps you time payments to suppliers.
- Reduce stress. Knowing the numbers is far calmer than guessing.
How to Create a Cash Flow Forecast in 6 Easy Steps
Step 1: Choose Your Time Frame and Starting Balance
Start with a 3-month forecast if you are new to this, then extend to 6 or 12 months. Break it into months (or weeks if cash is tight). Check your bank account and write down today’s balance. This is your opening cash.
Step 2: List Your Expected Cash Inflows
Inflows are all the money you expect to receive. Be realistic about timing.
- Customer payments (use the date they will pay, not the date you invoice)
- Subscription or retainer payments
- Loans, grants or owner contributions
- Interest or other income
If you sell subscriptions, tie this line to your recurring revenue. Our guide on how to calculate MRR shows how to turn plans and customers into a monthly figure you can place directly in the forecast.
Step 3: List Your Expected Cash Outflows
Outflows are everything you will pay. Split them into fixed costs (rent, salaries, insurance, software) and variable costs (materials, delivery, advertising). Do not forget less obvious items:
- Taxes and estimated tax payments
- Loan repayments
- Annual subscriptions that bill once a year
- Equipment purchases and repairs
If software bills are growing faster than revenue, take a look at our tips for reducing SaaS costs.
Step 4: Calculate Net Cash Flow and Closing Balance
For each month, use these formulas:
Net cash flow = Total cash in – Total cash out
Closing balance = Opening balance + Net cash flow
The closing balance of one month becomes the opening balance of the next.
Step 5: Review for Gaps and Plan Actions
Scan the closing balance row. Any month where it dips below zero (or below a safety buffer you choose, such as one month of expenses) needs an action: collect invoices faster, delay a purchase, negotiate longer payment terms or arrange a credit line before you need it.
Step 6: Update It Every Month
A forecast is a living document. At the end of each month, replace your estimates with actual numbers, compare them, and adjust the months ahead. Over time you will learn where your guesses are too optimistic.
Cash Flow Forecast Example (3 Months)
Here is a simple example for a small service business that starts with $8,000 in the bank.
| Month 1 | Month 2 | Month 3 | |
|---|---|---|---|
| Opening balance | $8,000 | $9,500 | $9,300 |
| Cash in (customer payments) | $12,000 | $11,000 | $9,500 |
| Cash out (all expenses) | $10,500 | $11,200 | $11,500 |
| Net cash flow | +$1,500 | -$200 | -$2,000 |
| Closing balance | $9,500 | $9,300 | $7,300 |
In month 1, cash out of $10,500 breaks down as rent $2,500, salaries $5,000, supplies $1,800, software $400, marketing $500 and other costs $300.
What does the table tell you? The business is not in danger yet, since the balance stays positive. But the trend matters: incoming cash falls each month while costs rise. By month 3 the business is losing $2,000 a month. If nothing changes, the cash will run out in roughly four more months. That early warning gives you time to act, for example by chasing overdue invoices, pausing a non-essential expense or lifting prices.
Practical Tips to Improve Your Cash Flow
- Invoice promptly and state clear payment terms. Shorter terms such as 14 days instead of 30 bring cash in sooner.
- Ask for deposits on larger projects so you are not funding the work yourself.
- Offer easy payment methods such as bank transfer or card links to remove excuses for delay.
- Negotiate supplier terms so bills fall due after your customers pay you.
- Keep a cash buffer equal to at least one to three months of fixed costs.
- Know the value of each customer. Learning how to calculate customer lifetime value helps you decide how much to invest in winning and keeping customers.
Common Cash Flow Forecasting Mistakes
- Counting sales as cash. Only count money when it lands in your account.
- Being too optimistic about payment dates. If customers usually pay in 45 days, forecast 45 days.
- Forgetting annual and tax payments. These can create sudden large outflows.
- Making it too complicated. A clean spreadsheet you update monthly beats a complex model you abandon.
- Never comparing forecast to actuals. The comparison is where you learn.
For more guidance, the U.S. Small Business Administration explains how to manage your business finances, and SCORE offers free mentoring and templates for small business owners. For tax or legal questions about your own situation, speak to a qualified accountant.
Frequently Asked Questions
How far ahead should a cash flow forecast go?
Three months is a good start, and 12 months suits planning and lenders. If cash is tight, use weekly columns for the first 8 to 12 weeks.
What is the difference between cash flow and profit?
Profit is revenue minus expenses over a period, recorded when sales and costs occur. Cash flow tracks actual money moving in and out of the bank, so timing matters.
Can I build a cash flow forecast in a spreadsheet?
Yes. Use rows for inflows, outflows, net cash flow and closing balance, and one column per month. Accounting software can automate it later.
Final Thoughts
A cash flow forecast does not predict the future perfectly, but it gives you time to react. Start with the next three months, list real inflows and outflows, calculate the closing balance, look for gaps and update the numbers monthly. Done consistently, it turns cash from a source of worry into something you can plan around.



