Bank Data can be imported from a bank statement in BAI2 format. This standard format is generally available for download in online banking, and can be configured for automatic transmission via SFTP.
For specific details about BAI2 availability from your bank, contact your relationship manager and inquire about
Direct, manual download from online banking
Automated transmission via SFTP
BAI2 Import Behavior
File Validation
When a file is imported in Tesorio, first the overall structure of the file is validated. Files will fail validation if:
Fields required by the specification are missing
Data in the file does not match the validation totals at the end of the file
When uploading from the UI the file must contain .txt extension.(bai2.txt)
Transaction Validation
After the file has been validated, the account summary and transaction data is imported. In the following cases, data is not imported:
Undefined transaction codes: if the transaction or account record references a transaction code that is not defined in the BAI2 specification, that record is skipped. This includes transaction code 890 which represents a non-monetary transaction.
Duplicate transactions: transactions that appear as duplicates will not be imported. Duplicate transactions are identified when the following is identical across two payments:
Payment Date
Payment Amount
Transaction Type (Transaction Code)
Type (Debit/Credit)
Account Number
Description (first 100 characters)