Procedure documentationCustomizing for Periodic VAT Returns

Procedure

Settings for Electronic Data Transmission to Authorities
  1. Start the SPRO transaction to access the SAP Customizing Implementation Guide.

  2. Open the Make Settings for Electronic Communication with Authorities Customizing activity.

    You find this activity in the Customizing for Financial Accounting under Start of the navigation path General Ledger Accounting Next navigation step Periodic Processing Next navigation step Report Next navigation step Electronic Communication with Authorities Next navigation step Make Settings for Electronic Communication with Authorities End of the navigation path.

    If you have not activated the New General Ledger, the path is as follows: Start of the navigation path General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Report Next navigation step Electronic Communication with Authorities Next navigation step Make Settings for Electronic Communication with Authorities End of the navigation path.

  3. Enter 0001 as the return type.

  4. Ensure that the following values are available in this Customizing view:

    Field

    Value

    Dominant Enterprise (Dom. Enterp)

    Enter the company code of the entity for which the VAT return is being generated.

    Reporting Country (Rep. Cntry)

    Enter LU.

    Transfer Type of Electronic Data Transmission (BCXI)

    Select DO - Download (No Transfer).

    You must download the XML file and then import it manually into the eTVA-application run by the tax authorities.

    Transfer

    Leave the checkbox unselected.

    Period

    Select the period that you need, for example, 01 Month.

  5. Save your entries.

  6. Open the Define Parameters for Electronic Communication with Authorities Customizing activity.

    You find this activity in the Customizing for Financial Accounting under Start of the navigation path General Ledger Accounting Next navigation step Periodic Processing Next navigation step Report Next navigation step Electronic Communication with Authorities Next navigation step Define Parameters for Electronic Communication with Authorities End of the navigation path.

    If you have not activated the New General Ledger, the path is as follows: Start of the navigation path General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Report Next navigation step Electronic Communication with Authorities Next navigation step Define Parameters for Electronic Communication with Authorities End of the navigation path.

  7. Enter the following:

    • 0001 as the return type

    • Company code of the dominant enterprise for which the return is being generated

    • LU as the reporting company

  8. Ensure that the correct values have been entered for the parameters in this Customizing view. For more information about the values to be entered, see SAP Note 2111084Information published on SAP site.

  9. Save your entries.

