European Sales Listing Report for Intra-EU Sales

Use the European Sales Listing Report to declare sales of goods and services rendered within the European Union to VAT-registered customers in other EU countries.

The report supports both summary and detail outputs for intra-EU goods, services, and triangulation transactions, and can be configured to reflect your organization’s legal and tax reporting requirements. Standard and custom tax reporting codes can be used to group transactions as needed for each EU member state.

Setup

Legal Reporting Unit Tax Profile

To enable European Sales Listing reporting:

  1. Navigate to Setup and Maintenance and go to Manage Legal Reporting Unit Tax Profiles.
  2. Search for the relevant legal entity and open the record.
  3. On the Edit Legal Reporting Unit Tax Profile page, go to the Tax Registrations tab.
  4. Ensure a tax registration record exists with a Tax Registration Number (TRN).
    • If not, create a new registration record and enter the TRN.
  5. Select the TRN as the Trader VAT Number for running the report.

Tax Reporting Types and Codes

  • Use the Manage Tax Reporting Types task in Setup and Maintenance to define tax reporting codes for intra-EU transactions.
  • Assign these tax reporting codes to tax rates that apply to your intra-EU sales.
  • You can define codes such as Goods, Services, or Triangulation, or use numeric values as per business needs.
  • These codes are referenced in both the summary and detail outputs of the report.

Tax Rate Setup

  • Assign the relevant Tax Reporting Types and Tax Reporting Codes to the tax rates associated with intra-EU transactions.
  • The European Sales Listing Report uses these codes to identify and group transactions for reporting.

Transaction Entry in Receivables

To enter transactions for intra-EU sales:

  1. Navigate to Receivables Billing and select Create Transaction.
  2. Create receivables transactions for goods or services provided to VAT-registered customers in other EU countries.
  3. Assign the tax rates that include the required tax reporting codes.
  4. Complete each transaction.

Reporting

European Sales Listing Report

To generate the report:

  1. Navigate to Tools > Scheduled Processes.
  2. Search for and run the European Sales Listing Report.
  3. Specify the Trader VAT Number, Tax Reporting Type, and Tax Reporting Code you set up earlier.
  4. Set the Summarization Level:
    1. Detail for transaction-level data.
    2. Summary for aggregated amounts.