Troubleshooting missing POS tip data

Updated

Missing tip data in 7shifts Tip Pool reports usually points to a mapping mismatch or incomplete punch data between 7shifts and your POS. This is sometimes described as tips not showing up in the tip pool or tip pool contributions not syncing from the POS.

Why is tip data missing from my Tip Pool report when using a POS integration?

When 7shifts can't match POS data to the right employee or role, tip contributions don't calculate or appear in Tip Pool reports. Common causes include unmapped roles or employees, incorrect mapping ratios, or employees who didn't punch out at the end of their shift.

What To Do

Important: Rule changes in 7shifts Tip Pooling apply to the current open pay period only. Deactivating an employee removes them from open pay periods, which affects your reporting figures.

  1. Ensure employees in your POS are assigned the specific job codes they perform. A receipt stays under the name of the staff member who opened it, even if the table is transferred.

  2. Ensure 7shifts Roles match their counterparts in the POS.

    Important: 7shifts requires a one-to-one mapping ratio between roles (for example, "Bartender" in 7shifts maps to "Bar Keeper" in your POS). Mapping multiple POS job codes to a single 7shifts Role isn't supported. Create additional Roles in 7shifts to maintain one-to-one pairs.

  3. In 7shifts, confirm that all employees are correctly mapped to their POS profiles so tip data syncs to the right person.

  4. Employees must punch out at the end of every shift, either through your POS or 7punches. Open punches prevent tips from calculating and allocating correctly, especially when using Dayparts.

    Tip: Enable Alerts for Missing Punches in 7shifts to get notified when employees forget to clock out.

Issue Unresolved

If the steps above don't resolve the discrepancy, contact support. To help our team investigate faster, pull the report for your POS system below before you reach out.

GoTab

  • Pull the Tip Detail Report from GoTab. It shows each server's name, totals, tips, autogratuities, date, and time. You may need to adjust the file after downloading it. 7punches must be used for time clocking.

Lightspeed K-Series

  • Export the Payments Report to CSV. It lists each closed order with its payment type, date, ID, "Sold by" employee, device, amount, and payment method.
  • Go to Reports > then Reports > Staff reports > export the Labor Report to CSV with all columns. It shows tips per employee. Click an employee's name to see their tips broken down by payment method.

Upserve (Lightspeed U-Series)

  • Detailed sales or transaction report. It should list every receipt, the employee on each one, and the tips collected. Contact Upserve (Lightspeed U-Series) support if you require assistance in finding the report. 

Brink

  • Pull the Sales Details Report. It shows daily sales broken down by individual receipt.

Spot On

  • Detailed sales or transaction report. It should list every receipt, the employee on each one, and the tips collected. Contact Spot On support if you require assistance in finding the report.

Toast

  • Pull the Payments Report by navigating to Reports, then Payments, then Payments. Set the required date range, and before exporting, confirm these columns are selected: Location, Order, Date, Server, Amount, Tip, Gratuity, Total, and Status.
  • Export the Time Entries report to confirm each employee's clock data.

TouchBistro

  • Pull the Staff Performance Report. It shows credit card tips, cash tips, and auto gratuities for each employee.
  • Pull the Shift Details Report. It shows each employee's time punches, including their name, role, and shift duration.
  • Pull the Detailed Sales Report. It shows sales broken down by individual receipt.
  • Export the Sales Dashboard as a CSV. It gives an overview of daily sales and sales by category.

Square

  • Log in to Square, go to Transactions, filter by timeframe, and export the Transactions Report as a CSV. It shows daily sales broken down by individual receipt.
  • Pull the Shift Report. It shows hours worked, tip details, and a sales summary for each employee.

Revel

  • Pull the Time Worked Report. Turn on Display Roles before exporting so each employee's role appears in the file.
  • Open the Payment Summary Report and go to Payment Details. Confirm that Include tips in totals is enabled before exporting.

Qu

  • Pull the Check Details Report. It provides full check-level details for your investigation.

Related Articles

How to map roles and employees
Setting up alerts for missing punches
What happens to a Tip Pool if an employee is deactivated/inactive?

Was this article helpful?
2 out of 5 found this helpful