Blog · Finance metrics and formulas · Finance and FP&A teams
See how advance billing and deferred revenue change a DSO denominator. Reconcile receivables, billings and recognized revenue with spreadsheet formulas and explicit assumptions.
A DSO calculation with deferred revenue needs a clear choice between recognized credit revenue and credit billings. Advance billing can create receivables before the corresponding revenue is earned, so the two denominators can give different answers from the same receivables balance. Reconcile that difference before describing it as a collections problem.
The standard days sales outstanding guide explains the usual formula and collection comparisons. This article addresses the extra reconciliation needed when billing and revenue recognition occur in different periods.
Revenue-based DSO = Closing trade receivables / Recognized credit revenue × Days
Billing-based receivables days = Closing trade receivables / Net credit billings × Days
Use the same closing receivables population, entity, currency and period in both versions. State whether receivables are gross or net of the credit-loss allowance and apply that policy consistently. Exclude cash sales from a denominator intended to describe credit collection.
The billing-based calculation is a management measure with a different denominator. It can help examine invoice collection, but it is not an elapsed-time measurement for each invoice. For the actual collection queue, inspect due dates, unapplied cash and the aging report.
An invoice for future services may establish an unconditional right to payment before the services are earned. Under the presentation guidance in FASB's revenue-recognition update, paragraphs 606-10-45-1 through 45-4, receivables are presented separately from contract assets and contract liabilities.
That is why subtracting total deferred revenue from total accounts receivable is not a sound default adjustment. Some deferred revenue relates to invoices already paid; some can relate to unpaid advance invoices. The aggregate liability does not identify the collectible invoice population.
Use the approved recognition schedule for the earned amount. Changing the DSO denominator does not change when revenue is recognized or eliminate a receivable from the ledger.
Start with a quarter-end trade-receivables aging, the quarter's invoice and credit-memo register, a revenue-recognition schedule, and opening and closing deferred revenue balances. Include contract IDs so a reviewer can follow advance invoices through the schedules.
Keep invoice date, due date and recognition period as separate fields. Add cash applications and opening receivables to prove the receivables movement. If contracts have earned but not yet billed amounts, bring the contract-asset schedule as well.
The bookings, billings and revenue bridge supplies the broader framework. Here the relevant question is whether the denominator represents earned credit sales or credit invoices issued during the measurement period.
An illustrative Colorado business-services company measures January 1 through March 31, 2026, a 90-day period. All billings are credit invoices, all recognized revenue belongs to those credit contracts, and there are no sales taxes, credits, write-offs, foreign-currency movements or contract assets in this example.
| Segment | Net credit billings (USD) | Recognized credit revenue (USD) | Closing receivables (USD) | Revenue-based DSO (days) | Billing-based days |
|---|---|---|---|---|---|
| Subscription services | 300,000 | 180,000 | 100,000 | 50.0 | 30.0 |
| Project services | 150,000 | 120,000 | 50,000 | 37.5 | 30.0 |
| Total | 450,000 | 300,000 | 150,000 | 45.0 | 30.0 |
Place the table headers in row 1 and the segments in rows 2 and 3. With columns A through F in the order shown, calculate E2 and F2 as follows, then fill down:
=IF(C2=0,NA(),D2/C2*90)
=IF(B2=0,NA(),D2/B2*90)
The total calculations divide summed amounts:
=SUM(D2:D3)/SUM(C2:C3)*90
=SUM(D2:D3)/SUM(B2:B3)*90
Revenue-based DSO is $150,000 / $300,000 × 90 = 45.0 days. Billing-based days are $150,000 / $450,000 × 90 = 30.0 days. Display days to one decimal place and retain unrounded values in the workbook.
These results describe the same closing unpaid invoices against different flows. They do not establish that collection improved or deteriorated, because no prior-period collection outcome has been supplied.
With no contract assets or other adjustments, the simplified identity is:
Net billings = Recognized revenue + Closing deferred revenue − Opening deferred revenue
| Control schedule | Amount (USD) |
|---|---|
| Recognized credit revenue | 300,000 |
| Opening deferred revenue | 200,000 |
| Closing deferred revenue | 350,000 |
| Increase in deferred revenue | 150,000 |
| Revenue plus deferred revenue increase | 450,000 |
| Invoice-register net billings | 450,000 |
| Billing reconciliation difference | 0 |
The liability increased because billing exceeded recognized revenue. The identity explains the denominator difference; it does not measure cash collected.
Independently reconcile receivables:
| Receivables movement | Amount (USD) |
|---|---|
| Opening trade receivables | 120,000 |
| Add net credit billings | 450,000 |
| Less cash applied to invoices | -420,000 |
| Calculated closing receivables | 150,000 |
| Closing aging-report balance | 150,000 |
| Receivables reconciliation difference | 0 |
Both checks must pass. A correct billing bridge cannot repair unapplied cash or a missing invoice in the aging report. Use control totals from independently produced schedules, rather than deriving every check from the same summary.
If earned revenue increases contract assets before billing, include that movement. Without other adjustments, billings equal revenue plus the increase in contract liabilities minus the increase in contract assets. Currency movements, acquisitions, refunds and reclassifications can require additional identified bridge lines.
FASB's implementation Q&A, question 61, explains that contract positions are assessed by contract and unconditional receivables are presented separately. Preserve those distinctions when matching the exports. A conveniently named unbilled column needs its accounting classification checked before it enters the calculation.
Bring the receivables aging, invoice register and recognized-revenue and deferred-revenue schedules as a file or Google Sheet; Covirage maps the columns, and its tools compute and check the supplied figures. The external AI model explains the denominator differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data after setting up your business.
See FP&A reporting for the supporting reporting approach.
Do not subtract the total deferred revenue balance automatically. Deferred revenue records an obligation to deliver goods or services, while receivables record rights to payment. They can coexist on the same contract. Reconcile invoice-level balances before defining any adjusted receivables measure.
You can report a separately labeled billing-based receivables-days measure when credit invoices are the relevant collection base. Define whether billings are net of credits and which invoice population is included. It is not directly comparable with a peer's revenue-based DSO.
No. Advance invoices, seasonal billing, payment terms and the recognition schedule can affect the ratio. Compare the result with invoice due dates and the receivables aging. A change in overdue balances is stronger evidence of slower collection than a denominator change alone.