The Kolleno team can bulk create SFTP (or manual upload) reconciliation accounts for your company instance, especially useful when no connector is available via Open Banking or Plaid.
Each row in the CSV will create both a reconciliation account for you to import transactions to.
📥 How it works
When SFTP reconciliation accounts are imported, Kolleno will create the necessary bank connections and accounts to enable reconciliation of bank statements uploaded via SFTP. If you do not have the SFTP connection, you can still upload manually, such as ISO20022 among other file formats.
📄 CSV Format Required
To proceed, provide a CSV file with the following columns:
Column | Description | Required |
| ISO currency code (e.g., | Yes |
| Account name | Yes |
| IBAN | No |
| Account number | No |
| Sort code | No |
Example:
currency,name,iban,number,sort_code
GBP,Main Operating Account,GB82WEST12345698765432,12345678,123456
USD,USD Holdings,,87654321,
EUR,Euro Account,DE89370400440532013000,98765432,
Sending the File
When sending the CSV to Kolleno Customer Support, please:
Confirm the company name in Kolleno that the accounts should be created for
Ensure the file is provided plenty of time in advance
Important Notes
This import is done manually by the Kolleno team. Please limit the number of requests.
Kolleno will aim to process the file as soon as possible, but no timing guarantees can be made.
Ensure the CSV file is UTF-8 encoded with commas for column separation and double quotes used to enclose values, especially those containing commas or special characters.
Currency codes must match valid ISO codes in the Kolleno system (e.g.,
GBP,USD,EUR).IBANs must be unique within your company — duplicates will be rejected.
Maximum of 50 accounts per file.