Settle Bulk Payments with your Bank

To settle Bulk Payments with your bank electronically, you need to assign that bank a Bank Payment File Type. When creating a Bulk Payment, select the Online Payment Type. This will make the Payment Methods with the Online Payment Type available for selection. See Codes Maintenance for more on setting up Payment Methods.

Once the Bulk Payment is processed, download the Payment File and upload it to your bank. This saves you time and reduces the risk of human error.

Unsupported Bank Payment File Types

We have Bank Payment File Types for a wide range of banking institutions and payment types. If none are suitable, there is the option to use a Generic Bank Payment File Type ("Generic Export – JSON Format" and "Generic Export – XML Format"). The process of using these is the same as with other formats. However, as they are in a generic format (XML / JSON), they need a third-party system to transform them into the required format for your bank.

If you are interested in another Bank Payment File Type being supported, contact support.

Alternative Offline Payment

Create a Bulk Payment with the Offline Payment Type to make the Payment Methods with the Offline Payment Type available for selection. 

Then process the payments manually with your bank using the Bulk Payments Report, found under Report Manager > AP > Payments.

See:

▶️ Bulk Payment Setup (6A.2) - AIQ Academy

▶️ Supplier Bulk Payments (4.12) - AIQ Academy

📗 Bulk Payments 

📗 Create & Manage Bank Accounts

📗 Generic Bank Payment File Type

📗 Report Manager 

The following are the currently supported Bank Payment File Types. If you are unsure about which format is appropriate, contact your bank.

1. AIB (.EMTS)
2. AIB – Multi-Currency (.XML)
3. ANZ Online (.ABA)
4. BACS – UK (e.g. Barclays)
5. Bank of Ireland
6. Bank of Ireland – BACS UK
7. Bank of Ireland – EFT
8. Bank of Ireland – SEPA
9. Bank of New Zealand (.AFI)
10. Bank of Scotland – COL BACS Multiple Payment
11. Barclays.Net
12. Bendigo (.ABA)
13. CBA (.ABA)
14. Central1 – AFT (.DAT)
15. CIBC (.XML)
16. Citibank – Batch Funds Transfer (GDFF)
17. Citibank – Cross Border Funds Transfer (GDFF)
18. Citibank – Domestic Funds Transfer (CDFF)
19. Citibank – SEPA Credit Transfer, Individual Debit (CDFF)
20. Citibank – UK ACH Credit/BACS (CDFF)
21. Citibank – UK Faster Payments, Single Immediate (CDFF)
22. Citibank – US ACH Credit (USFF)
23. Citibank – US ACH Credit with Addenda Information (USFF)
24. Citibank – US Funds Transfer (USFF)
25. Generic Export – JSON Format (.JSON)
26. Generic Export – XML Format (.XML)
27. HSBC – Asia Pacific ACH via iFile
28. HSBC – Asia Pacific Priority Payment via iFile
29. HSBC Net (.TXT)
30. HSBC Net – PP/HVP (.XML)
31. HSBC – SEPA (.XML)
32. Lloyds – BACS
33. Lloyds – BACS v2
34. Lloyds Commercial Banking – BACS
35. MUFG (.CSV)
36. NAB (.ABA)
37. NatWest (.TXT)
38. NatWest – Bankline International Payment (.TXT)
39. NatWest – Standard Domestic Payment (.TXT)
40. On Pay
41. PTX – Bottomline
42. RBS Bankline – Ad Hoc Bulk Payment
43. Santander – BACS (.TXT)
44. Santander – BACS v2
45. SEPA
46. Splitska Banka – SEPA (.XML)
47. St George (.ABA)
48. Ulster Bank – IBAN & BIC
49. Ulster Bank – RBS
50. Westpac (.ABA)

See Create & Manage Bank Accounts for more information on setting up banks.

1. To set up a bank account, go to Bank > Bank List > New Bank, or if your bank  account is already set up, find it in the listing and click A/C Details.
   
2. In Payments File Settings, under Type, select the appropriate format for your bank and payment type.
3. Click Save.