Import Bank Balance via CSV

This article describes how to import bank balances trough a CSV file instead of importing from Open Banking API or Bank Account Statements. 

Setup Integration

In the 'Integrations' tab in the Autopilot view the new Integration is set up.

Select the Plugin 'Bank Balance CSV Importer'

In settings of the integration select:

- Delimiter

- Culture

- Check 'Contains Headers' if the file contains headers (which is recommended)

Map each File Header with the relevant System Field

Required Fields - are all required information and must match with the information in Treasury Systems:

• Legal Entity
• Date
• Booked Balance
• Bank
• Currency
• Account Number - needs to match the master data or could be mapped in tab mappings Entity Acc Send.

Account Name is optional.

Available Balance is optional.

Import file

Files can be imported either by an Activity in Autopilot or imported manually from the Integration via 'Run from file' functionality.