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:

  1. Enter the date range
  2. Optional. Enter an Email address where you'd like to receive notifications when the report is available. A single email address can be entered.
  3. 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.
  4. Click Submit

To generate a recurring report:

  1. Toggle Recurring toggle to Yes.
  2. 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.
  3. Select the report's Frequency. Choose between Weekly, Monthly or Quarterly.
  4. Optional. Enter an Email address where you'd like to receive notifications when the report is available. A single email address can be entered.
  5. 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.
  6. Optional. If you want to receive the report uploaded to an SFTP Server, enable this option and provide the required details.
  7. Click Submit
Table 1. Summary Display Columns
Field Description
Accounting Period StartThe start date of the accounting period.
Accounting Period EndThe end date of the accounting period.
Report Run DateThe date and time the report was run.
Recognition RateDaily.
Billing PlanThe Billing Plan ID (null for one time transactions).
SKUThe product Stock Keeping Unit (SKU) ID.
CurrencyThree letter ISO code for the currency used in the Transaction.
Record TypeTransaction or Refund.
Revenue Previously RecognizedRevenue recognized from a previous accounting period.
Revenue Recognized in this periodTotal revenue recognized in the specified accounting period.
Deferred RevenueRevenue deferred to a later accounting period.
Table 2. Detail Display Columns
FieldsDescription
Transaction Identifier Transaction ID of this particular transaction item.Transaction ID of this particular transaction item.
Billing PlanBilling Plan associated with the transaction item (null for one time transactions).

SKU

Product associated with the transaction item.
Record TypeEither Refund or Transaction.
Transaction TypeType of Transaction, for example a onetime transaction, recur- ring transaction, and so on. Tokens are not included in revenue recognition.
Transaction DateDate when the Transaction occurred.
DispositionThe current status of the transaction (Captured or Refunded).
Transaction Item TypeThis indicates whether this transaction item type is a purchase,
Index NumberIndex number of the Transaction Item in the Vindicia database.
Subscription IdentifierSubscription ID if the transaction is part of a subscription—NULL if this is a one time transaction.
Service Period Start DateIf 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.
CurrencyThree letter ISO code for the currency in which the original transactions were charged.
Pre-Tax TotalTotal charge before tax for this transaction item.
Revenue Previously RecognizedFor 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 RevenueRevenue to be recognized for a particular transaction item in future accounting periods. For one-time transactions this field shows zero (0).
Accounting Period StartThe start date of the accounting period.
Accounting Period EndThe end date of the accounting period.
Report Run DateThe date and time the report was run.