The FloQast Bank Connector Widget, powered by Trovata, is our new turnkey approach to bank integrations. It is a paid feature, so if you want to automate your bank reconciliations within our new AI Matching feature, please contact your ASM for more information!

• FloQast Admins can enable bank connections by creating an account through the Connections Tab.

Account Creation

1. Log in to FloQast and navigate to your Admin Settings (gear icon).
2. Click on the Connections tab.
3. Select Add Connection:
   
4. Select Trovata from the dropdown menu.
5. The only requirement for account creation is agreeing to the Terms of Service, which can be viewed and downloaded inside the Connection Manager.

Adding a Bank Connection

Once the Trovata account has been created, you can connect your banks.

1. Click the green Add Connection button and select Trovata again.
   
   A slide-out panel will populate any existing and pending bank connections previously created.
2. Select New Connection: This allows users to connect to a new bank.
   
   
3. Search for and select your bank:
   • This page contains all available bank connections circled in green.
   • If the desired bank does not show up, a user can request a new bank connection circled in red.
     

NOTE: The connection method will differ from bank to bank. Some banks, such as Silicon Valley Bank (SVB), can be integrated immediately with user credentials. Others may require some additional setup. These connections typically ask for a contact email and phone number, which we will use for outreach with further instructions.

Map Bank Accounts to Entities

Depending on the bank and authorization method, connections will appear in the Connections tab in either a Connected or Pending state.

Those successfully connected will be accompanied by an Edit button for connection configuration.

1. Select Edit for several options to configure your bank connection.
   • Selecting the secondary Edit button in red below will allow you to update your credentials.
     • Updating credentials can fix broken connections due to a password reset or expired token.
2. Provide a Connection Name for this bank.
   This user-assigned name will also be displayed in the Connection Manager.
3. Most importantly, bank accounts can be mapped to FloQast Entities in the blue area.
   Mapping accounts provides an additional layer of security, as bank account data is restricted to their respective Entities.
4. Optionally, admins can deactivate a connection, which can be reactivated anytime.
   Deactivating a connection immediately stops the ingestion of bank data.

Setting Up AI Matching For The First Time

For setting up a new AI Matching account, the process is very much the same as outlined in this article: AI Matching

However, the key difference is in the Secondary Data Source selection. Under the Source dropdown, you'll select the Trovata option.

Next, you'll want to choose the Trovata connection you set up under the Connections dropdown and the bank account from which you'd like AI Matching to pull the transactions.

From there, the rest of the AI Matching setup process is the same! You can select which Reference fields to pull from Trovata, and the transactions will automatically sync when you import your Primary data source. You can also press the Sync button on the Unmatched Transactions page to query the latest data from Trovata at any time.

Note: The Trovata connection will only pull in transactions for the period you're accessing in FloQast. This means that if you have historical/outstanding transactions in Trovata, you'll want to upload them via File Upload first. Once they have been imported, you can follow the above steps to convert from File Upload to Trovata.

Configuring AI Matching For Existing AI Matching Accounts

If you've already been using AI Matching before establishing the Trovata connection, there are a few considerations to note for a one-time reconfiguration. For example, you've likely already created rules based on the file(s) you've been importing and their reference configuration. Once you select the Trovata source in the screenshot above, those references will change to Trovata's references. Some rules you've made for the previous data's references will likely need to be deleted and recreated with the new reference fields in mind.

We recommend fully deleting any old rules that have stopped working after setting up Trovata as your secondary data source, rather than editing them to fit the new connection. Deleting and recreating the rules will ensure a clean reference break so the engine only considers the new reference information going forward.

Recommended Steps When Switching an AI Matching Account from File Upload to Trovata

1. Roll forward any outstanding transactions from the previous period (or upload a file that contains the historical data you want to be included going forward) into the current one before changing the source to Trovata.
2. Change your Secondary Source to Trovata on the Manage Data page.
3. If possible, map your Trovata reference fields to as closely match the reference fields you were using during file upload, including using the same number of references. This is not required, as you can update the number/selection of references as needed, but your existing rules may stop working and may need to be deleted and recreated.
4. Once you import your data, check your existing rules. Delete and then recreate any rules that have stopped working due to switching references.

You should now be successfully syncing your bank transactions into AI Matching each month!