Sales Discrepencies / Reconcilation between Gpos and Total Control
Sale discrepancies can happen for a few reasons depending on set up options as well as network errors. These can be caused by a network issues, stored balances which aren’t cashed off and so forth.
In this document we shall go through the scenario of where this can occur and what self checks can be done to deal with this effectively and efficiently.
The total value of sales is higher on Total Control Premier for a full day when compared to the Gpos terminals.
The first which must be done is an attempt to narrow it down to the terminal/s which is proving to fault. To identify it for this day you will need all the till readings for that area.
Next, run the ‘Product Major Group Report’ (found under Product Sales>Major Group Sales) individually for each till on Total Control Premier and compare this to the till/s Main Group Sales Value heading, this will help narrow you search results down to a till/s. For reference I have included a dummy heading below, this Main Group Sales Total would need to be compared to the total from the Major Group report.
Once you have found the till which is causing an issue with balancing a common occurance can be a sale has been performed after the till has been cashed off for the night (period ended) and they then perform another sales transaction. To work this out we will need to double check when the till has been cashed off then run another report from a minute after this point up until just before the start of the next day’s transactions start.
This information is found at the bottom of the till read. Please see my picture below (I have purposely removed part of the VAT number on purpose).
In my scenario it may be that they have cashed up the till early, so I would run it from 16:26 until 23:59. If I then found it reported sales information then this means that Total Control Premier is more accurate, and the transaction needs to be accounted for. At this point you could use the Journal Reporting Applet to look up the transaction after the cashing up has taken place to find out which clerk has performed this transaction. Should it then happen in the future all they would need to do is perform another cashing up and be sure to include it with their original read.