Invoice-based Revenue Recognition Report

This report presents a list of invoices that occur between the start dates of weekly, monthly, or quarterly service periods you schedule. For larger reporting periods, you can schedule a one time report and specify a start and end date. The report presents previously recognized, currently recognized, and deferred regular and annualized revenue at the invoice item level. Each row in the report contains the invoice identifier, billing plan, SKU, invoice item, index number and Subscription identifier—and an Affiliate ID if there is one. The service period start and end dates are on the invoice item if it is unique, or on the invoice itself if the invoice item does not have a unique service period date. This report can be generated using Reports 1.0 or Reports 2.0 data engine.

Reports 1.0 data engine	Provides the data you need in the reports up to near real-time. Reports data is displayed in UTC time zone. Reports 1.0 lets you select which display columns to include in the report. Report generation is slow and typically lasts several hours.
Reports 2.0 data engine (default)	Supports 20 most commonly used Subscribe reports. Reports 2.0 operates in UTC time zone. You can select which time zone to use for the report data display. Reports display all the available columns. Data is available for the prior two years and up to the previous day according to UTC time. Report generation is quicker as data is prepared ahead of time, once a day. Note: For a list of reports 2.0, see Subscribe Reports using the Vindicia Data Platform —Reports 2.0

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.
For Reports 2.0, select the relevant Time Zone for data range selection and display. Data is available for the previous day at 13:00 UTC time. Note: A notification error message appears when attempting to run reports for which data is not yet available. The report can be submitted and includes data up to the available time.
Click Submit. View the report in the My Reports page.

To schedule a recurring report:

Toggle Recurring toggle to Yes.
Select a date for the first reporting period. Note: Reports display data occuring 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.
For Reports 2.0, select the relevant Time Zone for data range selection and display.
Optional. If you want to receive the report uploaded to an SFTP Server, enable this option and provide the required details. When enabled, a scheduled report will be uploaded to the specified SFTP Server. The SFTP report follows the <report name>-<frequency>-<timestamp>.csv naming convention where:
- <report name> is the name of the report
- <frequency> is the defined frequency such as monthly, weekly, quarterly, daily or once
- <timestamp> is the format YYYY-MM-DD”T”HH_MI_SS.TZ, where TZ is the timezone offset, for example, 2022-01-27T10_57_02.433174455Z. For this report, the <report name> is invoice_based_revenue_recognition_report.
Note: An email notification is sent if there is an issue in generating or downloading the report on the specified SFTP Server.
Click Submit. The report is submitted and will be generated according to the details provided. If you have provided an email or SFTP details, you will be notified when it is available for viewing.
View the report in the My Reports page.

Display Columns

Note: The report’s display columns order is machine-generated and may therefore change without prior notice.

Field	Description
Invoice Identifier	Merchant Invoice ID. (Null for one-time transactions.)
Billing Plan	Billing Plan ID. (Null for one-time Transactions.)
SKU	Stock keeping unit (SKU) identifier.
Record Type	Invoice or Refund.
Transaction Type	Indicates whether this is a one-time or recurring transaction.
Invoice Date	Creation date of the invoice.
Invoice Status	Current status of the Invoice.
Invoice Item Type	Possible values are RecurringCharge or DiscountBeforeTax or TaxableCredits.
Invoice Item Index Number	For internal use only.
Subscription Identifier	Merchant Subscription ID. (Null for one-time Transactions.)
Affiliate ID	ID of the affiliate associated with the Subscription.
Service Period Start	Start date of the service period specified.
Service Period End	End date of the service period specified.
Currency	The currency used for this invoice.
Pre-tax Total	Pre-tax total of the invoice item. Note that this is negative for invoice item type discounts, taxable credit and refunds.
Number of Days in Service Period prior to Accounting Period	This field is: - (Accounting period start date - Service period start date) if Service period start date < Accounting period start date - (0) if Service period start date >= Accounting period start date Note: Note that in (Accounting period start date - Service period start date) Service period is inclusive. For example, if Service Period Start date is March 25th, and Accounting period Start is April 1st, (Accounting period start date - Service period start date) = (April 1st - Mar 25th) = 6 days.
Revenue Previously Recognized—Annualized	(Recognized revenue in previous periods for one-time transactions is zero.) For Invoices of recurring transactions, this is ((pre-tax total/365.25) * number of service periods in a year * number of applicable days before Accounting Period start date). “Number of applicable days before accounting period start date” is calculated as above. Note that for discounts, taxable credits and refunds, this is a negative number.
Number of days in Service Period within the Accounting Period	This is calculated as follows: - (accounting period end date - accounting period start date) if service start date <= accounting period start date and service end date >= accounting period end date. Note that both accounting period start and end dates are inclusive. - (service period end date - service period start date) if service start date < accounting period start date and service end date < accounting period start date Note: Note that both service period start and end dates are inclusive. - • (service period end date - accounting period start date) if service start date <= accounting period start date and service end date <= accounting period end date and service end date >= accounting period start date Note: Note that accounting period start date and service period end dates are inclusive. - • (accounting period end date - service period start date) if service start date >= accounting period start date and service start date <= accounting period end date and service end date >= accounting period end date Note: Note that both accounting period end date and service period start date are inclusive. - • (service period end date - service period start date) if service start date >= accounting period start date and service end date <= accounting period end date. Note: Note that both service period end date and service period start dates are inclusive. - 0 (zero) if service start date > accounting period end date and service end date > accounting period end date
Revenue Recognized in this period—Annualized	Recognized Revenue for one-time transactions is the same as the subtotal * quantity For Invoices for recurring charges this is calculated as follows: ((Pre-tax total/365.25) * number of service periods in a year * number of applicable days within the accounting period) Number of applicable days within the Accounting period is calculated as above. Note: Note that this field is a negative number for refunds, discounts and taxable credits.
Revenue Recognized in this period	Recognized Revenue for one-time transactions is the same as the subtotal * quantity For recurring transactions, this is ((amount/service period) * number of applicable days within the accounting period).
Number of days in Service Period post Accounting Period.	Number of applicable days after the accounting period is calculated as follows: (service period end date - accounting period end date) if service period end date > accounting period end date and service period start date <= accounting period end date. (Service period end date - service period start date) if billing period end date > accounting period end date and billing period start date > accounting period end date. Note: Note that service period end date and service period start date are inclusive
Deferred Revenue—Annualized	Deferred revenue for one-time transactions is 0 (zero). For Invoices, deferred revenue is calculated as follows: ((pre-tax total/365.25) * number of service periods in a year * number of applicable days after the accounting period). The number of applicable days after the accounting period is calculated in the same way. Note: Note that for discounts, taxable credits, and refunds this must be a negative number.
Deferred Revenue	Deferred revenue for one-time transactions is 0 (zero). For recurring transactions, deferred revenue is ((amount/service period) * number of applicable days within the accounting period). Number of applicable days within the accounting period is calculated in the same way. Note: Note that for discounts, taxable credits, and refunds this is a negative number. Note also that if service periods are not present for recurring transactions (for whatever reason), these recurring transactions are treated like one-time transactions.
Parent topic:Finance Reports

Home

Guides

APIs

To generate a one time report:

To schedule a recurring report:

Display Columns

​To generate a one time report:

​To schedule a recurring report:

​Display Columns

To generate a one time report:

To schedule a recurring report:

Display Columns