TripWorks reports turn your bookings, payments, and activity data into the numbers you need to run the business — for accounting, for marketing, and for cash flow. This guide explains the report families and, just as importantly, which report answers which question, so you pick the right one the first time.

You'll find all of them under Reports, each with a date range you choose.

The big distinction: Sales vs. Finance

Almost every reporting question comes down to one difference:

• Sales reports show the value of what you sold in a period — the total value of products and services, regardless of how much money was actually collected at the time.
• Finance reports show the money that actually changed hands in a period — payments received and refunds issued, regardless of when the activity happens or when the funds hit your bank.

If you're on accrual accounting (revenue recognized when the service is delivered), you'll lean on Sales reports. If you care about cash flow (money in and out), you'll lean on Finance reports. They're supposed to differ — see Why don't my report totals match? for exactly why.

The report families

Executive Summary

A snapshot of your business pulling key numbers from across the other reports — comparable to an end-of-day "Z report," but for any date range you choose. Great for a quick read on how a day, week, or season went. The sales card shows the percentage change in net sales against the previous period. For a whole month it compares with the previous month, for a range that starts on January 1 it compares with the same stretch of the previous year, and for any other range it compares with the same number of days just before your range. There's also a daily version delivered to your inbox — see the Daily Executive Summary report.

Gross sales and net sales: which report shows them

Executive Summary shows both Gross Sales and Net Sales for any date range. Sales Summary shows Net Sale, the amount you earned, which leaves out discounts, promo codes, surcharges, fees, tips, and government taxes, so it is before tax. Sales Detail has a Gross Subtotal column (the total before promo codes and reseller commission) and a Net Sales column that is hidden by default; turn it on in the column picker. Net Sales in Sales Detail adds up activities, products, add-ons, and any taxes you've set to count as revenue, such as VAT.

Sales reports

The value of everything sold in a period, with paid vs. outstanding balances. Common cuts:

• Sales Summary — sales created, focused on subtotal, net sale, and outstanding balance. Net Sale is what you earned: it leaves out discounts, promo codes, surcharges, fees, tips, and government taxes, so it is before tax.
• Sales Detail — every available field: activity details, sale date, customer, travelers, totals, and more.
• Sales Conversions (under Marketing in the left menu, named Conversions) — e-commerce sales where the buyer abandoned the cart and later completed the purchase.
• Sales Underpaid — sales with a balance still due.
• Sales by Team Member — sales grouped by who created them.
• Sales by Method — sales grouped by how they were booked (walk-up, online, reseller, and so on).

Finance reports

The actual transactions and payouts in a period — money received and refunded. Common cuts:

• Finance Detail — every transaction and payout field: sale date, payment date, method, tips, fees, and more.
• Finance by Type — grouped by payment method (cash, check, credit card, voucher…).
• Finance Payouts — paid and in-transit deposits to your bank account (see Using the payout report).
• Finance Transfers — transfers between TripWorks and your account: chargeback fees, subscriptions, rebates, and other adjustments.
• Finance Tips — tips received from customers.

To check your credit card processing volume for a period, run a Finance report over the date range you want — it totals the card transactions processed in that window.

Tax & Surcharge reports

The taxes and surcharges you collected in a period — summarized, in detail, or grouped by trip. See also Set up taxes and surcharges.

Open Reports and select Taxes & Surcharges under Additional Reports. The summary has one row per tax or surcharge and four columns: Non-Taxable Sales, Taxable Sales, Total Sales (the first two added together), and Tax Amount. By default it groups sales by the date the activity was delivered.

A sale counts as non-taxable for a tax when that tax charged nothing on it. That happens when a booking is tax-exempt, when the tax is set to start exempt on new trips, or when the tax doesn't apply to that activity, product, add-on, or booking channel. So a non-taxable total can be real sales, not an error. See Set up taxes and surcharges for where each tax applies.

Activity reports

What you sold or delivered, by activity — including passenger counts and add-ons. Cuts include Activity Detail, By Activity, Ticket Types, Locations, Add-Ons, and Not Scheduled (unscheduled or canceled activities in the period).

Payout reports

The deposits TripWorks makes to your bank account. A payout groups transactions from a few days earlier, so payout totals deliberately won't line up with same-period Sales or Finance reports — see Using the payout report and Why don't my report totals match?.

Operations reports

Day-to-day records rather than money. Under Reports, the Operations group has Notes, Custom Fields, and Waivers. The Waivers report lists waivers signed in a period, based on the date each guest signed. It shows the ID, when it was signed, first and last name, email, phone, and date of birth, plus the booking it belongs to, and you can download it as a CSV. The phone number is the one the signer typed on the waiver.

Custom reports

Run any report, change its columns, filters, and sorts, then select the save icon to keep it as a Custom report. Give it a name, add notes, and tick Share this report with other team members if others should see it. A saved report remembers its column choices, including columns you hid, so it opens the way you left it. To change it later, open it and choose Update this custom report. Saved reports are listed under Custom in the Reports menu.

Which report should I use?

• "How much did we sell this month?" → Sales report (run by date created for marketing, or by activity date for accrual).
• "How much money came in this week?" → Finance report.
• "What hit my bank account?" → Payout report.
• "How much tax did we collect?" → Tax & Surcharge report.
• "How did each tour perform?" → Activity report.
• "How's the business doing overall?" → Executive Summary or the Business Analysis dashboard.

Frequently asked questions

Related

• Why don't my report totals match?
• The Daily Executive Summary report
• Understanding your Business Analysis dashboard