Reconciliation of mutual settlements is regularly carried out between counterparties to identify debts or inaccuracies. For reconciliation in 1C 8.3 3.0, a special document is provided, the creation of which will be discussed in this article. Reconciliation acts can be filled out for suppliers, buyers and other counterparties.

The document "Act of reconciliation of settlements" is located in the tabs:

Sales” for reconciliation with buyers;

"Purchases" for reconciliation with suppliers.

When you click on the corresponding item, a list of reconciliation acts opens, in which the creation of a new act is performed by the "Create" button. It turns out a document of the form:

Fields to be filled in the document:

"Counterparty" - the organization for which you need to reconcile is selected;

"Agreement" - if reconciliation is required under a specific agreement with the selected counterparty, then the required agreement is selected from the drop-down list. If reconciliation is carried out for all mutual settlements with this counterparty, then the field is cleared by clicking on "×" at the end of the line;

"Period" - fill in the start and end dates of the period for which you want to perform reconciliation.

Particular attention should be paid to the tab "Accounts of settlements":

Accounts on which settlements with the selected counterparty take place are displayed here. By default, the list already contains the main accounts, but if you want to expand this list, then the "Add" button is used. If you need to remove an account from the list, then the checkmark opposite the account name is removed.

In the "According to the organization" tab, when you click the "Fill" button, the item "Only for our organization" is selected:

The 1C 8.3 program will automatically fill in the act with data from the infobase and generate a document ready for printing. Before printing, you need to click the "Save" button:

In the menu of the "Print" button, "Reconciliation act" is selected, the document is displayed as it will look on paper:

Please note that the data was entered only from the side of our organization, the data of the counterparty was left blank. To enter data from the counterparty into the document, you need to go to the "According to counterparty data" tab and click the "Fill" button:

Thus, the second part of the reconciliation act will be completed.

In the "Advanced" tab, you can make the following settings:

fill in the person who will sign the reconciliation act from the organization;

fill in the person who will sign the reconciliation act from the counterparty;

break down the data for each contract (required if several contracts have been concluded with the counterparty);

display the full name of the documents - the documents on the basis of which mutual settlements with the counterparty were made will be displayed in the reconciliation act.

With additional settings, the reconciliation act when printed will look like this:

From the printed form, you can open a document for which verification is performed. To do this, click on it in the tabular part of the act. From the menu of the "Print" button, you can display a document with a signature and a seal if these data are entered in the 1C 8.3 database.

The printed reconciliation act is sent for approval to the counterparty, after this procedure, the “Reconciliation approved” checkbox is ticked in the document.

Where can I find the act of reconciliation in 1C 8.3? Reconciliation of calculations is made document In chapter Purchases - Settlements with counterparties - Settlement reconciliation statements - Create button.

The organization entered into a contract for the supply of kitchen furniture with CLERMONT LLC.

On February 22, the organization paid for the delivery of furniture dated February 15 and transferred an advance payment for the next delivery in the amount of 295,000 rubles.

Consider how to generate a reconciliation act in 1C using this example.

Settlement reconciliation period

The period and counterparty with which reconciliation is carried out are filled in in the document header The act of reconciliation of settlements with counterparties . Let's take a closer look:

• From- date of formation of the act of reconciliation with the counterparty;
• counterparty- the buyer, supplier or other counterparty with whom reconciliation of mutual settlements is carried out;
• Treaty- the document on which settlements with the counterparty are carried out.

Treaty indicated only if it is necessary to reconcile settlements with a counterparty under a specific contract. If the field is not filled in, then reconciliation is carried out for all counterparty agreements.

• Period- the period of reconciliation of mutual settlements. It is for this period that data will be displayed in the tabular section.

You can also reconcile settlements with the counterparty and its separate divisions in one act, for this you need:

• select parent organization in the field counterparty ;
• check the box with separate divisions .

Settlement accounts for which reconciliation is carried out

After filling in the counterparty, you must also specify the accounting accounts for which settlements with the counterparty will be analyzed. This must be done on the tab. Settlement Accounts by checking the required checkboxes.

