Skip to main content

Developer API — Sage Intacct Outbound: Transactions Sync Setup Guide

Follow these instructions to establish a connection that will push transactions from Citizens Treasury Intelligence to Sage

Written by David Taylor

Note: This integration only supports syncing with the following institutions:

  • Bank of America

  • Wells Fargo

  • JP Morgan

Single-Account Onboarding - Before You Begin You Will Need:

  1. Sage Intacct Admin privileges to connect the desired accounts.

  2. Onboarded accounts in Citizens Treasury Intelligence from their desired banking institution

  3. Beta Code

    1. Bank of America Beta Code: 987463

    2. Wells Fargo Beta Code: 590691

    3. JP Morgan Beta Code: 165364

  4. Company ID that can be found in the Customer DynamoDB table

  5. Access Key that can be created with the below cURL

    ## Post AccessKeys ## Given an access key name (label), and companyId, create a new Access Key ## that is stored to the AccessKeys table curl -X "POST" "https://admin.trovata.io/v2/customers/accesskeys" \      -H 'x-api-key: Kt9U5xuvTKOi7ERfUVeB7K9lbzDyAahymtMIu680' \      -H 'accessKeyName: <customerName>_<Date>' \      -H 'companyId: <customerCompanyId>'

  6. You can verify the above Access Key was created by fetching all access keys available to a given companyId

    ## Get AccessKeys ## Given a companyId, fetch all access keys stored in the AccessKeys table curl "https://admin.trovata.io/v2/customers/accesskeys" \      -H 'x-api-key: Kt9U5xuvTKOi7ERfUVeB7K9lbzDyAahymtMIu680' \      -H 'companyId: <customerCompanyId>'

Sage Intacct Onboarding Flow (Single Account):

1. Enable Sage Cloud Services for your Sage Intacct instance

Navigate to Company > Admin > Subscriptions in the upper left menu.

Find the “Sage Cloud Services” option, and enable Sage Cloud Services. This enables your Sage instance with the process to link accounts from Citizens Treasury Intelligence to Sage.

2. Onboard a single account to Sage

Navigate to Cash Management > All > Accounts > Checking

Click Edit on the account in which you’d like to receive transactions from Citizens Treasury Intelligence

Navigate to the Banking cloud tab of the checking account and click Connect

Search for Trovata in the search bar of the Sage Banking Institutions search screen and click it

Agree to the Terms and Conditions that Sage is presenting

If presented, input the Trovata (Beta) invite code shown above (805433)

Input the companyId (top line), accessKey (bottom line), and check the consent box. Then click Connect. This may take a couple of minutes as Citizens Treasury Intelligence authenticates your account and communicates with Sage. Note: The credentials in the screenshot will link data found in Acme8, the Trovata demo instance. Acme8 companyId: xbIyqnglwWJP Acme8 accessKey: uZ7hA5JiqT9QkYh75aKA

Select one bank account to upload transactions for, then click Continue. In this case Acme8’s account 5212 shown here has plenty of demo data to test this Sage integration with

Select a transaction history start date by clicking the calendar, selecting a desired start date (how far back to upload historical transactions from), and click Confirm. If you do not click Confirm, your start date may not be saved.

After clicking Confirm on the start date, the start date should be saved in the box below “Download starting from”. Then click Finish.

To complete the process, click Confirm. This will kick off the transaction upload step. The transactions uploader should be able to handle any volume of transactions given to it. The current estimated processing time is about 2 minutes per 2000 transactions. Times may vary.

Once you have confirmed the connection, you should be redirected to this screen. The time it takes to present uploaded data varies.

To view the uploaded transactions, navigate back to Cash Management > All > Accounts > Checking

Now click View on the newly linked account.

Navigate to the Banking cloud tab of your checking account. If everything worked as intended, the linked account should now present transactions that were uploaded. This concludes the onboarding of a single account.

If you want to see how many transactions were uploaded, follow these steps:

