Use this function to extract values for a VAT declaration using an existing VAT form created in the VAT form function. After you have extracted and validated the declaration, you can generate the file to submit to your tax authority.
This function is exclusive to the VAT framework process.
You can extract values in Simulation or Actual mode.
Simulations can be run for a VAT entity, for all or a single company, or for all or a single site. Values display in the Simulated value column in the VAT to declare and Detail by company grids. Each new simulation overwrites the previous.
Actual extractions can only be run for the VAT entity.
The reference date for VAT declaration extractions and all related processes, including journal entries and automatic journals, is defined by the DCLVATDAT - Date for tax declaration parameter (CPT chapter, VAT group) value. This can be the accounting date or the document date.
The VAT date can be updated in the Journal entries function as long as the journal entry to be updated has not been included in an actual declaration.
If you set up a print code linked to one or more reports for the VAT form, you can select a report from the Print button, List option. This is useful if your legislation requires multiple VAT return reports.
You can create a VAT return and extract values using an offline VAT form.
The VAT framework includes dedicated functions designed to facilitate calculating and validating VAT returns and generating the VAT preparatory report. For some legislations, you can submit directly from the VAT returns function. For specific legislations, there is a preset structure for VAT boxes and tax file generation that conforms to the respective tax laws. There is also a generic VAT declaration that can be customized for legislations not part of the framework.
Refer to the legislation how to guides for specific information.
Within the VAT framework, the company legislation and the VAT declaration process are separate.
Example
A company with a Belgian legislation may need for one of its sites to register for French VAT and to extract VAT on this site according to French fiscal authorities’ rules. You can do this by defining a dedicated VAT setup where the VAT declaration is set to DCLVATFRA and the legislation company is set to BEL.
This setup needs to contain the VAT boxes required by French fiscal authorities according to the 3310-CA3 declaration (as defined in standard setup for DCLVATFRA+FRA) and the corresponding mapping rules (with the document types and tax codes used in the Belgian site). And it has to be run on the VAT entity containing the site to declare in France.
In addition, the standard setup DCLVATBEL+BEL can be run on the VAT entity containing the sites of the Belgian company, except the site to declare in France.
The list of declarations that can take advantage of the VAT framework continues to grow. Additions are mentioned in the Sage X3 Release notes.
If your country/legislation is not yet included in the framework, you can use the Generic VAT declaration (DCLVATGEN) and manually set up VAT boxes and the VAT form.
Legislation presettings are delivered independent of the VAT reporting framework setup. A legislation presetting can include a dedicated VAT box structure, but that does not imply that you can use the remaining functions within the framework.
Except for the VAT boxes function, these functions are exclusive to declarations that are part of the framework. See the respective online help for each function for detailed information.
VAT boxes (not exclusive to the framework)
Use this function to create the VAT box structure for the declaration. If you select DCLVATGEN, you must select a legislation and manually create the required VAT box structure.
For all VAT declarations using the VAT framework. When setting up VAT boxes, the VAT box codes defined here must be the same when setting up the VAT form. This consistency must be respected for the automatic extraction of data for submission in the VAT returns function.
VAT entry groups (framework only)
Use this function to create an entry type group for a given legislation when setting up VAT declarations. In the VAT boxes function, you can use the entry group code for detail VAT boxes on a single line rather than entering multiple lines for detailed entry types. Entry type groups share the same Tax code + Tax management + Tax allocation combination.
VAT entities (framework only)
Use this function to create and manage VAT entities for a single or multiple companies or a single or multiple sites. VAT entities enable you to define distinct VAT returns at the site level.
VAT form (framework only)
Use this function to set up the VAT form for a specific legislation. You will use this form to create VAT returns. You can reuse the same form for different years, different VAT entities, etc. The VAT box codes defined for the VAT form must be consistent with the VAT boxes setup.
You can also use this function to enter a print code that links multiple VAT return reports that you can access from the VAT returns function.
Currently, only DCLVATBRI submits declarations to the British tax authority (HMRC) directly from the VAT returns function. For all other legislations, the VAT returns function extracts the data and generates a file or report that you need to submit manually to the respective tax authority.
VAT returns (framework only)
Use this function to set up and generate the VAT declaration for a VAT entity. You can extract data in simulation or actual mode. In simulation mode, you can extract for one or multiple companies or one or multiple sites. You can also run the preparatory report.
Use this function to extract data for multiple VAT entities in simulation or actual mode.
VATRETURNS (framework only)
This report can be accessed from the VAT returns function for simulated or actual extraction. It replaces the preparatory report functionality in the DCLVATBEL, DCLVATBRI, and DCLVATFRA functions.
| VAT declaration number (field VATENTNUM) |
|
This field automatically displays the VAT declaration number when you create a new VAT return and cannot be modified. |
| VAT form (field VATFRM) |
|
Enter the number for the VAT form created in the VAT form function (GESVEF). Only active forms can be used. |
| field DSPOFFLINE |
|
This indicates whether the current form is offline or online. |
| field DSPONLINE |
| Description (field DESTRA) |
|
This field displays the current VAT form description and cannot be modified. |
| Status (field STA) |
|
This field displays the VAT return status:
|
Block number 1
| Declaration (field VATFNC) |
|
This field displays the declaration for the current VAT form and cannot be modified. |
| Legislation (field LEG) |
|
This field displays the legislation for the current VAT form and cannot be modified. |
| VAT entity (field CODVATGRP) |
|
Enter the code for an existing VAT entity.
|
| Head member (field CPY) |
|
This field displays the company code for the Head member. If the Head member is a site, the site code also displays. |
| field HEAFCY |
| Company tax ID number (field CRN) |
|
This field displays the tax ID for the Head member, if relevant. If the country, such as Belgium, Spain, France, Italy, Poland, or Portugal, has a control script, the format control is enforced on this field or the EU VAT no. field.
|
| EU VAT no. (field EECNUM) |
|
For the VAT entity, this field displays the EU VAT no. for the Head member and cannot be modified. If the country, such as Belgium, Spain, France, Italy, Poland, or Portugal, has a control script, the format control is enforced on this field or the Company tax ID field. |
| Additional tax identifier (field ADLTAXID) |
|
For UK businesses, you can use this field to enter a VAT registration number that is more than nine digits. Note that only the EU VAT no. is used for submission to HMRC. |
If VAT posting is active for the VAT entity, the fields in this section are available. If not, the Posting status is Not managed and these fields are disabled.
Journal entries for VAT returns are posted using the VAT automatic journal. The journal entries offset the total VAT amount calculated for each company in the return into the Tax to disburse or the Tax credit accounts. The accounts are defined in the Accounting code lines function (GESCAC) for site and company entities.
| Launch VAT on debit (field VAT) |
|
This checkbox is selected or not based on the VAT period selection.
You can modify this value after you Create the VAT return, but after you Validate, no other modifications are possible. |
| Declaration start date (field STRDAT) |
|
The declaration start and end dates are used to filter the accounting entries by accounting dates or by original document dates, depending on the DCLVATDAT - Date for tax declaration parameter value (CPT chapter, VAT group). |
| Declaration end date (field ENDDAT) |
|
The declaration start and end dates are used to filter the accounting entries by accounting dates or by original document dates, depending on the DCLVATDAT - Date for tax declaration parameter value (CPT chapter, VAT group). |
| Include unextracted entries (field INCUNXENT) |
|
Select this checkbox to include entries that were not extracted for a previously submitted return and that are prior to the current declaration start date. |
| Starting from (field EXTSTRDAT) |
|
Enter a date to include unextracted entries from this date forward. This date must be before the declaration start date. |
VAT on payment
| Launch VAT on payment (field VATPAY) |
|
This checkbox is selected or not based on the VAT period selection. You can modify this value after you Create the VAT return, but after you Validate, no other modifications are possible. |
| Matching start date (field STRDAT2) |
|
This field displays the start date based on the VAT period selection. This includes journal entries whose matching dates fall within the matching start and end dates. Journal entries posted on accounts whose Tax management is set to Prepayment account are selected even if the journal entry line is not selected. You can modify this value after you Create the VAT return, but after you Validate, no other modifications are possible. |
| Matching end date (field ENDDAT2) |
|
This field displays the end date based on the VAT period selection. This includes journal entries whose matching dates fall within the matching start and end dates. Journal entries posted on accounts whose Tax management is set to Prepayment account are selected even if the journal entry line is not selected. You can modify this value after you Create the VAT return, but after you Validate, no other modifications are possible. |
| Due date until (field DATPCE) |
|
This field displays the due date based on the VAT period selection. Journal entries with due dates prior to or equal to this date are extracted. |
| Auxilliary postings only (field ECRAUX) |
|
Select this checkbox to restrict the entries that trigger the VAT declaration on payments to subsidiary records exclusively. The process eliminates as "payment" the matched accounting entry lines on the general accounts. For example, for the inter-currency reciprocal accounts. |
Generation criteria
| Generation (field TYPGEN) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The current generation type is Actual. You can run a simulation preparatory report in DCLVATBRI to review amounts before you Extract values. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| All companies (field ALLCPYSIM) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
In simulation mode only, you can select this checkbox to include all companies. This option does not apply to actual mode because an extraction in actual mode can only be run on the VAT entity.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Company (field CPYSIM) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
In simulation mode only, you can select this checkbox to include a single company. This option does not apply to actual mode because an extraction in actual mode can only be run on the VAT entity.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| All sites (field ALLFCYSIM) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
In simulation mode, you can select this option to include all financial sites in the extraction. In actual mode, you can only run the extraction on the VAT entity.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Site (field FCYSIM) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
In simulation mode, select a site depending on the VAT entity setup. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Simulation (PVWFLG) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
When you select this checkbox and select Post, you see a preview of the posted amounts in a temporary table. The general ledger is not updated. Clear this checkbox if you want to generate the actual VAT journal entries.
Tab VAT postingIf VAT posting is active for the VAT entity, the fields in this section are available. If not, the Posting status is Not managed and these fields are disabled. General settingsJournal entries for VAT returns are posted using the VAT automatic journal. The journal entries offset the total VAT amount calculated for each company in the return into the Tax to disburse or the Tax credit accounts. The accounts are defined in the Accounting code lines function for site and company entities. The calculation and posting are made by considering VAT amounts extracted on detail boxes of the VAT return. For a VAT entity with multiple companies or sites, you need to define the intercompany accounts used for journal entries in the Intercompany accounts mapping function, as well as the reciprocal accounts defined in chart of accounts setup. Settings for manual adjustmentsIf required, manual adjustments can create an additional journal entry line for the Head company of the VAT entity. To manage adjustments, you need to complete the following: 1. In the VAT form function, you need to select VAT boxes for the VAT due box, which holds the total submitted VAT amount due, and the Deductible VAT box, which holds the total submitted VAT deductible amount. Note: If you do not define these VAT boxes, adjustments are not taken into account and the related VAT adjustment balance is not posted. 2. In the Accounting code lines function, you need to define the adjustment account in the VAT adjustment balance modifier. This can be set at the company and/or the site level. Block number 2
Detail by company tabBlock number 1Management grid
Specific actions
Menu bar
Tab VAT to declareGrid Form
Block number 2
Tab Detail by companyBlock number 1
Specific actions
Menu bar
Error messagesThe only error messages are the generic ones. Tables usedRefer to documentation Implementation
|