If you need to add some other account that is not reflected in the tabular part by default, then you need to use the button Add. At the same time, one of the subcontos in the added invoice must be Counterparties And Treaties if the reconciliation is also under a certain agreement. Otherwise, the data on this account will not be automatically filled in.

Reconciliation of settlements with a counterparty

After setting the necessary settings, we fill in the calculations with the counterparty on the tabs According to the organization , According to counterparty .

This can be done in several ways:

• manually by button Add ;
• automatically fill in according to the data in the database by the button Fill .

In this case, you can fill out immediately:

• for our organization and counterparty;
• or just our organization.

If choose According to our organization and counterparty , then both tabs will be filled ( According to the organization And According to counterparty ).

If choose Only for our organization , then tab According to counterparty must be filled in manually or by clicking on the button Fill, but already on the tab According to counterparty .

Let's take a closer look at filling in the columns on the tabs According to the organization And According to counterparty :

• date- date of commission business transaction(receipt, sale, payment, etc.). Filled with date primary document.
• Document- link to the primary document in the database.
• Performance - short description business transaction, in brackets - date, number of the primary document (incoming or outgoing data of the primary document). It is this data that goes into the printed form of the document. reconciliation act. Read more.
• Debit- the amount reflected in the debit;
• Credit- the amount reflected on the loan.

The footer of the document displays:

• Balance at the beginning - final mutual settlements with the counterparty on the starting date specified in the field Period. In our example Receipt dated January 10, 2018 in the amount of 1,416,000 rubles. did not fall within the reconciliation period, so the unpaid amount is reflected in this field.
• Remaining at the end - final mutual settlements on the end date specified in the field Period. In our example, an advance payment was made against future deliveries in the amount of 295,000 rubles; because it is not closed on February 28, 2018, then it is displayed in this field.
• Discrepancy with the counterparty (Discrepancy with the organization) - must be equal to "0". If there is an amount in this field, it means that some data is missing in the database. Perhaps the payment was not posted or they forgot to enter the receipt (sales) document.

After completing and verifying the data Act of reconciliation necessary or transfer to the counterparty for approval:

• in paper form, for this you need to print it. More
• in electronic form, for this you can:
  • send directly from 1C by button More - Send by email. More ;
  • save the printable to your computer and send it via external email.

How to print a reconciliation act in 1C

Click the button Print - Reconciliation act document The act of reconciliation of settlements with counterparties . The printed form is divided into two parts (with data on our organization and counterparty) and will include transaction amounts, turnovers and final balances.

How to display the full name of the document in printed form Reconciliation act

The names of documents in printed form can be displayed in two forms:

• short name - "Payment (258 dated 02/01/2018)";

• full name - "Debit from the current account (258 dated 01.02.2018)".

To display the full name, check the box Display full document titles tab Additionally .

How to display invoices in the reconciliation act

To display invoices in the form reconciliation act Issue invoices tab Additionally .

How to indicate contracts in the act of reconciliation

For the conclusion of contracts in the form reconciliation act checkbox must be checked Split by contracts tab Additionally .

If the reconciliation is carried out with the head counterparty (GO) and its separate subdivisions (OP), then the checkbox Split by contracts you need to install it carefully: there may be a doubling of revolutions if there was an adjustment in mutual settlements (Payment from the civil defense, delivery from the OP, or vice versa).

How to indicate in the reconciliation act the responsible persons signing it

Consider how to fill out a printed form of the reconciliation report so that it automatically indicates the responsible persons of our organization and the counterparty who sign the reconciliation report.

In the 1C program, a reconciliation act was drawn up between our Organization and CLERMONT LLC. It is necessary to indicate in its printed form the full name of the managers signing the reconciliation act:

• Druzhnikov G.P. - from the side of the Organization;
• Vasiliev S.S. - on the part of CLERMONT LLC.

in printed form reconciliation act Full name and position of the representatives of the parties are filled in according to the tab Additionally In chapter Parties' representatives .

These data are automatically filled in when creating a document, if necessary, they can be changed manually.

