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

Accounting Period Start Date The start date of the accounting period. 
Accounting Period End Date The end date of the accounting period. 
Affiliate ID ID of the affiliate associated with the AutoBill.
Customer ID Merchant Customer ID.
AutoBill Identifier Merchant AutoBill ID. (Null for one-time Transactions.)

Invoice Identifier

Merchant Invoice ID. (Null for one-time transactions.)

Billing Plan

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

Invoice Item Index Number For internal use only.

SKU

Stock keeping unit (SKU) identifier. 

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. Possible values include the following: 

  • Open
  • Due
  • Overdue
  • Paid

Invoice Item Type

Possible values are RecurringCharge or DiscountBeforeTax or TaxableCredits.

Service Period Start

Start date of the service period specified.

Service Period End

End date of the service period specified.

Stop Date Date within the Service Period that an AutoBill line item was removed.

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

(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

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

Report Run Date The date the report was run.

 

Cashbox Features

Learn More
Cashbox Features

For Developers

Learn More
For Developers
Back to Top