Formation of a statement of reconciliation of calculations in "1C: Accounting". Accounting info Automatic generation of reconciliation reports in 1s 8.3
The domestically developed software product “1C: Accounting 8” works in many Russian enterprises. Users choose it for its user-friendly interface and thoughtful automation of all areas of accounting, including the organization’s mutual settlements with suppliers and customers. To quickly check debts and mutual settlements between counterparties, the “Reconciliation Report” document is used. 1C makes it possible to generate it automatically. Let's look at how to make a reconciliation report in 1C using the example of the latest version of the program - “1C: Enterprise 8.3”.
How to create?
To generate a reconciliation report, a separate hyperlink is provided in the “Purchases and Sales” section - “Settlement Reconciliation Acts”, located in the “Settlements with Counterparties” subsection.
We click and in the journal we see all the documents created before. To make a new reconciliation, click the “Create” button located on the panel just above the journal, and at the top of the document fill in the details, the required ones are underlined with a red line:
- "Counterparty". This is an organization or individual entrepreneur with whom we are checking;
- "Agreement". We fill in the details only if necessary. If the field is left empty, the printed form will contain movements on all contracts with the counterparty;
- "Period". We determine the time period we are interested in;
- The “Organization” and “Currency” fields are filled in automatically depending on the directory settings.
If you check the “Reconciliation approved” box, it will be impossible to edit the document. We place bets only after agreeing on the result with the supplier or buyer.
In addition to the “header”, to correctly generate a reconciliation report, you need to fill in some data in the tabs of the form.
- "Settlement Accounts". The accounts that most often take into account mutual settlements with counterparties are automatically adjusted here: 60, 62, 66, 67, 76. If necessary, you can make adjustments to the list;
- "Additionally". Here you need to enter the names of representatives of both organizations in the appropriate fields and, if necessary, check the “Split by agreement” box.
In principle, you don’t need to touch these tabs at all. 1C can generate a printed form without a breakdown by agreement and only by specified accounts, with empty lines where the names of representatives should be. You will have to spend a little time writing them in with a ballpoint pen.
How to fill in data?
In the “According to organization data” tab, click the “Fill in” button, then “Fill in according to accounting data.”
The system will automatically fill the table with rows indicating the primary documents and amounts. We carry out (the corresponding button is above the details) and print (the button with the printer is there).
The printed form contains data on mutual settlements, amounts, turnover and final balance. It is divided into two halves:
- According to our organization;
- According to the counterparty. This part must be completed by the supplier or buyer.
You can make a printed form of the reconciliation report by clicking on the appropriate button, or you can save it to a file (button with floppy disk). Available formats are Microsoft Word and Excel, text document, web page and others.
We sign and send to the person we are checking with.
You can send a file in Excel format to your counterparty so that he can fill it in with his data. Then, in case of discrepancies, we will not need to print and sign the reconciliation report again.
If the accounting data of the counterparty and our organization coincide, and the reconciliation report is signed without discrepancies, at the top of the form we check the “Reconciliation agreed” checkbox, save and relax.
If the reconciliation report contains discrepancies, then first of all we need to find an error in the accounting of our organization or the counterparty (incorrect amount, document, date, etc.) and make corrections. After this, open the document again in 1C, go to the “According to the counterparty data” tab, fill in the corresponding button, print out the final act and send it to the counterparty. After receiving the signed document, we save the form in 1C from accidental editing using the “Reconciliation approved” checkbox.
An act of reconciliation of mutual settlements is a document that allows you to compare settlements between two enterprises for a certain period. The legislation does not provide for a specific form of the act, so you can draw it up in any order. In today’s article we will try to most fully cover the topic of how to make a reconciliation report in 1C8, and we will analyze the stages of creating a document in 1C: Accounting 8, namely:
1. Where to find the reconciliation report in 1C
To create a reconciliation report in 1C8, go to the “Purchases and sales menu - Reconciliation reports for settlements with counterparties” and create a new element.
2. How to fill out the form
Let's move on to filling out a new document.
Line “from” - indicate the date the act was created.
Line “Counterparties” - select the company from the “Counterparties” directory.
The “Agreement” line is filled in with the details of the agreement with the counterparty.
Line “Period” - enter the dates of the period for which the reconciliation is performed.
Line “Currency” - fill in with the relevant data about the currency.
3. Settlement accounts
Go to the “Settlement Accounts” tab. In it you will see a list of all accounting accounts. Leave a check mark only on those that you want to make a reconciliation against.
4. Autofill other tabs
Next step: go to the “According to organization data” tab and to the “According to counterparty data” tab.
Use the “Fill” button if you want each tab in the table section to be filled in automatically. After that, save the document by clicking the “Burn” button
5. How to print a reconciliation report
6. How to perform a reconciliation report
To carry out a reconciliation act, click on the “Post and close” button
To print a reconciliation report, you need to create a printed form using the “Reconciliation report” button
We tried to fully answer the question of how to draw up a reconciliation report in 1C.
We hope our article was useful to you.
Mutual settlements? How to view payment in 1C? How can I see in 1C whether the payment was made to the supplier?
Let's consider creating a reconciliation report in 1C. Let's start this time with 1C Accounting 8.2. The list of documents “Act of reconciliation of mutual settlements” in 1C 8.2 is located both on the main menu button “Sale” and in the “Purchase” menu. If your 1C is configured to use the function panel, then the log of reconciliation acts can be called up in the “Purchase” and “Sale” tabs.
Open the reconciliation log and click the “+” (Add Ins) button to create a new document.
In the new document, we set the period for which the reconciliation will be carried out, select, of course, the counterparty with whom we will reconcile and pay attention to the “Agreement” field. In this field you must indicate the actual contract under which work with the counterparty is carried out.
In our example, the sample was made for 2001 under a supply agreement. From the document data it is clear that Dobro LLC is worth 130,477 UAH.
Having generated the act using the button below “Reconciliation Act”, we will notice that the data in the act is displayed only for our organization Dobro LLC.
To fill out the act with the counterparty’s data, go to the “According to the counterparty’s data” tab in the document and click the “Fill in” button and then “Fill in according to the accounting data.”
We repeat the seal of the act:
On the “Expense Accounts” tab, using the checkboxes, you can select the accounting accounts for which the act will be executed.
On the “Additional” tab, fill in the responsible persons signing the document on the part of our company and the counterparty company.
Next, if the reconciliation is agreed upon, check the “Reconciliation agreed” checkbox; on the first tab we can indicate the balances at the beginning of the period, if any. We print and carry out the final version of the settlement act.
Download illustrated instructions:
If you have questions about the article or there are still unresolved problems, you can discuss them at
But if suddenly someone does not know what kind of document this is, then we suggest staying here to gain a little theoretical knowledge. If you are fully aware of this issue, then you can immediately move on to the next block. A reconciliation act in 1C software is a document informing about the state of mutual settlements between counterparties for a certain period of time. You can do it very easily and quickly using the standard menu, which we will talk about a little later.
It is worth noting that when we mention 1C, we specifically mean the “Enterprise” platform, which allows you to perform similar operations in its product. The fact is that 1C itself is nothing more than a company that produces various software and even participates in the scoring of some games. For example, the company’s arsenal includes the following products: a series of educational programs “1C: Tutor”, “1C: Education” and others. In general, the company owns more than 200 subsidiaries, which shows its power.
The discussed “Enterprise” allows you to keep accounting records of everything that happens in your corporation. This is an indispensable product that makes life much easier for office employees of any company. This simplification is achieved by automating, using a computer program, all those processes that were previously done manually, on paper, with a calculator, and so on.
Let's move on to action
Now that you have more or less learned about the 1C product itself, and also clarified what a reconciliation act is, you can already do it. Go:
- Open the 1C: Accounting program on your computer.
- If the version of your product is 2.0, then open the menu of the top block “Sales”, and then select the item “Act of reconciliation of mutual settlements” from there, click on it. In version 3.0, you will need to open the “Purchases and Sales” tab, then find the “Settlements with counterparties” column. And already there, click on “Acts of reconciliation of calculations”. If automation is installed in complex mode, switch the interface to full. Next, go to “Documents”, then find “Sales Management” and click on “Act of Reconciliation of Mutual Settlements”.
Click on “Acts of reconciliation of calculations”
- Add a new document. Now we will need to fill in some fields.
- Specify the organization and counterparty, as well as the verification period (from which date to which date).
- If you have a specific agreement, then you indicate it in the field of the same name. Otherwise, it may remain blank.
- If you have several accounts with the specified counterparty, then you should check what is included in the final document. To do this, open the “Settlement Accounts” tab, then check the boxes for the required accounts.
Open the “Settlement Accounts” tab
- To set the parameters for the printed form of the document, click on the “Advanced” tab, where you can do all this.
- Now open the first tab: “According to organization data.” Please note that we go here when all the settings have been made and the necessary invoices have been entered. Here you have to click on the “Fill” button. By agreement with the counterparty, you can also fill out the fields in the “According to the counterparty data” tab. Be sure to check all the information, then print the document.
- Actually, how to print a reconciliation report in 1C? To do this, click the “Record” button, and then click “Print” in the new window. Wait until the printer prints your document, and then close the print window.
- If everything is done correctly, then it’s time to agree on all this with the counterparty. Only after this can you check the box next to “Reconciliation approved”, save, and close the report. Ready!
Please note that the document will then become unavailable for editing. Therefore, everything that has been done cannot be changed. Clearly control this moment so that later you do not have unpleasant situations both with your own company or firm, and with counterparties.
Conclusion
Friends, today we learned how to create a reconciliation report in 1C and print it. We hope everything worked out for you and there are no more questions left. As it turned out, this is quite easy to do, but at the same time responsible. Therefore, we remind you once again that before checking the box next to the “Reconciliation approved” item, obtain approval from the counterparty and double-check the document. Tell us in the comments your opinion and impression of the work done.
With the release of edition 4.5 of the standard configuration "Accounting" for "1C:Enterprise 7.7", users now have the opportunity to generate acts of reconciliation of calculations based on accounting data reflected in the information base. The “Calculation Reconciliation Report” report is intended for this purpose. 1C methodologists talk about filling out this report.
Due to the fact that the form of such an act has not been officially approved, when creating a printed form of the report “Act of Reconciliation of Calculations”, the procedure that has recently developed in accounting practice was taken into account.
The report is called up from the menu "Reports" - "Specialized" - "Act of reconciliation of calculations".
Tab "Reconciliation parameters"
On the "Reconciliation parameters" tab (see Fig. 1) the main parameters for reconciliation of calculations are set:
Calculation reconciliation period;
- “Counterparty” - the counterparty with whom settlements are reconciled;
- reconciliation of settlements with the counterparty can be performed both in general and for a specific agreement (supply, invoice, etc.). If it is necessary to reconcile the calculations as a whole, the “according to agreement” input field should be left empty. If it contains some selected element of the “Contracts” directory, then to clear it you can click the “For all” button located to the right of this field;
- “Accounts for which reconciliation is performed” - in the proposed list, you must mark the accounts, movements and balances for which are subject to reconciliation.
Rice. 1. Tab "Reconciliation parameters"
After setting all the necessary parameters, clicking the “Fill” button automatically fills in the table of transactions for settlements with the counterparty and switches to the tab “Table of transactions for settlements”.
Tab "Table of calculation operations"
An example of filling out the tab “Table of calculation operations” is shown in Fig. 2.
Rice. 2. Tab "Table of calculation operations"
In the column "Contents of operation" a brief summary of the transaction is entered (for example, “receipt” - when receiving property from the supplier, “exchange difference” - when writing off exchange rate differences, etc.); Date of operation; the amount of the transaction in foreign currency (in brackets, indicating the currency of the transaction) - if settlements are carried out in foreign currency.
In the column "Document" shows the document with which the transaction is reflected in the accounting records of the enterprise.
In the column "Debit" indicates the amount in rubles posted to the debit of the settlement accounts.
In the column "Credit" indicates the amount in rubles posted to the credit of the settlement accounts.
After auto-filling the table, in the “Result of settlements reconciliation” frame on the “Reconciliation parameters” tab, a message appears about the presence (absence) and amount of debt for settlements with the counterparty at the end of the reconciliation period.
In practice, a situation may arise when it is necessary to correct data obtained automatically from the information base. For example, you must additionally indicate the original document number in the “Operation” column. Or it turns out that some document was not recorded and, accordingly, was not included in the table, but in fact it exists, is reliable and therefore must be included in the reconciliation report. The opposite situation may also occur: something is included in the act by mistake.
To edit the generated table of settlement operations, the following options exist:
- When the button is pressed "Change" It is possible to manually change the value of the table cell that the cursor points to. If the cursor is in one of the cells in the “Document” column at the time the button is pressed, then the corresponding electronic document is called up (available for viewing and editing). If changes are made to this document and it is re-posted, the contents of the cell will not be automatically updated. To change the table of operations of the reconciliation report in this case, you can click the “Fill” button again. But it is advisable to do this if practically no “manual” changes were made to the report. Otherwise, it is more advisable to correct the amount in the “Debit” or “Credit” column manually.
- Button "Add line" allows you to insert an empty row into the operations table before the one in which the cursor is located (after insertion, the cursor will point to the added row). You will have to fill out this line manually.
- Button "Delete line" is intended to delete the current table row.
Tab "Persons signing the act"
Before printing the act, on the “Persons signing the act” tab (Fig. 3), enter the following data:
- about the employee who will sign the act on behalf of the organization - selection from the “Employees” directory;
- about the person signing the act on the part of the counterparty (if known);
- on the date and place of signing the reconciliation report.
Rice. 3. Tab "Persons signing the act"
When you click on the “Print” button, a printed form of the reconciliation report is generated (Fig. 4).
Rice. 4. Printed form of actp
By default, it is filled out only by the organization that prepared the reconciliation report based on its data.
This method of generating a printed form is recommended if you are not entirely sure of your data (for example, when preparing a reconciliation report for sending to a counterparty).
If you know that the counterparty’s data completely matches yours, you can check the “Reconciliation results agreed with the counterparty” checkbox on the “Reconciliation parameters” tab.