6Country Specific

This chapter contains the following:

Reporting

Oracle Fusion Financials for EMEA Predefined Reports

Using Oracle Fusion 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:

  1. Click the Schedule New Process button.

  2. Search on the Process Name.

  3. Enter the appropriate parameters.

  4. Enter the appropriate process options and schedule.

  5. 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.

General Ledger and Subledger Accounting Reports for EMEA

Oracle Fusion Financials for EMEA provides predefined reports that are used to meet reporting requirements for specific countries and for reconciliation and audit of tax calculated on transactions.

Use the General Ledger and Subledger Accounting reports for reporting in countries in Europe and South America. These reports provide reporting data models on which you can prepare specialized reports. You can also use them to inform shareholders on the financial results in other countries as well. Configure these reports to report the clearing account reconciliation information available in the report extract.

You can schedule and run reports from the Scheduled Processes work area found on the Navigator. To run predefined reports:

  1. Click the Schedule New Process button.

  2. Search on the Process Name.

  3. Enter the desired parameters.

  4. Enter the desired process options and schedule.

  5. Click Submit.

General Ledger Reports

The following table lists the General Ledger reports:

Display Name Description

General Ledger Trial Balance Report

Lists actual account balances and activity by ledger, balancing segment, and account segment. The report prints the value, description, and debit or credit balance for the beginning and ending period, along with the debits and credits for the period. The report can print income statement, balance sheet, or all balances for a selected range of accounting code combinations. You can run this report for a legal entity.

General Ledger Journal Entry Report

Provides general ledger journal activity for a given period or date range, and optionally other criteria including journal source, entered currency, and journal batch. Flexible grouping and sorting options are provided at report submission.

General Ledger Journal and Balance Report

Retrieves all information for the reports that require journal entries and account balances. The account balances can be printed for selected levels of the hierarchy for actual, encumbrance, or budget balance types.

Subledger Accounting Reports

The following table lists the Subledger Accounting reports:

Display Name Description

Third-Party Detail and Balances Report

Provides third-party account balances and accounting activity details for a period. You can review the accounting process details by third party and audit third-party accounts in detail.

Third-Party Account Balance Report

Prints account and original third-party transactions impacting the account during a particular period. The report is run to ensure that subledger and general ledger balances reconcile, and to identify possible reasons for any discrepancies.

Third-Party Balances Summary Report

Displays information for each account of the third party and third-party site, and account identification. This report is a tool for auditing third-party accounts.

Journals and Third-Party Report

Prints all journals posted in Oracle Fusion General Ledger for the accounting period. The report provides accounting and reporting sequence details, detailed subledger accounting entry lines reporting level regardless of the ledger journals summarization. It helps in verifying that all journals are accurately recorded in chronological order with no gaps using legal sequencing rules for both accounting entries and source documents.

General Ledger and Subledger Accounting by Journal Lines Report

Lists account balances or selected segment balances with subledger journal details including entered amounts, third-party name, journal source, journal category, and reporting and accounting sequences. Total number of debit and credit documents is also listed.

Account Analysis by Legal Entity Report

Prints account balances by accounting code combination and selected segments with subledger journal details, including third-party information and sequences. Flexible grouping and sorting options are provided at submission.

General Ledger and Subledger Account Analysis Report

Prints account balances by account with subledger journal details. The report displays entered amounts, third-party information, sequences, and total number of debit and credit documents.

Daily Journals Report

Lists subledger journal activity for a given period or date range, journal source, entered currency, and journal batch. Report prints detailed subledger journal lines prior to general ledger summarization. Third party and transaction details are also listed for the journal lines.

Subledger Detail Journal Report

Displays information about the posted general ledger journal batches that originate from Oracle Fusion Receivables and Oracle Fusion Payables subledgers. The report prints subledger details like transaction number, transaction date, transaction amount in entered and ledger currency.

Journal Ledger Report

Lists the accounting entries with subledger details like transaction number, transaction date, and line description, using flexible sorting options that are provided at report submission. This report provides a real audit trail between general ledger and subledgers to satisfy legal and business requirements.

Tax Reporting Processes

Tax reporting processes provide a single solution to meet global and country-specific tax reporting requirements. You can create tax reports in preliminary or final mode, and mark transactions as finally reported. Tax reporting processes help you when the tax reporting calendar is different from the ledger calendar.

Tax reporting is based on one or more of the following:

  • Tax registration number

  • Tax reporting entity, which is uniquely defined by the tax registration number, tax regime, and tax calendar

  • Tax reporting level, which can be ledger, legal entity, or tax registration number

Tax reporting level, which can be:

  • Ledger

  • Legal entity

  • Tax registration number

When you prepare your tax returns, run the tax reporting processes by legal entity and tax registration number. Legal entities and the associated tax registration numbers are aligned with how your businesses are legally recognized by government authorities. Preparing reports by tax registration number enables you to view all activities that can be reported for a given legal entity in your business.

The tax reporting processes include:

  • Tax Reporting Selection Process

  • Tax Final Reporting Process

Tax Reporting Selection Process

Use the Tax Reporting Selection Process to:

  • Select and mark the transactions you want to report.

  • Run tax reports in a preliminary mode.

  • Review transactions selected for reporting.

  • Make corrections before submitting the reports to the tax authority.

The tax reporting selection process marks transactions selected for tax reporting with an application generated tax reporting identifier. The tax reporting identifier consists of the parameter values you provide when running the Tax Reporting Selection Process. For example tax reporting context, such as ledger name or legal entity name.

Tax Final Reporting Process

Use the Tax Final Reporting Process to:

  • Control transactions that can't be changed once the reports are filed with the tax authorities.

  • Verify and correct tax details before finalizing the reports.

Once you generate the final reports, the tax period is closed to prevent updates or double reporting. Report updates as corrections in the subsequent periods.

How Tax Reporting is Processed

Generate tax reports in summary or detail mode. To generate tax reports, you must complete the following prerequisites:

  1. Set up your tax reporting configuration.

  2. Create country-specific templates used for tax reporting.

    Note: For Italy and Spain, a set of ready-to-use templates are available for tax reporting.

Tax reporting steps:

  1. Select the tax transactions using the Tax Reporting Selection Process.

  2. Generate preliminary reports.

  3. Submit the Tax Final Reporting Process.

  4. Generate the final reports.

  5. Reprint final reports if needed.

Settings That Affect Tax Reporting

Run the Tax Reporting Selection Process to mark the tax transactions within a tax period.

The following table describes selected process parameters:

Name Description

Reporting Level

Enter the reporting level for which you want to select transactions. It can be ledger, legal entity, or tax registration number.

Ledger

Enter the name of the ledger. If you have selected ledger as the reporting level, then you must enter the ledger name.

Tax Registration Number

Select the appropriate tax registration number.

When the reporting level is:

  • Legal entity, filter transactions based on the tax registration number, tax regime, and legal entity.

  • Ledger, you must select the tax registration number to determine the tax calendar for your reporting entity.

Source

Specify input tax, output tax, or both.

How Tax Is Reported

To generate reports, execute the following steps:

  1. Select the tax transactions

    The Tax Reporting Selection Process marks all the transactions eligible for reporting.

    You can run this process repeatedly provided you haven't completed final reporting for the selected tax period. Only accounted transactions can be marked by the selection process.

    Note: The Tax Reporting Selection Process considers corrections or backdated transactions only when the previous period is finally reported.
  2. Generate preliminary reports

    After selecting the transactions, run the tax reports. Tax reports that are run for an open tax period are considered preliminary reports.

    You can run preliminary reports more than once. Use these reports to verify and correct data before reporting to the tax authorities.

  3. Generate final reports

    Run the Tax Final Reporting Process to mark all the tax transactions as finally reported. If you make changes to the transactions before running the final process, you must run the Tax Reporting Selection Process to generate preliminary reports. Once the report data is correct, run the Tax Final Reporting Process.

    The Tax Final Reporting Process marks transactions as finally reported to avoid double reporting, and closes the tax reporting period. Once the tax reporting period is closed, you can't run the Tax Reporting Selection Process for that period. All transaction tax changes made in the finally reported period are reported as corrections in the subsequent periods.

  4. Print final reports

    After completing the final process, print the final reports.

    Note: You can print final reports more than once.

    To reprint final reports, search by:

    • Reporting identifier

    • Tax calendar period

    • Report name

Print the report from the Finalized Transaction Tax Reports page in the Financial Reporting Center.

Yearly Tax Report

This topic includes details about the Yearly Tax Report.

Overview

Use the Yearly Tax Report to display detailed or summarized information about tax and taxable amounts within a year. You can view information on both input and output tax for all finally reported tax periods within a year. All tax amounts are reported in the ledger currency.

The Yearly Tax Report provides countries using the Tax Reporting Selection Process the capability to analyze the annual subledgers and manual tax entry information.

Only finalized transactions in closed periods are included in the report. Use the Tax Final Reporting Process to mark transactions as final and close the tax calendar period.

You can print the report in the following levels:

  • Detail: Prints detailed tax amounts and summarized tax amounts by month and year. Includes the following sections:

    • Detailed Tax Calendar Period

    • Detailed Tax Calendar Year

    • Summarized Tax Calendar Period

    • Summarized Tax Calendar Year

  • Summary: Prints summarized tax amounts by tax calendar period and tax calendar year.

The following figure is an example of the report.

Example of the Yearly Tax report.

Key Insights

The following table displays the tax categories used to group the report:

Tax Category Grouping Criteria

Declarable Output Tax

Transaction type name.

Declarable Input Tax

Document category name, recoverable taxable and tax amounts, and nonrecoverable taxable and tax amounts.

Manual Tax Entries

Manually entered transactions and transactions imported from external sources into the tax repository. Includes the batch name, tax and taxable amounts. Debit tax amounts represent input tax, and credit tax amounts represent output tax.

Within each tax category, you can also group according to other criteria, such as:

  • Tax rate code

  • Tax rate

  • Tax type

Report Parameters

The following table lists selected parameters:

Parameter Description

Reporting Identifier

System generated reporting entity identifier assigned when the process Select Transactions for Tax Reporting is run. The reporting entity identifier is built as a concatenation of the Reporting Level, Legal Entity, Tax Regime, TRN and the Reporting Identifier ID (for example: LE:Vision Italy-1017:IT VAT:IT12345670017:300100066356392).

Tax Calendar Year

Indicate the tax year for tax reporting and settlements.

Summarization Level

Specify the level of detail for reporting. You can print summary data or detailed data.

Report Heading

Specify the report header that must be printed on the report as a legal requirement.

Frequently Asked Questions

The following table lists frequently asked questions about the Yearly Tax Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Tax manager

  • Tax accountant

When do I use this report?

Use this report to analyze:

  • Subledger tax information

  • Manual tax entry information

What type of report is this?

Oracle Business Intelligence Publisher

Turnover Reporting

In many countries, companies must report tax transactions on a monthly, quarterly, or annual basis. Turnover reporting is based on transaction dates or accounting dates, rather than tax point dates. It doesn't report manual tax transactions entered into the tax repository.

Some of the reports that are based on turnover reporting are:

  • European Sales Listing of Services for Italy

  • European Purchasing Listing of Services for Italy

  • Modelo reporting for Spain

Turnover reporting includes two processes:

  • Turnover Reporting Selection Process

  • Turnover Declaration Closure Process

Turnover Reporting Selection Process

The Turnover Reporting Selection Process prepares data for turnover reporting by extracting your payables and receivables transactions. The process selects transactions by accounting date or transaction date.

The Turnover Reporting Selection Process extracts all invoices, including correction transactions within the specified dates for a given legal entity. Correction transactions include credit memos and debit memos.

To accurately report data:

  1. Run the Turnover Reporting Selection Process in the preliminary mode.

  2. Verify the transactions to be reported, run the turnover extract and ensure the transactions listed in the log file are valid and complete.

    Note: Run the European Sales or Purchases Listing of Services for Italy reports to verify if the transactions are reported correctly.
  3. Run the Turnover Reporting Selection Process again in the final mode.

The following table describes selected parameters:

Parameter Description

Reporting Group

Specify the type of turnover reporting:

  • Other to extract transactions for the European Sales Listing of Services for Italy and European Purchase Listing of Services for Italy reports.

  • Modelo reporting for Spain when you want to select transactions for Modelo reporting.

Selection Mode

Indicate preliminary or final.

When you run the process in final mode, it marks the transactions as finally reported.

Finally reported transactions aren't included in the next run of the Turnover Reporting Selection Process.

Note: Finally reported transactions can be extracted again for Italy if:
  • A credit memo is applied to an invoice.

  • The global descriptive flexfield details on the invoice or transaction are changed.

Calendar

Select the calendar for reporting. Once you select the calendar, you must use the same calendar in later runs of the process.

Source

Select the source to extract transactions. You can select:

  • Payables

  • Receivables

  • Payables and Receivables

Note: This process doesn't select manual tax entries entered in Oracle Fusion Tax.

Turnover Declaration Closure Process

The Turnover Declaration Closure Process records the details of a finalized declaration to the tax authority. It's used only in Italy to record the declaration details and mark the reported transactions with the declaration number received from the tax authority.

The following table describes selected parameters:

Parameter Description

Tax Registration Number

Specify the registration number assigned to a party or party site by the tax authority when it's registered.

Declaration Year

Specify the year in which transactions are reported to the tax authority.

Declaration Authority

Specify the name of the tax authority responsible for receiving and processing all company declaration transaction tax reports.

Declaration Number

Specify the unique identifier assigned by the tax authority to a declaration.

European Union

Sales Listing Report for European Union

This topic includes details about the Sales Listing Report for European Union.

Overview

Use the Sales Listing Report for European Union to declare goods and services that are rendered within the European Union (EU) to VAT-registered customers in the other EU member states.

Let's take a look at the sample report in a summary format.

Sales Listing Report for the European Union

Key Insights

This report only includes transactions with the tax reporting code as Intra-EU transactions for goods or services tax.

Invoices, credit memos, and adjustments are reported based on the invoice tax date, the date on which goods and services are rendered.

Report Parameters

This table describes the selected report parameters:

Parameter Name Description

Trader VAT Number

Select the tax registration number of the first-party legal reporting unit.

Country of the Tax Registration Number

Select the site whose country code is displayed on the report when the tax registration number doesn't contain the first two characters as the country code.

Include Prior Period Adjustments and Credit Memos

Select Yes to display adjustments and credit memos that are related to transactions from a different reporting period. Select No for adjustments and credit memos to be included in the regular totals.

Rounding Rule

Select the rounding method for the calculated taxes to the minimum accountable unit. The available options are Up, Down, and Nearest.

Minimum Reportable Amount

Enter the smallest unit used for the ledger currency amounts.

Tax Reporting Type Code

Select the appropriate Intra-EU transaction tax reporting type code.

Tax Reporting Code for Intra-EU Goods

Specify the tax reporting code created for goods. If you don't want to include goods in the report, select the value as null.

Tax Reporting Code for Intra-EU Services

Select a tax reporting code associated with the tax reporting type that you have previously selected.

Additional Tax Reporting Code 1

Select a tax reporting code associated with the tax reporting type that you have previously selected. If required, specify the tax reporting code created for triangulation of goods or goods and services.

Additional Tax Reporting Code 2

Select a tax reporting code associated with the tax reporting type that you have previously selected. If required, specify the tax reporting code created for triangulation of goods or goods and services.

Frequently Asked Questions

This table lists frequently asked questions about the Sales Listing Report for European Union.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Tax Manager

  • Tax Accountant

When do I use this report?

Use this report to declare goods and services that are rendered within the European Union (EU) to VAT-registered customers in the other EU member states.

What type of reports are these?

Oracle Business Intelligence Publisher

France

Reporting Features for France

Oracle Fusion Applications provide standard financial and tax reports to meet the legal and business reporting requirements of tax authorities. For countries like France, a set of country-specific reports is provided to meet local requirements, such as DAS2 reporting and VAT reporting.

