Overview
If you'd like to learn more about connecting your Trovata transactions to your Netsuite instance, you've come to the right place!
Once implemented, your new transactions will be automatically pulled into Netsuite at the end of each day.
Having your previous day transactions seamlessly sent to Netsuite will assist users when trying to match and reconcile transactions with GL entries.
Configuring Trovata
There are a few requirements that must be done within Trovata prior to enabling and configuring Netsuite.
Confirm that your company’s bank accounts are onboarded onto Trovata
Balance and transaction activity is flowing into Trovata
Trovata Developer Portal access has been provided to an admin user
If you don’t have access the Developer Portal, please send us a message using the chat feature in the bottom right corner of your instance
Registering a new (Trovata) application for Netsuite within the Trovata Developer Portal to retrieve the Trovata App Id, Trovata Secret, and Trovata Company Id
Steps for registering a new Netsuite application in the Trovata Developer Portal
Login to the Trovata Developer Portal
Click on the ✚ icon on the right hand side
Register a new application
Enter the Application Name
Enter the Application Description
Select Prod as the Environment
Select the Resources checkbox for the following:
Accounts = GET /accounts
Transactions = GET/ transactions
Click Save
The screen will refresh once your application is registered to provide the Application ID (AppId), Secret and Company Id
🗒️ Note: Creating this new application automatically enables all of the accounts available in Trovata. To select specific accounts, you may edit the application and uncheck any accounts you don't want to include.
Configuring NetSuite
Enable CUSTOM TRANSACTIONS feature
Navigate to Setup → Company → Enable Features → SuiteCloud → SuiteGL and click the checkbox
Install the Trovata Financial Institution Plugin from the NetSuite Marketplace
Note: Download of app will fail if SuiteGL - Custom Transactions is not enabled
Add your Trovata App Id, Trovata Secret, and Trovata Company Id in Netsuite
Navigate to Setup → Company → API Secrets
Click on Create New and enter the details for each of the items in the table.
☝️ You will create three new secrets:
Trovata App Id
Trovata Secret
Trovata Company Id
These entries must be entered exactly as they are shown in the table below. Before saving, navigate to the Restrictions tab and toggle on:
Allow for all scripts
Allow for all domains
New Secret NAME | Trovata App Id | Trovata Secret | Trovata Company Id |
ID | trovataappid | trovatasecret | trovatacompanyid |
PASSWORD | <your value> | <your value> | <your value> |
ALLOW FOR ALL SCRIPTS | ✔️ | ✔️ | ✔️ |
ALLOW FOR ALL DOMAINS | ✔️ | ✔️ | ✔️ |
Once you have created and saved these three values, they will appear in NetSuite in the table Secrets as custsecrettrovataappid, custsecrettrovatasecret, and custsecrettrovatacompanyid
Linking Trovata Bank Accounts Using the Plugin in Netsuite
1. Navigate to Setup → Accounting → Financial Institution → List
2. Click on Edit next to the Trovata entry
3. Click on Format Profile: Configuration
4. Click on Edit next to Trovata
5. Click on the Account Linking tab, and use the Connectivity Method dropdown to select Trovata Plugin
Your Trovata accounts should now load into the table.
6. You can now link the appropriate Trovata account to one of your NetSuite Linked GL Accounts.
7. Navigate to the Code Type Mapping tab.
8. Enter the rows exactly as they appear in the following screenshot.
9. Click Save.
10. The transactions for the linked accounts will begin to import into NetSuite.
Matching Bank Transactions to NetSuite Transactions
1. To enable your account for matching, navigate to Lists → Accounting → Accounts and locate the account or accounts that you linked in the previous section.
2. Check the box next to USE MATCH BANK DATA AND RECONCILE ACCOUNT STATEMENT PAGES and click Save.
3. Navigate to Transactions → Bank → Match Bank Data
4. From the Account dropdown, select the account you want to look at.
5. This will load the Trovata transactions into the left side of the page at which point you will be able to reconcile these transactions your NetSuite Account Transactions.
