Payroll Reports tab with KPIs, composition chart, net pay by staff, and CSV export.
KPI strip
Payroll composition
A stacked bar chart split by:- Regular pay
- Overtime pay
- Commission
- Tips
- Deductions (negative)
- Advances (negative)
Net pay by staff
Bar chart of every staff member’s net pay for the period, sorted descending. Useful for spotting outliers.Hours by staff
Grouped bar chart with regular hours and overtime hours per staff. Cross-check with clock-in expectations.Detailed breakdown
A scrollable table with one row per staff. Columns:- Staff, Role
- Regular hours, OT hours
- Gross, Tips, Deductions, Advances
- Net
- Status (Draft/Approved/Paid/Disputed)
Filters
Net pay
Top earners, mid, low, or negative net pay only.
Hours
High-hour staff, low-hour staff, or overtime-only.
Tips
Staff who received tips vs those who did not.
Status
Filter by Draft, Approved, Paid, or Disputed.
CSV export
1
Filter as needed
Apply the period and any filters above.
2
Click Export CSV
A CSV downloads with every row currently visible in the table.
3
Import into accounting
Open in Excel, Google Sheets, QuickBooks, or your accounting package.
For a full-period export including all statuses, clear filters and set the period picker to the desired range before exporting.
Tips and best practices
- Run the report before approving records to catch outliers early.
- Export CSV at month-end into a dedicated folder — you now have a permanent archive.
- Watch the OT slice of the composition chart. Rising OT usually means understaffing, not high demand.
- Compare Total Net Pay period-over-period to detect creep.
Common mistakes
- Exporting with filters and forgetting them. Always clear filters if you want a full export.
- Reading Draft records as final. Filter to Approved+Paid for accounting purposes.
- Ignoring negative net pay. Investigate every negative record — usually excessive advances.