Total Sheet
Location: Reports > Transaction Reports
The Total Sheet is a great report to run, daily, weekly, monthly or just because. This report will give you summaries on everything from worker sales, company sales, ticket adjustments, payments, tips, etc. This article will tell you also where to go for more details on the summaries noted in the Total Sheet.
To generate the Total Sheet Report:
- Go to Reports > Transaction Reports > Total Sheet
- Enter a date range
- Click Generate
Results will display below in different tables depending on the transaction. See additional details below.
Worker Sales
All worker sales summaries for services, products and tips and their combined totals during the date range generated will display without tax.
For a more detailed report on Worker Sales, check out the Itemized Sales Report (located in Reports > Sales Reports > Itemized Sales) or the Sales Analysis by Employee Report (located in Reports > Business Analysis Report > Sales Analysis by Employee).
The
Guest Charge is not deducted from the Service Sales totals for workers but is noted to the right hand side in a grey font. To see the Guest Charge deducted from Service Sales for a worker, use the Service Sales report for a specific worker.
If a Service or Product was refunded, the amount will be adjusted on this report whether "Deduct from Worker" was selected or not. For the Service or Product Sales where the refunds are calculated for "Deduct From Worker" use the Process Compensation reporting.
Company Sales
All service, product, membership, miscellaneous and variable ticket fee sales and refunds will display in this table along with any adjustments. Adjustments are when the original price was changed manually, using a promotion, applying reward points or using a prepaid package. See the Adjustments Table below for details.
For a more detailed report on the Company Sales, check out the Itemized Sales Report (located in Reports > Sales Reports > Itemized Sales).
Adjustments
The Adjustments Table accounts for any intangible payments or adjustments were applied towards the payment of a service or product such as prepaid package usage, rewards points, promotions but also if the price was manually adjusted to be higher or lower than the original amount.
For a detailed report on items that were manually adjusted, check out the Price Adjustments Report (located in Reports > Transaction Reports > Price Adjustments).
For a detailed report on Rewards Usage, check out the Rewards Report (located in Reports > Client & Appointment Reports > Reward Points).
For a detailed report on Promotions applied, check out the Promotions Report (located in Reports > Client & Appointment Reports > Promotions Report).
Account Balances
The Account Balances table will show any transactions where a balance was created for the client in the form of a deposit, prepayment, service package sold, gift sold or an amount applied as Received on Account. Traditionally, this value needs to be noted because payments were made or created for these items however they are not considered sales yet.
Worker Tips
The Worker Tip table will show Tips Paid Out, Tips Left in Drawer and any Tip Refunds with a total below. Tips Paid Out are tips that were paid instantly to the worker, are noted in the software and would not be accounted for in your cash drawer at the end of the day or shift. Tips Left in Drawer are intended to be paid out at a later time and would be accounted for in your Cash Counting at the end of the day or shift.
For a more detailed Tip Report, check out the Tip Detail Report (located in Reports > Compensation Reporting > Tip Detail Report). For Tip Summaries for each worker with the "Deduct From Worker" considered, check out the Tip Summary Report (
located in Reports > Compensation Reporting > Tip Summary Report.)
Payments
The summary of payments that were applied to tickets during the date range generated. Additionally, any unpaid tickets, Change Back, Tips Paid Out, Cash Paid In and Cash Paid Out will be noted.
To see these values broken down by Cash Drawer / Shift, use the Payment List Report (located in Reports > Transaction Reports) or in Cash Counting (located in Check Out List > Cash Counting).
Table Totals
At the bottom of this report, the Table Totals will add up your Company Sales after adjustments and with tax, the Account Balance total, and your Tips Left In Drawer (minus refunds where the Tip was left in Drawer) and provide a Total.
Related Articles
Scheduled Reports
This feature will be released in May 2024, stay tuned! Location: Reports > Scheduled Reports The following Reports can be scheduled: Total Sheet Sales Analysis Report On Hand Product Yearly Dashboard Tab Text Count Report To schedule a report, simply ...Class Sales Report
This feature will be included in the Inspire by STX v3.1 release coming in Fall 2023. The Class Sales Report is a great tool to see how popular your classes are, the avege attendance and price plus much more! To generate the report, enter a Begin ...Itemized Sales Report
Location: Reports > Sales Reports Itemized Sales Report The Itemized Sales Report is a report that will show every single line item on every single ticket. Simply input the date ranges, select if reporting by Company or a specific Worker, which ...How does Change Back work?
How does change back work? When the last payment applied is greater than the balance due, "Change Back" is noted on the Completed Ticket and Receipt. What form of payment is used for change back? When any payment (cash, check, gift, credit card, ...Credit Card Batch Report
Location: Reports > Transaction Reports The Credit Card Batch Report exclusively reports on transactions where the payment used STX Payments integrated credit card processing. The report focuses on a single day's transactions starting at 9:30 PM EDT ...