Skip to main content
All CollectionsGetting Started with Trovata
Netsuite Transactions Syncing
Netsuite Transactions Syncing

End to end guide for setting up Trovata syncing of transactions into your Netsuite instance for use in matching and reconciliation

A
Written by Aqeel Gunja
Updated over 7 months ago

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

  1. Login to the Trovata Developer Portal

  2. Click on the ✚ icon on the right hand side

  3. Register a new application

    1. Enter the Application Name

    2. Enter the Application Description

    3. Select Prod as the Environment

    4. Select the Resources checkbox for the following:

      1. Accounts = GET /accounts

      2. Transactions = GET/ transactions

  4. Click Save

  5. 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

  1. Enable CUSTOM TRANSACTIONS feature

    1. Navigate to Setup β†’ Company β†’ Enable Features β†’ SuiteCloud β†’ SuiteGL and click the checkbox

  2. Install the Trovata Financial Institution Plugin from the NetSuite Marketplace

    1. 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:

  1. Trovata App Id

  2. Trovata Secret

  3. 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.

Did this answer your question?