Page Comparison

...

Table of Contents

...

Deck

id	desc

Card

label	22.00-22.06

Reconciliation	Function	Requirement
Reconciliation 1: Plausibility of VAT amounts in VAT report V00	This reconciliation checks the imported reporting data from RFUMSV00 for plausibility. Thereby the tax base is compared with the tax using the defined tax rate. In case of discrepancies, this reconciliation provides the possibility to store a limit for auto adjustments. Deviations up to this limit are automatically adjusted by the system during import and entered corrected in the declaration. Which side is adjusted in the process can be configured under [Settings → Countries → Edit → General information → Automatic correction].	Import of reported values from RFUMSV00 or Excel file
Reconciliation 2: Comparison of G/L account with VAT Return	The reconciliation 2 compares the VAT amount calculated in the VAT-Return has been really posted in the balance sheet as VAT payable.	RFBILA imported/ Value manually stored VAT payable account configured
Reconciliation 3: Differences between VAT reports V00 and V10	The reconciliation 3 compares the tax base of the reports RFUMSV00 and RFUMSV10 per tax code.	Import of RFUMSV00 and RFUMSV10
Reconciliation 4: Completeness check of revenue accounts	The reconciliation 4 filters the balance of the revenue accounts in the [Master data] main area of the RFBILA and compares them to the sums of tax bases, assigned to these accounts in the imported additional list to the monthly VAT return RFUMSV10. The aim of this reconciliation is to find out whether the bookings on the revenue accounts in the period are taken without the tax code. Reconciliation 4 is a typical reconciliation for SAP and other ERP systems that allow using more than one tax code on one account.	Import of RFUMSV10 and RFBILA Reconciliation 3 should be without errors Reconciliation accounts maintained
Reconciliation 5: Completeness check of expense accounts	The reconciliation 5 basically works in the same way as the reconciliation 4, with the only difference that the system compares the balance of the expense accounts from RFUMSV10 and RFBILA.	See Reconciliation 4
Reconciliation 6: Completeness check of balance sheet accounts	The reconciliation 6 basically works in the same way as the reconciliation 4, with the only difference that the system compares the amounts on the balance sheet accounts from RFUMSV10 and RFBILA.	See Reconciliation 4
Reconciliation 7: Plausibility check input Tax code	The reconciliation 7 filters all input tax codes from the imported RFUMSV10. The mapping - which type of tax code has a tax code - is taken from the tax code in the [Master data] main area. After that the system checks, which accounts are booked with this tax code and compares the list of accounts with the reconciliation accounts in VAT@GTC.	Import of RFUMSV10 Reconciliation 3 should be without errors Reconciliation accounts maintained
Reconciliation 8: Plausibility check output Tax code	The reconciliation 8 basically functions in the same way as the reconciliation 7 with the only difference that the system filters output tax codes and the corresponding expense accounts and compares them to the accounts in the VAT@GTC.	See Reconciliation 7
Reconciliation 9: Reconciliation with ESL	The reconciliation 9 identifies whether the reported values in the ESL match to the values in the monthly VAT return.	ESL filed with VAT@GTC
Reconciliation 10: Deviation from the mean of the last 12 months	Reconciliation 10 can be configured per field and calculates the mean value of the last 12 months and is used across years. If the current value deviates from the mean value of the 12 previous months by more than a value or percentage defined in the configuration of the reconciliation, this reconciliation reports an error.	Only useful if the fiscal year is consistent.
Reconciliation 12: Plausibility check for reverse charge	The reconciliation 12 controls whether the tax value that applies to the reverse charge turnover matches the value in the input tax field that is applicable to the reverse charge turnover.	Declaration info is imported
Reconciliation 13: Plausibility check intra-comunity acquisitions / Inputtax	The reconciliation 13 controls whether the tax value that is applied to the intra-community acquisitions matches the value of the input tax that is applicable to the intra-community acquisitions.	Declaration info is imported
Reconciliation 14: Zero balance validation of G/L accounts	Reconciliation 14 checks whether there is a zero balance on the deposited accounts.	Import RFBILA

Tip

title	Good to know

Companies whose values are entered manually can only perform reconciliation 9.

Card

label	since 22.07