If you want to see the total number of transactions, set State to All, Transaction type to All, and click Apply filters on the right side of the screen.

Navigate to the last page of the transactions explorer, and note the number of transactions by the number on the left hand side.

Multi-Account Onboarding - Before You Begin You Will Need:

Once you have onboarded one account using the single account onboarding flow (described above), you may onboard multiple accounts at the same time.

  1. Sage Intacct Admin privileges to connect the desired accounts.

  2. Permissions to create or edit an existing Role

  3. Permissions to assign a role to a user

  4. Onboarded accounts in Citizens Treasury Intelligence from their desired banking institution

  5. Needed while Sage is still in Beta:

    1. Bank of America Beta Code: 987463

    2. Wells Fargo Beta Code: 590691

    3. JP Morgan Beta Code: 165364

  6. Company ID that can be found in the Customer DynamoDB table

  7. Access Key that can be created with the below cURL

1## Post AccessKeys

2## Given an access key name (label), and companyId, create a new Access Key

3## that is stored to the AccessKeys table

4curl -X "POST" "https://admin.trovata.io/v2/customers/accesskeys" \

5 -H 'x-api-key: Kt9U5xuvTKOi7ERfUVeB7K9lbzDyAahymtMIu680' \

6 -H 'accessKeyName: <customerName>_<Date>' \

7 -H 'companyId: <customerCompanyId>'

You can verify the above Access Key was created by fetching all access keys available to a given companyId

1## Get AccessKeys

2## Given a companyId, fetch all access keys stored in the AccessKeys table

3curl "https://admin.trovata.io/v2/customers/accesskeys" \

4 -H 'x-api-key: Kt9U5xuvTKOi7ERfUVeB7K9lbzDyAahymtMIu680' \

5 -H 'companyId: <customerCompanyId>'

1. Enable Sage Cloud Services for your Sage Intacct instance

Navigate to Company > Admin > Subscriptions in the upper left menu.

Find the “Sage Cloud Services” option, and enable Sage Cloud Services. This enables your Sage instance with the process to link accounts from Citizens Treasury Intelligence to Sage.

2. Enable the Financial Institution feature

Navigate to Cash Management > Company > Admin > Roles

Add a new role, or Edit an existing role to add the Financial Institution feature permissions

If adding a new role, name the new role appropriately and click Save

After saving the new role, check Cash Management, then click Permissions

Grant all Financial Institution permissions, most importantly Map accounts. Then click Save. The Map accounts permission is required to complete this multi-account onboarding flow.

Navigate to Company > Admin > Users

Click Edit on the admin user that you want to add this role to

Click Roles information, and click the empty Role Name box (in this case it is in row 3)

Select the new role with the Financial Institution permissions. Click Save on the upper right.

You may be prompted to enter your password to confirm the change. After you confirm the change, you may need to log out and log back into Sage for the changes to take effect.

3. Create a Financial Institution in Sage

This “financial institution” idea is a way to group multiple accounts with the same Banking Cloud Provider; or in this case Trovata.

Navigate to Cash Management > Setup > Financial Institution. If this option is not available, the role may not have been set correctly on the user.

Click Add in the upper right corner

Give this new Financial Institution an ID and Name, select the account that was connected during the single account onboarding flow. Click Save and continue in the upper right.

After saving, click Map accounts

Select the desired Sage accounts, with the corresponding Banking cloud account. This list should contain all of the available accounts that were linked to Sage during the single account onboarding flow. You may continue adding multiple accounts to the Map by pressing the + button on the next row.

After selecting your accounts and Transaction start date, click Map.

After clicking Map, you should see your desired accounts in the Accounts list, with In progress as the Banking cloud status. The transaction upload process has been started for the newly mapped accounts.

To view uploaded transactions, navigate to Cash Management > All > Accounts > Checking

Click View on any of the newly mapped accounts

Navigate to the Banking cloud tab to view all of your newly uploaded transactions. This concludes the multi-account linking onboarding flow.

Did this answer your question?