To Download your General Ledger you will want to go to your Event Payment page. You can get there by clicking the Event Balance box on the dashboard.
On that page, scroll to the bottom where you see the "Download General Ledger" panel. Here you will see a few options to make sure you get the information you want to include.
When downloading your event's transaction data, you will receive a CSV file with the following columns:
Date | The date the transaction occurred in format MM/DD/YYYY. |
Time | The time the transaction occurred in 24hr format HH:MM:SS. |
Time Zone | Time zone of the transaction. |
Transaction ID | A unique ID for the transaction. |
Transaction Type |
|
Currency | The currency associated with the transaction's amounts. |
Gross |
|
Fee | Total fees charged to the event for this transaction. |
Net | The net amount of the transaction credited or debited to the event. |
Balance | The event balance after this transaction. |
Sales Tax | Sales tax collected on behalf of the event and remitted to state and local agencies. |
Confirmation Number | The confirmation number of the sale/refund. A confirmation number can have many associated transactions. All transactions completed in the same checkout will have the same confirmation number. |
Item Description | The item that the transaction is related to. Registrations will be the category name and merchandise will be the merchandise item name. |
Item ID | A unique ID for the item associated with the transaction. |
Entry ID | The ID of the entry associated with the transaction. |
Participant Name | The name of the participant associated with the associated entry. |
Payment ID | The ID of the event payment. Only relevant to event payment transactions. |
Quantity | How many units of the item were sold/affected by the transaction. |
Balance Impact | Credit when funds are being added to the event balance, or Debit when funds are being deducted from the event balance. |
Site Name | The website the transaction was completed on. |
Event ID | The Event ID the transaction was completed in. |
Event Name | The name of the event the transaction was completed in. |
Original Item Cost | The original per item cost before any discounts are applied. |
Amount Discounted Coupon | The amount discounted from the original cost by a coupon. |
Amount Discounted Multi-Entry | The amount discounted from the original cost by a multi-entry discount. For example, registering for two categories within the same event. |
Coupon Code | The coupon applied to the transaction. |