Oracle Fusion Cloud Financials for EMEA Predefined Reports

Using Oracle Financials for EMEA you can generate predefined reports to meet reporting requirements of specific countries for reconciliation and audit of tax calculated on transactions.

You can also prepare specialized reports based on the reporting data models.

You can schedule and run reports from the Scheduled Processes work area found on the Navigator. Here's how you can run the predefined reports:

Click the Schedule New Process button.
Search on the Process Name.
Enter the appropriate parameters.
Enter the appropriate process options and schedule.
Click Submit.

You can generate predefined reports for:

European Union
France
Germany
Israel
Italy
Spain
Turkey
United Kingdom

Reports for the European Union and United Kingdom

The tax reports for the European Union and United Kingdom are:

Display Name	Description
Sales Listing Report for European Union	Declares the information related to products and services that are rendered within the European Union to VAT registered customers in other European Union member states.
Reverse Charge Sales List Report for UK	Lists the UK sales transactions that are created in Oracle Fusion Receivables. It lists transactions for high value electronic goods that are subjected to the Reverse Tax Charge and reported to HRMC (Her Majesties Revenue and Customs). The reported data is grouped by the customers.

Reports for France

The tax reports for France are:

Display Name	Description
DAS2 Contractor Letters for France	Generates letters to all contractors in France whose income is reported in the DAS2 extract file for the current year. This lists income tax amounts from Oracle Fusion Payables grouped by income tax type for France.
DAS2 Extract File for France	Generates the DAS2 electronic file for France that's submitted to the tax authorities in a predefined format.
DAS2 Type 210 Updates Report for France	Generates a list of all changes to data related to DAS2 reporting for France. This also lists all the changes that are made since the last run of the verification report.
DAS2 Verification Report for France	Generates DAS2 information for contractors in France and related income tax information from data entered in Oracle Fusion Payables. The report extracts information into the DAS2 temporary tables and automatically submits the DAS2 Verification Extract Execution Report for France.
Deductible VAT Declaration Report for France	Lists the deductible VAT amount and totals of invoices for France that are entered in Oracle Fusion Payables. The VAT deductibility rule, tax rate, and account number are used to group the reported data.
Audit Report for France	Creates the electronic audit file that's required to be submitted to tax authorities in France. You can create the electronic file in HTML format, and as an excel spreadsheet for data verification.

Reports for Germany

The subledger and accounting reports for Germany are:

Display Name	Description
Z4 Report for Germany	Lists all incoming and outgoing payments made through a foreign bank for the selected ledger and date range. The report prints only the payments that are more than the legally defined threshold amount.
Z5A Report for Germany	Shows the sum of all outstanding receivables and liabilities of goods and services traded with foreign suppliers or customers. You can select the summarize option to print either the Z5A Reconciliation Report or the Z5A Sheet 2 Report.
Journal Details Report for Germany	Provides posted general ledger journal activity for a given period or date range. You can optionally include other criteria like journal category, ledger currency, and journal batch. You can group and sort the entries at report submission. Using this report you can print balances for actual, encumbrance, or budget balance type.

Reports for Israel

The tax reports for Israel are:

Display Name	Description
Withholding Tax Report for Israel	Prints summary and details of withholding tax and income tax activities.
Withholding Tax Reconciliation Report for Israel	Prints all payments and related withholding tax transactions for suppliers and supplier sites for the selected reporting period.
Withholding Tax File for Tax Authority for Israel	Creates a text file in a predefined format for submission to the tax authorities, using the form 856. The file lists the withheld tax amounts for each supplier, supplier personal details, and the total amounts on the transactions including payments, withholding tax amounts, and liabilities.
Supplier Withholding Annual Certificate for Israel	Prints the annual summary of all supplier transactions with the entity issuing the certificate. It lists the withholding tax amounts and payments made to the supplier.
Receipt Report for Israel	Prints receipt details, taxpayer details, and payer details in a specific format.
Withholding Tax Summary Detail Report for Israel	Prints summary and details of withholding tax and income tax activities.

Reports for Italy

The tax reports for Italy are:

