Skip to main content
Vindicia Knowledge Center

Invoice Based Revenue Recognition Report

Invoice Based Revenue Recognition Report

This report presents, in CSV form, 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 AutoBill 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.

Invoice Based Revenue Recognition Report Setup

To run the report, go to Reports > Run Report, click the name of the report, and enter From and To dates. Enter an email address if you want to be notified when the report is ready, and click Submit.

To schedule the report, go to Reports > Create Report Schedule, and click the name of the report. Select either once/weekly/monthly/quarterly and enter a Begin the first report period date. Enter an email address if you want to be notified when the report is ready, and click Submit.

Invoice Revenue Recognition Report

The following table describes the fields of the Invoice Based Revenue Recognition Report.

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.

AutoBill Identifier

Merchant AutoBill ID. (Null for one-time Transactions.)

Affiliate ID

ID of the affiliate associated with the AutoBill.

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 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 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 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 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 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 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 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 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 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.

 

Cashbox Features

Learn More
Cashbox Features

For Developers

Learn More
For Developers
Back to Top