In cases where a BAI2 or CAMT53 file is not available, bank data can be imported via a CSV file. CSV files typically do not have as much data available as BAI2 or CAMT53 files, but can be used as a fallback.
The table below outlines the fields that are supported in a CSV import.
Important Considerations
The header name used in the CSV is configurable and does not need to match exactly with the value in the Column Header column below. When sharing your file with the Tesorio team, provide a mapping between your preferred header and the Tesorio Field
The data outlined in the required fields must be present in the file in the format specified in the description field in order for the import to be successful
All column headers you are using must be present in every file that we import. Values for optional fields can be left blank.
Only one column in your CSV can be mapped to the Tesorio Column Header. If multiple columns in your CSV represent a specific value, adjust your file to meet the required format before importing into Tesorio.
The Column Header must be the first row in your CSV file. If your file has other summary information before the column headers, delete those rows before importing into Tesorio.
Delete any unused columns from your file before importing into Tesorio. If there are any unmapped column headers present in your file, the import will error out.
CSV Format
Column Header | Required? | Description | Example | Tesorio Field Name |
Transaction Date | Yes | Payment date in YYYY-MM-DD format. *If other formats are required, configuration is available | 2023-09-01 | transaction_date |
Account Number | Yes | Numeric account number associated with the payment | 12345678 | account_number |
Amount | Yes | All amounts should be defined as positive values | 10.00 | amount |
Type | Yes | DEBIT or CREDIT | CREDIT | type |
Currency | Yes | 3 letter currency code | USD | currency |
Description | No | Text description of the payment details | INCOMING ACH CUST ID: XXXX INV1234 | description |
Transaction Type Description | No | The BAI code text description | Preauthorized ACH Credit | transaction_description |
Note: The Tesorio Field Name is for internal purposes only