How to Build a Cash Flow Forecast You'll Actually Use

How to create a cash flow forecast: choose a time horizon, start from today's bank balance, list the cash you expect to receive and pay in each period, and calculate the ending balance for every period. That is the entire method. The skill lies in using real dates and real invoices instead of averages, and in updating the forecast every week so it stays useful. It is the central tool in cash flow management.

Why a forecast beats a bank balance

The balance in your bank account tells you where you are, not where you are heading. A forecast tells you whether next month's payroll, tax payment and supplier bills can be covered by what is coming in. When it shows a shortfall, you get weeks to adjust: chase a payment, delay a purchase, draw on a credit line or trim an expense. Without it, you discover the shortfall the day the payment fails.

Before you start: decisions to make

Horizon. For day-to-day control, forecast 13 weeks ahead in weekly columns. For planning and financing, add a monthly forecast of 12 months. This article builds the weekly version, which is the more useful for most owners. The structure is explored in depth in the 13-week cash flow forecast.

Level of detail. Use individual invoices and bills for the next four to six weeks, and categories for later weeks.

Basis. Forecast cash, not accounting profit. Count a sale when you expect the money to arrive, and a bill when you expect to pay it.

Owner. One person owns the file and updates it weekly. A forecast with no owner goes stale quickly.

Step-by-step

Step 1: Set up the layout

Create columns for each week, labeled with the week-ending date. Rows go in this order: opening cash, cash receipts, cash payments, net cash flow, ending cash. Leave room for a minimum cash line at the bottom.

Step 2: Enter the opening balance

Use today's bank balance, reconciled for checks or payments that have not yet cleared. Ending cash in week one becomes opening cash in week two, and so on.

Step 3: Forecast receipts

Start with the receivables aging report. For each open invoice, estimate the week it will be paid. Use the due date, adjusted for the customer's actual payment behavior. A customer who always pays ten days late should be forecast ten days late. Then add expected cash from sales you have not yet invoiced: recurring customers, orders in the pipeline, retail sales. Include other inflows such as loan draws, tax refunds or asset sales.

Step 4: Forecast payments

List payments in four groups:

1. Fixed and scheduled: payroll, rent, loan payments, insurance, subscriptions.
2. Supplier bills: from the payables aging report, scheduled by the date you intend to pay.
3. Taxes: sales tax, payroll tax, estimated income tax.
4. Discretionary or irregular: equipment, marketing campaigns, owner distributions.

Step 5: Calculate net cash and ending cash

Net cash flow is receipts minus payments. Ending cash is opening cash plus net cash flow. Copy ending cash to the next week's opening cash.

Step 6: Set a minimum cash level

Decide the lowest balance you are comfortable with, perhaps enough to cover two weeks of payroll and rent. Add it as a line, and flag any week where ending cash falls below it. This turns the forecast into an alarm.

Step 7: Plan responses

For any week below the minimum, list the actions you could take, how much each would add, and when you would need to decide. Possible actions include collecting a specific invoice early, deferring a purchase, negotiating a supplier payment date, or drawing on a credit line.

A worked example

A hypothetical services company has an opening balance of $40,000 and a minimum cash target of $25,000.

Check the arithmetic for week 2: receipts of $21,000 minus payments of $27,500 + $9,000 + $8,000 = $44,500 gives a net of -$23,500, so $48,000 opening cash becomes $24,500.

Week 2 ends at $24,500, just $500 below the $25,000 minimum. That one line is the point of the exercise. The business can still pay everyone, but it has no cushion in week 2. The owner has choices now: ask the largest customer to pay a few days early, move one supplier payment from week 2 to week 3, or accept the thin cushion knowing that week 3 receipts are firm.

What the example teaches

Three things stand out. First, the problem week is the one where payroll, a loan payment and weak collections coincide. Week 2 has $44,500 of payments against only $21,000 of receipts. Second, the four-week total looks healthy: receipts of $145,000 against payments of $120,500 leave a net inflow of $24,500, yet the balance touches its minimum in the middle. A monthly view would hide the dip. Third, a $500 gap is small, but a customer paying one week late would turn it into a much larger one. If a $15,000 invoice due in week 2 slipped to week 3, week 2 would end at $9,500. That is why the next step, planning responses, matters as much as the numbers.

