How to configure unloading and loading of a client bank in 1C 8.3

Let's look at setting up a client bank in 1C Enterprise 8.2.

Setting up a bank client is a very important setting of the 1C system. It greatly simplifies the life of an accountant from simple and routine work. This article will tell you about setting up data loading into 1C Enterprise Accounting 8.2 from bank client files. We will not consider downloading data from the client’s bank - it is different for each bank. Let's look at how to download statements from a bank client in 1c.

Setting up a bank client with 1C

To set up a client bank in 1C 8.3 you need to:

Go to the menu “Bank” - “Bank statements” - “Download”:

The system will inform you that there are no settings in the system, click yes:

In the Maintained bank account section, you must indicate the account to which payment orders will be sent. In the Program name list, select the program from which you are downloading the file. For Sberbank, this is the Client automated workplace of the Client-Sberbank AS of Sberbank of Russia.

Upload/upload file - setting up the disk space where payment orders will be exchanged between the client bank and 1C 8.3. By default the files are named kl_to_1c.txt and 1c_to_kl.txt.

That's all. Setting up the bank client is complete.

Loading payment orders

If your client bank is configured, loading payment cards into 1C 8 is very simple:

If you were unable to set up a bank client or need to set up a bank client that is not provided for in the standard 1C configuration, or you need other modifications, you can contact a professional 1C programmer for help.

List of banks that can exchange data with 1C:

• Sberbank
• VTB 24
• Rosselkhozbank
• Bank opening
• Bank of Moscow
• UniCredit
• Rosbank
• Alfa Bank
• LOCKO-Bank
• MPI-Bank
• BANK "YUGO-VOSTOK"
• Sberbank of Russia
• NOMOS BANK
• Lefko-Bank
• Vanguard
• Moscow Industrial Bank
• Prio-Vneshtorgbank
• PROMSVYAZBANK
• Uralvneshtorgbank
• Bank "New Symbol"
• Raiffeisenbank
• IMPEXBANK
• Sofia
• and many others

Based on materials from: programmist1s.ru

In this article I will tell you how to use the functionality of bank statements and exchange with a client bank in 1C 8.3 Accounting 3.0:

• where bank documents are located in the program interface;
• how to create a new outgoing payment order;
• how to upload payment slips for payment to the client bank;
• how to download a statement from the client bank and post them;
• How to download confirmation of successful payment of outgoing payments.

The general scheme of work for a single day with statements in 1C is as follows:

1. We load from the client-bank into 1C: receipts for yesterday and confirmation of yesterday's outgoing payments (+ commissions).
2. We create payment orders that need to be paid today.
3. (or use the Direct Bank system).

And so every day or any other period.

In the interface, the journal of bank statements is located in the “Bank and Cash Office” section:

How to create a new outgoing payment order

A payment order is a document to be sent to the bank; it can be printed using a standard bank form. Entered on the basis of the Invoice, Receipt of goods and services and other documents. Be careful document does not make any postings in accounting! The postings are made by the next document in the chain, 1C 8.3 - “Write-off from the current account”.

To create a new document, go to the “Payment orders” journal in the above section and click the “Create” button. A new document form will open.

The first thing you need to start with is choosing the type of operation. The choice of future analytics depends on this:

Get 267 video lessons on 1C for free:

For example, select “Payment to supplier”. Among the required fields for this type of payment:

• Organization and organization account are the details of our organization.
• Recipient, agreement and invoice - details of our counterparty-recipient.
• Amount, VAT rate, purpose of payment.

After filling out all the fields, check that the details are correct.

Our video about bank statements in 1C:

Uploading payment orders from 1C to the client bank

The next stage is transferring data on new payments to the bank. Usually in organizations it looks like this: throughout the day, accountants create a lot of documents, and at a certain time the responsible person uploads payments into the banking program. Uploading occurs through a special file - 1c_to_kl.txt.

To upload, go to the payment order journal and click the “Upload” button. A special processing will open in which you need to specify the Organization and its account. Then indicate the dates for which you need to upload, and where to save the resulting file 1c_to_kl.txt:

Click “Upload”, we get a file with approximately the following content:

It needs to be loaded into the client bank.

Our video on setting up, loading and unloading payment cards:

Almost any bank client supports uploading a file in the KL_TO_1C.txt format. It contains all data on incoming and outgoing payments for the selected period. To download it, go to the “Bank Statements” journal and click the “Download” button.

In the processing that opens, select the organization, its account and the location of the file (which you downloaded from the client bank). Click "Update from statement":

We will see a list of documents 1C 8.3 “receipts to the current account” and “debits from the current account”: both incoming and outgoing (including for). After checking, just click the “Download” button - the system will automatically generate the necessary documents according to the list with the necessary accounting entries.

• If the system does not find the TIN and KPP in the 1C directory, it will create a new one. Be careful, there may be a counterparty in the database, but with different details.
• If you use, be sure to fill them out in the list.
• If the created documents do not contain accounting accounts, fill them in the information register “Accounts for settlements with counterparties”. They can be set both for the counterparty or agreement, and for all documents.

Published 07/23/2014 18:41 Views: 56723

Many accountants have to do double work - generate payment orders in the client bank, and then enter them again into 1C. A lot of valuable working time is spent on these operations only because when installing 1C, downloading an extract from the client bank was not configured. Making this setup is not at all difficult and I hope that my article will help you deal with this issue and save time.

We will look at the example of the 1C program: Enterprise Accounting 8, edition 3.0.

Go to the "Bank and Cash" tab and select the "Bank Statements" item.

