Importing YTD adjustments

<< Click to Display Table of Contents >>

Importing YTD adjustments

Access: Year-end > Tools > Import adjustments

This procedure allows you to transfer the year-to-date adjustments (manual cheques), using files from another application, directly to the YTD adjustments function.

The file should only include year-to-date adjustments. The following formats are accepted: Excel, Excel in columns, Fixed columns or Delimited columns.

Important

▪We created templates in the Excel file format, available in the documentation (Docum > Documentation)

▪The Employer field of the import file must contain a value ONLY if an employer's share is associated with a deduction.

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 semicolons “;”;

▪“Excel” if the data comes from Microsoft® Excel application;

▪“Excel (columns)” if the data in your Microsoft® Excel file is organized in columns.

For API users, click hmtoggle_plus1 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
If “Local file” is selected, the File location field and the Browse button are displayed.

c)Click on Refresh.

3If you manage more than one company, select the Company or “All companies”.

▪All companies” heading includes all the companies of the business to which the user has access.

▪The import options that you have configured beforehand are displayed. It is possible to modify these options by clicking on Modify import configuration.

4Verify the date recorded under Last import.

If you have made multiple import attempts, click hmtoggle_plus1here.

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 YTD adjustments function.

Important

If you import more than one file for the same company in the same period, payroll entry will be added each time to the YTD adjustments function. An import does not replace transactions previously imported or entered. To reimport transactions, first delete the imported adjustments and repeat the import procedure.

5Click on Import to complete the procedure.

If all transactions are validated and imported without errors, the following confirmation message is displayed: “Processing completed. Your payroll data were imported successfully.” Your transactions are now available in the YTD adjustments function.

If generic errors (voluminous file, no data, erroneous extension, etc.) are identified, click hmtoggle_plus1 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.

Things to remember

When a file with the same name and size is imported more than once in the course of a day, a warning appears at the top of the screen and a Modify hyperlink is displayed allowing you to select another file.

If NON-generic errors are identified, click hmtoggle_plus1 here.

a)You can correct these errors directly on the screen by clicking on Correct (see Correcting YTD adjustments) 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.

Tips and tricks

Use the search filters to filter the import errors. Select a Message type, and then click on Refresh.

For more information

Employee YTD adjustments - Additional information

 

Go back to the table of content