Display Name	Description
Declarable Input VAT Register for Italy	Lists the tax declarable activities including payments of the invoices with deferred tax. The report lists supplier details and recoverable and nonrecoverable taxable and tax amounts grouped by tax rate code.
Declarable Output VAT Register for Italy	Lists the tax declarable activities including receipts of the invoices with deferred tax, adjustments, and bills receivables. The report prints customer details and transaction tax-related details grouped by tax rate code.
Payable Sales VAT Register for Self-Invoices, Inter-EU Invoices, and VAT for Italy	Identifies a sales VAT register for Italy for all invoices received from suppliers within the European Union or all self-billing invoices that have accounting dates within the period range being reported. The report displays recoverable and nonrecoverable elements of both tax and taxable amounts grouped by tax code.
Purchase VAT Register for Italy	Identifies all purchase invoices for Italy with document sequence numbers assigned to the selected VAT register name, and with accounting dates within the period range being reported. The report prints and groups invoices by tax rate code.
Receivables Sales VAT Register for Italy	Identifies all sales invoices for Italy assigned to the document sequence name of the selected VAT register name, and with accounting dates within the period range being reported. The report prints and groups invoices by tax rate code.
VAT Liquidation Report for Italy	Identifies a summary of the VAT amounts by tax code for each VAT type and VAT register for the selected period. It also includes the consumption per exemption limit group and the available limit at the beginning and end of the month. The transactional tax data are grouped by Declarable Output VAT Register and Declarable Input VAT Register.
European Purchase Listing of Services for Italy	Lists all Intra-EU payables transactions for services. The report prints invoice details specific to Italy such as service mode, service code, and protocol number.
European Sales Listing of Services for Italy	Lists all Intra-EU receivables transactions for services. The report prints invoice details specific to Italy such as service mode, service code, and protocol number.
Yearly Tax Report	Prints tax and taxable amount information for input and output taxes for all final reported tax periods within the year. The report can be printed in detail or summary format.
Yearly Withholding Tax Report for Italy	Shows annual taxes withheld by first-party legal entities, for the supplier for the year selected. The report data can be printed or grouped by supplier name, supplier taxpayer ID, or supplier tax registration number.
Withholding Tax Letters for Italy	Identifies letters sent to suppliers in Italy confirming tax amounts withheld on partially or fully paid purchase invoices within a calendar year. Letters can be printed for a specific supplier or for all suppliers that have tax withheld.
Exemption Letter Report for Italy	Produces an exemption letter for each exempt supplier in Italy instructing them not to include VAT on invoices that they submit.
Subledger Letter of Intent Register for Italy	Lists all exemption letters issued to suppliers or received by customers in Italy within a given period range.
Letter of Intent Receivables Invoice Register	Lists details about Receivables transactions issued with a Letter of Intent for a given calendar year. Provides letter of intent details like protocol number, allocation type, amount and effective dates.
Supplier Exemption Limit Consumption Report for Italy	Lists the details of suppliers eligible for exemption in Italy and their monthly consumption of assigned exemption limit. Lists consumption details of all the suppliers, or a specific supplier. Details include all invoices exempted during a calendar period.
Letter of Intent Report for Italy	Produces a letter of intent for each exempt supplier in Italy instructing them not to include VAT on invoices that they submit.

Reports for Spain

The tax reports for Spain are:

Display Name	Description
Input VAT Journal for Spain	Identifies detail and summary information about tax on invoices and expense reports for Spain entered in Oracle Fusion Payables. Data is reported by register type: recoverable tax register and nonrecoverable tax register. The transactions can be selected based on tax reporting type and tax reporting code.
Output VAT Journal for Spain	Identifies detail and summary information entered in Oracle Fusion Receivables about tax on transactions created for Spain. Data is reported by register type: tax register and nonrecoverable tax register. The transactions can be selected based on tax reporting type and tax reporting code.
VAT Inter-EU Invoice Journal for Spain	Identifies detail and summary information about invoices received in Spain from suppliers located in any European Union member state. Invoices are entered and posted in Oracle Fusion Payables, and have offset or self-assessed tax distributions. The transactions can be selected based on tax reporting type and tax reporting code.
VAT Inter-EU Invoice Format for Spain	Lists details of the same invoices that appear on the Spanish VAT Inter-EU Invoices Journal report. The transactions can be selected based on tax reporting type and tax reporting code.
Modelo Electronic File Generation for Spain	Prepares electronic file for Modelo 340, 347, 349, or 415 declarations in a legally predefined format.
Modelo Verification Report for Spain	Lists all payables invoices and receivables transactions that are reported in the Modelo 340, 347, 349, or 415 declarations. The report prints data based on the selected legal entity, period range, source, and Modelo name. For receivables cash receipts, only receipts that are of a greater value than the entered minimum cash amount are reported.
Withholding Tax Report for Spain	Identifies summary or detail withholding tax information for Spain by invoice and withholding tax code. The report prints information for a selected legal entity, and optionally for specific supplier.
Withholding Tax Magnetic Format for Spain	Lists withholding tax transactions for the selected legal entity and tax year in a flat file format in the predefined layout.
Withholding Tax Extract Report for Spain	Extracts withholding tax transactions for Spain and stores them in an interface table to be used to report withholding tax transactions. The report selects information for a specific legal entity, and optionally for a specific supplier.

Report for Turkey

The tax report for Turkey is:

Display Name	Description
Process Exchange Rate Difference Report for Turkey	Summarizes the conversion rate differences for invoice, credit memo and journal. It also provides the complete details including tax components in the ledger currency. It prints the eligible gain/loss lines that are processed by the Process conversion rate Differences job for each trading partner and site.