In the window that opens, click the "Download" button, select the organization and bank account (data for each account is downloaded separately) and click the "Settings" button at the bottom of the screen. If, after selecting an organization, the program immediately displayed a message,

Then click "Open settings".

Select the name of the program (client bank) from the list. Then you need to specify the download file. What it is? This is a file that contains all the information about the cash flow in the account. In order to create it, you need to go to the client bank and find the unloading point in 1C. Unfortunately, I cannot describe how to do this, because... There are a lot of bank clients and they are all different; as a rule, you need to look for the “Data Export” menu item and select export to 1C (you can consult your bank’s technical support on this issue). When uploading a file, you will need to specify the folder in which it will be located. And then in 1C, enter the path to this folder in the “Upload file to 1C: Accounting” field.

The "Upload file" field is used if outgoing payments are made in 1C and then uploaded to the client bank. If you make all payments directly to the client bank, then this field does not need to be changed.

I would also advise checking the “Automatically run after downloading” checkbox. In my opinion, it is more convenient when documents are posted immediately, otherwise you will have to go into each of them and post them. And if the checkboxes are checked, you will need to manually review only those documents in which any details have not been filled in.

After the settings are made and the data file is downloaded from the client bank, click the “Update from statement” button. We look through the list of payment orders, especially carefully check the “Type of transaction” column, make corrections if necessary, and click the “Download” button. Now you can open a bank statement in 1C and view the downloaded documents.

Payment orders, or payment slips, are downloaded from 1C 8.3 for further loading into the client bank. To correctly upload payment bills, you need to configure certain 1C 8.3 parameters. Read on to learn how to set up an exchange and how to upload payment cards from 1C 8.3 to the client bank.

Read in the article:

After you have created payment orders in 1s 8.3, you can upload them to the client-bank system for payment. The procedure for exchanging payments in 1C 8.3 consists of two stages:

1. uploading a text file from 1C 8.3
2. uploading this file to the client bank

To generate an upload file in 1C 8.3, you need to set up an exchange with the client-bank. Setting up the exchange is necessary not only for the correct upload of payment slips from 1C 8.3, but also for loading bank statements from the client bank into 1C 8.3. In this article we will tell you how to set up an exchange and how to upload payments from 1C 8.3 to the client bank in three steps.

How to download payments from BukhSoft

Step 1. Set up data exchange with the client bank in 1C 8.3

Go to the “Bank and cash desk” section (1) and click on the “Payment orders” link (2). A window will open with a list of previously created payments.

In the window that opens, in the “Organization” (3) field, select the organization (4) for which you want to set up an exchange. A window will open with a list of created payments for the selected organization.


Next, click on the “Send to bank” button (5). A window for exchanging data with the bank will open.


In the “Exchange with Bank” window, click the “Settings” button (6). The exchange settings window will open.

Step 2. Specify data exchange settings in 1C 8.3

In the “Exchange Settings with Bank Client” window, specify:

• your bank account (1). Select the bank account for which you are setting up the exchange;
• program name (2). Select from the list the bank client program that corresponds to your bank account, for example, “Client-Bank System” of CJSC “Bank “New Symbol””;
• upload file to the bank (3). Here, click “Select” (4) and specify the name of the file and its location on the disk. When uploading payment invoices, this file will be used for exchange;
• correctness of the document number (5). Check the box if you want the client bank to check payment slip numbers for repeatability.

After completing the settings, click the “Save and Close” button (6).

Step 3. Upload payments from 1C 8.3 to the client bank

Client bank - a program for remote work with your servicing bank. In such systems it is possible to download files with payment slips from 1C 8.3. To download a file from 1C 8.3, go to the “Bank and Cash Desk” section (1) and click on “Payment orders” (2). A list of payment orders that you created in 1C 8.3 will open.

In the window that opens, select your organization (3).


Now in the window you will see payments only for the selected organization. Next, click the “Send to Bank” button (4). The “Exchange with Bank” window will open.


In the window you see payment orders prepared for payment. They are in the Prepared state (5). Payments that will be downloaded are marked with ticks (6). You can uncheck payment orders if you do not want to pay for them. In the “Upload file to bank” window (7) you will see the path to the file that you specified in setting up the exchange with the client-bank. You can specify another file to upload. To do this, press the “…” button (8). To save the file with payments, click the “Upload” button (9). After this, the payment status will change to “Sent”. Your payments have been sent to the bank.


The file with payments is visible in the “Upload file to bank” field (7). Log in to your bank client and download this file to make a payment. You specified the location where this file is located in setting up the exchange with the bank (see step 2).

Let's look at setting up a bank client in 1C Enterprise 8.2.

Setting up a bank client is very important. It greatly simplifies the life of an accountant from simple and routine work. In this article we will only look at setting up data loading into 1C Enterprise Accounting 8.2 from client-bank files. We will not consider downloading data from a client bank - it is different for each bank. Let's look at how to download statements from the client bank into 1C.

Setting up a client bank with 1C

To set up a bank client in 1C 8.3 you need to:

Go to the menu “Bank” - “Bank statements” - “Download”:

Get 267 video lessons on 1C for free:

The system will inform you that there are no settings in the system, click “yes”:

In point Serviced bank account You must indicate the account to which payment orders will be sent. On the list The name of the program select the program from which you are downloading the file. For Sberbank, this is the Client automated workplace of the Client-Sberbank AS of Sberbank of Russia.

Upload/upload file - setting up the disk space where payment orders will be exchanged between the client-bank and 1C 8.3. By default the files are named kl_to_1c.txt And 1c_to_kl.txt.

That's all. The client bank setup is complete.

Loading payment orders

If your bank client is configured, loading payments into 1C 8 is very simple: