Posting an extract in 1s 8.3. Accounting info

Today we will look at how to properly conduct 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 payment by non-cash funds according to a supply agreement.

For example, there is a certain company Pilot TD, which must pay a certain amount to the company "UkrPostachSbut". 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 journal of payment orders. The payment order must be executed in accordance with the requirements (depending on the specifics of the transfer), and then saved.

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

When you have set the date, you need to add another statement.

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

If you filled in all the required fields correctly, the functional panel will now be available to you. Find the tab "Pick up unpaid" on it.

A window will open in front of you, where you will need to mark the desired document with a checkmark (or several documents at once). When the checkboxes are ticked, click on the "Post marked" button.

When the execution is completed, you need to close the form. Now you have a visible statement in 1C, which is generated by the desired date.

There is another simple way to generate outgoing and incoming banking documents. They are generated directly from the statement form itself. It's easy to do, just click on the "+Add" button. And then in the same window you can 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). For the debt of goods, works, services, taxes and other payments, payment must be made. Currently, this process takes place through the Client-Bank system. This program is installed by bank employees on the computer of an employee of the company, for making payments and loading payment orders into the program in which the maintenance is carried out. accounting. Let's look at how bank statements are loaded into 1C.

Downloading 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 for data transfer.

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, according to 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 the bank” position in it.

Organization for which payment orders will be loaded;
Organization bank account.

We click at the bottom of the document "Download" and after that in the tabular part all statements from the bank will be loaded into the "1C: Accounting" program. After that, we view the report on the uploaded file and proceed to the execution of payment orders.

You can set up automatic payment documents on receipt and withdrawal. To do this, you need to configure.

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

By clicking the "Settings" button at the bottom of the "Exchange with a bank" document;

In the journal "Bank statements" select the item "Set up exchange with the bank" from the list by clicking on the "More" button.

In the settings, fill in the fields:

Specify the bank account from which statements will be downloaded;
The name of the program is selected from the list laid down by the developers - this is the program with which you are working. After that, 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 the 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.

In the lower part of the settings, two fields open, in the left part data on unloading are indicated, in the right part data on loading.

In the field “Automatically post after loading”, it is advisable to indicate two checkboxes for the items “Receipt to the current account” and “Debit from the current account”, while payment orders will be automatically posted, which in the future only need to be rechecked without going into each of them.

After loading payment orders, you should carefully check the "Type of operation" and the created accounting entries and make corrections if errors are found.

Uploading statements from the banking program to 1C is a very convenient procedure that greatly facilitates the work of the accounting service, significantly saving employees' time.

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. Let's see how they are formed required documents.

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 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. Clicking opens a list from which you can choose desired view payment: "Assessed taxes and contributions" or "Goods and services":

When choosing one of the items, 1C Accounting itself will analyze the organization's debt and generate 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 receipt Money to the settlement account of the organization, use the "Bank statements" item 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 article of the 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.

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

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:

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.

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.

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:

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 article of the 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

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