Bank Statement

Import bank statements to automatically create bank income and bank outcome documents.

How to Access

Navigate to: Sidebar > Settings > Bank Statement

Route: /settings/bank-statement

Quick actions:

• Open list

Overview

The Bank Statement module allows you to upload a bank statement file in 1C exchange format and automatically create "Bank Income" and "Bank Outcome" documents. The system analyzes the file, identifies organizations and counterparties by their tax ID (BIN/IIN), and prepares documents for posting.

Fields

Field	Description	Required
Income Article	Income/expense article ID for incoming payments	Yes
Expense Article	Income/expense article ID for outgoing payments	Yes
File	Bank statement file in 1C format (.txt, .csv)	Yes

Step-by-Step Guide

1. Go to Settings > Bank Statement.
2. Enter the Income Article — the article ID for incoming payments.
3. Enter the Expense Article — the article ID for outgoing payments.
4. Select the bank statement file in 1C format (.txt or .csv).
5. Click Import to upload and analyze the file.
6. The system will display a list of parsed documents with type (income/outcome), date, number, amount, and counterparty.
7. For each document, choose an operation:
   • Conduct — create and post the document (updates bank account balances).
   • Save — create the document without posting.
   • Skip — do not create the document.
8. Click Process to execute the selected operations.

File Format

The standard 1C bank exchange format is supported. The file contains documents separated by the КонецДокумента marker, with the following fields:

• НомерДокумента / Номер — payment order number
• ДатаДокумента / Дата — document date
• ПолучательНаименование / Получатель — recipient name
• ПлательщикНаименование / Плательщик — payer name
• ПолучательБИН_ИИН / ПолучательИИН — recipient tax ID
• ПлательщикБИН_ИИН / ПлательщикИИН — payer tax ID
• СуммаПриход / Сумма — payment amount
• НазначениеПлатежа — payment purpose

Tips

• Make sure organizations and counterparties from the statement are already added to the reference guides with correct tax IDs. The system matches records by these identifiers.
• If an organization or counterparty is not found, the system will create them automatically during processing.
• Bank accounts are matched by the account number (IIK).
• The file should be in Windows-1251 encoding (standard for 1C bank statements).

FAQ

What file format is supported?

The standard 1C bank exchange format is supported — a text file with "Parameter=Value" pairs separated by КонецДокумента markers.

What happens if a document already exists?

The system checks for duplicates by number, amount, and date. If such a document already exists, it will be skipped.

What types of documents are created?

• Bank Income (d_bank_income) — when the recipient is your organization.
• Bank Outcome (d_bank_outcome) — when the payer is your organization.