Labor Reports

Job Labor Report

The Job Labor report contains estimated, actual, and remaining labor hours for all labor cost codes for the job, as well as field estimated percentage complete and the percentage of the cost code completed based on the field estimate. This report also projects gain or loss for each cost code, based on the field-estimated percentage complete.

1. Select Reports > Job Cost > Labor Reports > Job Labor.
2. Use the From and To lookup buttons to select the print range. Select Insert >>.
3. Select Print.

Certified Payroll Report

The Certified Payroll report lists employee information, details of hours worked, hourly rate, gross earned in job, deductions, and net weekly pay for the selected jobs.

To print accurate certified payroll reports, you must print your payroll checks using the Microsoft Dynamics GP Payroll module.

You must have an address ID entered in the Employee Address Maintenance window (Cards > Payroll > Employee > Address) for transactions to appear on the Certified Payroll report. To print a Certified Payroll report using SRS, refer to the TimeTrack manual. When building your payroll batches for certified payroll checks, the From and To dates of the Pay Period Date field in the Build Payroll Checks window (Transactions > Payroll > Build Checks) must be in a seven-day range. The From (beginning) date must be the beginning day of the week; the To (ending) date must be the week-ending date from the payroll transaction. This applies to both Microsoft Dynamics GP and TimeTrack payroll transactions.

1. Select Reports > Job Cost > Labor Reports > Certified Payroll.
2. Enter the transaction beginning and ending dates.
3. Select to print the report for all transactions, one job, or a range of jobs. Enter a Job Number or Range.
4. Select Print.

Union Report

The Union report is a combination of the Union report and Union Summary report. Both reports contain weekly pay amounts, benefit, and deduction contributions for each employee in the union. You can also sort the employees by name or position and automatically calculate gross wages by transaction date or check date. A maximum total of 150 benefits and deductions will print on the Union report. The Union Summary report lists a summary for all union employees.

1. Select Reports > Job Cost > Labor Reports > Union.
2. Enter the date to begin the report. If you are going to calculate gross wages based on a check date, enter the first day of the month in which the check was issued, rather than the first day of the month when the pay period began.
3. Select to print a Union report, Union Summary report, or both. The default is Summary, which is both reports. To print only the Union Summary report, mark the Summary Only checkbox. To print only the Union report, unmark both checkboxes.

4. Enter the beginning and ending dates of the pay weeks for which you want report information. 

   

   For this report, the pay week must begin and end on the first and last days of the week as defined for the pay period (Transactions > Payroll > Build Checks).

5. Select to Sort the report by position or by employee last name. If you sort by position, a subtotal is given for each position. The report also includes a total by union. If you sort by employee last name, the report will total by union and not by position.
6. Select to Calculate Gross Wages by check date or transaction date. If you select to calculate by check date, the employee summary table is used to get the gross wages. Make sure that, if your pay period begins in one month and ends in another, the Month Begin Date is the first day of the month in which the check was issued, rather than the first day of the month in which the pay period began. If you select to calculate by transaction date, the payroll transaction history table is used to get the gross wage amount for each transaction.
7. Select Print.

Rate Class Setup Report

The Rate Class Setup report lists all rate classes entered.

1. Select Reports > Job Cost > Labor Reports > Rate Class.
2. Enter a rate class range or select All to include all rate classes.
3. Enter a union code range or select All to include all union codes.
4. Select Print.

Rate Class Union Report

The Rate Class Union report is a combination of  the Union report and Union Summary report. Both reports contain the amount of hours and gross wages. The Union report is organized by union employee; the Union Summary report is organized by union and rate class. You can run the report for a single union code or a range of union codes.

1. Select Reports > Job Cost > Labor Reports > Rate Class Union.
2. In the Month Begin Date field, enter the beginning date for the report.
3. Select to print a Union report, Union Summary report, or both. The default is Summary, which is both reports. To print only the Union Summary report, mark the Summary Only checkbox. To print only the Union report, unmark both checkboxes.
4. Enter the starting and ending union codes.
5. Enter the beginning and ending dates for each week. If you leave these fields blank, the dates will automatically fill in, starting from the date entered in the Month Begin Date field.
6. In the Options area, select either Position or Name as the sorting option for the report.
7. Select Print.

Employee Union Report

The Employee Union report lists all the employees who belong to a union. The report contains deduction/benefits amounts, hours, and pay amount. The report is organized by union, then rate class.

1. Select Reports > Job Cost > Labor Reports > Employee Union.

2. Use the Ranges drop-down list to select the range for running the report. You can specify ranges for the employee ID, week-ending date, and union code. 

   

   If you don't select a range, the report will print all values for all range types.

3. In the From and To fields, select the beginning and ending values for your range. For the Employee ID and Union Code ranges, use the lookup buttons to select values. For the Week-Ending Date range, enter the beginning and ending transaction dates, not the week-ending dates.
4. Select Insert >>. You can create one range for each type of range.
5. Select Print.

Monthly Union Report

The Monthly Union report contains the number of hours and amount of earnings for each union employee within a specified time period and union range. The report also contains hours and earnings by rate class. This report is organized by union code.

1. Select Reports > Job Cost > Labor Reports > Monthly Union.
2. In the Ranges field, use the drop-down list to select the range(s) for the report. You can specify ranges for the week-ending date and for union code.
3. In the From and To fields, enter the beginning and ending values for your range. For the Week-Ending Date range, enter the beginning and ending transaction dates, not the week-ending dates.
4. Select Insert >>. You can create one range for each type of range.
5. Select Print.

Monthly Payroll Report

The Monthly Payroll report contains the total hours and gross earnings for union employees within a specified time period.

1. Select Reports > Job Cost > Labor Reports > Monthly Payroll.
2. In the From and To fields, enter the beginning and ending values for your range. Enter the beginning and ending transaction dates, not the week-ending dates.
3. Select the Insert >>. You can select one range per report.
4. Select Print.

Monthly Contribution Report

The Monthly Contribution report contains the benefits, deductions, hours, and gross earnings for each employee in a union.

1. Select Reports > Job Cost > Labor Reports > Monthly Contribution.
2. In the Ranges field, use the drop-down list to select the range(s) for the report. You can specify ranges for the week-ending date and for union code.
3. In the From and To fields, select the beginning and ending values for your range. For the Week-Ending Date range, enter the beginning and ending transaction dates, not the week-ending dates.
4. Select Insert >>. You can create one range for each type of range.
5. Select Print.

Technician Schedule Report

The Technician Schedule report lists jobs and the technicians scheduled to work on the jobs. You can print the report for all jobs, a single job, or a range of jobs. You can also filter the report by cost code number. The Technician Schedule report is available if you're using the Job Scheduling feature.

1. Select Reports > Job Cost > Labor Reports > Technician Schedule.
2. Select to print the report for all jobs, a single job, or a range of jobs. Enter the Job Number or range.
3. Enter the date range.
4. Select to print the report for all cost codes or a specific cost code. Enter the Cost Code.
5. Select Print.