EFT file in Dynamics 365 Business Central

One of the most asked question is how to create ABA file in Dynamics 365 Business Central and what is ABA file.

First, the Australian Bankers Association (ABA) or Cemtext file format is a format used by banks to allow for batch/import payment transactions.

What does an ABA file look like?

Each line in an ABA file is a "record". An ABA file has three main records, the "descriptive" record, a "detail" record for each transaction and the "file total record" at the end. An ABA record is exactly 120 characters long.

 

Example EFT Transfer File generated from Dynamics BC to be imported into Bank.

 



1.         EFT Bank Code=WWB. This is the EFT Bank Code for World Wide Bank (CRONUS data)
2.         EFT Security Name = TEST Company 
3.         EFT Security No. = 6567890. This is the EFT Security No. for World Wide Bank.
4.         EFT Payments File generated from Business Central – File Name = TEST
5.         EFT Payments File generated from Business Central – Payment Date = 071221

 

To generate EFT file, it is important to populate mandatory fields from Transfer Fast Tab on the Bank Account Card.


 

1. SWIFT Code – Required only if the company is making payments in currencies other than AUD or receiving funds in currencies other than AUD

2.  IBAN – this is only required if the company is making payments in currencies other than AUD or receiving funds in currencies other than AUD

3. EFT Bank Code – this code is specific to each Bank.

4. EFT BSB No. - This is the BSB No. and is the same as the BSB included in General Fast Tab in Bank Branch No. Field

5. EFT Security No. - this is a number specific to each Bank (ANZ, NAB etc.)

6. EFT Security Name – this can be a free text field and usually has reference to the company or to the Bank Account No

7.  Bank Statement Import Format – For Australian companies, it should be set up in csv format as the bank statement needs to be imported into Business Central. As of now, Business Central does not support direct import of the bank file from Australian banks.

#eftbusinesscentral #abafile #abafilebusinesscentral #cashmanagement #bank 

Comments

  1. Julia RikhterDecember 7, 2021 at 3:05 PM

    Thank you Alex! Such a detailed description

    ReplyDelete
  2. ChankyDecember 7, 2021 at 8:19 PM

    Good stuff.

    ReplyDelete
  3. UnknownDecember 20, 2021 at 4:14 PM

    I have tested in Business Central and the file comes out as a TXT file.
    Do you just change the .TXT extension to .ABA to upload the file to Australian banking platforms?
    Is there any way to test the file before a client goes live?

    ReplyDelete
    Replies
    1. DynamicstipsJanuary 5, 2022 at 1:14 PM

      Yes, the file is created in .txt. No need to convert to .ABA. Australian bank accepts BC EFT file as it is if all EFT bank details are populated correctly.

      Unfortunately, EFT file can be tested only by uploading directly to AU bank platform. Client does not need to proceed with the payment through. For the testing purposes, client needs to upload BC EFT file and if the file is accepted by the bank, then it is all set.

      Hope it helps!

      Please let me know if there are any other questions.

      Delete

Post a Comment

Popular posts from this blog

Ace the MB-800 Exam: Tips and Strategies for Success

 The Microsoft Dynamics Business Central MB-800 exam is a certification exam that tests your knowledge and skills in Business Central. Achieving certification in Business Central can help you advance your career and demonstrate your expertise in this software. If you are preparing to take the MB-800 exam, here are some tips and strategies that can help you succeed: Familiarize yourself with the exam format and content:   The MB-800 exam consists of 40-60 multiple-choice and case study questions and covers a range of topics. It is important to understand the exam format and content in order to prepare effectively. Here is the link to download MB-800 Study Guide to review the exam objectives.  Exam MB-800: Microsoft Dynamics 365 Business Central Functional Consultant - Certifications | Microsoft Learn .  Use study materials and resources: There are a variety of study materials and resources available to help you prepare for the MB-800 exam. These can include books, on...
Read more

Empowering Your Business with Custom Report Layouts in Business Central

Image
  In today's fast-paced business world, having well-designed and professional reports is crucial for success. That's where the Standard Reports in Business Central come into play. But what if you need to make modifications to these reports to align them with your company's unique needs and requirements? T he good news is that you can tailor the layout to meet your specific needs, without relying on technical expertise or the need for extensive programming or coding knowledge. Let's take a quick tour of how to utilize this fantastic feature in Business Central: Step 1: To modify a report layout, the first step involves exporting the existing layout as a file to a location on your computer or network. Step 2: Export the existing report layout to your computer or network, giving you the freedom to explore and modify it at your convenience. Step 3: Open the exported layout in MS word, click on the “XML Mapping Pane” under the Developer tab to open the XML Mapping.   ...
Read more

How to Reverse Disposal Fixed Asset Ledger Entries in Business Central

Image
 The main point for corrections in Fixed Assets is the usage of function “Cancel Entries” (Report 5686) “Cancel Entries” can be started from the FA Ledger Entries. This function copies the fixed asset ledger entries that you want to cancel to a journal.  If the fixed asset(s) are integrated with the general ledger, the program transfers the entries to the FA G/L journal . Otherwise, the program transfers the entries to the FA journal. You can then post the journal or adjust the entries before posting, if necessary. The fixed asset ledger entries are then removed from the FA Ledger Entries window and are posted to the FA Error Ledger Entries window. The steps below should be followed in using the Cancel Entries function to correct or reverse your Fixed Asset ledger entries: 1. Navigate to the FA Ledger entries page 2. Filter the document no. of the Disposal entries you would like to reverse Note: You need to select and Cancel the Depreciation Entries first before the Acquisiti...
Read more