DAS2 Reports

Companies in France that do business with independent consultants must declare all payments to consultants to the tax authorities. These third-party payments include fees, commissions, and rebates. These companies must also inform the independent consultants of the amounts reported in the DAS2 file for the current year. The following table lists the DAS2 reports that support these requirements:

Report Name Description

DAS2 Verification Report for France

Generates DAS2 information for contractors in France and related income tax information. Extracts information into the DAS2 temporary tables and automatically submits the DAS2 Verification Extract Execution Report for France.

DAS2 Verification Extract Execution Report for France

Generates output file for information extracted by the DAS2 Verification Extract process for France. Automatically submitted by the DAS2 Verification Report for France, but it can also be submitted as a standalone report.

DAS2 Type 210 Updates Report for France

Generates a list of all changes to data related to DAS2 reporting for France since the last run of the verification report.

DAS2 Contractor Letters Report for France

Generates letters to all contractors in France whose income is reported in the DAS2 extract file for the current year. Lists income tax amounts grouped by income tax type.

DAS2 Extract File Report for France

Generates the DAS2 electronic file for France that is submitted to the tax authorities in a predefined format.

VAT Reports

In France, companies must report input deductible VAT at invoice creation time and payment time. The following table lists the VAT report that meets this requirement:

Report Name Description

Deductible VAT Declaration Report for France

Lists the deductible VAT amounts and totals of invoices for France, grouped by deductible VAT rule, tax rate, and account number.

This topic includes details about the DAS2 reports for France.

Overview

In France, companies that do business with independent contractors declare to tax authorities all payments to contractors each year for each supplier. These third-party payments include fees, commissions, and rebates. The DAS2 report declares all payments made to the contractors.

The DAS2 reporting includes:

  • 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. Lists income tax amounts from Oracle Fusion Payables grouped by income tax type for France.

    The following figure is an example of the DAS2 Contractor Letters for France.

    DAS2 Contractor Letters for France
  • DAS2 Extract File for France: Generates the DAS2 electronic file for France that is 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 that are made since the last run of the verification report.

    The following figure is an example of the DAS2 Type 210 Updates Report for France.

    DAS2 Type 210 Updates Report for France
  • DAS2 Verification Report for France: Generates DAS2 information for contractors in France and related income tax information from data entered in Payables. Extracts information into the DAS2 temporary tables and automatically submits the DAS2 Verification Extract Execution Report for France.

    The following figure is an example of the DAS2 Verification Report for France.

    DAS2 Verification Report for France

Key Insights

You can generate an XML file with information on payments made to contractors and send it to the tax authorities.

If your company has more than one location that makes payments to independent contractors, you can submit:

  • Separate formatted XML files for each location that is a part of a different tax district

  • One XML file if all locations are from the same tax district

All invoices, advanced payments or prepayments, and credit memos that have DAS2 income tax codes associated with transaction lines are reported.

Report Parameter

The following table describes selected DAS2 report parameters:

Parameter Description

Legal Entity

Specify the legal entity. You can control the report output through this parameter only if you have associated balancing segment values to your legal entities.

Supplier

Specify the name of the contractor to whom payment is made.

Year

Specify the year in which the payment is made.

Tax for Salaries

Specify whether taxes on salaries and contractor fees are paid to the government.

Frequently Asked Questions

The following table lists frequently asked questions about the DAS2 reports for France.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Tax Manager

  • Tax Accountant

When do I use this report?

Use the DAS2 reports to:

  • Review payments made to foreign and domestic contractors during the fiscal year

  • Print DAS2 letters to send to contractors informing them about the:

    • Payments

    • Information reported to tax authorities

What type of reports are these?

Oracle Business Intelligence Publisher

This topic includes details about the DAS2 reports for France.

Overview

Companies in France that do business with independent contractors must declare to tax authorities all payments to contractors each year for each supplier. These third-party payments include fees, commissions, and rebates.

Your company submits this information to tax authorities in a formatted, electronic file. This file contains information about:

  • Suppliers and supplier sites

  • Invoice details

  • Supplier payment totals

If a company has more than one location that makes payments to independent contractors, the company can submit the formatted file as:

  • Separate files for each location that falls under a different tax district

  • One file if all locations are under the same tax district

You must provide complete and accurate information because the information in the DAS2 file is used to check the contractor supplier's tax declaration and tax payment. Omissions and errors in your DAS2 declaration may result in heavy penalties.

Prerequisites

Before you use DAS2 reporting, ensure that you:

  • Define suppliers and supplier sites. Assign the contractor type of Corporation, Foreign corporation, Individual, and Foreign individual to the supplier tax organization type.

  • Assign the 14-digit SIRET to the supplier as the Taxpayer ID on the Manage Third-Party Tax Profile page.

  • Define legal entity and legal reporting units. A legal reporting unit represents the company for which you prepare your DAS2 files. Assign SIRET and NIC to the legal entity and appropriate balancing segment value to each legal reporting unit.

  • Define the tax codes for DAS2 reporting. For example, if you want to report author royalties paid to the contractor, enter DDA/DA in the Income Tax Type field on the invoice line.

  • Enter invoices with corresponding DAS2 income tax codes in Oracle Fusion Payables.

Generate Reports

Use the following steps to generate DAS2 reports:

  1. Run the DAS2 Verification Extract for France. It extracts transaction information for legal entities from Payables to temporary tables and submits the DAS2 Verification Extract Execution Report for France.

    Note: All invoices, advanced payments or prepayments, and credit memos that have DAS2 income tax codes associated with transaction lines are extracted.
  2. Review the extracted data in the DAS2 Verification Extract Execution Report for France. The data is grouped by supplier and income tax code and the invoices are rounded to integer and listed in the reverse chronological order by the payment date.

  3. Modify the information using the Manage DAS210 Information for France page, if necessary. Manage DAS210 Information page lets you update the income tax amounts for every supplier displayed. The updates made on this page will be also reflected in the totals displayed on Manage DAS2 Summary page.

  4. Run the DAS2 Type 210 Updates Report for France to review the changes made. The report displays the old and new values for the updated amounts. Use the Manage DAS2 Summary for France page to modify the information, if necessary. Manage DAS2 Summary page gives you the total income tax amounts for the legal entity and legal reporting units. You can enter the type of work and NIC information here.

  5. Run the DAS2 Extract File Report for France to generate the file to be submitted to the tax authorities. You can run the report for a legal entity or a specific legal reporting unit.

  6. Run the DAS2 Contractor Letters Report for France to print letters that are sent to contractors who are reported in the DAS2 file for the current year.

Deductible VAT Declaration Report for France

This topic includes details about the Deductible VAT Declaration Report for France.

Overview

In France, companies must report deductible VAT on purchase of goods and services, by applying the relevant rule to determine if VAT is deductible during invoice creation and payment time. The Deductible VAT Declaration Report for France lists the deductible VAT amounts and totals of invoices for France, grouped by deductible VAT rule, tax rate, and account number.

The following figure is an example of the report.

Deductible VAT Declaration Report for France

Key Insights

The VAT processing is based on tax point basis, tax point date, and marked as reportable. Only tax lines with the reportable option set to yes are reported.

The Deductible VAT Declaration Report for France prints deductible VAT amounts and groups transactions by deduction tax rules such as:

  • DEB-M tax rule: VAT deductible on received invoices for goods or services.

  • CRE-M tax rule: VAT deductible on invoice payments.

For transactions to which the CRE-M rule applies, the tax point basis is set to Payment and are reported when they are either partially or fully paid.

The report displays two separate sections for DEB-M and CRE-M tax rules and lists details of transactions that are not posted to general ledger. Invoices with deferred tax rates are reported as a part of CRE-M only after the invoice is paid. Invoices that have tax rates with tax point basis set to invoice, accounting, or delivery are reported under the DEB-M section.

Report Parameters

The following table lists selected parameters for the Deductible VAT Declaration Report for France:

Parameters Description

Reporting Level

Choose the level on which you want to run the report. You can choose from three different levels, Ledger, Legal Entity, and Tax Registration Number.

Reporting Context

Specify the context for the report. The list of values for this parameter depends on the reporting level you selected.

  • If you select the reporting level of Legal Entity, you select the legal entity on which to report, and then select the tax registration number associated with the legal entity.

  • If you select Ledger as the reporting level, you can report on legal entities associated with ledgers defined in the data access set within your security profile. Run tax reports by ledger when you want to review your tax activity as it aligns with your accounting. Run tax reports by ledger when you need to view tax activity in reporting or secondary ledger currency.

  • If you select tax registration number as the reporting level, you can report all the transactions associated with different legal entities sharing the same tax registration number.

Tax Registration Number

Specify the registration number that is assigned to first party or first-party site by the tax authority when it is registered. A party or party site is identified by this registered number.

From Tax Point Date and To Tax Point Date

Print all the transactions based on the selected tax point date range.

Note: When CRE-M rule is applicable on transactions, the tax point date is the payment date.

Frequently Asked Questions

The following table lists frequently asked questions about the Deductible VAT Declaration Report for France.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Tax Manager

  • Tax Accountant

When do I use this report?

Use the Deductible VAT Declaration Report for France to produce the VAT declaration at the end of each reporting period, listing the deductible VAT amount for each purchase invoice and also the total VAT amounts for the period.

What type of reports are these?

Oracle Business Intelligence Publisher

Audit Report for France

This topic includes details about the Audit Report for France.

Overview

Use the Audit Report for France process to create an electronic audit file. You can transfer the electronic audit file, which is a data file, to the tax authorities. This electronic audit file along with journals must comply with the Generally Accepted Accounting Principles (GAAP) in France.

This report also includes the clearing account reconciliation information. In Columns 14, EcritureLet, and 15, DateLet, you can view the reconciliation group and reconciliation date respectively for each of the reconciled clearing account journal lines. For unreconciled lines or a reconciliation feature that's not being used, these columns don't display this information.

From January 1, 2014, all tax paying companies in France that are audited by the tax authorities must create audit documentation in the prescribed format. Auditors use this documentation to verify the coherence between the audit file and the reported accounting.

Key Insights

Before running the report, ensure that you have:

  • Set up the following entities:

    • Data security

    • Enterprise structure

    • Document sequences, if applicable

  • Completed the implementation project for your organization

  • Entered, processed, accounted, and transferred all subledger transactions to General Ledger

Note: All manual journals must be processed for the reporting period. You don't have to enter any specific attributes on the subledger transactions or journals to report them.

Report Parameters

This table describes selected report parameters:

Name Description

Journal Entry Source

Select a source or leave blank to report on all sources.

Ledger

Enter the ledger name. The available values depend on the data access set assigned to the user.

Legal Entity

Choose from values that are based on the legal entities associated with the ledger. Leave the field blank to report on the complete ledger, regardless of the legal entity.

Show adjustment periods

Indicate whether to create the report by adjustment period.

From and To Accounting Period

Select the reporting period for which you want to display the adjustment period.

Account filter

Optionally, restrict the accounts to include in the data file.

Document Sequence Name

Enter the sequence name to specify the transactions to be included in the electronic file.

Posting status

Select the posting status to view:

  • Only posted journals

  • Journals that are transferred, but not yet posted

Frequently Asked Questions

This table lists frequently asked questions about the Audit Report for France:

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

General Ledger users.

When do I use this report?

Use this report at the end of the reporting period to prepare the file to be submitted to the tax authorities. You can create the file quarterly or even for multiple tax years.

What type of report is this?

Oracle Business Intelligence Publisher.

How can I save the output for the audit reports for France?

Choose Save to save the output file for the audit reports for France in text, data, or CSV format.

How can I review the audit reports for France?

You can review the audit reports in an excel sheet.

Germany

Reporting Features for Germany

Oracle Fusion Applications provide standard financial and tax reports to meet the legal and business reporting requirements of tax authorities. Companies in Germany must comply with the Federal Bank reporting requirements on incoming and outgoing payments when the amount for an individual payment transaction exceeds the statutory limit. The Federal Bank also requires that companies use a specific format when submitting the Z4 and Z5 reports.

The following table lists the reports that support these requirements:

Report Name Description

Z4 Report for Germany

Reports all incoming and outgoing payments above a threshold amount that are any of the following:

  • Received from nonresidents

  • Received from residents for the account of nonresidents

  • Made to nonresidents from residents

Includes all payments made through a foreign bank account. This report is used to complete the official declaration.

Z5A Report for Germany

Provides the following reporting options:

  • Z5A Sheet 2 Report, which summarizes the receivables and payables of foreign customers and suppliers, respectively, both internal and external.

  • Z5A Reconciliation Report, which reconciles the aggregated amounts included in the Z5A Sheet 2 Report, by providing the transaction details per customer or supplier.

Select the Summarize option for the Z5A Reconciliation Report, or leave the option blank for the Z5A Sheet 2 Report.

Journal Details Report for Germany

Provides posted general ledger journal activity for a given period or date range, and optionally other criteria including journal source, entered currency, and journal batch. Provides flexible grouping and sorting options at report submission.

Prerequisite: Before you submit the report, you must configure the general ledger accounting sequence to generate the sequence while posting the journal.

Use the report to:

  • Verify that the journals are sequenced by posted date.

  • Confirm balance sheet and profit and loss statements for a specific accounting period.

  • Verify accounting books during audits.

Reports for Germany

This topic includes details about the reports for Germany.

Overview

The reports for Germany provide the details needed by companies to meet the statistical reporting requirements of the Federal Bank. You can use these reports as a basis for submitting your official declarations to the Federal Bank. These reports also simplify the auditing of general ledger journals, and streamline the reconciliation of outstanding receivables and liabilities of foreign customers and suppliers with subledger records.

The reports for Germany include:

  • Z4 Report for Germany: Lists all incoming and outgoing payments made through a foreign bank for the selected ledger and date range. Only payments more than the legally defined threshold amount are printed.

  • Z5A Report for Germany: Provides details of receivables and liabilities of foreign customers and suppliers, both internal and external. Based on the Summarize option selected, the Z5A Reconciliation Report or Z5A Sheet 2 Report is printed. The Z5A Reconciliation Report lists single transaction amounts that reconcile with the aggregated amounts in the Z5A Sheet 2 Report. Detailed amounts are provided per customer or supplier for each transaction or invoice number on a given date.

  • Journal Details Report for Germany: Provides posted general ledger journal activity for a given period or date range for auditing posting sequences. In Germany, general ledger journals must be sequenced by posted date. The report is generated for a range of accounting or posting dates to show all details of the sequenced journals and daily total amounts.

The following figure is an example of the Z4 Report for Germany.

This image displays the Z4 Report for Germany.

The following figure is an example of the Z5A Reconciliation Report for Germany.

This image displays the Z5A Reconciliation Report
for Germany.

The following figure is an example of the Z5A Sheet 2 Report for Germany.

This image displays the Z5A Sheet 2 Report for Germany.

The following figure is an example of the Journal Details Report for Germany.

This image displays the Journal Details Report
for Germany.

Key Insights

For accurate statistical reporting on the Z4 Report for Germany, enter the following information for transactions:

  • For Payables:

    • Record type

    • Payment reason

  • For Receivables:

    • Record type

    • Reason

Only transactions that are accounted and posted to the general ledger are selected for reporting.

Before you submit the Journal Details Report for Germany, you must configure the general ledger accounting sequence to generate the sequence while posting the journal.

Report Parameters

The following table lists selected process parameters of the Z4 Report for Germany:

Name Description

Ledger

Specify the ledger for reporting.

Threshold

Specify the statutory limit used to determine whether an individual payment is reported. The default value is the current statutory limit of 12,500 EUR, and only payments more than this limit are reported.

The following table lists selected process parameters of the Z5A Report for Germany:

Name Description

Ledger

Specify the ledger for reporting.

