Bank statements in 1s 8.3. Accounting info

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

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

Unloading from the Bank's Client in 1C 8.3 from the journal of bank statements

So, we have already named the first option - downloading bank statements is possible by clicking the button Download from the magazine of the same name in 1C. This is a typical download option that developers offer for use. According to it will be performed:

But that is not all!

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

We can upload and download banking information 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.

You can do this from the action bar settings by adding the available command Bank exchange to the selected commands of the section:

Team Bank exchange will appear in the Service group (section Bank and cash desk):

But that's not all!

Unloading statements from the Bank's Client in 1C 8.3 from the form Exchange with the bank in the journal of bank statements

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 command panel of Bank statements. Since we, of course, want to be somewhat different from the monotonous coverage of this issue on the Internet, now we will consider this option.

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

Changing command properties Bank exchange. From the menu of actions "More - Change form" of the Bank statements journal, we will include the Exchange with the bank service in the command panel of the journal:

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

All options for calling the Exchange with a bank service:

Directly from the form Exchange with the bank (section Bank and cash desk);
From bank statements for the book. Download;
From Bank statements by the action menu command More - Exchange with the bank;
From the Main menu - All functions - Processing - Exchange with the bank.

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

How to set up an upload from the Client's 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 Unloading in 1C. Copy the file name to yourself on a piece of paper - this will be needed when setting up the data exchange download in 1C.

Now open the processing form Bank exchange in 1C 8.3:

We present in the form bank exchange organization and bank account for which we will perform the operations of downloading statements and open the Settings form.

Exchange parameters settings are stored in a special information register. Settings for data exchange with the Bank's Client: ch. menu - All functions - Information registers:

After specifying the organization and bank account for which we will create the exchange setting, according to the book. Settings, go to the exchange settings form with the bank.

Program name and upload/download file parameter settings:

Serviced banking check- is set by default.

The name of the program- the name of your banking program with which you work. Choose the name of the program from the drop-down list provided by the developers.

For example, for SBERBANK, this is a program AWP “Client” AS “Client-Sberbankbank” of Sberbank of Russia:

Download file fromjar is the name and location of the file to which the data from the Bank's Client will be uploaded. Usually, the text file kl_to_1c.txt is used. But you can use other options.

The only condition: the name of the upload file in 1C must match the name of the upload file on the bank side. This is where the data written on the sheet from your banking program according to the upload file in 1C will help. Pay close attention to this. This is the most common exchange setup error. If the path is incorrect, the exchange will not work.

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

Check with the technical support service of your bank about upload data encoding. It can be both DOS and Windows. 1C supports both encodings.

Default substitution credentials

These settings are optional:

You can set the Item of cash flow to be substituted into the new documents Write-offs from the current account and Receipts to the current account. But in fact, it rarely happens that the DDS article is the same for all occasions. Therefore, in order not to get confused and not make a mistake, these fields are left blank. Filling in data on them comes after the exchange.

Groups for new partners

Also with filling in the Group settings for new business partners. The right of the accountant to decide how he will control in the database of counterparties created by uploading 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, it asks you to decide on the loading and unloading actions:

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

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

After saving the settings, you can start uploading documents.

After the data on cash flows from the banking program have been uploaded to a file and received by an accountant, you can upload them to 1C. During the upload process, the Receipts to the current account and Withdrawals from the current account documents are created.

The sequence of actions of an accountant when uploading statements is as follows:

Specify the bank account of the organization;
Choose an organization;
Check the path to the download file;
We control the information in the data loading file;
Uploading bank statements
We generate a report on the downloaded statements:

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

What you need to pay attention to first of all:

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

The checkmark icon indicates that the document is in the database and posted;
An unchecked icon indicates that the document is in the database, but has not been posted;
The sun icon indicates that a new document will be created.

When loading data, the message "not found" is issued:

