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

Bank Statement File Setup "Matches does not exist"

(0) Share

Report

Posted on by anmuriel

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

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

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

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

3. Here is the error I am getting

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.

Please help how to fix this issue.

Thank you.

All responses (4)

Answers (0)

Nexusd 15 on at

Like (0)

Report

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 90 on at

Like (0)

Report

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

Giambattista Malvasi 195 on at

Like (0)

Report

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 74,115 Super User 2024 Season 2 on at

Like (0)

Report

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