The [Import] dialogue is available only for the periods of the monthly VAT return and is not shown in the annual VAT return periods. Please note: if you want to use this dialogue, do not select the [Manual processing of VAT returns] when creating the company. Select the required period and company in order to view their [Import] dialogue.
...
.
RFBILA00 This report contains the financial balance sheet as well as the profit and loss account.
SAP-Reports
31 Dokument: Erstellung einer Textdatei für den Upload von Meldedaten aus SAP / ERP.
32 Näheres dazu, siehe Abschnitt [Stammdaten: Steuerkennzeichen: Anlegen der Steuerkennzeichen / Importieren der Steuerkennzeichen].
Status Information
The [Status Information] is used to display the imported reports V00, V10 and RFBILA. The respective report shows whether an import has been carried out, when and by which user.
The imported reports can also be displayed in the overview table below. The report can be selected via [Import Selection], it appears in the overview table. It is possible to see the most recent Import.
...
Import of reports
The reports can be imported manuallyimported manually, via a network a network drive (and fallback) or or via the web service. The import method used in the VAT@GTC is defined at the beginning of the Project.
Manual import
If the data are imported manually, select a report using the dropdown and the upload a locally saved document using the [Browse] button.
Netzwerk drive import
The reports are imported automatically via the network drive. Every time you click on the [Import] button, the VAT@GTC checks whether the reports are available in the corresponding folder. Please note that the file name of the report must be composed of a naming conventions defined in the current project and separated by underscores.
Art of reports | BuKr | Month | Year | Format |
|---|---|---|---|---|
Art Type of reports | BuKr | Month | Year | Format |
RFUMSV00 | e.g. 2000 | MM | JJJJ | .txt |
| RFUMSV10 | ||||
| RFBILA00 |
...
If the VAT@GTC recognises the available reports, they appear in the overview. Use the [New import data are available] to import the available reports into the VAT@GTC.
Fallback Import
If the network drive is temporarily not available, the [Fallback Import] option can be used. Select the report type, find it on your computer and Import.
...
If an error message relates not to the whole report, but only to certain positions of the report, this will be marked correspondingly in the position overview:
The 
The [Error] message means that something has gone wrong. The error must be corrected before continuing the work
There 
There may be errors related to this report position, e.g. if the accounts, contained in the RFBILA, are missing from the [Master data] main area. The error does not have to be corrected in order to continue the work.
No 
No plausibility errors in the report Position.
...
If all the items match, a green check mark [
] is displayed in the overview table for each line. .
If the import has been carried out successfully, the signs are adjusted as follows:
...
Normalcase | sign in report | Adjustment of the sign in the VAT@GTC | |
|---|---|---|---|
| Tax base & tax | The same sign | The same sign | |
| MWS/ESA | - | + | |
| VST/ESE | + | + | |
sign in report | Adjustment of the sign in the VAT@GTC | Special case I | sign in report | Adjustment of the sign in the VAT@GTC | |
|---|---|---|---|---|---|
Tax base&tax | The same sign | The same sign | |||
| MWS/ESA | + | - | |||
| VST/ESE | - | - |
If the signs of the tax base and tax are different, a coordination with AMANA must be carried out and parameters must be adapted in the master data area (special case).
Automatic correction
The
figure [Import process RFUMSV00] shows that an automatic correction [1]
has been made. The automatic correction setting can be made in the master data,
where it can be decided whether the tax base or tax is considered relevant. An
automatic correction is made if the tax base and tax do not correspond exactly.
It can also be specified in the [master data - reconciliations] to which value
the tax base or tax is to be adjusted[2],
in order to copy the adjusted value to the VAT return form and ensure that the
tax base and tax are identical.
...
To copy the values from the import correctly, a tax code mapping must be performed. Specify which tax codes are deductbile in the (Master Data:Tax Code) dialogue.
If the Checkbox has not been activated, only the (Output VAT) and (Input VAT) columns are taken into account in addition to the (Tax base). When this field is activated, the columns (Tax base), deductible Output tax) and (detuctible Input tax) are recorded.
Report RFUMSV10
The original report and the overview table in the VAT@GTC can be seen in thefollowing figure [Import process RFUMSV10]. The columns from [Company report.
...
If the import has been carried out successfully, the signs are adjusted as follows:
...
Normalcase
...
Sign in report
...
Normalcase | Vorzeichen im Report | Adjustment of the sign in the VAT@GTC | |
|---|---|---|---|
Tax base& Tax | The same sign | The same sign | |
| MWS / ESA | - | + | |
| VST / ESE | + | + |
...
Please note: There are no types of tax codes in the V10RFUMSV10. VAT@GTC takes them from the master data area.
Report RFBILA
The original report and the overview table in the VAT@GTC with the same columns can be seen in the following figure [Import process RFBILA00].
...
If an account is not saved in the master data, this is indicated by a [Warning ]. Nevertheless, import is possible. The accounts that are marked with a [Warning ] are not imported. If such warning is displayed, it is recommended to check whether this account has been newly added to SAP and if so, add it to the master data.
Sollte der Hinweis gegeben werden, ein Konto sei bereits importiert, so wird dieses Konto im RFBILA doppelt aufgeführt sein.
If the message is given that an account has already been imported, this account will be listed twice in the RFBILA.
