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