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

wiki.page{path: "/z_Source/RevRecFD", heading: "1", section: "rs-number"}

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)