Summarize

Select the Summarize option for the Z5A Reconciliation Report, or leave the option blank for the Z5A Sheet 2 Report.

Party Name

Indicate a supplier or customer to reconcile specific payments.

Threshold Amount

Specify the statutory limit used to determine whether an outstanding receivables or payables amount is reported.

The following table lists selected process parameters of the Journal Details Report for Germany.

Name Description

Ledger

Specify the ledger for reporting.

Filter Conditions Defined

To audit a specific account, specify the segments and values.

Document Sequence Number

Specify the reporting sequence name used to number the posted journal. You can audit journals that have a specific reporting sequence name and number assigned.

From/To Document Number

Enter a specific range to verify that sequence numbers are assigned chronologically.

First Page Number

Specify the starting page number for the report.

Frequently Asked Questions

The following table lists frequently asked questions about the reports for Germany.

FAQ Answer

How do I find these reports?

Schedule and run these reports from the Scheduled Processes work area on the Navigator menu.

Who uses these reports?

  • General Accounting Manager

  • Payables Manager

  • Receivables Manager

  • Financial Analyst

When do I use these reports?

Use these reports to:

  • Review the incoming and outgoing payments that exceed the statutory limit.

  • Report all payments with payment reason, reason code, and record type.

  • Report outstanding receivables and payables of foreign customers and suppliers that exceed a prescribed threshold.

  • Print daily totals for a given period, or accounting and posting dates.

  • Print journals that have posting errors.

  • Audit reporting sequence name and numbers assigned to the journals, and verify they are assigned in ascending order based on the journal posting date.

  • Audit posting document sequences for a range of accounting or posting dates.

What type of reports are these?

Oracle Business Intelligence Publisher

Israel

Reporting Features for Israel

Use Oracle Fusion Applications to get standard financial and tax reports that meet the legal and business reporting requirements of tax authorities. For countries such as Israel, you can get a set of country-specific reports. These reports meet local reporting requirements for withholding tax.

This table lists the withholding reports for Israel.

Withholding Tax Reports

Report 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 to Tax Authority for Israel

Creates a text file in a predefined format for submission to the tax authorities, that's, 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.

Withholding Tax Annual Certificate to Suppliers 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 Reports for Israel

This topic includes details about the withholding tax reports for Israel.

Overview

All legal entities in Israel must submit their withholding tax reports in compliance with the fiscal authority specifications.

The following reports support withholding tax for Israel:

  • Withholding Tax Report for Israel: Prints summary and details of withholding tax and income tax activities. It lists all the withholding tax transactions for a given period.

  • 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 to Tax Authority for Israel: Creates a text file in a predefined format, called form 856, for submission to the tax authorities. 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.

  • Withholding Tax Annual Certificate to Suppliers 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. The report contains the following details:

    • For a receipt in the form of a check: the account, bank, branch and check number information is listed.

    • For an account transfer: bank, branch information is listed.

    • Else, the credit card information is listed.

  • Receipt Report for Israel: Prints receipt details, taxpayer details, and payer details in the specific format for Israel.

Key Insights

Before running the reports, ensure that you:

  • Set up the following entities:

    • Data Security

    • Geographies

    • Enterprise Structure

    • Suppliers

    • Bank accounts

    • Procurement Business Function

    • Common Options for Payables

  • Complete the implementation project before entering transactions and using the transaction tax reports.

Report Parameters

The following table lists the main parameters for the withholding tax reports for Israel:

Name Description

From and To Document Number

Enter a specific range to verify that sequence numbers are assigned chronologically.

Ledger

Specify the ledger for reporting.

Legal Entity

Specify the legal entity that is submitting the declaration to the tax authority.

Reporting Level

Enter the reporting level for which you want to select transactions, such as ledger, legal entity, or tax registration number.

Frequently Asked Questions

The following table lists frequently asked questions about the withholding tax reports for Israel.

FAQ Answer

How do I find these reports?

Schedule and run these reports from the Scheduled Processes work area on the Navigator menu.

Who uses these reports?

  • Tax Manager

  • Tax Accountant

What type of reports are these?

Oracle Business Intelligence Publisher

SHAAM Interface File Data

Overview of SHAAM Interface File Data for Israel Process

In Israel, tax authorities provide a computerized processing system known as SHAAM to maintain bookkeeping and withholding tax exemption certificates for suppliers that trade goods or services. As a tax manager, you can submit supplier information electronically and receive back a file with valid certificate details from the Israel tax authority.

Here's how Oracle Fusion Applications enable you to meet the requirements of Israel tax authority:

  • Generate a file of supplier or supplier sites that require withholding certification and exemption. You can submit this file to the Israel tax authority.

  • Import the file that the Israel tax authority returns by updating the supplier certification and withholding tax exemptions, where applicable.

Generate SHAAM Supplier File for Israel

Generate a file of supplier or supplier sites that require withholding certification and exemption. You can submit this file to the tax authority.

Let's walk through the steps to generate a SHAAM supplier file for Israel:

  1. Navigate to the Scheduled Process work area.

  2. Search for the Create SHAAM Supplier for Israel process.

  3. On the Process Details dialog box, select the values for these parameters.

    Parameter Description

    Legal Reporting Unit

    The legal reporting unit for which you want to generate the file.

    Certificate Expiration Date

    Suppliers or Supplier sites which have an end date of a bookkeeping certificate earlier than this date to be included in the file.

    Use Alternate Names

    The alternate supplier name to be used instead of the supplier name.

    Withholding Tax Regime

    The withholding tax regime that you have created for processing withholding tax.

    VAT Regime

    The VAT regime that you have created for processing transaction taxes.

  4. Click Submit.

After the process completes, you can see a flat file with supplier or supplier site details. You can submit this flat file to the Israel tax authority.

Import SHAAM Interface File Data for Israel

Import SHAAM bookkeeping certificates and withholding tax exemptions data from a flat file received from the Israel tax authority. You can then load the data to the Withholding Tax Registrations and Tax Exemptions tables.

Let's walk through the steps to access the template:

  1. Navigate to the File-Based Data Import for Oracle Financials Cloud guide.

  2. In the Table of Contents, click File-Based Data Imports.

  3. Click SHAAM Interface File for Israel.

  4. In the File Links section, click the link to the control file.

Here are a few things to keep in mind when preparing your data in a flat file.

  • Import flat file data directly from the Israel tax authority SHAAM system. You don't need to manually enter data.

  • Create data in the format specified in the control file.

Settings that Affect the Import SHAAM Interface File Data for Israel Process

The SHAAM Interface File for Israel Control File provides the format to load supplier certification and withholding tax exemptions. You can load data to the following table:

Table Description

JG_REPORTING_TRANSACTION_T

Stores supplier SHAAM certificates and withholding tax exemptions for Israel.

How SHAAM Interface File for Israel Data Is Processed

After you import the flat file from the Israel tax authority SHAAM system, you compress the file as a Zip file and then, load the Zip file to the application.

Here's how you load the Zip file to the application:

  1. Navigate to the Load Interface File for Import page.

  2. Select the Process Received SHAAM Certificates File for Israel process.

  3. In the Data File list, select Upload a new file.

  4. Select the Zip file to upload

  5. Submit the process.

  6. Monitor the import process.

  7. If the Process Received SHAAM Certificates File for Israel process ends in an error or a warning, review the log file. You can find details about the rows that caused the process failure in the log file.

Italy

Reporting Features for Italy

Oracle Fusion Applications provide standard financial and tax reports to meet the legal and business reporting requirements of tax authorities. For countries like Italy, a set of country-specific reports is provided to meet local reporting requirements for VAT, intra-EU activity, exemptions and withholding tax.

The following tables are the lists of reports for Italy by type.

VAT Reports

Report Name Description

Declarable Input VAT Register for Italy

Lists the declarable input VAT activities with document sequences assigned to the selected tax register, including payments of invoices with deferred tax. Displays the recoverable and nonrecoverable tax amounts and corresponding taxable amounts. Provides a summary section with totals by tax rate code and a grand total.

Declarable Output VAT Register for Italy

Lists the declarable output VAT activities with document sequences assigned to the selected tax register, including receipts of invoices with deferred tax and adjustments. Displays the tax and taxable amounts. Provides a summary section with totals by tax rate code and a grand total for invoices, receipts and adjustments.

Payables Sales VAT Register for Self Invoices, EEC, VAT for Italy

Provides information about:

  • Recoverable, nonrecoverable, and deferred tax amounts.

  • Corresponding portions of taxable amounts for all invoices received from suppliers within the European Union.

  • All self-billing invoices that have accounting dates within the reporting period.

Purchase VAT Register for Italy

Lists all purchase invoices with document sequences that are assigned to the selected tax register and have accounting dates within the selected tax period.

Receivables Sales VAT Register for Italy

Lists all sales invoices with document sequences that are assigned to the selected tax register and have accounting dates within the selected tax period.

VAT Liquidation Report for Italy

Provides summary information for all reportable tax events with tax point dates within the reporting period. Identifies the associated tax register for each transaction. Provides a summary per tax rate code with the totals for each tax register. Includes a grand total section for all reportable sales and purchases VAT and credit balances from the previous report. This determines the net VAT amount to be paid to the authorities.

Intra-EU Reports

Report Name Description

European Purchase Listing of Services for Italy

Lists all Intra-EU payables transactions for services with specific transaction details for Italy, such as service code and service mode.

European Sales Listing of Services for Italy

Lists all Intra-EU receivables transactions for services with specific transaction details for Italy, such as service code and service mode.

Exemption Reports

Companies in Italy that are regular exporters can legally request suppliers to not charge VAT on purchase transactions. The Letter of Intent is the official letter to send to suppliers and customs for this exemption. This letter contains:

  • Instructions to invoice without VAT.

  • Revocation or suspension of a previous letter of intent, with instructions to invoice with VAT.

The exemption limit is the total VAT exemption amount that a regular exporter can claim against suppliers, and is monitored on a periodic basis.

The following reports support the exemption handling requirements:

Report Name Description

Letter of Intent Report for Italy

Produces an exemption letter for suppliers in Italy instructing them not to include VAT on invoices that they submit.

Supplier Exemption Limit Consumption Report for Italy

Lists 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. Includes all invoices exempted during a calendar period.

Letter of Intent Receivables Invoice Register for Italy

Lists receivables transactions associated with a letter of intent for a specific calendar year. Prints letters of intent details issued by customers and associated with the transactions.

Subledger Letter of Intent Register for Italy

Lists payables and receivables transactions issued with a letter of intent for a specific calendar year. Provides letter of intent details such as protocol number, allocation type, amount, and effective dates.

Withholding Tax Reports

Report Name Description

Withholding Tax Letters for Italy

Creates letters sent to suppliers in Italy that confirm tax amounts that are withheld on partially or fully paid purchase invoices within a calendar year. Prints for a specific supplier or for all suppliers.

Withholding Tax Yearly Report for Italy

Shows the annual taxes withheld by first-party legal entities for a supplier during a specified year. The report is grouped by supplier name, supplier taxpayer ID or supplier tax registration number.

VAT Reports for Italy

This topic includes details about the VAT reports for Italy.

Overview

Oracle Fusion Applications provide a set of VAT reports to meet the legal and business reporting requirements of tax authorities.

The VAT reports for Italy include:

  • Declarable Input VAT Register for Italy: Lists the declarable input VAT activities with document sequences assigned to the selected tax register, including payments of invoices with deferred tax for a specific period. The report displays the recoverable and nonrecoverable tax amounts and corresponding taxable amounts. Provides a summary section with totals by tax rate code and a grand total.

    The following figure is an example of the report.

    Declarable Input VAT Register for Italy
  • Declarable Output VAT Register for Italy: Lists the declarable output VAT activities with document sequences assigned to the selected tax register, including cash receipt applications of invoices with deferred tax and adjustments. Displays the tax and taxable amounts. Provides a summary section with totals by tax rate code and a grand total for invoices, receipts and adjustments.

    The following figure is an example of the report.

    Declarable Output VAT Register for Italy
  • Payable Sales VAT Register for Self Invoices, Inter-EU Invoices, and VAT for Italy: Provides the recoverable, nonrecoverable and deferred tax amounts, and corresponding portions of taxable amounts for all invoices received from suppliers within the European Union, or all self-billing invoices that have accounting dates within the reporting period.

    The following figure is an example of the report.

    Payable Sales VAT Register for Self Invoices, Inter-EU
Invoices, and VAT for Italy
  • Purchase VAT Register for Italy: Lists all purchase invoices with document sequences that are assigned to the selected tax register and have accounting dates within the selected tax period.

    The following figure is an example of the report.

    Purchase VAT Register for Italy
  • Receivables Sales VAT Register for Italy: Lists all sales invoices with document sequences that are assigned to the selected tax register and have accounting dates within the selected tax period.

    The following figure is an example of the report.

    Receivables Sales VAT Register for Italy
  • VAT Liquidation Report for Italy: Provides summary information for all tax events that can be reported with tax point dates within the reporting period. Identifies the associated tax register for each transaction. Provides a summary per tax rate code with the totals for each tax register. Includes a grand total section for all sales and purchases VAT that can be reported and credit balances from the previous report, which determines the net VAT amount to be paid to the authorities.

    The following figure is an example of the report.

    VAT Liquidation Report for Italy

Key Insights

Before you run the VAT reports for Italy, ensure that you:

  • Set up tax reporting entities and tax registers

  • Configure tax reporting type and tax reporting type codes

  • Associate document sequence names with tax registers

The VAT reports for Italy either use accounting date or tax point date for reporting data. Reporting of data by:

  • Accounting date lets you list all invoicing activity regardless of what is declarable from tax perspective.

  • Tax point date lets you report all declarable tax activity within a specific period and helps you to prepare declaration.

The following table lists the reports that use accounting date and tax point date for reporting transactions:

Report Name Accounting Date Tax Point Date

Declarable Input VAT Register for Italy

No

Yes

Declarable Output VAT Register for Italy

No

Yes

Payable Sales VAT Register for Self Invoices, Inter-EU Invoices, and VAT for Italy

Yes

No

Purchase VAT Register for Italy

Yes

No

Receivables Sales VAT Register for Italy

Yes

No

VAT Liquidation Report for Italy

No

Yes

Run the Select Transactions for Tax Reporting process before you run the VAT reports for Italy. The process marks the transactions with a tax reporting identifier, and identifies the tax reporting periods and tax registers defined for Italy.

Run the Finalize Transactions for Tax Reporting process to mark transactions as finally reported for the following reports:

  • Declarable Input VAT Register for Italy

  • Declarable Output VAT Register for Italy

  • VAT Liquidation Report for Italy

Note: Only the listed reports can be printed in final mode and can be reprinted if required.

Report Parameters

The following table lists the common parameters for the VAT Reports for Italy:

Parameters Description

Tax Calendar Period

Indicate the period name of the monthly calendar for reporting data.

Tax Register

Indicate the tax register such as, recoverable and nonrecoverable for reporting VAT reporting for Italy.

First Page Number

Indicate the starting page for the report.

The following table lists additional parameters for the VAT Liquidation Report for Italy:

Parameters Description

Variation on Sales

Indicate the debit amount to reduce the sales VAT for net payment purposes.

Variation on Purchase

Indicate the credit amount to reduce the sales VAT for net payment purposes.

Frequently Asked Questions

The following table lists frequently asked questions about the VAT reports for Italy.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Tax Manager

  • Tax Accountant

When do I use this report?

Use VAT reports for Italy to review:

  • Invoices that are assigned to a document sequence name of a specified VAT register on the accounting dates within specified period.

  • Tax declarable activities including payments of invoices with deferred tax for a specific period.

  • Tax declarable activities including cash receipts of invoices with deferred tax, adjustments, and bills receivables.

  • Review summary of VAT amounts grouped by tax code for each VAT register for the selected period.

What type of reports are these?

