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.