Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Bank Statement File Setup "Matches does not exist"

Posted on by 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. 

  • Nexusd Profile Picture
    Nexusd 15 on at
    RE: Bank Statement File Setup "Matches does not exist"

    Hi,

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

    Thank you,

    Henna

  • anmuriel Profile Picture
    anmuriel 90 on at
    RE: Bank Statement File Setup "Matches does not exist"

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

  • Suggested answer
    RE: Bank Statement File Setup "Matches does not exist"

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

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 72,941 Super User 2024 Season 2 on at
    RE: Bank Statement File Setup "Matches does not exist"

    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

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans