1s 8 bank statements holding. Accounting info. Receiving payments from buyers

Today we will look at how to correctly post a bank statement in 1C.

Now we will consider in more detail the issue of working with such a document as a 1C bank statement. As an example, let’s take a situation where you need to make a non-cash payment in accordance with a supply agreement.

For example, there is a certain company Pilot TD, which must pay the UkrPostachSbut company a certain amount. To reflect this action, you need to open the item in the “Bank” menu. There, select the “Outgoing payment order” section. The same procedure can be performed if you go to the control panel. There will be a bookmark of the same name, click on it.

You need to add a new entry in the payment order journal. The payment order must be completed in accordance with the requirements (depending on the specifics of the transfer), and then saved.

After this, you need to open a special category called “Bank Statement”. There, set the day on which the bank statement is directly saved.

Once you have dated it, you need to add another statement.

In the newly created statement, you must fill out the bank account, and also do not forget to put the date. A future bank statement in 1C will be generated for it.

If you have filled in all the required fields correctly, the functional panel will now be available to you. Find the “Select unpaid” tab on it.

A window will open in front of you, where you will need to check the required document (or several documents at once). When the checkboxes are checked, click on the “Check checked” button.

When completed, you need to close the form. Now you can see a statement in 1C, which is generated according to the required date.

There is another simple way to generate outgoing and incoming bank documents. They are formed directly from the extract form itself. This is easy to do, just click on the “+Add” button. And then in the same window you will be able to use 1C documents and:

navigate through all statements;

view the results of the conduct;

change the payment status of documents and much more.

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.

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:

We download from the bank client into 1C: receipts for yesterday and confirmation of yesterday's outgoing payments (+ commissions)
We create payment orders that need to be paid today
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

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:

We load from the client-bank into 1C: receipts for yesterday and confirmation of yesterday's outgoing payments (+ commissions).
We create payment orders that need to be paid today.
(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.

Entering bank statements in the 1C 8.3 Accounting 3.0 program is carried out:

Manual entry of bank statements;

Data on receipts and debits of funds in 1C 8.3 is entered in the Bank Statements journal. The magazine is located in the Bank and Cash Department section:

To manually enter an extract into the program, you need to click on the button in the journal form. Admission or book. Write-off.

There is another way to enter bank statements manually: based on other documents. Then the receipt and write-off data are filled in automatically according to the documents - grounds.

: drawn up on the basis of an Invoice to the buyer, Payment request, Cash issuance, Sales (act, invoice) and other documents.
WITHDene scripturehard means: drawn up on the basis of the documents Invoice from the supplier, Receipt (act, invoice), etc.

According to the received bank statements on cash flows, the accountant enters information into the 1C program:

Receipt to the current account in 1C 8.3

To enter data on cash receipts into the 1C 8.3 program, click book Admission and select the correct Operation Type in the document. The set of available form details depends on this.

To arrange for the buyer to pay for the order on account of the future delivery of goods, select the type of operation - Payment by buyer. We indicate the organization – Trading House “Complex”. If there is only one organization in the database, then the organization field is not shown in the form. This field becomes visible only if there are several organizations in the database.

The field Bank account of the organization, Amount, Payer, Accounts for accounting of settlements and advances – 62.01 and 62.02 is required to be filled in:

Since payment is made before the goods are sold to the buyer, the 1C 8.3 transactions will reflect the prepayment on advance payment account 62.02:

Debiting from a current account in 1C 8.3

Debiting from a current account in 1C 8.3 Accounting 3.0 is executed according to the book. Write-off from the Bank Statements journal. A document form opens, in which the type of operation and organization are indicated.

Let's select the transaction type: Payment to supplier. Let's fill in the data on the counterparty, amount, and bank account of the organization.

We also fill out the tabular part of the document: agreement, VAT rate, purpose of payment:

In this case, the following transactions are generated in 1C 8.3:

Uploading statements from Client Bank in 1C 8.3

The work of the accounting department is structured in such a way that during the day the accountant must prepare payment orders to the bank for current transactions and post the received bank statements for transactions already performed by the bank. Work in 1C 8.3 on interaction with the bank comes down to processing payment orders outgoing to the bank in the program and then entering data on transactions performed by the bank.

Automation of this process involves loading bank statements from the Client Bank into the 1C program and uploading payment orders from the 1C program to the Client Bank.

Currently, most banks support the data exchange format with 1C programs. Loading of bank statements after setting up an exchange with the bank is done from the Journal of Bank Statements according to the book. Download. You can open the Exchange with Bank setup form directly from the Bank Statements journal - book. MORE – Exchange with the bank:

Setting up an exchange with a bank and downloading bank statements is discussed in detail in our other article: “.

According to the book Download Bank Client data is read by the 1C program and loaded into the Bank Statements journal:

When loading data, the 1C 8.3 program matches database objects with data from the loading file. The message that the object “not found” is issued:

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 only the Amount and Payment Type data. If they change, the data is overwritten.

How to upload a payment card from 1C 8.3 to the Bank Client

You can upload payments from the 1C 8.3 program to the Client Bank:

From the Exchange with Bank processing form. If you place the processing in "The Chosen Ones"", it will be accessible from any place where the user works;
From the list of Payment orders according to the book. Unload. When you press the button. Unload The Exchange with bank form opens.

We discussed in detail setting up an exchange with a bank for uploading payment orders from 1C to Client Bank in our other article: “”.

According to the book Unload From the Payment Order Journal, the data is downloaded into a text file and then transferred to the Client Bank:

Exchange form with the bank – Upload to bank tab:

You can study the features of processing banking transactions in 1C 8.3: accounting accounts, documents, postings, bank-client, and correctly configure Direct Bank settings on our. For more information about the course, watch our video:

On the website you can see our other free articles and materials on configurations: