Skip to main content
Vindicia Knowledge Center

General Ledger Extract Report

The General Ledger Extract report provides a comprehensive view of data for use in sub-ledger entry or pre-entry activities to your external GL. The report can be run and downloaded on demand, or scheduled and automatically emailed as an attachment.

Enter desired parameters, select the information you want displayed, and click Submit  to generate the report.

Display Columns
Field Description
Report Run Date Date the report ran.
Accounting Period Start Date Period start date for which this report is run.
Accounting Period End Date Period end date for which this report is run.
Invoice Identifier Unique identifier for the invoice.
Customer ID  Unique identifier for the customer.
Subscription Identifier Unique identifier  of the Subscription for which the invoice is generated.
Affiliate ID  Affiliate ID associated with the Subscription—indicates the sub group within the merchant.
Transaction ID Transaction identifier—if a transaction exists for an invoice.
Refund ID 

Unique identifier for a refund. This data is present only for Refund rows. (If a Paid Invoice has been refunded, the refund identifier is not populated for that Invoice.)

Billing Plan  Billing Plan of the Subscription.
SKU Stock Keeping Unit information.
Invoice Date  Due date for the invoice.

Transaction Date/Refund Date

Transaction date for the transaction, Refund Date for a refund.

Record Type

Indicates the type of data shown in a particular row. Possible values include: Invoice, Invoice Item, Transaction Item, One-time purchase, Refund. Record Type indicates the type of data shown in a particular row.

Invoice Status

Current status of the invoice. Possible values include: Open, Due, Overdue, Paid, Written Off, Canceled, Free.

Transaction Type

Type of transaction if transaction info exists for this row or if the row is showing onetime or Refund information. Possible values: Recurring, One-time, Refund, NULL, Partial Payment.

Transaction Status

Shows status of Transaction and Transaction Items, if showing transaction information in this row of the report.

Also shows transactions whose status has changed (for example from Authorized Pending to Canceled) in a given accounting period.

Invoice Item Type

Type of the Invoice Item if the row corresponds to an Invoice Item. Possible values include: Recurring Charge, Nonrecurring Charge, Tax, Credit, DiscountBeforeTax, TaxableCredit.

Campaign Description/Credit Reason/Refund Note/MAP Payment Note

This field will contain one or more of the following: description of the Campaign; reason credit was granted; a note about the refund; a note about the MAP.

Invoice Item Index Number

For internal use only. 

Transaction Item Type

Type of the corresponding transaction item if applicable. Possible values include: Purchase, Discount, Credit, TaxableCredit, Tax.

Service Period

Indicates whether the plan is Monthly, Quarterly, Bi-annual or Annual.

Service Period Start

Start date of the Service Period for the invoice.

Service Period End

End date of the Service Period for the invoice.

Payment Type

Type of payment if payment has been made, for example credit card, PayPal, MAP, and so on.

Tax Level

If this is a taxable item, then city, county, state, and so on.

Currency

Currency code of the payment.

Invoice Amount

Amount of the invoice item.

Invoice Subtotal

Subtotal of the invoice—only present for invoice rows.

Invoice Tax

Total tax amount for the invoice—present only at the invoice level.

Invoice Balance

Balance remaining on an invoice (to be paid)—present only at the invoice level.Total Credits

Total Credits

Total credits on the invoice—present only at the invoice level.

Total Discounts

Total discounts on the invoice—present only at the invoice level.

Transaction Amount

Amount of the transaction/transaction item.

Transaction Subtotal

Amount of the transaction before tax.

Transaction Tax

Total tax of the transaction—present only for invoice rows where the invoice is paid.

Refund Amount

Total amount of the refund—present only for invoice rows if the invoice has a transaction

associated that has been refunded.

Refund Sub-total

Subtotal portion of the refund.

Refund Tax

Tax portion of the refund.

Number of Days in Service Period prior to Accounting Period

This field is calculated as follows:

* 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: In (Accounting period start date - Service period start date), the Service period

start date is inclusive. For example, if the 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.

Invoice Revenue Previously Recognized

This is ((Invoice amount/service period) * number of applicable days before Accounting Period start date).

“Number of applicable days before accounting period start date” is calculated as described in Number of Days in “Service Period prior to Accounting Period” in the row above in this table.

Transaction Revenue Previously Recognized

Recognized Revenue in previous periods for one-time transactions is "zero".

For recurring transactions, this is ((amount/service period) * number of applicable days before Accounting Period start date). “Number of applicable days before accounting period start date” is calculated as above.

Number of days in Service Period within the Accounting Period

Number of applicable days within the Accounting period is calculated as:

(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: 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: 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: 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: 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: both service period end date & service period start dates are inclusive.

'0' if service start date > accounting period end date and service end date > accounting period end date

Invoice Revenue Recognized in this period

This is ((amount/service period) * number of applicable days within the accounting period).

Number of applicable days within the accounting period is calculated as above.

Transaction 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 applicable days within the accounting period is calculated as above.

Number of days in Service Period post Accounting Period

Number of applicable days after the accounting period is calculated as:

(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: both Service period end date - service period start date are inclusive.

Invoice Deferred Revenue

Deferred revenue is ((amount/service period) * number of applicable days after the accounting period). The number of applicable days after the accounting period is calculated as above.

Transaction Deferred Revenue

Deferred revenue for one-time transactions is '0' (in 1.0 version of report).

For recurring transactions, deferred revenue is ((amount/service period) * number of applicable days after the accounting period). The number of applicable days after the accounting period is calculated as above.

Invoice Earned Revenue by the end of the Accounting Period

This is Revenue Previously Recognized + Revenue recognized in this period.

Transaction Earned Revenue by the end of the Accounting Period

This is Revenue Previously Recognized + Revenue recognized in this period.