web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Convert csv file into Bank Format BAI2

(0) ShareShare
ReportReport
Posted on by 2

Hi Folks,

We have a requirement to activate advance bank rec functionality for a bank account that does not offer statements in one of the accepted formats (Australia its BAI2). Client has asked how easy it would be to convert a csv file from bank into the BAI2 Format. Does anyone have any suggestions for this or alternative suggestions? 

Thanks

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Simon,

    You don't necessarily need a BAI2 statement to import bank statements into D365FO.

    With electronic reporting you can also use CSV files and import them.

    Of course this requires a new setup of an electronic reporting configuration but is doable.

    A friend of mine demonstrated this some time ago at an online webinar of the AXUG.

    Probably have a look at the recording and/or talk to one of your developers about this electronic reporting alternative.

    Best regards,

    Ludwig

  • Suggested answer
    simonsmith101 Profile Picture
    2 on at

    Thanks Ludwig.

    Could you send me a link to the recording possibly

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Simon,

    Here is the link:

    www.axug.com/.../advanced-bank-reconciliation-and-se

    You need to be registered /logged into the axug website to access the files.

    Best regards,

    Ludwig

  • Suggested answer
    simonsmith101 Profile Picture
    2 on at

    Thanks Ludwig. I will take a look. Much appreciated

  • simonsmith101 Profile Picture
    2 on at

    Hi Ludwig

    Its saying I am not authorised. I then applied for full membership and the address email bounced .

    Simon

  • Benjamin Michael Profile Picture
    5 on at

    Hi Simon,

    I hope you're doing well.

    I'm checking in to see if you've been able to get a solution to this requirement.

  • simonsmith101 Profile Picture
    2 on at

    Hi Benjamin. We managed to create an ER report to convert it. Cheers 

    [quote user="simonsmith101"]

    Hi Folks,

    We have a requirement to activate advance bank rec functionality for a bank account that does not offer statements in one of the accepted formats (Australia its BAI2). Client has asked how easy it would be to convert a csv file from bank into the BAI2 Format. Does anyone have any suggestions for this or alternative suggestions? 

    Thanks

    [/quote]

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans