Discussions
SuiteWorld is the largest annual gathering of the NetSuite community! It will be held in Las Vegas on October 6-9, 2025. Our customers and partners look forward to SuiteWorld every year as a place to hear the latest from NetSuite, get hands-on learning, and connect with each other. Register now!
How to upload a bank statement in CSV or excel format and delete/match previous uploads?
Hi,
We currently have several transactions from prior years that have not been reconciled in the bank reconciliation, nor will they ever be reconciled and so when attempting to clean this up, a solution would be to upload an amount on the bank statement side with the specific amount, since it is non posting item in the Financial Statements.
Currently we use quicken format to upload bank statement data (and reconcile using Match Bank Data ), it looks like this is the default setting in our Netsuite. Is there a way to make CSV/Excel format bank statement uploads possible, so that we can edit the amount of the bank statement upload in order to clean up the historic non-reconciling items we have inherited?