Payroll summary
The "after": one line per employee. Open a row to see every step of the calculation.
Labor cost by department
| Department | Hours | Labor cost | Share |
|---|---|---|---|
| Checkout | 499.00 | $8,084.29 | 33.0% |
| Floor | 479.50 | $9,788.42 | 40.1% |
| Stockroom | 394.88 | $6,339.38 | 25.9% |
| Unassigned | 15.90 | $254.40 | 1.0% |
| Total | 1,389.28 | $24,466.49 | 100.0% |
Labor cost is gross pay: regular + overtime + add-ons - absence deductions. The department comes from each shift's clock-in row; shifts without one are Unassigned.
Labor cost by store and department
| Store | Department | Hours | Labor cost |
|---|---|---|---|
| A Northgate Market | Checkout | 231.40 | $3,782.92 |
| Floor | 164.50 | $3,311.27 | |
| Stockroom | 152.00 | $2,476.00 | |
| Unassigned | 15.90 | $254.40 | |
| Store A total | 563.80 | $9,824.59 | |
| B Riverside Plaza | Checkout | 84.00 | $1,305.02 |
| Floor | 153.00 | $3,132.00 | |
| Stockroom | 171.46 | $2,756.37 | |
| Store B total | 408.46 | $7,193.39 | |
| C Lakeview Commons | Checkout | 183.60 | $2,996.35 |
| Floor | 162.00 | $3,345.15 | |
| Stockroom | 71.42 | $1,107.01 | |
| Store C total | 417.02 | $7,448.51 |
Deductions = penalties + loans and advances + custom deductions. Absence deductions are already taken out of gross. Net before taxes = gross - deductions. Sort by gross
| Employee | Home store | Pay type | Reg. hours | OT hours | Regular pay | OT pay | Add-ons | Deductions | Gross | Net before taxes | Exceptions |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Avery Holt E01 | Store A | Salaried | 84.50 | 0.00 | $2,000.00 | $0.00 | $0.00 | $90.00 | $2,000.00 | $1,910.00 | To discuss 1 |
| Blake Moreno E02 | Store A | Hourly | 79.50 | 0.00 | $1,272.00 | $0.00 | $0.00 | $50.88 | $1,272.00 | $1,221.12 | Needs review 3 |
| Casey Lin E03 | Store A | Hourly | 72.00 | 0.00 | $1,116.00 | $0.00 | $0.00 | $44.64 | $1,116.00 | $1,071.36 | Needs review 1 |
| Devon Price E04 | Store A | Hourly | 80.00 | 0.00 | $1,360.00 | $0.00 | $0.00 | $54.40 | $1,360.00 | $1,305.60 | Info 1 |
| Emery Walsh E05 | Store A | Hourly | 77.90 | 2.00 | $1,318.35 | $16.50 | $0.00 | $53.40 | $1,334.85 | $1,281.45 | Info 1 |
| Finley Cruz E06 | Store A | Hourly | 80.00 | 4.00 | $1,344.00 | $32.00 | $0.00 | $55.04 | $1,376.00 | $1,320.96 | Info 1 |
| Harper Lane E07 | Store B | Salaried | 81.00 | 0.00 | $2,200.00 | $0.00 | $0.00 | $89.10 | $1,980.00 | $1,890.90 | To discuss 1 |
| Jordan Ellis E08 | Store B | Hourly | 72.00 | 0.00 | $1,080.00 | $0.00 | $0.00 | $43.20 | $1,080.00 | $1,036.80 | Needs review 1 |
| Kai Bennett E09 | Store B | Hourly | 79.46 | 0.00 | $1,355.64 | $0.00 | $0.00 | $54.23 | $1,355.64 | $1,301.41 | Info 2 |
| Logan Reyes E10 | Store B | Hourly | 80.00 | 0.00 | $1,288.00 | $0.00 | $0.00 | $51.52 | $1,288.00 | $1,236.48 | Needs review 1 |
| Morgan Shah E11 | Store A | Hourly | 80.00 | 4.00 | $1,368.00 | $33.09 | $0.00 | $56.04 | $1,401.09 | $1,345.05 | Info 2 |
| Nico Fischer E12 | Store B | Hourly | 80.00 | 0.00 | $1,200.00 | $0.00 | $0.00 | $198.00 | $1,200.00 | $1,002.00 | Info 1 |
| Parker Dunn E13 | Store C | Salaried | 45.00 | 0.00 | $1,000.00 | $0.00 | $0.00 | $240.00 | $1,000.00 | $760.00 | Needs review 1 |
| Quinn Harlow E14 | Store C | Salaried | 72.00 | 0.00 | $1,600.00 | $0.00 | $0.00 | $72.00 | $1,600.00 | $1,528.00 | Info 1 |
| Riley Okafor E15 | Store C | Hourly | 80.00 | 5.00 | $1,275.00 | $42.50 | $90.00 | $56.31 | $1,407.50 | $1,351.19 | Info 1 |
| Sage Delgado E16 | Store C | Hourly | 80.00 | 0.00 | $1,280.00 | $0.00 | $100.00 | $331.20 | $1,380.00 | $1,048.80 | Needs review 1 |
| Taylor Voss E17 | Store C | Hourly | 71.42 | 0.00 | $1,107.01 | $0.00 | $0.00 | $44.28 | $1,107.01 | $1,062.73 | Info 1 |
| Rowan Pike E18 | Store C | Hourly | 79.50 | 0.00 | $1,208.40 | $0.00 | $0.00 | $48.33 | $1,208.40 | $1,160.07 | |
| Total (18 employees) | 1,374.28 | 15.00 | $24,372.40 | $124.09 | $190.00 | $1,632.57 | $24,466.49 | $22,833.92 | |||
Federal, state and payroll tax withholding is calculated by your payroll provider (for example ADP, Gusto or Paychex). This system prepares checked, ready-to-run numbers for it.