Cash Drawer report

Was this article helpful?
4 out of 4 found this helpful
Follow

SUMMARY

The Cash Drawer report will help you balance your cash drawer at the end of a shift or the end of the day. This report works well with the Daily Closeout report.

Only cash equivalent sales are listed on the Cash Drawer report.

This includes:

  • cash
  • check
  • credit card sales.

Staff can balance the drawer according to cash, checks, and credit card sales receipts. You can run this report for your multiple cash drawers, as well. Click here to learn more about multiple cash drawers on a PC. Apple users, click here.


CONTENTS

 

Report's location

Hit the Reports tab and choose Sales from the tabs on the left. To narrow the list, select Administrative from the filters, and then click Cash Drawer to open the report.

Note: You can always use the search bar at the top right to search for Cash Drawer by name, and if it’s a report you use often, then consider making it one of your favorites

Sales_Administrative.png

 

DEFINE YOUR DATA

This section will describe how to run the Cash Drawer report and what filters and options are available.


Set Dates

To manually change the report's start and end dates, you can type the date(s) in, or click on a Quick Dates option.

 

Back to top

 

Choose Filters

  • Show Tagged Clients Only: If you previously tagged a list of clients in the system, then checking this box will display only those clients. Click here to learn more about tagging.
  • Location: You can use this multi-select list to filter by multiple business locations or find sales from your online store. By default, the filter is set to All Locations.
  • Entered By: You can run the report by employee to see how many sales each employee made and for how much. Choose the employee name from the drop-down list, and click the Go! button. Filtering this sales report by employee name requires that you assign each employee their own login and that they use it every time they make a sale.

EnableOptions

  • View:
    • By Date: Selecting this option sorts the report results by date, regardless of who completed the sale.
    • By Employee: Selecting this option sorts the results by date and employee.
  • Display individual summaries for the following payment methods: Use this multi-select list to choose which cash equivalent payment methods to display in a unique Total Sales and Grand Total column. All options not selected will be added into the Other column.

Back to top

Generate

  • Go!: This will make the report magically appear, based on the filters that you set. If you click the Go! button and nothing happens, then your instructors have not completed any appointments between the start and end dates for the report.

Print, Save or Export

  • Print This Report: This will open your computer's print menu, so that you can print the report.
  • Export to Excel: This will generate a spreadsheet containing the report's data in Microsoft Excel. To learn about exporting reports to Excel, click here.
  • Export to PDF: This will format the report’s results into a PDF file that can be saved to your computer. Printing directly from a PDF may solve formatting issues that arise when trying to print reports from an internet browser.
  • Save This ReportClick here to learn about using the Save This Report feature.
  • Tag Add: Adds the list of clients displayed to the list of clients you have tagged in the past. Click here to learn about tagging clients.
  • Tag New: This deletes the old list of tagged clients (it doesn't actually delete the clients, just the list), then it adds everyone displayed to a new list of tagged clients. It's the closest thing we have to starting with a new list of tagged clients. Click here to learn about tagging clients.
  • Untag clients: This will remove any clients generated by the report from the tagged list. Click here to learn about tagging clients.
  • Constant Contact: You can use this feature to convert the report’s results into a new contact list in Constant Contact. Simply click the Constant Contact icon, give the contact list a unique name, and click the Export button. You can find this newly-created list in your Constant Contact account.

Note: The checkboxes and radio buttons in the report's filters are sticky, which means they'll remember what settings your user login prefers.

Back to top

 

UNDERSTANDINGTHE RESULTS

Results are displayed by date or by employee, depending on the preference you've set in the Options Filter.

  • Client: The client who made the purchase. A client's name will show up numerous times if they have multiple sales in the date range.
    • Clicking on the client's name will take you to the client's profile or Home screen, depending on the default Home tab option selected on the General Setup & Options screen.
  • Sale ID: The ID number that is associated with the particular transaction.
    • Clicking on this sale ID will bring the user to the Manage Sales screen for that particular sale.
  • Location: The location selected in the Retail screen when the sale took place.
  • Notes/Check #: The number of the check used to make payment, or payment method notes (if there are any).
    • Notes will appear only if they are entered into the sale notes section in the Retail screen.
    • This sale notes section will only appear if the checkbox is checked next to the payment method in the Payment Methods screen.
  • Payment Amount: The total amount paid for the given payment method.
    • Certain sale IDs can have more than one payment amount, depending on how many payment methods were used to process the sale.
    • The Other payment method includes all user-defined, cash-equivalent methods and ACH.
    • To separate a payment method from the Other column, you can select Display individual summaries for the following payment methods from the report's filter.
  • Total <PAYMENT METHOD> Amount: This shows the total payment amount for the particular payment method for all transactions that were processed during the selected date range.
  • Total Sales: The total sales for the date range, separated by payment method.
  • Payment Method: This row breaks down the total sales by the payment types that clients used. You’ll see the usual payment methods like cash, check, and credit. You might see additional methods, too.
    • For example, if you’ve opted in to the Spafinder program, you’ll see a Spafinder Wellness 365 column.
    • The Other column includes all of the payment methods you've created yourself (e.g., Trade, Room Charge, etc.), as well as ACH transactions.
    • The Credit column includes keyed, swiped, and no-auth transactions.
    • On the far right, you’ll see a Total column, which combines all sales for all payment methods.
  • Total Received: This is the total amount received for each particular payment method for the date range selected.
  • Tips: This is the amount of tips received for a particular payment method for the date range selected.
  • In Drawer: This is the sum of the Total Received and Tips columns for the particular payment methods for the date range selected.
  • Paid Out: This the amount paid out in tips for the date range selected.
    • This section will display when the Tips option is checked in the General Setup & Options screen, and the Tips Included in Cash Drawer & Payroll option is unchecked.
    • This totals the tips for all payment methods and places it under the Cash heading.
  • Total Sales: This field categorizes the total sales amounts from the different payment methods into tip and non-tip amounts for the date.
  • Grand Total: This field sums all of the Total Sales fields for the date range selected.

Back to top

 

Permissions that control access to this report

To view and run this report, one of the following permissions must be enabled for you or your staff's login group:

  • Cash Drawer - Run for current date
  • Cash Drawer - Run for date range

To grant or restrict access to this report, just hit the Home tab and select Staff from the submenu. Choose Tools at the top right and click on Staff Permissions.

Staff_Permissions_in_Tools.png

  1. Select a permission group from the drop-down menu.
  2. Click on Report Permissions.
  3. Check or uncheck the boxes for the Cash Drawer - Run for current date and the Cash Drawer - Run for date range permissions.
  4. Click Update.

Back to top

Want to watch the tutorial? View it here!


 ADDITIONAL RESOURCES:










0 Comments
Powered by Zendesk