TicketingHub Transaction Reports: Guide to All 13 Financial Exports

TicketingHub's Transaction Reports section gives you 13 downloadable CSV exports covering bookings, vouchers, merchandise, payments, refunds, unallocated payments, and OTA channel transactions. This guide explains what each report contains, when to use it, and how date filters affect your results.

🌐 All date and time values in exported CSV files are in UTC.

Accessing Transaction Reports

Navigate to Reports → Transaction Reports in your TicketingHub dashboard. Select a date range using the date picker, then click Download next to the report you need. All reports export as CSV files compatible with Microsoft Excel, Google Sheets, and most accounting software.

Understanding Key Concepts

Transaction Date vs. Reporting Date

Several reports are available in two date-filtered variants:

• Transaction Date — filters by when the booking or order was created in the system. Use this for day-to-day sales monitoring and cash-based reporting.
• Reporting Date — filters by when each individual financial transaction event was recorded (e.g. when a payment, refund, or adjustment was processed). This date may differ from the original booking date. Use this for accrual-based accounting and reconciliation against your accounting software.

Example: A booking created on 1 March may have a payment processed on 3 March and a refund on 15 March. A Reporting Date filter for March captures all three events. A Transaction Date filter for 1 March returns only the booking itself.

Summary vs. Detail Reports

• Summary reports return one aggregated row per booking, voucher, or purchase — totals only.
• Detail reports return one row per individual transaction event — the full audit trail.

Booking Reports

Booking Transaction Summary (Transaction Date)

Shows the total financial values per booking, based on transactions that occurred within the selected date range.

Best used for:

• Cash flow snapshots: End-of-day or end-of-week revenue summaries
• Period reconciliation: Quick totals for bookings made during a specific window
• Management reporting: Revenue overview without line-by-line detail

Booking Transaction Summary (Reporting Date)

Shows the total financial values per booking, filtered by the date each financial transaction event was recorded.

Best used for:

• Monthly reporting: Align revenue to when financial events were recorded
• Accrual accounting: Reconcile TicketingHub data with your accounting software
• Period close: Quarterly or annual financial statement preparation

Booking Transaction Detail (Transaction Date)

Shows every individual transaction line for bookings created within the selected date range — including payments, refunds, adjustments, and fees.

Best used for:

• Gateway reconciliation: Match transactions against payment processor statements
• Booking audits: Full financial history of any individual booking
• Refund investigation: Trace every charge and refund processed in a period

Booking Transaction Detail (Reporting Date)

Shows every individual transaction line, filtered by when each financial event was recorded.

Best used for:

• Accrual audit trail: Line-level detail aligned to revenue recognition dates
• Month-end close: Full transaction breakdown where recording date is the reference point
• Accountant submissions: Granular data for deferred revenue reconciliation

Booking Transaction Sales Reports

Booking Transaction Sales (Transaction Date)

Shows the total financial values per booking and per pricing tier, based on transactions that occurred within the selected date range.

Best used for:

• Tier analysis: Understand which ticket types (adult, child, group) are driving revenue
• Commission calculation: Tier-based breakdowns for agent or reseller payments
• Sales performance: Revenue contribution by pricing category

Booking Transaction Sales (Reporting Date)

Shows the total financial values per booking and pricing tier, filtered by when each financial transaction was recorded.

Best used for:

• Accrual tier reporting: Revenue by pricing category aligned to recording date
• Monthly breakdowns: Ticket type performance for specific financial periods

Voucher Reports

Voucher Booking Transaction Summary

Shows the total financial values per voucher booking, based on transactions that occurred within the selected date range.

Best used for:

• Voucher revenue overview: Consolidated gift voucher and prepaid voucher totals
• Period reconciliation: Voucher activity separated from standard booking revenue

Voucher Booking Transaction Detail

Shows every individual transaction line for voucher bookings that occurred within the selected date range.

Best used for:

• Voucher audit trail: Full history of issuances, redemptions, and refunds
• Dispute resolution: Investigating the financial history of a specific voucher

Merchandise Reports

Merchandise Purchase Transaction Summary

Shows the total financial values per merchandise purchase, based on transactions that occurred within the selected date range.

Best used for:

• Merchandise revenue: Consolidated totals for photos, guidebooks, or branded items
• Separate reconciliation: Merchandise sales isolated from booking revenue

Merchandise Purchase Transaction Detail

Shows every individual transaction line for merchandise purchases that occurred within the selected date range.

Best used for:

• Item-level audit: Granular breakdown per merchandise purchase
• Discrepancy investigation: Tracing a specific merchandise transaction

Payment & Refund Reports

Payment And Refund Transaction Detail

Shows all payment and refund transactions across all booking types that occurred within the selected date range.

Best used for:

• Full cash reconciliation: All money in and money out for a period
• Bank statement matching: Cross-reference against payment gateway or bank records
• Chargeback investigation: Complete refund and dispute activity in one export
• Cross-type view: Covers standard bookings, vouchers, and merchandise together

Unallocated Payments

Shows orders created within the selected date range where a payment has been received but not yet matched to a specific booking or transaction.

Best used for:

• Month-end reconciliation: Identify outstanding unmatched payments before period close
• Booking issues: Investigate cases where a customer has paid but the booking is unconfirmed
• Accounts team flags: Resolve unmatched receipts raised during reconciliation

⚠️ Action required: Unallocated payments are funds received that need attention. Review this report regularly — unmatched payments can cause incorrect revenue figures and customer service problems.

Channel Reports

Channel Transaction Report

Shows all payment and refund transactions originating from Viator and GetYourGuide that occurred within the selected date range.

Best used for:

• OTA reconciliation: Match channel payments against your TicketingHub bookings
• Net revenue calculation: Analyse revenue after OTA commissions are applied
• Channel performance: Financial contribution by channel partner
• Commission statements: Payout preparation for channel-sourced bookings

Note: This report covers OTA channel transactions only. Direct bookings do not appear here — use the Booking Transaction reports for those.

Quick Reference: Choosing the Right Transaction Report

Frequently Asked Questions

What is the difference between Transaction Date and Reporting Date?

Transaction Date filters by when the booking or order was created in TicketingHub. Reporting Date filters by when each individual financial event — such as a payment, refund, or adjustment — was recorded in the system. A single booking can have multiple financial events recorded on different dates.

Which report should I use to reconcile with my bank statement?

Use Payment And Refund Transaction Detail for a complete view of all money in and money out. For transactions originating from Viator or GetYourGuide, use the Channel Transaction Report.

Why do some transactions appear in Reporting Date reports but not Transaction Date reports?

Because a payment or refund may have been processed on a different date to when the original booking was created. Reporting Date captures the financial event date, not the booking creation date.

What timezone are the reports in?

All date and time values in exported CSV files are in UTC.

Can I export voucher and merchandise sales separately from bookings?

Yes. Use Voucher Booking Transaction Summary or Voucher Booking Transaction Detail for voucher activity, and Merchandise Purchase Transaction Summary or Merchandise Purchase Transaction Detail for merchandise — both are separate from the standard booking reports.

What does "unallocated payment" mean?

An unallocated payment is a payment that has been received and recorded in TicketingHub but has not yet been matched to a specific booking. This often happens when a manual payment is logged before a booking is confirmed. Use the Unallocated Payments report to identify and resolve these.

Which report is best for my accountant?

For accrual accounting, use the Booking Transaction Detail (Reporting Date) — it gives your accountant a full line-by-line audit trail aligned to when each financial event was recorded. For a summary view, use Booking Transaction Summary (Reporting Date).

Need Help?

If you are unsure which report to use, or you notice a discrepancy in your exported data, contact our support team via the chat widget in your TicketingHub dashboard or email support@ticketinghub.com.

Updated on: 10/04/2026