...
| Table of Contents |
|---|
...
Twelve reconciliations are available for the creation of the monthly VAT returns. These reconciliations combine the imported files and detect possible inconsistencies.
...
| 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. | Zero balance verification |
Configuration of the reconciliations
...
There are two ways how reconciliation accounts are assigned to companies in VAT@GTC:
| Individual company | SAP system | |
|---|---|---|
| Assignment | Reconciliation accounts can be assigned to each company individually. | Reconciliation accounts can be assigned for all companies in an ERP group. |
| Dialogue | In the function bar, "- - -" must be selected under [SAP system]. | The relevant ERP group must be selected in the function bar under [SAP system]. |
| Display / Usage | If available, accounts that are specifically assigned to this company are displayed and used for the reconciliations of the company. If the company is assigned to an ERP group, the accounts of the ERP group, if any, are also displayed and used for the reconciliations of the company. | The accounts that are assigned to the ERP group are displayed. |
| Import / Create | If a single company is selected, the accounts will be created only for this company during import or creation. | If an ERP group is selected, the accounts are created for the ERP group during import or creation. |
| Edit / delete existing accounts | Company-specific accounts and accounts from the assigned ERP group are displayed, but only the company-specific accounts can be edited or deleted. | All accounts in the ERP group can be edited or deleted. |
The available SAP systems are preset in the admin area and can be assigned to each company in the master data settings.
...
For each reconciliation account 3 fields can be filled:
| Account number | The 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. |
| Description | An 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:
|
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.
...
In addition to the simple creation function, there is also the possibility to create a range of accounts. This function is useful when adding some new accounts that have the same account type and the account numbers are consecutive.
| Account number from | The lowest account number to be created must be specified here. An account is created for all account numbers that lie between [account number from] and [account number to]. |
| Account number to | The highest account number to be created must be specified here. An account is created for all account numbers that lie between [account number from] and [account number to]. |
| Description | Optionally, a description can be stored. This is stored uniformly for all account numbers. |
| Account type | The account type of the desired accounts must be specified here. This account type applies to all accounts to be created. |
Import of accounts
Since accounts are normally available in a very large number and can often already be pulled from the previous system as an Excel file, there is the possibility to import a CSV file with the accounts via [Import].
...