Payroll Detail Report

The Payroll Detail Report is a very valuable report for reviewing the employees work and pay details for a specified pay period.  It prints by employee and provides a signature line for verification.  Details include Date worked, Job performed, Shift in and out times, Regular hours worked, Hourly rate, Hourly Pay, Piece Quantity, Piece Rate, Piece Pay and total Pay. The report can be provided to the employee for verification and signature.  

To print the Payroll Detail report, click the Reports drop-down menu at the top of the screen. Then click Payroll Detail.

The Payroll Detail provides multiple options for generating the report.  It can be printed by Start and End Date (usually the pay period dates), Crew, Query Type (select how the crew information will be looked up, by Time Sheet, Assigned, or Employee),  Employees, Jobs, Location and Crop/Variety, Time Sheet Status (Uploaded, Approved, Complete),  Wage Rule (If wage rules are used, you must select which wage rule to run the report for), Order By (the report can be sorted by Employee#, First Name, or Last Name), and Report Type, (the report can be generated as a PDF or Excel Spreadsheet).  Except for Wage Rule, if nothing is selected, the report will include all data (i.e. all crews, all employees, all jobs etc.). Make the desired selections and click Get Report.

The report header displays the company name, FEIN number, address, crew, pay period and employee name and number.

The details for each employee includes Date worked, Job performed, Shift in and out times, Regular hours worked, Hourly rate and Hourly Pay (1), Piece Quantity, Piece Rate and Piece Pay (2) and total Pay (3) (Piece pay + Hourly Pay). 

The summary at the bottom of each employee’s detail displays the Hours Offered (4) (used in the calculation of the ¾ guarantee for H2A workers), Total Hours (5) (Hourly Hours + Piece Hours) Minimum Required Pay (6) (Regular Pay + Minimum Wage Adjustment), and the Minimum Wage Adjustment (7) (if the piece pay is less than minimum wage, this is the amount added to the piece pay to bring it up to minimum wage).

The report can be given to the employee for their review and Signature (8).  

With piece pay, Time Portal can be set up to calculate the Minimum Wage Adjustment.  If the employee does not earn enough in piece pay to make at least minimum wage, Time Portal will calculate the difference between the piece pay and minimum wage and display it as the Minimum Wage Adjustment on the report.  

If Overtime is defined in the Wage Rule, additional columns appear on the report for the various Overtimes.  For each of the three types of Overtime (1), the OT Hours, OT Rate and OT Pay (OT Hours X OT Rate) display.  In the subtotals at the bottom, the Overtime Pay (2) is displayed and added to the Regular Pay to get Gross Pay.

The last page of the report provides the Gross Total pay for the parameters specified.

NOTE: 1.  For the Overtime to be calculated and the OT columns to appear on the report, an Overtime                       rule must be defined in the Wage Rule.