Settings for Data Extraction and Reporting
  1. Start the SPRO transaction to access the SAP Customizing Implementation Guide.

  2. Open the Define Tax Codes for Sales and Purchases Customizing activity and ensure that you have created all necessary VAT codes with the corresponding percentage rates and G/L account assignment.

    You find this activity in the Customizing for Financial Accounting under Start of the navigation path Financial Accounting Global Settings Next navigation step Tax on Sales/Purchases Next navigation step Calculation Next navigation step Define Tax Codes for Sales and Purchases End of the navigation path. Alternatively, use the FTXP transaction.

  3. Open the Define a Tax on Sales/Purchases Group Customizing activity.

    You find this activity in the Customizing for Financial Accounting under Start of the navigation path General Ledger Accounting Next navigation step Periodic Processing Next navigation step Report Next navigation step Sales/Purchases Tax Returns Next navigation step Define Tax on Sales/Purchases Groups End of the navigation path.

    If you have not activated the New General Ledger, the path is as follows: Start of the navigation path General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Report Next navigation step Sales/Purchases Tax Returns Next navigation step Taxes on Sales/Purchases Groups Next navigation step Define Tax on Sales/Purchases Groups End of the navigation path.

    The tax on sales/purchases group corresponds to the entity that is subject to VAT and for which, consequently, a VAT return needs to be generated. A tax on sales/purchases group can be either a single legal entity (for example, a company code) or a group of legal entities.

    In this Customizing activity, you enter a dominant enterprise (company code) for the tax on sales/purchases group. This is required for technical reasons; there is no impact on the VAT return itself. The program used for managing the amounts for the VAT return does so based on this company code.

    Note that you can generate a periodic VAT return without defining a tax on sales/purchases group if the VAT return is for only one single legal entity (company code). If you do not define such a tax on sales/purchases group in Customizing, the RFUMSV00 program can use the company code entered on the selection screen for its data extraction.

  4. After defining a tax on sales/purchases group, open the Assign Company Code(s) to a Tax on Sales/Purchases Group Customizing activity and group the company codes that should be considered as the taxable entity.

    You find this activity in the Customizing for Financial Accounting under Start of the navigation path General Ledger Accounting Next navigation step Periodic Processing Next navigation step Report Next navigation step Sales/Purchases Tax Returns Next navigation step Assign Company Codes to Tax on Sales/Purchases Groups End of the navigation path.

    If you have not activated the New General Ledger, the path is as follows: Start of the navigation path General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Report Next navigation step Sales/Purchases Tax Returns Next navigation step Taxes on Sales/Purchases Groups Next navigation step Assign Company Codes to Tax on Sales/Purchases Groups End of the navigation path.

  5. Open the Assign Tax Group Version Time-Dependent Customizing activity, create the tax group(ing) version and enter from which date this version is to be used. These values are stored in the T007Z database table.

    You find this activity in the Customizing for Financial Accounting under Start of the navigation path General Ledger Accounting Next navigation step Periodic Processing Next navigation step Report Next navigation step Sales/Purchases Tax Returns Next navigation step Assign Tax Group Version Time-Dependent End of the navigation path.

    If you have not activated the New General Ledger, the path is as follows: Start of the navigation path General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Report Next navigation step Sales/Purchases Tax Returns Next navigation step Assign Tax Group Version Time-Dependent End of the navigation path.

    The From Date defines the date from which the appropriate periodic VAT return can be generated by the system. Note that it is important that you check and adapt, as necessary, the entries that were copied by the system into the T007K_LU and T007L_LU database tables for the new tax group version. This is explained in the following steps.

  6. Open the Group Tax Base Balances Customizing activity with LU as the country key and the tax group(ing) version from the previous Customizing activities. The settings made in this activity are stored in the T007K_LU database table. Note that prior to January 2015, these values were stored in the T007K table.

    You find this activity in the Customizing for Financial Accounting under Start of the navigation path General Ledger Accounting Next navigation step Periodic Processing Next navigation step Report Next navigation step Statutory Reporting: Luxembourg Next navigation step Group Tax Base Balances End of the navigation path.

    If you have not activated the New General Ledger, the path is as follows: Start of the navigation path General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Report Next navigation step Statutory Reporting: Luxembourg Next navigation step Group Tax Base Balances End of the navigation path.

    In the T007K_LU table, you define the mapping between VAT codes and the VAT boxes on your periodic VAT return for the tax base amounts.

  7. Open the Group Tax Balances Customizing activity with LU as the country key and the tax group(ing) version from the previous Customizing activities. The settings made in this activity are stored in the T007L_LU database table. Note that prior to January 2015, these values were stored in the T007L table.

    You find this activity in the Customizing for Financial Accounting under Start of the navigation path General Ledger Accounting Next navigation step Periodic Processing Next navigation step Report Next navigation step Statutory Reporting: Luxembourg Next navigation step Group Tax Balances End of the navigation path.

    If you have not activated the New General Ledger, the path is as follows: Start of the navigation path General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Report Next navigation step Statutory Reporting: Luxembourg Next navigation step Group Tax Balances End of the navigation path.

    In the T007L_LU table, you define the mapping between VAT codes and the VAT boxes on your periodic VAT return for the tax amounts.

  8. Open the Assign External Tax Group to Internal Tax Group Customizing activity with LU as the country key and the tax group(ing) version from the previous Customizing activities.

    You find this activity in the Customizing for Financial Accounting under Start of the navigation path General Ledger Accounting Next navigation step Periodic Processing Next navigation step Report Next navigation step Sales/Purchase Tax Returns Next navigation step Assign External Tax Group to Internal Tax Group End of the navigation path.

    If you have not activated the New General Ledger, the path is as follows: Start of the navigation path General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Report Next navigation step Sales/Purchases Tax Returns Next navigation step Assign External Tax Group to Internal Tax Group End of the navigation path.

    In this Customizing activity, you enable the users creating the periodic VAT returns to manually enter values for VAT boxes before the XML file is generated. Make the following entries for periodic VAT returns created as of January 2015:

    Gp No

    ExTxGrpNo.

    Text

    0

    403

    % for box 403

    0

    418

    % for box 418

    0

    453

    % for box 453

    Note that prior to January 2015, the VAT box numbers were entered in the Gp No. field. After January 2015, you make the entries to the ExTxGrpNo. field.