Skip to main content

Payroll Details Report

The Payroll Details Report provides the most detailed view of payroll. It lists every employee shift, including clock-in/out times, pay, sales, and a full breakdown of tips. This report combines the depth of the Payroll Report with the added clarity of tip details and payroll summaries, making it ideal for audits and payroll reconciliation.

Where to find the report

  • Backoffice --> Reporting --> Reports --> Payroll folder --> Payroll Details --> Select Date --> Execute

image.png

What it looks like

image.png


Report Parts

Employee Shift Details

Each employee section lists shifts worked during the period.

  • Clock In/Out Date & Time – Exact times for each shift worked.

  • Job Role – The role worked that shift (e.g., Bartender, Server, Cook).

  • Pay Rate – The employee’s hourly wage for that role.

  • Hours Worked – Total hours for the shift.

  • Pay – Wages earned for the shift.

  • Sales – Sales attributed to that employee during the shift.

  • Tips – Tip breakdown for the shift:

    • CC Tips – Tips left on credit card, gift card, or house account.

    • CC Tip Fee – Processing fees deducted from credit card tips (negative value).

    • Cash Tips – Cash tips reported.

    • Gratuities – Auto-added gratuities (e.g., large party charges).

    • Tipouts Given – Tips paid out to another employee (negative).

    • Tipouts Received – Tips received from another employee.

    • Total Tips – Combined tips for that shift.

    • Retained Tips – Net tips the employee kept after fees and tipouts.

Additional Tip Info

Some employees will have an Additional Tip Info line showing manual adjustments or carryover tips.

  • Purpose – Used to capture tips not tied to a single shift (e.g., adjustments, corrections, or pooled distributions).

  • Displayed – As separate line items in the employee’s section.

Employee Totals

At the end of each employee’s section, the report shows:

  • Regular Hours / OT Hours / Total Hours – Total hours worked in the period.

  • Regular Pay / OT Pay / Total Pay – Total wages earned.

  • Sales – Employee’s total sales.

  • Tips – Combined tips across all shifts.


Pay Period Summary

At the end of the report, payroll and tips are summarized by job role and then totaled for the entire pay period.

  • Job Role Totals – Summed across all employees in each role:

    • Regular Hours, OT Hours, Total Hours

    • Regular Pay, OT Pay, Total Pay

    • Sales and Tips (by type: CC, cash, gratuities, tipouts, retained)

  • Grand Totals – Overall totals for all employees and all roles.

How to Use This Report

This report helps you:

  • Audit employee timecards with clock-in/out detail.

  • Reconcile tips, including credit card fees, cash tips, and tipouts.

  • Review sales by employee alongside payroll costs.

  • Track overtime usage and its impact on pay.

  • Confirm payroll totals before submission to your provider.

  • Investigate discrepancies by drilling down into shift-level detail.