This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hello, is it possible to import a bank reconciliation file that has multiple accounts in the file?

I'm sure there are other methods to do that.

thanks.  we have a csv file with the transactions.  what do I need to do to get the file configured?  we download the file from the bank

that unfortunately isn't how a BAI2 file works - you have to get it from the bank as a BAI2 file

is it possible to setup a transaction parser from a csv file?

I wouldn't expect so, but I've never configured it

Kevin, I did get a bai2 file.  Do I need to get the field setup of the file from the bank?  Also, do I need the bai2 parser suiteapp?  Thank you

No. All you should have to do is map on the account record the appropriate fields.

for account/routing number effectively (some banks use different numbers, but most don't)

thanks.  do I need to map anything on the code type mapping page?

not unless you have non standard BAI2 types

and if that's the case - you have to do extra stuff

do we have to ask the bank if its a non standard bai2?  sorry for all the questions but I have not set this up before