Out accounting department was able to set up bank statement import automation extremely easily using Quickbooks and believes that it should be as easy in Netsuite.
As far as I can see, there are 2 available options to do this in Netsuite:
Bank Feeds SuiteApp
and
Auto Bank Statement Import
Issue 1: Bank Fees Suite App
I tried to set up the Bank Feeds SuiteApp, but the Citizen's Business Bank account we use is a sub menu on the CBB top page, and apparently the link we'd need to log into isn't it one direct url they offer.
Question 1: Is there any way to set up a different url (the correct one?) or are we just out of luck with this app?
Issue 2: Auto Bank Statement Import
Question 2: Manual Import; Do we need to upload a CSV file?
If so, do we first need to reformat the bank statement to that specific csv upload format?
Question 3: SFTP Upload
To set this up, I need a lot of information directly from the bank, correct?
I'm having trouble getting this info from my regional bank, is there a centralized file with this information, or is it account specific?
Question 4:
Is there really no simpler, easier way to solve this issues?
We just want to import the statements / transaction info from our bank accounts, something it's been extremely easy to do in QuickBooks, and this just seems unnecessarily difficult.
Is NetSuite just not keeping up with the times very well?