Knowledge Center

Knowledge Center > Finance > Revenue Recognition > Accounting Period Revenue Detail > Revenue Detail Exported Data Descriptions

Revenue Detail Exported Data Descriptions

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 File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png The name for the selected accounting period.
Period File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png The accounting period date range.
Home Currency   File:Z_Media/checkmarkGreen_xsm.png The tenant currency.
Deferred Revenue Account File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png The name of the deferred revenue accounting code name for the selected worksheet. 
Deferred Revenue Account Type File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png The accounting code type associated with the deferred revenue accounting code for the selected worksheet.
Report Generated File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png The date and time of the export and the user who initiated the export.
Customer Account Information
Customer Account Number File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png The customer account number associated with the charge.
Customer Account Name File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png The name of the company or person that is associated with the charge.
Customer Account Currency File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png This is the currency in which your customer will be billed. Each account can be billed only in one currency.

<Customer Account Segments>

File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png

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 File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png The date when the transaction occurred.

Not populated for a revenue schedule based on a custom unlimited revenue rule.

Transaction Type File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png The type of transaction, such as an invoice item or invoice item adjustment.

Not populated for a revenue schedule based on a custom unlimited revenue rule.

Transaction Number File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png The number for the invoice item or invoice item adjustment, such as INV01234567.

Not populated for a revenue schedule based on a custom unlimited revenue rule.

Transaction ID File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png 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 File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png 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

File:Z_Media/checkmarkGreen_xsm.png  

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)   File:Z_Media/checkmarkGreen_xsm.png
Transaction Impact Amount (Home Currency)   File:Z_Media/checkmarkGreen_xsm.png
Transaction Impact Amount Currency Rounding   File:Z_Media/checkmarkGreen_xsm.png

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 an 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 File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png 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 File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png

<Transaction Segments>

File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png

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 File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png The product name.
Product Rate Plan File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png The name of the Product Rate Plan.
Product Rate Plan Charge File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png The name of the charge associated with the Product Rate Plan.

<Product Segments>

File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png

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 File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png The original subscription charge ID.

<Subscription Segments>

File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png

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 File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png

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

File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png

Revenue schedule number. The revenue schedule number is always prefixed with "RS", for example, "RS-00000001".

Revenue Schedule Reference Id File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png

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 File:Z_Media/checkmarkGreen_xsm.png   The revenue schedule amount is the sum of all revenue items.

Revenue Schedule Amount (Transaction Currency)

  File:Z_Media/checkmarkGreen_xsm.png
Revenue Schedule Amount (Home Currency)   File:Z_Media/checkmarkGreen_xsm.png
Revenue Schedule Amount Currency Rounding   File:Z_Media/checkmarkGreen_xsm.png

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 an 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 File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png 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 File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png The accounting code for recognized revenue, such as Monthly Recurring Charges or Overage Charges.
Recognized Revenue Accounting Code Type File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png The accounting code type associated with the recognized revenue accounting code, such as Revenue: B2B Sales.
Foreign Exchange Information
Home Currency   File:Z_Media/checkmarkGreen_xsm.png The tenant currency.
Exchange Rate   File:Z_Media/checkmarkGreen_xsm.png The exchange rate.
Exchange Rate Date   File:Z_Media/checkmarkGreen_xsm.png The date when the exchange rate occurred.
Accounting Period Information
Accounting Period Name File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png The name of the accounting period, such as Apr 2014 or Jan '15.
Accounting Period Start File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png The accounting period start date.
Accounting Period End File:Z_Media/checkmarkGreen_xsm.png File:Z_Media/checkmarkGreen_xsm.png The accounting period end date.
Recognized Revenue Detail
Recognized in All Accounting Periods File:Z_Media/checkmarkGreen_xsm.png   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)   File:Z_Media/checkmarkGreen_xsm.png
Recognized in All Accounting Periods Currency Rounding   File:Z_Media/checkmarkGreen_xsm.png

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 an 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 File:Z_Media/checkmarkGreen_xsm.png   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)   File:Z_Media/checkmarkGreen_xsm.png
Recognized in this Accounting Period File:Z_Media/checkmarkGreen_xsm.png   The amount of revenue recognized in the selected accounting period.
Recognized in this Accounting Period (Home Currency)   File:Z_Media/checkmarkGreen_xsm.png
Recognized after this Accounting Period File:Z_Media/checkmarkGreen_xsm.png   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)   File:Z_Media/checkmarkGreen_xsm.png

Accounting Period Name

File:Z_Media/checkmarkGreen_xsm.png   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)

  File:Z_Media/checkmarkGreen_xsm.png

 

Last modified
23:03, 20 Mar 2017

Tags

Classifications

(not set)