For department employees accounting There is a tradition: every year, as of December 31, they draw up statements of reconciliation of accounts. 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 Civil Code of the Russian Federation, its signing interrupts 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 Regulations on accounting and financial statements In Russian federation"; Order of the Ministry of Finance of the Russian Federation dated June 13, 1995 N 49 (as amended on November 8, 2010) “On approval of the Methodological Guidelines for the Inventory of Property and Financial Liabilities.”

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 manually filling out the Reconciliation Act forms (by the way, the Reconciliation Act form is not approved by 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 have provided the ability to automatically generate the document in question.

How to make a reconciliation report in 1C?

To create a Reconciliation Report, you need to go to 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 the document

In the header of the document you must fill in the following fields:

• Organization;
• Counterparty;
• Reconciliation currency (even if the agreement is in a currency, but enter the value “rubles” in this field, the reconciliation report will be drawn up in rubles, and in each line, as a reference, the amount in the currency of the agreement will be indicated);
• Agreement (if you leave this field empty, a reconciliation report will be generated for all agreements 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 out the information in the tab Settlement accounts. By default, the tab contains the main settlement accounts. If necessary, use the checkbox Participates in calculations or By adding/removing lines, you can create your own list of settlement accounts.

Next step: Bookmark Additionally. Choose Representatives of the parties from the relevant directories (Representative of the organization - Directory Individuals A; Contractor representative – Directory Contact faces).

Editing the view Printed form, by checking the required boxes:

• Break down by agreement(the checkbox is active only if there is an empty Contract field) – in printed form, the data of the Reconciliation Report will be broken down for each agreement with the counterparty. If this box is not checked, information will be displayed in printed form for all contracts in chronological order;
• Display full document names– if the checkbox is not checked, the names of transactions (payment, sale, etc.), document number and date will be printed. If the checkbox is checked, the form will display the full names of documents (Receipt to the current account, Sales (acts, invoices), etc.), number and date of the document;
• Issue invoices– checking the box will display in 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 filling out the sections listed above, you need to go to the section According to the organization and fill out the table.

Fill selection According to our organization and counterparty will fill in both parts of the Reconciliation Report in a mirror manner. Filling Only according to our organization will leave the counterparty side blank.

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

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

There is a button in the document header Clip, with which you can attach a file to a document, for example, a scan of a signed Reconciliation Report.

To reconcile mutual settlements with counterparties, a reconciliation report is generated. This document contains information about sales of goods (services) and payment for them. It indicates the incoming and outgoing balance of debt for settlements with the counterparty. When taking inventory, receivables and creditors of the organization sign a reconciliation report with all suppliers and customers. Read on to learn how to make a reconciliation report in 1C.

Read in the article:

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

• settlement balance 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 header of the settlement reconciliation act in 1C 8.3 contains the following information:

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

How to create a reconciliation report in 1C 8.3 in 6 steps, read this article.

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

Go to the “Purchases” section (1) and click on the link “Reconciliation statements” (2). A window for generating 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 report in 1C, indicate:

• your organization (1);
• the counterparty you are checking with (2);
• agreement with the counterparty (3). Select the required 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 settlement accounts

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

Step 4: Customize the Advanced Tab

Go to the “Advanced” tab (1). Select in the “Organization Representative” field (2) an employee of your organization who will sign the act. In the “Counterparty Representative” field (3), select individual, which will sign the document on the part 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 “According to organization data” tab (1), click on the “Fill in” button (2) and click on the “Only for our organization” link (3). The reconciliation report will be filled with data from your accounting.

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

To save the reconciliation, click the “Record” (9) and “Post” (10) buttons. Now the document will appear in the general list of created reconciliation reports (step 1).

The act of reconciliation of mutual settlements in 1C is completed. Now you can print it and sign it.

We learn to draw up a statement of reconciliation of calculations (1C: Accounting 8.3, edition 3.0)

2016-12-08T13:37:38+00:00

In this lesson we will learn how to correctly draw up a statement of reconciliation of mutual settlements with a counterparty for 1C: Accounting 8.3 (edition 3.0).

Situation. We have long-term cooperation with our counterparty Prodmarket LLC. The food market supplies us with some goods, and we provide it with some services.

Once a quarter, we draw up reconciliation acts for mutual settlements in order to avoid accounting errors, as well as to legally fix the debt to each other, because the act certified by both parties can be used in court.

On October 10, we decided to draw up a reconciliation report for the 3rd quarter. Thus, we initiated the preparation of an act of reconciliation of mutual settlements with the counterparty.

According to our data (analysis of accounts 60, 62, 66, 67, 76), at the beginning of the 3rd quarter we had no debt to each other.

• On September 2, we received goods from the food market in the amount of 4,000 rubles.
• On September 3, we paid 4,000 rubles from the cash register to the food market for goods.
• On September 24, we provided services to the food market in the amount of 2,500 rubles.

Thus, according to our data at the end of the 3rd quarter the food market owes us 2500 rubles.

Go to the “Purchases” section, “Calculation Reconciliation Acts” item:

We create new document"Act of reconciliation of settlements with the counterparty." We fill in the counterparty of the food market and indicate the period for which the reconciliation report is drawn up (3rd quarter):

If it were necessary to make a reconciliation for a specific agreement, it would be necessary to indicate it in the “Agreement” field. But we carry out a general reconciliation of all contracts, so we leave the contract field empty.

Go to the “Additional” tab and indicate representatives of our organization and representatives of the food market.

Since we are reconciling all contracts, it will be convenient if in printed form the lines are divided according to contracts. To do this, check the “Split by contracts” checkbox:

We go to the “Accounts” tab and mark here the accounting accounts that need to be analyzed to reconcile our settlements with the counterparty. The most typical accounts are presented here (60, 62, 66...), but it is possible to add new ones (the "Add" button):

Finally, go to the “According to organization data” tab and click the “Fill in according to accounting data” button:

The tabular part is filled with primary documents and settlement amounts:

We post the document and print the reconciliation report:

It shows that we have zero debt to each other at the beginning of the period, and at the end of the period the food market owes us 2,500 rubles.

Please note that this form contains only our data for now. We have yet to find out the details of the counterparty (food market).

We send this version to the counterparty

Let’s save this version of the act by clicking on the floppy disk button above the printed form:

The act was saved to the desktop as an Excel file:

We send this file by mail to the food market counterparty.

The counterparty makes its reconciliation

Prodmarket received this file, carried out its reconciliation and identified discrepancies regarding the receipt dated September 2. According to his data, the goods were shipped to us not for 4000, as indicated by us, but for 5600 rubles.

We receive a statement with discrepancies from the counterparty

Prodmarket indicated this error in the Excel file that we sent to it, and then returned this corrected file to us by mail.

We are correcting our accounting error.

Having learned about these discrepancies, we raised source documents and found out that the operator missed one position when entering the invoice. We corrected this error, went back to the created act and again clicked the “Fill in according to accounting data” button:

Since we are sure that this act will be final, we go to the “According to the counterparty data” tab and click the “Fill in according to the organization’s data” button:

The tabular part from the first tab is completely copied into this one, only the amounts in Debit and Credit are inverted (swapped):

We send the counterparty a new (final) act

We print out the reconciliation report again. In duplicate. We sign both, put a stamp and send it to the food market (by mail or courier) to get back one certified copy:

After receiving a return copy of the act from the food market, go back to the document and check the “Reconciliation approved” checkbox. This will protect the document from accidental changes in the future:

In this lesson we learned how to draw up a reconciliation report with a counterparty in 1C: Accounting 8.3, edition 3.0.

Instructions

You can generate a reconciliation report in 1C:Enterprise 8.2 by going to the “purchase” or “sale” tab, which is located on the operations panel.

The register of all generated and recorded settlement reconciliation acts will open. You must click the "add" button. This will open the document “Act of Reconciliation of Mutual Settlements: New”. Here you need to fill in the document data:
- There is no need to enter the number of the reconciliation act; the program sets it automatically when recording the document;
- The date of the document in the program is set automatically; if you need to create a reconciliation report with another date, then click the calendar next to the date and select the desired one. Or enter the date manually using the keyboard;
- Specify the period for which it is necessary to generate a reconciliation report;
- In the "organization" field, indicate your organization. This field is required;
- In the “counterparty” field, you must indicate the business partner with whom you want to reconcile the calculations;
- In the “agreement” field, you must select an agreement with the counterparty for which you want to reconcile the calculations
- Specify the payment currency

Open the tab “according to the organization’s data” and click on the “fill in” button, then “fill in according to accounting data.”

Click on the “reconciliation act” button in the lower right corner of the document. A dialog box will appear with the question: "The document has been modified. To print it, you need to write it down. Should you write it down?" We answer “ok”. The reconciliation report prepared for printing will open. To print it, you need to click on the “print” button in the upper left corner of the document. Or click the “file” tab, then “print”.

After this, you can click on the "OK" button in the lower right corner and exit the document. After this, the document will be saved in the register of reconciliation acts. If necessary, you can delete it, change it, or print it again.

note

In order for the reconciliation report to indicate the persons who will sign the reconciliation report, you need to go to the “additional” tab and fill in the “organization representative” and “counterparty representative” fields.

How to make an act of reconciliation of mutual settlements with counterparties? The easiest way is to make a reconciliation report from a specialized accounting program in which you keep records.

Instructions

So, in the 1C program version 7.7, click Reports / specialized / reconciliation report. First check whether all transactions for this are entered into the program and whether the bank statement is included. The program will prompt you to enter the period for which you are drawing up the act, and also select the counterparty. The reconciliation report will be generated automatically, after which it can be printed or saved.

If you do not have an accounting program and you keep accounting records, then you will have to draw up a reconciliation report manually. Find in the reconciliation report and

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

Step 1. Create a document Certificate of reconciliation of settlements with counterparties

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

On the screen: List of documents. Press the button Create:

Step 2. Fill in the title of the document State 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 report will be drawn up;
• In field Counterparty– select with which the reconciliation report is drawn up;
• In field Agreement– we indicate the agreement under which we will draw up a reconciliation report. If this field is left empty, then the reconciliation report will include documents for all valid contracts;
• In field Period– indicate the interval for which the reconciliation is performed;
• Flag Reconciliation approved– we set it when the counterparty has signed the reconciliation report. When this flag is set, all document fields will be unavailable for editing:

Step 3. Fill in the tables of the document Statement of reconciliation of settlements with counterparties

Fill out the tab According to the organization

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

The 1C 8.3 program analyzes transactions for the selected counterparty, agreement (or for all agreements) and for those accounting accounts that are checked in the Settlements Accounts tab:

Fill out the tab According to the counterparty data

If the reconciliation report does not reveal any discrepancies with the counterparty, then the According to the counterparty data tab is also filled in using the button Fill. When filling out the tab, the data specified on the According to the organization tab is taken as a basis, only the data from the column Debit are transferred to the column Credit, and vice versa:

Fill out the Advanced tab

In chapter Representatives of the parties it is necessary to indicate the full name of the persons whose signature will appear on this reconciliation act. The representative who signs the reconciliation report on our part must be selected in the Phys. directory. faces:

The counterparty's representative is selected from the Contact persons directory:

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

The created document must Write down And Conduct .

Step 4. Create a printed form of the Reconciliation Report

In the 1C 8.3 program, you can create and print two printed forms:

• Reconciliation report (with stamp and signature).

Select a printable form using the button Seal:

In 1C 8.3, a printed form of the Reconciliation Report is generated:

How to make a reconciliation report with a facsimile signature and seal and send it by email to the counterparty

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

Let's look at an example of how to take advantage of the opportunity to add a seal and signature to a reconciliation report and send it by email.

Step 1. The Logo and Seal section must be filled out in the organization’s card

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

Step 2: Your primary email account must be set up

Section Administration – Organizer – System account setup:

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

Step 3. We create a printed form of the Reconciliation Report (with stamp and signature) in 1C 8.3

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

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

Step 4. Send the reconciliation report to the counterparty by email from 1C 8

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

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

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

We also study how to send documents via mail in the 1 C program in our video lesson:

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