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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / No bank statements wer...
Finance | Project Operations, Human Resources, ...
Answered

No bank statements were imported successfully BAI2

(0) ShareShare
ReportReport
Posted on by Kate Li 30

Hi Everone,

We are using D365 FO and we were asked to configure advanced bank reconciliation function. I have completed steps listed in Set up the advanced bank reconciliation import process - Finance | Dynamics 365 | Microsoft Docs. Map is completed. Transformation is completed. We use BAI2 as the format and enabled advanced bank reconciliation under bank account.

Now when I test this function, I upload my bank statement file (in CSV format) and nothing show up.

pastedimage1629785454601v2.png

And I go check data management - execution log, it's showing "The specified file is not in the same format as the source data format selected.
'1' 'Bank statements_BankStatementDocumentEntity' record(s) inserted in staging"
:

pastedimage1629785495512v3.png

pastedimage1629785517359v4.png

I'm new to Microsoft AX and couldn't figure out what is the cause. Is it because my bank statement file is in CSV? Do I need to make any adjustments to my bank statement file before uploading into AX? many thanks in advance for any contribution on this.

I have the same question (0)
  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 15,039 Moderator on at
    RE: No bank statements were imported successfully BAI2

    can you share the Bank statement setup and file which you importing ? I think you need to import txt file with BAI2 structure, this is not same as csv

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 299,407 Super User 2025 Season 2 on at
    RE: No bank statements were imported successfully BAI2

    Hi Kate,

    Please check if the transformation files (xslt) were the correct ones, setup as per the documentation and if your CSV is a valid BAI2 file. If you continue having this error, you can reach out to your partner or Microsoft Support for more in depth assistance.

  • Suggested answer
    Prem Kumar Bachu Profile Picture
    Prem Kumar Bachu 3,418 on at
    RE: No bank statements were imported successfully BAI2

    Hi Kate,

    1) Try with importing file in BAI2(text) format

    2) Ensure you are importing to correct bank account. Match D365 bank account number with account number in bank statement file.

    Thanks,

    Prem

  • Kate Li Profile Picture
    Kate Li 30 on at
    RE: No bank statements were imported successfully BAI2

    Hi Saurabh,

    I used sample setup file downloaded from visual studios as below link guided. I think I need to change my bank statement CSV file as the error message is saying format is not correct.

    docs.microsoft.com/.../set-up-advanced-bank-reconciliation-import-process

  • Kate Li Profile Picture
    Kate Li 30 on at
    RE: No bank statements were imported successfully BAI2

    Hi Prem,

    If bank cannot provide statement in text format, Do I need to manually maintain the file everytime I receive CSV statement from bank and change it to text format then upload file?

  • Kate Li Profile Picture
    Kate Li 30 on at
    RE: No bank statements were imported successfully BAI2

    Hi Andre,

    Can you further discuss how to confirm if my CSV is a valid BAI2 file? I'm so confused here. I set up BAI2 file type to txt as the instruction guided, and my file is in CVS format. Do I need to manually transform the whole file to txt format in BAI2 layout?

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 299,407 Super User 2025 Season 2 on at
    RE: No bank statements were imported successfully BAI2

    Hi Kate,

    You can check if your file is correct with help of the BAI2 file description and/or file examples. You can find more details here: quickstream.westpac.com.au/.../

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,933

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 537 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans