Report Column Reference | TTG Developer Portal

This page describes every column that can appear in a custom report. Not all columns appear in every report — the visible columns depend on your chosen grouping (by ticket, by performance, or by transaction date).

Identification columns

These columns appear in by-ticket reports and identify the specific order.

Column	Description
Confirmation	Unique order confirmation number. Prefix indicates the source system — `T` for TTG-processed transactions, `SPX` for legacy Spectrex transactions.
Showtime	Performance date and time for this ticket.
Transaction Date	Date the charge or refund was processed. For refunds, this is the refund date, not the original sale date.
Section	Seating section (e.g. Front Stalls, Rear Stalls).
Row	Seat row identifier.
Seat	Seat number.

Transaction metadata

Column	Description
Payment Type	How the ticket was paid for. See Payment types below.
Retailer	The retailer (e.g. ticket agent) that made the sale — such as PxT Primary or a third-party retailer.
Mode of Sale	Sales channel — typically “Web” for online sales.
Ticket Status	Current status: Sold or Returned. Returned tickets have negative financial values.

Revenue columns

These columns trace the path from gross revenue to net revenue.

Column	Description
Gross Revenue	Face value of the ticket before any deductions. For refunds, this is negative.
Total Commission	Commission amount in currency, calculated from the commission rate.
Commission %	The commission rate applied to this transaction. Rates vary by retailer and may differ for promotional tickets.
Gross Less Agency / Sales Tax	Gross revenue minus the agency commission and sales tax.
Sales Tax	VAT or sales tax calculated on the gross revenue.
Net Revenue	Revenue after commission and sales tax have been deducted.

Fee deduction columns

These columns list individual fees deducted from the gross. All fees are listed separately for full transparency.

Column	Description	Notes
Ticket Charge	A fixed per-ticket charge.	Applies to legacy transactions only.
Website Fee	The tick fee — a per-ticket charge for online sales.	Applies to legacy transactions only.
PxT Fee	The Powered by TTG platform fee.	Applies to all PxT-processed transactions.
Printing Fee	A per-ticket printing surcharge.	Applies to legacy transactions only.
Restoration Levy	Building restoration contribution, if applicable.	Currently zero for most shows.
Credit Card Fee	Card processing fee.	Applies to legacy transactions only. Present for historical Spectrex-migrated data.

For current PxT-processed transactions, the PxT Fee is typically the only active deduction column. The other fee columns (Ticket Charge, Website Fee, Printing Fee, Credit Card Fee) contain data from legacy systems and apply only to historical transactions.

Summary columns

These columns appear at the end of each row and show the final position after all deductions.

Column	Description
Gross Deductions	Sum of all fee deductions (Ticket Charge + Website Fee + PxT Fee + Printing Fee + Restoration Levy + Credit Card Fee).
Gross After Deductions	Gross revenue minus all deductions.
Net After Deductions	The final net amount after all commissions, taxes, and fees. This is the amount that matters for settlement.
VAT After Deductions	VAT calculated on the net after deductions.

Reading the totals

Reports grouped by transaction date or by performance include summary rows at the bottom:

Row	Meaning
Total — Transactions	Sum of all sales in the report
Total — Refunds	Sum of all refunds (shown as negative values)
Transactions net of refunds	Net position: total sales minus total refunds

Payment types

The payment type column reflects how the customer paid for the ticket.

Payment Type	Description
Credit card	Standard card payment processed through TTG.
Voucher	Payment made using a voucher or gift token.
Account	Payment via the retailer’s account credit. Typically used by external retailers reporting sales on account.
Agent	Direct retailer sale.
Agent Invoice	Group sales processed via Agent Invoice — often at a different commission rate.
MX / Mastercard / Visa	Card-type-specific payments. These appear on legacy Spectrex-migrated transactions only and are not used for new PxT sales.
External	Sales made via distribution partners (e.g. kiosk sales). Treated the same as standard TTG sales for reporting purposes.

Legacy payment types (MX, Mastercard, Visa) correspond to card merchant relationships from the previous ticketing system. All new PxT transactions use the generic “Credit card” type. You can distinguish legacy from current transactions by the confirmation number prefix: SPX for legacy, T for TTG.

Next steps

Understanding Report Output — how the reports look when delivered
Creating Reports — build a new report
Invoicing — sending invoices to retailers