Page Comparison

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].

Reconciliation 2: Comparison of G/L account with VAT Return

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. 

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.

Reconciliation 5: Completeness check of expense accounts

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.

Reconciliation 7: Plausibility check input Tax code

Reconciliation 8: Plausibility check output Tax code

Reconciliation 9: Reconciliation with ESL

Reconciliation 10: Deviation from the mean of the last 12 months

Reconciliation 12: Plausibility check for reverse charge

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.

    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.

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.

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”.

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. 

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.

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.