The All Transactions Beta Report is a sales report that displays a detailed list of all transactions made at your business. This report provides an all-in-one solution for business owners to view and manage transactions, along with a set of filters for advanced report tracking.
The summary cards at the top of the page provide an overview of the key information in the report.Filters in this report only appear when data relevant to that filter is available. For example, the Products filter only appears when transactions related to products occurred within the date range set.
In this article:
To view the All Transactions Beta Report:
- Click the App Drawer button
.
- In the App Drawer, click View All.
- In the list, click Reports. You can filter the list by entering Reports into the Search field.
- On the Reports menu, click Sales.
- On the Sales menu, click hidden.
- On the Sales menu, click All Transactions Beta Report. The All Transactions Beta Report is displayed.
Summary cards in the All Transactions Beta Report
In addition to the summary cards listed below, summary cards corresponding to any customized taxes you have created will also be available.
Summary card | Description |
Total Items | The total quantity of items purchased during the selected date range. This summary card is visible when the View Mode advanced filter is set to Item View. |
Total Payments | The total number transactions that took place during the selected date range. This summary card is visible when the View Mode advanced filter is set to Payment View. |
Total Sales | The total amount of sales that occurred during the selected date range. |
Taxes | The total amount of taxes levied on all transactions during the selected date range. |
Headings in the All Transactions Beta Report
Heading | Description |
Transaction ID | The transaction ID of the sale. |
Client Name | The name of the client who made the transaction. You can click the client’s name to open their client profile. If a guest completed the transaction, Guest appears in this column. You can click Guest to open their guest profile. |
Transaction Time | The time at which the transaction was made. |
Location | The location at which the transaction was made. |
Revenue Category | If you use revenue categories to organize your online store, the category (or categories) set for the item in the transaction. |
Quantity | The number of items sold to the client as part of the transaction. |
Item | The name of the item. |
Amount | The amount of the transaction excluding discounts, taxes, and tips. |
Total Sales | The amount of the transaction before applied discount(s). |
Groupon Code | The Groupon code that was used for the purchase, if any. |
Discount Code | The discount code that was used for the purchase, if any. |
Discount Amount | The amount of the discount applied to the transaction, if any. |
Total Net Sales | The total transaction amount before taxes and after any applied discount(s). |
Custom Tax | One or more tax columns will be generated based on the taxes that you have set up for your business. Each column will list the amount of tax charged for the sale. For example, Sales Tax (GST/HST). |
Total Taxes | The total amount of taxes applied to the transaction. |
Total Sale Amount | The total amount of the transaction after applied taxes. |
Total Tips | The total amount of tips associated with the transaction. |
Total Surcharge | The surcharge charged to the client if they completed the transaction using a credit card or ACH payment method. This column is only displayed if you set the Surcharge setting to ON in your store settings. |
Total Amount | The total amount of the transaction after discount(s), taxes, and tips. |
Total Paid | The total amount of the transaction paid by the client. |
Total Receipts | The outstanding balance amount for partially paid transactions. |
Payment Method | The payment method used by the client to make the transaction. If the client used multiple payment methods to make the transaction, each payment method will be listed in this column. |
Transaction Origin | The source of the transaction, such as scheduled payment or installment plan. |
Transaction Balance | The balance of the transaction. |
Advanced filters in the All Transactions Report
Filter | Description |
View Mode | Use this filter to determine the method by which each line item in the report is organized. The options are:
|
Classes | Use this filter to determine which classes to include in the report. |
Gift Cards | Use this filter to determine which gift cards to include in the report. |
Display sales with discounts | Use this filter to determine whether to include discounted sales in the report. |
Discount Codes | Use this filter to determine which sales to include in the report based on which discount codes were applied to the sale. |
Events | Use this filter to determine which events to include in the report. |
Introductory Offer | Use this filter to determine whether to include introductory offers in the report. |
Groups | Use this filter to determine which clients to include in the report based on their client group. NoteThis filter will pull any relevant information from the available fields. For example, if you filter for groups A, B, and C, the filter will find clients from group A, group B, group C, and any combination thereof, as opposed to only finding clients who belong to all three groups. |
Payment Method | Use this filter to determine which sales to include in the report based on the payment methods used. |
Accounting Method | Use this filter to determine which sales to include based on whether accrual or cash accounting methods were used. For more information, see FAQ: What is the difference between accrual and cash-based accounting? |
Locations | Use this filter to determine which locations to include in the report. |
Account Purchase Options | Use this filter to determine which account purchase options to include in the report. Account purchase options are purchase options with Account Tab selected as the Purchase Option Service Category. For more information, see Creating or modifying a membership or Creating or modifying a session pass. |
Appointment Purchase Options | Use this filter to determine which appointments purchase options to include in the report. Appointments purchase options are purchase options with Appointment selected as the Purchase Option Service Category. For more information, see Creating or modifying a membership or Creating or modifying a session pass. |
Class & Events Purchase Options | Use this filter to determine which class/event purchase options to include in the report. Class/event purchase options are purchase options with Class/Events selected as the Purchase Option Service Category. For more information, see Creating or modifying a membership or Creating or modifying a session pass. |
Daily Deals | Use this filter to determine which Groupon deals to include in the report. |
Gym Purchase Options | Use this filter to determine which gym purchase options to include in the report. Gym purchase options are purchase options with Gym Visits Options selected as the Purchase Option Service Category. For more information, see Creating or modifying a membership or Creating or modifying a session pass. |
Package Purchase Options | Use this filter to determine which package(s) to include in the report. To learn how to create a package, see Creating or modifying a package. |
Others | Use this filter to determine whether to include other purchases in the report. |
Purchase or Money Owner | Use this filter to determine which items to include in the report based on who made the purchase; the client who received the item or the client who paid for the item. |
Auto-Renew | Use this filter to determine which Purchase Options to include based on whether auto-renew is on or off. |
Point of Sale | The platform through which the sale was made. |
Revenue Categories | Use this filter to determine which sales to include in the report based on the revenue categories they are classified under. |
Charged Taxes | Use this filter to determine which sales to include in the report based on whether the client was or was not charged taxes. |
Taxes | Use this filter to determine which sales to include in the report based on which tax types were applied to them. The options available in this filter are dependent on the taxes you have set up in your store. Selecting a tax filter will display all sales to which that tax was applied. Selecting the No taxes filter will filter for sales that do not have taxes applied to them. NoteIf the tax amount of a sale is manually changed to zero when the sale is made, the sale will still be considered taxed and can be filtered for using the appropriate tax filter. |
Bookable Assets | Use this filter to determine which Book-a-Spot assets to include in the report. |
Deposit | Use this filter to determine which sales to include in the report based on whether they were made with or without a deposit. |
Guest Purchases | Use this filter to determine whether to include transactions completed by clients, guests or both in the report. |
Appointments | Use this filter to determine which appointment types to include in the report. |
Products | Use this filter to determine which product(s) to include in the report. |