If you are a commercial subscriber of the BukhExpert8 - Rubricator 1C Accounting system, you can learn more about filling in the responsible persons in the documents:

in printed form reconciliation act We will see the data on the representative of the counterparty LLC "CLERMONT" in two places: in the text of the act and at the bottom of the act - where the counterparty's stamp is affixed.

If Counterparty representative tab Additionally is not specified, then the data on it will not get into the printed form.

In order not to redo the document, you can enter the full name of the representative of the counterparty by hand in the empty field.

How to display the facsimile signature and seal of the organization in the reconciliation act

To display the facsimile signature of the head and the seal of the organization, you must select the checkbox Signature and seal on the printable command line reconciliation act .

If you are a commercial subscriber of the BukhExpert8 system - Rubricator 1C Accounting, then read the additional material

For reconciliation of mutual settlements with counterparties, a reconciliation act is formed. This document contains information about sales of goods (services) and their payment. It indicates the incoming and outgoing balance of the debt for settlements with the counterparty. When inventorying receivables and creditors, organizations sign a reconciliation act with all suppliers and buyers. How to make a reconciliation act in 1C, read on.

Read in the article:

The act of reconciliation of mutual settlements in 1C 8.3 is formed and signed with all counterparties before the submission of annual financial statements. We recommend signing acts once a quarter or monthly. This will allow you to quickly find errors and inconsistencies in accounting. The reconciliation act in 1C 8.3 contains all the necessary information for reconciliation of calculations:

• balance of settlements at the beginning of the reconciliation period;
• register of documents for the shipment of goods (services);
• register of payments (payment orders, cash orders, offsets of counterclaims);
• settlement balance at the end of the reconciliation period.

The heading of the act of reconciliation of mutual settlements in 1C 8.3 contains the following information:

• for what period the act was formed;
• the name of your organization;
• with which counterparty, and under which contract the reconciliation is being carried out.

How to generate a reconciliation act in 1C 8.3 in 6 steps, read this article.

Step 1. Go to 1C 8.3 Accounting in the window for generating reconciliation acts

Go to the "Purchases" section (1) and click on the link "Acts of reconciliation of settlements" (2). A window for creating a document will open.

In the window that opens, click on the "Create" button (3). A form for creating a document will open.

Step 2. Fill in the basic details

To generate a reconciliation act in 1C, specify:

• your organization (1);
• the counterparty you are checking with (2);
• contract with a counterparty (3). Select the desired contract from the directory. If you leave the field empty, a reconciliation will be generated for all contracts;
• reconciliation period (4). Specify the start and end date of the period.

Step 3: Set up billing accounts

Go to the "Settlement Accounts" tab (1) and check the boxes next to the accounting accounts for which you want to generate a reconciliation (2). By default, all accounts are checked, but you can change the setting if necessary, for example, leave only accounts 60 and 62.

Step 4: Customize the Advanced Tab

Go to the "Advanced" tab (1). Select in the field "Representative of the organization" (2) an employee of your organization who will sign the act. In the field "Representative of the counterparty" (3), select an individual who will sign the document on behalf of the counterparty. If you want invoices (numbers and dates) to be visible in the reconciliation, check the box next to "Display invoices" (4).

Step 5. Create an act of reconciliation of mutual settlements in 1C 8.3

In the tab "According to the organization" (1), click on the "Fill" button (2) and click on the link "Only for our organization" (3). The reconciliation act will be filled with data from your account.

In the generated act, in the "Document" field (4), receipts and payments for the counterparty are visible. In the "Date" field (5) you can see the dates of these documents. In the "Representation" field (6) - the numbers and dates of documents (waybills, invoices, payment orders, etc.). If an act is formed with a supplier of goods (services), then in the field "Debit" (7) the amounts of payments to the supplier are visible, in the field "Credit" (8) - the amounts of supplies of goods from the supplier (services). In the reconciliation with the buyer, the "Debit" field will indicate the amount of sales, in the "Credit" field - the amount of payments from the buyer.

