Countback DSO matches receivables to the months that are actually unpaid, so seasonal sales stop looking like slow collections.
The countback method calculates DSO by subtracting each month's revenue from the receivables balance, starting with the latest month, and adding that month's days until the balance is used up; the last month counts only for the fraction it covers. For an illustrative company with $4.80 million of receivables at year end and December revenue of $3.40 million, countback DSO is 46.0 days, while the simple quarterly formula gives 51.3 and the annualised formula 66.4. Customers paid exactly as fast as in every other quarter; only the countback figure says so.
Worked in full in Financial Planning and Analysis by Julian R. Sterling, with every figure reproduced in a free workbook.See the book on Amazon →
The textbook DSO divides receivables by revenue for a period and multiplies by the days in it. That implicitly assumes revenue was earned evenly across the period. When sales ramp up into a quarter end, the receivables reflect the last few, larger months, while the denominator averages them with smaller ones, and DSO rises with no change in how customers pay. FP&A teams that report DSO monthly, set collection targets, or forecast working capital from it end up explaining a seasonal pattern as a collections problem. The countback method matches the balance against the most recent revenue, which is the revenue that is actually unpaid.
The company is fictional. Every month, customers leave the whole of that month's invoices and half of the previous month's unpaid at month end, and the pattern never changes. The prior year had the same monthly revenue, so trailing twelve-month revenue is $26.4 million at every quarter end.
| Quarter | Month 1 | Month 2 | Month 3 | Quarter |
|---|---|---|---|---|
| Q1 (Jan to Mar) | 1.6 | 1.6 | 2.0 | 5.2 |
| Q2 (Apr to Jun) | 2.0 | 2.2 | 2.6 | 6.8 |
| Q3 (Jul to Sep) | 2.0 | 1.6 | 2.2 | 5.8 |
| Q4 (Oct to Dec) | 2.4 | 2.8 | 3.4 | 8.6 |
| Year | 26.4 |
Receivables at 31 December are December's $3.40 million plus half of November's $2.80 million, $4.80 million in total.
Step 1: $4.80m − December revenue $3.40m = $1.40m left; count all 31 days of December
Step 2: $1.40m is less than November revenue of $2.80m, so count the fraction: $1.40m / $2.80m = 0.50 of 30 days = 15.0 days
Countback DSO = 31 + 15.0 = 46.0 days
Simple quarterly DSO = $4.80m / $8.6m × 92 days = 51.3 days
Annualised DSO = $4.80m / $26.4m × 365 = 66.4 days
Excel, one row per month with the latest first, revenue in B, days in C, receivables in F1: in D (balance left) =MAX(prev_D-B2,0) starting from F1, and in E =MIN(1,prev_D/B2)*C2; DSO is =SUM(E:E).
| Quarter end | Receivables, $m | Simple quarterly | Annualised | Countback |
|---|---|---|---|---|
| March | 2.80 | 48.5 | 38.7 | 45.0 |
| June | 3.70 | 49.5 | 51.2 | 45.5 |
| September | 3.00 | 47.6 | 41.5 | 45.5 |
| December | 4.80 | 51.3 | 66.4 | 46.0 |
The annualised figure swings from 38.7 to 66.4 days, and jumps 24.9 days between September and December, a deterioration that would trigger a collections review. The simple quarterly figure is calmer but still moves 3.8 days in that quarter. Countback stays between 45.0 and 46.0, and the half-day differences come only from the number of days in each month. It is the only one of the three that measures what the business controls.
Now change the behaviour: at each month end 60 per cent of the previous month and 10 per cent of the month before that remain unpaid. December receivables rise by $0.52 million to $5.32 million.
| Quarter end | Receivables, $m | Simple quarterly | Annualised | Countback |
|---|---|---|---|---|
| March | 3.12 | 54.0 | 43.1 | 50.6 |
| June | 4.12 | 55.1 | 57.0 | 51.4 |
| September | 3.36 | 53.3 | 46.5 | 52.5 |
| December | 5.32 | 56.9 | 73.6 | 51.6 |
Countback rises 5.6 days in December, which is the real slowdown. But the annualised figure still says March is the best quarter of the year at 43.1 days, better than the old December's 66.4: the seasonal noise is larger than the signal. A manager watching annualised DSO cannot tell a collections problem from a strong fourth quarter.
Suppose the forecast sets each quarter-end balance at the average annualised DSO, 49.4 days, applied to trailing revenue of $26.4 million. Every quarter end gets $3.58 million of receivables. The actual balances are $2.80 million in March and $4.80 million in December, so the forecast overstates March by 27.7 per cent and understates December by 25.5 per cent, a $1.22 million cash surprise at year end. In a 13-week cash flow forecast that is the difference between a comfortable year end and a drawn revolver.
Countback runs in reverse for forecasting: with a 46.0-day countback DSO and revenue up 10 per cent, December receivables are all of December's $3.74 million plus 15 of November's 30 days on $3.08 million, $5.28 million, the balance moving with the months that drive it.
Countback DSO walks back through the months until the receivables are used up: 46.0 days here, against 51.3 simple and 66.4 annualised for the same customers. Use it for reporting, targets and the working capital forecast in any business whose revenue is not flat. The book's forecast accuracy and variance workbooks are in the free companion files; the cash value of each day is worked in how much cash reducing DSO releases.
Standard DSO divides receivables by period revenue and multiplies by the days, assuming revenue was even. Countback matches receivables to the latest months' revenue. With a ramp into year end, the illustrative company shows 51.3 days on the quarterly formula and 66.4 annualised, but 46.0 on countback, which is how long its customers actually take.
Whenever revenue is seasonal, growing fast, or lumpy at period ends. In the illustrative case annualised DSO swings from 38.7 to 66.4 days across four quarter ends with no change in payment behaviour, while countback stays between 45.0 and 46.0. For a flat revenue line the methods converge and the simple formula is enough.
Run it in reverse: the forecast balance is the full revenue of each recent month covered by the DSO, plus the fraction of the last one. At 46.0 days and 10 per cent growth, the illustrative December balance is $3.74 million of December revenue plus half of November's $3.08 million, $5.28 million.
This article is one calculation from Financial Planning and Analysis. The book takes the same case from first principles to the decision, chapter by chapter, and every figure it prints is a live formula in the free companion workbooks.
Get the book on Amazon →Free companion files
Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada
Reading guide: corporate finance, valuation and markets → · All 1614 articles →
If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.