eComply Payroll Import Mapping

Objective

Contractors have the option to use payroll applications to assist them in managing their certified payroll reporting. eComply 2.0 offers the ability to work with those application vendors to assist the contractor in using an exported file from the payroll applications and import it into the eComply 2.0 system.

For anyone interested in using their payroll application to import certified payrolls into the eComply 2.0 system, please feel free to contact Support@ecomplysolutions.com and a Support Representative will be able to assist you.

Process

Importing Payroll

Once your account has been configured to utilize payroll, you can start importing your payrolls by following these steps:

  1. Log into eComply 2.0
  2. Navigate to Activities > Manage CPRs

Figure 1 - Activities > Manage CPRs

Activities menu showing Certified Payrolls with a Manage CPRs option, allowing users to access and manage certified payroll reports.
  1. On the right-hand side of the screen, find the project you will be submitting a CPR for and click on your company name under that project.
  2. If this is your first CPR, you will not see any CPRs listed. If you have previously submitted CPRs, you will see them on the right-hand side of the screen. To import your CPR file, click on “New CPR.”

Figure 2 - Manage CPRs & New CPR

CPR Management page to search, filter, and sort certified payroll reports, view existing CPRs, or select New CPR to add a report.
  1. The first screen/tab in the CPR Creation Wizard will display the agency you will be submitting the CPR to and the project name. Click “Next” to go to the next screen/tab.
  2. The second screen/tab will allow you to select the week ending date for the CPR. If you have submitted a CPR previously, the date will auto populate as the next week ending date in sequential order.
  3. To import the payroll file from your payroll application, click on “Browse.”

Figure 3 - Select Import File

Certified Payroll Report Wizard to enter week-ending date, payroll number, upload CPR data file, and proceed to next step.
  1. Once you navigate to the import file you wish to load, highlight the file, double click or click on “Open” to have the eComply 2.0 system to process the file.
  2. The system will read the file and provide friendly messages instructing you what the next step will be. With this being the first time you are using the payroll import function, you will receive a message similar to the one shown below.
  3. You have the ability to click on “(MAP)” or click on “Setup” and navigate to the “Payroll Upload Settings” link.

Figure 4 - Unmapped Crafts/Classes Message

Certified Payroll Report Wizard page to select week-ending date, enter payroll details, upload CPR data, and review mapping errors.

Note: This message is just to let you know you need to map the classifications from your import file to the classifications used in your account for eComply 2.0.

Mapping Crafts and Classes for Payroll Import

Now that you have loaded the first payroll file, the eComply 2.0 system has the classifications from your import file stored within the system. All that needs to be done is identify what classifications within the system are the classifications used in your import file.

  1. From the “CPR Creation Wizard” second screen/tab, you can either click on “(MAP)” in the mapping message you received or click on “Setup” and navigate to the “Payroll Upload Settings” link.
    Note: If you are prompted to navigate from the current screen, click “Ok” or “Leave Page.”

Figure 5 - Setup > CPR Upload Settings

Setup tab displaying Certified Reports menu options, allowing users to manage organization settings, employees, and payroll upload configuration.
  1. Do not do anything to the first tab, “Basic Settings”. This shows the interface profile you are currently assigned to. The second tab, “Craft/Class Mapping”, is the tab you will want to click on.

Figure 6 - Craft/Class Mapping

Payroll Upload Settings page on Craft/Class Mapping tab, showing unmapped crafts and allowing users to edit or add mappings.
  1. On the second tab, you will see the crafts, classifications and trade that were imported from your import file. Here you can also see if they have already been mapped to a classification within 2.0.

Figure 7 - Unmapped Crafts & Classes

Payroll Upload Settings showing Craft/Class Mapping table with unmapped crafts and trades, allowing users to review and update mappings.
  1. To map a craft/class and trade, click on the pencil icon to the right of the craft/class and trade you wish to map.
  2. On this screen you will be able to select the craft/class and trade to match the classification used in your import file. Click on the drop down “System Craft/Class” to select the classification.

Figure 8 - Update Craft/Class Mapping

Update Craft/Class Map form allowing users to select a system craft/class from a dropdown and submit the mapping.

Note: Only crafts/classes that were previously selected and added under “Setup > Craft and Classification” will appear as a selection. If you need to add additional crafts and classes to choose from, please navigate to “Setup > Crafts and Classifications” to add them or for further assistance, please check the user manual for instructions on how to add the crafts and classifications.

  1. Do the same for the trade. Select “Journeyman” or “Apprentice” depending on the status of the employee.

Figure 9 - Mapped Craft, Class and Trade

Update Craft/Class Map form displaying selected system craft and trade, allowing users to confirm and submit the mapping.

  1. Once you have completed this, click “Submit” to be brought back to the main “Payroll Upload Settings” screen. Repeat these steps for all crafts and classifications needing to be mapped.

Figure 10 - Successful Mapping

Payroll Upload Settings showing Craft/Class Mapping table with mapped crafts and trades, allowing users to review or edit mappings.
  1. Now that your classifications have been mapped in the system you can now go back to “Activities > Manage CPRs” and import the payroll again as described above in above.

Other Deduction Mapping

Some payroll applications allow the ability to specify the types of deductions your company has for your employees. eComply 2.0 also allows the option to map those deductions, as well. The agency you are performing work for will specify the deductions they expect to see within the CPRs submitted. An example of a message you will get when you need to map your deductions is seen below.

Figure 11 - Deduction Mapping Message

Certified Payroll Report Wizard showing week-ending date entry and CPR upload, with an error about a missing other deduction description.

Note: This message is letting you know that the deduction type in the import file needs to be mapped to the deductions specified by the agency.

  1. From the “Setup” tab, navigate to the “Payroll Upload Settings” link.

Figure 12 - Setup > Payroll Upload Settings

Setup tab displaying Certified Reports menu options, allowing users to manage organization settings, employees, and payroll upload configuration.

  1. The third tab on this screen is “Other Deduction Mapping.” From this tab, you can map any deductions that the agency has already approved and added that also appear in your upload file.
    Note: If you do not see a specific deduction that applies to your employees, you will want to contact the agency the project is under to request having the deduction added.
  2. Using the drop-down menu, select the deduction that you need to map from your import file into the eComply 2.0 system.

Figure 13 - Mapping Deductions

Payroll Upload Settings on Other Deductions Mapping tab, allowing users to select a deduction type and add a mapping.
  1. In the field labeled “Mapped Name,” you will want to enter the deduction as it is seen in your import file.
    Note: The “Mapped Name” needs to be identical to how it is seen in your import file. This does mean it IS case sensitive.

Figure 14 - Mapped Name

Payroll Upload Settings page showing Other Deductions Mapping, where users select a deduction type and add or review mapped names.
  1. Once you have entered in the Deduction to be mapped and the “Mapped Name,” click on “Add Mapping.” This will bring the mapped deduction down to the lower section of the screen identifying it has been added into the eComply 2.0 system.

Figure 15 - Successful Mapping Deduction

Payroll Upload Settings page showing Other Deductions Mapping, where users add and review mapped names for deduction types like Child Support.
  1. Now that your deductions have been mapped in the system you can now go back to “Activities > Manage CPRs” and import the payroll again as described above in above.

Summary

This article explains how to import payroll data into eComply 2.0 for Certified Payroll Report (CPR) submission. It outlines how to upload payroll files, manage unmapped crafts or deductions, and align imported data with the classifications and deduction types used in the system. Following these steps ensures payroll information is accurately imported and compliant with agency reporting requirements.

If you still require additional assistance, close this tab and return back to the system and submit a support ticket.

Related to

Was this article helpful?

0 out of 0 found this helpful