How to Export my Pay into Employer D

How to send the hours of my employees into Desjardins payroll system

Mark Borham avatar
Written by Mark Borham
Updated over a week ago

Before exporting your first pay

Before exporting your first payroll in Employer D format, you must set up your configuration. Here is an article that explains How to set up Employer D exportation?

A) Exporting your pay

Once the employees' timesheet have been approved, you can export the hours into Employer D

  • Click on the pink « Export pay period» button

B) Exporting options

  • Select the Employer D (Desjardins) export format

  • If you have more than one location to manage, you can segment the exportation of your payroll by location

  • Click on the « Export » button once you've selected

  • Save the spreadsheet on your desktop

  • You can modify the spreadsheet manually before importing it to Employer D

EXTRA OPTION

If you wish to use Agendrix hourly rates rather than the ones in EmployeurD, you can check the option below before exporting. Please note that the hourly rates of employees must be filled for this to work.

C) Importing data

Once in your payroll system, here’s how to import 

  • Click on the « Payroll » tab.

  • Click on « Import transactions » in the Tools subsection

D) Importation settings

  • Click on the « Choose file » button to look for the file that was exported during step B).

  • Select « Excel with columns » file format.

  • If you have more than one company in your payroll system, select the right company number in the choices shown to the right of the « Company » title.

E) Importing transactions

  • Click on the orange / red « Import » button.

F) Importation successful

  • If the word « Completed » appears in red, to the right of the « Status » title, the importation was successful, and you can now make manual changes to your payroll system, as needed.

G) Importation impact

Data imported in Employer D is always per week; this allows you to understand the earning codes repartition more easily.

H) Error messages

If a red « Not completed » status text appears, the importation process has failed.

  • Check out which of the lines are causing the errors in order to correct your import file. Details for each error are shown at the bottom of the page.

I) How to correct errors?

  • Each error is well detailed in the error table.

  • Serial number : Serial number of the employee to verify the Excel payroll export file.

  • Line no : Reference line in the Excel file. Helpful for quickly spotting the error.

  • Message : Used to see the type of error you’re dealing with. For example, if you see « G43 », it means that a data is incorrect in the Earning 43 column for overtime gains.

  • Blue « Correct » button : Allows you to manually correct errors directly from your payroll system.

Did this answer your question?