To save the reconciliation, press the "Record" (9) and "Submit" (10) buttons. Now the document will appear in the general list of created reconciliation acts (step 1).

The act of reconciliation of mutual settlements in 1C is completed. Now it can be printed and signed.

Step-by-step instructions on how to generate a reconciliation act in 1C 8.3

Step 1. Create a document Reconciliation of settlements with counterparties document

The first question when creating a document is where to find the Reconciliation Act in 1C 8.3? It is located in the section Purchases or section Sales– Settlements with counterparties – Acts of reconciliation of settlements:

On the screen: List of documents. We press the button Create:

Step 2. Fill in the title of the document The act of reconciliation of settlements with counterparties

• In field Number– document number automatically generated by the program;
• In field From– document date;
• In field Reconciliation currency- select the currency in which the reconciliation act will be drawn up;
• In field counterparty- choose with which the reconciliation act is drawn up;
• In field Treaty- indicate the contract under which we will draw up an act of reconciliation. If this field is left blank, then the reconciliation act will include documents on all valid contracts;
• In field Period– specify the interval for which the reconciliation is performed;
• Flag Reconciliation agreed- we set when the counterparty signed the reconciliation act. If the flag is set, all fields of the document will be unavailable for editing:

Step 3. We fill in the tables of the document The act of reconciliation of settlements with counterparties

Fill in the tab According to the organization

The tab According to the organization is filled with data by clicking the button Fill – Fill in according to the data accounting :

The 1C 8.3 program analyzes transactions for the selected counterparty, contract (or for all contracts) and for those BU accounts that are marked with checkboxes on the Settlement Accounts tab:

Fill in the tab According to the counterparty

If there are no discrepancies with the counterparty according to the reconciliation report, then the tab According to the counterparty's data is also filled in by clicking the button Fill. When filling in the tab, the data specified on the tab According to the organization is taken as the basis, only the data from the column Debit moved to column Credit, and vice versa:

Fill out the Advanced tab

In chapter Parties' representatives it is necessary to indicate the full name of the persons whose signature will be on this reconciliation act. The representative who signs the reconciliation act on our part must be selected in the directory Physical. faces:

The representative of the counterparty is selected from the directory. Contact persons:

In the case when several contracts are concluded with the supplier or buyer, it is convenient to set the flag Break down by contracts:

The generated document is burn And Conduct .

Step 4. We form a printed form of the Reconciliation Act

In the 1C 8.3 program, you can generate and print two printing forms:

• Reconciliation act (with seal and signature).

Select the printable by clicking the button Seal:

In 1C 8.3, a printed form of the Reconciliation Act is formed:

How to make a reconciliation act with a facsimile signature and seal and send it by e-mail to a counterparty

In 1C 8.3, you can draw up an act of reconciliation with the seal of the organization, facsimile signature of the head or chief accountant. Usually, such a reconciliation act is generated if it needs to be urgently sent to the counterparty by email to email. For these purposes, the 1C 8.3 program provides for a printed form of the Reconciliation Act (with a seal and signature).

Let's take an example of how to use the opportunity to add a seal and signature to the reconciliation act and send it by mail to email.

Step 1. The Logo and Seal section must be completed on the organization card

How to add a logo and a seal to a document in 1C 8.3 is discussed in detail in the article "".

Step 2: The primary email account must be set up

Section Administration - Organizer - Setting up a system account:

For more details on how to set up an email account in the 1C program, see our video:

Step 3. We form a printed form of the Reconciliation Act (with a seal and signature) in 1C 8.3

You can print the act by clicking the button Seal – Reconciliation act (with seal and signature):

In 1C 8.3, a printed form of the Reconciliation Certificate with the seal of the organization and the facsimile signature of the chief accountant is formed:

Step 4. We send the reconciliation act to the counterparty by e-mail from 1C 8

We press the button. Select the document format, for example, an Adobe PDF document (.pdf):

In 1C 8.3 a dialog box appears Sending a message. The dialog box fields are filled in automatically. In field To whom the e-mail address specified when filling in the contact information of the counterparty is substituted.

