VAT Invoice Customer Reconciliation
Interface
To quickly create and reconcile sales VAT invoices and calculate adjustments to sales VAT invoices in the context of Customers, Agreements, Orders, Types of Operations, it is recommended to use the VAT Invoice Customer Reconciliation page. Consolidated interface of VAT Invoice Customer Reconciliation makes it possible to check the amounts of tax liabilities and compare them with the Customer’s operations, which is the basis for creating sales VAT invoices and calculating adjustments to sales VAT invoices, creating VAT documents based on the type of sales operations, in accordance with the current legislation.
Entry data
Before you start creating and reconciling the amounts of VAT documents, you need to set up general information on taxes in Tax Setup and VAT posting periods in Tax Periods. You also need to specify the rules for VAT posting in VAT Posting Setup and set up and assign VAT Business Posting Groups for Customers and VAT Business Posting Groups for items and services. For more information, see the VAT Posting Setup section or follow the links.
For a full-fledged data generation, all documents for sale, prepayment, payment, return of items and services, refunds in VAT Invoice Customer Reconciliation must be created and posted.
Field description
The tabular part of the VAT Invoice Customer Reconciliation page displays the following:
- Status of settlements with counterparties for the period and operations that are the basis for generation of VAT documents,
- Amounts of actually created and posted VAT invoices and adjustment calculations,
- Control of amounts for VAT invoices – the amount for which the VAT invoices still need to be generated and posted.
Records in the tabular part are generated in terms of Customers and Contracts for the period set in the Date Filter or View by fields (the following values are available: Day / Week / Month / Quarter / Year / Reporting period).
The page fields are described in the table below:
| Field | Description |
|---|---|
| Customer No. | Number of the Customer. |
| Customer Name | Name of the Customer. |
| Agreement No. | Number of the Customer’s Agreement. |
| Begin Balance | Amount of settlements with the Customer as of the start of the selected period based on Customer Ledger Entry. |
| Debit Amount | The debit amount of settlements with the Customer for the selected period based on the Customer Ledger Entry. |
| Credit Amount | The credit amount of settlements with the Customer for the selected period based on the Customer Ledger Entry. |
| Ending Balance | Amount of settlements with the Customer as of the end of the selected period based on the Customer Ledger Entry. |
| Invoices | Amount of posted invoices. |
| Payments | Amount of posted payments. |
| Credit Memos | Amount of posted refunds. |
| Refunds | Amount of posted monetary refunds. |
| VAT Invoice Amount | Amount of created VAT invoices. |
| VAT Appendix Amount | Amount of created adjustment calculations before VAT invoices. |
| Posted VAT Invoice Amount | Amount of posted VAT invoices. |
| Posted VAT Appendix Amount | Amount of posted adjustment calculations before VAT invoices. |
| VAT Bus. Posting Group | Code of VAT business group assigned to contract of the customer. |
| Check Invoice Amount* | Shows the difference between the calculated amount of VAT invoices, which should be generated in accordance with the Create VAT Invoice method, which is indicated on the corresponding VAT Business Group for the Customer’s operations for the period selected on the page, and the amount of created and posted VAT invoices for the Customer’s operations for the period selected on the page. |
| Check Appendix Amount* | Shows the difference between the calculated amount of adjustments to VAT invoices that must be generated according to the VAT invoice creation method specified in a corresponding VAT Business Group for Customer’s operations for the period selected on the page and the amount of created and posted adjustments to VAT invoices for Customer’s operations for the period selected on the page. |
| Check Qty. Of Operations* | Shows the number of documents with a deviation when checking VAT Invoices and VAT Appendices 2. |
Note
All digit fields except for those marked with “*” are available for breakdown in terms of operations.
Buttons on a ribbon
To fill in and update the data in the tabular section of the VAT Invoice Customer Reconciliation page, you need to click the Recalculate Lines button on the ribbon.
On the ribbon, it is possible to change the data generation period using the Previous Period and Next Period buttons. With their use, you can quickly change the calculation periods based on the selected interval in the View by field.
Show agreement without entries field is aimed to control the display of rows in the tabular part of the page. You must enable this feature to display data for all Customers in terms of contracts, or disable it if you need to analyze only those for which there are operations in the system for the period specified in the filter.
It is possible to set automatic data update after each running of the Reform VAT Inv. From Date job. To do it, enable the Recalculate when reform invoices option.
Also, the time since the last data update is written on the page in words. For the Customer selected in the tabular section, a quick view of the created and posted VAT documents for the period specified on the page is available using the buttons on the Sales VAT invoice List and Posted Sales VAT invoice List ribbons.
Using the Ledger Entry button, you can view the Customer Ledger Entry for the selected Customer for the period specified in the filter.
It is possible to check the amounts of VAT documents and compare them with the operations of the Customer, which is the basis for their creation in the context of operations. To do this, select the required row of the tabular section of the VAT Invoice Customer Reconciliation page and use the Check created VAT Invoices by lines button on the ribbon. The page created on the basis of entries in the Customer Ledger Entry will open, the data of which is filtered according to the settings of the line from which the page was called. For reconciliation, it is convenient to use the Check Invoice Amount and Check Appendix Amount fields that repeat the logic of the fields of the same name on the VAT Invoice Customer Reconciliation page, with breakdown by operations.
From the VAT Invoice Customer Reconciliation report page, using the Check created VAT Invoices by lines button, you can access a report that verifies quantitative and value indicators, as well as the consistency of Customs Category codes, Service code DKPP codes, and the Imported item attribute at the sales document line level and their matching with tax document lines. On this page, the Update line information function is available, which allows updating data regarding Customs Category codes, DKPP codes, and the imported item attribute after changes have been made to the related documents. The update is applied only to the selected lines.
If discrepancies are found in Customs category codes, DKPP codes, and/or the imported item attribute, the corresponding matching fields — Customs Category Code are NOT Alligned, Service Codes DKPP are NOT Alligned and Imported Item Attributes are NOT Alligned — will display the value Yes. Clicking on a field with the value Yes opens the Check of Customs and Service Codes in Documents page, which displays a complete list of related documents for the respective sales document. This allows users to view and analyze the Customs category codes, DKPP codes, and imported item attribute across all related documents for a specific item.
Note
Sales documents marked as Change Price Order are not displayed on the Check of Customs and Service Codes in Documents page and are not included in the verification of Customs category codes, DKPP codes, or imported item attributes.
The following table contains the description of jobs available from the VAT Invoice Customer Reconciliation page. Description of their use can be accessed by following the links below:
| Link | Action |
|---|---|
| Reform VAT Inv. From Date | Creation and re-generation of VAT invoices and adjustments on general terms for Customers and Vendors for the required period, in accordance with the selected method of VAT Invoice creation. |
| Create Total VAT Invoice | Creation of consolidated sales VAT invoices for rhythmic supplies and retail supplies for the required period. |
| Export VAT Invoice to XML | Generating VAT invoices in XML format for their further registration in the URTI. |
Sequence of steps
- Select the
icon, enter VAT Invoice Customer Reconciliation, and then choose the related link. - On the VAT Invoice Customer Reconciliation page, fill in the View by and/or Date filter field with one of the available values.
- Click Recalculate Lines on the menu ribbon to update data in line with the set filters.
- If necessary, use the buttons on the ribbon as described above.