The Bank Feeds SuiteApp automates the transfer of your bank data from your financial institution accounts into NetSuite. The SuiteApp uses the Financial Institution Connectivity Plug-In and an authorized account information service provider to securely access online financial institution data.
Setup Tasks
1. Install the SuiteApp via Marketplace.
- Navigate to SuiteApps
- Search for Bank Feeds
- Click Install
2. Configure the Format Profile to register and link bank and credit card accounts. Once the installation is completed, system automatically create a New Financial Institutions
- To Configure the Format Profile, please follow the steps below:
- Navigate to Setup > Accounting > Financial Institutions > List
- Click View next to the Financial Institution you would like to set up
- Navigate to Format Profile: Configuration tab
- click Edit next to the Format Profile you would like to use
- Navigate to Connectivity Configuration tab and click on Connect New Institution
- You will need to use the same credentials as used to login to actual bank account.
- It is important to accept the consent to read-only access to data otherwise the daily bank updates from NetSuite will not be received
Once the Connection is set upped, review available Bank Accounts and link them to NetSuite GL Accounts on the Account Linking tab
- Navigate to Account Linking tab on your Format Profile
- Link the Bank Account with the GL Account
- Click Save > it will trigger the first import
The first import of data contains the past 60 days of bank and credit card data.
Detailed explanation of fields used on the Format Profile:
- Format Profile > Connectivity Configuration tab > Connections Subtab:
- Accounts = an overview how many accounts were connected using the specific credentials
- Connection Expiry Date = if there is an expiring date for connection
- Update MFA = Multi-Factor Authentication is required – Tick – is still valid
- Rebuild Connection = for changing the credentials
- Delete Connection = delete the connection which was created
- Format Profile > Connectivity Configuration tab > Accounts Subtab:
- This section controls what accounts are available for mapping of GL accounts (if user excludes any account here, it will not be available in Account Linking tab)
Note: Automated import occurs every day during 5am – 8am PST. Currently it is not possible to customize it.
I hope, this information will be helpful for you. Do you have some other related tips to this topic? Please, share it with us! :-)