VAT return reporting
Use this inquiry to filter for amounts submitted for a given date range linked to a VAT or RTD return. The query is based on the actual VAT box setup and not limited to the boxes defined in the VAT return. You can display summary amounts for several declarations and filter for specific VAT boxes.
You can only filter for a given declaration and legislation that has already been extracted in the VAT returns function.
Prerequisites
Refer to documentation Implementation
Screen management
Header
Selection
| VAT form (field VATFRM) |
|
Enter or select the VAT form to filter based on the declaration and legislation defined on the VAT form. You can then select to filter for VAT boxes related to this declaration and legislation combination. |
| Description (field DESTRA) |
|
This field displays information for the selected VAT form and cannot be modified. |
| Declaration (field VATFNC) |
| Legislation (field LEG) |
| Validity start date (field VLYSTRDAT) |
|
This field displays information for the selected VAT form and cannot be modified. This is the date for the form, not the return. |
| Validity end date (field VLYENDDAT) |
| VAT entity (field CODVATGRP) |
|
Select a VAT entity. The VAT entity selection is limited to those that match the legislation for the VAT form. |
| Head member (field VATHEA) |
|
This field displays the head member for the selected VAT entity. |
| field HEAFCY |
|
This field displays information for the Head member and cannot be modified. |
| Currency (field AMTVATCUR) |
| Company tax ID number (field CRN) |
| EU VAT no. (field EECNUM) |
| Additional tax identifier (field ADLTAXID) |
| Start date (field STRDAT) |
|
Enter a date range to filter for declarations within that timeframe. If there is more than one declaration within that timeframe, the related amounts are combined. If the date range includes a VAT return that is in simulation mode, an information message displays. |
| End date (field ENDDAT) |
| VAT on debit (field VATDBT) |
|
Select this checkbox to include VAT on debit. If the Detail checkbox is also selected, all related information displays in the VAT on debit details grid when you extract. |
| VAT on payment (field VATPAY) |
|
Select this checkbox to include VAT on payment. If the Detail checkbox is also selected, all related information displays in the VAT on payment details grid when you extract. |
| Detail (field SHODET) |
| Amount type (field AMTTYP) |
|
Select one:
|
| From VAT box (field BOXFROM) |
|
Select a VAT box range. The selection list is based on the declaration and legislation combination for the entered VAT form. This is list is not limited to the boxes in the VAT return but includes all Detail VAT box types defined in the VAT boxes setup. If you do not enter a range, all related VAT boxes are included in the inquiry. |
| To VAT box (field BOXTO) |
|
Select a VAT box range. The selection list is based on the declaration and legislation combination for the entered VAT form. This is list is not limited to the boxes in the VAT return but includes all Detail VAT box types defined in the VAT boxes setup. If you do not enter a range, all related VAT boxes are included in the inquiry. |
Tab Results
This grid displays the amount summaries for the VAT boxes entered per company. Select a line to see details in the Journal entries grid in either the VAT on debit details or VAT on payment details sections.
The results can be exported to an Excel file and used as a preparatory report. For an Irish company, this file can be used to submit to ROS.
| Company (field CPY) |
|
This field displays information based on the selection criteria and cannot be modified. |
| Company name (field CPYNAM) |
| VAT boxes (field VATBOX) |
| Description (field DESVATBOX) |
| Extracted value (field VATAMT) |
|
This field displays information based on the selection criteria and cannot be modified. For overlapping declarations, this is the combined value. |
Summary
| Total amount (field TOTAMT) |
|
This field displays the total amount of the extracted values. |
| Currency (field CUR) |
|
This field displays the currency for the extracted values based on the declaration and legislation for the selected VAT form. |
| Number of lines (field NOLINES) |
|
The maximum line limit is 5000 and you are warned when you reach 1000 lines. You can manage this using the ENSLB - No. lines EC Sales List activity code. |
Tab VAT on debit details
If you have selected the Detail checkbox, this grid displays all journal entries for VAT on debit.
You can drilldown to the journal entry from the Action icon menu at the beginning of each line.
The maximum line limit is 5000 and you are warned when you reach 1000 lines. You can manage this using the ENSLB - No. lines EC Sales List activity code.
Grid Journal entries
| Account (field ACC) |
|
This field displays information for the journal entry and cannot be modified. |
| Site (field FCY) |
| Declared amount (field AMT) |
| Entry type (field TYP) |
| Document no. (field NUM) |
| VAT code (field VAT) |
| Tax management (field FLGVAT) |
| Tax allocation (field VATIPT) |
| VAT rate (field VATRAT) |
| Query no. (field NUMRPT) |
| Simulation (field SIM) |
| Accounting date (field ACCDAT) |
| Chart code (field COA) |
| Currency (field CUR) |
| Company (field CPY) |
| Amount type (field TYPAMT) |
| Accounting document |
|
Click this action to view the journal entry on the line. |
Tab VAT on payment details
If you have selected the Detail checkbox, this grid displays all journal entries for VAT on payment.
You can drilldown to the journal entry from the Action icon menu at the beginning of each line.
The maximum line limit is 5000 and you are warned when you reach 1000 lines. You can manage this using the ENSLB - No. lines EC Sales List activity code.
Grid Journal entries
| Matched control account (field MTCACC) |
|
This field displays information for the journal entry and cannot be modified. |
| Matched BP (field BPR) |
| Match letter (field MTC) |
| Matching date (field MTCDAT) |
| Site (field FCY) |
| Payment amount (field AMTVCR) |
| Base including tax (field ATIVCR) |
| Entry type (field TYP) |
| Document no. (field NUM) |
| VAT code (field VAT) |
| Tax management (field FLGVAT) |
| Tax allocation (field VATIPT) |
| Base before tax (field BASNOTLIN) |
| Tax base (field BASVATLIN) |
| Declared amount (field AMT) |
| VAT rate (field VATRAT) |
| Query no. (field NUMRPT) |
| Simulation (field SIM) |
| Accounting date (field ACCDAT) |
| Chart code (field COA) |
| Account (field ACC) |
| Record type (field TYPREC) |
| Currency (field CUR) |
| Company (field CPY) |
| Journal date (field DATMAX) |
| Amount type (field TYPAMT) |
|
This field displays information for the journal entry and cannot be modified. |
| Accounting document |
|
Click this action to view the journal entry on the line. |
Specific actions
|
After you have entered your search criteria, select this action to extract the related VAT box information. If the Detail checkbox is selected, the VAT on debit detail and/or VAT on payment detail grids display all journal entries when you extract data. If this checkbox is cleared, no information displays in the respective grids. |
|
Select this action to view the VAT declaration numbers for the related extractions. A new screen opens that displays the declaration number, VAT entity, period, last extraction, and the user. The declarations shown depend on the information entered in the Header and limited by the periods that fall within the start and end dates. |