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.
Bank Lockbox PDF (.pdf extension) (Cash Application Only)
PDF file containing image scans of checks. Checks can span more than 1 page, but each page should only reference a single check.
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.