Versions Compared

Old Version 59

changes.mady.by.user Tina Sunjic

Saved on

compared with

New Version 60

changes.mady.by.user Lukas Schwalvenberg

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


...

Table of Contents

...

ReconciliationFunctionRequirement

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 accountsReconciliation 14 checks whether there is a zero balance on the deposited accounts.Zero balance verification

...

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.

...

Hide all zero values for RFUMSV10 and RFBILAChecking 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.
Hide all zero values for RFUMSV10Checking 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.

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.

...

In order to calculate the average value of the last 12 months across the year, a field Position must be specified for which this is to be done. With tolerance limit, the amount or percentage by which the value may vary across months can be specified. Only one of the two variants can be specified. Only one of the two variants can be selected. If both tolerance limits are configured, only the percentage tolerance limit is appliedbe selected. If both tolerance limits are configured, only the percentage tolerance limit is applied.

Configuration of Reconciliation 14

For reconciliation 14, it must be deposited which accounts are to be checked that they have a zero balance. This can be configured under [Manage reconciliation accounts].

Manage reconciliation accounts

...

Account numberThe name of the account from SAP. This field is a mandatory field. This field can be filled with up to 10 digits and is always completed with leading 0s to 10 digits.
DescriptionAn optional description of the account. The description of the account from SAP should be entered here for better transparency.
Account type

There are 5 account types that can be selected:

  • Asset account: Accounts that are stored in VAT@GTC as asset account are taken into account in reconciliation 6 [Completeness check balance sheet accounts].
  • Liability account: Accounts that are stored in VAT@GTC as liability account are taken into account in reconciliation 6 [Completeness check balance sheet accounts].
  • Expense account: Accounts that are stored in VAT@GTC as expense accounts are considered in reconciliation 5, 7 and 8.
  • Revenue account: Accounts that are stored in VAT@GTC as revenue accounts are taken into account in reconciliation 4, 7 and 8.
  • Tax payable account: There can be only one tax payable account per company. The VAT payable should be posted to this account. It is used for reconciliation 2 to match the posted tax payable and the calculated tax payable in the declaration.
Zero balance G/L accountsIf this tick is set, this account will be reconciled via reconciliation 14.

Click on the [Save] button to save all the entries. When exiting the page without clicking on the [Save] button, all the entries will be discarded. After a reconciliation account has been created, only the description can be changed.

...