How to Build a 13-Week Cash Flow Forecast Step by Step

Step 1: Start with real cash

Begin with the actual balance in every bank account as of today, not the figure from your last report. Use a spreadsheet with thirteen columns, one per week, and rows for opening cash, cash in, cash out and closing cash. Each week's closing balance becomes the next week's opening balance.

This is where reconciled books matter. If your records are behind, you may not know what has actually cleared the bank, and the starting point is already wrong.

Step 2: Forecast cash in by timing

List expected receipts by week. For invoiced customers, pull the open receivables report from QuickBooks Online or Xero and estimate when each will really pay, based on how that customer has paid before, not the due date. For retail or card sales, use recent weekly patterns and remember that processors often deposit a day or more later and net of fees.

Be conservative. If a large customer usually pays two weeks late, plan for two weeks late. Count only sales you have good reason to expect.

Step 3: Forecast cash out by obligation

List fixed items first: payroll, rent, loan payments, insurance, software subscriptions and utilities. Then add variable costs such as inventory and materials, using the open bills report to see what is due and when. Add periodic items that are easy to forget, such as quarterly tax payments, annual insurance premiums and equipment purchases. Ask your CPA what payments to plan for, since tax timing is their area.

Include owner draws or distributions explicitly. Leaving them out is a common reason forecasts look healthier than reality.

Step 4: Find the low point

Look at the closing balance each week and mark the lowest one. That is your pinch point. Decide in advance what you will do if the balance dips below a minimum you set. Options include chasing invoices, delaying a purchase, negotiating a vendor payment date or arranging a credit line before you need it.

Seeing a shortfall six weeks ahead gives you choices. Seeing it six days ahead usually gives you only expensive ones.

Common pitfalls

The most frequent error is treating the forecast as a one-time exercise. Another is mixing accrual thinking with cash thinking: a sale you invoiced is not cash until it is collected, and a bill you received is not cash out until you pay it. Keep the model strictly on dates money moves. A third is ignoring seasonality, so check the same weeks last year for patterns before you project this quarter.

Finally, keep a short list of assumptions beside the sheet. When the forecast misses, the list tells you which assumption failed.

Step 5: Update weekly

Roll the forecast forward each week. Replace last week's estimates with actuals, add a new thirteenth week and note why any big variance happened. Over a few months you will learn where your estimates run optimistic, and the forecast gets sharper. A short weekly review of fifteen minutes is enough.

If maintaining it feels like too much, MCC Solutions can build and update one from your monthly books as part of its planning support.

Worked example with numbers

Opening cash is $18,000. Week 1 expects $9,000 of collections and $11,500 of payments (payroll $6,000, rent $2,500, vendors $3,000). Ending cash is $18,000 + $9,000 - $11,500 = $15,500. Week 2 expects $4,000 in and $3,200 out, ending at $16,300.

Keep rolling forward. If any week falls below your minimum cash cushion, you can see it three months ahead and act, by collecting sooner or timing a large payment.

Check your work

Each week, replace the forecast with actuals and note why they differed. Patterns show which assumptions are weak.

Common questions

This guide is general information, not tax, legal or accounting advice. Rules, fees and due dates change; check with the IRS, the NJ Division of Taxation or a licensed professional for your situation.