...
| Table of Contents |
|---|
...
| Preliminary VAT return | from RFUMSV00 |
| Additional data on preliminary VAT return | from RFUMSV10 |
| Balance sheet / profit and loss account | from RFBILA00 |
...
...
| 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. |
...
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 | ||
|---|---|---|
| ||
Companies whose values are entered manually can onlyperform reconciliation 9,10,12 and 13. Card | | |
| ||
| 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 | ||
|---|---|---|
| ||
Companies whose values are entered manually can perform reconciliation 9,10,12 and 13. |
Configuration of the reconciliations
General configuration
The reconciliations are configured in the tabular overview, since the setting options are basically the same.
...
| id | config |
|---|
...
| label | 22.00-22.02 |
|---|
...
Execute [the reconciliations] for VAT returns or annual returns
...
By activating this checkbox, the corresponding reconciliation can be executed for the creation of the preliminary VAT return (month or quarter).
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]
When the checkbox is activated the reconciliation will be executed for the ESL.
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.
If the checkbox is activated, this reconciliation has to be performed successfully before the VAT return can be finalised and sent.
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.
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.
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.
...
| label | 22.03-22.05 |
|---|
...
Execute [the reconciliations] for VAT returns or annual returns
...
By activating this checkbox, the corresponding reconciliation can be executed for the creation of the preliminary VAT return (month or quarter).
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]
When the checkbox is activated the reconciliation will be executed for the ESL.
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.
If the checkbox is activated, this reconciliation has to be performed successfully before the VAT return can be finalised and sent.
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.
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.
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.
...
Configuration of the reconciliations
General configuration
The reconciliations are configured in the tabular overview, since the setting options are basically the same.
Execute [the reconciliations] for VAT returns or annual returns |
|
Execute ESL | Is relevant only for the reconciliation 9 [Reconciliation with ESL]. Further Details in the next section [Configuration of Reconciliation 9]
|
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.
|
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.
|
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.
...