About the Report
- The Daily Sales Report (DSR) is a detailed report for 7 days of daily sales and labor information from the Point of Sale.
- This report can be used to validate daily sales and close procedures from the following business day when used at the store level in conjunction with End of Day
- The data reported here is imported from your point of sale to Decision Logic via the Universal Data Transfer (UDT) Install OR via an API with your Point of Sale.
- The fields that report are dependent on those fields existing with the correct point of sale identifier mapped in POS Admin
- Deposits, Paid Outs, Paid Ins may need to be manually entered into the End of Day depending on the Point of Sale integration. These types of fields cannot always be automated for import into Decision Logic.
Running the DSR Report
Navigate to Operations> End of Day> DSR
Select a scope and Year, Period and Week
Select Apply to load the report.
Daily Sales By Store
Decision Logic Formulas#CashAccountability
For each store, the DSR gives a daily detail of many of the following fields and calculate Cash O/S based on the Decision Logic Formulas Cash Accountability listed below:
- Gross Sales = All System Sales less exclusive taxes
- Net Sales = Gross – Voids
- Net Net Sales = Net – Comps and Discounts
- Total Amount of Billable Product = Net Net Sales + Taxes + Gifts (Gift Card Sales + Service Charges + Order Charges) + Paid Ins - Paid Outs
- Cash Accountability = Total amount of the billable product + Paid Ins - Paid Outs – Gift Card Payments – Non Cash / Non-check Payments
- Cash Over and Short = Cash Accountability - Deposit
Net Net Sales should match POS Systems NET Sales.
- Total Amount of Billable Product line not reported in Decision Logic
- Inclusive Taxes are included in the Gross Sale by Department of the Item Sold
Field names will vary depending on your Point of Sale and what is mapped in POS Admin. Here are the basic Sections of the DSR we report
- Gross Sales
- Voids
- Comps or Complaints
- Discounts / Promotions
- Payments
- Payments are electronic payment types + tips on electronic payment types.
- Payments will not automatically include Cash or Check
- Cash and Check those should be entered as Deposits into the End of Day
- Gifts
- Gift types sold
- Paid Out / Ins
- Paid outs and Paid ins from the point of sale do not automatically impact your Cogs or IvA.
- To account for the product associated with the paid out/in stores will need to create a Manual Receive
- Will include Gift types redeemed
- NET NET Sales
- should match POS Systems NET Sales.
- Labor Hours by Job Code
- Labor Dollars by Job Code
Taxes
- Accountability
- Deposit
- Cash O/S
- Liquor Mix %
- Bar Sales as defined in POS Admin > POS Set Up > Department Type: Bar / All Sales
- Customer Count
- PPE
- per person expenditure. Customer Count / Net Sales
Accountability
see CashAccountability or End of Day
Deposit
- Depending on the Point of Sale Paid Out / Ins will either be auto-imported or need to be manually entered into End of Day
- Automation exists for the following Point of Sale
- Aloha
- Micros
CashAccountability or End of Day
Cash O/S
see Deposit CashAccountability or End of Day
The Daily Sales Report shows the categories broken out for Sales sections.
Paid Outs
- Depending on the Point of Sale Paid Out / Ins will either be auto-imported or need to be manually entered into End of Day
- Automation exists for the following Point of Sale
- Aloha
- Micros
Manager Comments
Comments can be manually entered into End of Day
DSR Export & Print
Select from the options at the top right on the page to export the report to CSV or print to local printer or PDF.
The current view of the report is the data that will be printed or exported.
Table of Contents
For additional questions or assistance please submit a support ticket by visiting the Decision Logic Help Center.
All training videos are located in the Decision Logic Video Vault