Oracle Business Intelligence Publisher

Intra-EU Reports for Italy

This topic includes details of the Intra-EU reports for Italy.

Overview

Companies in Italy must report the details of the sale or purchase of services to or from companies in European Union (EU) member states.

The reported transactions, once declared to the tax authority, must be stamped with declaration number issued by the tax authority.

Use the following reports to report intra-EU transactions to the tax authorities:

  • European Sales Listing of Services for Italy: Use this report to declare services rendered by Italian companies to VAT-registered customers in European Union (EU) member states.

    The report prints service mode, service code, reporting receipt method, and reporting receipt country details associated with the transactions. The following figure is an example of the report.

    European Sales Listing of Services for Italy
  • European Purchase Listing of Services for Italy: Use this report to declare services purchased by Italian companies from VAT-registered suppliers in European Union (EU) member states.

    The report prints service mode, service code, reporting payment method, and reporting payment country details associated with the transactions. The following figure is an example of the report.

    European Purchase Listing of Services for Italy

Key Insights

Both the European Sales Listing of Services for Italy and European Purchase Listing of Services for Italy reports:

  • Display report level totals for invoice amount.

    Note: Create your own templates to specify page totals, carry forward totals, or brought forward totals.
  • Round off all amounts to the nearest Euro.

  • List invoices that are reported and later canceled in the adjustments section of the report.

Before running the European Sales Listing of Services for Italy report, ensure that you:

  • In Oracle Fusion Functional Setup Manager, use the:

    • JG_ESL_EPL_SERVICE_CODE lookup type to specify the service code.

    • JG_ESL_EPL_SERVICE_MODE lookup type to specify the service mode.

    • JG_ESL_EPL_RCPT_PYMT_MODE lookup type to specify the reporting payment method.

  • Configure the tax reporting type and tax reporting code for intra-EU transactions.

Before running the European Purchase Listing of Services for Italy report, ensure that you:

  • Update the service code, service mode, reporting payment method, and reporting payment country for the services you purchase.

  • Update the service codes for the services you purchase. Use the Service Code (JG_ESL_EPL_SERVICE_CODE) lookup type in Oracle Fusion Functional Setup Manager to specify the service codes.

  • Configure the tax reporting type and tax reporting code for intra-EU transactions.

Report Parameters

The following table describes selected parameters of the European Sales and Purchase Listing of Services for Italy reports:

Parameter Description

Tax Registration Number

Specify the registration number assigned to a party or party site by the tax authority when it's registered. A party or party site is identified by this registered number.

Tax Reporting Type

Select a tax reporting type code created in Oracle Fusion Tax. Select the appropriate Intra-EU transaction tax reporting type.

Tax Reporting Code

Select a tax reporting code created as a part of the tax reporting type you previously selected. Specify the tax reporting code relating to European Sales Listing of Services for Italy.

Frequently Asked Questions

The following table lists frequently asked questions about the European Sales and Purchase Listing of Services for Italy reports:

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Tax Manager

  • Tax Accountant

When do I use this report?

Use the European Sales Listing of Services for Italy and European Purchase Listing of Services for Italy reports to:

  • Meet the reporting requirements of the Italian tax authorities.

  • Verify the details before submitting information as a declaration to the tax authority.

  • Accompany the positive receipt of the declaration number from the tax authority for future reference.

What type of reports are these?

Oracle Business Intelligence Publisher

How European Sales Listing Services for Italy is Reported

You can use the European Sales Listing of Services for Italy report to declare services rendered by Italian companies to VAT-registered customers in European Union (EU) member states.

Settings That Affect Reporting

Before running the report, ensure to complete these things:

  • In Oracle Fusion Functional Setup Manager, use the:

    • JG_ESL_EPL_SERVICE_CODE lookup type to specify the service code.

    • JG_ESL_EPL_SERVICE_MODE lookup type to specify the service mode.

    • JG_ESL_EPL_RCPT_PYMT_MODE lookup type to specify the reporting payment method.

  • Configure the tax reporting type and tax reporting code for intra-EU transactions.

How Sales Listing of Services is Reported

To complete the European Sales Listing of Services for Italy report, run the following processes:

  1. Turnover Reporting Selection Process in final mode

  2. European Sales Listing of Services for Italy

To complete the declaration, run the Turnover Reporting Declaration Closure Process to mark the reported transactions with the declaration number received from the tax authority.

Turnover Reporting Selection Process

The selection process extracts transactions to be reported from Oracle Fusion Receivables. Reporting is based on the extraction result of the Turnover Reporting Selection process.

The process extracts all the invoices, including correction transactions such as credit memos, within the specified dates for a given legal entity.

Only transactions that have the additional details entered for European Sales Listing of Services are extracted.

Run the Turnover Reporting Selection Process in the preliminary mode. After you verify the transactions to be reported, run the European Sales Listing of Services for Italy report, and ensure the transactions are reported correctly. When the transactions are reported correctly, run the Turnover Reporting Selection Process again in the final mode.

The following table describes selected process parameters of the Turnover Reporting Selection Process:

Parameter Description

Reporting Group

Specify the type of turnover reporting to be selected. Select Other to extract transactions for the European Sales Listing of Services for Italy report.

Selection Mode

Indicate the selection mode of the report, such as preliminary or final.

When you run the process in final mode, it stamps the transactions as finally reported. The finally reported transactions aren't included in the next run of the Turnover Reporting Selection Process.

European Sales Listing of Services for Italy

The European Sales Listing of Services for Italy report displays all Intra-EU Receivables transactions for services.

Use the European Sales Listing of Services for Italy report to:

  • Meet the reporting requirements of the Italian tax authorities.

  • Verify the details before submitting information as a declaration to the tax authority.

The following table describes selected parameters of the European Sales Listing of Services for Italy report:

Parameter Description

Tax Registration Number

Specify the registration number assigned to a party or party site by the tax authority when it's registered. A party or party site is identified by this registered number.

Tax Reporting Type

Select a tax reporting type code created in Oracle Fusion Tax. Select the appropriate Intra-EU transaction tax reporting type.

Tax Reporting Code

Select a tax reporting code created under the tax reporting type you previously selected. Specify the tax reporting code relating to European Sales Listing of Services for Italy.

Turnover Declaration Closure Process

The Turnover Declaration Closure Process records the details of the finalized declaration that you submitted to the tax authority.

Run this final step after the electronic submission of the European Sales Listing of Services for Italy report to the tax authority.

Use the Turnover Declaration Closure Process to accompany the positive receipt of the declaration number from the tax authority for future reference.

The Turnover Declaration Closure Process marks all the declared transactions that are reported. Any future adjustments to these declared transactions are reported in section four of the European Sales Listing of Services for Italy report for subsequent periods.

The following table describes selected process parameters of the Turnover Declaration Closure Process:

Parameter Description

Tax Registration Number

Specify the registration number assigned to a party or party site by the tax authority when it's registered. A party or party site is identified by this registered number.

Declaration Year

Specify the year in which transactions are reported to the tax authority.

Declaration Authority

Specify the name of the tax authority responsible for receiving and processing all company declaration transaction tax reports.

Declaration Number

Specify the unique identifier assigned by the tax authority to a declaration.

How European Purchase Listing Services for Italy is Reported

Use the European Purchase Listing of Services for Italy report to declare services purchased by Italian companies from VAT-registered suppliers in European Union (EU) member states.

Settings That Affect Reporting

Before running the report:

  • Update the service codes for the services you purchase. Use the Service Code (JG_ESL_EPL_SERVICE_CODE) lookup type in Oracle Fusion Functional Setup Manager to specify the service codes.

  • Update the service code, service mode, reporting payment method, and reporting payment country for the services you purchase.

  • Configure the tax reporting type and tax reporting code for intra-EU transactions.

How Purchase Listing of Services Is Reported

To complete the European Purchase Listing of Services for Italy report, run the following processes:

  1. Turnover Reporting Selection Process in final mode

  2. European Purchase Listing of Services for Italy

To complete the declaration to the authorities, run the Turnover Reporting Declaration Closure Process. This marks the reported transactions with the declaration number received from the tax authority.

Turnover Reporting Selection Process

The selection process extracts transactions to be reported from Oracle Fusion Payables. Reporting is based on the extraction result of the Turnover Reporting Selection process.

Only transactions with the European Purchase listing of Services additional details entered are extracted.

First run the Turnover Reporting Selection Process in the preliminary mode. After you verify and confirm the transactions to be reported, run the process again in the final mode.

The following table describes selected process parameters of the Turnover Reporting Selection Process:

Parameter Description

Reporting Group

Specify the type of turnover reporting to be selected. Select Other to extract transactions for the European Purchase Listing of Services for Italy report.

Selection Mode

Indicate the selection mode of the report, such as preliminary or final.

When you run the process in final mode, it stamps the transactions as finally reported. The finally reported transactions aren't included in the next run of the Turnover Reporting Selection Process.

European Purchase Listing of Services for Italy

The European Purchase Listing of Services for Italy report lists all Intra-EU Payables transactions for services.

Use the European Purchase Listing of Services for Italy report to:

  • Meet the reporting requirements of the Italian tax authorities.

  • Verify the details before submitting information as a declaration to the tax authority.

  • Accompany the positive receipt of the declaration number from the tax authority for future reference.

The following table describes selected parameters of the European Purchase Listing of Services for Italy report:

Parameter Description

Tax Registration Number

Specify the registration number assigned to a party or party site by the tax authority when it's registered. A party or party site is identified by this registered number.

Tax Reporting Type

Select a tax reporting type code as created in Oracle Fusion Tax. Select the appropriate Intra-EU transaction tax reporting type.

Tax Reporting Code

Select a tax reporting code created under the tax reporting type that you previously selected. Specify the tax reporting code relating to European Purchase Listing of Services for Italy.

Turnover Declaration Closure Process

The Turnover Declaration Closure Process records the details of the finalized declaration you submitted to the tax authority.

Run this final step after the electronic submission of the European Purchase Listing of Services for Italy report to the Italian tax authority.

The Turnover Declaration Closure Process marks all the declared transactions that are reported. Any future adjustments to these declared transactions are reported in section four of the European Purchase Listing of Services for Italy report for subsequent periods.

Parameter Description

Tax Registration Number

Specify the registration number that is assigned to a party or party site by the tax authority when it's registered. A party or party site is identified by this registered number.

Declaration Year

Specify the year in which transactions are reported to the tax authority.

Declaration Authority

Specify the name of the tax authority responsible for receiving and processing all company declaration transaction tax reports.

Declaration Number

Specify the unique identifier assigned by the tax authority to a declaration.

This topic includes details about the exemptions reports for Italy.

Overview

In Italy, regular exporters can legally request suppliers to not charge VAT on purchase transactions. The Letter of Intent is the official letter to send to suppliers and customs for vat exemption. This letter contains:

  • Instructions to invoice without VAT.

  • Revocation or suspension of a previous letter of intent, with instructions to invoice with VAT.

The exemption limit is the total VAT exemption amount that a regular exporter can claim against suppliers, and it is monitored on a periodic basis.

The following reports support exemption handling for Italy:

  • Exemption Letter 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.

    The following figure is an example of the report.

    Exemption Letter Report for Italy
  • 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 such as protocol number, allocation type, amount, and effective dates.

    The following figure is an example of the report.

    Letter of Intent Receivables Invoice Register
  • Subledger Letter of Intent Register for Italy: Lists all letters of intent issued to suppliers or received by customers in Italy within a given period range.

    The following figure is an example of the report.

    Subledger Letter of Intent Register for Italy
  • Supplier Exemption Limit Consumption Report: 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.

Key Insights

For each year, the initial exemption limit is the sum of all reported export invoices of the previous year. You can allocate the exemption limit as an annual or monthly amount and allocate the exemption limit among different suppliers. To each supplier, you send a Letter of Intent that indicates the exemption amounts, and request that they do not charge tax when they send the invoices.

Define the tax reporting type and tax reporting code with the usage as exempt for using letter of intent and reporting exemption data.

Exemption limits can be adjusted during the year to reflect an increase or decrease in export activities and changes in the VAT exemption amount as agreed with tax authorities. However, you will not be able to change the exemption limit type.

Report Parameters

The following table lists the common parameters for all the exemption reports:

Parameter Description

Tax Reporting Type Code

Specify the tax reporting type code as created in Oracle Fusion Tax. Select the appropriate tax reporting type created for letter of intent.

Tax Reporting Code

Specify the tax reporting code created as a part of the tax reporting type that you previously selected. Specify the tax reporting code relating to letter of intent.

From Period and To Period

Indicate the period range for the report data.

The following table lists the parameters for the Letter of Intent Receivables Invoice Register:

Parameter Description

Calendar Year

Indicate the year for the report data.

From Customer and To Customer

Indicate the customer range for the report data.

The following table lists the parameters for the Supplier Exemption Limit Consumption Report:

Parameter Description

Calendar Year

Indicate the year for the report data.

Month

Indicate the month for which the consumption of exemption amount must be reported.

From Supplier and To Supplier

Indicate the supplier range for the report data.

Invoices with Letter of Intent

Indicate whether all or only invoices with a letter of intent must be included in the report.

Frequently Asked Questions

The following table lists frequently asked questions about the exemption reports for Italy.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Tax Manager

  • Tax Accountant

  • Tax Specialist

  • Accounts Receivables Manager

  • Accounts Receivables Specialist

  • Accounts Payables Manager

  • Accounts Payables Specialist

When do I use this report?

Use the exemption reports for Italy to:

  • Specify VAT exemption limit on transactions

  • Review transactions issued with a letter of intent during a calendar year

  • Review all letter of intent issued to suppliers or received from customer during a given period.

  • Monitor monthly consumption of exemption amounts to make sure you do not exceed the agreed limit.

  • Review the monthly consumption of assigned exemption limit.

What type of reports are these?

Oracle Business Intelligence Publisher

In Italy, export transactions are exempted from value-added tax (VAT). Companies classified as regular exporters have more input VAT than output VAT. They can request their suppliers to not charge VAT on transactions for export-related goods. Italian law lets you claim an exemption if you meet certain legal requirements.

These legal requirements are:

  • Your regular exporter ratio is higher than 10 percent.

  • The value of goods and services purchased without VAT charges is lower or equal to your exemption limit.

  • You declare all export activities to your tax authorities.

The exemption limit is the total VAT exemption amount that a regular exporter can claim to its suppliers. A regular exporter can avoid purchasing and importing of goods and services without VAT up to the determined amount or ceiling. This exemption process is considered the Letter of Intent process.

For each year, the initial exemption limit is the sum of all reported export invoices of the previous year. You can allocate your yearly exemption limit among different suppliers. To each supplier:

  • Send a Letter of Intent indicating the exemption amount.

  • Request them not to charge tax when they send the invoices.

At the end of the year, if your total exempt purchases of goods and services is higher than your exemption limit, you incur administrative sanctions and penalties.

Exemption Limit Types

Exemption limits are of two types:

  • Annual: The exemption is manually calculated at the beginning of the year. The calculation is based on the sum of exemption limits for all the reported export invoices of the previous year. Companies can allocate the yearly exemption limit among different suppliers. Send Letters of Intent to each supplier that indicate the exemption amounts and request that they do not charge tax when they send the invoices.

  • Monthly: The exemption is manually calculated at the beginning of each month. The calculation is based on operations in the previous 12 months. This method is used frequently by regular exporters as it allows for progressive increase of exports since it's calculated monthly.

Once exemption limits are defined for a legal entity, the exemption limit type cannot be changed during a calendar year.

Exemption limits can be adjusted during the year to:

  • Reflect the increase or decrease in export activities.

  • Changes in the VAT exemption amount as agreed with the tax authorities.

Exemption Process

