Troubleshooting missing POS tip data
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.
- 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.
-
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.
- In 7shifts, confirm that all employees are correctly mapped to their POS profiles so tip data syncs to the right person.
-
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 the team investigate faster, pull the reports listed below for your specific POS system before reaching out.
GoTab
- Tip Detail Report — shows server name, totals, tips, autogratuities, date, and time. This report may require manipulation after download. 7punches must be used for time clocking.
Lightspeed POS
- Transactions Report — provides daily sales data by individual receipt and sales category.
-
Payments Report — navigate to Reports > Payments > Payments, set the required date range, and before exporting confirm these columns are selected: Location, Order, Date, Server, Amount, Tip, Gratuity, Total, and Status.
- Time Entries Export — used to confirm time clock data for each employee.
TouchBistro
- Staff Performance Report — includes credit card tips, cash tips, and auto gratuities per employee.
- Shift Details Report — shows time punch data including employee name, role, and shift duration.
- Detailed Sales Report — sales broken down by individual receipt.
- Sales Dashboard (CSV Export) — overview of daily sales and breakdown by category.
Square
-
Transactions Report — log in to Square, go to Transactions, filter the timeframe, and export as CSV. Provides daily sales data by individual receipt.
- Shift Report — includes hours worked, tip details, and sales summary per employee.
Revel
- Time Worked Report — includes hours worked. Enable "Display Roles" before exporting.
- Payment Summary Report — access Payment Details and confirm "Include tips in totals" is enabled.
Qu
-
Check Details Report — provides full check-level details to support investigations.