How to forecast cash flow for 13 weeks

Why 13 weeks is the right window

Thirteen weeks covers one full quarter, which is long enough to see tax dates, rent cycles and seasonal swings but short enough to forecast with some accuracy.

A monthly budget hides timing problems. Rent leaves on the first, payroll on the 15th and 30th, a big supplier bill on the 20th, and the customer who owes you for March pays in May. Inside a single month, your balance can drop below zero for a week and recover by month end. A monthly view will never show it.

Weekly columns expose those dips. Thirteen of them let you see far enough ahead to act. If you spot a shortfall in week nine, you have two months to collect faster, delay a purchase or arrange a line of credit. If you spot it in week one, your options are much worse.

The forecast is a cash document, not a profit document. It records when money moves, not when you earn or owe it. For the difference, see cash flow versus profit.

Set up the grid before you fill in any numbers

Use one row per cash source or cash use and one column per week, with an opening balance, total receipts, total payments and a closing balance at the bottom.

Open a spreadsheet and label the columns Week 1 through Week 13, using the actual date each week starts. Down the left side, build these blocks:

• Opening cash: the bank balance at the start of the week. For week 1, use your real balance today. For every later week, link it to the prior week's closing cash.
• Cash in: customer payments, deposits, card settlements, loan proceeds, owner contributions, tax refunds.
• Cash out: payroll and payroll taxes, rent, supplier payments, loan payments, insurance, software, sales tax, owner draws, equipment.
• Net change: cash in minus cash out.
• Closing cash: opening plus net change.

Add one more line under the grid: your minimum safe balance. Many owners choose roughly one payroll cycle plus a month of fixed bills. Any week where closing cash falls below that line is a flag.

Estimate the cash coming in, week by week

Forecast receipts from the way customers actually pay, not from when you invoice, and start with what is already owed to you.

Start with open invoices. For each one, write down the week you honestly expect payment, using each customer's past habits. A client who pays in 45 days on a net-30 invoice goes in the week 45 days out, not week four.

Next, add sales you expect but have not invoiced. Use recent averages, then trim them. If the last eight weeks of card sales ranged from $9,000 to $13,000, plan on the low-middle of that range. Cash forecasts should lean cautious.

Illustrative example: a cleaning company bills $24,000 a month on net-15 terms to commercial accounts and collects about $6,000 a week on average, but its largest client, worth $8,000, pays on the 25th. The forecast puts $5,000 in most weeks and $13,000 in the week containing the 25th. That lumpy pattern is the information a monthly budget would smooth away.

Estimate the cash going out

List every payment by its due date, separate fixed from variable costs, and include the irregular bills that cause surprises.

Work from your bank and card statements for the last three months. Fixed items go in first because their dates are known: rent, loan payments, insurance, leases, subscriptions, payroll. Then add variable costs such as inventory, materials, fuel and contractor payments, based on your sales forecast.

The items owners forget are the ones that wreck a forecast:

• Quarterly estimated taxes and sales tax remittances.
• Annual insurance premiums, licenses and renewals.
• Payroll tax deposits, which land on top of the payroll itself.
• Equipment repairs and a small buffer for the unplanned.

Be careful with owner pay. If you take draws, put them in as a real line. A forecast that leaves them out will look healthier than your bank account will be.

Read the forecast and decide what to do

Look for the first week where closing cash drops below your minimum, then compare the size of the gap with the levers you have to close it.

Once the grid is full, scan the closing cash row. You are looking for the lowest point and the week it happens. The size of the gap matters more than its existence. A $2,000 dip can usually be fixed by chasing two invoices. A $40,000 dip needs a bigger plan.

Your levers, roughly in order of cost:

1. Collect faster. Call overdue customers, send invoices the day work finishes, ask for deposits.
2. Move payment dates. Ask suppliers to shift a due date by a week or two.
3. Delay or cut spending that does not produce revenue soon.
4. Bring in outside cash. A business line of credit suits repeating gaps because you draw only what you need and repay it. Working capital suits a one-time gap tied to a specific opportunity.

Whatever you borrow, put the repayments into the forecast and rerun it. If the forecast still dips after the new payments, the plan is too tight.

Keep the forecast alive with a weekly update

Every week, replace the oldest forecast column with actuals, add a new week 13 and note where the forecast was off.

A forecast you build once and never touch is a snapshot, not a tool. Set a fixed time each week, perhaps Monday morning, to do four things. First, type last week's actual receipts and payments over the forecast numbers. Second, reset the opening balance to the real bank figure. Third, add a new week at the far end so you always look 13 weeks ahead. Fourth, write one sentence on the biggest miss.

After a month, patterns appear. Maybe you consistently overestimate receipts by 10 percent, or a certain vendor bills early. Adjust your assumptions and the forecast gets sharper. Many owners find the habit takes under thirty minutes once the grid exists.