Reconciliation	Function	Requirement
Reconciliation 1: Plausibility of VAT amounts in VAT report V00	This reconciliation checks the imported reporting data from RFUMSV00 for plausibility. Thereby the tax base is compared with the tax using the defined tax rate. In case of discrepancies, this reconciliation provides the possibility to store a limit for auto adjustments. Deviations up to this limit are automatically adjusted by the system during import and entered corrected in the declaration. Which side is adjusted in the process can be configured under [Settings → Countries → Edit → General information → Automatic correction].	Import of reported values from RFUMSV00 or Excel file
Reconciliation 2: Comparison of G/L account with VAT Return	The reconciliation 2 compares the VAT amount calculated in the VAT-Return has been really posted in the balance sheet as VAT payable.	RFBILA imported/ Value manually stored VAT payable account configured
Reconciliation 3: Differences between VAT reports V00 and V10	The reconciliation 3 compares the tax base of the reports RFUMSV00 and RFUMSV10 per tax code.	Import of RFUMSV00 and RFUMSV10
Reconciliation 4: Completeness check of revenue accounts	The reconciliation 4 filters the balance of the revenue accounts in the [Master data] main area of the RFBILA and compares them to the sums of tax bases, assigned to these accounts in the imported additional list to the monthly VAT return RFUMSV10. The aim of this reconciliation is to find out whether the bookings on the revenue accounts in the period are taken without the tax code. Reconciliation 4 is a typical reconciliation for SAP and other ERP systems that allow using more than one tax code on one account.	Import of RFUMSV10 and RFBILA Reconciliation 3 should be without errors Reconciliation accounts maintained
Reconciliation 5: Completeness check of expense accounts	The reconciliation 5 basically works in the same way as the reconciliation 4, with the only difference that the system compares the balance of the expense accounts from RFUMSV10 and RFBILA.	See Reconciliation 4
Reconciliation 6: Completeness check of balance sheet accounts	The reconciliation 6 basically works in the same way as the reconciliation 4, with the only difference that the system compares the amounts on the balance sheet accounts from RFUMSV10 and RFBILA.	See Reconciliation 4
Reconciliation 7: Plausibility check input Tax code	The reconciliation 7 filters all input tax codes from the imported RFUMSV10. The mapping - which type of tax code has a tax code - is taken from the tax code in the [Master data] main area. After that the system checks, which accounts are booked with this tax code and compares the list of accounts with the reconciliation accounts in VAT@GTC.	Import of RFUMSV10 Reconciliation 3 should be without errors Reconciliation accounts maintained
Reconciliation 8: Plausibility check output Tax code	The reconciliation 8 basically functions in the same way as the reconciliation 7 with the only difference that the system filters output tax codes and the corresponding expense accounts and compares them to the accounts in the VAT@GTC.	See Reconciliation 7
Reconciliation 9: Reconciliation with ESL	The reconciliation 9 identifies whether the reported values in the ESL match to the values in the monthly VAT return.	ESL filed with VAT@GTC
Reconciliation 10: Deviation from the mean of the last 12 months	Reconciliation 10 can be configured per field and calculates the mean value of the last 12 months and is used across years. If the current value deviates from the mean value of the 12 previous months by more than a value or percentage defined in the configuration of the reconciliation, this reconciliation reports an error.	Only useful if the fiscal year is consistent.
Reconciliation 12: Plausibility check for reverse charge	The reconciliation 12 controls whether the tax value that applies to the reverse charge turnover matches the value in the input tax field that is applicable to the reverse charge turnover.
Reconciliation 13: Plausibility check intra-comunity acquisitions / Inputtax	The reconciliation 13 controls whether the tax value that is applied to the intra-community acquisitions matches the value of the input tax that is applicable to the intra-community acquisitions.
Reconciliation 14: Zero balance validation of G/L accounts	Reconciliation 14 checks whether there is a zero balance on the deposited accounts.	Import RFBILA

Tip

title	Good to know

Companies whose values are entered manually can perform reconciliation 9,10,12 and 13.

...

The reconciliations are configured in the tabular overview, since the setting options are basically the same.

Deck

id	config

Card

label	22.00-22.02

