1c enterprise 8.2 act of reconciliation. Formation of an act of reconciliation of calculations in "1C: Accounting"
But if suddenly someone does not know what kind of document this is, then we suggest staying here to get some theoretical knowledge. If you are fully aware of this issue, you can immediately go to the next block. The act of reconciliation in software 1C is a document informing about the status of mutual settlements between counterparties for a certain specified 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 here, when 1C is mentioned, it refers specifically to the “Enterprise” platform, which allows you to perform such operations in your product. The fact is that 1C itself is nothing more than a company that produces various software and even participates in the dubbing of some games. For example, the company's arsenal includes the following products: a series of training programs "1C: Tutor", "1C: Education" and others. In general, the firm owns more than 200 subsidiaries, which shows its power.
The discussed "Enterprise" allows you to conduct Accounting everything that happens in your corporation. This is an indispensable product that makes life easier for office staff of any company. This simplification is achieved by automating with the help of a computer program all those processes that were previously done manually, on paper, on 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 the reconciliation act is, then you can already do it. Go:
- Open the program 1C: Accounting on your computer.
- If the version of your product is 2.0, then open the menu of the upper block "Sale", 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 settlements." When automation is set to 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 settlements"
- Add new document. Now we will need to fill in some fields.
- Specify the organization and counterparty, as well as the verification period (from what to what date).
- If you have a specific contract, 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 will be included in the final document. To do this, open the "Settlement accounts" tab, then check the boxes for the required accounts.
Open the Accounts tab
- To set the parameters for the printing form of a document, click on the "Advanced" tab, where you can do it all.
- Now open the first tab: "According to the organization." Please note that we go here when all the settings are done, desired accounts made. Here you have to click the "Fill" button. By agreement with the counterparty, you can also fill in the fields in the "According to the counterparty's data" tab. Be sure to check all the data, then print the document.
- Actually, how to print a reconciliation act in 1C? To do this, click the "Record" button, and then click "Print" in a new window. Wait for the printer to print your document, and then close the print window.
- If everything is done correctly, then it's time to coordinate all this with the counterparty. Only after that you can check the box next to the item "Reconciliation is agreed", save, close the act. Ready!
Please note that the document will then become inaccessible 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 have learned how to generate a reconciliation act in 1C and print it out. We hope that everything worked out for you, and there are no more questions left. As it turned out, doing this is quite easy, but at the same time - responsibly. Therefore, we remind you once again that before checking the box next to the “Reconciliation approved” item, get approval from the counterparty and double-check the document. Tell us your opinion and impression about the work done in the comments.
The act of reconciliation of mutual settlements in 1C 8.3 reflects the settlements of two companies among themselves for a certain period of time. The law of our country does not approve a unified form of this document, so you can form it in any form. Despite the fact that the act of reconciliation is not mandatory, organizations everywhere use it for convenience.
After being formed in 1C, this document can be printed, signed and certified in two copies. The organization keeps one for itself, and transfers the other to the counterparty. The counterparty, in turn, can draw up a similar act of reconciliation of mutual settlements, but according to its own data.
Consider step by step instructions how to make a reconciliation act in 1C 8.3 using the example of a demo database. LLC TD Kompleksny will act as our organization, and the Vnukovo in-flight catering plant will act as a counterparty. We will form an act of reconciliation of mutual settlements for the second quarter of 2017.
To begin with, let's figure out where to find the reconciliation act in 1C 8.3. The document we are interested in is located in the "Sales" or "Purchases" menu.
To form new act reconciliation in 1C, you need to click on the "Create" button.
Fill in the header of the document - select the counterparty, organization, reconciliation currency, contract and period.
Please note that the reconciliation act can be generated not only within the framework of a specific agreement, but also in general for the counterparty. In this situation, we nevertheless decided to choose a contract, since it is assumed that our organization has relations with this counterparty exclusively as with a buyer.
First of all, let's go to the tab "Accounts of settlements". It filled in automatically. The data in this tabular section can be edited independently. Please note that it is on them that further automatic completion mutual settlements.
Filling out a document
The first tab of this 1C 8 document reflects the data that is reflected in our organization. Of course, they can be filled manually, but this is extremely inconvenient.
Above the tabular part, click on the "Fill" menu. You will be presented with a choice of two filling options:
- “According to our organization and counterparty". In this case, the program will fill in both tabs with settlement data: “According to the organization” and “According to the counterparty”. After the counterparty provides information, we can manually correct the corresponding tab.
- "Only in our organization." And in this situation, only the data for our organization will be automatically filled in.
In the event that, after automatic filling, any documents did not get into the document, first of all check the accounts indicated on the corresponding tab and the agreement in the header. Perhaps you simply configured the filtering by which the selection took place incorrectly.
The tab with counterparty data can be filled in from the previous tab, as described earlier. It also has an independent "Fill" button. In fact, the data of our organization is copied (from the first tab). In the future, these data, if necessary, are subject to correction.
At the very bottom of the document, not only the balance at the beginning and end of the period is reflected, but also discrepancies with the organization and counterparty, respectively.
See also the video instruction on document execution in 1 C:
Coordination
On the "Advanced" tab, you can configure some of the options for printing forms of this document, for example, the signatories of the parties.
In the case when the reconciliation act is generated not for any specific contract with the counterparty, but for all settlements, you can split the data by contracts by setting the appropriate flag.
Also on the “Advanced” tab there are also settings for specifying document names and outputting invoices.
After you have carried out the reconciliation with the counterparty and both parties have signed it, set the “Reconciliation approved” flag in the relevant document. This will make the document unavailable for accidental editing. This document does not produce any movements.
Printout of the act of reconciliation
In the "Print" menu of this document, you can print three printable forms of the Reconciliation Act. The first two are almost the same except for the print space.
The printed form of the reconciliation act is shown in the image below. We remind you that the legislation has not approved a unified form for this document.
With the release of version 4.5 of the standard configuration "Accounting" for "1C: Enterprise 7.7", users have the opportunity to generate acts of reconciliation of calculations according to accounting reflected in the infobase. For this purpose, the report "Act of reconciliation of settlements" is intended. The methodologists of the company "1C" tell about filling out this report.
Due to the fact that the form of such an act has not been officially approved, when creating the printed form of the report "Act of reconciliation of settlements", the procedure established in Lately in accounting practice.
The report is called from the menu "Reports" - "Specialized" - "Act of reconciliation of settlements".
Reconciliation settings tab
On the "Reconciliation parameters" tab (see Fig. 1), the main parameters for reconciliation of calculations are set:
Period of reconciliation of settlements;
- "Counterparty" - the counterparty with which the settlements are reconciled;
- reconciliation of settlements with a counterparty can be performed both in general and under a specific agreement (delivery, invoice, etc.). If it is necessary to reconcile settlements in general, the input field "under the contract" should remain empty. If it contains some selected element of the "Agreements" directory, then to clear it, you can click the "For all" button located to the right of this field;
- "Accounts for which reconciliation is carried out" - in the proposed list, it is necessary to mark the accounts, movements and balances for which are subject to reconciliation.
Rice. 1. Tab "Reconciliation parameters"
After setting all required parameters by pressing the "Fill" button, the table of transactions for settlements with the counterparty is automatically filled in and the transition to the tab "Table of transactions for settlements" takes place.
Bookmark "Table of settlement operations"
An example of filling in the tab "Table of settlement operations" is shown in fig. 2.
Rice. 2. Bookmark "Table of settlement operations"
In the graph "Contents of operation" affixed summary transactions (for example, "incoming" - when receiving property from a supplier, "exchange difference" - when writing off an exchange difference, etc.); Date of operation; transaction amount in foreign currency(in parentheses, indicating the currency of the transaction) - if the settlements are made in foreign currency.
In the graph "Document" shows the document with the help of which the operation is reflected in the accounting of the enterprise.
In the graph "Debit" the amount in rubles posted on the debit of settlement accounts is indicated.
In the graph "Credit" the amount in rubles posted on the credit of settlement accounts is indicated.
After autocompletion of the table in the frame "Result of reconciliation of settlements" on the "Reconciliation parameters" tab, a message appears on the presence (absence) and amount of debt on settlements with the counterparty at the end of the reconciliation period.
In practice, a situation may arise when it is necessary to correct the data obtained automatically from the infobase. For example, you must additionally indicate in the column "Operation" the original number of the document. Or it turns out that some document was not registered, and, accordingly, did not get into the table, but in fact it exists, is reliable and therefore must be included in the reconciliation act. The reverse situation may also be: something is erroneously included in the act.
There are the following options for editing the generated settlement operations table:
- When you press a button "Change" it is possible to manually change the value of the table cell pointed to by the cursor. If the cursor at the moment of pressing the button is in one of the cells in the "Document" column, then the corresponding electronic document is called (available for viewing and editing). If changes are made to this document and it is reposted, the contents of the cell will not be automatically updated. To change the table of operations of the act of reconciliation 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 expedient to correct the amount in the "Debit" or "Credit" column manually.
- Button "Add Row" allows you to insert an empty row in the operation table before the one in which the cursor is located (after inserting, the cursor will point to the added row). This line must be filled in manually.
- Button "Delete line" is designed to delete the current table row.
Bookmark "Persons signing the act"
Before printing the act, on the tab "Persons signing the act" (Fig. 3), the following data is entered:
- about the employee who will sign the act on the part 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 act.
Rice. 3. Bookmark "Persons signing the act"
When you click on the "Print" button, a printed form of the reconciliation report is formed (Fig. 4).
Rice. 4. Printed form actp
By default, it is filled in only by the organization that prepared the reconciliation act according to its data.
This method of generating a printed form is recommended if you are not completely sure of your data (for example, when preparing a reconciliation report for sending to a counterparty).
If you know that the counterparty's data exactly matches yours, you can select the "Reconciliation results are consistent with the counterparty" checkbox on the "Reconciliation parameters" tab.
The software product of domestic development "1C: Accounting 8" works on a set of Russian enterprises. Users choose it for its user-friendly interface and thoughtful automation of all accounting areas, including the organization's settlements with suppliers and customers. For a quick check of debts and mutual settlements between counterparties, the document "Reconciliation Act" is used. 1C makes it possible to generate it automatically. Consider how to make a reconciliation act in 1C using an example latest version programs - "1C: Enterprise 8.3".
How to create?
To generate a reconciliation act in the "Purchases and sales" section, a separate hyperlink is provided - "Acts of reconciliation of settlements", located in the "Settlements with counterparties" subsection.
We press and in the log 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 in the upper part of the document fill in the details that are required to be filled in are underlined with a red line:
- "Contractor". Is it an organization or individual entrepreneur with which we check;
- "Agreement". We fill in the details only if necessary. If the field is left blank, the printed form will include the movements under all contracts with the counterparty;
- "Period". We determine the time period of interest to us;
- The fields "Organization" and "Currency" are filled in automatically depending on the settings of the directories.
If you check the box "Reconciliation approved", you will not be able to edit the document. We put only after agreeing the result with the supplier or buyer.
In addition to the “header”, for the correct formation of the reconciliation act, you need to fill in some data in the tabs of the form.
- "Settlement Accounts". Here, the accounts are automatically pulled up, on which mutual settlements with counterparties are most often taken into account: 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 box "Split by agreements".
In principle, these tabs can not be touched at all. The 1C printable form can be generated without a breakdown by contracts and only for the specified accounts, with empty lines where the names of representatives should be. You will have to spend a little time writing them with a ballpoint pen.
How to fill in data?
In the "According to the organization's data" tab, click the "Fill" button, then - "Fill in according to accounting data".
The system will automatically fill in the table with rows indicating primary documents and amounts. We spend (the corresponding button is above the details) and print (the button with the printer is in the same place).
The printed form contains data on mutual settlements, amounts, turnovers and the final balance. It is divided into two halves:
- According to our organization;
- According to counterparty. This part must be completed by the supplier or purchaser.
You can make a printed form of the reconciliation act by clicking on the appropriate button, or you can save it to a file (button with a diskette). Available formats - Microsoft Word and Excel, text document, web page and others.
We sign and send to the person with whom we check.
You can send an Excel file to the counterparty so that he fills it with his data. Then, in case of discrepancies, we will not need to print and sign the reconciliation act again.
If the accounting data of the counterparty and our organization match, and the reconciliation act is signed without discrepancies, we put the checkbox “Reconciliation agreed” at the top of the form, save and calm down.
If the reconciliation act contains discrepancies, then first of all you need to find an error in the accounting of our organization or counterparty (incorrect amount, document, date, etc.) and make corrections. After that, we reopen the document in 1C, go to the "According to the counterparty" tab, fill in the appropriate button, print 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.
Where can I find the act of reconciliation in 1C 8.3? Reconciliation of calculations is made document in section 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 of- date of commission business transaction(receipt, sale, payment, etc.). Filled with date primary document.
- Document- link to the primary document in the database.
- Representation - 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 in electronic format, 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 section 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 system - Rubricator 1C Accounting, you can learn more about filling out responsible persons in 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 manager 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