...

Table of Contents

maxLevel	2

...

Deck

id	Start

Card

label	22.00-22.10

In the reports area, there are various evaluations of the data from the VAT@GTC in the form of Excel reports. Clicking on the Excel symbol in the report table starts the creation of the report. The notification field opens at the top of the application and the user receives a message that the report is being created. While the report is being created, the user can continue to use VAT@GTC and even have other reports created. As soon as a commissioned report is ready, this can be viewed via the notification and the report can be downloaded from there. The report then disappears from the notifications.

Card

label	since 22.11

In the reports area, there are various evaluations of the data from the VAT@GTC in the form of Excel reports. Clicking on the Excel symbol in the report table starts the creation of the report. The notification field opens at the top of the application and the user receives a message that the report is being created. While the report is being created, the user can continue to use VAT@GTC and even have other reports created. The bin An X can be used to cancel the creation of a report or to delete a completed . A report that has already been completed but is not needed can be deleted via the bin symbol without downloading it. As soon as a commissioned report is finished, this can be seen via the notification and the report can be downloaded from there. The report then disappears from the notifications.

...

Deck

id	Tabelle

Card

label	22.00-22.05

ID	Report	Availability of the reports per country, company type or period type
ID	Report	Representative VAT group member	Consolidated VAT group member	VAT group member	Company Subdivision	Standalone	Preliminary Declaration	Annual Declaration	SPP	DE	Other countries
0	Annual VAT return
2	Variance analysis VAT values
4	Reporting values of all VAT group members per tax code
	Reporting values of all companies by mapped tax codes
6	Vat validation
7	Reporting relevant adjustments of the year
25	VAT Returns of the past 12 months
26	Special prepayment overview
28	Variance analysis VAT payment/refund
31	Deviation between current month and average of 12 previous months
35	Foreign Tax codes
36	Reporting values of all companies by tax codes
38	Value transfer from preliminary into annual VAT return
39	Clearing document
40	Total annual value of the preliminary VAT returns within the VAT group
41	Comparison annual VAT return/sum of preliminary VAT returns
45	Overview prepayment / payable
46	Preliminary / Annual VAT return in detail
47	Year summary of the VAT returns
48	Month overview
49	Plausibility of the tax amounts in the VAT report
50	Finance plan overview										Teilweise
51	All reporting values of the year
52	Data base for bookkeeping voucher

Card

label	22.06

ID	Report	Verfügbarkeit der Reports pro Land, Gesellschafts- und Periodentyp
ID	Report	OT	ZOT	OG	TG	STA	VA	JE	SVZ	DE	Ausland
0	Annual VAT return
2	Variance analysis VAT values
4	Reporting values of all companies by tax codes
6	Vat validation
7	Reporting relevant adjustments of the year
25	VAT Returns of the past 12 months
26	Special prepayment overview
28	Variance analysis VAT payment/refund
31	Deviation between current month and average of 12 previous months
35	Foreign Tax codes
36	Reporting values of all companies by tax codes
38	Value transfer from preliminary into annual VAT return
39	Clearing document
40	Total annual value of the preliminary VAT returns within the VAT group
41	Comparison annual VAT return/sum of preliminary VAT returns
45	Overview prepayment / payable
46	Preliminary / Annual VAT return in detail
47	Year summary of the VAT returns
48	Month overview
49	Plausibility of the tax amounts in the VAT report
50	Finance plan overview										It depends
51	All reporting values of the year
52	Data base for bookkeeping voucher

Card

label	since 22.07

ID	Report	Verfügbarkeit der Reports pro Land, Gesellschafts- und Periodentyp
ID	Report	OT	ZOT	OG	TG	STA	VA	JE	SVZ	DE	Ausland
0	Annual VAT return
1	Resubmissions of the year
2	Variance analysis VAT values
4	Reporting values of all companies by tax codes
6	Vat validation
7	Reporting relevant adjustments of the year
25	VAT Returns of the past 12 months
26	Special prepayment overview
28	Variance analysis VAT payment/refund
31	Deviation between current month and average of 12 previous months
35	Foreign Tax codes
36	Reporting values of all companies by tax codes
38	Value transfer from preliminary into annual VAT return
39	Clearing document
40	Total annual value of the preliminary VAT returns within the VAT group
41	Comparison annual VAT return/sum of preliminary VAT returns
45	Overview prepayment / payable
46	Preliminary / Annual VAT return in detail
47	Year summary of the VAT returns
48	Month overview
49	Plausibility of the tax amounts in the VAT report
50	Finance plan overview										Teilweise
51	All reporting values of the year
52	Data base for bookkeeping voucher

...

This report shows all resubmissions of all companies that play a role in the selected year and for which the user is authorised. This includes both resubmissions from previous years that were just booked in the current year and resubmissions that were created in the selected year and are either not yet booked or will be booked in the following year. The following columns are filled in for each resubmission:

Columns	Meaning
ID	ID of the resubmission
Unit-ID, Unit name, Company code, Unit type	Identification of the affected company
Created in period	Period in which the resubmission was created by a change made. This does not necessarily have to happen in the selected year of the report.
Deadline	The deadline by which the resubmission must be processed. Once a period that starts after the deadline is selected, this resubmission blocks the import if it is still open.
Status	The processing status of a resubmission can be either open or closed.
Posted in period	Period in which the resubmission was posted. This does not necessarily have to happen in the selected year of the report. For resubmissions for which "no posting necessary" was selected, "no posting necessary" is entered here. For open resubmissions, "no information available" is entered.
Resubmission type	Adjustments from the system always have "SAP-accounting entry" entered here. There are also deferred open reconciliations, tasks from the VAT-Audit and self-set reminders.
Base field, tax field	The fields that are affected by the resubmission.
Tax code, tax code form, tax rate, tax code description	Info about the tax code for which the resubmission was created.
Adjustment type	Either base or tax. If a resubmission concerns both sides, the side from which the resubmission was created is entered.
Basis of assessment, Tax	Value of the resubmission. If one of the entries is empty, the adjustment is only made to the opposite side.
Source	Resubmissions can result from manual adjustments in the declaration [MAN], or from adjustments by reconciliation, such as the automatic adjustment of the assessment base or tax from rounding differences [AUTO-AB1] , from manual reconciliation 1 [AB1], as well as other reconciliations (each AB + the number of the reconciliation).
SAP document-no.	When editing the resubmission, the SAP document number of the document with which the original adjustment was subsequently posted in SAP can optionally be entered here.
Created by, Creation date	The compliance stamp for generating the resubmission with user and time.
Changed by, change date	The compliance stamp for the last change to the resubmission with user and time.
Comment	The comment of the resubmission is already created when the manual adjustment is created and can be adjusted when editing the resubmission.

Variance analysis VAT values

...

If a yearly overview is desired in addition to this comparison, see the report "Deviation between current month and average of 12 previous months".

Tip

title	Good to know!

Deviation analysis is important to ensure the control of sales volumes. Based on the development of the tax base, it is possible to identify wrong entries. In addition, the report can be used to document business development. In addition to the above-mentioned information, the report contains a further worksheet with VAT group data.

...

All companies are listed in this report. Each VAT group has its own spreadsheet, and another spreadsheet summarises all the standalones. This report is similar to the Financial Plan Overview report, but also offers a data comparison. For this purpose, the current month is compared with the previous month and the difference is shown. Likewise, the current month is compared with the same month of the previous year and this difference is also documented.

Deviation between current month and average of 12 previous months

In this report, the reporting values of the last 12 periods are shown with a mean value deviation and configurable threshold value, divided into assessment basis and tax. If the threshold value for a field is exceeded, this is highlighted in red.

...

The following columns are created:

Company

Type of VAT group member

Company code

Import V00

Import V10

Import RFBILA

Reconciliations

VAT Return

Reporting period

Due dates VAT Return

VAT Return

Review before transfer

Review after VAT Return has been sent/payed

Tax payable / Refund

Last status change

User

Review

Last status change

User

Review

Last status change

User

Active

Successful

Incorrect

Plausibility of the tax amounts in the VAT report

...

The following columns are created:

Unit number

Unit name

Rec. result

Status

CC

Tax code

Tax code description

Tax code form

VAT rate from V00

Assessment base from VAT Return

VAT from VAT Return

Calculated Tax base

Calculated tax

initial difference base

initial difference tax

Base field

Tax field

Reconciliation executed at

Executed by

Finanzplanübersicht

This report contains a total overview of the tax payable and refund amounts for the period called up and how these are distributed among the individual companies. All companies stored in VAT@GTC are taken into account and added up. A spreadsheet is created for each VAT group, one for all standalones and another spreadsheet with all companies.

...

This report provides every single entry from all declarations from all companies over all periods of the year. All import values, manual adjustments, resubmissions and reconciliation corrections are taken into account. Especially if the year is far advanced, the report is filled with a lot of data and therefore needs a bit more time to be created. The following columns are filled in for each declaration value:

Company

Unit type

Representative VAT group member

Period name

Declaration field

Field type

Company code

Tax code

Tax code Type

Tax rate

Tax code description

Value

Source

Reference-ID

Correction

in OT correction

Timestamp

User

Comment

With the Excel filters, you can filter the report in many different ways, in order to possibly trace individual specific declaration values.

...

Using this function, it is possible to customise the layout of the reports created from VAT@GTC. With the help of a template, for example, the classic AMANA colours can be exchanged with the colours of the company, the font size and type of various cell types can be adapted, as well as own graphics and symbols can be incorporated into the header and AMANA elements can be removed. If a customisation of the report layout is desired, vat-support@amana.de will gladly provide the template and assist with the implementation.