To access the Sales Summary by Revenue Category Report, click on the App Drawer button then click View All > Reports > Sales > Sales Summary by Revenue Category.
The Sale Summary by Revenue Category Report is a sales report that displays a summary of sales made at your business during the selected date range, sorted by revenue category. This report can be used to analyze your earnings per revenue category.
This report includes any sales made during the time period that you select in the report, even if the transaction for the sale may not have occurred yet. For example, a sale of a membership made in December will appear in the December report, even though the transaction does not occur until January.
View options in the Sales Summary by Revenue Category Report
Option | Description |
Accounting method | Determines which sales to include based on accounting method. For more information about accrual and cash accounting methods, see FAQ: Reports.
Notes
|
Revenue Attribution Method | Determines how items are counted based on their revenue category in the report.
|
Summary cards in the Sales Summary by Revenue Category Report
Summary cards | Description |
Total Items | The total number of items purchased during the selected date range.
Transactions that were failed, voided, and refunded aren’t included in this value. |
Total Returns | The total amount refunded for all revenue categories in the date range you selected, excluding taxes. The amount displayed in this summary card will either be negative, or zero. |
Total Net Sales | The total value of sales during the selected date range, after the deduction of refunds and voids. Any discounts applied to the transactions are included in this value, but taxes or tips applied to the transactions aren’t included. Transactions that were failed, voided, and refunded aren’t included in this value. |
Total Taxes before Returns | The total value of taxes applied to the items sold during the selected date range. Taxes from failed and voided transactions aren’t included in this value. |
Total Returns Tax | The total amount of taxes refunded for all revenue categories in the date range you selected. The amount displayed in this summary card will either be negative, or zero.
This summary card is only visible if taxes have been set up in your store settings. |
Total Paid | The sum of all values in the Total Paid column. |
Headings in the Sale Summary by Revenue Category Report
Heading | Description |
Revenue Category | The name of the revenue category is listed in this column.
|
Quantity | The total number of sales of the revenue category type during the selected date range is listed in this column.
|
Subtotal | The value of the total number of sales of the revenue category type before taxes or discounts during the selected date range is listed in this column. |
Discount Amount | The total value of discounts applied to sales for the revenue category. |
Returns | The total value of any refunds applied to sales for the revenue category. The amount displayed in this column will either be negative, or zero. Includes surcharge refunds, excludes tax refunds. |
Total Net Sales | The value of the Subtotal column subtracted by the Discount Amount and Returns columns. Surcharges are included in their own revenue category. Excludes taxes and tips. |
Total Taxes | The total value of taxes applied to sales for the revenue category. If there is only one type of tax set up in your store settings, this column will be named after the tax you have created. If you have two or more taxes set up in your store settings, this column will appear as Total Taxes. |
Returns Tax | The total value of tax refunds for the date range you selected. The amount displayed in this column will be negative, or zero. |
Total Paid | The sum of the Total Net Sales and Total Taxes columns, subtracted by the Returns Tax columns. |
Advanced filters in the Sale Summary by Revenue Category Report
Filter | Description |
Bookable Assets | Use this filter to determine which Book-a-Spot assets 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. |
Locations | Use this filter to determine which locations to include in the report. This filter is only available if your business has multiple locations. |
Auto-Renew | Use this filter to determine which Purchase Options to include based on whether auto-renew is on or off. |
Products | Use this filter to determine which product(s) to include in the report. |
Packages | 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. |
Classes | Use this filter to determine which classes to include in the report. |
Events | Use this filter to determine which events to include in the report. |
Appointments | Use this filter to determine which appointment types to include in the report. |
Appointments Purchase Options | Use this filter to determine which appointment Purchase Options to include in the report. Appointment 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. |
Revenue Categories | Use this filter to determine which sales to include in the report based on the revenue categories they are classified under. |
Others | Use this filter to determine whether to include other purchases in the report. |
Client Groups | Use this filter to determine which clients to include in the report based on their client group.
Note: This 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 about accrual and cash accounting methods, see FAQ: Reports.
If any option is selected for this filter, a staff member can click the value under the Quantity or Total Sales columns to open the Sales Details by Revenue Category Report, which will be filtered for the associated revenue category and cash accounting.] |
Deposit | Use this filter to determine which sales to include in the report based on whether they were made with or without a deposit. |