VAT Invoice Vendor Reconciliation
Interface
To quickly create and reconcile purchase VAT invoices and calculate adjustments to purchase VAT invoices in the context of Vendors, Agreements, Orders, Types of Operations, it is recommended to use the VAT Invoice Vendor Reconciliation page. Consolidated interface of VAT Invoice Vendor Reconciliation makes it possible to check the amounts of tax liabilities and compare them with the Vendor’s operations, which is the basis for creating purchase VAT invoices and calculating adjustments to purchase VAT invoices, creating VAT documents based on the type of purchase 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 Vendors 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 purchase, prepayment, payment, return of items and services, refunds in VAT Invoice Vendor Reconciliation must be created and posted.
Field description
The tabular part of the VAT Invoice Vendor 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 Vendors 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 |
|---|---|
| Vendor No. | Number of the Vendor |
| Vendor Name | Name of the Vendor |
| Agreement No. | Number of the Vendor’s Agreement |
| Begin Balance | Amount of settlements with the Vendor as of the start of the selected period based on Vendor Ledger Entry |
| Debit Amount | The debit amount of settlements with the Vendor for the selected period based on the Vendor Ledger Entry |
| Credit Amount | The credit amount of settlements with the Vendor for the selected period based on the Vendor Ledger Entry |
| Ending Balance | Amount of settlements with the Vendor as of the end of the selected period based on the Vendor 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 Vendor |
| 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 Vendor’s operations for the period selected on the page, and the amount of created and posted VAT invoices for the Vendor’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 Vendor’s operations for the period selected on the page and the amount of created and posted adjustments to VAT invoices for Vendor’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 Vendor 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 Vendors in terms of agreements, 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 Vendor 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 Purchase VAT invoice List and Posted Purchase VAT invoice List ribbons.
Using the Ledger Entry button, you can view the Vendor Ledger Entry for the selected Vendor 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 Vendor, 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 Vendor 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 Vendor 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 Vendor Reconciliation page, with breakdown by operations.
The following table contains the description of jobs available from the VAT Invoice Vendor 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 |
| Export VAT Invoice to XML | Generating VAT invoices in XML format for their further registration in the URTI |
Sequence of steps
- Choose the
icon, enter VAT Invoice Vendor Reconciliation, and then choose the related link. - On the VAT Invoice Vendor 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.