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.

Report filters

Membership

Filter by membership. This report can be run by a single membership or all memberships.

Status

Filter by status. This report can be run by active, expired, or all statuses.

Balance

Filter by balance. This report can be run by an outstanding balance, no balance, or all balances.

Date

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:

(Report columns)

(Report columns continued)

Contract Price	Price of the membership. Calculation - Contract Price: [New Sales Task amount] + ([Billing amount] x [Number of charges]) A new sales task is the Pricebook task used for a new membership sale. Billing amount includes the negative item(s) in the Pricebook that are used for invoice templates and membership sales.
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]
Recognized Revenue	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]
Deferred Balance	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.

Disclaimer: Information provided in this article is for informational purposes only and it should not be construed to be legal advice. Information provided in this article may also not constitute the most up-to-date legal or other information. You should not act or refrain from acting on the basis of any information in this article to meet any compliance requirements without seeking independent legal or other professional advice.

Customer	Customer name. This is the Bill To customer on the invoice.
Address	Service location address that the membership is attached to.
Membership	Type of membership attached to the service location.
Start Date	Start date of membership.
End Date	End date of membership.