Articles

How do you build a 13-week cash flow variance report?

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 →

What a 13-week variance report compares

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.

Step 1: variance by line, week by week and to date

Fictional case, dollars. Variance = actual minus forecast.
WeekReceipts forecastReceipts actualVarianceDisbursements forecastDisbursements actualVariance
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.

The trap. A large variance in one week is usually timing, and a small one repeated every week is usually permanent. A $38,000 fuel surcharge on freight is invisible in any single week and costs $152,000 of availability by week 4.

Step 2: find the lines that moved

Disbursements are $927,225 over the forecast to date. Five lines explain all of it:

Disbursement lineVariance, 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.

Step 3: split the availability variance into drivers

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.

Effect of each driver on availability at week 4, dollars
DriverClassEffect
Dunstrey's payment due in week 2 arrived in week 3timing$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 6timing$250,000
Other customers paid their 31 to 90 day past-due balances at 50 percent of the curvepermanent-$32,350
New-order shipments at 85 percent of the forecastpermanent-$393,615
Overtime of $62,000 in the payroll of week 3permanent-$62,000
A carrier fuel surcharge of $38,000 a weekpermanent-$152,000
The lender's advisor, $45,000 a week from week 2permanent-$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.

Step 4: keep a reversal list

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.

Questions people ask

What is a variance report in a 13-week cash flow?

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.

What is the difference between a timing and a permanent variance?

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.

Should variances be measured on cash or on availability?

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.

How often should the variance report be produced?

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.

Read the whole case

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.

Also on this site

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.