This article explains how to upload payroll data from your payroll system into a Certified Payroll Report (CPR). This process allows users to import employee payroll information using a structured template instead of entering data manually. Completing this upload ensures accurate employee reporting and helps maintain compliance with CPR requirements.

• You must have Manage Payroll Upload access to configure upload settings.

• The vendor profile must already exist.

• You must have access to the correct payroll data from your payroll system.

• PDFs are not acceptable for CPR uploads. Some acceptable formats include: CSV, XLSX, XML, etc.

Preparing the Payroll Template

1. Export your file in the applicable format from your payroll system

2. Before you upload, verify the following fields:

• Payroll Number & Week Ending Date: These must be precise to avoid system errors.
• Employee Identity: Ensure the first name, last name, and SSN are correct so the system can match the record to the specific employee.

• Trade – the Craft category for the employee.

• Classification – Worker level (example: Apprentice or Journeyman).

  • Note: You can map the classifications 

    • to your file on the Payroll Upload Settings screen or 

    • during the CPR upload process (covered below).

3. Save the completed file ot your computer.

Configuring Payroll Upload Settings

Before uploading payroll data, you must configure your organization’s payroll upload format.

1. Navigate to Settings.

2. Scroll to Payroll Upload Settings.

   

3. From the Basic Settings tab, locate the Accounting Profile field. It will likely show as Unassigned, if this is your first time setting up a template.

4. Click the dropdown menu to select the appropriate Accouting Profile (example: LCM CSV). 

   

a. If your payroll software is not listed, downlaod the LCM CSV template provided or contact Customer Support.

b. Prepare the LCM template to fit your organization’s needs.

5. Click Submit to save your selection.

Uploading the CPR

1. Navigate to Activities in the left navigation pane.

2. Select Manage CPRs.

3. Choose the appropriate Project Name.

4. Click New CPR/NP and enter the Week-Ending Date and Payroll Number.

Pro Tip: Double-check that the Week Ending Date and Payroll Number on this screen match your Excel file.

5. Under Upload CPR Data, click Choose File and add you template.

Mapping Classifications

If classification mapping is required during the upload, you will see a red error message regarding craft/class mapping.

1. Click the bolded Map link.

2. Review the imported classification from your file.

3. Select the corresponding system classification. For example, if your import says "Blase" for craft and "Journeyman" for trade, select the corresponding system craft and trade (e.g., Blaster - Journeyman).

4. Click Submit.

Once mapping is complete, the classifications are linked and you can continue to upload.

Resolving Errors and Validating Data

1. If there are errors, you will see a yellow warning box with a list of identified errors.

2. Once resolved, attempt to upload the file again.
3. If the information is complete, the status displays “Ready.” If an employee shows “Not Ready,” a required field is missing. Click the pencil icon to edit the employee and complete fields such as trade, rate, and hours before submitting.

Troubleshooting / Common Issues

• Classification Mapping message appears during upload
  • If you see a Classification Mapping message, it means the classification in your file does not yet match a system-defined craft. This usually occurs when the contractor has more than one job and the craft/class names differ due to having a different wage determination. Ex. Project 1 – Laborer, Project 2 – Laborer and Related Classifications.
  • What to do: Click Map, select the correct system classification, and click Submit to continue.
• Payroll upload does not populate employee data
  • If the CPR loads but employee data does not appear, the payroll identifiers may not match.
  • What to check: Confirm that the Week Ending Date and Payroll Number in the CPR exactly match the values in your Excel file.
• Employee record is not recognized
  • If an employee does not import correctly, the system may be unable to match the record.
  • What to check: Verify that the employee’s First Name, Last Name, and SSN in the template match the employee record in the system. Also, it is possible that the employee is not yet added on your account.
• Validation errors related to demographic fields
  • If you receive validation errors for demographic information, the data in your file may not a match the system-defined options.
  • What to check: Ensure Gender, Ethnicity, DOB, and Marital Status  in your payroll system match the available selections configured in eComply. You can bypass this step.
• File does not upload
  • File does not come directly from the accounting profile/payroll program you selected. Or the file is in an incorrect format. 
  • PDFs are not acceptable. Some acceptable formats include: CSV, XLSX, XML, etc.
• No Fringe Benefits Package Error
  • This occurs when an employee is not associated with a Fringe Benefits package. Or the Fringe Benefits package has expired.
  • What to check: Ensure the employee is associated with a Fringe Benefits package. And check the expiration dates of the packages.

If issues continue after verifying these items, contact your payroll system administrator or Customer Support for assistance.

Uploading payroll data through the payroll upload feature streamlines Certified Payroll Report (CPR) creation by reducing manual data entry and improving accuracy. By selecting the correct template format, preparing required employee data, and completing classification mapping when prompted, users can efficiently import payroll records into the system. Proper configuration and data validation help ensure successful uploads, accurate compliance reporting, and smoother CPR processing.