General Ledger Extract Report

Last updated
Save as PDF

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.