What each row contains
For every recognition schedule, the report shows:- The customer, product, and source document (invoice or credit note).
- The service period the schedule covers.
- The amount originally invoiced and the amount recognized to the as-of date.
- Two distinct measures of what is left: Balance and Remaining.
As-of date
The As-of date filter produces a point-in-time snapshot of the deferred liability. Setting it to a fiscal period end gives you the figure that should reconcile to the deferred revenue line on the balance sheet for that close. When an as-of date is set, the report:- Includes recognition schedules that were active on that date.
- Calculates Balance and Remaining as they stood on that date.
- Includes credit note reversals that had been posted by that date and excludes those that had not.
Balance vs Remaining
Each row carries two measures. They agree for a normal invoice. They can diverge once a credit note reverses revenue against a back-dated parent.| Column | Definition | When to use it |
|---|---|---|
| Balance | The remaining performance obligation: how much of the invoiced amount has not yet been recognized on this schedule, at the as-of date. | Operational reporting and forecasting future recognition. |
| Remaining | The row’s net movement against the deferred revenue ledger, after all postings on or before the as-of date. Ties to the revenue waterfall’s remaining figure. | Reconciling to the deferred revenue balance on the general ledger. |
Use Balance when the question is “how much have we billed but not yet earned on this schedule?”. Use Remaining when the question is “what amount on this row makes up the deferred revenue balance in the general ledger?”.
Credit notes in the report
Credit notes appear as their own rows in the report, including:- Credit notes attached to specific invoices.
- Standalone credit notes that have no parent invoice.
- Credit notes attached to schedules whose original recognition has already completed. The parent schedule itself is closed, but the credit note row remains visible so reversals against historical revenue are not lost.
(credit note, product) pair. A credit note that spans multiple products produces one row per product, with the reversal allocated correctly across them.
What is excluded by default
To keep the report focused on substantive rows, the following are excluded:- Zero-balance, zero-remaining rows. Schedules that have netted out to nothing.
- Archived schedules. Only active schedules appear in the paginated list.
- Completed obligations (configurable). When “Hide completed obligations” is on, schedules whose recognition was fully complete by the as-of date are hidden. Related credit notes are also hidden if their only link to the report is through the completed schedule.
Exporting
For larger books, the export runs asynchronously:Generation runs in the background
Sequence assembles the export. You can navigate away from the page while this runs.
Email arrives with signed link
When the file is ready, you’ll receive an email with a signed download URL. The link is also surfaced inside the dashboard.
Working with the CSV in spreadsheets
Long date ranges can produce CSVs that exceed the row limit of Excel and Google Sheets (around 1 million rows). If you hit the limit:- Narrow the date range and run multiple exports.
- Aggregate to monthly granularity before exporting.
- Load the CSV into a database tool (DuckDB, BigQuery) for analysis.
Reconciling to the revenue waterfall
The deferred revenue report and the revenue waterfall describe the same book of business at the same as-of date. They reconcile when scoped consistently. To make them tie:- Use the same as-of date on both reports.
- Read the Remaining column on the deferred report (not Balance). Remaining ties to the waterfall’s remaining figure because both are measured against the deferred ledger.
- For accounts with historical data, set both reports to start at the same earliest date.