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.
All worker sales summaries for services, products and tips and their combined totals during the date range generated will display without tax.
All service, product, gift, 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.
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.
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 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.
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.
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.
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.