Freigeben über

Australian Bankers Association Australian Direct Entry EFT File Format

  • Artikel

David Meego - Click for blog homepageHello 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

ABA_FORMAT.zip

Comments

  • Anonymous
    March 16, 2014
    The comment has been removed

  • Anonymous
    March 16, 2014
    The comment has been removed

  • Anonymous
    March 17, 2014
    Leave it to the Aussies, to be able to agree upon a single format :) Thanks to the Partner for sharing info! Cheers

  • Anonymous
    March 17, 2014
    Hi David I'm trying to setup EFT as per your instructions above. I find that when choosing "Data Field" in the "Maps To" column GP will not accept that. I'm assuming it's trying to reference another field here that I possibly haven't set up correctly. I'd appreciate any hints. Best Regards Tom

  • Anonymous
    March 17, 2014
    Hi Tom Just download and import the file attached to this blog post. David

  • Anonymous
    March 24, 2014
    The comment has been removed

  • Anonymous
    March 26, 2014
    The comment has been removed

  • Anonymous
    March 26, 2014
    Hi Mike I have been discussing the HSBC format issues with development as I have a case that also wants HSBC ACH XML format. I will pass on your comments to the appropriate people. David

  • Anonymous
    April 23, 2014
    Hi David, Thanks for working through this case and uploading this in your blog. I am using this as a repository easy to download for my next site :) Regards Sekar

  • Anonymous
    July 10, 2014
    The comment has been removed

  • Anonymous
    December 08, 2015
    Hi Dave it was great to meet all, at the GPUG seminar today. Just wanted to advise all that I have lately been working on the ACH XML payments for GP in our Chile company and have finally managed to generate an XML file that the bank hasn't yet rejected solely on the format. There are of-course many questions that still need to be answered by the bank, but I reckon its a good start. I'm attempting to add the Format File for your review and openions.

  • Anonymous
    December 08, 2015
    Hi Aniket Thanks for your feedback. I will look at posting the file you sent me directly in a blog post at http://WinthropDC.com/Blog in the near future. Thanks David