When Radar polls data from your Point of Sale, the data within Radar should mirror the data in the POS. Comparing how the POS reports sales data to how Radar reports the same sales data is an important part of managing a Radar database. 

Recommended reasons to audit sales:

• New Location added 
• New POS added
• Data discrepancy troubleshooting
• Ongoing data integrity

Step 1: Running a Report from the POS

For auditing, you will need a current report run from the POS for the Location and date of business being audited. 

    Important Note: This report must be run from the POS and not from third-party software. 

The more detailed the POS report is, the more thorough the audit will be. If possible, the report from the POS should include:

Every POS has a different name for this general sales report. Common POS report names include:

• Daily Sales Report
• Sales Summary
• Sales Detail

Step 2: Running a Report from Radar

For auditing sales data, the 'POS Sales Report' is used.  The POS Sales Report is the most comprehensive sales report in Radar. This is a multi-metric snapshot of one or more Location's sales data for a date or date range. The layout and organization of this report allow for easy auditing of daily sales. 

The POS Sales Report is found on the Sales page within the Reports Module 

• Note: You may not have access to the POS Sales Report or Reports Module. If you do not have access, please contact your Superadmins for assistance.

Filtering the POS Sales Report for a Sales Audit

1. In Step 1, Select a Single Location
   
   

   
   

   • Auditing for sales should always be done for one Location at a time
   • If discrepancies are found, narrowing down the cause is simpler when limited to a single Location
     
     
2. In Step 2, Select a Single DOB
   
   
   • Auditing for sales should always be done for one day at a time
   • If discrepancies are found, narrowing down the cause is simpler when limited to a single date of business
     
     
3. In Step 3, Click Show Cash OS Calculation
   
   

   
   

   • Auditing sales includes an audit of the Theoretical Cash Deposit and Calculated Cash O/S
   • The POS Sales Report will always show the calculated Theoretical Deposit. Including the Cash O/S Calculation filter in Step 3 will indicate what data is added or subtracted from Cash Tenders to calculate the Theoretical Deposit.
     
     

Step 3: Compare Reports

To audit sales, move through the report run from the POS and compare each metric to a comparable metric on the POS Sales Report run from Radar. 

What to Audit

• Names - Radar is name-based. The names for details within the metric should match the POS.
  • Note: If two Locations have the same metric detail name spelled differently, Radar pulls both names and will list both when viewing All Company. 
  • Note: If the name 'UnSpecified' or 'Unknown' is listed, this indicates that the metric detail was not provided a name in the POS data. This detail may not be provided or may not be configured properly in the POS.
    
    

• Detail Amounts - The detail amounts within each metric should match
• Total Amounts - Total amounts should match
• Calculated Cash O/S - Cash O/S should match
• Radar Configurable Calculations -  Most amounts are pulled directly from the POS. There are however a handful of calculations that are configurable in Radar. These calculations are adjusted in Company Preferences in the Company Configuration Module. 
  • Sales Type Definitions 
    • Net Sales
    • Gross Sales
    • Order Mode Net Sales
  • Cash O/S (Theoretical Deposit)
    
    
• Note: Do Not Audit Master Sale Departments - 
  • Master Sale Departments (MSDs) are configurable reporting categories created within Radar. MSD categories are not used during an audit of Sales data.
    
    

What if something doesn't match?

If discrepancies are found during the Data Integrity Audit:

1.  Confirm that the Report run from the POS is accurate and current
2.  Repoll the day's data
3.  Re-audit
4.  If the discrepancy is still present, submit a case to the Support Team

• Important Note: When submitting a data discrepancy case to Support, include the Report run from the POS for one date of business that illustrates the discrepancy