A profitable month can still produce a cash shortage when customers pay after payroll, suppliers and tax deposits are due. A 13-week cash-flow forecast turns that timing problem into a dated schedule. This guide builds one from a complete modeled dataset, tests a late-payment scenario and shows the control process used to keep the forecast useful.
Important: the numbers below are an original modeled example for education, not a client result or individualized accounting, lending or tax advice.
What a 13-Week Forecast Measures
The schedule follows cash, not accounting revenue. An invoice appears only in the week payment is realistically expected. A bill appears in the week money will leave the account. The core formula is:
Closing cash = opening cash + receipts − payments
Each week’s closing balance becomes the next week’s opening balance. Thirteen weeks is long enough to expose payroll cycles, rent, tax dates and slow customer payments while remaining short enough to update from real information.
Complete Worked Example
Assume a small service business begins with $10,000 in available operating cash. Forecast receipts are based on open invoices and conservative sales estimates. Payments include payroll, contractors, rent, software, suppliers, advertising, tax reserves and other scheduled operating costs.
| Week | Opening cash | Receipts | Payments | Closing cash |
|---|---|---|---|---|
| 1 | $10,000 | $4,200 | $3,800 | $10,400 |
| 2 | $10,400 | $2,800 | $5,100 | $8,100 |
| 3 | $8,100 | $6,500 | $4,200 | $10,400 |
| 4 | $10,400 | $3,100 | $6,100 | $7,400 |
| 5 | $7,400 | $7,200 | $4,300 | $10,300 |
| 6 | $10,300 | $2,600 | $5,200 | $7,700 |
| 7 | $7,700 | $4,800 | $3,900 | $8,600 |
| 8 | $8,600 | $3,500 | $6,400 | $5,700 |
| 9 | $5,700 | $7,600 | $4,400 | $8,900 |
| 10 | $8,900 | $2,900 | $5,600 | $6,200 |
| 11 | $6,200 | $5,200 | $4,100 | $7,300 |
| 12 | $7,300 | $3,800 | $6,700 | $4,400 |
| 13 | $4,400 | $8,200 | $4,600 | $8,000 |
| Total / final | $62,400 | $64,400 | $8,000 |
The business finishes with $2,000 less cash than it started with, but the more useful signal is the minimum balance: $4,400 in week 12. If management requires a $5,000 safety floor, the base case already shows a $600 shortfall against that policy even though the bank balance never reaches zero.
Stress Test: One Customer Pays Two Weeks Late
Now assume $6,300 of week-9 receipts arrives in week 11 instead. Week 9 closing cash falls from $8,900 to $2,600. After week-10 receipts and payments, cash becomes negative $100. The delayed receipt restores liquidity in week 11, but the forecast has exposed a temporary funding gap before it occurs.
| Stress-test week | Base closing cash | Late-payment closing cash | Difference |
|---|---|---|---|
| 9 | $8,900 | $2,600 | −$6,300 |
| 10 | $6,200 | −$100 | −$6,300 |
| 11 | $7,300 | $7,300 | $0 after collection |
The operational response is not automatically “borrow money.” First confirm the invoice date, accelerate collection, move discretionary spending, negotiate a supplier date where appropriate, and identify an approved backup facility before the gap. Do not delay payroll, taxes or contractual obligations without qualified advice.
A Reusable Forecast Template
- Opening cash: cleared operating cash, excluding restricted or reserved amounts.
- Customer receipts: invoice-level expected dates, not sales booked.
- Other receipts: financing or owner contributions shown separately.
- Payroll and contractors: exact pay dates including employer costs where applicable.
- Suppliers and operating bills: due dates, not statement dates.
- Taxes and reserves: separated from spendable cash.
- Closing cash and safety-floor variance: the decision signal for each week.
- Actual-versus-forecast: replaced weekly so forecasting errors become visible.
The Weekly Control Process
- Import cleared bank movements and replace the completed week’s estimates with actuals.
- Review every material receipt with the person responsible for collection.
- Move payments only when the revised date is contractually and operationally realistic.
- Add a new week at the end so the view always covers 13 weeks.
- Record the reason for material variance: timing, price, volume, cost or error.
- Run at least one downside scenario and compare every week with the minimum cash policy.
What I Watch in Publisher and AdTech Operations
Publisher dashboards often show earned revenue long before the cash is collected. Different demand partners may operate on net-30, net-60 or net-90 terms, while hosting, data, content and team costs leave on shorter cycles. I therefore separate reported revenue, validated revenue, invoiced revenue and collected cash. Mixing those stages creates false confidence.
Concentration also matters. A forecast that assumes five partners will pay on time is safer than one relying on a single large balance, even when total expected revenue is identical. Partner-level expected dates and a conservative dispute or deduction assumption are more useful than copying the monetization dashboard total into one week.
Common Forecasting Errors
- Using invoice issue dates instead of expected collection dates.
- Counting a credit limit as cash before it is drawn and approved.
- Leaving tax, refunds, chargebacks or annual renewals outside the schedule.
- Entering optimistic sales estimates without a downside case.
- Updating totals but not investigating forecast variance.
- Combining personal money and business operating cash.
The Business Profit & Break-Even Planner can test whether the underlying monthly model is profitable. The Pricing & Margin Calculator can test whether contribution per sale supports the cost structure. Neither replaces the dated liquidity view built here.
Primary Sources and Limitations
The FDIC and U.S. Small Business Administration describe cash-flow management as an essential business competency in their Money Smart for Small Business curriculum: FDIC Money Smart for Small Business. SBA planning guidance also calls for cash-flow statements and detailed monthly projections in the first year: SBA planning guidance.
This framework is general education. Cash definitions, tax treatment, financing obligations and required reserves depend on the business and jurisdiction. Verify material decisions with the appropriate accountant, tax professional or lender.
Tigran Melqumyan is the editor of Business Hub Pulse, based in Armenia. His professional background is in publisher and AdTech operations, including programmatic advertising, search and native monetization, and portfolio management. Read the full author profile or view his LinkedIn.