Actual minus forecast by line, then the availability gap split into timing and permanent drivers, worked on four weeks of one company.
A 13-week variance report sets the frozen forecast against the actuals, line by line and week by week, as actual minus forecast, totals the weeks to date, and explains the availability variance by driver, each tagged timing or permanent. In the worked case availability at week 4 is $1,379,965 below the forecast: $605,000 of timing that should reverse, and $774,965 that never will.
Worked in full in The 13-Week Cash Flow Handbook by Julian R. Sterling, with every figure reproduced in five free workbooks.Get the DRM-free PDF, $19.99 →
The comparison is always against the forecast that was sent, frozen as values on the day it left. Re-forecasting the past weeks and comparing with that is not a variance report; it hides the miss. The sign convention is fixed once: variance is actual minus forecast, so on receipts a positive variance is favorable and on disbursements a positive variance is unfavorable.
The case is a fictional manufacturer, Strellmont Fluid Products, financed by an asset-based revolver. Its first 13-week forecast was built in week 0; weeks 1 to 4 have now happened. Every figure below comes from the book's model.
| Week | Receipts forecast | Receipts actual | Variance | Disbursements forecast | Disbursements actual | Variance |
|---|---|---|---|---|---|---|
| Week 1 | $3,500,000 | $3,453,700 | -$46,300 | $5,173,400 | $5,206,675 | $33,275 |
| Week 2 | $4,484,000 | $3,292,700 | -$1,191,300 | $3,251,667 | $4,183,892 | $932,225 |
| Week 3 | $4,778,000 | $5,876,700 | $1,098,700 | $4,922,667 | $4,810,317 | -$112,350 |
| Week 4 | $4,585,400 | $4,546,600 | -$38,800 | $2,936,666 | $3,010,741 | $74,075 |
| Weeks 1 to 4 | $17,347,400 | $17,169,700 | -$177,700 | $16,284,400 | $17,211,625 | $927,225 |
Week 2 looks like the bad week: receipts $1,191,300 short. Week 3 then comes in $1,098,700 over. Read alone, either week tells the wrong story; to date, receipts are only $177,700 short. That is why the report always carries a weeks-to-date column beside the week just closed.
Disbursements are $927,225 over the forecast to date. Five lines explain all of it:
| Disbursement line | Variance, weeks 1 to 4 |
|---|---|
| Critical suppliers (castings foundry, brass bar mill) | $855,000 |
| Freight | $125,225 |
| Payroll and payroll taxes | $62,000 |
| Capital expenditure | -$250,000 |
| Professional fees | $135,000 |
| Total | $927,225 |
The castings foundry asked to be paid in advance on the critical goods of week 2, so $855,000 left in week 2 instead of week 6. The capex instalment of week 3 slipped to week 6. The lender's advisor started billing $45,000 a week from week 2. Each of those has a different future, which is what the next step sorts out.
Under an asset-based facility with a cash sweep, book cash stays at $1,250,000 every week and the revolver absorbs everything else, so the variance that matters is availability, not cash. The model is run once per driver, adding one driver at a time; the effect of a driver is the difference between two runs, so the effects add up to the total by construction.
| Driver | Class | Effect |
|---|---|---|
| Dunstrey's payment due in week 2 arrived in week 3 | timing | $0 |
| The castings foundry required payment in advance on the goods of week 2 (paid in week 2 instead of week 6) | timing | -$855,000 |
| The capex instalment of week 3 slipped to week 6 | timing | $250,000 |
| Other customers paid their 31 to 90 day past-due balances at 50 percent of the curve | permanent | -$32,350 |
| New-order shipments at 85 percent of the forecast | permanent | -$393,615 |
| Overtime of $62,000 in the payroll of week 3 | permanent | -$62,000 |
| A carrier fuel surcharge of $38,000 a week | permanent | -$152,000 |
| The lender's advisor, $45,000 a week from week 2 | permanent | -$135,000 |
| Timing drivers | -$605,000 | |
| Permanent drivers | -$774,965 | |
| Availability variance at week 4 | -$1,379,965 |
Timing means the variance reverses inside the forecast horizon: the foundry's advance is goods paid early, not extra goods, and the capex moved from week 3 to week 6. Permanent means it never comes back: shipments at 85 percent of the forecast are sales lost to the quarter, overtime is spent, the surcharge is paid.
Every timing driver goes on a list with the week it should reverse and the evidence that supports that week: the foundry's written terms for the advance, the supplier's invoice for the capex. A timing driver that has not reversed by its due week plus two is reclassified as permanent, whatever the evidence is hoped to show. Without the list, timing becomes the label for everything nobody wants to explain.
The roll then takes the actual balances at week 4 and rebuilds weeks 5 to 17. In the case, availability falls below the $5,625,000 trigger in week 9 of the rolled forecast, which is the news the lender has to hear before it happens.
A weekly comparison of actual receipts and disbursements with the frozen forecast, line by line and to date, with the availability variance explained by driver. In the worked case it shows availability $1,379,965 below forecast at week 4.
A timing variance reverses inside the forecast horizon, such as a payment that arrives a week late. A permanent variance never reverses, such as lost sales or an extra fee.
Under an asset-based revolver with a sweep, book cash is held constant ($1,250,000 in the case) and every dollar moves the revolver, so availability is the measure that tells the company how much room it has left.
Every week, for the week just closed and the weeks to date, before the forecast is rolled. A monthly variance hides the week in which the facility is tested.
This article is one step of The 13-Week Cash Flow Handbook. The book follows one company through seventeen weeks: receipts from the aging, the borrowing base every Sunday, the variance report, the roll, five levers and a DIP budget in the conditional, with every figure a live formula in the free workbooks.
Paperback PDF edition, $19.99 Book page and free files
Free: the 13-week cash flow, ABL availability and variance template in Excel.
Case figures computed by the book's model; the company is fictional and every balance, rate and covenant level is a teaching assumption. Figures checked on 17 November 2026.