Discrepancy on the payment type between payment report and register closure report

Discrepancy on the payment type between payment report and register closure report

Description
The total sales of a particular payment type can be different for the same date range. For example, on the 1 Feb 2019, NETS payment total show in the Register closure summary is $132.00 but Payment report is showing $149.00, a different of ($17.00).









Possible reasons
  1. More than one register closure has been done on the same day.
  2. Modification of sales date to the previous day.



Diagnostic for More than one register closure has been done on the same day

Take note of the Opened and Closed in the Register closure summary. If the transaction fall outside of these date/time range, it will not be included in the calculation which resulting in discrepancies in one or more payment type.

We are comparing between Register closure details ( View full details ) and Sales ledger applying same date range and filter by Closed sales under Show filter.




Diagnostic - Modification of sales date to the previous day

Discrepancy may happen if user modify sales date of a particular transaction to the past date. Vend allow authorized user to edit certain information on Closed sales transaction such as Customer, Note and Sale date. It is important to know that the finalized sale transaction will reflect on the Register closure summary on the same day only. But the edited sale transaction will show in the Payment report or other reports that filtered by sale date.









Summary

The reason that edited sale transaction will still reflected on the same day of the Register closure summary is to prevent data integrity issue between POS and accounting systems. It also prevent possible exploitation of user from altering date and taking money out of cashier.



Troubleshooting
  • Login to Vend as Administrator or Manager