Australian Bankers Association Australian Direct Entry EFT File Format
Hello to the Australian Microsoft Dynamics GP community.
Today I wanted to post online the results of a support case we had where we were trying to make the built in EFT (Electronic Funds Transfer) functionality of Microsoft Dynamics GP work with the Australian Bankers Association (ABA) Australian Direct Entry EFT file format.
The Australian Direct Entry (aka AUSDE or DE) file format is used to electronically provide details of payments to Australian banks. It is a single format used by all Australian banks.
During the course of the case I contacted a couple of the major Australian banks and obtained their specifications for the Direct Entry file format. If you need the specific details of the format, please contact your bank and request the specifications for the ABA Direct Entry file format that the bank uses for EFT payments.
Once we had the we format setup in the EFT File Format Maintenance window (Financial >> Cards >> EFT File Format) and had it tested, the partner on the case agreed that we should post the results on the blog for the benefit of the Australian Microsoft Dynamics GP community.
EFT File Format Maintenance
Example Output
0 01ABA COMPANY ABCD PTY LTD 301500EFT-PAYMENT 051206
1062-000 10001000 530000010050CLIENT COMPANY XYZ INVOICE 123456 063-000100000000COMPANY ABCD P/L00000000
1063-000 10000000 130000010050COMMPANY ABCD PTY LTD PAYMENT 063-000100000000COMPANY ABCD P/L00000000
7999-999 000000000000000100500000010050 000002
The ABA Direct Entry file format export is attached to the bottom of this article. It is provided "as is" and should undergo User Acceptance Testing for each Customer site.
Hope you find this useful
David