...
| Table of Contents |
|---|
...
| 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 |
...
An account that appears multiple times in a large import file | The account will be imported only the first time, all further entries will be ignored. These accounts should be checked again in the file and in VAT@GTC. |
An incorrect structure of the file: Lines are not valid | The file type could be recognized by the VAT@GTC, but the record is not complete. The import failed in this respect. |
The filetype is wrong | The file type could not be interpreted by the VAT@GTC. A txt or CSV file is required. |
...
Export of accounts
There are three different export functions for the reconciliation accounts. For each function, a file is created in exactly the same format that can be read in by the VAT@GTC during import:
- [Export]: This function exports all accounts that correspond to the current allocation. If, for example, company 1000 is selected, which is assigned to the ERP system ERP1, accounts from both assignments are shown in the overview. However, only the accounts that belong to the company are actually exported. You can recognise these accounts in the overview because they can be edited and deleted. If, however, an ERP group is selected under Assignment ERP, then only the accounts of the ERP group are displayed and also exported.
- [Export all pages to CSV-file]: Here, all accounts that are currently displayed are exported, including the accounts that are in further pages. On the one hand, the display of the accounts can be combined from accounts of the company and accounts of the ERP group, on the other hand, the accounts can also be filtered by filtering on the account type or by entering a search term.
- [Export to CSV file]: Here, only the accounts that are on the currently displayed page are exported. On the one hand, the display of the accounts can be combined from accounts of the company and accounts of the ERP group, on the other hand, the accounts can also be filtered by filtering on the account type or by entering a search term.
If no data sets have been created yet, the exported CSV file is empty.
...