Automatic import of bank statements into BAS via API: Forget about manual file uploads

Key features and advantages of the module

• Full automation (Background mode): The system works invisibly to the user. A special robot automatically connects to the bank via API according to your set schedule, retrieves fresh transactions, and loads them into the database. Data in BAS is always up to date.
• Automatic counterparty creation: If you receive a payment from a new client who is not yet in the database, the system will independently find them by EDRPOU / TIN (IPN), fill in the details, and create a card in the "Counterparties" directory.
• Multi-currency support: The module works correctly with foreign currencies. That is, the system automatically relies on the account currency set in your BAS database, which eliminates confusion when accounting for foreign currency inflows.
• Flexible auto-fill and transformation: You can configure specific rules for individual payments — the system allows you to change the operation type or fill in the required analytical fields "on the fly".
• Expansion prospects (Creation of documents for signature): Certain bank APIs allow not only retrieving statements but also sending data back to the bank. Upon your request, we can expand this functionality so that you can create outgoing payment orders directly in BAS and send them to the client-bank for subsequent signature by the manager.

Reliable two-level architecture

To ensure maximum security of your commercial data and system flexibility, we have divided the solution into two levels:

1. First level (Configuration Extension): This is the "brain" of the system, which connects directly to your BAS database. Important: the standard configuration remains upgradeable! Directories, payment processing rules, and authorization tokens are stored here. Data is securely protected inside your system.
2. Second level (External Data Processor): This is the "courier" that performs the technical work. It can be launched automatically according to a schedule or manually by an accountant in user mode. Its task is to securely call the bank's API, retrieve the data, and transfer it to the first level to create documents.

Result: Manual work is reduced to zero, bank documents appear in the database on time, and commercial secrets and access keys are never transferred anywhere and remain within the company.

Want to automate work with banks in your company? Contact us, and we will connect the module to your accounts in a matter of days!

Compatibility with BAS configurations

Our extension is developed according to modern standards and works absolutely correctly and stably with the following popular databases:

• BAS Accounting (all versions);
• BAS Small Business.

Do you have a different configuration? 

The architecture of our module allows for quick and seamless adaptation to any other BAS configurations (for example, BAS Comprehensive Enterprise Management, BAS ERP, Trade Management, etc.). If you have a need for automation — we will implement it for your database!

More details in screenshots

Fig. 1. Form for manual retrieval of bank statements.

Fig. 2. Data exchange settings. Here we specify the token and the accounts we will process.

Fig. 3. Based on the payment description, we can change many settings of the "Cash Outflow" document.

Fig. 4. We also have some default settings.

Configuration cost: 10,000 UAH.