LCPTracker XLS Format

An Excel file can be uploaded into LCPTracker, saving you from having to enter data manually.

Use Spectrum to create a file that can be opened in Excel and saved as an XLS file. Access this feature by selecting LCPTracker file on the Certified Payroll Report starting screen.

Requirements

It is a requirement that the union and wage code system be used to utilize the LCPTracker format. NonUnion Pay Groups are not supported for LCPTracking reporting.

Unions are required as the union code references the 'Certified craft code'. Wage codes are required as they reference the 'Certified labor code.'

Information Needed To Get Started

Before you begin, you will need to obtain the following from the DOT/agency:
  • Your user name and password at LCPTracker
  • Your Contractor/Vendor ID code
  • The Contract #
  • The Project #
  • The Craft and Labor codes used
  • Benefit program information
  • Determine how you will identify the employee
    • Social Security Number
    • Partial Social Security Number
    • Employee Code
  • Determine whether you are required to include the employee's address or not

Certified Benefit Program Maintenance

Use this screen to map add-ons, deductions and union fringe benefits to their 'Program type'.
  1. Navigate to Payroll > Maintenance > Certified Benefit Program.
  2. Select Build.
  3. Enter Job state and XML format of LCPTracker.
  4. Select OK.
  5. All of the various program types will default on the screen.
  6. Highlight the first program type and select Edit.
  7. Enter program information on the Properties tab.
    Note: Even though certain DOT/agencies require that these fields all be completed, they are not required entry fields in Spectrum. This allows you to enter the information you have and return later if requirements remain.
  8. On the Fringes tab, select all items to map to this program type.
  9. On the Adds / Deducts tab, select all items to map to this program type.
  10. Select OK.
  11. Continue assigning fringes, add-ons and deductions to all program types.

Union File Maintenance

By union, enter the Certified craft code. These numerical codes come from the state or agency to which the payroll is being submitted. Enter only the code in this field, as entry of the description will result in errors.

Non-union employers must set up a cash fringe add-on code with calculation method of Prevailing Wage Adjustment and health and welfare add-on code with calculation method of Health and Welfare.