Reporting – Daily Sales Recap

Continuing our introduction to SP-1 reporting. . . 

The Daily Sales Recap section of SP-1 reporting is where you can access most of the daily business reporting you will need to make intelligent decisions about your business.  

Think of this area as a 24 / 7 manager that can give you instant feedback on how the business is coming along.  Once you enter this area of reporting, you will see a number of report options:

Balance Till: This area is designed to do just that – allow you to balance a till.  This report shows every ticket that was added throughout the day.  You can provide an exception on the report for delivery tickets as those are handled through the driver.  This report can be run by the shift, the workstation or the day. The best use is to close out the actual cash drawer on a station and to close out a shift.   This can help you determine if you are over / short per drawer.  Keep in mind that this can also show and reflect credit cards, gift cards, tips, coupons and discounts.  This report should be run every day. 

Workstation Summary:  This report is designed to give you a picture of what is happening per workstation – including totals and menu breakdown. 

Employee Summary:  Use this to get a view of how well employees are doing from a cashier standpoint.  This report shows the total dollars that an employee sold, number of voids, number of tickets etc.  The great thing about this report is that the number of voids gives you a good indication of potential theft.

Shift Close – 40 Column:  This is very similar to the Balance Till but it is more of a summary.  You would use this report to print a receipt (on the thermal printer) for the shift.  This allows you to easily close out a till during your different shifts. 

Business Summary Recap:  This is the primary business report and is too large to go in depth with here.  This gives you a detailed listing of your day (week, month, year).  Labor percentages, menu mix breakdown down to the modifier level etc.  The important thing to remember here is that this should be run every day.  When this report is run, you have the ability to enter your cash, checks, credit cards etc for the day.  This will then compare those entries with what SP-1 has recorded.  You can then have an over/short to help see what is happening.

Hourly Recap by Week: This report is underused by most stores.  Basically this tracks, over a week the total number of tickets by hour and by menu group.  This is a great report because it shows you how many orders you had.  Use this to help schedule and plan your next week based on the last weeks sales. 

Credit Card Settlement:  This report allows you to reconcile your credit cards that were run through SP-1 with the credit card information reported by your processor. 

XML Ticket Summary: This is a customized export to an XML format.  This report can be brought into Microsoft Excel and used to provide full reporting beyond the normal reporting in SP-1. 

Contact us at:
Mike Spence
8326 Woodland Ave. E
Puyallup Wa 98371

March 22nd, 2011 by