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

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Bank Statement File Se...
Small and medium business | Business Central, N...
Suggested Answer

Bank Statement File Setup "Matches does not exist"

(0) ShareShare
ReportReport
Posted on by anmuriel 90

This is my second attempt to upload this bank statement for the reason I fixed some data. 

Here is my data: 

1st column = DATE 

2nd column = Description 

3rd column = Amount

pastedimage1680465038941v1.png

And in bank statement file setup, here are the steps I follow: 

1. Header lines to skip is zero as there are no headers. 

pastedimage1680465092821v2.png

2. This is the usual format I follow. I've been following this format and I didn't get error before. 

pastedimage1680465144233v3.png

3. Here is the error I am getting 

pastedimage1680465235492v4.png

Usually in the amount column, I place 3 because it is in 3rd column in original file but now I am getting this kind of error. Even in Description column when I place 2, it also gets the same error. 

pastedimage1680465382745v5.png

Please help how to fix this issue. 

Thank you. 

I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 97,218 Super User 2025 Season 2 on at

    Hi, Looks like an issue with the Excel file. There are many characters that cannot be fetched.

    I think you can copy the Excel data to a new Excel file and try again.
    Here's a simple test I did when the feature was released, hope this helps
    https://yzhums.com/11072/

    Thanks.

    ZHU

  • Suggested answer
    Giambattista Malvasi Profile Picture
    Giambattista Malvasi 195 on at

    Hi, you have more invalid characters for Excel. Clear your file and retry

  • anmuriel Profile Picture
    anmuriel 90 on at

    Hi I appreciate sharing your article. I followed it and remove some characters but still I am getting the same error.

  • Nexusd Profile Picture
    Nexusd 15 on at

    Hi,

    I am also having this erroe now. Did you figure out what was wrong? Any help would be greatly appreciated.

    Thank you,

    Henna

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

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

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

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,957 Moderator

#2
Dhiren Nagar Profile Picture

Dhiren Nagar 1,245 Moderator

#3
YUN ZHU Profile Picture

YUN ZHU 1,045 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans