eComply Payroll Import Mapping

Overview

Contractors have the option to use payroll applications to assist them in managing their certified payroll reporting. eComply 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 system.

For anyone interested in using their payroll application to import certified payrolls into the eComply system, please feel free to contact Support to assist you.

Steps

Importing Payroll

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

  1. Sign in to eComply.
  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 select 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, select 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. Select 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, select 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, Select Open to have eComply 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 select (MAP) or select 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.

Mapping Crafts and Classes for Payroll Import

Now that you have loaded the first payroll file, the eComply 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 select (MAP) in the mapping message you received or select Setup and navigate to the Payroll Upload Settings link.
    Note: If you are prompted to navigate from the current screen, select 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 in the Basic Settings tab. This shows the interface profile you are currently assigned to. The second tab, Craft/Class Mapping, is the tab you should select.

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 eComply.

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, select 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. Select 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, select 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 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, select Payroll Upload Settings.

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 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, select Add Mapping. This will bring the mapped deduction down to the lower section of the screen identifying it has been added into eComply.

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 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.

For more detailed guidance on specific features and functionality, explore related articles in the Help Center. If you require additional assistance, select Submit a Request to create a support ticket.

Related to

Was this article helpful?

0 out of 2 found this helpful