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.
Common questions
Why thirteen weeks and not twelve months?
Thirteen weeks is one quarter. It is short enough to estimate with reasonable accuracy and long enough to spot problems while you still have time to act.
Can I build it in QuickBooks Online or Xero?
The software supplies the inputs, such as receivables, payables and bank balances. Most owners build the forecast in a spreadsheet using those reports.
How accurate does it need to be?
It needs to be useful, not perfect. Track the gap between forecast and actual each week and adjust your assumptions.
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.