Estimating when customers will really pay

Receipts are the hardest part of any forecast, so give them extra attention. Use these methods in order of preference:

1. Invoice-level promise. For your largest customers, ask accounts receivable or sales to confirm a payment date. Record the date and who gave it.
2. Customer payment history. For each customer, calculate the average number of days between invoice date and payment over the last six invoices. Add that to each open invoice date.
3. Aging buckets. For small invoices, assume a share of each aging bucket collects in each future week, based on your history. For example, you might expect 60 percent of current invoices, 25 percent of 30-day invoices and 10 percent of 60-day invoices to collect in the next four weeks. Use your own history to set the percentages.
4. Cash sales and card payments. Use recent weekly averages adjusted for seasonality, and remember that card processors usually settle a day or two after the sale.

If you use history, test it. Compare the last eight weeks of forecast receipts with actual deposits. If you consistently overestimate, shift receipts later until the pattern disappears.

Estimating payments reliably

Payments are more controllable than receipts, but several categories are easy to miss:

• Payroll taxes and benefit deposits, which often land on different dates than payroll itself.
• Quarterly and annual items, such as insurance premiums, licenses, and estimated taxes.
• Credit card balances, which are paid in a lump from spending that happened weeks earlier.
• Supplier deposits on large or custom orders.
• Annual software renewals that auto-bill.

A simple safeguard is to review the last twelve months of bank statements and list every payment that occurred less often than monthly. Place each in the week it is likely to recur this year.

Making it accurate

• Forecast by customer for large invoices. A single $30,000 payment moving one week changes everything.
• Use realistic timing for new sales. If sales close on average 35 days before cash arrives, add that delay.
• Include taxes and irregular items. Sales tax and quarterly payments are the most common missing lines.
• Record the source of each number. A note such as "per signed contract" or "average of last six months" lets you judge its reliability.
• Be conservative with receipts and realistic with payments. Optimism on collections is the main reason forecasts fail.

Keeping it current

A forecast is a living document. Each week:

1. Replace last week's estimates with actual bank figures.
2. Add a new week at the end.
3. Update the receipts and payments for the weeks ahead.
4. Compare forecast to actual and note the biggest differences.
5. Review the minimum-cash flags and decide on actions.

The ongoing practice is described in rolling cash flow forecasts, and measuring how close your forecasts are is covered later in the cluster.

Common mistakes

• Forecasting profit instead of cash. The two diverge, as explained in cash flow vs. profit.
• Using monthly averages for lumpy items. Show annual insurance in the week it is due.
• Ignoring owner draws and taxes.
• Building it once. An outdated forecast creates false comfort.
• Hiding bad news. If a customer is late, show it. The point is to see problems early.

A starting template

If you prefer to begin with a ready layout, see the 13-week cash flow forecast template. The structure matches the steps above.

If your business sells physical products, add a line for inventory purchases scheduled by supplier and ship date. These payments are usually the largest controllable outflow and are driven by your demand forecast, a subject covered in demand planning and inventory optimization.

FAQs

How far ahead should a cash flow forecast go?

For short-term control, 13 weeks ahead in weekly columns. For planning, financing and budgeting, add a 12-month monthly view. Many companies maintain both.

What do I need to start?

A current bank balance, a receivables aging report, a payables aging report, a payroll calendar and a list of fixed obligations. A spreadsheet is enough.

How accurate should the forecast be?

Expect the first few weeks to be close and later weeks to be rougher. Track the difference between forecast and actual each week and improve the lines that miss most.

Should I include sales that have not been invoiced yet?

Yes, if you can estimate them reasonably, but delay the cash by your normal payment lag, and treat them as less certain than invoiced sales.

How often should I update it?

Weekly. Update more often during a crunch, such as when cash is close to the minimum or a major payment is due.