-
Unexpected error on bank import (long-time users)
We've been importing bank transactions for years with the NetSuite default CSV parser, but today something has changed and every one is being rejected for an unprovided reason. The formatof the import files hasn't changed and I can't see anything that may trip it up. I tried a previously accepted file again and that also…
-
Can't wrap my head around importing bank statements and corporate credit card transactions.
I've been trying for two days to get bank statements and corporate credit card statements/transactions imported. There seems to be several ways to do it. While having a bank feed would be ideal, we are waiting on an update from our bank to help us get connected. But in the meantime I wanted to train our accounting team to…
-
How to expose the bank statement balance from match bank data
Hello I would like to create a bank reconciliation report in PowerBI. I cannot see how i can get the bank statement balance from the Match Bank Data screen. I cant even see how i can get this in a saved search. Is it possible to expose this field, ie what table is it held on and how can i access this? Copilot said to…
-
New To NetSuite | Understanding Banking Import History portlet
Reconciliation is a critical aspect of financial management in any business. With the goal of reducing paperwork, NetSuite offers a streamlined process to match transactions through automatic or manual import, ensuring bank transactions align with their corresponding book entries. NetSuite provides users with a powerful…
-
DELETED RECONCILED BANK STATEMENT
Hi! I've been worrying about this for over a week. I deleted a reconciled bank statement. I am aware that the transactions are still matched and submitted and should be in Reconcile Account Statement, but I don't see those matched and submitted in the Reconcile Account Statement. I did this last month and did not have any…
-
Download the Bank Statement Import Details in Excel Format
Hi, Is there a way to download the bank statement import details in Excel format? I can see the import details page but I don't see a button to download it. There are hundreds of lines there and it would be great to have the option to download it. I've asked Netsuite Support but they did not give a work around on how to do…
-
Unable to import bank statement due to an error
Hello All, I am facing an issue while importing the bank statement. Error: "The file could not be imported, because there is an incorrect number of CSV columns in the header: 1. For specifications, check with your file provider." I Below is the screenshot of file which I have tried to upload. I have already deleted all he…
-
How to Import bank statements using CSV import assistant?
Do NetSuite support bank statement import using CSV import assistant? For example, I want to upload some bank statements to our records via .csv file. When looking at the import assistant, there are multiple import types and multiple record types for each of those. I don't want to have to create a new custom record if the…
-
Bank Feeds and Bank Statement Apps - Canada
We currently import our bank statement using a .csv file, we manually enter bank transactions. We are considering using the newly improved Bank Feed App to import transactions. Do we need to consider using the Bank Statement App as well? or do we continue with our statement import via .csv? (found BAI2 to be an expensive…
-
AE: Bank Statement
Hi, Is it possible to see on a bank statement to which bank account was paid? regards, Mathias