Access: Payroll > Tools > Import payroll transactions
This procedure allows you to import payroll data from another application.
It is possible to import year-to-date adjustments (manual cheques) throughout the year or at year-end, however the file should not contain year-to-date adjustments. The following formats are accepted: Excel, Excel in columns, fixed columns or delimited columns.
Important It is recommended to finalize all modifications and employee file creations before starting the payroll. However, if you have started your payroll (payroll status: “In progress”) it is always possible to make modifications, additions or terminations. |
1Under New import, click on Browse in the File location field, to select a file for import.
2Select the File type.
▪“Fixed column” if the data in your text file is organized in columns;
▪“Delimited columns;“ if the data is separated by semi-colons “;”;
▪“Excel” if the data comes from Microsoft® Excel application;
▪“Excel (columns)” if the data in your Microsoft® Excel file is organized in columns;
▪“Maitre’D” if the data comes from Maitre’D application.
For API users, click 
here.
a)If at least one file was transmitted, a drop-down list is available for the File selection field. b)Select “Local file” or the name of a file that was previously transmitted c)Click on Refresh. |
3If you manage more than one company, select the desired company or “All companies” from the Company field’s drop-down list.
▪All companies” heading includes all the companies of the business to which the user has access.
▪If the import file format is Maitre’D, you have to select a company.
▪The import options that you have configured beforehand are displayed. It is possible to modify these options by clicking on the Modify import configuration hyperlink.
4Verify the date recorded under Last import.
| If you have made multiple import attempts, click here. |
a)When an import has been carried out successfully and you wish to import another file for the same company, the system will display a message to inform you that an import was completed today and to ask you if really you wish to perform the import once again. b)If you accept the notice, the payroll entry will be added to the Enter pay screen (and Separate payments screen if you use the regular import interface).
|
5Click on Import to complete the procedure.
6If there are unapproved absence requests for the pay period to import, submitted by employees who do not have a time sheet, click here.
The Unapproved absence requests screen displays and shows the employees concerned by at least one unapproved request for the pay period you wish to process. If your business has the Time management solution, the Unapproved absence requests screen only concerns employees who do not have a time sheet. ▪Click on Do not import. or ▪Click on Import. |
7If approved absence requests affect the pay period to import and a regular earning was not configured, a message appears. Click here to see the steps to follow.
▪Click on the hyperlink which takes you to the Payroll configuration screen to identify the regular earning that is to be reduced by absence requests. or ▪If your business has the Time management solution, a hyperlink takes you to the Time management parameters screen. It is important to associate the regular earning to the hour types on the Associate hour types with earnings screen (Time > Hour types for time sheets), otherwise you will receive a message telling you to do so when you redo the import. Once you have configured the earning, resume the import. |
If all transactions are validated and imported error-free, the system will provide the following confirmation message: “Processing completed. Your payroll entry were imported successfully.” Your transactions are now available on the Enter pay screen (and Separate payments screen if you use the regular import interface).
If generic errors (voluminous file, no data, erroneous extension,) are identified, click here.
a)Cancel the import by clicking on Cancel import. b)In the Import payroll transactions screen, click on OK. c)The initial import screen will be displayed and you will be able to import a new file.
|
If NON generic errors are identified, click here.
a)You can correct these errors directly in the screen by clicking on Correct (see Correcting payroll transactions) or cancel the import by clicking on Cancel import. b)If you choose to cancel, verify the messages displayed under the Summary heading and correct the errors in your file. Start the import procedure again. |
For more information