We regularly have to explain to accountants how to generate payment orders in a client bank, and also enter them into 1C programs again. To avoid double tedious work, just set up a simple transfer - loading bank statements into the program. The complexity of this operation is small for any accountant, and he is able to cope with it on his own and figure it out.

In a programme 1C:BP 8, edition 3.0, open the section Bank and cash desk and choose Bank statements.

In the window that opens, click the button Download and fill in the details of our Organizations and her Bank account, then press the button Settings. If after filling in the details Organizations the program displays a message,

then let's press Open settings.

Here we will select the program name from the drop-down list and specify the file to download.

To generate the required file, you need to go to your banking program, find a service for uploading data to 1C and create the necessary file.

Due to the huge diversity of bank clients, it is not possible to describe this to everyone. As a rule, you need to find the “Data Export” menu item and select export to 1C there. You can get more precise instructions by consulting your bank’s technical support or on the bank’s website.

In any case, when uploading a file, you will need to indicate the folder into which the file will be uploaded (remember it). In the future, in 1C you will need to enter the path to the folder in the “Upload file to 1C: Accounting” field.

The name of the file itself may differ from (kl_to_1c.txt). The “Upload file” field is filled in if you plan to initially enter outgoing payments in 1C, and then upload them to the client bank through this processing.

I also recommend unchecking the “Automatically run after downloading” checkbox. When the checkbox is enabled, documents are processed immediately, and you may miss something important. I advise you to go to each of them and conduct them yourself.

If you have done everything according to the instructions, then the settings have been made and the data file has already been downloaded from the client bank, then click the “Update from statement” button. Enjoy viewing the list of payment orders, focus on the “Type of transaction” column, then make the necessary corrections, if necessary, and click the “Download” button.

All! You can open bank statements in 1C and check/post downloaded documents.

It’s the 21st century and I’m surprised to learn that some accountants still enter bank statements into 1C: Accounting manually, although in all programs of the 1C family (starting with 7) this process is automated.

And if in 1C 7.7 there were still complaints about it, then the mechanism for loading bank statements for 1C: Accounting 8.3 (revision 3.0) truly deserves all praise.

I’ll tell you step by step how to download statements from your client bank (using the example of the iBank system as the most common now) into 1C: Accounting 8.3.

1. Launch the client bank. From the main menu, select "Settings" - "General".

2. In the settings that open, go to the "Export" tab. Check the box in section 1C and uncheck all other sections. As an exchange file in section 1C, enter any path to a file with the extension ".txt". Click the "Save" button.

3. Now get the statements for the required number, select them all (key combination Ctrl + A) and select the down arrow in the panel next to the Out button. From the list of commands that opens, select "Export to 1C...".

4. Half the battle is done! The statements were uploaded to the same file that we specified in the client bank settings.

Since you are downloading statements for the first time, this is a necessary precaution.

5. Now launch 1C and go to the “Bank and Cash Desk” section. And then select "Bank Statements" in the panel on the left.

6. In the statement log that opens, click the “More” button and select “Exchange with bank” from the drop-down list:

7. An exchange window with the bank has opened. Select the "Load from Bank" tab.
Specify the bank account and the file into which statements from the client bank were downloaded:

8. In the bottom panel, click the "Download" button. And all extracts from the file will be uploaded to 1C.

9. Done! All that remains is to view the “Load Report”.

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

Before setting up the exchange, let's answer the question: “Where is the exchange service with the bank in 1C?”

And, as it turns out, everything is not so simple here.

As a rule, they point us to the Bank Statements magazine, where the developers placed a magic button Download and they stop there. But we will go further and explore all possible ways to access this wonderful service.

Uploading from Client Bank to 1C 8.3 from the journal of bank statements

So, we have already named the first option - downloading bank statements is possible using the button Download from the magazine of the same name in 1C. This is a typical download option that developers offer for use. It will do the following:

But that is not all!

Uploading statements from Client Bank in 1C 8.3 from Exchange with bank processing in the Service group (Bank and cash desk section)

We can upload and download information on banking transactions from the processing itself Exchange with bankom. We can launch it traditionally through the Main Menu - All Functions, or by adding this processing to the active commands of the section Bank and Cashier.

This can be done from the action bar settings by adding the available command Exchange with bank to selected section commands:

Team Exchange with bank will appear in the Service group (Bank and cash department section):

But that's not all!

Uploading statements from Client Bank in 1C 8.3 from the Exchange with bank form in the bank statement journal

In the Bank Statements journal itself, it is possible to open a form Exchange with bankom by the action menu command MORE – Exchange with the bank.

This same command can be placed on the Bank Statements command panel. Since we, of course, want to be somewhat different from the monotonous coverage of this issue on the Internet, we will now consider this option.

We are sure that this will be useful to you in your future work.

Changing command properties Exchange with bank. From the action menu “More – Change form” of the Bank Statements journal, we will include the Exchange with Bank service in the journal command panel:

Processing Exchange with bank is available in the list of bank statements:

All options for calling the Exchange service with a bank:

• Directly from the Exchange with bank form (section Bank and cash desk);
• From Bank statements according to the book. Download;
• From Bank statements using the action menu command More – Exchange with bank;
• From the Main menu – All functions – Processing – Exchange with the bank.

