We are setting up Automatic Bank Statement Import ...
# accounting
a
We are setting up Automatic Bank Statement Import for Bank of America BAI2 files and Wells Fargo BAI2 files Problems: • We have a few concurrent issues and we're trying to determine whether they're related, as well as how to solve them: ◦ Automatic Bank Statement Import every day or every other day has both a successful import and an import that fails due to the file allegedly already having been uploaded. ◦ It imports twice a day for each bank despite us having only 1 Format Profile for each bank, set to run only 1 time per day. ◦ Three of our Accounts in NetSuite are not showing any activity on them, but it should be there according to the manual data entry and tracking process we've been using up to now. Questions: • Could the importer miss or ignore an entry in a BAI2 file or the entire file itself if the filename is the same as the day before (due to that already-uploaded-this-file error)? • Without having to talk to the banks themselves, does anyone know whether Bank of America or Wells Fargo would ever upload or update a file by the same name, with different information in it? • Does the Automatic Bank Statement Import feature ignore or filter out ZBA disbursement accounts because they either always balance to zero or always have what might look like duplicate transactions since they're transferring the same amounts from one account to another (this seems unlikely since what's the point of accounting if we only look at net resulting amounts)?