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
| Field | Description |
|---|---|
| View by | Specifies the period of report generation. The following values are available: Day / Week / Month / Quarter / Year / Reporting period. |
| Date Filter | Specifies the date that will be used to filter the vendors entries in the window. |
| Vendor No. | Specifies the number of the vendor account that the entry is linked to. |
| VAT Bus. Posting Group | Specifies the VAT specification of the involved customer or vendor to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. |
| Show Only With Difference | Specifies how the data will be displayed on the page. If YES, then the page will display only vendors for whom VAT Invoices must be created. |
| Show agreement without entries | Specifies whether the lines in the table are displayed for vendors agreements for which entries were not posted in the specified period. |
| Recalculate when reform invoices | Specifies whether the value in the table lines will be updated automatically after Reform VAT Invoice From Date. |
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 Agreements according to the parameters specified on the page.
The page fields are described in the table below:
| Field | Description |
|---|---|
| Vendor No. | Specifies the number of the vendor account that the entry is linked to. |
| Vendor Name | Specifies the vendor’s name, which is indicated on the vendor card. |
| Agreement No. | Specifies the vendor agreement number associated with the entry. |
| Begin Balance | Specifies the balance at the beginning of the selected period. |
| Debit Amount | Specifies the total of the ledger entries that represent debits. |
| Credit Amount | Specifies the total of the ledger entries that represent credits. |
| Ending Balance | Specifies the balance at the end of the selected period. |
| Invoices | Specifies the amount of the posted purchase invoices. |
| Payments | Specifies the amount of the posted payments for the vendor. |
| Credit Memos | Specifies the amount of the posted purchase credit memos. |
| Refunds | Specifies the amount of the posted refunds for the vendors. |
| VAT Invoice Amount | Specifies the amount of created purchase VAT invoices for vendors entries. |
| VAT Appendix Amount | Specifies the amount of created purchase Appendix 2 for vendor's entries. |
| Posted VAT Invoice Amount | Specifies the amount of posted purchase VAT invoices for vendor's entries. |
| Posted VAT Appendix Amount | Specifies the amount of posted purchase Appendix 2 for vendor's entries. |
| VAT Bus. Posting Group | Specifies the VAT specification of the involved customer or vendor to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. |
| Check Invoice Amount* | Specifies the difference between the calculated amount of VAT invoices according to the VAT invoice creation method and the amount of generated VAT invoices for vendor's transactions. The VAT invoice creation method can be specified for the corresponding VAT Business Posting Group. |
| Check Appendix Amount* | Specifies the difference between the calculated amount of Appendix 2 according to the VAT invoice creation method and the amount of generated Appendix 2 for vendor transactions. The VAT invoice creation method can be specified for the corresponding VAT Business Posting Group. |
| Check Invoice Amount For Sales* | Specifies the difference between the calculated amount of VAT invoices according to the VAT invoice creation method and the amount of generated VAT invoices for vendor's transactions. The VAT invoice creation method can be specified for the corresponding VAT Business Posting Group. |
| Check Appendix Amount For Sales* | Specifies the difference between the calculated amount of Appendix 2 according to the VAT invoice creation method and the amount of generated Appendix 2 for vendor transactions. The VAT invoice creation method can be specified for the corresponding VAT Business Posting Group. |
| Check Qty. Of Operations* | Specifies the number of transactions for which VAT Invoices must be created. |
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.
For Import of Services operations, it is possible to view Sales VAT Invoice related to the vendor for the specified period through the Sales VAT Invoice List and Posted Sales VAT Invoice List buttons.
Note
The buttons are available when the VAT business group in the table row is marked as Service Import.
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
- Select 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 fields 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.