By counterparty, if neither the bank account specified in the download file nor the TIN is found;
According to the account of the counterparty, if the account number is not found in the download file;
Under 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 according to the situation;
When reloading documents, the program analyzes the Amount and Type of payment 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 the payment of an invoice, how it is affected by the status of payment of an invoice, 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

Usually, work with bank statements is set up automatically through the client-bank system, but the possibility of integrating client-bank and 1C is not always available. In this case, the work with the bank will have to be done manually. Consider how the necessary documents are formed.

Creating a payment order

In order to transfer money from the organization's current account to pay suppliers, pay taxes and other contributions, you need to create a payment order. On the tab "Bank and cash desk" select the item "Payment orders":

A list of payment orders opens. In the upper left part of the document, click the "Create" button, a form for a new payment order opens. The following fields are filled in:

Type of operation - selected from the proposed drop-down list according to the type of payment made;
Recipient - the required counterparty is selected from the directory of counterparties, the recipient's account and the contract are filled in automatically from the counterparty's details;
Amount of payment;
VAT - by default, it is set from the counterparty's data;
VAT amount – calculated automatically;
Purpose of payment.

It is important to correctly specify the type of operation, since depending on the selected operation, the details of the document will change.

For example, when choosing the type of operation “Payment of tax”, you will need to fill in the “Type of obligation” field, you can change the CCC and the OKTMO code (they are filled with up-to-date data by default). The order to pay the supplier looks like this:

After completing the completed order for payment to the supplier, no postings are generated in 1C, this is just an information document that fixes the need to generate a similar payment order in the client-bank system (recall, we are talking about manual work).

Another way to generate a payment order manually is through the "Pay" button, which, like the "Create" button, is located above the list of payment orders. When clicked, a list is opened from which you can select the desired type of payment: "Accrued taxes and contributions" or "Goods and services":

When choosing one of the items, it will analyze the debt of the organization itself and form a list of documents for which payment is required:

To create payment orders for several creditors at once, you can mark the necessary documents in the list and click the "Create payment orders" button.

New payments will be reflected in the list. They are in bold and not posted because they need to be verified. After checking the correctness of filling and the correctness of the amounts, the order is executed. In this case, you also need to duplicate the order in the client-bank system.

As soon as the bank has confirmed that this payment has been transferred to the recipient, the movement of funds on the accounts must be reflected in 1C and debited from the organization's current account.

You can write off the current account from the same payment order. In it, you need to set the status to "Paid" and click on the hyperlink "Enter a debit document from the current account."

The document "Debit from the current account", unlike the payment order, generates postings in 1C.

You can see the postings by clicking the "Show Postings" button:

Everything was filled in correctly: funds were transferred from the organization's settlement account to the supplier's settlement account, which is reflected in the posting Dt60.01 - Kt51. In the list of payment orders, a checkmark appears in the first column opposite the paid documents:

Receiving payments from buyers

To reflect the receipt of funds to the settlement account of the organization, the “Bank statements” item is used in the “Bank and cash desk” section:

When this item is selected, a journal opens, which reflects all receipts and debits from the current account:

To enter information about the receipt, use the "Receipts" button. The document “Receipts to the current account” opens, in which the fields are filled in:

Type of operation - in our case, "Payment from the buyer" is set;

Payer - the counterparty from which the money came is selected from the directory;

The VAT rate, the contract and the item of movement of the DS are filled in from the previously established values.

After filling in all the data, the document is held:

After conducting, you can check the wiring:

Posting Dt51 - Kt62.02 shows that money has been received from the buyer to our account.

The list of bank statements shows up-to-date information on the status of the current account for the current day:

Information is provided on the amount at the beginning of the day, on receipts and write-offs for the day, the balance at the end of the day.

If you need to clarify information for any other day, you can use the calendar to select the desired date:

A list will be generated for the selected day, which will also show all information about the account status.

Register of documents

To get summary information on operations on a bank account, use the "Register of Documents" report, the button of the same name for its creation is located in the bank statements journal. After clicking on the button, a document is generated for printing:

An already completed document is created, it remains only to carry out after verification:

The debt of the counterparty for this implementation is extinguished, the receipt automatically falls into the subordination structure of the implementation:

Similarly, payment orders are issued based on purchases and receipts of services.

Checking the status of the current account

You can check the status of the current account both in the journal of bank statements, and through the "Home Page" on the main page of 1C:

Also, to check the account, you can use the balance sheet for the account (on 51 accounts - for ruble transactions, 52 - for currency transactions).

How to conduct a bank statement 1s 8.2 1s 8.3?

The procedure for conducting a bank statement in 1C version 8.2 is indeed somewhat changed compared to 1C 7.7. But, if you think about it, the apparent inconvenience of the new algorithm is replaced by an understanding of its logic. We have already briefly covered in one of our previous articles the work with a bank statement. This article is “How to sell currency? Sale of currency in 1s 82» |

Today we will consider the process of working with a bank statement in more depth. So, …

for example, we will reflect the process of payment by non-cash under the supply agreement.

Let's say the organization Dobro LLC pays a certain amount to the organization UkrPostachSbut. To reflect this action, open the "Bank" menu item and select the "outgoing" item. The same can be done in the control panel on the tab of the same name.

Add a new entry to the journal of payment orders. We issue an outgoing payment order in the appropriate way. We save it.

Then we add a new statement.

In the created statement, fill in the required bank account and the date on which the statement is generated.

After filling in all the details, the functional panel will automatically become available, on which you need to click "Pick up unpaid".

In the selection window, mark the required or several necessary documents with checkmarks and click "Submit selected".

After the completion, we close the form and the statement formed by the required number becomes visible.

In fairness, we must add that we can also generate outgoing and incoming bank documents directly from the statement form. This is done simply by pressing the "+ Add" button.

In the same statement window, you can navigate through the statements, view the results of the transaction, change the payment status of documents, etc.

We hope that our article has sufficiently fully covered the answers to the questions: How to issue an outgoing payment order? How to make a payment? How to enter bank statements in 1C version 8.2? How to make a bank statement 1C? How to post a bank statement in 1s? How to conduct a bank statement in 1s 8? Bank statement 1C 82″

If you have any difficulties, we will definitely help.

You can discuss the operation and ask questions about it at.

If you have any questions about the article or there are unresolved problems, you can discuss them at

Rate this article:

Bank statement in 1C 8.3 Accounting is necessary to reflect the write-off and receipt of funds by bank transfer. It reflects information about the state of bank accounts at the current moment. On the basis of statements in accounting, operations are carried out on personal accounts.

Usually statements are generated daily. First, all cash receipts and debit confirmations are downloaded from the bank. Next, there is the formation of current payment orders, 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 a recipient. This document has no accounting entries.

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

In this example, we will consider the creation of a payment order based on the document "Receipt of goods and services". 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 specify the details of the recipient, payer, amount of payment, its purpose and VAT rate.

Uploading payments from 1C to a client bank

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

Consider how this is done in 1C: Accounting 3.0. Go to the form of the list of payment orders ("Bank and cash desk" - "Payment orders"). Click on the "Submit to Bank" button.

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

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

1C will most likely prompt you to connect to the DirectBank service. Let's explain a little what it is. 1C:DirectBank allows you to send and receive data from the bank directly through 1C. This method allows you to avoid uploading documents to intermediate files, installing and running additional programs.

For information on how to issue a payment order and debit from a current account manually, see the video:

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

The bank statement is loaded into 1C using the same processing as the unloading of payment orders. Open the "Download Bank Statement" tab. Next, select the required organization and data file (which you downloaded from the client bank). After that, click on the "Download" button. All data will get from the file to 1C.

You can see how to reflect the receipt from the buyer in 1C manually in this video: