This feature gives IPS users a tool to save time when adding new
bank accounts in the system. Many new bank accounts can be added at
the same time by using the ‘Upload Bank Accounts’ feature.
1. Create a five-column spreadsheet with the following headers (No
spaces between words):
Headers may be lowercase, uppercase or a combination of both,
but it is very important that there are no spaces between
words.
2. Fill in the spreadsheet considering every field
requirements.
3. User may leave the field AccountType blank for every
employee, but the file must have that header anyway.
4. Save spreadsheet as a CSV file and name it as follows: “UPL”
followed by the Company Code and two-digit month, two-digit date
and four-digit year of the Pay Period Date. Suffix: For practical
handling and to avoid undesirable deleting of data, it is necessary
that all files have a suffix, which consists of a hyphen (-)
followed by any three-alphanumeric character combination. For
example: Company Code JAM submitting information for the Pay Period
October 31, 2005 would name their import file
UPLJAM10312005-105.CSV (105 would be the suffix).
5. Go to Management/Data Upload Options/Upload Bank Accounts
6. Click on ‘Browse…’ to search for file.
7. Click on ‘Upload’.
8. Check option ‘Also Update Previous Pay Period’ in case the pay period has already been frozen.
This way the bank accounts will be added in the system even if the pay previous period has been closed, and employee pay will be directly sent into their accounts.
Make sure Payroll Process has not been run at this point,
otherwise the Bank Accounts will not be updated.