Reconciliation of Tips & Gratuities in Labor Summary Reports (screen and the export don't reconcile)

[drdgreen]

We have noticed that Tips and Gratuities for our Delivery and Catering employee in various labor and time entry exports do not reconcile to what shows on the screen for these reports and the values from the relevant invoices (which are generated in Catering and Events).  NetSales in the screen view and in the exports ties to the invoices for the time period analyzed, but tips and gratuities in the exported reports do not tie to what shows on the screen or in the invoices.  There are no open shifts or pooled tips causing the issue.  We have had over a dozen interactions on online chat and no one has been able to explain the discrepancy.  My concern if that tips and gratuities do not foot for one employee, how many other employees might be affected? We use the labor reports to feed payroll.  Can they be trusted?

[drdgreen · Accepted solution]

After speaking with over a dozen chat and help line representatives who were unable to address the problem, I finally received a call from someone on the escalation team who could speak to the issue. We determined that NetSales associated with the Delivery and Catering employee hits revenue on the day of the event. While this treatment appears to be consistent across all reports in the system, tips and gratuities which accrue to the employee are not reported consistently, so be careful where you are pulling data from for tips and gratuities.

When viewing the data associated with the employee in the Labor Summary report on the screen, tips and gratuities show as of the date of the event, but when this report is exported, these data show up when the payment is made even though NetSales in the exported report post on the day of the event (yes, the treatment between the numbers is not consistent from a timing standpoint).  In the Sales Summary report, when filtering for the Catering and Events employee, tips and gratuities post to revenue on the day of the event; this is reported the same way on the screen and in the exported report.

If you want to reconcile tips and gratuities due to the difference in recognition method, you must use the Deposit Sales Collected report which shows tips and gratuities for each invoice which were paid on a date that is different from the event date.

[Rob]

Thanks for coming back and updating your post!