This article explains how to configure Payroll Upload Settings in eComply and prepare payroll files for upload into a Certified Payroll Report (CPR). This process allows users to import employee payroll information using a structured file instead of entering data manually.

Configuring Payroll Upload Settings

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

1. Navigate to Setup
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. Select the dropdown menu to review the supported payroll systems.

5. Select the payroll system you use.

   If your payroll system is not listed, you have the following options:

   1. Check to see if your payroll software (LCP Tracker, ADP, QuickBooks 2014, etc.) can export the data into one of the supported payroll software formats. If it is available you will simply download the export from your accounting software and directly upload the file into the CPR. There will not be a downable file provided.
   2. Select eComply CPR CSV Template or Legacy eComply CPR CSV Template, which is a template where you can populate your data and upload it to the system.
   3. Choose to manually enter your data when creating a CPR. Once you have created a CPR, you can copy it to a new one and change the wage and hours being reported for the next reporting period.
6. Select Submit to save your selection.

Preparing the Payroll File

Depending on the type of upload you will utilize there are a few requirements you want to review. After configuring the Payroll Upload Settings, you will need to review the file you plan to upload into the system.

Using a payroll system export file

Follow these instructions if you are using a payroll system to submit your CPR data. 

1. Export your file in the applicable format from your payroll system. 
2. Verify the following fields are present in your file:
   • 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, such as Apprentice or Journeyman.
   • Rate: The hourly rate for the employee.
   • Hours: The hours worked by the employee.
3. Save the completed file to your computer.
4. Proceed to reporting your certified payroll report. You may also need to perform specific mapping. For more information, see Upload CPR Data and Perform Payroll Import Mapping.

Using the eComply CPR CSV Template

Following these instructions if you are using our standard downloadable file.

1. From the left Navigation pane, select Setup > Payroll Upload Settings.

2. On the Basic Settings tab, locate Template, and download the eComply CPR CSV Template (or Legacy eComply CPR CSV Template) file. 

   Note: On first use, select Submit to reveal the template and then select the linked .csv file to download it.

3. Complete all required fields for each employee. See the Required Fields table below.
4. Complete any additional fields that apply to the employee’s payroll. Some information needed to submit a CPR may not be noted as required because the required value depends on the payroll data. For example, you must report hours worked, but the type of hours—such as regular time or overtime—may vary.  See the Additional Fields table below.
5. Save the completed file using a name that identifies the project and week-ending date.
6. Proceed to reporting your certified payroll report. For more information, see Upload CPR Data and Perform Payroll Import Mapping.

Required fields

Additional fields

Employee and Payroll Information

 Other Deductions

 The accepted Other Deduction descriptions are: 

• Child Support
• Company Finance Retirement Plan / Pension
• Deferred Compensation Plan / 401K
• Dental Insurance
• Disability Insurance
• Employee Savings Plan
• Garnishment
• Health Insurance
• Life Insurance
• Miscellaneous
• Section 125 Cafeteria
• Supplemental Dues
• Union Vacation Fund
• Vision Insurance

 Other Project Hours and Benefits

 Regular Time

Swing Time

Overtime

Graveyard Time

Note:

1. Numbers must be in numeric format. It should exclude dollar ($) and comma (,) symbols. 
2. If possible, total tax and other deductions should be broken down to FICA, Fed Withholding, State Withholding.

You can streamline CPR creation by configuring your payroll upload format and preparing employee payroll data from a supported payroll system or either of the eComply CPR CSV templates. Reviewing required employee, payroll, and classification information before uploading helps ensure the data can be matched and processed correctly in eComply. 

If you require additional assistance, select Submit a Request to create a support ticket.