Skip to main content

All Transactions Report

Written by Ariane Ramirez
Updated over 2 weeks ago

This feature is available for Enterprise and White Label Plans

This feature is still in BETA. We’re excited to release this functionality in our public beta. During the beta phase, some behaviors described here may still change as we continue improving the feature. Stay tuned for updates.

Download a History of All Transactions

The All Transactions Report is a downloadable CSV report in the Enterprise / White Label dashboard that includes all transactions under your account.

Each row represents a transaction history, and not a per item tracking. This will include transactions from all your events under your Enterprise or White Label account.

When Will a Line Item Generate in the CSV

1. New Order

  • A line item will generate when a new order is created, regardless of what is in the order and payment method (e.g. if it's a free order or paid by card, or invoiced - it will show in the CSV).

  • Only 1 line will be generated regardless of how many items there are in the order as this is only 1 transaction. (e.g. they buy 2 tickets + 2 add ons + 1 bundle - it will show as 1 line)

2. New Payment in an Existing Order

  • A line item will generate if a credit card payment is received for an existing order

    • Partial or full payment for the balance if they were initially invoiced

    • Partial or full payment for the balance if they initially paid for the deposit only

    • Payment for the balance if they exchange the ticket to a higher priced ticket

    • Payment for additional items in the order

  • A line item in the CSV will generate if the existing order is marked as paid or payment is applied

    • Received full payment externally and Marked as Paid

    • Received partial or full payment externally and the payment is posted through Apply / Adjust Payment

3. Ticket Exchanges without payment movement

An exchange without an additional payments or refunds is still considered a transaction so a line item should generate.

  • A line item will generate if the ticket is exchanged to a higher priced ticket and the payment type for the exchange is invoice or complimentary

  • A line item will generate if the ticket is exchanged to a lower priced ticket and no refund is issued

  • A line item will generate if the ticket is exchanged to a same priced ticket

4. Full or Partial Refunds

  • A line item in the CSV will generate if an order or an item in the order is partially or fully refunded

    • If multiple items are refunded in one submission, it will generate 1 line item.

    • If multiple items are refunded but submitted separately, it will generate 1 line item per submission.

  • No line item will be created if an order or an item in the order is canceled without partial or full refund or is deleted without refunding

Note: Failed payment will not be recorded in this report

All Transaction Columns

Column Header

Description

1

ID

Number that indicates the chronology of transactions

2

Event Title

Event Name

3

Event Billing ID

This is the value you add in Settings > Payment Processing > Event Billing ID. If you have billing codes within your organization, you can add them to that field, and they can appear in the transaction within your payment processor.

4

Full Name

Buyer's first name and last name

5

Email Address

Buyer's email address

6

Order Number

Order Number

7

Order Date

The date and time when the order is created

8

Order Type

This is the payment type for the order:

  • CASH

  • CARD

  • PAY_LATER

  • UNPAID

  • COMPLIMENTARY

  • EXTERNAL_TRANSACTION (for CSV and Integration imports)

9

Ticket Price

If the transaction is a new order, this will show the total base price of all tickets in the order

If the transaction is for an exchange, this is the price of the new ticket.

If the transaction is for additional items in the order, this will show the total base price of all the new items in the order.

If the transaction is for a refund, this is the total base price of the items refunded.

10

Tech Fees

TBA

11

Credit Card Fees

This will show the credit card fees if the fees are passed to buyer

12

Service Fee

This will show Accelevents ticketing fees if the fees are passed to buyer and if applicable to your events.

13

Sales Tax

This will show the sales tax if the event has sales tax

14

VAT

This will show the vat if the event has vat

15

Total

This will show the total amount paid in the transaction

16

Refund Amount

This will show the total amount refunded in the transaction

17

Transaction Type

This will show whether the transaction is for a new order, a new payment in the existing order or a refund.

  • PURCHASE when a new Order is created

  • PAYMENT when the balance for the invoice is paid, or when new items are added to the order

  • REFUND when a partial or full refund is applied

18

Payment Method

This is the payment type for the transaction. So if an order was invoiced, the line item's payment method is PAY_LATER. When the balance is paid, the next line item's payment method is CASH or CARD, depending on how it was paid.

19

Successful

This would show Yes or No if the transaction is successful

20

Transaction ID

This is the generated transaction id when transaction go through a payment processor

21

Transaction Date

The date and time when the transaction occurred

22

Amount Applied

This is the total amount in the transaction, it can be a payment or a refund.

23

Event Start Date

Event Start Start Date

24

Event Month

Event Month

25

Event Year

Event Year

26

Metadata 1

This is the value you add in Settings > Payment Processing > Metadata. If you have billing codes within your organization, you can add them to that field, and they can appear in the transaction within your payment processor.

Did this answer your question?