The following outlines the steps in the process:

  1. Define the exemption type and exemption limit for the legal entity and calendar year.

  2. For a supplier, create and print a Letter of Intent specifying the limit. The Letter of Intent can also be suspended or revoked, and sent to the supplier requesting that the supplier charge VAT on invoices. An inactive letter can be returned into active status if needed.

    Note: A Letter of Intent can be created for a particular supplier site or for all sites. Define a Letter of Intent:
    1. Select the Manage Tax Exemptions task.

    2. Search for third-party tax profiles for which you want to define the Letter of Intent.

  3. As a customer, receive and register the Letter of Intent. You can set the status of the letter to active, revoked, suspended, or inactive.

    Note: Register the Letter of Intent on a particular site or on all the sites.
  4. Generate Letter of Intent registers and reports to track the exemption amount consumed by the suppliers.

Withholding Tax Reports for Italy

This topic includes details about the withholding tax reports for Italy.

Overview

The withholding tax reports for Italy provide specific withholding tax information on supplier invoices as required by the tax authorities in Italy. You can use these reports to produce withholding tax letters you send to suppliers, reconcile the withholding tax letters sent to suppliers with the yearly amounts withheld for tax and social security, and prepare the yearly declarations for the tax authorities.

The following reports support withholding tax handling for Italy:

  • Withholding Tax Letters for Italy: Creates letters sent to suppliers in Italy that confirm the tax and social security amounts withheld on purchase invoices that are partially or fully paid within a calendar year. Prints for a specific supplier or for all suppliers.

  • Yearly Withholding Tax Report for Italy: Shows the annual taxes withheld by first-party legal entities for a supplier during a specified year, ordered by supplier name, supplier taxpayer ID or supplier tax registration number. Prints the yearly summary of tax and social security amounts withheld for the legal entity. For each supplier and supplier site:

    • The details section lists the tax and social security amounts withheld per invoice.

    • The summary section lists the total tax and social security amounts withheld, grouped by withholding tax rate and withholding social security rate.

The following figure is an example of the Withholding Tax Letters for Italy report.

This image displays the Withholding Tax Letters for
Italy report.

The following figure is an example of the Yearly Withholding Tax Report for Italy.

This image displays the Yearly Withholding Tax
Report for Italy.

Key Insights

The Yearly Withholding Tax Report for Italy must include, in ledger currency, the same withholding tax and social security information printed in the Withholding Tax Letters for Italy report sent to suppliers. These reports leverage the new withholding tax architecture introduced in Release 9.

When defining individuals as suppliers, you must specify the date of birth and place of birth. These details are entered at the supplier header level.

Report Parameters

The following table describes selected process parameters:

Name Description

Legal Entity

Specify the legal entity for reporting.

Year

Specify the calendar year to be included for reporting withholding tax.

Frequently Asked Questions

The following table lists frequently asked questions about the withholding tax reports for Italy.

FAQ Answer

How do I find these reports?

Schedule and run these reports from the Scheduled Processes work area on the Navigator menu.

Who uses these reports?

  • Tax Manager

  • Tax Accountant

  • Payables Manager

  • Payables Specialist

When do I use these reports?

Use these reports to:

  • Create letters for your suppliers in Italy to confirm withheld tax amounts.

  • Reconcile the withholding tax letters sent to your suppliers.

  • Review withheld taxes for each invoice or supplier.

  • Review withheld taxes by calendar year for your first-party legal entities.

What type of reports are these?

Oracle Business Intelligence Publisher

Statutory Heading

Use statutory headings to print the official heading on all statutory reports. After the legal authority approves the header information for your company, this header must appear on all your statutory official company reports.

Note: Statutory headings are printed according to the legal format in Italy, but they can be printed in any other country format.

A statutory heading is printed on every report page with the following information:

  • First-party legal entity name

  • Address

  • Tax registration number

  • Taxpayer ID

  • Commercial ID

Statutory headings have two parameters:

  • First Page Number: Indicates the starting page number to be printed on the report. The default value is 1. The statutory heading prints a sequential page number on each sheet. If necessary, you can print additional sheets beginning from the next page number in the sequence.

  • Report Heading: Indicates the type of heading to be printed on the report. You can either print the first page number or the first-party legal entity information, or both.

You can apply these parameters based on your report.

FAQs for Italy

Why is the credit memo amount not reflecting in the European Purchase Listing of Services for Italy report?

To reflect your credit memo amount in the European Purchase Listing of Services, verify that you have linked the credit memo with a payment invoice. This adds the credit memo amount to the invoice amount when grouping the transactions.

To link the credit memo with an invoice:

  1. Create a new invoice in Oracle Fusion Payables.

  2. Click the Additional Information tab on the Invoice Header section.

  3. Select European Purchase Listing of Services for Italy from the Regional Information list.

  4. Enter the Service Code, Service Mode, Reporting Payment Method, and Reporting Payment Country.

  5. Enter the Credit Memo details.

  6. In the Correct Unmatched Invoices section, enter the invoice to which the credit memo applies.

What's the criteria to use statutory heading parameters in reports for Italy?

The Statutory headings include two parameters: First Page Number and Report Heading.

Here are the criteria to use these parameters in Italy reports:

  • The annual statutory reports that are submitted on a yearly basis always start with page number 1. The page format is:

    <Calendar year> <Page number> of <Total number of pages>

  • The annual statutory reports submitted on a monthly basis must include the First Page Number and Report Heading.

  • The monthly statutory reports submitted on a monthly basis must start with page number 1. It's not required to print the total number of pages.

Note: Any statutory report developed for Italy includes the year and total number of pages in the page format.

Poland

Tax Point Date

Tax Point Date Adjustment

Use the Tax Point Date Adjustment feature to change the tax point date for transactions with a tax point basis of Invoice. You can change the tax point date on an Oracle Payables or Oracle Receivables transaction at either header or line level. When you change the tax point date at the header level, the new tax point date applies to the transaction lines where the tax point date isn't specifically modified.

The feature consists of these processes:

  • Select Transactions for Tax Point Date Adjustment process: Selects transactions to download to a spreadsheet. You can apply bulk updates to the tax point dates of the selected transactions using a spreadsheet, and then upload your changes for processing.

  • Tax Point Date Adjustments process: Selects transactions where you must adjust the tax point date, and updates the tax lines accordingly.

Assign a Security Privilege

Use the Tax Point Date Adjustment feature to change the tax point date for transactions with a tax point basis of Invoice. You can change the tax point date on an Oracle Payables or Oracle Receivables transaction at either header or line level.

Before You Start

To successfully implement Tax Point Date Adjustment, complete the respective Payables and Receivables application setups and the related tax configuration.

Assign a Security Privilege

To change the tax point date on a transaction, you must assign the security privilege. To assign the privilege Run Tax Point Date Adjustment Process to your Tax Manager role:

  1. Navigate to the Security Console page.

  2. From the Search box on the dashboard, select Job Roles.

  3. Search for Tax Manager Custom.

  4. From the Actions menu on the Search Results section, select Edit Role. The Basic Information page appears.

  5. Click Next. The Function Security Policies page appears.

  6. Click the Add Function Security Policy button. The Add Function Security Policy dialog box appears.

  7. Search for Run Tax Point Date Adjustment Process.

  8. In the Privileges section, click the Run Tax Point Date Adjustment Process link.

  9. Click Add Privilege to Role. A confirmation message appears. Close the dialog box.

  10. Click Next.

  11. Save your changes.

Process Transactions Manually in Receivables

The tax point date of a Payables or Receivables transaction can be adjusted at header or line level. The transaction must have a tax point basis of Invoice, and a status of Completed. After changing the tax point date in the Manage Transactions page, the tax manager must submit the Process Tax Point Date Adjustments process.

Invoice Header

Complete the following steps to adjust the tax point date at invoice header level:

  1. Navigate to Receivables> Billing.

  2. On the Tasks panel tab, click the Manage Transactions link in the Transactions section.

  3. On the Manage Transactions page, enter the relevant information, and click Search.

  4. On the Search Results section, select the transaction to be adjusted.

  5. Click Edit.

  6. On the Review Transactions page, click the link Show More.

  7. Click the Miscellaneous tab to see the regional information associated with Receivables transactions.

  8. In the Adjusted Tax Point Date field, enter a valid date.

  9. Click OK.

  10. Save your changes.

Invoice Lines

Complete the following steps to adjust the tax point date at invoice header level:

  1. Navigate to Receivables> Billing.

  2. On the Tasks panel tab, click the Manage Transactions link in the Transactions section.

  3. On the Manage Transactions page, enter the relevant information, and click Search.

  4. On the Search Results section, select the transaction to be adjusted.

  5. Click Edit.

  6. On the appropriate invoice line, click Show More. The Review Invoice Line page appears.

  7. In the Additional Information section, select the Adjusted Tax Point Date field and enter a valid date.

  8. Click OK.

  9. Save your changes.

Process Transactions Manually in Payables

The tax point date of a Payables transaction can be adjusted at header or line level. The transaction must have a tax point basis of Invoice, and a status of Validated. After changing the tax point date in the Manage Invoices pages, the tax manager must submit the Process Tax Point Date Adjustments process.

Invoice Header

Complete the following steps to adjust the tax point date at invoice header level:

  1. Navigate to Payables> Invoices.

  2. On the Tasks panel tab, click the Manage Invoices link in the Invoices section.

  3. Enter the relevant information, and click Search.

  4. Select the invoice to be adjusted, and click Edit from the Actions menu.

  5. Click the link Show More to view the Invoice Header section.

  6. Click the Miscellaneous tab to see the regional information associated with Payables invoices.

  7. In the Adjusted Tax Point Date field, enter a valid date.

  8. Click OK.

  9. Save your changes.

Invoice Lines

Complete the following steps to adjust the tax point date at invoice line level:

  1. Navigate to Payables> Invoices.

  2. On the Tasks panel tab, click the Manage Invoices link in the Invoices section.

  3. Enter the relevant information, and click Search.

  4. Select the invoice to be adjusted, and click Edit from the Actions menu.

  5. Click the link Show More to view the Lines section.

  6. The Update Additional Information dialog box appears.

  7. In the Adjusted Tax Point Date field, enter a valid date.

  8. Click OK.

  9. Save your changes.

Process Tax Point Date Adjustments Using a Spreadsheet

You can now make multiple updates to the tax point dates of an Oracle Payables or Oracle Receivables transaction using a spreadsheet. The Select Transactions for Tax Point Date Adjustment process selects transactions to download to a spreadsheet. You can then upload your changes for processing.

Select Transactions for Tax Point Date Adjustment

Complete the following steps to submit the Select Transactions for Tax Point Date Adjustment process:

  1. Navigate to the Scheduled Processes work area, and search for the Select Transactions for Tax Point Date Adjustment task.

  2. On the Process Details dialog box, enter values for the following parameters as shown in the following table:

    Parameter Description

    Legal Entity

    The legal entity in which the transactions were created

    Tax Registration Number

    The first-party tax registration number of the transactions

    Source

    Payables or Receivables

    From Transaction Date

    The earliest transaction date to be considered

    To Transaction Date

    The latest transaction date to be considered

    From Accounting Period

    The earliest accounting period to be considered

    To Accounting Period

    The latest accounting period to be considered

    Selection Level

    Header or Line

  3. Click Submit.

  4. After the process completes, open the CSV output file in your spreadsheet application.

Columns in the spreadsheet

Consider the following points regarding the content of the columns in the spreadsheet:

  • Column headings ending with _ID are important for processing the updated rows. You must not modify the data in these columns, except when they are displayed in scientific format. If they are displayed in scientific format, you should convert such columns to number, with no decimal places, or you may encounter issues during the upload process.

  • Do not change the order, or add or remove columns in the spreadsheet.

  • Due to the possibility of different locale settings on your computer, any date columns that you intend to use must be formatted with the format DD-MM-YYYY. This includes the following two columns:

    • New_Header_Tax_Point_Date: Populate the new tax point date in this column to modify the tax point date for all the lines of the selected transaction.

    • New_Line_Tax Point_Date: Populate the new tax point date in this column to modify the tax point date for a specific transaction line.

When your updates are complete, use Save As to save your data, and select the comma-separated values or CSV file type.

Upload Spreadsheet for Processing

Perform the following steps to process your spreadsheet updates:

  • Upload the spreadsheet file from your computer to the server.

  • Transfer the uploaded file to the interface table.

  • Process the data in the interface table to update the appropriate tax lines.

Uploading the spreadsheet to the server

Perform the following steps to upload the populated spreadsheet to the server:

  1. Navigate to the File Import and Export page.

  2. Select the icon to upload a file. The Upload File dialog box appears.

  3. Select Browse to select the spreadsheet file containing your data from your computer.

  4. From the list of values for the account, select fin/tax/import.

  5. Click Save and Close.

Transferring the uploaded data to the interface table

Perform the following steps to transfer the uploaded data to the interface table:

  1. Navigate to the Scheduled Processes page.

  2. Search and select the Load Interface File for Import process.

  3. The Process Details page appears. Select Process Tax Point Date Adjustments from the list of values in the Import Process parameter.

  4. Select the file you previously uploaded from the list of values for the Data File parameter.

  5. Click Submit.

Processing the interface table data

When the Load Interface File for Import process completes successfully, submit the Process Tax Point Date Adjustments process, with Import as the Process Type.

Update Tax Lines for Tax Point Date Adjustments

You can update tax lines for tax point date adjustments. Perform the following steps to update tax lines:

  1. Navigate to the Scheduled Processes work area, and search for the Process Tax Point Date Adjustments task. The Process Details dialog box appears.

  2. On the Process Details dialog box, enter values for the following parameters as shown in the following table:

    Parameter Description

    Legal Entity

    The legal entity in which the transactions were created

    Tax Registration Number

    The first-party tax registration number of the transactions

    Source

    Payables or Receivables

    Process Type

    Manual or Import. Select Import to process updates made using a spreadsheet.

    Processing Mode

    Draft or Final.

    From Transaction Date

    The earliest transaction date to be considered

    To Transaction Date

    The latest transaction date to be considered

    From Accounting Period

    The earliest accounting period to be considered

    To Accounting Period

    The latest accounting period to be considered

  3. Click Submit.

Submitting the process in Draft mode provides a list of transactions for which the tax point date of the tax lines is updated. The tax periods for which the reporting may need to be re-processed as a result of the changes are also displayed.

Caution: The Draft mode is not available when the Process Type is Import.

Submit the program again in Final mode to perform the updates. The Tax Point Date History field on each transaction line processed is also updated with a record of the change.

Accounting Entries

The Process Tax Point Date Adjustments does not change the accounting entries of the transactions. Any changes related to accounting entries must be performed manually.

Correction Document for Poland

Process Correction Documents in Receivables

The correction document is created based on the original document that needs to be corrected.

The Correction Documents for Poland background process creates the correction document in the Receivables invoice interface tables and automatically submits the Receivables AutoInvoice process to import the correction document and make it available on the Manage Transactions page.

Create a Correction Document

To create a correction document, complete the following steps:

  1. On the Schedule Processes page, schedule a new process.

  2. On the Process Details dialog box, enter values for the following parameters as shown in the following table:

    Parameter Description

    Business Unit

    Enter the business unit for which the transaction was created.

    Customer Name

    Enter the customer involved in the transaction.

    Transaction Number

    Enter the transaction number to be corrected.

    Correction Reason

    Enter the reason for the correction.

    Transaction Date

    Enter the transaction date to be applied to the correction invoice.

    Accounting Date

    Enter the accounting date to be applied to the correction invoice. The accounting date must be in an open or future-enterable period.

    Whole Price Adjustment

    Select Yes to adjust the price of all lines on the correction invoice to zero.

    Adjust All Lines

    Select Yes to apply a discount to all invoice lines on the correction invoice.

    Discount Percentage

    Enter the percentage discount to be applied to all lines on the correction invoice.

  3. Click Submit.

  4. After the process completes, review the log file for the transaction number of the correction invoice that has been created.

