Skip to main content
All CollectionsIntegrationsBank Connectivity
Bank Connectivity: File Formats and SFTP Configuration
Bank Connectivity: File Formats and SFTP Configuration
Updated over 6 months ago

In order to receive bank transaction data via SFTP, Tesorio needs the following information.

File Formats

Tesorio supports four file formats for importing bank transactions via SFTP.

  • BAI2 (.TXT or .BAI file extension)

    • Comma separated file with 16, 88 records

  • CAMT53 (.XML file extension)

  • CSV (.CSV extension)

    • Review this article for CSV file requirements. Contact your Tesorio CSM to configure your CSV file format.

  • Bank Lockbox BAI (.TXT extension)

    • Fixed width file with 6, 4 transaction records

    • Contact your Tesorio CSM to configure your Lockbox file format.

These files contain prior day transaction data for one or more bank accounts. Tesorio creates unposted payments from these files and matches them against customer and invoice data.

Note: Tesorio does NOT support intra-day files.

SFTP Configuration

Three options are supported for SFTPs:

  • Bank hosted SFTP

    • This is the most common, preferred option

    • If required, Tesorio's static IP address is 44.199.23.90.

  • Customer hosted SFTP

    • If required, Tesorio's static IP address is 44.199.23.90.

    • If you choose this option, Tesorio will configure the SFTP.

Bank Hosted Authentication Options

Username/Password authentication:

The following details should be provided by the bank

  • SFTP Server Location

    • The address used to access the SFTP via an SFTP Client

    • e.g. sftp.<bank-name>.com

  • Directory Path

    • If files are being dropped in the top level directory, leave the default value in the field as ./

    • For subfolders, provide the full path

  • Port

  • User Name

  • Password

After this information is provided, enter in Tesorio and validate the connection is live.

SSH Authentication:

Generate an SSH key in Tesorio and send it your bank. The bank should confirm when the SSH key has been configured.

The following details should be provided by the bank

  • SFTP Server Location

    • The address used to access the SFTP via an SFTP Client

    • e.g. sftp.<bank-name>.com

  • Directory Path

    • If files are being dropped in the top level directory, leave the default value in the field as ./

    • For subfolders, provide the full path

  • Port

  • User Name

After this information is provided, enter in Tesorio and validate the connection is live.

Did this answer your question?