Hello. Wondering if someone can help. Using Bank Feeds and there are some transactions that were improperly linked to the wrong GL Account by a previous consultant. We have since fixed the improper linkage and selected the right GL Account however there are transactions on the incorrect GL Account and the new correct GL Account making the Matching Bank Feed not possible. How do we fix this? I was thinking of removing the bank connection all together and rebuilding it. But upon doing so, would it Delete all previous transactions imported and re-import it all of the transactions into the correct GL Account? Also I'm assuming it would impact all of the other accounts that is connected to this financial institution. I was also thinking of changing the GL Account of the NS Transactions to point to the incorrect GL Account so that it at least makes it possible to match the bank feeds, however the account reconciliation will not be able to be done using the closing statement balance now and moving forward.

This is a common shortcoming of the Bank Feeds - essentially Yodlee (underlying technology) is a screen scraper, data in screen scaping processes cannot be 100% correct. Best option is to use Automated Bank Statement Import (ABSI) suiteapp along with bank statement parser. Connect to your bank using SFTP and use BAI2 or any other bank statement format supported by Netsuite. Where you can define the GL account mapping account data from the statement file.