I tried to upload a .bai file to the Match Bank Data page, but when I click the blue "Import" button, it prevents me with a popup saying "unknown format". I made sure the line endings were CRLF, the file was UTF-8, and that it starts with "01," and has lines starting with "16," in it. It also has a "99," line at the end and several "49," lines with a "98," line right after them, the last pair of them occurring just before the final line that starts "99," I think the company I'm working at has imported these before on a regular basis, just not into the Match Bank Data page. I'm new to bank statement files, but I don't see anything wrong with the file so far. What have you all done to troubleshoot this issue?

Hey, did you double check the actual BAI2 structure rules? In my opinion, even if the file looks right, small things like field count, comma placement, amount format, or control totals can cause that ‘unknown format’ error.

AI said to check those things too, but they look okay to me. I haven't hand-calculated the control totals yet, however. Is the Match Bank Data file upload pickier than the old Reconciliation page? I haven't used either one up to now, and what I'm doing is I'm learning how to use them so I can make a recommendation to my manager as to whether this will get the job done for what they're trying to accomplish. Kind of hard to try it out when it won't import the bank statements, though.

"Is the Match Bank Data file upload pickier than the old Reconciliation page? " Of course. NetSuite usually expects bai standard, not just “something that looks like bai”.

I got it to work by changing the file's bai or bai2 extension to txt

“each line has 81 characters… padded with spaces” you mean that fixed-length format, not standard bai. Strict bai request comma separated format.

It's comma-separated. But there are spaces between the last visible character on each line and the CRLF, to make the lines all the same width.

changed file to txt? in my thought, the file content is ok, but NetSuite was rejecting it based on file type / parsing behavior.. in Match Bank Data, NetSuite - treats .bai as strict BAI2 format.. but upload txt, parser becomes less strict, just reads lines instead of validating hard.