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