The EMEA VAT Reporting feature in Oracle Financials for Europe lets EMEA countries manage their VAT reporting requirements. The EMEA VAT reports make use of the E-Business tax data extract to retrieve VAT transaction information based on your tax configuration and tax rules setup. You can use EMEA VAT Reporting to organize tax report data according to the requirements of your company and the tax authority.
EMEA VAT reports are XML reports that let you control the report presentation using report templates and XML Publisher.
Related Topics
Setting Up Taxes, Oracle E-Business Tax User Guide
VAT Reporting Overview, Oracle Financials for Europe User Guide
XML Publisher Introduction, Oracle XML Publisher User's Guide
This section lists all of the EMEA VAT reports.
Austrian VAT Reconciliation Report by Tax Code, Oracle Financials for Europe User Guide
Austrian VAT Reconciliation Report by Tax Account, Oracle Financials for Europe User Guide
ECE Payables VAT Register, Oracle Financials for Europe User Guide
ECE Payables VAT Register Unpaid Invoices Annex, Oracle Financials for Europe User Guide
ECE Receivables VAT Register, Oracle Financials for Europe User Guide
ECE General Ledger VAT Register, Oracle Financials for Europe User Guide
Belgian VAT Monthly VAT Preparation Report, Oracle Financials for Europe User Guide
Belgian VAT Annual Declaration Process Report (AR), Oracle Financials for Europe User Guide
Belgian VAT Annual Return Report, Oracle Financials for Europe User Guide
Belgian VAT Annual Audit Report, Oracle Financials for Europe User Guide
Belgian VAT Purchases Journal, Oracle Financials for Europe User Guide
Belgian VAT Sales Journal, Oracle Financials for Europe User Guide
Croatian Vendor Invoice Tax Report, Oracle Financials for Europe User Guide
Croatian Customer Invoice Tax Report, Oracle Financials for Europe User Guide
French Deductible VAT Declaration Report, Oracle Financials for Europe User Guide
German Payables VAT Reconciliation Detail Report, Oracle Financials for Europe User Guide
German VAT for On-Account Receipts Report, Oracle Financials for Europe User Guide
Israeli VAT AP Detailed Report, Oracle Financials for Europe User Guide
Israeli VAT AR Detailed Report, Oracle Financials for Europe User Guide
Israeli VAT Files - Related to 835 and Not Related to 835, Oracle Financials for Europe User Guide
Israeli VAT Summary Declaration to Tax Authority, Oracle Financials for Europe User Guide
Italian Annual Customer and Supplier Listing, Oracle Financials for Europe User Guide
Italian Purchase VAT Register, Oracle Financials for Europe User Guide
Italian Payables Purchase VAT Register Annex, Oracle Financials for Europe User Guide
Italian Payables Sales VAT Register (Self Invoices, EEC, VAT), Oracle Financials for Europe User Guide
Italian Payables Sales VAT Register Annex (Self Invoices, EEC, VAT), Oracle Financials for Europe User Guide
Italian Payables Summary VAT Report, Oracle Financials for Europe User Guide
Italian Payables Exemption Letter Process, Oracle Financials for Europe User Guide
Italian Payables Exemption Letter Register, Oracle Financials for Europe User Guide
Italian Supplier Exemption Limit Consumption Report, Oracle Financials for Europe User Guide
Italian Payables Exemption Limit Declaration, Oracle Financials for Europe User Guide
Italian Receivables Sales VAT Register, Oracle Financials for Europe User Guide
Italian Receivables Sales VAT Register Annex, Oracle Financials for Europe User Guide
Italian Receivables Deferred VAT Register, Oracle Financials for Europe User Guide
Italian Receivables Deferred VAT Register Annex, Oracle Financials for Europe User Guide
Norwegian VAT Reconciliation Report, Oracle Financials for Europe User Guide
Portuguese Periodic VAT Report, Oracle Financials for Europe User Guide
Portuguese Annual VAT Report, Oracle Financials for Europe User Guide
Portuguese Suppliers Recapitulative Report and Extract File, Oracle Financials for Europe User Guide
Portuguese Customers Recapitulative Report and Extract File, Oracle Financials for Europe User Guide
Spanish Input VAT Journal Report, Oracle Financials for Europe User Guide
Spanish Periodic Modelo Report, Oracle Financials for Europe User Guide
Spanish Payables Inter-EU Operations Summary Data Extract (Modelo 349), Oracle Financials for Europe User Guide
Spanish Payables Operations with Third Parties Data Extract (Modelo 347), Oracle Financials for Europe User Guide
Spanish Payables Canary Islands Annual Operations Data Extract (Modelo 415), Oracle Financials for Europe User Guide
Spanish Inter-EU Invoices Journal Report, Oracle Financials for Europe User Guide
Spanish Inter-EU Invoice Format (Documento Equivalente), Oracle Financials for Europe User Guide
Spanish Output VAT Journal Report, Oracle Financials for Europe User Guide
Spanish Receivables Inter-EU Operations Summary Data Extract (Modelo 349), Oracle Financials for Europe User Guide
Spanish Receivables Operations with Third Parties Data Extract (Modelo 347), Oracle Financials for Europe User Guide
Spanish Receivables Canary Islands Annual Operations Data Extract (Modelo 415), Oracle Financials for Europe User Guide
Spanish Annual Modelo Magnetic Format Report, Oracle Financials for Europe User Guide
Spanish Operations with Third Parties Magnetic Format (Modelo 347), Oracle Financials for Europe User Guide
Spanish Inter-EU Operations Summary Magnetic Format (Modelo 349), Oracle Financials for Europe User Guide
Spanish Canary Islands Annual Operations Magnetic Format (Modelo 415), Oracle Financials for Europe User Guide
Swiss Payables VAT Report, Oracle Financials for Europe User Guide
The European Sales List (ESL) report can be used to display the Intra EU service, goods, or triangulation transactions in European Union (EU) member states other than your own. For these transaction to appear jointly or in separate ESL reports, you must specify the relevant Tax Reporting Type and the Reporting Code created under it.
Important: This is an XML based report. Customized report layouts can be built using the Tax Reporting Ledger (TRL) and Business Intelligence (BI) Publisher. This report displays only cross border Intra EU transactions. Prior to submitting this report you must set the VAT Member State codes for all the EU countries in the Countries and Territories window.
Navigation
(N) E-Business Tax > Request > European Sales Listing
Selected Parameters
In the Parameters window, enter the required parameters:
Trader VAT No.: List contains registration numbers for all the first party legal establishments. This is used to filter and display data related to only that registration number. You must ensure that the tax registration number is specified for the relevant legal establishment before entering such transactions.
Detail/Summary/Both: Specify either a detail or summary listing.
If you select Both, then the report generates two sections, summary and detailed.
Tax Date From: Select start tax date for the report.
Tax Date To: Select end tax date for the report.
Default for Tax Date (if Null): Select Transaction Date or GL Date.
If a tax date is not provided on the invoice, then to display data on the report the system uses a value from the source selected in this parameter.
Site Reported: Select Bill To or Ship To.
This is the site whose country code shall be displayed on the report when the tax registration number does not contain the first two characters as the country code.
Show Out of Period Adjustments and Credit Memos: Select Yes or No.
Select Yes to display adjustments and credit memos, which are created in the selected reporting period but are related to transactions that are reported in a different period.
Select No for adjustments and credit memos to be included in the regular totals.
Include Discounts: Select Yes or No.
Default value is set as No. If Yes is specified, discounts are included in the report. This applies for summary and detail reports. The option (Show Out of Period Adjustments and Credit Memos) is used to present the out of period discount in a separate column or section. Both earned and unearned discounts are included.
Rounding Rule: Select either No, Up, Down or Nearest.
Select No for no rounding. Select Up to round up. Select Down to round down. Select Nearest to rounded off to the nearest level.
Minimum Accountable Unit: Enter a minimum accountable unit.
This is the smallest unit used for the functional currency amounts.
Tax Reporting Type: Select a tax reporting type code as created in Oracle E-Business Tax.
Select the appropriate Intra EU Transaction Tax Reporting Type.
Reporting Code- Intra EU Goods: Select a reporting code created under the tax reporting type that you previously selected.
Specify the reporting code created for goods. If goods transactions should not to be included in the report, then the value should be null.
Reporting Code- Intra EU Services: Select a reporting code created under the tax reporting type that you previously selected.
Specify the reporting code created for services.
Reporting Code- Additional 1: Select a reporting code created under the tax reporting type that you previously selected.
Specify (if required) the reporting code created for triangulation of goods or goods and services.
Reporting Code- Additional 2: Select a reporting code created under the tax reporting type that you previously selected.
Specify (if required) the reporting code created for triangulation of goods or goods and services.
Important: The report output has a column named Country. The value for this column is derived based on the first two characters of the tax registration number specified on the Site Reported parameter. If they match the VAT member state code of the country/territory, then that is taken as Country. Oracle recommends that you always prefix the tax registration number with the country code. If the tax registration number specified for the site reported does not have the first two characters as country code or it does not match with the VAT member state code of the country or territory, then the country code of the address for the site reported (ESL report selection parameter) is printed on the report.