Execute [the reconciliations] for VAT returns or annual returns	Image Modified By activating this checkbox, the corresponding reconciliation can be executed for the creation of the preliminary VAT return (month or quarter). Image Modified The reconciliation will not be executed for the preliminary VAT return in the selected period for the selected company.
Execute ESL	Is relevant only for the reconciliation 9 [Reconciliation with ESL]. Further Details in the next section [Configuration of Reconciliation 9] Image Modified When the checkbox is activated the reconciliation will be executed for the ESL. Image Modified If the checkbox is left unmarked the reconciliation will not be executed for the ESL in the selected period for a certain company.
Mandatory	If the reconciliation will be executed for the monthly or annual VAT return, define whether its execution is mandatory. For time reasons during the VAT return creation process, it can be reasonable to mark the reconciliations as not mandatory. Image Modified If the checkbox is activated, this reconciliation has to be performed successfully before the VAT return can be finalised and sent. Image Modified If the checkbox is left unmarked, it is possible either not to execute the reconciliation at all or ignore the eventual errors. In both cases, it is possible to finalize the VAT return. In any case, this will be saved to the “Resubmission”.
Manually	This field relates only to the filed 2 [Comparison of G/L account with VAT return]. It is relevant when this reconciliation is to be performed for the monthly or annual VAT returns without importing the RFBILA. Image Modified If the checkbox is activated, the VAT@GTC knows that the G/L account VAT to pay or recover data cannot be read from the balance sheet (e.g. since the RFBILA has not been imported or the tax accounts have been closed via the G/L account VAT to pay or recover). As a result, there is a field for the manual input of the G/L account VAT to pay or recover balance in the [Import] dialogue. Here the user can enter the value of the G/L account VAT to pay or recover. It is important to create the G/L account VAT to pay or recover in the VAT@GTC [Master data] main area before that. Image Modified If the checkbox is left unmarked, the reconciliation 2 is performed, using the data from the RFBILA report. In this case, it is necessary to create the G/L account VAT to pay or recover in the [Manage reconciliation accounts] sub-dialogue.
Tolerance limit (EUR) tax amount	This parameter is irrelevant for the reconciliations 7 and 8 [Plausibility check input tax code] and [Plausibility check output tax code], so that no entry is possible for these reconciliations. The user can define the tolerance limit [EUR] when the reconciliation can still be considered correct. The setting can be used to deal with the rounding differences. The tolerance limit applies to one row of the current reconciliation. If the reconciliation value is at or below the tolerance limit, the reconciliation is considered successful, but a warning appears. If the reconciliation value is over the defined tolerance limit, the reconciliation fails. No entry means that there is no tolerance limit. Even the tiniest deviation results in an error.
Tolerance limit (in %)	The tolerance limit in % is used only for the reconciliation 9 [Reconciliation with ESL]. Due to different rounding procedures, higher variances often occur between the values in the VAT return and those in the european sales list. It can therefore be useful to specify a percentage tolerance limit. Variances within this tolerance are not displayed as reconciliation errors. A numbered tolerance limit can be entered aswell. However, only one of the two limits should be specified.
Limit for autom. corrections (EUR)	The defined limit is used for reconciliation 1 [Plausibility of VAT amounts in VAT report VOO] in order to carry out an automatic adjustment to the tax base or tax, depending on the settings made in the country dialogue.
Hide all zero values for RFUMSV10 and RFBILA	Checking this option hides all accounts in the respective reconciliation for which both the value in RFBILA is 0 and there is also no entry in RFUMSV10. By checking this option, the result of the respective reconciliation is slimmed down so that rows without values are no longer displayed. This usually concerns accounts that are not relevant for VAT and that are never posted to with tax codes.
Hide all zero values for RFUMSV10	Checking this option hides all accounts in the respective reconciliation for which there is no entry in RFUMSV10. By checking this option, the result of the respective reconciliation is slimmed down so that rows without values are no longer displayed. This usually concerns accounts that are not relevant for VAT and that are never posted to with tax codes.

Card

label	22.03-22.05

