A report of events taking place this month answers a different question from a report of events that became definite this month. Begin with the question, then choose the dates, statuses, and records needed to answer it.
This guide is a starting workflow, not a promise that every field appears in every Tripleseat account. Permissions, configuration, and product updates can affect the available reports.
1. Separate event timing from sales timing
Use an event-date view to examine the activity scheduled or delivered in a period. Use a definite-date view to examine events that reached that status during a period. A record’s creation date is not automatically its booking date or revenue-recognition date.
For a definite-date report, Tripleseat’s documented route is Reports → Event Details Report → Custom → Customize. On the Event Details tab, set the Definite Date range. Use the Columns tab to select relevant identifiers, financial fields, and item-category totals. Run the report, inspect the result, then save or export it. Tripleseat identifies financial columns including Event Actual, Event Grand Total, and Amount Due; the label alone does not make a column accounting revenue.
For an event-date view, use the applicable event-date filter and confirm that it represents the event period—not the period in which records were entered. Keep a note of all status and location filters. Tripleseat supports customizable Event Details reports and exports.
Event date
Which activity is scheduled or delivered in this period?
Definite date
Which events reached definite status in this period?
2. Prepare separate datasets rather than one overloaded total
| Dataset | Purpose | Information to preserve where available |
|---|---|---|
| Events and bookings | Define what was sold and when it occurs | Stable source identifiers, booking/event relationships, event dates, relevant status dates, status, location, type, financial categories |
| Customer transactions | Explain cash activity | Transaction identifier, date, status, amount, payment/refund type, linked event or booking, and reversal relationship |
| Scheduled customer obligations | Understand contracted collection timing | Linked record, installment due date, scheduled amount, payments applied, remaining balance, and cancellations |
| Billing detail and adjustments | Explain financial composition | Revenue items, discounts, taxes, gratuities or service charges, deposits, and other separately identified components |
These are required concepts, not a claim that each is an exact column label in a single export. Confirm which reports or supported connection provide them. A remaining balance without installment dates does not establish a reliable collection calendar.
3. Keep the relationships intact
Retain stable IDs. Names can change and are not a dependable join key. A payment linked to a booking with several events must not be copied onto every event and then summed.
Check the number of rows and the control total before and after combining datasets. Reconcile unique transaction totals separately from any allocation across events, revenue categories, or installments.
A booking payment must not be copied onto every event and then summed.
4. Preserve dates and status context
Record the export date, reporting window, timezone where relevant, filters, and currency. Keep refunds and failed or voided transactions distinguishable rather than dropping them into an unlabeled net total.
To compare booking pace with what was known at a prior date, use retained snapshots or a reliable history that can reconstruct that state. Today’s event list and creation dates alone may not show past cancellations, value changes, or status changes.
5. Check before drawing conclusions
Compare the exported totals with the source report. Investigate unexpected duplicates, missing IDs, blank dates, and changes caused by filters. Reconcile cash activity to the relevant processor or banking records, accounting for timing and fees. Then reconcile the appropriate financial view to the ledger.
Do not send customer personal information, bank credentials, or tax identifiers through our public contact form. We agree a secure transfer method when records are needed.
