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 engineProvides 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:

  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. 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.
  4. Click Submit.

    View the report in the My Reports page.

To schedule a recurring report:

  1. Toggle Recurring toggle to Yes.
  2. 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.
  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. For Reports 2.0, select the relevant Time Zone for data range selection and display.
  6. 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.
  7. 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.

  8. 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.
FieldDescription
Invoice IdentifierMerchant Invoice ID. (Null for one-time transactions.)
Billing Plan

Billing Plan ID. (Null for one-time Transactions.)

SKUStock keeping unit (SKU) identifier.
Record TypeInvoice or Refund.
Transaction TypeIndicates whether this is a one-time or recurring transaction.
Invoice DateCreation date of the invoice.
Invoice StatusCurrent status of the Invoice.
Invoice Item TypePossible values are RecurringCharge or DiscountBeforeTax or TaxableCredits.

Invoice Item Index

Number

For internal use only.
Subscription IdentifierMerchant Subscription ID. (Null for one-time Transactions.)
Affiliate IDID of the affiliate associated with the Subscription.
Service Period StartStart date of the service period specified.
Service Period EndEnd date of the service period specified.
CurrencyThe currency used for this invoice.
Pre-tax TotalPre-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.