When your bank’s SFTP server is connected to Kolleno, bank statements are imported automatically every day. No manual action is required once the setup is complete.
This allows you to benefit from fully automated reconciliation even if your bank does not support a direct integration.
Benefits of Using SFTP Imports
Fully automated – No manual uploads required
Secure – Encrypted connections with key-based authentication
Reliable – Runs continuously without user intervention
Timely – Transactions appear shortly after the bank publishes them
How the Automated SFTP Import Works
Step 1: Your Bank Generates Statement Files
Each day, your bank creates statement files containing recent transactions.
These files follow the ISO20022 standard, which is widely used by banks worldwide.
Step 2: Files Are Uploaded to the Bank’s SFTP Server
Your bank places the statement files on a secure SFTP server. This SFTP server acts as a protected storage location that only authorized systems can access.
Step 3: Kolleno Fetches New Files Automatically
Kolleno connects to the SFTP server every hour to check for new files.
When new statements are detected:
They are securely downloaded
Duplicate files are ignored from this process
Only new data is processed and uploaded to Kolleno
Step 4: Statements Are Processed and Reconciled
Processes the statement data
Matches transactions to invoices and expected payments
Displays the results in your account like any other bank connection
What You Will See in Kolleno
Once configured, SFTP-imported bank statements:
Appear alongside statements from directly integrated banks
Follow the same reconciliation and reporting logic
Require no special handling from your side