Deferred Revenue Report GuideLast updated on 09/09/2022
Purpose of the Deferred Revenue Report:
This report is useful if you track deferred revenue with your membership billing. This report will display billed amount as of the date of the report.
Common uses for this report:
Use this report to view the membership contract price, the amount billed to date, recognized revenue, and deferred balance.
How to find this report:
Click Reports > Search Deferred Revenue. Click the report name. Then you will be able to set filters and run the report.
Filter by membership. This report can be run by a single membership or all memberships.
Filter by status. This report can be run by active, expired, or all statuses.
Filter by balance. This report can be run by an outstanding balance, no balance, or all balances.
Filter by date. Use the dropdown to select a date range.
Include Zero Recognized Revenue
If the Include Zero Recognized Revenue checkbox is checked, then all customers whose recognized revenue is zero will not show in the report.
View or download the report
Click the Search icon to view the report.
The report can be downloaded in three different formats:
Export to Excel (*.xlsx) (click the dropdown arrow next to Download PDF)
Export to Comma separated (*.csv) (click the dropdown arrow next to Download PDF)
Click the Clear icon to reset the report filters.
Explanation of report columns
The report includes the following columns:
Customer name. This is the Bill To customer on the invoice.
Service location address that the membership is attached to.
Type of membership attached to the service location.
Start date of membership.
End date of membership.
(Report columns continued)
Price of the membership.
Calculation - Contract Price: [New Sales Task amount] + ([Billing amount] x [Number of charges])
Billed To Date
Total amount the customer has been billed up to the selected report date.
Calculation - Billed To Date: [New Sales Task amount] + [Billing amount collected up to the selected date]
Revenue is recognized as recurring services are completed. Revenue recognition tasks are the negative items on the recurring service job template.
Calculation - Recognized Revenue: [Sum of negative revenue recognition tasks]
The amount of recognized revenue, out of the total amount the customer has been billed.
Calculation - Deferred Balance: [Billed To Date] - [Recognized Revenue]
Important note: Some features may not be currently included in your account and additional configuration may be required. Please contact technical support for details.