Update a Correction Document

To correct or update a correction document, complete the following steps:

  1. Navigate to Receivables> Billing.

  2. On the Tasks panel tab, click the Manage Transactions link in the Transactions section.

  3. On the Manage Transactions page, search for the correction document you want to update.

  4. Update the Invoice Status to Incomplete, and click Edit.

  5. Add Document Fiscal Classification to the transaction header.

    Note: You cannot modify the following reversal lines attributes:
    • Line Number

    • Description

    • Quantity

    • Unit Price

    • Transaction Business Category

    • Previous Invoice

    • Previous Line

  6. Update other fields as required, and click Save and Close.

  7. Navigate to the Scheduled Processes work area, and search for the Process Tax Point Date Adjustment task.

  8. Submit the task to update the tax lines with the revised tax point date.

Correction Invoices Parameter Options

A correction invoice is a separate value-added tax (VAT) document, which contains the changes to a transaction that has already been issued to a customer.

You can create three different types of correction invoices depending on the following parameter values:

  • Whole Price Adjustment

  • Discount Applicable to All Lines

  • Reversal for Manual Corrections

Whole Price Adjustment

Select Yes for the parameter Whole Price Adjustment to create a correction document which cancels the original invoice. Canceling an invoice means that the lines of the original transaction are reversed, and new lines are created with zero value.

Discount Applicable to All Lines

Selecting the value Yes for the parameter Adjust All Lines results in creation of a correction invoice where the original lines are reversed and each of the new lines has the discount rate applied to the net price of the original lines according to the value provided in the parameter Discount Percent.

Reversal for Manual Corrections

Selecting the value No in both Whole Price Adjustment and Adjust All Lines result in the creation of a correction invoice where the original lines are all reversed, and the correction lines contain exactly the same value. You can then make individual adjustments to the correction invoice lines.

Print Commercial Document

How You Print Commercial Documents

The Print Commercial Documents for EMEA feature lets you define key attributes for the report, such as document type, print mode, and third-party information. To print commercial documents, navigate to the Scheduled Processes page, and search for the Print Commercial Documents for EMEA process.

The following table illustrates the different parameters you can select before you submit the process:

Parameter Description Mandatory

Legal Entity

The legal entity that issued the documents to be printed. The default value is the legal entity that is linked to the reference data set of the user.

Yes

Tax Registration Number

Tax registration number that issued the documents to be printed.

No

Business Unit

Business unit that issued the documents to be printed. The default value is the business unit that is linked to the reference data set of the user.

Yes

Start Date

Start date of the period in which the documents are registered.

No

End Date

End date of the period in which the documents are registered.

No

Third Party Type

Type of third party to which the documents are sent. For Poland the third party type can only be Customer.

Yes

Third Party

The third party to whom the documents have been issued.

No

Third Party Site

The third party site to which the documents have been issued.

No

Print Mode

The options are Draft and Final. The default value is Draft. Use the Draft mode to verify data after your print. Select Final when you are ready to present the printed version to a third-party. Selecting Final also links the copy of the report to the transaction that you can view from the View Transactions page.

Yes

Document Type

Documents to be printed are limited to the specific Document Fiscal Classification that you define.

No

Start Document Number

First number in the range of document numbers to be printed.

No

End Document Number

Last number in the range of document numbers to be printed.

No

Print Currency

Currency in which the documents are to be printed. The options are Entered Currency and Ledger Currency.

Yes

Print Template

Template to be used to print the documents.

No

Order By

The order in which the documents are printed.

Yes

The Print Commercial Documents for EMEA process also launches a child process that performs the invoice printing.

If the Document Type column is empty but in the Print Template column a template is defined, then the transaction is printed using the template defined in the Transaction Type Regional Information field. If both columns are empty and no print template was defined in the corresponding parameter, then the transaction is not printed. The execution report can identify why some transactions, that were selected, were not printed.

Determining the Layout

The process determines the layout for each document in any one of the following processes:

  1. The process checks if a specific layout is requested.

  2. If a layout is not specified, the process checks the layout that you assigned to the Document Fiscal Classification field.

  3. For Receivables transactions, the process also checks the value in the Print Template field in the Regional Information section of the Receivable Transaction Types page.

Reviewing the Execution Report

The Print Commercial Documents for EMEA process checks the following information for the Print Commercial Documents Execution Report:

  • Validity of association between the Document Fiscal Classification or Document Subtype and the template that is used for printing the invoice.

  • Document Fiscal Information such as Third Party Name, Document Number and Transaction Date.

The report lists all the transactions that you selected for printing based on the parameters provided. If the process cannot determine a layout for the print, the report still displays the data extract for the document. In this case, the print template column is blank.

Determining the Document Print Status

When the document is printed in Final print mode, the Print Status field in the Regional Information section on the document header is set to Printed.

When printing a batch of invoices in the final mode, an additional process runs and creates separate attachment files for each one of the transactions in the batch. The attachment file is a copy of the original transaction marked Duplicate to distinguish it from the original invoice. To reprint an invoice which has previously been printed in the Final mode with the print status set to Printed, select the attachment from the main page of the Review Transaction page and print it.

How You Print Commercial Documents Execution Report

This topic contains summary information about the Print Commercial Documents Execution Report.

Overview

The Print Commercial Documents Execution Report lists all the selected transactions to be printed based on the parameters that you have provided. The printing program checks the following information:

  • The validity of the association between Document Fiscal Classification or Document Subtype and the template, which you use for the invoice print process.

  • Document Fiscal Information such as Third-Party Name, Document Number, and Transaction Date.

Key Insights

Before running the reports, ensure that you:

  • Set up the following entities:

    • Data Security

    • Geographies

    • Address Style Format

    • Enterprise Structures

    • Tax Regimes to Rate Flow

    • Tax Profiles for Parties

    • Tax Rules

    • Customers and Suppliers

    • First Party Bank, Branch, and Account

  • Complete the implementation project for your organization before you start the following feature-specific setup.

This is what a typical Commercial Documents Execution Report looks like:

The image describes the Print Commercial Documents
Execution Report.
Report Parameters

This table describes the process parameters:

Parameter Description

Legal Entity

Indicates the legal entity that issues the documents to be printed. The default value is the legal entity that's associated to the reference data set of the user. This parameter is mandatory.

Tax Registration Number

Indicates the tax registration number that issued the documents to be printed. This parameter is optional.

Business Unit

Indicates the business unit that issued the documents to be printed. The default value is the business unit that's linked to the reference data set of the user. This parameter is mandatory.

Start Date

Indicates the start date of the period that the documents are registered in. This parameter is optional.

End Date

Indicates the end date of the period that the documents are registered in This parameter is optional.

Third Party Type

Indicates the type of third party the documents are sent to. For Poland, value of the third-party type is Customer. This parameter is mandatory.

Third Party

Indicates the third party to whom the documents are issued. This parameter is optional.

Third Party Site

Indicates the third-party site to which the documents are issued. This parameter is optional.

Print Mode

Indicates the print mode. Select Draft or Final. The default value is Draft. Use the Draft mode to verify data after your print. Select Final when you're ready to present the printed copy to a third party. Selecting Final also links the copy of the report to the transaction that you can view from the View Transactions page. This parameter is mandatory.

Document Type

Indicates the document type to be printed. The specific Document Fiscal Classification that you defined determines the documents. This parameter is optional.

Start Document Number

Indicates the first number in the range of document numbers to be printed. This parameter is optional.

End Document Number

Indicates the last number in the range of document numbers to be printed. This parameter is optional.

Print Currency

Indicates the print currency in which the documents are to be printed. Select Entered or Ledger. This parameter is mandatory.

Print Template

Indicates the template to be used to print the documents. This parameter is optional.

Order By

Indicates the order in which the documents are printed. This parameter is mandatory.

Frequently Asked Questions

This table lists frequently asked questions about the Print Commercial Documents Execution Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

This report is used by:

  • Receivables Supervisor

  • Receivables Manager

When do I use this report?

Use the Print Commercial Documents Execution report to check:

  • The validity of the association between Document Fiscal Classification or Document Subtype and the template, which is to be used for the invoice print process.

  • Document fiscal information, such as Third-Party Name, Document Number and Transaction Date.

  • The reason for transactions not getting printed.

What type of report is this?

Oracle Business Intelligence Publisher

JPK Extracts for Poland

How can I enter transactions for accounting?

You can use one of these methods, to enter transactions for accounting:

  • Create a Receivables or a Payables transaction in the application, and then account and post these transactions in General Ledger.

  • Import transactions from external sources and then account these transactions in General Ledger.

  • Manually enter transactions in General Ledger using an Adjustment or any other General Ledger category.

After accounting the transactions, you can post them in General Ledger to include in the extract. You must also account and post the journals created directly in General Ledger.

EnterTransactions in Payables and Receivables

To enter transactions in Payables or Receivables, you must specify the document fiscal classification and the first party tax registration number on the header of the Payables invoice or the Receivables transaction.

Define the following components to enter transactions.

VAT Invoice and Payables VAT Correction Invoice

Perform the following steps to populate a Payables invoice or a Receivables transaction with the document fiscal classification code:

  1. For Payables, navigate to the Create or Manage Invoices page. For Receivables, navigate to the Create or Manage Transactions page.

  2. Enter the standard commercial information for each transaction.

  3. For Payables, navigate to the Additional Information tab, and select the appropriate supplier from the list of values in the Taxpayer Representative field. This applies to invoices issued by a taxpayer representative.

  4. For Receivables, navigate to the Miscellaneous tab, and select the appropriate value in the Document Fiscal Classification field. If the value has not been populated automatically, enter the First Party Tax Registration Number.

  5. Click Save.

Receivables Correction VAT Invoice

Receivables transactions with correction VAT invoices must be created according to the rules defined by Correction Documents for Poland. Refer to the Correction Documents for Poland documentation for additional information.

Sales and Purchases through Taxpayer Representative

The taxpayer representative of the company is specified in the Legal Entity setup. Perform the following steps to specify that the purchase is made through the taxpayer representative:

  1. From the Home work area, navigate to the Create Invoices page in Payables.

  2. Click Create.

  3. From the Invoice Header section, navigate to the Show More, Additional Information tab, and select the taxpayer representative attribute in the Regional Information field.

  4. Select a supplier from the list of values in the Taxpayer Representative field.

  5. Click Save.

Create JPK Extracts

This topic includes details about creating JPK extracts for Poland and entering transactions.

Overview

To provide the Polish tax authorities with the JPK extracts, you can schedule one of the following processes from the Scheduled Processes work area:

  • JPK Accounting Books Extract for Poland

  • JPK Bank Statements Extract for Poland

  • JPK Invoices Listing for Poland

  • JPK Sales and Purchase Registers for Poland

Key Insights

Use the JPK extracts to produce the output in a legal format containing the following information:

  • Header section.

    • Extract creation details, such as schema, version, creation date, and purpose.

    • Legal entity information, such as name, address, and registration numbers.

    • Requesting tax authority information.

  • Detail section containing required details in the legally prescribed format.

Prerequisites

Ensure that you submit the following processes before creating JPK extracts for VAT:

  • Select Transactions for Tax Reporting

  • Tax Allocation

Parameters

The following table lists the parameters that apply to all the JPK processes that are mentioned in the topic except when there is a special indication:

Parameter Name Description

Legal Entity

The legal entity under which the selected transactions were made.

Tax Registration Number

The tax registration number of a company or legal entity for which the JPK extract is delivered. Tax registration number is not required for accounting books.

Requesting Tax Authority Code

The code of the tax authority requesting the JPK extract.

Declaration Purpose

The purpose of the declaration. Includes the following information:

  • First declaration delivery

  • Declaration correction

  • Subsequent number of the correct. Used for JPK VAT.

Declaration purpose is not required for accounting books.

Create JPK Extracts

Perform the following steps to run the processes:

  1. Navigate to the Scheduled Processes work area.

  2. Click Schedule New Process.

  3. Search for the process name.

  4. In the Process Details dialog box, enter or select the required parameters.

  5. Click Submit.

How You Create Accounting Books Extracts

This topic includes details about creating accounting books extracts for Poland.

Overview

Submit the JPK Accounting Books Extract for Poland to create the XML output that is required by the tax authorities of Poland.

Parameters

The following table lists the required parameters for the JPK Accounting Books Extract for Poland process.

Parameter Name Description

Data Access Set

The data access set for the legal entity to be used.

Ledger

The ledger that you want to select from the data set to view the accounting activity. You can run the export for one ledger at a time.

Legal Entity

The accounting activity that you can filter by legal entity if you have associated your legal entities with the balancing segments in your chart of accounts.

From Accounting Period

The beginning period of the accounting period. The default value is the first open or closed accounting period for the ledger.

To Accounting Period

The ending period of the accounting period.

Top Level Parent Account

The code of the top level parent account being used for the JPK hierarchy tree.

Account Level

The maximum level that is being used for the JPK Account Hierarchy. The default value is 4.

Natural Account or Complete Account Flexfield

The level of analysis and grouping to be included in the extract.

Subsection Name

Indicate if you want to run the extract for each one of the three sections separately, or for all the accounting books in one extract.

Account Filter

The standard account filtering conditions on the different segments of the accounting flexfield with sub-filter. For example, Account and operator Descendants of can isolate the postable JPK accounts to be presented in the extract.

Output

The output of the JPK Accounting Books Extract process is an XML file, which you can review using your browser or other external applications.

Frequently Asked Questions

The following table lists the frequently asked questions.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

This report is used by:

  • Tax manager

  • Tax accountant

What type of reports are these?

Oracle Business Intelligence Publisher XML reports

How You Create JPK Sales and Purchase Registers Extracts

This topic includes details about creating JPK Sales and Purchase registers for Poland.

Overview

The JPK Sales and Purchase Registers extracts contain the list of Receivables transactions and Payables invoices that meet the minimum requirements as specified by the tax authorities.

Prerequisites

Ensure that you perform the following tasks before creating JPK Sales and Purchase Registers extracts:

  1. Enter and complete all Receivables transactions for the reported period.

  2. Enter and validate all Payables invoices for the reported period.

  3. Post all Receivables transactions for the reported period by submitting the Create Accounting for Receivables transactions process.

  4. Account all Payables invoices for the reported period by submitting the Select Transactions for Tax Reporting for the specified period.

  5. Select the transactions to be included for tax reporting.

  6. Run the Tax Box Allocation process for the reported period by submitting the Tax Allocation process.

  7. Run the JPK Sales and Purchase Registers Extract for Poland process from the Scheduled Processes work area.

Parameters

The following table lists the required parameters for the JPK Sales and Purchase registers for Poland.

Parameter Name Description

Legal Entity

The legal entity that created the register.

Tax Registration Number

The tax registration number for which the JPK extract is delivered.

From Tax Period

The beginning tax period of the period for which the extract is created.

To Tax Period

The ending tax period of the period for which the extract is created.

Register Type

The section to be included in the extract. Options are sales register, purchase register, or both.

Tax Box Set

The codes that you can restrict from displaying in the register output.

Requesting Tax Authority

The tax authority requesting the output.

The extract uses specific sales register and purchase register boxes to map the document to the appropriate section. These boxes also store the total tax amount for the respective sections of the purchase and sales register.

Output

The output of the JPK Sales and Purchase registers for Poland process is an XML file. You can review the output using your browser or other external applications.

How You Print Sales and Purchase VAT Registers

This topic includes details about printing Sales and Purchase VAT registers for Poland.

Overview

The VAT Registers can be printed in the PDF format. The printed output is based on the JPK extract, and contains all transactions selected for JPK VAT. The output also displays the transaction details. The amounts are grouped by JPK Codes or Declaration VAT-7 boxes. Depending on the report parameters, the report can contain sales or purchase registers, or both. You can also restrict the printed output to a certain set of codes, such as domestic transactions only. Codes in the Tax Reporting Type ORA_JEPL_VAT_BOXES_PDF must be defined to select a subset of all tax box allocation boxes.

