-
Error preventing manual Import of BAI2 file for Match Bank Data
We have no Financial Institutions, Format Profiles, Connectivity Plugins, or Parsers. I'm simply trying to manually upload a BAI2 txt file into the Match Bank Data page using NetSuite's default parsers, but I always get the following error (routing and account numbers redacted as '#' characters): The file could not be…
-
How to extract the bank statement balance
I would like to know which table the statement balance as per the match bank data screen is held, so that i can report on it. Can anyone help please
-
Banking QFX File Import - Unexpected Error
I have been attempting to import QFX files downloaded from our bank so that we can bank data for reconciliation. This has all been done in Sandbox for testing purposes. I created a Financial Institution Parser Plug-In file and attached it to the Format Profile for our bank's Financial Institution record. The Format Profile…
-
NetSuite Admin Tip | Different ways to access Upload File page for Bank Statement Import
Taking control of your financial data is a powerful way to gain greater insight into your financial health and make informed decisions. One of the most important steps in this process is importing bank statements, as it ensures that your records are accurate, up-to-date, and fully aligned with your financial activities. By…
-
New to NetSuite | Resolve Error: “The file upload failed...” During import with a default parser
When performing bank imports using default parsers in NetSuite, such as CSV, OFX, QFX, BAI2, or CAMT.053, users may encounter various errors. One prevalent issue users face is related to file naming conventions, and the below error is likely to occur during the import process. In NetSuite: In NetSuite Next: This error…
-
How can I access the data from this report, via SuiteQL or Rest API?
This report contains the bank data imported for bank reconciliation. We tried reviewing with Account, Transactions, and TransactionLine, but we couldn't find this information on the screen.
-
Export or View Bank Data or transactions
Hi Team, We want to view or export bank statements in NetSuite and connect to the bank to view/export bank transactions. Our main objective is to view the bank transactions and export them if possible. Currently, we are sending an email to the bank account holder, and he is sending the bank transaction statements via…
-
Upload File (Bank) - CSV Import error: incorrect number of CSV columns in the header (Memo column)
I've tried removing commas, dashes, periods, and other characters; also tried keeping the char count under 60, but this error keeps coming back. Does anyone know what I'm doing wrong? Thanks.
-
Nordea Bank Statement downloads for auto bank reconciliation
We use the auto bank rec functionality whereby transactions from out banks auto feed in via the Saltedge solution in Netsuite. This works great for our HSBC accounts. We have some Nordea bank accounts we wish to use in this way. When we authenticate via the Nordea app to set up we just time out. Nordea are saying its an…
-
Upload BAI2 bank statement Auto import
Hi Guys, Is there a way to import BAI2 file from file cabinet using the parser which NetSuite provides? Any option to use Suitescript for import? Issues: 1) SFTP won't work because NetSuite doesn't have static IP. 2) Bank Feed app doesn't work.