Importing employee banks

<< Click to Display Table of Contents >>

Importing employee banks

Access: Employee file > Tools > Import employee banks

This function allows you to import an Excel file to update employee banks. It involves calculating and entering positive or negative values to reach the desired balance.

Warning

Imported data does not replace the bank balance*.

First, check the balance indicated in the payroll application and then add a positive or negative amount in the Excel document to attain the desired balance.  

* Rate column: This field is only applicable for banks that use a calculated rate. For instance, if the import file includes a valid rate (between 0 and 9999.9999), it will replace the rate indicated in
  the bank parameter. For other banks (rate in the file or average rate), importing a rate has no impact.  

How can you verify the Used rate in banks? hmtoggle_plus1Click here

a)Access the Configuration menu Configuration.

b)Under the PAY section, click on Banks and leaves.  

c)Select the desired Banks.

d)View the Used rate field displayed under the Payment section.

 

NET red-pointer

 

To help you prepare your import file:

✓Refer to the import file parameters available in the Help section by clicking here or on the Documentation page of the payroll application (Docum > Documentation)

✓Use the Bank Import Template (Excel file) available on the Documentation page of the payroll application (Docum > Documentation).

 

1Under New import, click on Choose file to select the file to import.

2If you have more than one company, select the desired Company.

▪The list includes all companies to which the user has access.

3Click on Import. Our system will analyze your file. Click on the link that corresponds to your situation:

A message will confirm that the import was completed successfully

a.Click on the Imported data report link to review your data and ensure compliance.  

b.If the report data matches the expected results, click Save to complete the process and update the employee banks. Otherwise, click Cancel import to make the necessary corrections and restart the import.

Errors identified (missing required value, invalid character, no data, etc.)

a.Errors will appear in the Messages table at the bottom of the screen.

Idée_transp

Click on theExcelicon to download messages in an Excel file.

b.Once the errors are corrected, click Cancel import.

c.In the Do you really want to cancel import? window, click on OK.

d.The initial import screen will be displayed, allowing you to reimport the corrected file.

e.If the data is correct and meets expectations, click Save to complete the process and update employee banks.

One or many warnings will be displayed

a.Since warnings do not block the bank import process, you can click the Imported data report link in the message to verify your data and ensure compliance.  

b.Review the warning messages displayed in the Messages table at the bottom of the screen.
If no corrections are required, check the box in the second message, then click Save to complete the process and update the employee banks. Otherwise, click Cancel import to make the necessary corrections and restart the import.

Possible warning messages:

✓The accrual balance exceeds the allowed value. Prerequisite: The Maximum on balance parameter is set to Yes in the bank. Message: The accrual balance exceeds the allowed value of {0}. The excess payment will be processed in the next regular payroll.

✓Modification of the eligible amount. The amount entered in the Eligible amount field has no impact on the amount accumulated in the bank. Message: Modifying this field does not
affect the amount accumulated in the bank.

avertissemnt jaune If the file contains more than 30 errors, the application will stop the analysis, and the import will be interrupted. Please review the file data before restarting the process.  

4The data in the Last import section is updated with each import, regardless of status: Completed, Error, Not completed or Cancelled.