| Excerpt |
|---|
This article describes how to produce a file for Western Union payment system in Adonis. |
| Page Properties | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Configuration
As with any payment files created from Adonis, Western Union requires the setup of banking info for payroll transactions.
The Balance Action used for this interface is ISO 20022/Swift. Please use article How to generate ISO 20022 format bank file to configure the system (General Codes and Organization setup, Person/Employee setup). Most settings are the same, though there are specifics for Western Union:
Though the file sent to Western Union does not contain information about the company bank, Adonis still needs it be created in General Codes > Payroll > Banks and then setup in Organization structure under company Payroll > Payment settings in Bank Account for NetPay. If wanted, a dummy bank can be used.
Western Union does not use the setup in Global Options > Payroll > Countries type definition described in the article that we refer to above.
Western Union only works with Payroll Entry Codes that are setup with "Advance Entry Code" option. Meaning, it does not include payments from EC 994 Net Wages and Payment tab does not need to be setup with ISO 20022/Swift balance action and banking details on a person as described in the article. All transactions must be added to payroll entries with "advance" entry codes and banking details in Payroll Additional Info window (described later in the mentioned article).
When configuring a person transactions for back processing, use Text field in Payroll Additional Info to define EFT or ACH transfer. EFT - Electronic file transfer, ACH - Automatic Clearing House system transfer used by many USA banks.
This field is further used in the Western Union files in "PayBy" column.
Produce file to Western Union
Go to Tools > Export > Western Union
In the next window select Entry Codes that should be selected by the system for payment distribution. This window only shows Entry Codes with option "Advance Entry Code".
Western Union window will give a preview of all the data that will be included in the export file. You can make checks, select the records that you want to be exported, the export directory and export the file.
After the export file is created you will receive confirmation message as below. The file is exported in .csv format.
When you click "OK" you will be asked if you want to lock the exported entries. You can learn more about this functionality in the following article Lock/Unlock Payment Entries and Payroll Period
Reports for bank transactions sent to Western Union
If you want to produce a report on all transactions with banking details that will be included in Western Union export file, then before the export you can run Payroll > Reports > Current > Advance List report > Preview and save it to pdf or excel, or print it.
The report is also available in historical mode to check on historical bank transfers in closed payroll periods.
Specification of WU files
Western Union excepts the .csv format files. Adonis creates the files of the same format.
Fields specification:
Adonis spec | Crew Personal Details Last, First name separated by comma | Receiver name from Payroll Additional Info | Transaction country | Transaction currency code | Transaction amount | Fetch Text from Payroll Additional lnfo | Receiver Bank name | Receiver bank account | Receiver bank SWIFT | Receiver bank Routing code | Receiver bank country | Receiver bank address | Receiver bank address | Receiver bank address | Receiver bank address | Receiver address | Receiver address | Receiver address | Receiver address | Blank | Blank | Receiver Bank Identification | Intermediate bank Bank Identification code | Intermediate bank name | Intermediate bank SWIFT | Intermediate bank | Intermediate bank | Intermediate bank | Intermediate bank | Intermediate bank | Intermediate bank | Intermediate bank |
File column headers | Name | AcctName | Country | Currency | Amount | PayBy | BankName | BankAccount | BankSWIFT_Address | BankRoutingCode | BeneBankCountry | BankAddressLine1 | BankAddressLine2 | BankAddressLine3 | BankPostalCode | BeneAddressLine1 | BeneAddressLine2 | BeneAddressLine3 | PostalCode | RefLine1 | RefLine2 | BankCode | IBankCode | IBankDescription | IBankSWIFT_Address | IBankRoutingCode | IBankAccount | BeneIBankCountry | IBankAddressLine1 | IBankAddressLine2 | IBankAddressLine3 | IBankPostalCode |
Example of file.
| View file | ||
|---|---|---|
|