Billing Schedule Report

The Billing Schedule Report provides a consolidated view of billing over time, giving users insights into historical and projected invoicing for all Subscriptions. For each month in the selected period, the report reflects the sum of all Billing Schedule Lines within that month. The “Total” column reflects the total of all Billing Schedule Lines for the entire Financial Period selected.

Report Features:

• By default the report excludes Subscriptions in Draft status, but can be modified by enabling the “Include Draft Subscriptions” toggle.
• The report shows billed amounts in the month indicated by Invoice Date when available for non-deferred Revenue Products.
  • When a Billing Schedule Line has not been invoiced, it appears in the month indicated by the Charge Ready Date.
• The report can be aggregated by Month, Quarter, or Year by changing the “Aggregate By” drop-down.
• Filter the report by Customer, Product, and Plan to find relevant information quickly.
• Additional Filters allow for further refined insights from the report, including filtering by custom fields.

Data Sources

• Billing Schedules, Billing Schedule Lines, Customers, Products, Plans

Notes:

• This report does not include invoiced amounts for Orders.
• If a Billing Schedule Line has been invoiced, the report will then reference the Invoice Date instead of the Charge Ready Date, and the amount associated with the Invoice Line instead of the Billing Schedule Line.

Example:

A Billing Schedule Line for a Product with Revenue Rule = Recognize on Invoicing has a Charge Ready Date of 01/01/2021.

• This same Billing Schedule Line was invoiced on 03/11/2021, instead of the Charge Ready Date.
  

• This amount appears in the Billing Schedule Report for March 2021.
• This amount appears in the Revenue Report for March 2021 (when Include Non-Deferred Revenue is enabled).

Run Billing Schedule Report

Navigate to Menu > Reports > Billing Schedule Report. 

Default View

By default this report is grouped by Customer Name and Draft Subscriptions are excluded. The Financial Period selected by default is the Current Year, defined as the current calendar year, and is aggregated by Month.

Filter Report

Use the available Filters to customize the report. 

• Common filters include filter by Customer, Product, and Plan to find relevant information quickly. 
• Additional Filters allow for further refined insights from the report, including filtering by custom fields.