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

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

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.

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 check marks (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).

2.

3. When typing the name of the counterparty in the "Recipient" field, you must type the first letters of the short name of the recipient. If it doesn’t automatically select what you need, you need to click “Show all”, and it will send you to the “Counterparties” directory, where you can select your counterparty.


For convenience, you can filter by TIN, or alphabetically by clicking to change the alphabetical order or the order by TIN. By filtering by TIN, you can also search for duplicates, but unfortunately in the same folder. In version 3.0, it became possible to enable verification of counterparties; it currently works in test mode, but it shows errors well. Such as duplicates, non-existent checkpoints. If you don’t have a subscription to the ITS, you can always follow the link http://egrul.nalog.ru/ and there, using the TIN, Unified State Register of Legal Entities or name, check the latest details of the organization.


4. Let's move on with the bills. When you have added a Counterparty, his current account is added. If it doesn’t fit, it means it’s not filled. You need to press the down arrow (circled in green). “Show all”, if it’s not in the list, then create a new one.
Let’s say the score has improved, but you need to check it, click on the “squares” circled in red.
By analogy with the recipient’s account, we check the “Agreement” line and fill in “Payment Amount” and “VAT Rate”. VAT must be indicated only at 18% or 10%, or 0%, etc. WITHOUT slash. Rates like 18%/118% DO NOT SPECIFY.


5. By clicking “Settings” at the top, we can check the box “


6. Payment order:
When paying suppliers, paying taxes, fees and charges, we always indicate 5, salary 3. Here, in general, if you update on time, everything is clearly marked and up-to-date.


7. Next, check the “Base of payment” Field, make sure there is no checkmark at the bottom next to “Enter a debit document from the current account” if you do not want to generate transactions when creating a payment order. And click “Post and close”, in the new field at the top click the “Upload” button. In a new window, we check the Period for which we are uploading payments. Then we have a selection of all the necessary bills; we withdraw those that are not needed. We go to the address field where the file with payments is uploaded, so that we know where to look later. And the upload button.
Next, go through Explorer to the folder where the text file was and upload it to your Bank client.

A bank statement in 1C 8.3 Accounting is necessary to reflect write-offs and receipts Money by bank transfer. It reflects information about the status of bank accounts at the current moment. Based on accounting statements, transactions on personal accounts are carried out.

Typically statements are generated daily. First, all cash receipts and debit confirmations are downloaded from the bank. Next, current payment orders are generated, which are transferred to the bank at the end of the working day.

A payment order is a document that instructs its bank to transfer a certain amount of its funds to the account of some recipient. This document does not have accounting entries.

In 1C: Accounting 3.0, payment orders are usually created on the basis of other documents, but they can also be created separately. Creation can be done from the list form of this document. To do this, in the “Bank and cash desk” section, select “Payment orders”.

In this example, we will consider creating a payment order based on the “Receipt of goods and services” document. To do this, open the already generated document you need and select the appropriate item in the “Create based on” menu.

The created document will be filled in automatically. If this does not happen, enter the missing data manually. Be sure to indicate the details of the recipient, the payer, the amount of the payment, its purpose and the VAT rate.

Uploading payment slips from 1C to the client bank

Most often, organizations upload payment orders to the bank at the end of the working day. This happens in order not to upload every document, but to upload all those accumulated during the day at once.

Let's look at how this is done in 1C: Accounting 3.0. Go to the form for the list of payment orders (“Bank and cash desk” - “Payment orders”). Click on the “Send to Bank” button.

A processing form will open in front of you, in the header of which you need to indicate the organization or account and the unloading period. At the bottom of the form, select the file into which the data will be uploaded. It will be created and filled in automatically. Check the boxes for the required payment orders and click on the “Upload” button.

To ensure the security of data exchange with the bank, a corresponding window will be displayed. Which will inform you that the file will be deleted after it is closed.

1C will most likely offer you to connect to the DirectBank service. Let us explain a little what this is. 1C:DirectBank allows you to transmit and receive data from the bank directly through 1C. This method allows you to avoid uploading documents to intermediate files, installing and launching additional programs.

To learn how to issue a payment order and debit a current account manually, watch the video:

How to unload a bank in 1C 8.3 and distribute it

Loading a bank statement into 1C is carried out using the same processing as uploading payment orders. Open the “Download Bank Statement” tab. Next, select the desired organization and the data file (which you downloaded from the client bank). After that, click on the “Download” button. All data will go from the file to 1C.

You can see how to manually reflect receipts from a buyer in 1C in this video: