To download payment orders from the 1C: Accounting 8 database, you need to open the “Bank and Cash Office” tab and select the “Payment orders” line in the “Bank” section. Click "Upload".

In the tab that opens, select your organization (No. 1) in the drop-down list, the bank account appears automatically. In field No. 2, indicate the date or time period when the payment order was created. Next, in the main field, check the boxes for those payment orders that you want to upload to the client bank.
Below (No. 3) select the location to save the upload file on your computer and its name.
Click "Upload" No. 4.

All that remains is to upload the statement to the client bank.

How to download statements from a client bank into 1C: Accounting 8

To download statements from the client bank, you need to go to the same “Bank and cash desk” tab, but select the “Bank statements” line.

In the tab that opens, click “Download”. A file selection window will open, select the one you need (the document must be saved in *.txt format). In a couple of seconds (sometimes minutes, if there is a lot of data), the list of statements will be replenished with new lines. Next you need to carry them out. To do this, select the required lines, click “All actions” and select “Perform”.

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 the process of work, in each organization, there is interaction with other companies (organizations). Payments must be made for outstanding goods, works, services, taxes and other payments. Currently, this process occurs through the Client-Bank system. This program is installed by bank employees on the computer of a company employee to make payments and load payment orders into the program in which accounting is carried out. Let's look at how bank statements are loaded into 1C.

Uploading statements from the Client-Bank program

In order to download an extract from the Client-Bank program, you must:

• Generate a statement for the required period;
• Export it to a text file to transfer data.

Export occurs when you click on the “Export”, “Export” or something similar button; in different Client-Bank programs this button is called differently. The generated file is uploaded for export to the desired folder, along a predetermined path.

In front of the tabular part of the document in the right corner we find the “More” button, click on it, a window appears with a list of functions, select the “Exchange with bank” item in it.

• The organization through which payment orders will be downloaded;
• Organization bank account.

Click “Download” at the bottom of the document and after that, in the tabular part, all statements from the bank will be loaded into the “1C: Accounting” program. After this, we review the report on the uploaded file and proceed to processing payment orders.

You can set up automatic processing of payment documents upon receipt and debit. To do this you need to configure.

You can select the “Setup with Client-Bank” document:

• By clicking the “Settings” button at the bottom of the “Exchange with the bank” document;

• In the “Bank Statements” journal, select the “Set up exchange with the bank” item from the list when you click on the “More” button.

In the settings, fill in the fields:

• We indicate the bank account from which statements will be downloaded;
• The name of the program is selected from the list provided by the developers - this is the program you are working with. After this, the fields “Upload file from 1C Accounting” and “Download file from 1C Accounting” open. “Upload file from 1C Accounting” only if outgoing payment orders are generated in the 1C database and then uploaded to Client-Bank;

The condition that must be met is the name of the download file in 1C, it must match the name of the download file from the Client-Bank program.

• At the bottom of the settings, two fields open, the left one shows upload data, and the right side shows download data.

In the “After loading automatically post” field, it is advisable to indicate two checkboxes on the positions “Receipt to the current account” and “Write off from the current account”, in this case payment orders will be automatically processed, which in the future only need to be double-checked without going into each of them.

After uploading payment orders, you should carefully check the “Type of transaction” and the created accounting entries, and make corrections if errors are found.

Uploading statements from a banking program into 1C is a very convenient procedure that significantly facilitates the work of the accounting department, significantly saving employees’ time.

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 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.

Instructions

Launch the 1C: Enterprise program. Open the “Bank” section and select the menu item “1C: Enterprise – Bank Client”. If you have not configured sharing settings yet, you will be prompted to do so. Click Yes.

Start setup. In the drop-down menu in the “Program Name” section, select a certified application that matches what your servicing bank uses. For example, many credit institutions use the iBank 2 system.

Next, install the download and upload files for data exchange with the Client Bank. Be sure to check that the links are to different documents. Set the type of documents for data exchange and the encoding that matches the operating system of your personal computer.

Go to the "Download" section. Use the checkbox to mark the types of documents that you plan to work with when downloading a bank statement. Opposite them, mark the cash flow items. A group for new counterparties is selected below. Check that the changes you made are correct and click OK.

Log in to the Client-Bank system. Open the “ ” menu and select the “General” - “Data Import” section. Specify the format as 1C. From the Method drop-down menu, select Sync. Set the directory for data exchange, which must match the one specified in the 1C program.

Carry out a similar operation with the “Data Export” section. Check the entered data and click “Save”. Thus, the setup of data exchange between the Client-Bank system and the 1C: Enterprise application will be completed. When you perform any operation in one of these software, you can check that the synchronization is correct and make corrections if necessary.

Video on the topic

note

Open the “1C:Enterprise – Bank Client” item in the “Bank” menu: Since we have not yet configured the exchange parameters for our current account, the program will display the following window: Answer “Yes”. In the next window that opens, in the “Program name” field, from the drop-down list of certified programs, you must select the system that our bank uses.

Helpful advice

This is a system with which you can upload payments into the bank-client system and send them directly to the bank. Then the payment slips do not need to be entered directly into a separate bank-client program for sending to the bank. To set up interaction with the client-bank in 1C, you need to go to the “Bank” - “Bank Statements” menu. In the journal of bank statements that opens, click the “Download” button. Next, the client-bank form will open.

Sources:

• how to work in a client bank

The company makes all payments in non-cash form, transferring cash accounts from one current account to another. Based on these transactions, the bank provides an extract within the established time frame, which acts as a primary document for accounting. Many accountants encounter difficulties associated with uploading statements into the 1C: Enterprise program.

Instructions

Receive a bank statement for your current account. Study the information provided and divide all cash flows into incoming and outgoing cash flows. Collect primary documentation (invoices, acts, contracts, payment orders, etc.) that confirms the completion of the financial transactions indicated in the statement.