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. To generate a one time report:

Enter the relevant date range.
Optional. Enter an Email address where you’d like to receive notifications when the report is available.
Click Submit. View the report in the My Reports page.

To generate a recurring report:

Toggle Recurring toggle to Yes.
Select a date for the first reporting period. The same date format will be used for future scheduled reports Note: Reports display data occurring starting from the defined date. For example, a monthly report starting on March 1st displays data for the month of March up to March 31st.
Select the report’s Frequency. Choose between Weekly, Monthly or Quarterly.
Optional. Enter an Email address where you’d like to receive notifications when the report is available. A single email address can be entered.
Optional. If you want to receive the report uploaded to an SFTP Server, enable this option and provide the required details.
Click Submit. View the report in the My Reports page.

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.
Parent topic:Finance Reports

Home

Guides

APIs

Display Columns

​Display Columns

Display Columns