Home | POS Systems | Global Data Server

Past Sales is different to End Of Day

The totals on the Past Sales screen and the End of Day screen do not always agree as the two screens are reporting and showing slightly different information. Alternatively, if you are using Pinboards or web reconciliation screens, similar issues can be observed.

The End Of Day screen (and EOD pinboards) is designed solely to show payments received within a trading period. This allows the cash drawer to be balanced and banking to occur. To select the correct payments for processing, the system selects all payment records where the date and time on the payment entry is within the time period selected.

The Past Sales screen is designed to show historic sales for investigative purposes. It selects sales based on completion date of the sale (or start date of the sale on some configurations). Past Sales also shows all sale related transcations, not just normal retail sales, such as writeoffs, security sales (trashed sales) and other similar items. When a sale is included in the Past Sales selection all the payments are considered to apply, regardless of the actual timing of the payment.

The pinboards totals, such as total sales of Product XYZ are also based on the date/time the sale completes, not the time the payments were received. This can be a different date in some circumstances. The End of Day pinboards for tender totals were only designed to provide totals of tender types, they do not directly relate to sales

These differences mean that the two totals or lists are close, but may not always match. If you are attempting to reconcile the two screens, you need to take the following into account.

  1. Payment dates and sale dates may not exactly overlap. Especially in the case of multi day sales, such as laybys (lay aways), or where the system has processed a sale over two days.

  2. Account Payments that have been entered to be applied to a different date to today will also cause this problem. The "sale" occurs on the current date/time, so the total sales of "Account Payment" will include this amount on the current date. The "payment" is recorded on the date you entered as the date for the payment. These two dates are both required in order to ensure proper auditing and taxation requirements are met.

    If cross day account payments are your main cause of issue, then a quick solution may be not to change the payment date unless you have external systems that require the exact date.

  3. Past Sales includes more than just sales, unlike End Of Day. To select only sales, press the "sales" button and enter a "1" (one) into the phase column.

EXAMPLES

Layby

Day 1Day 2Day 3
XYZ Sold
for $300
Payment $150Payment for $100Final Payment of $50

  • On Day 1, the End of Day will show $150. Sales of XYZ will show $0
  • On Day 2, the End of Day will show $100. Sales of XYZ will show $0
  • On Day 3, the End of Day will show $50. Sales of XYZ will show $300

Cross Day Account Payment

Day 1Day 2
Account Payment Entered of $200, with application date of "day 1"

At the end of the day on day 1 (ie the point in time before Day 2 starts)

  • On Day 1, the End of Day will show $0. Sales of "Account Payment" will show $0

At the end of the day on day 2

  • Rerunning EOD for Day 1:
    • The End of Day will now show $200.
    • Sales of "Account Payment" (for Day 1) will show $0
  • EOD for Day 2
    • The End of Day will show $0.
    • Sales of "Account Payment" (for Day 1) will show $0.
    • Sales of "Account Payment" (for Day 2) will show $200

    THIS ARTICLE APPLIES TO

    • POSGreen 2007