Key Insights

The Sales and Purchase VAT Registers process creates the following two output files:

  • XML file in the JPK format

  • PDF file with printable registers

Both files contain the same data presented in a different format. Printed registers can be used to verify the content of the JPK extract before sending it to the tax authorities.

Parameters

The following table lists the required parameters for printing the JPK Sales and Purchase VAT registers for Poland.

Parameter Name Description

Legal Entity

The legal entity that created the register.

Tax Registration Number

The tax registration number for which the JPK extract is delivered.

From Tax Period

The beginning tax period of the period for which the extract is created.

To Tax Period

The ending tax period of the period for which the extract is created.

Register Type

The section to be included in the extract. Options are sales register, purchase register, or both.

Tax Box Set

Restrict the codes displayed in the register output.

Requesting Tax Authority

Select the tax authority requesting the output.

Prerequisites

Ensure that you complete the following tasks before printing either the VAT Registers or the JPK VAT extract file:

  1. Create transactions for a period and complete the transactions for Receivables, or validate the invoices for Payables.

  2. Run the Create Accounting process for Receivables and Payables. Verify if the transactions were accounted correctly.

  3. Run the Select Transactions for Tax Reporting process for your legal entity and reported period.

  4. Run the Tax Allocation process for the tax registration number of the legal reporting unit to be reported.

  5. Verify the result of the allocation by running the following reports with the same parameters as the Tax Box Allocation:

    • Tax Allocation Listing Report

    • Tax Allocation Exemptions Report

Print Sales and Purchase VAT Registers

Run the following processes to provide the printed Sales and Purchase VAT Registers to the tax authorities:

  • JPK Sales and Purchase Registers for Poland: Contains the JPK_VAT file in the XML format.

  • Sales and Purchase VAT Register for Poland: Contains the Sales, Purchase, or both VAT Registers in the PDF format.

Perform the following steps to run the process:

  1. Navigate to the Scheduled Processes work area.

  2. Click Schedule New Process.

  3. Search for the process name.

  4. In the Process Details dialog box, enter the required parameters.

  5. Click Submit.

Create JPK Bank Statements Extracts

This topic includes details about creating JPK Bank Statements Extracts for Poland.

Parameters

This table lists the required parameters for the JPK Bank Statements Extracts for Poland.

Parameter Name Description

Legal Entity

The legal entity that created the register.

Tax Registration Number

The tax registration number for which the JPK extract is delivered.

Bank Account

The bank account for which the extract is created.

From Date

The start date of the period for which the extract is created.

To Date

The end date of the period for which the extract is created.

Tax Authority

The tax authority requesting the extract. You can view the tax authority code in the JPK extract.

Create JPK Bank Statements Extracts

JPK Bank Statements Extract for Poland is based on entered bank statements. To submit the JPK Bank Statements Extract for Poland process:

  1. Navigate to the Scheduled Processes work area.

  2. Click Schedule New Process.

  3. Search for the process name.

  4. In the Process Details dialog box, enter the required parameters.

  5. Click Submit.

JPK Bank Statements Line Selection Rules

The JPK Bank Statements Extract can be created for any specified period. The extract is always created for one bank account and assigned to the reporting legal entity. The bank account reported must have a defined IBAN number since it's displayed as the account number in the file.

The JPK Bank Statements Extract is created as an XML file in the legally required format, JPK_WB. The bank statements are selected based on the following rules:

  • All bank statements with a start date between the dates From Date and To Date are selected.

  • All lines with a value date between the dates in the parameters are selected. If the value date is blank, then the accounting date is retrieved from the line date, and is compared with the parameter dates.

  • Debit lines are displayed as negative amounts.

  • Credit lines are displayed as positive amounts.

  • Statements lines are ordered by the line date.

  • The extract opening balance is equal to the opening balance of the earliest bank statement period selected by the extract.

  • The extract closing balance is calculated by adding or subtracting amounts of all lines in the extract to the opening balance.

  • Credit and Debit totals are calculated in the following manner:

    • Credit total is the sum of all positive amounts in the extract.

    • Debit total is the sum of all negative amounts in the extract. The total amount is displayed with a positive sign.

  • All selected lines are counted and the line count is displayed in each line.

    The credit total, debit total, and the number of lines are displayed in the file Control section.

    You must be assigned the Cash Manager role to enter bank statements. To enter bank statement lines:

    1. Navigate to Cash Management> Create Bank Statements page.

    2. Enter and save the bank statement header.

    3. Enter the bank statement lines.

    It is sufficient to enter and save a Bank Statement. Reconciliation does not affect the content of the extract.

Enter all the bank statements for the reported period to generate the correct bank statement extract data. You must also populate the following statement line level fields on the Create Bank Statement Line page:

  • Booking Date

  • Flow Indicator: Debit or Credit

  • Amount: Positive amount

  • Counterparty Bank Account Name

  • Customer Reference

  • Additional Entry Information

Spain

Reporting Features for Spain

Oracle Fusion Applications provide standard financial and tax reports to meet the legal and business reporting requirements of tax authorities. For countries like Spain, a set of country-specific reports is provided to meet the local reporting requirements for VAT, Modelo and withholding tax.

The following tables are the lists of reports for Spain by type.

VAT Reports

Report Name Description

Input VAT Journal for Spain

Provides summary and detail tax information about invoices and expense reports. Reports by register type, such as recoverable tax register or nonrecoverable tax register. Selects transactions based on tax reporting type and tax reporting code.

Output VAT Journal for Spain

Provides summary and detail tax information about transactions. Reports by register type, such as tax register or nonrecoverable tax register. Selects transactions based on tax reporting type and tax reporting code.

VAT Inter-EU Invoice Journal for Spain

Provides summary and detail information about invoices received in Spain from suppliers located in any European Union member state. Includes invoices with offset or self-assessed tax distributions. Selects transactions 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 VAT Inter-EU Invoices Journal for Spain. Selects transactions based on tax reporting type and tax reporting code.

Modelo Reports

Companies registered in Spain for tax purposes are legally required to submit periodic and annual turnover reports to the tax authorities in a predefined format. The following reports support the specific formats for Modelo declarations 340, 347, 349 and 415:

Report Name Description

Modelo Electronic File Generation for Spain

Prepares the electronic file for Modelo 340, 347, 349, or 415 declarations.

Modelo Verification Report for Spain

Lists all payables invoices and receivables transactions that are reported in the Modelo 340, 347, 349 or 415 declarations.

Withholding Tax Reports

Companies in Spain are legally required to submit withholding tax reports to tax authorities in a predefined format called Modelo 190. The following reports support Modelo 190 submission:

Report Name Description

Withholding Tax Extract for Spain

Extracts withholding transactions and stores them in an interface table to be used for reporting withholding tax transactions.

Withholding Tax File for Spain

Lists withholding tax transactions in a flat file using a predefined layout.

Withholding Tax Report for Spain

Provides summary or detail withholding tax information about transactions.

VAT Reports for Spain

This topic includes details about the VAT reports for Spain.

Overview

Oracle Fusion Applications provide a set of VAT reports to meet the legal and business reporting requirements of tax authorities.

The VAT reports for Spain include:

  • Input VAT Journal for Spain: Provides summary and detail tax information on recoverable and nonrecoverable tax for accounted transactions entered in Oracle Fusion Payables and tax repository. Reports by register type, such as recoverable tax register or nonrecoverable tax register.

    The following figure is an example of the report.

    Input VAT Journal for Spain
  • Output VAT Journal for Spain: Provides summary and detail tax information on recoverable and nonrecoverable tax for accounted transactions entered in Oracle Fusion Receivables and tax repository. Reports by register type, such as recoverable tax register or nonrecoverable tax register.

    The following figure is an example of the report.

    Output VAT Journal for Spain
  • VAT Inter-EU Invoice Journal for Spain: Provides summary and detail information on invoices received in Spain from suppliers located in any European Union member state. Includes invoices that have offset or self-assessed tax distributions.

    The following figure is an example of the report.

    VAT Inter-EU Invoice Journal for Spain
  • VAT Inter-EU Invoice Format for Spain: Lists details of the same invoices that appear on the VAT Inter-EU Invoices Journal for Spain. Selects transactions based on tax reporting type and tax reporting code.

    The following figure is an example of the report.

    VAT Inter-EU Invoice Format for Spain

Key Insights

You can report transactions based on a specific tax reporting type and tax reporting code or report transactions associated with all the tax reporting types and codes. Ensure that you create relevant tax reporting types and tax reporting codes and assign them to tax rates before running the reports. When the tax rate is applied to a transaction, tax reporting type and tax reporting code is also applied.

If you want to use a calendar for tax reporting that is different from the accounting calendar, set up a new calendar and associate it with the tax reporting entity. However, before you create a new calendar, you must set up a new tax reporting entity.

Before you run the VAT reports for Spain, ensure you:

  • Configure the document sequence to be used for reporting and printing transactions on the reports.

  • Run the Select Transactions for Tax Reporting process to select and mark transactions for reporting.

When you finish reviewing the reports and want to close the tax period, run the Finalize Transactions for Tax Reporting process. The process marks all the reported transactions as finally reported.

Report Parameters

The following table lists selected parameters for the VAT reports for Spain:

Parameter Description

From Tax Calendar Period and To Tax Calendar Period

Specify the tax calendar period range for reporting data. The transactions are selected for reporting based on the tax point date that is within the specified tax calendar period range.

Tax Reporting Type

(Optional) Select a tax reporting type created in Oracle Fusion Tax. Select the appropriate tax reporting type for reporting VAT on transactions for Spain.

Tax Reporting Code

(Optional) Select a tax reporting code created as a part of the tax reporting type that you previously selected. Specify the tax reporting code for reporting VAT on transactions for Spain.

Enable Reporting Sequence

Indicate whether you want to print reporting sequences for your transactions.

Register Type

Select the register type. You can select tax register, nonrecoverable tax register, or both. This parameter is applicable only for:

  • Input VAT Journal for Spain

  • Output VAT Journal for Spain

Note: When you want to list transactions with interim tax, run the Interim Tax Register.

Start Invoice Sequence

Indicate the starting invoice sequence number. When you want to continue the reporting sequence numbers from the previous reporting period, specify the number you want to use as the starting number for this period. The default value is 1.

Frequently Asked Questions

The following table lists frequently asked questions about the VAT reports for Spain.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Tax Manager

  • Tax Accountant

When do I use this report?

Use the VAT reports for Spain to review tax information on:

  • Invoices and transactions entered in Payables and Receivables

  • Transactions that are manually entered in the tax repository

  • Invoices received in Spain from suppliers located in any European Union member state

You can also use these reports for tax reconciliation and for preparing tax declarations.

What type of reports are these?

Oracle Business Intelligence Publisher

Modelo Reports for Spain

This topic details about the tax box allocation reports.

Overview

The Modelo Reports for Spain are legally required turnover reports. These reports are delivered electronically in a predefined format to the tax authorities in Spain.

The Modelo reports for Spain include the following :

  • 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 payable 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 with a value more than the entered minimum cash amount are reported.

Key Insights

Modelo reporting is based on accounting date or transaction date, depending on the type of Modelo and source of data.

You can report a transaction in multiple reports, which can be submitted annually, quarterly, or monthly.

Run Modelo Electronic File Generation for Spain for one period at a time and verify your transactions or summary data.

Report Parameters

Let's understand the selected report parameters:

Parameter Description

Modelo Name

Select the Modelo type. Available values for this parameter are: Modelo 340, 347, 349, or 415

Source

Select Payables or Receivables. Modelo reporting doesn't include manually entered tax transactions.

Minimum Transaction Value

Select the minimum transaction amount to be reported. This parameter is required for Modelo 347 and 415.

Receipt Method

Select the Receivables receipt method that's used to record customer payments in cash. Only receipts with the specified receipt method are selected and compared with the cash amount limit. The cash amount limit is specified using the Minimum Cash Receipt Amount parameter.

Minimum Cash Receipt Amount

Specify the minimum amount for payments in cash.

Selection Status

Select the status of the transactions to be reported. The available options are all, preliminary, and final

Driving Date

Select the transactions based on transaction date or accounting date.

Frequently Asked Questions

Here are some frequently asked questions about the Modelo Reports for Spain.

FAQ Answer

How do I find this report?

You can schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Tax Manager

  • Tax Accountant

When do I use this report?

You can use these reports to do the following things:

  • Review your payables and receivables transactions before reporting to the tax authorities.

  • Report to the tax authorities in Spain in a predefined format.

What type of reports are these?

These are Oracle Business Intelligence Publisher reports.

How Modelo Reports for Spain are Generated

The Modelo Reports for Spain are legally required turnover reports, delivered electronically in a predefined format to the tax authorities in Spain. Companies operating under the Spanish VAT regime or Canary Islands IGIC regime must submit the following Modelo declarations:

  • Modelo 340

  • Modelo 347

  • Modelo 349

  • Modelo 415

Modelo reporting is based on accounting date or transaction date, depending on the type of Modelo and source of data. You can report a transaction in multiple reports, which can be submitted annually, quarterly, or monthly.

Settings That Affect Report Generation

Before you generate the Modelo reports, you must:

  • Complete and validate all the transactions.

  • Enter appropriate data in the global descriptive flexfields.

  • Select the transaction business category, document fiscal classification, and user-defined fiscal classification attributes for the transactions.

To report transactions correctly in the Modelo reports, use the following transaction attributes:

Source Application Field Name Information used for Header or Line Level Information Used in Modelo

Payables or Receivables

Business Category

Tax setup, such as transaction business category

Line

347, 349, 415

Payables or Receivables

Document Fiscal Classification

Tax setup, transactions or document type

Header

340

Payables or Receivables

User-Defined Fiscal Classification

Tax setup, such as transactions or user-defined fiscal classification

Line

340

Receivables

Global Descriptive Flexfield

Global descriptive flexfield attribute

Header

340, 347, 349, 415

Human Capital Management

HR Location

Property address defined for each transaction related to property rental

Header

347

Human Capital Management

HR Location

Land registry reference number for transaction related to property rental

Header

340, 347

Payables or Receivables

Product Type

Goods or services for intra-EU operations

Line

349

Receivables

Intended Use

Triangulation

Line

349

Payables or Receivables

Tax Reporting Code

Tax reporting codes assigned by tax rule to intra-EU transactions based on source, product type and intended use

Line

349

Payables or Receivables

Tax Rule

Tax reporting codes, based on party bill to and ship-to address, source, product type and intended use

Line

349

How Reports Are Generated

To generate the Modelo reports, run the following processes in the specified order:

  1. Run the Turnover Reporting Selection Process in preliminary mode.

    Select the Reporting Group parameter as Modelo Reporting for Spain. The Turnover Reporting Selection Process selects all the transactions with accounting date or transaction date within the selected periods.

  2. Run the Modelo Verification Report for Spain.

  3. Run the Modelo Electronic File Generation for Spain to generate XML files for Modelo 340, 347, 349, and 415, for a specific period.

  4. Run the Turnover Reporting Selection Process in final mode to mark transactions as reported.

Withholding Tax Report for Spain

This topic explains about the withholding tax reports for Spain.

Overview

The Withholding Tax Report for Spain is an annual report that's submitted to the tax authorities at the beginning of the year. Using this report you can list the operations of the previous year.

The Withholding Tax Reports for Spain includes:

  • Withholding Tax Extract Report for Spain: Extracts the withholding tax transactions for Spain, and stores them in an interface table. You can select information based on a specific legal entity, and optionally based on a specific supplier.

  • Withholding Tax Report for Spain: Identifies summary or detail of withholding tax information for Spain by invoice and withholding tax type. You can print information for a selected legal entity, and optionally for a specific supplier.

  • Withholding 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.