Let's move on to the second part of the question - settings for Exchange with the bank.

How to set up downloading from the Client Bank in 1C 8.3 Accounting 3.0

Before you start setting up an exchange with a bank, enter the banking program and find the item in it Uploading to 1C. Copy the file name onto a piece of paper - this will be needed when setting up data exchange loading in 1C.

Now open the processing form Exchange with the Bank in 1C 8.3:

Displayed in form Exchange Bank organization and bank account through which we will perform operations for downloading statements and open the Settings form.

Exchange parameter settings are stored in a special information register Data exchange settings with the Bank Client: Ch. menu – All functions – Information registers:

After specifying the organization and bank account for which we will create an exchange setup, according to the book. Setting up, go to the form for setting up an exchange with the bank.

Settings for program name and download/upload files:

Serviced Banking check– is on by default.

The name of the program– the name of your banking program you are working with. You select the name of the program from the drop-down list provided by the developers.

For example, for SBERBANK this is a program AWS “Client” AS “Client-Sber”Bank" of Sberbank of Russia:

File download fromjar– this is the name and location of the file into which data will be downloaded from the Bank Client. Typically, the text file kl_to_1c.txt is used. But you can use other options.

The only condition: the name of the download file in 1C must match the name of the download file on the bank’s side. This is where the data recorded on a piece of paper from your banking program using the upload file in 1C will help. Please pay serious attention to this. This is the most common exchange setup mistake. If the path is specified incorrectly, the exchange will not work.

Another very important note: enter the file name without spaces, spaces, or unnecessary extensions. After entering, check that the file in the 1C window “Download file from Bank Client” and “Upload file in 1C” of your banking program completely match!

Check with your bank's technical support service about encoding of upload data. This can be either DOS or Windows. 1C supports working with both encodings.

Default substitution details

These settings are optional:

You can set the Cash Flow Item for substitution in the new documents Debiting from the current account and Receipt to the current account. But in fact, it rarely happens that the DDS article is the same for all occasions. Therefore, in order to avoid confusion and make mistakes, these fields are left blank. The data on them is filled in after the exchange is completed.

Groups for new contractors

Also with filling in the Group settings parameter for new counterparties. The accountant has the right to decide how he will control the counterparties in the database created by downloading bank statements in the event that 1C 8.3 did not find the necessary payers and recipients in.

Load/Unload Block

This block already works with the data received from the bank and, before generating new documents in 1C, asks you to decide on the loading and unloading actions:

We are now considering downloading statements from the Bank Client and here the user chooses whether it is necessary to automatically create new objects in the database and post new documents. But, probably, the checkboxes for posting documents of receipts to the current account and debits from the current account will be convenient.

Uploading from the Client's Bank to 1C 8.3 Accounting 3.0

Once you save the settings, you can start uploading documents.

After the cash flow data from the banking program has been uploaded to a file and received by the accountant, you can load it into 1C. During the loading process, the documents Receipts to the current account and Write-offs from the current account are created.

The sequence of actions of the accountant when downloading statements is as follows:

1. We indicate the bank account of the organization;
2. Choosing an organization;
3. Check the path to the download file;
4. We control the information in the data loading file;
5. Download bank statements;
6. We generate a report on downloaded statements:

If no mistakes were made in setting up the exchange with the bank, then the program will handle the download without any problems. Your task is to check the data before downloading:

What you need to pay attention to first:

1. When checking data before uploading, pay attention to the icon in the column next to the date:

• An icon with a check mark means that the document is in the database and has been posted;
• An icon without a checkmark indicates that the document is in the database, but has not been posted;
• The icon with a “sun” signals that a new document will be created.

1. When loading data, a “not found” message appears:

• By counterparty, if neither the bank account specified in the download file nor the TIN is found;
• For the counterparty's account, if the account number is not found in the download file;
• According to the contract, if the owner of the contract and the required type of contract are not found in the 1C database;
• If there are several identical objects in the database, the first one from the list will be selected and a warning will be issued regarding the situation;
• When re-uploading documents, the program analyzes the Amount and Payment Type data. If they change, the data is overwritten.

After downloading bank statements, you can print a report on the downloaded documents in 1C:

How to automatically monitor invoice payment, how this is affected by the status of invoice payment, that is, quickly report to the manager on paid and unpaid invoices, you can study the features of processing banking transactions in 1C 8.3 on our

How to generate an extract in the 1C 8.3 Accounting program?

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

• where in the program interface are bank documents located?
• how to create a new outgoing payment order
• how to upload payment slips for payment to a client bank
• how to download incoming payment orders and payment confirmations from a client bank

Working with the bank

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

1. We download from the bank client 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. We upload them to the client bank

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, the document does not make any accounting entries! 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:

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

• Organization and organization account - 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.

Uploading payment orders from 1C to the client bank

The next stage is the transfer of 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.

Loading client's bank statements into 1C

Almost any bank client supports uploading a file in the KL_TO_1C.txt format. It contains all the 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 bank services). 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 a counterparty in the 1C database using INN and KPP, it will create a new one. Be careful, there may be a counterparty in the database, but with different details.
• If you use cash flow items, 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.

Based on materials from: programmist1s.ru