Execute [the reconciliations] for VAT returns or annual returns	Image Added By activating this checkbox, the corresponding reconciliation can be executed for the creation of the preliminary VAT return (month or quarter). Image Added The reconciliation will not be executed for the preliminary VAT return in the selected period for the selected company.
Execute ESL	Is relevant only for the reconciliation 9 [Reconciliation with ESL]. Further Details in the next section [Configuration of Reconciliation 9] Image Added When the checkbox is activated the reconciliation will be executed for the ESL. Image Added If the checkbox is left unmarked the reconciliation will not be executed for the ESL in the selected period for a certain company.
Mandatory	If the reconciliation will be executed for the monthly or annual VAT return, define whether its execution is mandatory. For time reasons during the VAT return creation process, it can be reasonable to mark the reconciliations as not mandatory. Image Added If the checkbox is activated, this reconciliation has to be performed successfully before the VAT return can be finalised and sent. Image Added If the checkbox is left unmarked, it is possible either not to execute the reconciliation at all or ignore the eventual errors. In both cases, it is possible to finalize the VAT return. In any case, this will be saved to the “Resubmission”.
Manually	This field relates only to the filed 2 [Comparison of G/L account with VAT return]. It is relevant when this reconciliation is to be performed for the monthly or annual VAT returns without importing the RFBILA. Image Added If the checkbox is activated, the VAT@GTC knows that the G/L account VAT to pay or recover data cannot be read from the balance sheet (e.g. since the RFBILA has not been imported or the tax accounts have been closed via the G/L account VAT to pay or recover). As a result, there is a field for the manual input of the G/L account VAT to pay or recover balance in the [Import] dialogue. Here the user can enter the value of the G/L account VAT to pay or recover. It is important to create the G/L account VAT to pay or recover in the VAT@GTC [Master data] main area before that. Image Added If the checkbox is left unmarked, the reconciliation 2 is performed, using the data from the RFBILA report. In this case, it is necessary to create the G/L account VAT to pay or recover in the [Manage reconciliation accounts] sub-dialogue.
Tolerance limit (EUR) tax amount	This parameter is irrelevant for the reconciliations 7 and 8 [Plausibility check input tax code] and [Plausibility check output tax code], so that no entry is possible for these reconciliations. The user can define the tolerance limit [EUR] when the reconciliation can still be considered correct. The setting can be used to deal with the rounding differences. The tolerance limit applies to one row of the current reconciliation. If the reconciliation value is at or below the tolerance limit, the reconciliation is considered successful, but a warning appears. If the reconciliation value is over the defined tolerance limit, the reconciliation fails. No entry means that there is no tolerance limit. Even the tiniest deviation results in an error.
Tolerance limit (in %)	The tolerance limit in % is used only for the reconciliation 9 [Reconciliation with ESL]. Due to different rounding procedures, higher variances often occur between the values in the VAT return and those in the european sales list. It can therefore be useful to specify a percentage tolerance limit. Variances within this tolerance are not displayed as reconciliation errors. A numbered tolerance limit can be entered aswell. However, only one of the two limits should be specified.
Limit for autom. corrections (EUR)	The defined limit is used for reconciliation 1 [Plausibility of VAT amounts in VAT report VOO] in order to carry out an automatic adjustment to the tax base or tax, depending on the settings made in the country dialogue.
Hide all zero values for RFUMSV10 and RFBILA	Checking this option hides all accounts in the respective reconciliation for which both the value in RFBILA is 0 and there is also no entry in RFUMSV10. By checking this option, the result of the respective reconciliation is slimmed down so that rows without values are no longer displayed. This usually concerns accounts that are not relevant for VAT and that are never posted to with tax codes.
Hide all zero values for RFUMSV10	Checking this option hides all accounts in the respective reconciliation for which there is no entry in RFUMSV10. By checking this option, the result of the respective reconciliation is slimmed down so that rows without values are no longer displayed. This usually concerns accounts that are not relevant for VAT and that are never posted to with tax codes.
Consider input tax positions	You can select whether only the output VAT values should be checked in reconciliation 1 or whether input VAT values should also be checked. The check mark is set in Germany by default.

Card

label	Since 22.06

Execute [the reconciliations] for VAT returns or annual returns	Image Added By activating this checkbox, the corresponding reconciliation can be executed for the creation of the preliminary VAT return (month or quarter). Image Added The reconciliation will not be executed for the preliminary VAT return in the selected period for the selected company.
Execute ESL	Is relevant only for the reconciliation 9 [Reconciliation with ESL]. Further Details in the next section [Configuration of Reconciliation 9] Image Added When the checkbox is activated the reconciliation will be executed for the ESL. Image Added If the checkbox is left unmarked the reconciliation will not be executed for the ESL in the selected period for a certain company.
Mandatory	If the reconciliation will be executed for the monthly or annual VAT return, define whether its execution is mandatory. For time reasons during the VAT return creation process, it can be reasonable to mark the reconciliations as not mandatory. Image Added If the checkbox is activated, this reconciliation has to be performed successfully before the VAT return can be finalised and sent. Image Added If the checkbox is left unmarked, it is possible either not to execute the reconciliation at all or ignore the eventual errors. In both cases, it is possible to finalize the VAT return. In any case, this will be saved to the “Resubmission”.
Manually	This field relates only to the filed 2 [Comparison of G/L account with VAT return]. It is relevant when this reconciliation is to be performed for the monthly or annual VAT returns without importing the RFBILA. Image Added If the checkbox is activated, the VAT@GTC knows that the G/L account VAT to pay or recover data cannot be read from the balance sheet (e.g. since the RFBILA has not been imported or the tax accounts have been closed via the G/L account VAT to pay or recover). As a result, there is a field for the manual input of the G/L account VAT to pay or recover balance in the [Import] dialogue. Here the user can enter the value of the G/L account VAT to pay or recover. It is important to create the G/L account VAT to pay or recover in the VAT@GTC [Master data] main area before that. Image Added If the checkbox is left unmarked, the reconciliation 2 is performed, using the data from the RFBILA report. In this case, it is necessary to create the G/L account VAT to pay or recover in the [Manage reconciliation accounts] sub-dialogue.
Tolerance limit (EUR) tax amount	This parameter is irrelevant for the reconciliations 7 and 8 [Plausibility check input tax code] and [Plausibility check output tax code], so that no entry is possible for these reconciliations. The user can define the tolerance limit [EUR] when the reconciliation can still be considered correct. The setting can be used to deal with the rounding differences. The tolerance limit applies to one row of the current reconciliation. If the reconciliation value is at or below the tolerance limit, the reconciliation is considered successful, but a warning appears. If the reconciliation value is over the defined tolerance limit, the reconciliation fails. No entry means that there is no tolerance limit. Even the tiniest deviation results in an error.
Tolerance limit (in %)	The tolerance limit in % is used only for the reconciliation 9 [Reconciliation with ESL]. Due to different rounding procedures, higher variances often occur between the values in the VAT return and those in the european sales list. It can therefore be useful to specify a percentage tolerance limit. Variances within this tolerance are not displayed as reconciliation errors. A numbered tolerance limit can be entered aswell. However, only one of the two limits should be specified.
Limit for autom. corrections (EUR)	The defined limit is used for reconciliation 1 [Plausibility of VAT amounts in VAT report VOO] in order to carry out an automatic adjustment to the tax base or tax, depending on the settings made in the country dialogue.
Hide all zero values for RFUMSV10 and RFBILA	Checking this option hides all accounts in the respective reconciliation for which both the value in RFBILA is 0 and there is also no entry in RFUMSV10. By checking this option, the result of the respective reconciliation is slimmed down so that rows without values are no longer displayed. This usually concerns accounts that are not relevant for VAT and that are never posted to with tax codes.
Hide all zero values for RFUMSV10	Checking this option hides all accounts in the respective reconciliation for which there is no entry in RFUMSV10. By checking this option, the result of the respective reconciliation is slimmed down so that rows without values are no longer displayed. This usually concerns accounts that are not relevant for VAT and that are never posted to with tax codes.
Consider input tax positions	You can select whether only the output VAT values should be checked in reconciliation 1 or whether input VAT values should also be checked. The check mark is set in Germany by default.
Resubmissions to no booking	If this box is ticked, then the resubmissions resulting from the automatic adjustment of reconciliation 1, i.e. those adjustments below the tolerance limit that can also be configured in this table, are automatically set to not to be posted. Usually, these are rounding differences that will probably not be adjusted in the ERP system.

All master data settings in this dialogue are saved for the selected company in the selected period. A mass import of the master data settings is not intended for reconciliations. When a period is created based on another period, master data settings of the reconciliations are taken into account.

...

Versions Compared

Old Version 63

New Version 64

Key