Here's an example of the report.

Withholding Tax Report for Spain

Key Insights

When you submit the Withholding Tax Data Extract Report for Spain, the data extract overwrites the transactions stored from any previous submission.

The Withholding Tax Report for Spain lists only invoices that are posted to the general ledger, and includes prepayments. When you apply prepayment to an invoice on a date other than the invoice accounting date, the report displays prepayment as a negative amount with the prepayment application date.

Report Parameters

The following table lists selected report parameters:

Parameter Description

Withholding Tax Type

Select one of the following:

  • Spanish Income Tax Withholding (Modelo 190)

  • Spanish Nonresidents Withholding

  • Spanish Investment Income Withholding

  • Spanish Property Rental Withholding

Selection Criteria

Select one of the following:

  • Invoice accounting date, for validated or approved transactions only

  • Payment date, for paid withholding transactions only

Frequently Asked Questions

Here are few frequently asked questions about the Withholding Tax Reports for Spain.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Tax Manager

  • Tax Accountant

When do I use this report?

Use these reports to declare withholding and payments on account of income from employment, economic activities, prizes, certain capital gains and income allocations.

What type of reports are these?

Oracle Business Intelligence Publisher

Submit Online VAT Reporting for Spain

Use the Online VAT Reporting for Spain process to report VAT online. Use Addition as the Communication Type to report new transactions, which are in the Ready or Null status, for tax reporting. You can submit the Online VAT Reporting for Spain process daily, every other day, or multiple times a day.

Complete the following steps to submit Online VAT reporting for Spain:

  1. Navigate to the Scheduled Processes work area, and submit the Online VAT reporting for Spain process.

  2. On the Process Details dialog box, enter the parameters as displayed in the following table:

    Field Value

    Tax Registration Number

    Enter the tax registration number.

    Currency

    Select your reporting currency. The default value is the functional currency of the primary ledger.

    Note: Reporting or secondary ledger name is activated if the currency is not the functional currency.

    Register Type

    Select any of the following register types:

    • Issued invoices register

    • Received invoices register

    • Intra-EU invoices register

    • All

    From Date

    Select a date.

    To Date

    Select a date.

    Communication Type

    Select Addition.

    Selection Mode

    Select either of the following options:

    • Review: To verify your report before submission.

    • Report: To submit your report directly.

The following table displays the processes that are submitted depending on the register selected as the parameter:

Register Name Processes Submitted Entities Updated After Submission

Issued Invoices Register

Invoices for the Issued Invoices Register

Receivables Invoices

Issued Invoices Register

Collections for the Received Invoices Register

Receipt Applications

Received Invoiced Register

Invoices for the Received Invoices Register

Payables Invoices

Received Invoiced Register

Payments for the Received Invoices Register

Payment Applications

Selected Intra-EU Transactions Register

Selected Intra-EU Transactions Register

Receivables and Payables Invoices

Use the Online VAT Reporting for Spain process to perform the following:

  • Select Issued Invoices Register as the Register Type. The process then selects the AR transactions in the modified status and generates an output file in a predefined format for the register type. The process also initiates payments message creation for any payments corresponding to deferred tax transactions in the selected date range.

  • Select Review as the Selection Mode to get XML messages for your review. These messages indicate the review only status, and must not be submitted to the tax authority.

  • Select Report as the Selection Mode so that the XML messages are created for submission. These messages are submitted to the tax authority. The transactions and payment applications are also updated as submitted. The transaction status is updated as submitted.

  • Update the transactions you have modified by updating transaction status at header level as Modified. You can correct the data on the transactions, save the transaction and then submit the Online VAT Reporting for Spain process in Modified mode. If you do not want to submit a transaction that is returned by tax authorities, change the transaction status to On Hold to prevent the transaction from being submitted when you run the process.

How Annual Online VAT Reporting for Spain is Processed

You can use either the Cash Collections register or the Investment Goods register to submit the Annual Online VAT reporting for Spain.

Cash Collections Register

Use the Cash Collections Register to report your cash collections from your customers who have yearly amounts exceeding 6000 EUR that are paid in cash.

Submit the Cash Collections Register

To submit the register, complete the following steps:

  1. Submit the Cash Collections Register from the Setup and Maintenance work area.

  2. The Process Details dialog box opens. Select a Tax Registration Number.

  3. Select Cash collections register as the Register Type.

  4. Enter the Year for which you want to report the cash collections.

  5. Select Addition as the Communication Type.

  6. Select Report as the Selection Mode. You can also submit the process in Review mode to verify the data that you have entered.

When you click Submit with Report as the Selection Mode, the reported customer accounts and sites are updated with the Submitted status.

Note: If a customer has multiple sites but a single Taxpayer ID or Tax Registration Number, cash payments from all sites are added and reported together. For customers with both Spain and other EU country sites, the reporting process groups the cash receipts separately based on the Taxpayer IDs or Tax Registration Numbers.

Investment Goods Register

The Investment Goods Register, which contains the fixed assets transactions, contains the following transaction types for Invoices:

  • Addition

  • Modification

  • Deletion

  • Inquiry

Note: The register reports information about the year-end investment goods. Hence, the investment goods invoices that appear in the register are already reported in the Received Invoices register.

Prerequisites

Complete the following setups before you submit Annual Online VAT Investment Goods Register:

  1. Select your asset categories on the Manage Asset Categories page. Select the category and enter one of the predefined values for the Investment Goods Reporting field. The values are 10 Years, 5 Years, and No. If you don't enter any value, No is applied as the default value.

  2. Manage your asset level exceptions in the Update Descriptive Details page. On the page, select the asset you want to modify, and click Update Descriptive Details. You can either enter or change the value in the Investment Goods Register field.

Submit the Annual Online Investment Goods Register Process

Run the Annual Online Investment Goods Register process once all your yearly asset invoices are fully processed, and the corresponding asset additions and cost adjustments are created in your Assets application. To submit the process, complete the following steps:

  1. Submit the Annual Online Investment Goods Register from the Setup and Maintenance work area.

  2. The Process Details dialog box opens. Select a Tax Registration Number.

  3. Select Cash collections register as the Register Type.

  4. Enter a From Invoice Date.

  5. Enter a To Invoice Date.

  6. Click Submit.

An Asset invoice is eligible to be reported only if the invoice meets the following conditions:

  • The asset invoice date is within the From Invoice Date and To Invoice Date.

  • The asset belongs to one of the two types for Investment Goods Reporting: 10 years, and 5 years.

  • The Asset level override value isn't No. A blank value doesn't mean No in this context.

If all the conditions are met, the Annual Online Investment Goods Register process selects and lists all the required information in an XML format. You can edit and modify the XML file before submitting to the tax authorities. You can also use an excel format for your output.

How Annual Online VAT Response for Spain is Processed

After the application receives the response messages, you can upload the messages for confirmation processing. Each response message is assigned a unique ID.

Upload the Confirmation Response Messages

Complete the following steps to upload the response messages:

  1. Sign in to the UCM server.

  2. Select New Check-In.

  3. The Content Check-In Form is available. Enter the mandatory values.

  4. Click Browse to select the XML confirmation message as your primary file.

  5. Click Check In to receive a unique Content ID. Use Content ID as a parameter for the respective register when you run the confirmation process

Submit the Annual Online VAT Response for Spain process

Complete the following steps to submit the process:

  1. Search for the Annual Online VAT Response for Spain process on the Setup and Maintenance work area.

  2. The Process Details dialog box opens. Review all the parameters, and click Submit.

  3. After you click Submit, the process updates customer accounts and sites that were reported to the tax authorities with the corresponding confirmation information.

  4. Ensure that the Tax Authority status is now Approved. This means that the record is correctly validated by the tax authority.

Retroactive Reporting

Use retroactive reporting to report VAT transactions in any given range for which the company has not already submitted VAT data online.

Retroactive reporting includes mandatory and optional setups.

Mandatory Setup

The following is the setup list required for retroactive reporting:

  • Lookup Type: ORA_JEES_SII_RETROACTIVE_DATES

  • Lookup Codes: The default lookup code is ORA_EFFECTIVE_DATES, with the start date as January 1, 2017 with the Retroactive option enabled. The application automatically assumes June 30, 2017 as the end date. You can change the dates, or disable the original line and add a new range.

    Note: Enable only one lookup code before you run retroactive reporting.
  • Application and Party Level Lookups: The application and party level default value are the same for normal and retroactive reporting.

  • Global Descriptive Flexfields: You don't need additional transaction level global descriptive flexfields for Online VAT Reporting for Spain. Changes in global descriptive flexfields are only for the retroactive data that has been reported through Modelo reporting. The following Modelo contexts are predefined:

    • JE_ES_MODELO347

    • JE_ES_MODELO347PR

    • JE_ES_MODELO349

    • JE_ES_MODELO415_347

    • JE_ES_MODELO415_347PR

Optional Setup

Consider the following before you run retroactive reporting:

  • To assign user-defined attributes to any of the invoices in the retroactive date range, such as document type override, query the transactions and update the necessary changes in the Regional Information tab with Online VAT Reporting for Spain. Don't make any other SII changes to your transactions.

  • Ensure the application and party level defaults are complete.

  • If you have excluded supplier or customer accounts or sites from selection and if you have exceptions for these third parties and sites, query the corresponding transactions in both Payables and Receivables and select E in the Regional Information field.

Create Retroactive Reports

This topic includes details about the retroactive reports for Spain.

Overview

Use retroactive reports to generate and report transactions that occurred before:

  • The start date of online reporting, which is July 1, 2017.

  • The company revenue exceeded six million Euros.

Create Reports

Use the following steps to create retroactive reports for Spain:

  1. On the Scheduled Processes work area, run the Online VAT Reporting for Spain process.

  2. Select Yes for the Retroactive parameter in the Process Details dialog box. The default value is No.

    Note: Don't select Selected Intra-EU Transactions Register as the Register Type for retroactive reporting.
  3. The report generates XML messages for the selected date range. Ensure that the date range you entered is consistent with the enabled lookup code start and end dates for the ORA_JEES_RETROACTIVE_DATES lookup.

  4. Enable the Retroactive parameter.

  5. If you're running the report for the first time, select Addition as the Communication Type. For subsequent times, select Modification as the Communication Type.

  6. Submit the Online VAT Reporting Confirmation for Spain.

  7. You can now submit the retroactive reports to the tax authorities.

FAQs for Spain

How can I exclude transactions from immediate submission?

To postpone submitting a ready transaction, change the transaction status to On Hold. Once the transaction is ready for submission, update the transaction status back to Ready.

How can I mark a transaction for reporting directly to the tax authorities?

To mark a transaction for reporting manually through the tax authorities' website, change the Transaction Status to Directly Reported.

You must not change the submission status after you report the transaction. If your reporting wasn't successful, contact the tax authorities.

Turkey

Exchange Rate Difference Report for Turkey

This topic includes details about the Process Exchange Rates Difference report.

Overview

This report summarizes the exchange rate differences for invoice, credit memo, and journal. Use this report to:

  • View ledger currency including tax components.

  • Print the eligible gain/loss lines that are processed by the Process Exchange Rates Difference job for each trading partner and site.

Key Insights

You must run the Process Exchange Rate Difference job before running this report. The report output is a predefined PDF format that displays the following information:

  • Eligible gains/losses in terms of the total exchange rate difference amount, recorded for a trading partner enabled to generate the exchange rate difference invoice.

  • Total tax amount segregated from the total exchange rate difference amount.

  • Line level information for the invoice, credit memo, and journal.

Use the report grouping to view the details of eligible gain/loss incurred and how it is processed at various levels. The trading partner and trading partner site at each level are the final grouping level. The following combinations are used:

  • Exchange rate difference type, creation option, status, transaction currency, and receipt currency

  • Exchange rate difference type, and creation option

  • Exchange rate difference type

When you search for processed records, the report displays additional information about reference numbers of the invoices, credit memos, and journals. This reference number can be used to query exchange rate difference invoices, credit memos, and journals.

The following figure is an example of the report.

Process Exchange Rate Difference Report

Report Parameters

The following table describes selected process parameters:

Parameter Description

Source

Specify the subledger application for which the report must be run. The available options are Accounts Receivables and Accounts Payables. The default value is Accounts Receivables.

Business Unit

Specify the business unit for which the report must be run. The default value is the business unit to which a user has access. If a user has access to multiple business units, the default is the last used business unit.

Period

Specify the period for which the report must be run. The list of values includes all the open subledger periods.

The default value is the earliest unprocessed open period if the exchange rate difference is enabled. Otherwise, it is the earliest open general ledger period.

Unprocessed Only

Specify if the report must be printed for unprocessed or processed records. If you select Yes, only the lines that were processed in the preview mode of the exchange rate difference job are printed. If you select No, all the invoices, credit memos, and journals are printed.

Report Mode

Specify the layout of the report. Valid values are Detail and Summary. If the report is submitted in the detail mode, it displays both header and line level details for each record. If the report is submitted in the summary mode, it displays only the header level details for each record.

Frequently Asked Questions

The following table lists frequently asked questions about the Process Exchange Rate Differences Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Tax Manager

  • Tax Specialist

  • Tax Accountant

  • Accounts Receivable Manager

  • Accounts Receivable Specialist

  • Accounts Payable Supervisor

  • Accounts Payable Manager

  • Accounts Payable Specialist

When do I use this report?

Use the Process Exchange Rate Differences report to analyze records. These records are of the following types:

  • Unprocessed records: These include the exchange rate difference gain/loss lines after they have been processed. Use these records to envision the exchange rate difference invoices, credit memos, and journals that are going to be created.

  • Processed records: These include the exchange rate difference invoices, credit memos, and journals that have been created.

What type of reports are these?

Oracle Business Intelligence Publisher

United Kingdom

Reverse Charge Sales Listing Report for UK

This topic includes details about the Reverse Charge Sales Listing Report for UK.

Overview

The Reverse Charge Sales Listing Report for UK lists the sales transactions for UK 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). Reported data is grouped by customers.

The following figure is an example of the report.

Reverse Charge Sales Listing Report for UK

Key Insights

Before you run the report, configure self-assessed tax in Oracle Fusion Tax and ensure that transactions with self-assessed tax are available for reporting.

The report output is available in two formats:

  • XML: Provides a readable view of the report.

  • CSV: Creates the electronic output to submit the report to HMRC.

HMRC requires a specific format for the CSV version, no specific format for the XML output.

Report Parameters

The following table describes selected report parameters of the report:

Parameter Description

Legal Entity

Specify the legal entity submitting the declaration to the tax authority.

Tax Registration Number

Specify the tax registration number of the legal entity or legal reporting unit submitting the declaration to the tax authority.

Tax Reporting Type

Indicate the appropriate reporting type that you defined to be used for reporting of reverse charges. Tax reporting type identifies a specific unit of information, such as a date or a text comment, to associate with a specific tax usage.

Tax Reporting Code

Specify the appropriate tax reporting code.

From Tax Point Date and To Tax Point Date

Print all the transactions based on the selected tax point date range.

Frequently Asked Questions

The following table lists frequently asked questions about the Reverse Charge Sales Listing Report for UK.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Tax Manager

  • Tax Accountant

When do I use this report?

Use this report to provide details of high value sales transactions that are subject to reverse tax charges.

What type of reports are these?

Oracle Business Intelligence Publisher

Russia

Customer Balance Reconciliation Report for Russia

Use the Customer Balance Reconciliation Report for Russia to comply with the Russian legislation on the 'Act of Reconciliation of Balance between Customer and Supplier'. You can create the report based on a legal entity and select the transactions based on a business unit. The report lists receivables documents (invoices, debit memos, credit memos) and customer payments to periodically reconcile settlements based on the act. You can also use this report to get the summary of reconciliation of balance between a customer and a supplier. The summary includes description number, document type, organization name, and invoiced amount.