https://netsuiteprofessionals.com logo
k

Kristian G

04/26/2022, 11:24 AM
Any takers on this error when uploading a bank reconciliation file? "The file could not be imported, because the account X in the file does not match an account in NetSuite."
z

Zoran R-DATAGRAM

04/26/2022, 2:29 PM
You should enter ALL bank accounts and map them to the NS account (bank type)…. Problem might be one of : • you have undefined bank account in setup, and bank account exists in bank reconciliation file • subsidiary mismatch while doing bank reconciliation
I would check Setup -> Accounting -> Financial institutions -> List If there is one or more FI, you should check Account Linking
k

Kristian G

04/26/2022, 2:35 PM
The file is a CAMT.053 with only one bank account. I have added that bank account to account linking page for that particular parser.
What do you mean with undefined bank account in setup, which setup are you referring to?
And thank you for the response 🙂
z

Zoran R-DATAGRAM

04/26/2022, 2:48 PM
If you have added account on the linking page (you wrote there is the only one) you have done everything required... Next, try to compare format of bank account inside of reconciliation file and value entered on the linking page... I had situation (here in Serbia) that bank account (string value) can different if you compare it on the paper document and in reconcilation file. for example my bank account printed on the statement 123-123455-12 but in the reconciliation file it is RS123000012345512
k

Kristian G

04/27/2022, 6:24 AM
This is correct I believe. I believe the issue is connected with the camt.053 being an extended type, so the parser needs to be updated with reading several more rows which are not setup with the default CAMT.053 parser. I will have to try this out. e