The reconciliation act is added to the letter as an attachment. The text of the letter, if necessary, can be corrected using the built-in text editor. Email is sent by button Send:

How to send documents via mail in program 1 C, we also study in our video lesson:

On the site you can see our other free articles and materials on configurations.

Employees of accounting departments have a tradition: every year, as of December 31, they draw up acts of reconciliation of calculations. This tradition is due to the obligation to conduct an annual inventory of assets and liabilities, including an inventory of settlements. * The reconciliation act is an integral part of the inventory of settlements, because it is this document that confirms the state of mutual settlements between the parties, and also, in accordance with Art. 203 of the Civil Code of the Russian Federation, its signing interrupts the running of the limitation period for the debt.

*P. 27 Order of the Ministry of Finance of Russia dated July 29, 1998 N 34n (as amended on March 29, 2017) “On approval of the Regulation on accounting and financial statements In Russian federation"; Order of the Ministry of Finance of the Russian Federation dated 06/13/1995 N 49 (as amended on 11/08/2010) "On approval of the Guidelines for the inventory of property and financial obligations".

The Organization has the right, on its own initiative or in accordance with the terms of the contract, to draw up a Reconciliation Report as of any date.

In order not to waste time on manually filling out the forms of the Reconciliation Acts (by the way, the form of the Reconciliation Act is not approved by the current legislation and can be developed by the organization independently, which confirms Letter of the Ministry of Finance dated February 18, 2005 N 07-05-04 / 2), the developers of 1C:Accounting 3.0 provided for the possibility of automatically generating the document in question.

How to make a reconciliation act in 1C?

To create a Reconciliation Act, you need in the section Sales or Purchases follow the link Links from both sections refer to the same directory.

In the open directory, click the "Create" button:

Filling out a document

The following fields must be filled in the header of the document:

• Organization;
• Counterparty;
• Reconciliation currency (even if the contract is in a currency, but in this field put the value - "rubles", the reconciliation report will be drawn up in rubles, and in each line, as a reference, the amount in the currency of the contract will be indicated);
• Contract (if this field is left blank, the Reconciliation Report will be generated for all contracts with the counterparty);
• Period.

fields Number And date filled in automatically when recording a document, if necessary Date can be entered manually.

Next, you need to fill in the information in the tab Settlement Accounts. By default, the main accounts of settlements are filled in the tab. If necessary, using the checkbox Participates in calculations or By adding/removing rows, you can create your own list of settlement accounts.

Next step: Bookmark Additionally. Choose Parties' representatives from the relevant directories (Representative of the organization - Directory Individuals A; Counterparty representative - Directory Contact faces).

Editing the View printed form, by setting the required checkboxes:

• Split by contracts(the checkbox is active only if the Contract field is empty) – in printed form, the data of the Reconciliation Report will be broken down for each contract with the counterparty. If this checkbox is not checked, information will be displayed in printed form for all contracts in chronological order;
• Display full document titles– if the checkbox is not set, the printed form will display the names of operations (payment, sale, etc.), number and date of the document. If the checkbox is checked, the form will display the full names of documents (Receipt to the current account, Implementation (acts, invoices), etc.), number and date of the document;
• Issue invoices- Checking the box will reflect in the printed form, in the Document column, information about the number and date of the invoice.

Important! Checking or unchecking any of the three checkboxes will result in mandatory clearing of the tabular parts of the document.

After completing the sections listed above, you must go to the section According to the organization and complete the table.

Infill selection According to our organization and counterparty fill in mirror both parts of the Reconciliation Act. filling Only for our organization will leave the counterparty side empty.

If necessary, as in the section According to the organization, as well as in the section According to counterparty, you can make changes to the tabular part manually (add/delete rows, change the debit/credit amount). After checking the box Reconciliation agreed in the header of the document, the ability to edit the document is blocked. Balances at the beginning or end of the period are not subject to editing.

At the bottom of the document there is a field for adding a comment - filling is optional.

There is a button in the header of the document Clip, which can be used to attach a file to a document, for example, a scan of a signed Reconciliation Act.