> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.todaytixgroup.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.todaytixgroup.com/_mcp/server.

# Report Column Reference

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](#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. |

<Note>
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.
</Note>

## 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. |

<Note>
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.
</Note>

## Next steps

- [Understanding Report Output](/partner-portal/understanding-report-output) — how the reports look when delivered
- [Creating Reports](/partner-portal/creating-custom-reports) — build a new report
- [Invoicing](/partner-portal/invoicing) — sending invoices to retailers