Skip to main content
All CollectionsCash Application
Cash Application: Set-up Your Bank Transaction Feed
Cash Application: Set-up Your Bank Transaction Feed

How to connect your bank account to Tesorio

Updated over 2 months ago

Options to Access Payment Data from your Bank

Plaid

If your bank supports an automatic connection to Plaid, you can set this up immediately. Note: if you're not sure whether your account supports Plaid, start with this flow. If you are unable to find your bank account you can connect via SFTP.

  • Go to Administration > Integrations in the navigation. In the box titled “Bank Accounts”, select Get Started and Connect to bank accounts via Plaid.

  • If you already have at least one account added, click Manage Bank Accounts and the Add Bank Accounts option to add another.

  • Follow the prompts from Plaid.

  • If you have multiple bank accounts with a given bank, select only the accounts you wish to use for Cash Application. Only transactions from those accounts will sync to Tesorio.

  • Once you select which accounts to connect with via Plaid, those accounts will appear in a list in the Bank Accounts box.

  • For accounts you actively want to use, make sure the connection status is set to Connected.

  • Optional: to streamline the Cash Application process, select a default GL account to be used when transactions are created from this bank account. You can update this manually for each transaction any time you need to override the default. Read more here.

SFTP

If your bank does not support a connection using Plaid, your Tesorio CSM will work with youand your bank to set up an automatic file transfer between your bank and Tesorio using an “SSH File Transfer Protocol (SFTP)”.

💡Review this article and share the details with your bank in order to set up your STFP connection and select your file format. It may take a few weeks for your bank to configure the SFTP.

Once you have your SFTP information,

  • Go to Administration > Integrations in the navigation. In the box titled “Bank Accounts”, click Add Bank Accounts and select the “Add Manually” option.

  • Enter the SFTP information provided by your bank into the form fields. For more information on SFTP configuration, see this article.

    • For Username/Password Authentication

      • Enter your username and password that will be used to connect to the server

    • For SSH Authentication

      • Enter the username that will be used to connect to the server. Once you finish adding your bank account. And SSH will be generated that can be shared with your bank.

      • At any point from the Bank Accounts page, open the Connection Details and copy or download the SSH to share with your bank.

  • Enter your bank account details.

  • You will have the option to add more than one bank and/or accounts, if needed.

  • Once you’ve completed your SFTP connection, the accounts you added will appear in a list in the Bank Accounts box.

  • For accounts you actively want to use, make sure the connection status is set to Connected.

  • Optional: to streamline the Cash Application process, select default GL, Class, Department, and Location values to be used when transactions are created from this bank account. You can update this manually for each transaction any time you need to override the default. Read more here.

Manually Testing File Imports

When configuring a new bank file, it's helpful to test the file import manually. Once you have configured your Bank Account and SFTP information, navigate to Administration > Flat Files. If you don't see this tab, contact your Tesorio Administrator.

In the Flat Files Status section, you'll see entries for BAI2 File or XML File, depending on the type you configured. Download a BAI2 or CAM53 file from your online banking account, and import it into Tesorio by clicking the import button or dropping the file over the applicable row. The import will begin immediately, and on the right side of the screen you will see the status of the import. If there were any errors, an error report is available for download. If the file processed successfully, navigate to Customer Payments > Unposted Payments to view your imported transactions and complete the matching and posting process.

Did this answer your question?