Revenue Detail Exported Data Descriptions

Last updated
Save as PDF

This reference describes the data exported when downloading the Accounting Period Revenue Detail report. This includes data associated with single currency and foreign currency exports. See Accounting Period Revenue Detail for more information about the Accounting Period Revenue Detail report.

Revenue Detail Data Descriptions

The following describes the exported data and indicates the data included in the export when foreign currency conversion is enabled:

Column	Without Foreign Currency Conversion	With Foreign Currency Conversion	Description
Report Header Information (for .xslx exports only)
Accounting Period Name			The name for the selected accounting period.
Period			The accounting period date range.
Home Currency			The tenant currency.
Deferred Revenue Account			The name of the deferred revenue accounting code name for the selected worksheet.
Deferred Revenue Account Type			The accounting code type associated with the deferred revenue accounting code for the selected worksheet.
Report Generated			The date and time of the export and the user who initiated the export.
Customer Account Information
Customer Account Number			The customer account number associated with the subscription rate plan charge.
Customer Account Name			The name of the company or person that is associated with the subscription rate plan charge.
Customer Account Currency			This is the currency in which your customer will be billed. Each account can be billed only in one currency.
<Customer Account Segments>			If you have configured any segments related to customer accounts, the segment names appear here as column headings. The segments are arranged in alphabetical order. See Fields Supported by Segments for information about which customer account fields are supported on segments.
Transaction Information
Transaction Date			The date when the transaction occurred. Not populated for a revenue schedule based on a custom unlimited revenue rule.
Transaction Type			The type of transaction: Invoice Item Invoice Item Adjustment Credit Memo Item (only available if you enable the Invoice Settlement feature) Debit Memo Item (only available if you enable the Invoice Settlement feature) Not populated for a revenue schedule based on a custom unlimited revenue rule.
Transaction Number			The number for: invoice item invoice item adjustment Credit Memo Item (only available if you enable the Invoice Settlement feature) Debit Memo Item (only available if you enable the Invoice Settlement feature) Not populated for a revenue schedule based on a custom unlimited revenue rule.
Transaction ID			The unique system ID for the transaction, such as an invoice item or invoice item adjustment. Not populated for a revenue schedule based on a custom unlimited revenue rule.
Transaction Amount			The amount of the transaction when currency conversion is not enabled. Not populated for a revenue schedule based on a custom unlimited revenue rule.
Transaction Impact Amount			The amount impacted from the revenue side. This value is often the same as the transaction amount, but can have a different value for invoice item adjustments. For example, if an invoice is generated for $1,000. and then a credit is issued for $500, the Transaction Impact Amount value is -500 and the Transaction Amount is 1000. Not populated for a revenue schedule based on a custom unlimited revenue rule.
Transaction Impact Amount (Transaction Currency)
Transaction Impact Amount (Home Currency)
Transaction Impact Amount Currency Rounding			Rounding difference in the transaction amount. The value of this field equals to: With an inverse rate: `[Transaction Impact Amount (Transaction Currency)] * Exchange Rate - [Transaction Impact Amount (Home Currency)]` With a non-inverse rate: `[Transaction Impact Amount (Transaction Currency)] / Exchange Rate - [Transaction Impact Amount (Home Currency)]` You can reconcile the transaction amount based on the rounding difference.
Transaction Service Period Start			The Transaction Service Period start and end dates are based on the transaction type. For example, for an invoice item, the dates are based on the service start and end dates. Not populated for a revenue schedule based on a custom unlimited revenue rule.
Transaction Service Period End
<Transaction Segments>			If you have configured any segments related to transactions, the segment names appear here as column headings. The segments are arranged in alphabetical order. See Fields Supported by Segments for information about which transaction fields are supported on segments.
Product Information
Product			The product name.
Product Rate Plan			The name of the Product Rate Plan.
Product Rate Plan Charge			The name of the charge associated with the Product Rate Plan.
<Product Segments>			If you have configured any segments related to products, the segment names appear here as column headings. The segments are arranged in alphabetical order. See Fields Supported by Segments for information about which product fields are supported on segments.
Subscription Information
Subscription Rate Plan Charge Id			The original subscription charge ID.
<Subscription Segments>			If you have configured any segments related to subscriptions, the segment names appear here as column headings. The segments are arranged in alphabetical order. See Fields Supported by Segments for information about which subscription fields are supported on segments.
Revenue Schedule Information
Revenue Schedule Date			The effective date of the revenue schedule. For example, the revenue schedule date for bookings-based revenue recognition is typically set to the order date or contract date. Includes only revenue schedules from this accounting period and revenue recognized in this accounting period.
Revenue Schedule			Revenue schedule number. The revenue schedule number is always prefixed with "RS", for example, "RS-00000001".
Revenue Schedule Reference Id			The reference ID associated with revenue schedules based on custom unlimited rules. This optional ID is used to link the revenue schedule to an external transaction or entity. Populated only if the Reference ID was defined when manually creating a revenue schedule from the user interface or through a REST API.
Revenue Schedule Amount			The revenue schedule amount is the sum of all revenue items.
Revenue Schedule Amount (Transaction Currency)
Revenue Schedule Amount (Home Currency)
Revenue Schedule Amount Currency Rounding			Rounding difference in the revenue schedule amount. The value of this field equals to: With an inverse rate: `[Revenue Schedule Amount (Transaction Currency)] * Exchange Rate - [Revenue Schedule Amount (Home Currency)]` With a non-inverse rate: `[Revenue Schedule Amount (Transaction Currency)] / Exchange Rate - [Revenue Schedule Amount (Home Currency)]` You can reconcile the revenue schedule amount based on the rounding difference.
Accounting Code Information
Deferred Revenue Accounting Code			The accounting code for deferred revenue, such as Monthly Recurring Liability.
Deferred Revenue Accounting Code Type			The accounting code type associated with the deferred revenue accounting code, such as Liabilities: Deferred Revenue.
Recognized Revenue Accounting Code			The accounting code for recognized revenue, such as Monthly Recurring Charges or Overage Charges.
Recognized Revenue Accounting Code Type			The accounting code type associated with the recognized revenue accounting code, such as Revenue: B2B Sales.
Foreign Exchange Information
Home Currency			The tenant currency.
Exchange Rate			The exchange rate.
Exchange Rate Date			The date when the exchange rate occurred.
Accounting Period Information
Accounting Period Name			The name of the accounting period, such as Apr 2014 or Jan '15.
Accounting Period Start			The accounting period start date.
Accounting Period End			The accounting period end date.
Recognized Revenue Detail
Recognized in All Accounting Periods			A sum of recognized revenue from all accounting periods: `[Recognized prior to this Accounting Period] + [Recognized in this Accounting Period] + [Recognized after this Accounting Period]` This value often is the same as the Revenue Schedule Amount if it is based on the same currency.
Recognized in All Accounting Periods (Home Currency)
Recognized in All Accounting Periods Currency Rounding			A sum of the rounding difference in the recognized revenue amount from all accounting periods. The rounding difference in recognized revenue amount for an accounting period: With an inverse rate: `[Recognized Revenue Amount in a accounting period] * Exchange Rate - [Accounting Period Name (Home Currency)]` With a non-inverse rate: `[Recognized Revenue Amount in a accounting period] / Exchange Rate - [Accounting Period Name (Home Currency)]` You can reconcile the recognized revenue amount based on the rounding difference.
Recognized prior to this Accounting Period			The total amount of revenue recognized from all accounting periods before the selected accounting period. For example, if selected accounting period is April 2014 and the Revenue Schedule Start Date is January 1, 2014, this value is the sum of recognized revenue from January through March.
Recognized prior to this Accounting Period (Home Currency)
Recognized in this Accounting Period			The amount of revenue recognized in the selected accounting period.
Recognized in this Accounting Period (Home Currency)
Recognized after this Accounting Period			The total amount of revenue recognized from all accounting periods after the selected accounting period plus any undistributed amount reported in the Open-ended period.
Recognized after this Accounting Period (Home Currency)
Accounting Period Name			The revenue detail for each accounting period, where one column represents an accounting period following the selected accounting period. The last column reports any undistributed revenue as Open-Ended accounting period. The export will include all accounting periods available in the future.
Accounting Period Name (Home Currency)