Transaction-based Revenue Recognition Report

This report lists revenue recognized during a time period you specify. It enables you to break up total revenue into useful categories such as Accounts Receivables, Earned, Recognized, Deferred and so on, at a Billing Plan and SKU level. To generate a one time report:

Enter the date range
Optional. Enter an Email address where you’d like to receive notifications when the report is available. A single email address can be entered.
Select from the following:
- Summary report format. See the table below listing the report’s columns.
- Detailed report format. See the table below listing the report’s columns.
Click Submit

To generate a recurring report:

Toggle Recurring toggle to Yes.
Select a date for the first reporting period. The same date format will be used for future scheduled reports Note: Reports display data occurring starting from the defined date. For example, a monthly report starting on March 1st displays data for the month of March up to March 31st.
Select the report’s Frequency. Choose between Weekly, Monthly or Quarterly.
Optional. Enter an Email address where you’d like to receive notifications when the report is available. A single email address can be entered.
Select from the following:
- Summary report format. See the table below listing the report’s columns.
- Detailed report format. See the table below listing the report’s columns.
Optional. If you want to receive the report uploaded to an SFTP Server, enable this option and provide the required details.
Click Submit

Field	Description
Accounting Period Start	The start date of the accounting period.
Accounting Period End	The end date of the accounting period.
Report Run Date	The date and time the report was run.
Recognition Rate	Daily.
Billing Plan	The Billing Plan ID (null for one time transactions).
SKU	The product Stock Keeping Unit (SKU) ID.
Currency	Three letter ISO code for the currency used in the Transaction.
Record Type	Transaction or Refund.
Revenue Previously Recognized	Revenue recognized from a previous accounting period.
Revenue Recognized in this period	Total revenue recognized in the specified accounting period.
Deferred Revenue	Revenue deferred to a later accounting period.

Fields	Description
Transaction Identifier Transaction ID of this particular transaction item.	Transaction ID of this particular transaction item.
Billing Plan	Billing Plan associated with the transaction item (null for one time transactions).
SKU	Product associated with the transaction item.
Record Type	Either Refund or Transaction.
Transaction Type	Type of Transaction, for example a onetime transaction, recur- ring transaction, and so on. Tokens are not included in revenue recognition.
Transaction Date	Date when the Transaction occurred.
Disposition	The current status of the transaction (Captured or Refunded).
Transaction Item Type	This indicates whether this transaction item type is a purchase,
Index Number	Index number of the Transaction Item in the Vindicia database.
Subscription Identifier	Subscription ID if the transaction is part of a subscription—NULL if this is a one time transaction.
Service Period Start Date	If this transaction is part of a subscription service, this field shows the corresponding service period start date for this transaction. For a one-time transaction this column shows the transaction date.
Currency	Three letter ISO code for the currency in which the original transactions were charged.
Pre-Tax Total	Total charge before tax for this transaction item.
Revenue Previously Recognized	For recurring transactions, the sum of revenue recognized for a transaction item in previous accounting period (for billings still in flight in this period). For one time transactions, this field is always zero (0).
Revenue Recognized In current period.	Revenue recognized for a particular transaction item in this accounting period. For one time transactions, this is the entire subtotal of the transaction.
Deferred Revenue	Revenue to be recognized for a particular transaction item in future accounting periods. For one-time transactions this field shows zero (0).
Accounting Period Start	The start date of the accounting period.
Accounting Period End	The end date of the accounting period.
Report Run Date	The date and time the report was run.
Parent topic:Transaction Reports

Home

Guides

APIs