Use this function to extract and display the values for the German advance turn over tax return. The output of the calculated data can be printed or exported to the X3 ELSTER Client for online submission.

The data selection depends on the company or group of companies and the date range. The data is extracted from the main legal ledger, which must be in Euros.

SEEINFO The date range can only be a calendar month, a calendar quarter, or a calendar year. Generating the statement for a calendar year is only for internal reconciliation purposes, and it is not an official declaration time range.

These how to guide provides additional information:

German legislation guide

Germany and Austria VAT declarations guide

Prerequisites

SEEREFERTTO Reportez-vous à la documentation de Mise en oeuvre

Screen management

The calculated values from the data extraction display in two grids:

  • The Preview grid displays data by report line.
  • The VAT Line items grid displays details for the selected line in the Preview grid.

Header

Sélection

Groupe (champ GRP)

Enter a company group to extract values for the group.

Société (champ CPY)

Enter a company.

Législation (champ LEG)

This field displays the legislation for the selected company.

Site (champ FCY)

Enter a site for the selected company to limit the extraction to that site. This field is not available if you enter a company group.

Numéro de TVA (champ CRN)

This field displays the tax identifier for the company or company group.

Dép (champ DATDEB)

Enter a date rate to select records within those dates. The date range can only be a calendar month, a calendar quarter, or a calendar year. Generating the statement for a calendar year is only for internal reconciliation purposes, and it is not an official declaration time range.

Fin (champ DATFIN)
Devise (champ CURSEL)

This field displays the currency from main legal ledger.

Onglet Preview

The calculated values from the data extraction are shown grouped by report line. If a line is selected, the underlying documents are shown in the VAT Line items grid along with their details.

Tableau

Ligne état (champ REPLINE)

This field indicates the VAT report line (VAT box), for which the values of the following columns have been extracted.

This number corresponds to the entry field in the official VAT declaration form and links the VAT declaration to the tax rate. The available report lines are defined in the

Assiette fiscale (champ AMTVATBASE)

This field displays the assessment base for VAT report lines that are included.

Montant T.V.A. (champ AMTVAT)

This field displays the VAT amount for VAT report lines that are included.

Onglet VAT Line items

For the selected line in the Preview grid, the underlying documents display in this grid along with their details.

Tableau

Ligne état TVA (champ REFNO)

This field is display-only and cannot be modified.

Niveau de taxe (champ TAXNO)
Pièce (champ IVNUM)
Tiers (champ BPR)
Comptes généraux (champ ACC)
Extourne (champ OFFACC)
Mt devise locale (champ AMTLOC)
Sens (champ SNS)
Type de document (champ TYP)

This field is display-only and cannot be modified.

type de ligne (champ FLGVAT)
Règle d'imposition (champ VATIPT)

This field is display-only and cannot be modified.

Taux (champ VATRAT)

Utilisez ce champ pour indiquer le taux de taxe applicable à cette taxe.
Début valid. (champ STRDAT)

This field is display-only and cannot be modified.

Code plan (champ COA)
Entry

Select this action to open the associated journal entry.

Customer

Select this action to view details for this business partner.

Specific Buttons

You can export the data extraction as an XML-file for online submission with the X3 ELSTER Client or as a printed report.

Identification

Date début (champ DATDEB)

Enter the start date which the definition line is valid.

If there are changes to any of the activity codes for the same tax rule, the switch between the old and the new activity code can be handled by adding new lines with the new code and a corresponding start date.

Date fin (champ DATFIN)

Enter an end date for records to be include or the end date for the validity of an configuration entry.

Déposant (champ SUBMITTER)

This field displays the type of entity for VAT declaration.

Numéro TVA émetteur (champ CRN)

This field displays tax number for the VAT declaration submitter.

Déclaration TVA

Acompte 1/11 uniquement (champ DFV)

Select this checkbox to transmit an application for a 1/11 prepayment.

Case 23 : Compléments à prendre en compte (champ KNZ23)

Select this checkbox to be able to enter additional notes in the ELSTER online submission process.

Case 10 : déclaration corrective (champ KNZ10)

Select this checkbox to indicate a corrected VAT declaration that replaces a previously submitted for the same time range.

Case 22 : documents originaux envoyés séparément (champ KNZ22)

Select this checkbox to indicate that the original documents will be transferred separately. The transferring original documents is not managed in Sage X3.

Case 29 : refus exceptionnel du prélèvement agréé (champ KNZ29)

Select this checkbox to indicate that a balance offset could exist in the customer account with the German fiscal authorities.

Case 26 : crédit de TVA à reporter (champ KNZ26)

Select this checkbox to indicate that an exceptional cancellation of a direct debit agreement could exist with German fiscal authorities for tax payments.

Transmission

Type de destination (champ TYPEXP)

Select the download location for the ELSTER file:

  • Client
  • Server
Fichier répertoire ELSTER (champ VOLFIL)

If you selected Server for the file download location, you need to enter the directory.