How to build a cash flow forecast for your small business
Cash flow is the lifeblood of any small business. You can be profitable on paper and still go out of business if you run out of cash. A cash flow forecast helps you see the future so you can make decisions today that keep your business solvent.
What is a cash flow forecast
A cash flow forecast estimates the money coming into and going out of your business over a future period. It shows you when you will have cash surpluses and when you will face shortfalls. With this information, you can plan ahead instead of reacting to emergencies.
How to build a basic cash flow forecast
Start with a spreadsheet. Create columns for each month of the forecast period, typically 12 months ahead. Then add these rows:
Starting cash balance — How much cash you have in the bank at the beginning of the period.
Cash inflows — All the money you expect to receive. This includes customer payments, loan proceeds, investment capital, and any other income. Be realistic about when customers actually pay, not when you invoice them. If you send an invoice on Net-30 terms, the money might not arrive for 45-60 days.
Cash outflows — All the money you expect to pay out. Rent, payroll, supplies, loan payments, taxes, marketing, and any other expenses. Include both fixed expenses and variable expenses.
Net cash flow — Total inflows minus total outflows for the period.
Ending cash balance — Starting balance plus net cash flow. This becomes the starting balance for the next period.
The importance of timing
The most common mistake in cash flow forecasting is confusing revenue with cash receipt. If you invoice a client for $10,000 in January but they pay in March, that $10,000 is not January cash flow. It is March cash flow.
The same applies to expenses. If you sign a lease in January but the first payment is due in February, the cash leaves in February. Match every cash movement to the month it actually happens, not when you commit to it.
How to handle uncertainty
Your forecast will never be perfectly accurate, and that is fine. The goal is to identify trends and potential problems, not to predict the exact number. Build in buffers. Assume some customers will pay late. Assume some expenses will be higher than planned.
A good practice is to create three scenarios: a base case (most likely), an optimistic case (everything goes right), and a pessimistic case (everything goes wrong). This prepares you for multiple outcomes.
Common cash flow problems and solutions
Late customer payments are the most common problem. Solutions include requiring deposits, offering discounts for early payment, and tightening your collection process.
Seasonal dips happen in many businesses. Build up cash reserves during good months to cover the slow months. A cash flow forecast shows you exactly how much you need to set aside.
Unexpected expenses will happen. Your forecast should include a contingency line item of 5-10% of total expenses for things you cannot predict.
Growth can kill cash flow. When you grow quickly, you often need to pay for inventory, labor, and equipment before you collect revenue from new customers. This is called the growth trap, and it destroys many otherwise successful businesses.
Using your forecast to make decisions
A cash flow forecast is not a set-it-and-forget-it document. Update it every month with actual numbers and revise your forward projections. Use it to decide when to hire, when to buy equipment, and when to seek financing.
If your forecast shows a cash shortfall in three months, you have time to act. You can cut expenses, accelerate collections, or arrange a line of credit before the crisis hits.
Use the Cash Flow Waterfall Tool to visualize your cash flow and identify potential shortfalls before they become emergencies.
Frequently asked questions
What is a cash flow forecast?
A cash flow forecast projects the money flowing in and out of your business over a future period. It shows when you will have cash surpluses and when you might face shortfalls so you can plan ahead. Unlike a profit and loss statement, it tracks actual cash timing — when money hits your account versus when you earn it.
How do I forecast cash flow for my business?
Start by listing all expected cash inflows (customer payments, loans, investments) and outflows (rent, payroll, supplies, taxes) by month. Estimate payment timing based on historical patterns — if clients typically pay in 45 days, do not count an invoice as cash until then. Subtract outflows from inflows to find your net cash position each period.
What is the difference between cash flow and profit?
Profit is revenue minus expenses on an accrual basis, while cash flow tracks actual money movement. You can be profitable on paper but run out of cash if clients pay late. A business with $100,000 in sales and $80,000 in expenses is profitable, but if only $50,000 has been collected, you have a cash flow problem.
How far ahead should I forecast?
Most small businesses should forecast 12 months ahead, with the first 3 months projected weekly and the remaining 9 monthly. Once established, maintain a rolling 12-month forecast updated each month. Seasonal businesses should forecast at least 18 months to capture the full annual cycle.
What tools can I use for cash flow forecasting?
Excel and Google Sheets are the most common starting points with built-in templates available. For more advanced needs, tools like Float, Pulse, or QuickBooks Cash Flow Planner integrate with your accounting software. A simple spreadsheet works well for most small businesses with fewer than 50 transactions per month.