Customer VAT Invoice Check
For analyzing Sales VAT Invoices and detecting deviations between sales documents and VAT Invoices, in order to create VAT documents based on the type of sales operations, a related “Customer VAT Invoice Check” report has been added.
Entry data
Before you start creating and reconciling the amounts of VAT documents, you need to set up general information of taxes on 'Revenue Service Integration Setup' page 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 sales, prepayment, payment, return of items and services, refunds in Customer VAT Invoice Check must be created and posted.
Customer VAT Invoice Check/Header
Select the 
icon, enter Customer VAT Invoice Check, fill out the following fields/filters in the report and click Recalculate Lines. If necessary, use the buttons on the ribbon.
| Field | Description |
|---|---|
| Date Filter | The Date of generating the page. |
| View By | Options: Day / Week / Month / Quarter / Year / Accounting period. |
| Show agreement without entries | If enabled, the report displays all customers. If disabled, then only those for which there are operations (records in customer ledger entries or/and Sales VAT Invoices) in the system for specified period. |
| Show Only with warning | Show only the lines with deviation. |
| VAT Payer | If enabled, the report displays only customers which are VAT Payers. If disabled, then all customers regardless of the value of VAT Taxation. |
| Include Draft | If enabled, the report includes Sales VAT Invoices with External Status: “Draft”, “Draft Of Correction” in calculation of “VAT Invoice Amount“. If disabled, they are not included in the calculation. |
Field Description
The tabular part of the Customer VAT Invoice Check 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 for the period set in the Date Filter or View by fields (the following values are available: Day / Week / Month / Quarter / Year / Reporting period).
| # | Field | Description |
|---|---|---|
| 1. | customer No. | Number of the Customer. |
| 2. | Customer Name | Name of the Customer. |
| 3. | Agreement No. | Number of the Customer’s Agreement. |
| 4. | VAT Bus. Posting Group | Code of the VAT Business Posting Group assigned to the Customer. |
| 5. | Begin Balance | The amount of settlement for selected customers as of the start of the selected period based on Customer Ledger Entry. |
| 6. | Debit Amount | The debit amount of settlement for selected customers from the start of the selected period based on customer Ledger Entry. |
| 7. | Credit Amount | The credit amount of settlement for selected customers from the start of the selected period based on Customer Ledger Entry. |
| 8. | Ending Balance | The credit amount of settlement for selected customers as of the end of selected period based on Customer Ledger Entry. |
| 9. | Invoice Amount | The sum of Amount (LCY) for selected customers in selected period based on Customer Ledger Entry, where Document Type = “Invoice” or “Credit Memo”. |
| 10. | VAT Amount | The sum of Amount for selected customers in selected period based on VAT Entries related to Customer Ledger Entries. |
| 11. | VAT Invoice Amount | The sum of “Total Amount Exc. VAT” for selected customers in selected period based on Sales VAT Invoice, where External Status is Sent, Corrected, Approved, Approved correction and Advance VAT = NO. |
| 12. | VAT Amount INV. | The sum of “Total VAT” for selected customers in selected period based on Sales VAT Invoice Line, where External Status is Sent, Corrected, Approved, Approved correction and Advance VAT = NO. |
| 13. | Prepayment | The sum of Amount (LCY) for selected customers in selected period based on Customer Ledger Entry, where Document Type = “Payment” and Advance Payment = YES. |
| 14. | Advance VAT Invoice | The sum of “Total Amount Inc. VAT” for selected customers in selected period based on Sales VAT Invoice Line, where External Status is Sent, Corrected, Approved, Approved correction and Advance VAT = YES. |
| 15. | Check Invoice Amount | "Invoice Amount"– “VAT Invoice Amount”. |
| 16. | Check Invoice VAT Amount | "VAT Amount" – “VAT Amount in INV.” |
| 17. | Check Advance Amount | “Prepayment” – “Advance VAT Invoice”. |
| 18. | Deviation exists | If in the “Check Amount”, “Check VAT Amount”, ”Check Advance Amount” fields, the value > 0, then YES; if = 0, then NO. |
Fields 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.
Using the Ledger Entry button, you can view the Customer Ledger Entry for the selected Customer for the period specified in the filter.
Using the Sales VAT Invoice List button, you can view the sales VAT Invoices for the period specified in the filter.
Using the Posted Sales VAT Invoice List button, you can view the posted sales VAT Invoices for the period specified in the filter.