What is the 1C reconciliation service intended for? Reconciliation of VAT accounting data
The 1C:Reconciliation service provides automatic reconciliation of invoices with suppliers and customers at any time convenient for the user - both promptly during the accounting process and before sending a VAT return to the Federal Tax Service.
Service capabilities:
requesting information about issued invoices from suppliers and automatically loading them into the 1C program;
automatic comparison of invoices of counterparties and your organization;
managing the provision of information about received invoices to customers in response to requests received from them;
convenient reports with reconciliation results - with visual highlighting of discrepancies and the ability to decipher them back to the original document.
Advantages
the service allows you to organize regular prompt reconciliation of invoices without waiting for the end of the reporting period;
support for general reconciliation with all counterparties immediately before generating a declaration and sending it to the Federal Tax Service;
reconciliation is performed directly in the program - without the need to upload and download data that is a trade secret to third-party applications or third-party sites;
for each identified discrepancy, you can immediately go to the source document for study and correction, if the source document is included in the 1C information base;
the user can plan his work in a way that is convenient for him and his partners, so as not to leave analysis difficult situations in the last days before the deadline for submitting the VAT return.
Major changes in the form and delivery procedure tax return on VAT are aimed at tax service could automatically compare information about the transactions of counterparties, monitor and identify organizations that have understated their tax obligations. For this purpose, the Federal Tax Service, as part of its internal desk control, carries out a total automatic reconciliation of data from the purchase and sales books of all taxpayers. The possibility of a similar preliminary check for taxpayers is implemented in the 1C: Reconciliation service.
Report "Reconciliation of invoices with suppliers" compares your database data and supplier data. The compliance of invoices is checked using three parameters: number, date, amount.
The report is located in the section “Purchases” – “Reconciliation of VAT accounting data”. It can be generated either for one counterparty or for all of them for which you have loaded data into the database. Lines with discrepancies are displayed twice in the report - “according to our data” and “according to the supplier” and are highlighted in red.
There are 4 possible results of reconciliation:
the data matches
an invoice with the same number and dates is not in the counterparty’s database
the counterparty does not have an invoice with such numbers and dates
The data differ in amounts.
How to load supplier data into the database?
Supplier data in the buyer's database is stored as documents "Registers of supplier invoices" in the "Purchases" - "Reconciliation of VAT accounting data" section. You can download them either using the "Download" button, specifying the path to the corresponding .xml file, or from e-mail to all contractors who sent the registers. To be able to download or send registers via email, you need to set up an email account in the program.
How to upload data to the buyer?
As a supplier, you can send reconciliation data to the buyer. To do this you need to generate a report "Register of issued invoices", which is located in the "Sales" - "VAT Reports" section.
This report can be downloaded using the appropriate button or sent to the buyer by email directly from the form.
To send by email, you must set up an email account. Its settings are located in the "Administration" - "Organizer" - "System email account setup" section.
Specify the settings for outgoing and incoming mail servers.
If you already have an account in the program, check whether the ability to receive email is enabled.
Connect the service
The new VAT return is complex and voluminous - it includes all entries in the purchase and sales books, invoice journals. There is only one way to reduce the likelihood of errors and discrepancies in the declaration - regular reconciliation with counterparties issuing invoice data. In the program "1C: Accounting 8" starting with version 3.0.40.31 in "1C: Accounting 8" ed. 3.0 worked perfectly new service– “Reconciliation of VAT accounting data.” Read about its advantages and use in the material of 1C experts.
New service Reconciliation of VAT accounting data allows you to request, receive and download data from counterparties without leaving the 1C: Accounting 8 program, ed. 3.0 - all the functions necessary for this are collected in one place. Access to the service is carried out via the hyperlink of the same name from the group VAT reports section Reports. The service consists of five sections: Reconciliation, Supplier Requests, Supplier Responses, Buyer Requests, Settings(Fig. 1). The service allows for reconciliation within one tax period. If taxable period is not completed, the report will be generated for the current date. The selected period is indicated in a special field.
Rice. 1.Form of the report “Reconciliation of VAT accounting data”
Reconciliation
In chapter Reconciliation a report is generated on the compliance of the buyer's invoices with the data of the seller's invoices. The report is generated based on information from the buyer’s information base and registers of invoices received from the supplier by clicking on the button Check(Fig. 2).
Rice. 2. Reconciliation result
If the registers of invoices from suppliers are not loaded, the program will notify you about this (Fig. 3). You can request registers from suppliers directly from this section by clicking on the button Request registries.
Rice. 3. Section “Reconciliation” in the absence of registers of invoices from suppliers
Inquiries to suppliers
To section Inquiries to suppliers you can get there in two ways: by going to the appropriate tab or by clicking on the button Request registries In chapter Reconciliation.
The section provides information about suppliers who issued invoices in the period selected for reconciliation.
Note! The program automatically analyzes the credentials and, in accordance with them, determines the status of the supplier's registry. The status can take the following values:
- Not requested- in the selected tax period, the register has not yet been requested from the supplier;
- Requested– a registry request has been sent to the supplier (see Fig. 4);
- Waiting to load– the supplier has sent the register, but it has not yet been loaded into the program;
- Outdated– the credentials in the program have changed (there are invoices in the database that are not included in the register);
- Ready for reconciliation– the supplier register is loaded and ready for reconciliation.
You can request registers using the button with the same name. Suppliers marked with the flags will be automatically sent query letters. The letter contains instructions for sending a register of invoices from 1C programs and an XML file with a request containing data for the supplier’s accounting system.
Rice. 4. Section “Requests to suppliers”
Supplier responses
This section displays information about registers of invoices received from suppliers. The list contains information about the supplier, the date the register was formed and the date the request was sent. By button Download(Fig. 5), the registers marked with the flag are loaded into the program. You can see the loaded registers by moving the toggle switch to the position Loaded.
Rice. 5. Section “Supplier responses”
Buyer Requests
All register requests received from buyers are reflected in the appropriate section. The list of requests displays information about the buyer, the date the request was sent, the amount of goods and services purchased (according to the buyer) for the tax period (Fig. 6).
Rice. 6. Section “Customer requests”
By button Answer the service will analyze the data of the marked requests, create registers of invoices and send them to buyers by email.
Settings
Set up an email account directly in the service on the tab At a construction site. In the form that opens Setting up an email account you need to enter the email details that you plan to use to send and receive registers (Fig. 7), set the flag to To receive mail.
Rice. 7. Create an email account
Specify the settings for outgoing and incoming mail servers. For the incoming mail server, we recommend using the IMAP protocol - this increases the data transfer speed for reconciliation (Fig. 8).
Rice. 8. Selecting an account from the list
If accounts in the program have been created previously, you need to make sure that they are enabled to receive email (checkbox To receive mail) and, if necessary, set up an account for this.
Implementation of invoice reconciliation in 1C:Enterprise (terms may be specified)
Configuration name |
Version number and date |
1C:Enterprise 8 |
|
Automatic invoice reconciliation functionality |
|
Enterprise Accounting, ed. 3.0 Basic, PROF and CORP | |
1C:ERP Enterprise Management 2.0 | |
Holding management |
Version 1.1.1.30 released on 07/09/2015 |
Accounting government agency, ed. 2.0 | |
Enterprise Accounting, ed. 2.0 | |
Control manufacturing enterprise | |
Trade Management, ed. 10.3 | |
Trade Management, ed. 11.0 | |
Accounting of a government agency, ed. 1.0 |
August 2015 |
1C:Enterprise 7.7 |
|
Uploading information about issued invoices for reconciliation of VAT data |
|
Accounting | |
Accounting + Trade + Warehouse + Salaries + Personnel, edition 4.5 | |
Production+Services+Accounting |
Features of setting up the service via gmail
To automatically compare information on invoices, it uses a mailbox, through which data is exchanged with counterparties. Because Google's mailbox uses unified system authentication for your services, then to access mail functions you need to make special settings. To configure the service via Gmail email, you must complete the following steps:
1. Give third-party applications access to mail. To do this, follow the link https://www.google.com/settings/security/lesssecureapps. In the window that opens, select Turn on(see Fig. 9).
To verify that the setup was successful, go to https://security.google.com/settings/security/secureaccount.
In point Block untrusted apps item must be selected Turn on opposite the line Account access(see Fig. 10).
2. If during the setup process the program reports that it was unable to connect to mail and you need to do it manually, you need to follow the link https://accounts.google.com/displayunlockcaptcha. In the form that opens, click on the button Continue(see Fig. 11).
The computer on which you perform the setup is authorized in the Google system and the service will work. If your Google account uses two-step authentication, then for the service to work you need to disable it, and then repeat the steps described above.
It is recommended to use a mailbox that does not have a large number of messages, otherwise, during initial setup, collecting information about the mailbox may take quite a long time. You can even create a separate mailbox for the service with different access rights for different users.
Service 1C:Sverka
This service allows you to automatically reconcile invoices with suppliers and customers at a convenient time. Moreover, now this can be done more quickly while accounting is in progress, and also before the value added tax (VAT) return is generated and sent to the federal tax service.
The service helps users:
1. Make a request about how much and what accounting documents generated from suppliers (invoices, etc.), and also uploaded to the 1C program automatically;
2. Compare the accounts of counterparties with those formed in your organization;
3. Manage the process of providing data on whether partners have received documents that are sent to them based on their own requests;
4. Generate reports that contain the results of the reconciliation: discrepancies will be highlighted and clearly visible, moreover, it will be possible to decipher them back to the source document;
The service is constantly being developed and tested; the number of possibilities and ways to make a reconciliation report in 1C is growing. The service will be further improved; its updates will make the reconciliation process as convenient and fast as possible.
What are the advantages of 1C:Sverka?
1. Regular and prompt reconciliation with 1C suppliers is carried out, and it is not necessary to wait until the reporting period ends;
2. Reconciliation with counterparties is carried out before the organization sends the report to the Federal Tax Service, this eliminates errors and omissions;
3. The act of reconciliation of mutual settlements is done by the program; there is no need to unload or upload information that is a trade secret into third-party applications;
4. All discrepancies can be checked and corrected. This can be done by going to the source document, if, of course, it was previously entered into the 1C information database of transaction partners;
5. The accounting department can organize accounting with partners in a convenient manner even before sending the VAT return.
Conditions of receipt
In order to receive the service, it is enough to register as a user of 1C programs. You will be given a period to familiarize yourself with the program. At the end of the training period, the conditions will be changed. In order for the service to work stably and, if necessary, to update it, a technical support service is needed. It is carried out by a partner with whom you will enter into an information technology support agreement. As for the price, so far software is provided free of charge.
Our specialists will tell you in more detail about the conditions for working with the service! Please refer to the “Order a call” or “Ask a question” form.
Since 2015, as part of the VAT return in in electronic format information is provided from the book of purchases, sales and the journal of invoices. Tax inspections Conduct cross-checks of the buyer and seller's data. In order to reduce the risk of discrepancies between invoices, automatic reconciliation is implemented in the main 1C programs - the 1C: Reconciliation service.
You can use the service at any convenient time - immediately before submitting your VAT return or carry out a reconciliation in advance, during the reporting period. The service allows for reconciliation within one tax period. If the tax period has not ended, the report will be generated for the current date. The selected period is indicated in a special field.
Main features of the 1C:Sverka service:
- Requesting information about issued invoices from suppliers, receiving them and loading them into the program;
- Managing the provision of information to customers about invoices in response to requests received from them;
- Automatic comparison of information in invoices of counterparties and your organization according to three parameters (date, number and amount);
- Convenient reports with visual highlighting of discrepancies and the ability to decipher them back to the original document.
Let's take a closer look at how the service works. using the program as an example.
The service in the program is accessed from the section Reports, group VAT reports(Fig. 1).
The service consists of five sections: Reconciliation, Supplier Requests, Supplier Responses, Buyer Requests and Settings.
Reconciliation
In chapter Reconciliation the period for reconciliation is set, the supplier counterparty is set, and invoices are automatically reconciled based on information from the buyer’s information base and invoice registers received from the supplier. Next, a report is generated on the compliance of the buyer’s invoices with the data of the seller’s invoices (Fig. 2).
Rice. 2. Reconciliation result
If during reconciliation discrepancies are found in invoices, the program will mark these lines in red (Fig. 3). Then, directly from this window, you can go to the disputed document and understand the reason for the discrepancy.
The program also displays messages if the registers of invoices from suppliers are not loaded or not provided (Fig. 4). You can request registers from suppliers from this section by clicking on the button Request registries, or go to section Inquiries to suppliers.
Rice. 4. Section "Reconciliation" in the absence of registers of invoices from suppliers
Inquiries to suppliers
This section provides information about suppliers who issued invoices in the selected period for reconciliation. The program automatically checks the credentials for each supplier and indicates the status of the supplier registry. The status can take the following values (Fig. 5):
- Not requested- in the selected tax period, the register has not yet been requested from the supplier;
- Requested- a registry request has been sent to the supplier;
- Waiting to load- the supplier sent the register, but it has not yet been loaded into the program;
- Outdated- the credentials in the program have changed (there are invoices in the database that are not included in the register);
- Ready for reconciliation- the supplier register is loaded and ready for reconciliation.
When the button is pressed Request registries emails will be automatically sent to selected suppliers requesting invoices.
Rice. 5. Section "Requests to suppliers"
Supplier responses
In this section we see information about the registers of invoices received from suppliers. We select suppliers and load the registers into the database (Fig. 6). By pressing the " Loaded", you can view all downloaded registers from suppliers .
Rice. 6. Section "Supplier responses"
Buyer Requests
This section displays all requests received from customers. The table shows information about the buyer, the date the request was sent, the amount of purchased goods and services (according to the buyer) for the tax period (Fig. 7). 1C:ITS services, which will help you quickly and without errors submit all reports to the regulatory authorities.
requesting information about issued invoices from suppliers and automatically loading them into the 1C program;
automatic comparison of invoices of counterparties and your organization;
managing the provision of information about received invoices to customers in response to requests received from them;
convenient reports with reconciliation results - with visual highlighting of discrepancies and the ability to decipher them back to the original document.
Advantages
the service allows you to organize regular prompt reconciliation of invoices without waiting for the end of the reporting period;
support for general reconciliation with all counterparties immediately before generating a declaration and sending it to the Federal Tax Service;
reconciliation is performed directly in the program - without the need to upload and download data that is a trade secret to third-party applications or third-party sites;
for each identified discrepancy, you can immediately go to the source document for study and correction, if the source document is included in the 1C information base;
the user can plan his work in a way that is convenient for him and his partners, so as not to leave the analysis of complex situations until the last days before the deadline for submitting the VAT return.
The main changes in the form and procedure for submitting a VAT tax return are aimed at ensuring that the tax service can automatically compare information about the transactions of counterparties, monitor and identify organizations that have understated their tax liabilities. For this purpose, the Federal Tax Service, as part of its internal desk control, carries out a total automatic reconciliation of data from the purchase and sales books of all taxpayers. The possibility of a similar preliminary check for taxpayers is implemented in the 1C: Reconciliation service.
Report "Reconciliation of invoices with suppliers" compares your database data and supplier data. The compliance of invoices is checked using three parameters: number, date, amount.
The report is located in the section “Purchases” – “Reconciliation of VAT accounting data”. It can be generated either for one counterparty or for all of them for which you have loaded data into the database. Lines with discrepancies are displayed twice in the report - “according to our data” and “according to the supplier” and are highlighted in red.
There are 4 possible results of reconciliation:
the data matches
an invoice with the same number and dates is not in the counterparty’s database
the counterparty does not have an invoice with such numbers and dates
The data differ in amounts.
How to load supplier data into the database?
Supplier data in the buyer's database is stored as documents "Registers of supplier invoices" in the "Purchases" - "Reconciliation of VAT accounting data" section. You can download them either using the "Download" button, specifying the path to the corresponding .xml file, or from e-mail to all contractors who sent the registers. To be able to download or send registers via email, you need to set up an email account in the program.
How to upload data to the buyer?
As a supplier, you can send reconciliation data to the buyer. To do this you need to generate a report "Register of issued invoices", which is located in the "Sales" - "VAT Reports" section.
This report can be downloaded using the appropriate button or sent to the buyer by email directly from the form.