Skip Headers

Oracle Financials for Europe User Guide
Release 12.1
Part Number E13421-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

EMEA VAT Reporting

VAT Reporting Overview

Oracle Financials for Europe enables the EMEA countries to streamline their VAT reporting. Using the VAT report processing feature, EMEA countries can meet the following business needs:

VAT Reporting Process Flow

The VAT report processing functionality in Oracle Financials for Europe involves several broad user procedures. The EMEA VAT reporting process requires the financial administrators and personnel to complete the following:

See: Setting up VAT Reporting and VAT Reporting Process

VAT Pre-Reporting Concurrent Program

Before you can use VAT reporting in Oracle Financials for Europe, you must run the EMEA VAT: Pre Reporting Process concurrent program. This program can only be run from the Reporting Level. The EMEA VAT: Pre Reporting Process only needs to be run the first time you run reports in Oracle Financials for Europe. The following table describes parameters for running this concurrent program.

EMEA VAT: Pre Reporting Process Concurrent Program Parameters
Parameter Description
Reporting Level The reporting level for which you want to run reports. It can be Ledger or Balancing Segment.
Ledger If you select Ledger or Balancing Segment as the reporting level, you must enter the ledger name.
Balancing Segment Enter the Balancing Segment value if you selected Balancing Segment as the Reporting Level.
Last Reported Period The last period in which EMEA VAT reports were submitted.

Setting up VAT Reporting

To process VAT reports, implementers and financial personnel perform the following:

Prerequisite activities

VAT Setup activities

See: Setting up EMEA VAT Reporting Entities

Record the following VAT processing information:

Setting up EMEA VAT Reporting Entities

To process VAT reports, you must set up the reporting entities for the registration number associated with a legal entity and regime.

Note: Ensure that you define tax registrations for all legal establishments that have the applicable VAT tax requirement. See: Setting up VAT Reporting

You can customize your VAT reporting process by specifying the tax calendar for a tax registration number, threshold amounts, allocation rules, and VAT registers in the EMEA VAT Reporting Entities Setup window. The window tabs and related functions are:

The following table describes the fields on the Configuration tab:

Name Description
Tax Calendar Name of the calendar to be associated to the tax registration number.
Threshold Amount The threshold amount value set for the legal entity or tax regime that have tax transactions. If you leave this field blank, then the application reports all tax transactions.
Some countries like Spain report transactions or make declarations to the authorities if the amount is over a certain threshold value.
Enable Allocations Select to setup allocation rules in the Allocation Rules tab.
Enable Annual Allocations Select to enable annual allocations. This option is enabled only if Enable Allocations is checked. Based on this option, allocation process decides whether to do only periodic or both allocations at the same time. If annual allocation is enabled, final reporting cannot happen if both periodic and annual allocation is not completed successfully.
Enable Report Sequence Select to enable report level sequence number while running the reports. For numbering transactions, you can print the document sequence number for the transaction, or you can print the report-specific sequence number. For example, countries like Poland use the report Level sequencing.
VAT Reporting Date Enter the country’s tax reporting date based on the tax registration number.

The following table describes the fields on the Allocation Rules tab:

Note: You can select the VAT transaction type, tax name, and tax status that you defined in E-Business Tax. If you define the rule for a tax, all tax rate codes that falls within that tax are applicable to the rule defined. You can override this rule at any level or define a different rule for status, jurisdiction, and tax rate code.

Name Description
Source Source of the tax transaction, such as the Payables or Receivables subledger, or the General Ledger.
Financial Document Type The type of financial transaction being considered, such as standard invoice, credit memo, or debit memo. You can define additional financial document types by using the AP Transaction Type lookup, AR Transaction Type lookup or GL Transaction Type lookup.
VAT Transaction Type The VAT transaction type.
Tax Name The name of the tax.

Note: The taxes are filtered based on the regime that is associated with the tax registration number that you chose at the header level and the VAT transaction type you chose in the details block.

Tax Status The applicable tax status of the tax.
Tax Jurisdiction The applicable tax jurisdiction of the tax.
Tax Rate The applicable tax rate code of the tax.
Tax Box The group of recoverable and non-recoverable tax boxes.
Sign The group of recoverable and non-recoverable tax box sign to be used when allocating amounts to a transaction.
Taxable Box The taxable box number.
Taxable Box Sign Sign for the taxable box.
Total Box The total taxable box. The Portuguese Annual VAT report uses this field.
Location The name of the province being reported for. The Portuguese tax authorities use this field. This column gets defaulted from E-Business Tax based on the tax reporting code that is associated to the PT_LOCATION reporting type at the rates level.
Period Type A designation for the reporting frequency and the VAT boxes that need to be created to support the frequency, such as monthly and annual.
Portuguese users must set up specific annual tax box allocations if using specific tax boxes for annual reporting. The possible values are Annual and Periodic. Even though Belgium uses the same tax box for all reports, Belgium users must replicate the same rule for periodic and annual reporting types.
Effective From The date from which the rule is effective.
Effective To The date when the rule is effective till.

The following table describes the fields in the Register and Documents regions on the VAT Registers tab. This tab is enabled for Italy only.

Name Description
Register Name Name of the register.
Register Type The type of VAT, such as Receivables Sales VAT Register, Receivables Defferred VAT Register, Sales Register (Self Invoice, EU VAT), and Purchase VAT.
Effective Date From The date from which the VAT register is effective.
Effective Date To The date when the VAT register is effective till.
Document Sequence Name The document sequence name for transactions that are reported in the defined VAT register.

EMEA VAT Reporting Rules Listing

Use the EMEA VAT Reporting Rules Listing to print your VAT reporting rules. The EMEA VAT Reporting Rules Listing displays the existing Payables, Receivables, and General Ledger VAT reporting rules that you defined. You should run this report after you set up Reporting Entities – Allocations to verify your rules.

Report Parameters

Financial Transaction Type

Enter the financial transaction type, such as standard invoice, debit memo, or credit, that you want to run the report for. Oracle Regional Financials displays financial transaction types based on the source that you entered in the Source field.

VAT Reporting Process

You can generate the following categories of EMEA VAT reports:

Additionally, you can run these reports for the subledgers. For example, VAT Journal reports for Oracle Payables, Oracle Receivables, and Oracle General Ledger.

The VAT reporting process involves the steps shown in the following diagram:

the picture is described in the document text

To generate VAT reports, you must complete the following steps.

Note: Not all VAT reports support the final reporting mode. Hence, you need not run the EMEA VAT: Selection process, allocation process or final reporting process for the following reports:

  1. Select the tax transactions. See: Running the EMEA VAT Selection Process

  2. Allocate tax and taxable box number to tax transactions, if this is applicable to your country or tax reporting requirements. See: Running the EMEA VAT Allocation Process

  3. Generate preliminary reports using the Submit Request window. See the individual report descriptions in this chapter. VAT reports, which are run for an open tax period (final reporting process not run for this particular period), are considered preliminary reports and are printed with a Report Type: Preliminary. You can run preliminary reports more than once. The preliminary tax reports enable you to run a trial version of the reports to verify and correct data before reporting to the tax authorities.

  4. Process final reports. See: Running the Final Report Process

  5. Generate the final reports using the Submit Request window. See the individual report descriptions in this chapter.

  6. Reprint final reports using the Submit Request window. You can run reprints more than once.

Running the EMEA VAT Selection Process

Run the EMEA VAT: Selection Process in the Submit Request window to select tax transactions within a tax period. The selection process creates a repository of all the transactions eligible for reporting from Oracle E-Business Tax, Oracle Payables, Oracle Receivables, and Oracle General Ledger. You can run this process multiple times provided you have not completed final reporting. Each time you run the selection process, the application replaces data pertaining to the previous run with latest data to accommodate any changes to tax transactions.

Note: The Selection process considers corrections or backdated transactions only when the previous period is finally reported. Otherwise it reports only the current period data.

When you run the EMEA VAT: Selection Process for ECE countries, it automatically launches the following:

The following table describes selected process parameters:

Name Description
Reporting Level The reporting level for which you want to select transactions; it can be ledger, legal entity, or balancing segment.

Note: If you want to report by the legal entity level, then you must complete the setup for tax registrations in the context of regime for the legal establishments in your company in the party tax profile.

Ledger Name of the ledger. If you have selected ledger or balancing segment value as the reporting level, then you must enter the ledger name.
Balancing Segment Enter the balancing segment value. If you have selected balancing segment value as the reporting level, then you must enter the segment value.
Tax Registration Number Select the applicable tax registration number. When the reporting level is Legal Entity, the transactions are filtered based on the tax registration number, regime and legal entity. When the reporting level is Ledger or Balancing Segment Value, you have to choose the tax registration number to determine the tax calendar for your reporting entity and other EMEA VAT setup attributes.
Accounting Status The accounting status such as accounted, unaccounted, or both.
  • Accounted – only accounted transactions are selected.

  • Unaccounted – only unaccounted transactions are selected. No accounting information is populated. Transactions must be validated in Oracle Payables or complete in Oracle Receivables, if you want to select them in the EMEA VAT Selection process.

  • Both – accounted and unaccounted transactions are selected. Accounting information is populated for accounted transactions only.


If you want to select tax on manual journal entries, then you must post the journal entries to the general ledger. If you have selected budget segment value as reporting level, then you must select the accounting status.
Entity Identifier This parameter provides a system derived entity identifier. The identifier is a combination of parameter values that you selected, such as transaction registration number, ledger, and balancing segment value.
The application uses the entity identifier as a required parameter named Reporting Identifier when you run any of the EMEA VAT reports in preliminary, final, or reprint mode.

Running the EMEA VAT Allocation Process

You can optionally report transactions based on the tax box setup by running the EMEA VAT: Allocation Process in the Submit Request window. This process allocates tax and taxable box number to records selected by the selection process, by period type. The allocation process matches the transactions with the rules to find out the allocated box. The hierarchy of checking VAT reporting rules within a period type is as given below:

Note: To run this process, you need to enable the allocation rule for a tax registration number in the Configuration tab of the EMEA VAT Reporting Entities window. Additionally, you must complete the Selection process before you run the EMEA VAT Allocation process..

This process produces the EMEA VAT Allocation Errors report if errors are recorded during the allocation process.

The following table describes the process parameters:

Name Description
Reporting Identifier This is the entity identifier value that the application created while submitting EMEA VAT Selection process.
Reallocation Flag When you select Yes, allocations if any already existing are flushed and all the records are processed. When you select No, then the process would only allocate those transactions which have allocation errors or unallocated transactions.

EMEA VAT Allocations Listing

Use the EMEA VAT Allocations Listing to review a range of transactions and the VAT boxes that the transactions were allocated to. This report displays payables, receivables, and general ledger transactions that are extracted within a specific tax period for a VAT reporting entity.

You must run this report before you close a tax period. Review the VAT Allocations Errors report and make any necessary corrections before you close a VAT period. Use the Standard Request Submission windows to submit the Belgian VAT Allocations Listing.

Program Parameters

Source

Enter the specific source that you wish to run the report for: AP, AR, or GL or ALL for all the three sources.

Document Sequence Name

Enter the specific document sequence name.

From Document Sequence Number

Enter the specific document sequence number that you wish to run the report from.

Note: There is no cross reference between this parameter and the Source parameter.

To Document Sequence Number

Enter the specific document sequence number that you wish to run the report to.

Note: There is no cross reference between this parameter and the Source parameter. In addition, the document sequence number that you enter in this field is not automatically validated. If you enter a nonexistent document sequence number, then the application still runs the report but the report will not contain any data.

EMEA VAT Allocation Errors Report

Use the EMEA VAT Allocation Errors report to report on errors recorded during the EMEA VAT Allocation process. The report also displays any errors from previous submissions of the Allocation process that have not yet been resolved.

Some of the errors listed in this report are:

If there is any error, then modify the transaction to correct the error and run the EMEA VAT Selection and EMEA VAT Allocation processes. If there is an error in the allocation rules, then correct the rules and run the EMEA VAT Allocation process.

Running the EMEA VAT Final Reporting Process

Run the EMEA VAT: Final Reporting Process in the Submit Request window for stamping all the tax transactions as final.

If you make changes to the transaction before running the final process, then you must run the EMEA VAT Selection and EMEA VAT Allocation processes (if your country has enabled Allocation). Additionally, you must run the preliminary reports. Repeat this process until the report data is correct and then run the EMEA VAT Final Reporting process.

You cannot change any data in the transaction after running the final process and the application closes the tax period. After completing the final process, you can run individual reports in the final and reprint mode.

EMEA VAT Extracts

The EMEA VAT reports consist of the following two components:

When you select the report to be run from the Standard Submission window, the request, which has the same name as the templates, calls the corresponding extract to which the template is attached. The extracts can be AP extract, AR extract or All extract. The extract fetches the values from the tables and publishes the same using the attached template. The prerequisite for this process is to run the EMEA VAT Selection process.

You can run the extract independently as a concurrent request without attaching any template. The program will fetch the data in the xml format. Later, you can use a customized template to publish the report in the required format. This feature enables the flexibility to create and maintain user specific templates and does not restrict you to the predefined templates.

The available extracts are:

EMEA VAT Yearly Extract

The yearly VAT declaration is a legal requirement for many European countries. Fiscal authorities for some countries require completion of the VAT yearly template. The EMEA VAT Yearly Extract Report assists users in completing the VAT yearly template according to the specifications of their fiscal authority.

EMEA VAT Yearly Extract Report

Use the EMEA VAT Yearly Extract Report in EMEA countries to build your annual VAT declaration and for VAT reconciliation.

Use the report to print the following information:

The EMEA VAT Yearly Extract Report also includes specific information for EMEA customers and provides the exemption consumption amount, per every VAT code used in the exemption feature.

The report only displays information if there are specific transactions related to a topic.

Prerequisites

The EMEA VAT yearly extract must be based on the existing VAT repository and VAT reporting processing feature for EMEA countries, including the following:

Reporting currency is based on the reporting entity. If the reporting entity is at the ledger level, and is based on the Primary Ledger, the report will be functional currency. If the reporting entity is at the reporting ledger or secondary ledger level, the ledger currency will be displayed in the report. If the reporting entity is at the legal entity level, the report will be functional currency.

The EMEA VAT Yearly Extract Report can be submitted per reporting entity for the first party legal entity or for reporting entities based on ledgers and per calendar year.

Note: Though the EMEA VAT Selection process can be run for different reporting entities (LE, Primary, Secondary, Reporting Ledgers) in the same period, the final reporting can be done only for one reporting entity. When run for the same reporting entity for which the final reporting has been done, this report will have data.

The EMEA VAT Yearly Extract Report will print for every VAT code the amounts with the following two levels of information:

The report can be submitted in either Detail mode or Summary mode.

In Detail mode, at either the VAT calendar period level or the yearly VAT calendar level, the report prints the following per every VAT code:

In Summary mode, at either the VAT calendar period level or the yearly VAT calendar level, the report prints the following per every VAT code:

EMEA VAT Yearly Extract Process

The business process for printing an EMEA VAT Yearly Extract Report consists of the following steps:

  1. Complete all basic setups for General Ledger, Payables, Receivables, and E-Business Tax.

  2. In E-Business Tax, attach the EMEA VAT Reporting Code to the Tax Rates.

  3. Create VAT transactions in Payables, Receivables, and General Ledger

  4. Run the EMEA VAT: Selection Process concurrent program

  5. If Allocation has been enabled for a country, run the EMEA VAT: Allocation Process concurrent program

  6. Run the EMEA VAT: Final Reporting Process concurrent program

  7. Run the EMEA VAT Yearly Report concurrent program

The EMEA VAT: Final Reporting Process for all periods in the tax calendar year must be run for all sources to have correct report figures. The Exemption part of this report is available only for EMEA customers, and the report exemption tables are not populated unless EMEA customers have enabled the Exemption feature for the VAT calendar year for which the report is run.

Report Parameters

The EMEA VAT Yearly Report includes the following parameters.

Reporting Identifier

The list of values of report identifiers based on the ledgers associated to the GL: Data Access Set profile option. Based on the ledgers or balancing segments to which the user has access to, the reporting identifier will be displayed. This is a required parameter with no default value.

VAT Calendar Year

The list of values shows only those calendar years for which the EMEA VAT: Final Reporting process has been run for at least one period in the particular tax calendar year. This prevents a “No Data Found” response.

For example, if a VAT calendar associated with a reporting entity is from 1990 to 2010, but the EMEA VAT: Final Reporting process has only been run for March 2005 and February 2006, then the list of values will only have two values—2005 and 2006.

Report Submission Mode

The list of values has two values, Detail or Summary. Based on this parameter, the layout and information in the report output will vary.

Exception Handling

The following exceptions apply to the report process:

Italian Exemptions Overview

In Italy, export transactions are exempted from VAT, but companies that are classified as regular exporters have more input VAT than output VAT. Italian law lets you claim exemption if you meet these legal requirements:

The exemption limit is the total VAT exemption amount that a regular exporter can claim to its suppliers. 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, you send exemption letters that indicate the exemption amounts and request that they do not charge you tax when they send you the according 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. Oracle Payables for Italy provides the Italian Supplier Exemption Limit Consumption report to help you keep track of your exemption limit consumption.

Exemption Setup and Process

To set up Oracle Payables for the exemption process:

  1. Manually calculate the initial exemption limit for the current year by summing all reported export invoices of the previous year.

  2. Use the Italian Payables Exemption Limit Manager program to enter the initial exemption limit.

  3. Use the Exemption Letters window to allocate exemption limits to your suppliers and set up for the exemption letters to send to your suppliers.

  4. Create tax reporting codes under the tax reporting type EMEA VAT Reporting Type for each of your exemption limit groups and define tax rate codes for these tax reporting types using Oracle E-Business Tax. See: Setting Up Tax Reporting Types, Oracle E-Business Tax User Guide

  5. Optionally, use the Italian Payables Exemption Limit Manager program to adjust the yearly exemption limit. You can also assign new exemption letters and limits to your suppliers.

To process and report exemptions:

  1. Enter invoices and ensure that the tax rate codes that you apply to each invoice has a tax reporting code assignment for your exemption limit groups.

  2. Use the Italian Payables Exemption Letter Process to print exemption letters to send to suppliers or the customs authority (for imported goods). These letters request that the supplier or customs authority invoices goods and services as VAT-exempt.

    Use the Italian Payables Exemption Letter Register to keep track of the letters that you send.

  3. Use the Italian Supplier Exemption Limit Consumption report to keep track of the exemption limit consumption per supplier. You can still use the Italian Payables Exemption Limit Manager to adjust the yearly exemption limit or the exemption limit assignments to your suppliers.

  4. Use the Italian Payables Exemption Limit Declaration report to print information on the exemption limit consumption for the entire year. Use this report along with the Italian Payables VAT Summary report for reporting VAT to your tax authorities.

Italian Payables Exemption Limit Manager

Use the Italian Payables Exemption Limit Manager to set up a new exemption limit year and to adjust the exemption limit. This program creates a 12 month calendar from January to December for the year that you enter. After you set up the exemption limit amount for the year, you can adjust the amount for any given month. The exemption reports use the latest adjustment that you enter for each month to recalculate all the reported amounts. You run this program by the legal entity parameters.

Use the Standard Request Submission windows to submit the Italian Payables Exemption Limit Manager program.

Program Parameters

Exemption Type

Enter Create New Year to set up a new year for the exemption limit process. You cannot run the Italian Payables Exemption Limit Manager program more than once within a year with this parameter set to Create New Year.

Enter Adjust Limit if you are adjusting an exemption limit.

Year

Enter the year that you want to set up or adjust the exemption limit for.

Month

Leave this parameter blank if you are setting up a new exemption limit year. If you are adjusting the exemption limit, enter the month that you want to adjust for.

Limit Amount/Adjustment

Enter the initial exemption limit amount if you are setting up a new exemption limit year. If you are adjusting the exemption limit, enter the amount that you want to adjust. Add a negative sign to your amount if you want to reduce the exemption limit. For example, to reduce the limit by 1,000,000, enter -1,000,000. Amounts without the negative sign are added to the exemption limit.

Related Topics

Running Reports and Programs, Oracle Applications User Guide

Assign Exemption Letters and Limits

Use the Exemption Letters window to assign first party legal entity to the exemption letter. Additionally, use the Exemption Letters window to assign both exemption letters and limits to your suppliers. Each letter may apply to all or part of a calendar year. The effective date range for a letter to a given supplier must not overlap the dates of any other exemption letter for that supplier. Once an exemption letter is created, the letter cannot be canceled, and identification numbers that are mistakenly allocated to exemption letters cannot be recovered.

For suppliers that you want to allocate exemption amounts to, specify the exemption limit amount and letter type for each exemption letter. The total exemption limit amount for a supplier is the sum of the exemption limit amounts for each letter.

Note: You can also assign exemption letters and amounts to customs.

Prerequisites

Before using the Exemption Letters window to assign exemption letters and limits to your suppliers, you should define your suppliers and supplier sites and set the income tax reporting site to Yes at site level.

To assign exemption letters and limits to your suppliers:

  1. Navigate to the Exemption Letters window.

  2. Select a supplier from the list of values.

    Once a supplier's name is entered, the supplier's number, taxpayer ID, VAT registration number, and any existing exemption letters automatically appear.

  3. In the Effective Dates From and To fields, enter effective dates to activate the letters that you want to use. The dates must be within the same calendar year.

  4. If you want to assign exemption limits to the supplier, enter a letter type in the Letter Type field:

  5. Enter the exemption limit in the Exemption Limit Amount field for each exemption letter.

  6. Enter the article of DPR 633/72 that applies to each exemption letter in the Clause field:

  7. Check the Print check box to enable the exemption letter for printing.

  8. Check the Issue check box if you want to produce a listing of all letters that are printed to be issued to the Italian Post Office.

  9. Check the Custom check box if you are addressing the letter to your supplier's customs official.

  10. Save your changes to generate a unique exemption letter ID.

Create Exemption Limit Group

Use Oracle E-Business Tax to create an exemption limit group by defining the tax reporting codes under the tax reporting type EMEA VAT Reporting Type. After creating the tax reporting codes, create the tax rate codes to associate invoice lines with exemption limit group.

Prerequisites

Use the System Administrator responsibility to enter a value for the JEIT: Exemption Limit Tax Type profile option in the System Profile Values window.

Related Topics

Setting Up Tax Reporting Types, Oracle E-Business Tax User Guide

Enter Invoices with Exemption Limit

Use the Invoices and Distributions window to enter invoices that an exemption limit applies to. At the distributions level, you must associate appropriate invoice lines with an exemption limit group. In the Tax Code field, enter a tax rate code of a tax reporting type according to the value defined in the JEIT: Exemption Limit Tax Type profile option. See: Create Exemption Limit Groups.

Regional and Country Reports

Austrian VAT Reconciliation Report by Tax Code

The Austrian VAT Reconciliation Report by Tax Code reports on taxable transactions in Oracle Payables, Oracle Receivables and Oracle General Ledger. This report helps fulfilling the legal reporting requirement for Austrian tax returns and tax audits for VAT accounting. Austrian financial authorities require to report on taxable amounts and on the related taxes by tax code. The amounts shown in General Ledger have to be the same as the reported amounts for later auditing. This report shows all taxable transactions related to the according reporting period grouped by tax code and highlights transactions that have differences.

Use the Austrian VAT Reconciliation Report by Tax Code to report VAT exceptions for VAT transactions that do not reconcile. The report is used for reconciliation purposes and you must not submit it to the tax authorities.

Prerequisites

Before running this report, you must complete the following:

Related Topics

Austrian VAT Reconciliation Report by Tax Account

Austrian VAT Reconciliation Report by Tax Account

Use the Austrian VAT Reconciliation Report by Tax Account to report VAT exceptions for VAT transactions output types by tax account that do not reconcile. This report shows all taxable transactions related to the reporting period grouped by tax account and highlights transactions that have differences. The report helps you to find out on which accounts the wrongly taxed transactions are posted. Additionally, the report helps you find which adjustments have to be mad, in case the Austrian VAT Reconciliation Report by Tax Code shows errors. The report is for reconciliation purposes and you must not submit it to the tax authorities.

Use the Tax Reconciliation by Taxable Account report to:

For prerequisites, see Austrian VAT Reconciliation Report by Tax Code.

ECE Payables VAT Register

Use the ECE Payables VAT register to print all taxable invoices that were entered in Oracle Payables. Use this register to prepare VAT returns for submission to tax authorities in ECE countries and as an official supporting document for VAT returns. The register sorts and totals by tax period, VAT transaction type, and tax code.

There are two summary sections. The first section prints totals per tax code and VAT transaction type. The second summary prints totals per GL period and tax account.

The ECE Payables VAT Register does not support taxable invoices entered for the Polish Social Insurance Institution (ZUS).

Use the Standard Request Submission windows to submit the ECE Payables VAT register.

Prerequisites

To use this register, you must complete these prerequisites:

Report Parameters

VAT Transaction Type

Choose a value to include transactions with tax codes that have the chosen VAT transaction type. Leave the parameter blank to include all transactions as long as the tax code has a VAT transaction assigned.

Exclude VAT Transaction Type

Choose a value to exclude transactions with tax codes that are assigned to selected VAT transaction types.

Column Headings

This table shows the column headings.

In this column… Oracle Payables prints…
Seq Num Sequence number for the transaction. The journal sequence number if the Enable Reporting Sequence is not selected for Reporting Entity , or the report-level sequence number.

ECE Payables VAT Register Unpaid Invoices Annex

Use the ECE Payables VAT Register Unpaid Invoices Annex to print the taxable transactions that are not yet fully paid and cleared. The annex sorts and totals transactions by tax period and prints all unpaid invoices, even if already printed on final VAT register. Use this annex to supplement the ECE Payables VAT Register to help prepare VAT returns for tax authorities in Hungary. You can also use the annex as an official supporting document for VAT returns. The annex is run from the Standard Request Submission windows by choosing the Annex template from the Options in this window.

ECE Receivables VAT Register

Use the ECE Receivables VAT Register to print all taxable transactions that were entered in Receivables. Use this register to prepare VAT returns for submission to tax authorities in ECE countries and as an official supporting document for VAT returns. The register prints standard tax transactions and deferred tax transactions separately. The register sorts and totals by tax period, VAT transaction type, and tax code.

There are two summary sections. The first summary section prints totals per tax code and VAT transaction type. The second summary section prints total tax amount per tax account and GL period.

Use the Standard Request Submission windows to submit the ECE Receivables VAT register.

Prerequisites

To use this register, you must complete these prerequisites:

ECE General Ledger VAT Register

Use the ECE General Ledger VAT register to print all taxable journals that were manually entered in Oracle General Ledger and to prepare VAT returns for submission to tax authorities in ECE countries. Use this register as an official supporting document for VAT returns. The register sorts and totals by tax type, VAT reporting period, VAT transaction type, and tax code.

There are two summary sections each for input and output tax. The first summary section prints totals by tax code and VAT transaction type. The second summary section prints totals by tax account within each GL period.

Use the Standard Request Submission windows to submit the ECE General Ledger VAT register.

Prerequisites

To use this register, you must complete these prerequisites:

Invalid Tax Date Listing

The ECE General Ledger VAT register prints an additional section for any journals with tax codes that are assigned to a VAT transaction type but have invalid or missing dates in the Document Date field. This section is printed when you run the ECE General Ledger VAT register in preliminary or final mode. The listing sorts records by GL date. For each GL date, records are sorted by journal line and line number.

Belgian VAT Monthly VAT Preparation Report

Use the Belgian VAT Monthly VAT Preparation report to produce a monthly draft of the VAT return report. This report shows a box summary of declared tax and taxable amounts that you must report. Use this report to complete the official VAT report that you submit to Belgian authorities. The report is ordered by VAT Report Box, Source, Document Name (with a page break on Period Name), and VAT Report Box. The report displays the following summaries

The Monthly VAT Preparation report shows the transactions that have a GL date before the start of the reporting period (but are being declared in this reporting period) as corrections. Use the Standard Request Submission windows to submit the Belgian VAT Monthly VAT Preparation report.

Prerequisites

Complete these prerequisites before you can run this report:

Report Parameters

Tax Calendar Period

Enter a specific period name for the monthly VAT calendar that you want to run for the report.

Belgian VAT Annual Declaration Process Report (AR)

The Belgian VAT Annual Declaration Process report selects the following from the Belgian Receivables customers for all the posted transaction lines:

Customer transactions are only included if the total amount exclusive of tax exceeds or equals a predefined value (currently this value is set at 250,00 euros). Customers are considered Belgian when the first two characters of the VAT number on the bill to site level refer to Belgium; for example, BExxxxxxxxx. For example, a customer with VAT number BE123456797 on the bill to site level is considered a Belgian EU customer (BE stands for Belgium). Transactions with this customer are reported in the VAT Annual Declaration process.

The VAT Annual Declaration process is composed of three steps, which you must execute in the following order:

The information in the output report from the Belgian VAT Annual Declaration Process report helps you to complete the Begeleidingsnota/Note d’accompagnement, which accompanies your VAT Annual Return.

Use the Standard Request Submission windows to submit the Belgian VAT Annual Declaration Process report.

Report Parameters

Min Transaction Value

Enter the minimum value that the total amount of customer transactions, exclusive of tax, must reach before transactions are included in the declaration. The minimum transaction value defaults to 250,00 euros.

Note: You should run the Belgian VAT Annual Declaration after you close the last period of the calendar year.

Row Headings

This table shows the row headings.

In this heading... Oracle Receivables prints...
Amount The total amount (exclusive of tax) of all summarized customer records in the declaration.
Tax The tax amount of all summarized customer records in the declaration.

Belgian VAT Annual Return Report

The Belgian VAT Annual Return process uses the data generated through the Belgian VAT Annual Declaration process to produce the VAT Annual Return. The generated Return file is in ASCII format and suitable for declaration on disk. The declaration must be accompanied with a Begeleidingsnota/Note d’accompagnement.

Use the Standard Request Submission windows to submit the Belgian VAT Annual Return.

Belgian VAT Annual Audit Report

The Belgian VAT Annual Audit report is a detailed overview of all transactions related to Belgian customers for a tax year, reported according to the parameters that you enter. This report lets you limit the data you see by entering the parameters Customer Name From/To. The Audit report can be different from the VAT Annual Return depending on the values that you enter for these parameters.

Use the Standard Request Submission windows to submit the Belgian VAT Annual Audit report.

Report Parameters

Min Declared Amount

Enter the minimum declared amount for the declaration.

Report Format

Enter whether you wish to run the report in detailed or in summary mode. The default for this field is Detailed.

Belgian VAT Purchases Journal

Belgian VAT laws require that Belgian companies maintain the Belgian VAT Purchases Journal. This report lists all purchase documents in sequential order and is mainly used by VAT authorities during a VAT audit.

This report shows for each transaction (Invoice, Credit Memo, Debit Memo, Expense Report, Interest, Mixed, and Prepayment) the following:

The transactions shown are grouped by period name. Within the period name, the transactions are grouped by document sequence number.

The report is ordered by period (start date of the period), document name, and document sequence number.

The report has three summaries:

  1. A total of the total invoice amount, taxable amount, tax amount (total, recoverable, and non-recoverable), taxable amount per VAT box, and tax amount per VAT box is displayed at the end of a Period and Document Name.

  2. A total of all invoice amounts, taxable amounts, tax amounts (total, recoverable, and non-recoverable), taxable amounts per VAT box, and tax amounts per VAT box is displayed at the end of a period.

  3. A grand total of the total invoice amount, taxable amount, tax amount (total, recoverable, and non-recoverable), taxable amount per VAT box, and tax amount per VAT box is displayed on the last page of the report. This grand total is displayed only if you selected two or more periods.

VAT box information for a transaction is not displayed if the transaction is not allocated by the EMEA VAT Allocation process.

Use the Standard Request Submission windows to submit the Belgian VAT Purchases Journal. You can run this report in either detail or summary mode.

Report Parameters

This table provides an example of entering the Document Sequence Name parameter:

Document Sequence Name From Document Sequence Name To Result
No value No value All transactions with any document sequence name or no document sequence names.
No value 02-AP-INV-01 This combination is not possible due to parameter validation.
02-AP-INV-01 No value All transactions with a document sequence name of 02-AP-INV-01 or more; for example, 02-AP-INV-01 and 02-AP-INV-02.

Note: In this case, the application does not select transactions that do not have a document sequence number.

Belgian VAT Sales Journal

Belgian VAT laws require that Belgian companies maintain the Belgian VAT Sales Journal. This report lists all sales documents in sequential order and is mainly used by VAT authorities during a VAT audit.

This report shows the following for each transaction (Sales Invoice, Credit Memo, Debit Memo, Chargeback, Deposit, and Guarantee):

The transactions shown are grouped by period name. Within a period name, transactions are grouped by document sequence name.

The report is ordered by period (start date of the period), document name, document number, and document line number.

There are three summaries for the report:

  1. A total invoice amount, taxable amount, tax amount, taxable amount per VAT box, and tax amount per VAT box is displayed at the end of a period and name.

  2. A total invoice amount, taxable amount, tax amount, taxable amount per VAT box, and tax amount per VAT box is displayed at the end of a period.

  3. A grand total of invoice amount, taxable amount, tax amount, taxable amount per VAT box, and tax amount per VAT box is displayed on the last page of the report. This grand total is only displayed if you selected two or more periods.

VAT box information for a transaction is not displayed if the transaction is not allocated by the EMEA VAT Allocation process.

Use the Standard Request Submission windows to submit the Belgian VAT Sales Journal. You can run this report in either detail or summary mode.

Report Parameters

See: Belgian VAT Purchases Journal Report

Croatian Vendor Invoice Tax Report

Use the Croatian Vendor Invoice Tax Report to report all vendors invoices on a monthly basis. This report shows the total VAT amount, total deductible, and non deductible tax amounts. The report has the following layouts:

The report has the following summaries:

Prerequisites

Before running the Croatian Vendor Invoice Tax Report, you must complete the following tasks:

Croatian Customer Invoice Tax Report

Use the Croatia Customer Invoice Tax report to prepare a listing of all the customers' invoices, credit and debit memos, and journal entries from the general ledger at the end of each accounting period. This report shows the total VAT amount, total deductible, and non deductible tax amounts. The report has the following layouts:

The report has the following summaries:

Prerequisites

Before you generate this report, you must complete the following tasks:

French Deductible VAT Declaration Report

Use the French Deductible VAT Declaration report to list your VAT declaration. Run this report at the end of each month to get the deductible VAT amount from each Payables invoice as well as the corresponding total VAT amounts for the month.

You do not have to post your invoices to see invoice information in the report. French VAT laws do not use accounting dates to define the month that VAT amounts become deductible. Instead, Oracle Payables separates deductible VAT on purchases of goods and services, with the use of the Option pour les debits rule (when applicable), to determine when VAT is deductible. The Option pour les debits rule states that VAT amounts become deductible as soon as you receive the invoice.

Deduction tax rules designate when VAT amounts are deductible, and are represented in Oracle Payables with these codes:

The French Deductible VAT Declaration report sorts and totals by:

Use the Standard Request Submission windows to submit the French Deductible VAT Declaration report.

Prerequisites

Before you submit the French Deductible VAT Declaration report, you must link all payables documents to a DEB/M or CRE/M tax deduction rule using the Document Sub Type column on the Invoices window.

Column Headings

In this column... Oracle Payables prints...
Invoice Status Invoice status can be cancel, void, apply, and prepay. d
Recovery Percentage The actual recoverable tax percentage applied to the Recoverable Tax Amount.

German Payables VAT Reconciliation Detail Report

Use the German Payables VAT Reconciliation Detail report to obtain information about VAT that you can recover on inputs.

The German Payables VAT Reconciliation Detail report helps you produce monthly, quarterly, and annual German VAT declarations. The report provides a detail listing of all transactions posted to each VAT account in General Ledger during the General Ledger period range that you specify. The transactions are grouped by VAT code and supplier and selected by General Ledger date.

The report includes details such as the transaction amount and VAT entered on the original invoice, as well as any discount taken upon payment of the invoice.

The report prorates the discount on the transaction amount and the VAT in the same proportion as the non-tax to tax lines on the invoice. The accounting distribution of the discount taken depends on the value that you selected for the Payables option Discount Distribution Method.

If the value is set to Prorate Expense, the discount is prorated across all invoice distribution lines. If the value is set to Prorate Tax, a proportion of the discount is prorated across the tax distribution lines and the remaining discount is credited to the Discount Taken accounting flexfield.

The German Payables VAT Reconciliation Detail report calculates the expected VAT based on the VAT rate and the original invoice cost, and displays the difference between this calculated value and the actual VAT entered on the invoice. The report prints a supplier-level total for transactions that relate to the specified VAT code, as well as a total for all VAT codes that you select.

For each VAT code, the report shows the balance of the VAT account in General Ledger, and identifies any difference between the amount posted to General Ledger and the VAT in the AP transactions. The difference is split into a calculation difference and other differences. The other category would be used, for example, where a manual journal entry was made to the General Ledger VAT account, or where a non-tax line on an invoice was posted to the VAT account.

The report is produced only in the ledger currency for your ledger. Foreign currency invoices use the exchange rate applied to the invoice when the invoice was entered into Oracle Payables.

The German Payables VAT Reconciliation Detail report includes a separate Exception Listing. AP invoice distribution lines that affect a VAT account in General Ledger print on the listing when either of these is true:

Warning: If you run the report after you perform a General Ledger revaluation for the selected accounting flexfields, the reported General Ledger Balance might be changed by the revaluation. Before you make a correcting journal for any differences, the revaluation content of the General Ledger Balance should be established and not included in the correcting journal. General Ledger revaluation journals are created as reversing journals in the following period.

You can run this report by the legal entity, ledger, or balancing segment value.

Prerequisites

Before you run the German Payables VAT Reconciliation Detail report, you must:

If the resulting journals are not posted in General Ledger, the General Ledger Balance for the VAT Account will not correspond with the sum of VAT on the transactions for that VAT code and will appear in the Other Difference to VAT GL Balance column on the report.

Accounting Flexfield From

Enter the lowest accounting flexfield combination for the range that you want to report on. The accounting flexfield range should apply to the VAT codes selected.

Accounting Flexfield To

Enter the upper accounting flexfield combination for the range that you want to report on.

Note: If you leave the accounting flexfield range fields blank, then the fields default to All. If you leave both the VAT code range fields and the accounting flexfield range fields blank, then the report selects all VAT codes as well as the accounting flexfields assigned to the codes.

Column Headings

In this column... Oracle Payables prints...
Discount Taken Amount - Transaction The discount prorated in the same proportion as the tax: non-tax lines on the invoice.
The discount on the non-tax lines is calculated as: discount taken * (total value of non-tax lines / total value of invoice).
Discount Taken Amount - VAT The discount prorated in the same proportion as the tax: non-tax lines on the invoice.
The discount on the VAT lines is calculated as: discount taken * (total value of tax lines / total value of invoice).
VAT Calculation Difference The difference between the expected tax amount and the actual tax amount entered on the original invoice (before discounts are taken).
The expected tax amount is calculated as: total value of non-tax lines * (tax rate / 100).

Exception Listing

The German Payables VAT Reconciliation Detail report includes a separate exception listing. Invoice distribution lines print on the listing if:

German VAT for On-Account Receipts Report

Use the German VAT for On-Account Receipts report to print details of all on-account receipt transactions that are assigned a tax code for the period range that you select. The report also shows the customer name and bill-to site with details of applied and unapplied on-account receipts.

You make manual adjustments based on the information that the report provides. Post VAT amounts on the on-account receipts to your VAT accounts and reverse any VAT that was posted on invoices if you received an invoice for the transaction after you recorded VAT for the prepayment.

Prerequisites

Before running the German VAT for On-Account Receipts report, you must assign tax codes to your on-account receipts.

Column Headings

In this column... Oracle Receivables prints...
Transaction The type of transaction for all on-account receipts in the period range that you selected. The valid types are:
  • Receipt - for entry of an on-account receipt.

  • Reversed - for a reversal of an on-account receipt.

  • Applied - for the application of an on-account receipt to invoices, credit memos, or any other invoice type.

  • Unapplied - for a previously applied on-account receipt that is either reapplied or reversed to become on-account.

Clearing Debit The amount of clearing VAT. Positive numbers are debits; negative numbers (in brackets) are credits.
Liability Credit The amount of liability VAT. Positive numbers are credits; negative numbers (in brackets) are debits.
New Yes for new transactions in the period selected.

Israel VAT Reports Process

Once all necessary setups are done, complete the following steps to report Israel VAT tax for each tax period.

Israeli VAT AP Detailed Report

Use the Israeli VAT AP Detailed report to view a list of the VAT input transactions for each month. This report displays VAT details for standard, import, and petty cash transaction categories. You can run the report in functional and reporting currency.

Use the Standard Request Submission windows to submit the Israeli VAT AP Detailed report.

For prerequisites, see Israeli VAT Summary Declaration to Tax Authority.

Column Headings

In this column... Oracle Payables prints...
Import Document Number The invoice import number for import invoices. For standard invoices, the application leaves this column blank.

Israeli VAT AR Detailed Report

Use the Israel VAT AR Detailed report to view a list of the VAT output transactions for each month. You can run the report in functional and reporting currency.

Use the Standard Request Submission windows to submit the Israeli VAT AR Detailed report.

For prerequisites, see Israeli VAT Summary Declaration to Tax Authority.

Israeli VAT Files

Use the VAT File to prepare an ASCII file (form 835) to submit the monthly VAT file to the tax authority. You can run the VAT files in functional and reporting currency.

Use the Standard Request Submission windows to submit the Israeli VAT Files - Related to 835

To copy the output to a file, do the following:

Prerequisites

Before you generate the VAT files, ensure the following:

Israeli VAT Summary Declaration to Tax Authority

The Israeli VAT Summary Declaration to Tax Authorities report provides a summary listing showing VAT collected by categories for a selected reporting period, which is usually a month or bi-month. Use this report to provide the tax authorities with the summary amounts for input and output VAT amounts.

Use the Standard Request Submission windows to submit the Israeli VAT Summary Declaration to Tax Authorities report.

Prerequisites

Before running this report, complete the following tasks:

Summarize Sales Transactions Below VAT Aggregation Limit Amount

Sales transactions are subject to aggregated reporting if the absolute value calculated from the not-exempt taxable amount on the transactions is below, or less, than the periodically published VAT Aggregation Limit Amount.

Taxable net amounts are compared to the VAT Aggregation Limit Amount before a transaction is merged and tax declared as summary line. Only sales transactions with the following classifications are summarized for declaration purposes:

Aggregate Declared Petty Cash Transactions Up to Maximum Recoverable Amount

Companies can declare the taxable transactions reconciled via Petty Cash purchases in the aggregated format instead of continuing to list them as individual transactions. Israeli companies can declare and reclaim tax on petty cash transactions only up to the certain, published limit called Maximum Recoverable Amount.

The Maximum Recoverable Amount can be represented by the following:

If the Maximum Recoverable Amount calculated on the percentage basis is below the other officially published called the Minimum Recoverable Amount, and the VAT on petty cash transactions for the declaration period is above the Minimum Recoverable Amount, then Israeli companies can declare and reclaim with the tax period for the full Minimum Recoverable Amount.

Move Not Aggregated Petty Cash Transactions to Subsequent Tax Period

Petty cash transactions which have not been included in the VAT file for the current tax period due to exceeding the recoverable limit are rolled forward to subsequent tax periods. For the current period declaration, purposed transactions are selected and totaled using the FIFO algorithm based on the Transaction Date. You should run the EMEA VAT: Final Reporting Process to finally mark and stamp transactions below the Maximum Recoverable Limit in the current tax period.

Set Up Israeli Tax Calendar for VAT Limits

You must record all Israeli VAT limits before running any Israeli VAT reports. To enter Israeli VAT limits, navigate to Israel VAT Limits window.

Israeli AP/AR Localizations > Israel VAT Limits Setup > Israel VAT Limits

Enter your Israel VAT limit data. The following table describes the fields in the Israel VAT Limits window.

Israel VAT Limits Fields
Field Description
Tax Calendar Enter the Tax Calendar name attached to the VAT reporting entity.
Tax Period Choose the tax period.
VAT Aggregation Amount Enter the limit for individual sales transactions taxable amount, or net amount, below which the transaction can be aggregated and declared in summary mode.
Minimum Recoverable Amount Enter the minimum recoverable amount for the petty cash purchases.
Maximum Recoverable Percentage Enter the maximum recoverable percentage for the petty cash purchases, or enter the maximum recoverable amount. Both values cannot be entered for the same tax period.
Maximum Recoverable Amount Enter the maximum recoverable amount for the petty cash purchases, or enter the maximum recoverable percentage. Both values cannot be entered for the same tax period.

Important: VAT Limits cannot be modified for a tax period if the EMEA VAT: Final Reporting Process has been run for that period for any reporting entity using the tax calendar.

If any modifications are made to the VAT Limits, then the VAT reports should be run again in the following order to consider the new limits:

  1. Israeli VAT AR Detailed Report/Israeli VAT AP Detailed Report

  2. Israeli VAT Summary Declaration to Tax Authorities

  3. Israeli VAT File Generation Related to 835

In this column... Oracle Receivables prints...
VAT Taxable Transactions The VAT liable transactions amount for customers.
VAT on Output Transaction The total VAT exempt transactions amount for customers.
VAT on Fixed Assets Input The tax amount on fixed asset of the invoice (for standard VAT-A tax type).
VAT on Other Input Transactions The tax amount on the transaction that is not a fixed asset (for import VAT-RS tax type).
Total VAT to be Paid (Refund) The total net VAT amount to be paid (the difference between total VAT on output and total VAT on input).

Set Up Israel VAT Tax Reporting Codes

Israeli VAT reporting uses the following tax classifications for tax reporting:

Tax Reporting Codes

Tax Reporting Codes are grouping transaction lines for all Israeli reports. Set up of Israeli Tax Reporting Codes must be completed before Israel VAT tax can be processed.

VAT File Line Types

VAT File Line Types, or declaration classifications, are grouping transaction lines for Israeli VAT files and are derived from the Tax Reporting Codes. No additional setup is required for VAT File Line Types.

Entering Israeli VAT Tax Reporting Codes

You can enter the following Israeli VAT Tax Reporting Codes as tax reporting codes for the tax reporting type EMEA VAT Reporting Type. The following tables describe both Payables Input VAT tax and Receivables Output VAT tax.

Payables Input VAT Tax
Tax Reporting Code Description VAT File Line Type Description
VAT-A Input VAT on equipment and fixed assets transactions T Classification for Input VAT on Standard transactions.
VAT-S Input VAT on standard types of transactions. T Classification for Input VAT on Standard transactions
VAT- C Input VAT for Self-Invoicing transactions. C Classification for Input VAT on self-invoiced transactions.
VAT-KA Input VAT on equipment and fixed assets paid by petty cash. K Classification for Input VAT on transactions paid via Petty Cash.
VAT-KS Input VAT on other transactions paid for by petty cash. K Classification for Input VAT on transactions paid via Petty Cash.
VAT-RA Input VAT on equipment and fixed assets from an Import Invoice. R Classification for Input VAT on import transactions, or Rshimon imports.
VAT-RS Input VAT on other types of transactions from an Import Invoice. R Classification for Input VAT on import transactions, or Rshimon imports.
VAT-P Input VAT for purchases from a Palestinian Supplier. P Classification for Input VAT on transactions with delivery by a Palestinian supplier.
VAT-H Input VAT for all other transactions and product fiscal classifications. H Classification for Input VAT on transactions with specific fiscal classifications, such as Taxable Rshimon Amendments, bank charges, VAT on fund invoices, etc.
Receivables Output VAT Tax
Tax Reporting Code Description VAT File Line Type Description
VAT-S Output VAT on standard types of transactions S Classification for Output VAT on Standard sales transactions.
VAT- L Output VAT for unknown customers. L Classification for Output VAT on standard sales transactions with missing Customers Tax Payer ID.
VAT-0 Output VAT for zero VAT. S
L
S or L depending on the Customers Tax Payer ID or Customers Registration Status.
VAT-EXEMPT Output VAT Exempt S
L
S or L depending on the Customers Tax Payer ID or Customers Registration Status.
VAT-M Output VAT for self-invoices M Output VAT on self-invoiced sales transactions.
VAT-Y Output VAT for Export Invoices. Y Output VAT on export transactions.
VAT-I Output VAT for Palestinian customers. I Output VAT on transactions with supplies to Palestinian customers.

Italian Purchase VAT Register

Use the Italian Purchase VAT Register report to print all invoices that have General Ledger dates within the period range that is being reported. These invoices are assigned to the document sequence name for the VAT register name that you selected.

Both preliminary and final reports show invoices that were accounted, unaccounted, or both based on the accounting status option chosen while running the EMEA VAT: Selection process. Final process, however, marks the invoices so that these invoices are not included in subsequent runs of the report. Only invoice lines with an assigned tax code are included in the Italian Purchase VAT Register report. The report displays the recoverable and non-recoverable elements of both the tax and taxable amounts.

The Italian Purchase VAT Register report is run in the ledger currency of your ledger. The report is ordered by sequence name, accounting date, and document sequence number. A summary of invoice totals by tax rate and a grand total are printed at the end of the report.

The Italian Purchase VAT Register report is printed on preprinted stationery. You can generate these printed report headings by running the Italian Statutory Headings report. For more information, see Italian Statutory Headings Report.

Use the Standard Request Submission windows to submit the Italian Purchase VAT Register report.

Prerequisites

Before you can run the Italian Purchase VAT Register report, you must:

Related Topics

Italian Payables Purchase VAT Register Annex

Italian Payables Purchase VAT Register Annex

The Italian Payables Purchase VAT Register Annex lists the full names of the suppliers that are printed on the current execution of the Italian Purchase VAT Register. The Italian Purchase VAT Register may contain some truncated supplier names, so the Italian Payables Purchase VAT Register Annex lists the full supplier names for government reporting.

To run the Italian Payables Purchase VAT Register Annex, you must:

Italian Payables Sales VAT Register (Self Invoices, EEC, VAT)

Use the Italian Payables Sales VAT Register report to print a sales VAT register for all European Union invoices or all self invoices that have General Ledger dates within the period range being reported and are:

Both preliminary and final reports show invoices that were accounted, unaccounted, or both based on the accounting status option chosen while running the EMEA VAT Selection process. Final process, however, marks the invoices so that these invoices are not included in subsequent runs of the report. For the invoices, the Italian Payables Sales VAT Register report displays the recoverable and non-recoverable elements of both the tax and taxable amounts.

Only invoice lines with an assigned tax code are included in the Italian Payables Sales VAT Register report.

The Italian Payables Sales VAT Register report is run in the ledger currency for your ledger. The report is ordered by document sequence number within sequence name. A summary of invoice totals by tax rate and a grand total are printed at the end of the Italian Payables Sales VAT Register report.

The Italian Payables Sales VAT Register report is printed on preprinted stationery. You can generate these printed report headings by running the Italian Statutory Headings report. For more information, see Italian Statutory Headings Report.

Use the Standard Request Submission windows to submit the Italian Payables Sales VAT Register report.

Prerequisites

Before you can run the Italian Payables Sales VAT Register report, you must:

Related Topics

Italian Payables Sales VAT Register Annex (Self Invoices, EEC, VAT)

Italian Payables Sales VAT Register Annex (Self Invoices, EEC, VAT)

The Italian Payables Sales VAT Register Annex (Self Invoices, EEC, VAT) lists the full names of the suppliers that are printed on the current execution of the Italian Payables Sales VAT Register. The Italian Payables Sales VAT Register may contain some truncated supplier names, so the Italian Payables Sales VAT Register Annex (Self Invoices, EEC, VAT) lists the full supplier names for government reporting.

To run the Italian Payables Sales VAT Register Annex (Self Invoice, EEC, VAT), you must:

Italian Payables Summary VAT Report

Use the Italian Payables Summary VAT report to print a summary of the taxable amount and VAT amount by tax code for each VAT type and VAT register for the period that you select. You can print the Italian Payables Summary VAT report for transactions in both Oracle Payables and Oracle Receivables.

The Italian Payables Summary VAT report is only available if the final VAT registers are printed in the subledgers. The report prints a grand total of all sales and purchases VAT amounts and adjusts for any deferred VAT which is either payable or not yet payable, together with any manual adjustments and credit balances from the previous report, to give a net amount of VAT to be paid to the authorities.

Deferred VAT invoices can be either included the Italian Sales VAT Register report and maintained in the Italian Receivables Deferred VAT Register report, or reported only in the Italian Receivables Deferred VAT Register report.

If you report deferred VAT invoices in both reports, the Italian Payables Summary VAT report does not display summarized deferred VAT register information. The report takes into account the deferred VAT issued and deferred VAT payable in the sales VAT registers and adjusts accordingly in the Amount to Pay row heading calculation.

If you report deferred VAT invoices in the Italian Receivables Deferred VAT Register report only, the Italian Payables Summary VAT report displays summarized deferred VAT register information. The report takes into account the deferred VAT payable from this register and adjusts accordingly in the Amount to Pay row heading calculation.

The Italian Payables Summary VAT report also prints monthly information on exemption limit consumption, including the consumption per exemption limit group and the available limit at the beginning and end of the month.

The Italian Payables Summary VAT report is printed on preprinted stationery. You can generate these printed report headings by running the Italian Statutory Headings report. For more information, see Italian Statutory Headings Report.

Use the Standard Request Submission windows to submit the Italian Payables Summary VAT report.

Prerequisites

Before you can run the Italian Payables Summary VAT report, you must:

Report Parameters

Variation on Sales

Enter the debit amount that you want to reduce the sales VAT by for net payment purposes. This amount is printed at the end of the report. The default value for this parameter is zero.

Variation on Purchases

Enter the credit amount that you want to reduce the purchase VAT by for net payment purposes. This amount is printed at the end of the report. The default value for this parameter is zero.

Italian Payables Exemption Letter Process

Use the Italian Payables Exemption Letter process to generate and print an exemption letter for each record. Send exemption letters to instruct suppliers not to include VAT on invoices that are sent to you. The transmission of this letter is recorded in Oracle Payables, along with details of the period that the letter applies to and the type of company that the letter is sent to. Each letter is given a unique sequential number within a calendar year.

Note: The Print check box in the Exemption Letters window must be checked for the letter to print.

The Italian Payables Exemption Letter process also produces a listing of all letters that were printed in order to be issued for the Italian Post Office. The Issue check box in the Exemption Letters window must also be checked.

The Italian Payables Exemption Letter process prints the type of letter that you designate in the Letter Type field of the Exemption Letters window.

Use the Standard Request Submission windows to submit the Italian Payables Exemption Letter process.

Prerequisites

Before submitting the Italian Payables Exemption Letter process, you must:

Report Headings

In this heading... Oracle Payables prints...
<First Party Legal Entity> The first party legal entity information.
<Individual Person Section Heading> INDIVIDUAL PERSON
Last Name The last name of the individual, if the letter is from an individual.
First Name The first name of the individual.
Date of Birth The birth date of the individual.
Sex The sex of the individual.
City (or Foreign Country) of Birth The city or foreign country where the individual was born.
<Company Section Heading> SUBJECT IF DIFFERENT FROM INDIVIDUAL PERSON
Company Name The name of your company, based on your ledger ID.
<Fiscal Address Heading> FISCAL ADDRESS
Street and Number The street from your company address, based on your ledger ID.
Postal Code The postal code from your company address, based on your ledger ID.
City The city from your company address, based on your ledger ID.
<Letter Text and Clause> The undersigned, willing to avail itself with the right granted to those who perform export sales or assimilated operations, in order to purchase or import goods and services without application of VAT according to <law clause> of DPR 633/72, asks on its own responsibility to purchase or import goods and services without the application of the levy.
The clause types are:
  • art. 8 - Export sales

  • art. 8 bis - Absorbed operations

  • art. 9 - International services

<Letter Type Text> For domestic purchases of goods and services, this statement concerns:
Depending on the letter type:
  • Exempted Period - The operations performed in the year <fiscal year> from <effective date from> to <effective date to>

  • Specific Operation - A specific operation

  • Exempted Amount - The operations performed in the year <fiscal year> until the consumption of <exemption limit amount>

<Addressee Section Heading> ADDRESSEE OF THE STATEMENT
Custom of The name of the customs office related to this exemption letter.
<Different Third Party Text> Or
DIFFERENT THIRD PARTY
Company Name or, if an Individual Person, the Last and First Name The supplier name, either company name or individual's first and last name.
<Fiscal Address Heading> FISCAL ADDRESS
Street and Number The street of the supplier address.
Postal Code The postal code of the supplier address.
City The city of the supplier address.
Date The date that the exemption letter was first issued.
Signature The signature and The Management.
<Supplier Information> The supplier name and address.

Exemption Letter Listing

In this column... Oracle Payables prints...
Number A program-generated line number for each letter, starting with 1.
Individual or Company Name The name of the supplier that the exemption letter applies to.

Italian Payables Exemption Letter Register

Use the Italian Payables Exemption Letter Register to list all exemption letters issued within a given month, such as letters that have gone through the Italian Payables Exemption Letter process.

Use the Standard Request Submission windows to submit the Italian Payables Exemption Letter Register.

Prerequisites

Before submitting the register, complete the following:

Italian Supplier Exemption Limit Consumption Report

Use the Italian Supplier Exemption Limit Consumption report to monitor the monthly consumption of the exemption limit. The report provides details about suppliers and their monthly consumption of the exemption limits that you assigned to them.

The report selects all approved invoices with an invoice header General Ledger date that corresponds to the month and year that you select in the Month/Year parameter.

Use the Standard Request Submission windows to submit the Italian Supplier Exemption Limit Consumption report.

Italian Payables Exemption Limit Declaration

Use the Italian Payables Exemption Limit Declaration report to print the information that you need to report your VAT exemption limit declarations to your tax authorities. The report provides information on the monthly consumption of the exemption limit by each exemption limit group in a calendar year.

The Italian Payables Exemption Limit Declaration report includes only invoices that were submitted in the Final report mode by the Italian Purchase VAT Register report.

The information for each month is also printed on the Italian Payables Summary VAT report. For more information, see Italian Payables Summary VAT Report.

Use the Standard Request Submission windows to submit the Italian Payables Exemption Limit Declaration report.

Prerequisites

Before you submit the Italian Payables Exemption Limit Declaration report, you must run the Final Process for the Italian Purchase VAT Register report. For more information, see Italian Purchase VAT Register.

Italian Annual Customer and Supplier Listing

Use the Generate Italian Annual Customer and Supplier Listing report to print the total amount of transactions logged during the fiscal year, the total amount of credit memos issued during the same fiscal year and the credit memos applied to transactions created in the previous year. The total of transactions and credit memos are classified as follows:

You can print the Generate Italian Annual Customer and Supplier Listing report in preprinted stationery and electronic format. Submit the electronic format report to the fiscal authorities.

Note: The electronic file size cannot exceed 2 MB.

Use the Standard Request Submission windows to submit the Generate Italian Annual Customer and Supplier Listing concurrent program to generate the customer and supplier listing as warranted by the fiscal authorities.

Prerequisites

Before you run the Generate Italian Annual Customer and Supplier Listing, you define the receivables and payables VAT codes for a reporting identifier and a fiscal year using the Supplier Listing Columns and the Customer Listing Columns tabs in the Italian Annual Listing Setup window.

You perform this setup every year for the reporting legal entity. You must freeze the setup before running the Generate Italian Annual Customer and Supplier Listing concurrent program.

Note: You can unfreeze the setup and change the VAT codes until you submit the report in the final mode.

Report Parameters

Reporting Identifier

Select the applicable reporting identifier that you want to run the report for.

Year of Declaration

Select the year for which you want to run the report for.

Report Type

Select Preliminary, Final or Reprint as the report type. You can generate the Preliminary report type as you wish, until submitting the report as Final. After running the program in the Final mode, you can only reprint the final report.

VAT Registered Parties

Select Yes or No to include the customers and suppliers registered with VAT.

Report Mode

Select Detail to display the transaction lines in detail or Summary to summarize totals for each customer and supplier

Generate EFT File

Select Yes to generate an electronic file to submit to the fiscal authorities.

Number of Parties in a EFT

Enter a value to print the number of parties in an electronic file.

Note: Use this option to split the electronic file on the number of parties and generate multiple electronic files if the file size exceeds 2 MB.

Customer Listing Sort Column

Select Customer Name, Customer Taxpayer ID, or Customer VAT Registration Number to order the report by these columns.

Supplier Listing Sort Column

Select Supplier Name, Supplier Taxpayer ID, or Supplier VAT Registration Number to order the report by these columns.

Group by Duplicate Taxpayer ID/Registration Number

Select Yes to group the report data by the Duplicate Taxpayer ID and Registration Number. The default value is No.

Italian Receivables Sales VAT Register

Use the Italian Receivables Sales VAT Register report to print all invoices that:

Preliminary reports show unaccounted, accounted, or both. The final process marks the invoices so that these invoices are not included in subsequent runs of the report. Only invoice lines with an assigned tax code are included in Italian Receivables Sales VAT Register report. The report is run in the ledger currency of your ledger.

The report is ordered by document sequence number within sequence name. A summary of invoice totals by tax rate and a grand total are printed at the end of the report.

The Italian Receivables Sales VAT Register report is printed on preprinted stationery. You can generate these printed report headings by running the Italian Statutory Headings report. For more information, see Italian Statutory Headings Report.

Use the Standard Request Submission windows to submit the Italian Receivables Sales VAT Register report.

Prerequisites

Before you can run the Italian Receivables Sales VAT Register report, you must:

Italian Receivables Sales VAT Register Annex

The Italian Receivables Sales VAT Register Annex lists the full names of the customers that are printed on the current execution of the Italian Receivables Sales VAT Register. The Italian Receivables Sales VAT Register may contain some truncated customer names, so the Italian Receivables Sales VAT Register Annex lists the full customer names for government reporting.

To run the Italian Receivables Sales VAT Register Annex, you must:

Italian Receivables Deferred VAT Register

Use the Italian Receivables Deferred VAT Register report to print all invoices that reference a deferred type tax code, are accounted and:

Preliminary reports show accounted, unaccounted, or both invoices. The final process marks the invoices so that these invoices are not included in subsequent runs of the report. Only invoice lines with an assigned tax code are included in the Italian Receivables Deferred VAT Register report. The report is run in the ledger currency of your ledger.

The Italian Receivables Deferred VAT Register report is ordered by document sequence number within sequence name. The report lists all invoices with deferred VAT and all cash receipt applications and adjustments that caused the VAT to be reclassified from deferred to due. At the end of the report are two summary sections: one for VAT issued and deferred, and one for VAT that is due. Deferred VAT invoices, but not receipts and adjustments, are required to be reported on the Sales VAT Register as well, at the time of invoice issue. The summaries display totals by tax rate and print a grand total.

Note: In Italy, deferred VAT is applicable only when trading with the public sector. Only public or private organizations trading with the public sector are allowed to defer VAT on invoices issued against public sector customers.

The Italian Receivables Deferred VAT Register report is printed on preprinted stationery. You can generate these printed report headings by running the Italian Statutory Headings report. For more information, see Italian Statutory Headings Report.

Use the Standard Request Submission windows to submit the Italian Receivables Deferred VAT Register report.

Prerequisites

Before you can run the Italian Receivables Deferred VAT Register report, you must:

Related Topics

Italian Receivables Deferred VAT Register Annex

Italian Receivables Deferred VAT Register Annex

The Italian Receivables Deferred VAT Register Annex lists the full names of the customers that are printed on the current execution of the Italian Receivables Deferred VAT Register. The Italian Receivables Deferred VAT Register may contain some truncated customer names, so the Italian Receivables Deferred VAT Register Annex lists the full customer names for government reporting.

To run the Italian Receivables Deferred VAT Register Annex, you must:

Norwegian VAT Reconciliation Report

Use the Norwegian VAT Reconciliation report to print information that you need to complete the bimonthly report that you submit to your tax authorities two months after the reporting period. If the bimonthly reporting period is January to February, for example, the tax declaration and payment are due two months later in April. If you did not report an item at the appropriate time, report the item for the current period as a correction. You cannot report an item more than once.

Note: After you report on a bimonthly reporting period, close the periods to avoid entering more taxable transactions.

The Norwegian VAT Reconciliation report includes any invoice distribution line or General Ledger journal entry line that has a tax code or impacts a revenue account. The report combines values from Oracle Payables, Receivables, and General Ledger. All taxable transactions are included except transactions with these tax types:

The report also excludes transactions that you import into General Ledger from sources other than Oracle Payables and Receivables, except in the General Ledger balance amounts.

The Norwegian VAT Reconciliation report prints all VAT and investment tax amounts, the taxable and non-taxable revenue amounts, and taxable amounts for investment taxes. The report reconciles the tax amounts of the tax control accounts with the taxable amounts, using the tax rate to calculate whether the correct amounts have been accounted to the control accounts or not.

The Norwegian VAT Reconciliation report lets you report VAT according to the official bimonthly reporting periods for VAT. The report will include all transactions with GL dates that are within the GL date range that you enter, including transactions that are entered in adjustment periods.

You can run the Norwegian VAT Reconciliation report in Summary or Detail mode. The summary report provides the information that you must report to your tax authorities and indicates any variances between calculated and accounted tax amounts. Use the detail report, which provides details on transactions, to identify and correct any transactions with such variances. You can also identify single transactions for auditing purposes.

The three sections of the Norwegian VAT Reconciliation report are Input Tax Calculation Control, Output Tax Calculation Control, and GL Reconciliation and Revenue Tax Report. Under the first two sections are subsections indicating the source of the transaction: Payables, Receivables, or General Ledger. For each source, VAT and investment tax reconciliation information is printed, and transaction details are printed if you choose the Detail mode.

The GL Reconciliation and Revenue Tax Report section provides the values that you enter in the report to your tax authorities. This section is also divided into two subsections, Revenue Reconciliation and Reporting and Tax Control Account Reconciliation.

The Revenue Reconciliation and Reporting subsection displays information on non-taxable sales, taxable sales, VAT exempt sales, and other revenue. Other revenue results from transactions entered in revenue accounts that are not associated with a tax code in the Tax Options window. Identify and correct other revenue amounts or manually add them to non-taxable or taxable sales amounts.

The Tax Control Account Reconciliation subsection shows information on output VAT, investment tax, investment tax basis, and input VAT.

The Norwegian VAT Reconciliation report runs in the ledger currency of your ledger and converts foreign exchange amounts into the ledger currency. Run the report for your ledger.

Use the Standard Request Submission windows to submit the Norwegian VAT Reconciliation report.

Prerequisites

Before you submit the Norwegian VAT Reconciliation report, you must:

Report Parameters

Sort by Operating Unit

Enter Yes to sort the report first by operating unit and then by the default sorting. Enter No for the default sorting only, which is:

Column Headings

In this column... General Ledger prints...
VAT - Entered Rate (%) The tax rate associated with the VAT code, printed as a percentage.
VAT - Calculated Rate (%) The result of this calculation as a percentage: Calculated Rate = VAT Amount / Taxable Amount.
<Variance Status>
  • * - If the entered VAT tax rate does not equal the calculated VAT tax rate.

  • # - If the investment tax rate does not equal the calculated investment tax rate, which is: Investment Tax Amount / Taxable Amount.

VAT Reconciliation Subsection

In this column... General Ledger prints...
Tax Code The VAT code
Tax Rate (%) The VAT transaction type
Total Taxable The sum of the taxable amounts for each unique tax code and tax rate combination
Total VAT The sum of VAT amounts for each unique tax code and tax rate combination
Calculated Rate (%) The result of this calculation as a percentage: Calculated Rate = Total Tax / Total Taxable

Investment Tax Reconciliation Subsection

In this column... General Ledger prints...
Tax Code The investment tax code
Tax Rate (%) The tax rate associated to the tax code
Total Taxable The sum of the taxable amounts for each unique tax code and tax rate combination
Total Tax The sum of investment tax amounts for each unique tax code and tax rate combination
Calculated Rate (%) The result of this calculation as a percentage: Calculated Rate = Total Tax / Total Taxable

Revenue Reconciliation and Reporting Subsection

In this column... General Ledger prints...
Accounts The balancing segment and natural account combination for only revenue accounts.
Source - Receivables The amount imported from Oracle Receivables into General Ledger.
Source - General Ledger The amount entered directly into General Ledger revenue accounts.
Total The sum of Receivables amounts and General Ledger amounts.
GL Period Activity The General Ledger activity for the reporting period. If the date range that you enter in the GL Date From and To parameters does not match the General Ledger period, this column remains blank.
Difference The GL Period Activity amount minus the Total amount.
GL YTD Balance The year-to-date balance for the account combination.

Tax Control Account Reconciliation Subsection

In this column... General Ledger prints...
Accounts The balancing segment and natural account combination for only tax control accounts that are associated to a tax code with a tax type that is not Withholding Tax, Self Invoice, or Use.
Under the Investment Tax Basis section, the tax rates are printed instead.
Source - Payables The amount imported from Oracle Payables into General Ledger.
Source - Receivables The amount imported from Oracle Receivables into General Ledger
Source - General Ledger The amount entered directly into General Ledger revenue accounts.
Total The sum of Oracle Payables, Receivables, and General Ledger amounts.
GL Period Activity The General Ledger activity for the reporting period. If the date range that you enter in the GL Date From and To parameters does not match the General Ledger period, this column remains blank.
Difference The GL Period Activity amount minus the Total amount.
GL YTD Balance The year-to-date balance for the account combination.

Portuguese Periodic VAT Report

Use the Portuguese Periodic VAT report to produce VAT information to help you complete the statutory periodic (monthly and quarterly) VAT returns.

You can produce total taxable and tax amounts rounded to the nearest integer for each of the boxes identified in the Portuguese Periodic VAT report.

Use the Standard Request Submission windows to submit the Portuguese Periodic VAT report.

Prerequisites

Before you submit the Portuguese Periodic VAT report, you must complete the following:

To specify a box identifier for a tax code:

  1. Using Oracle E-Business Tax, navigate to the Tax Rate page and associate a reporting code to the tax rate code. Tax reporting type code is PT_LOCATION, and the reporting code can be one of the following:

  2. Define Allocations in the Define Reporting Entities > Allocation Rules window (Regional Localizations). In the box fields, enter a number between 000 and 999 to identify each box for each type of tax amount. Enter 999 to indicate that the box is not reported. Define Tax Boxes and Taxable Boxes for Period Type: Annual and Periodic.

This table shows an example of a box identifier setup for a Payables tax code, st17 (Recoverable = 80%, Non Recoverable = 20%):

Field Value
Location C
Periodic: Taxable Box 999
Periodic: Recoverable Tax Box 024
Annual: Total Taxable Box 265
Annual: Recoverable Taxable 203
Annual: Non Recoverable Taxable 212
Annual: Recoverable Tax Box 008

If the total taxable amount of a Payables invoice is 100,000 euros, the Portuguese Periodic VAT report:

The Portuguese Periodic VAT report calculates the recoverable tax amounts according to the recovery rate defined for the tax rate code.

Report Parameters

Reporting Identifier

Select the applicable reporting identifier that you want to run the report for.

Tax Calendar Year

Enter the period that you want to select transactions from Oracle Receivables, Payables, and General Ledger for the report.

VAT Report Box Low/High

Enter the smallest/highest box number that you want to select the required tax codes and transactions from Oracle Payables, Oracle Receivables, and General Ledger for the report. If you leave Box From and Box To blank, all boxes are selected.

Report Headings

In this heading… General Ledger prints…
NIF The fiscal identification number
SIC Code The Standard Industry Classification code
Declarer's Name The company's name
Tax Office Code The tax office code
Tax Office Loc The tax office location

Column Headings

In this column… General Ledger prints…
Taxable Amount The box number for the taxable amount and the amount of tax for each transaction, or the total net value for the transactions that are posted to the tax code associated with the current box.
Total Taxable Amount The sum of the taxable amount values.
Deduct-To Tax The box number for the tax amount paid as defined in the Define Tax Codes window and the tax paid, which is the total tax amount for the Payables transactions that are posted with the tax code associated to the current box. The Deduct To Tax also includes transactions posted directly in General Ledger using the same tax code.
Total Deduct-To Tax The sum of the Deduct-To Tax.
Clear-To Tax The box number for the tax amount received as defined in the Tax Codes window and the total tax amount for the Receivables transactions that are posted with the tax code associated to the current box. The Clear To Tax also includes transactions posted directly in General Ledger using the same tax code.
Total Clear-To Tax The sum of the Clear-To Tax.

Row Headings

In this heading… General Ledger prints…
Tax to Pay The total Clear-To Tax minus the Total Deduct-To Tax, if the Total Clear-To Tax is greater than Total Deduct-To Tax. This row is blank otherwise.
Tax to Receive The Total Deduct-To Tax minus the Total Clear-To Tax if the Total Deduct-To Tax is greater than or equal to the Total Clear-To Tax. This row is blank otherwise.

Portuguese Annual VAT Report

Use the Portuguese Annual VAT report to complete the statutory Annual VAT return. You can produce total taxable amounts rounded to the nearest integer for each of the boxes identified in the Portuguese Annual VAT report.

Use the Standard Request Submission windows to submit the Portuguese Annual VAT report.

For the report prerequisites, parameters, and headings, see Portuguese Periodic VAT Report.

Portuguese Suppliers Recapitulative Report and Extract File

Use the Portuguese Suppliers Recapitulative report to provide information required by government authorities in paper or electronic format. The file lists Portuguese suppliers with whom you conducted transactions greater than a specified value (including VAT).

This report only includes transactions posted through Oracle Payables. The report does not include transactions posted directly to General Ledger.

To report in a paper format, use the Standard Request Submission windows to submit the Portuguese Suppliers Recapitulative report.

To report it in ASCII format, use the Standard Request Submission windows to submit the Portuguese Suppliers Recapitulative Report, with the template option set to Portuguese Suppliers Recapitulative Extract File.

The file is an ASCII file. The types of records are:

Prerequisites

Before you run the Portuguese Suppliers Recapitulative Extract File, you must complete these tasks:

Report Parameters

Minimum Invoiced Amount

Enter the minimum amount on an invoice that you want to report above. Only suppliers with total transaction amounts (including VAT) greater than what you enter are included in the extract file.

Reporting Year

Enter the tax year that you want to report on. The file always runs from January 1 to December 31 of the year you enter.

Detail Page Headings

In this heading… Oracle Payables prints…
Total The sum of the invoiced amounts for the current supplier. Oracle Payables truncates the amounts at the decimal places.
Page Total The sum of the net amounts of the lines. Page totals do not include brought forward values. Oracle Payables truncates the amounts at the decimal places.
Report Total The report totals, a recalculation based on all detail lines in the report.

Portuguese Customers Recapitulative Report and Extract File

Use the Portuguese Customers Recapitulative report to provide information required by government authorities in paper or electronic format. The file lists Portuguese suppliers with whom you conducted transactions greater than a specified value (including VAT).

The report only includes transactions posted through Oracle Receivables. It does not include transactions posted directly to General Ledger.

To report in a paper format, use the Standard Request Submission windows to submit the Portuguese Customes Recapitulative report.

To report it in ASCII format, use the Standard Request Submission windows to submit the Portuguese Suppliers Recapitulative report, with the template option set to Portuguese Customer Recapitulative Extract File.

The Portuguese Customers Recapitulative Extract File is an ASCII file. The types of records are:

Prerequisites

Before you run the Portuguese Customers Recapitulative Extract file, you must:

Report Parameters

Minimum Invoiced Amount

Enter the minimum amount on an invoice that you want to report above. Only customers with total transaction amounts (including VAT) greater than what you enter are included in the extract file.

Reporting Year

Enter the tax year that you want to report on. The report always runs from January 1 to December 31 of the year that you enter.

Detail Page Headings

In this heading... Oracle Receivables prints...
Total The sum of the invoiced amounts for the current customer. Oracle Payables truncates the amounts at the decimal places.
Page Total The sum of the net amounts of the lines. Page totals do not include brought forward values. Oracle Payables truncates the amounts at the decimal places.
Report Total The report totals, a recalculation based on all detail lines in the report.

Spanish Input VAT Journal Report

Use the Spanish Input VAT Journal report to gather and report information about VAT that is charged on invoices and expense reports entered in Oracle Payables. The Spanish Input VAT Journal report is required by Spanish legislation for VAT. The report consists of two parts: a detailed section, organized by invoice accounting date and number, with totals at the end of the section; and a summary by tax, organized by tax rate code, with totals at the end of the report.

The Spanish Input VAT Journal report displays invoices and expense reports that includes VAT for the tax reporting code and balancing segment value that you choose. If an invoice has several lines with different tax rate codes, the lines for the same tax rate code are summarized.

If you want to use the balancing segment parameter to distinguish between groups of invoices, do not enter documents such as invoices and credit memos with accounting information that relates to multiple balancing segment values.

The Spanish Input VAT Journal report prints the expense reports that your employees enter for their expenses. The report prints information about the supplier that the expenses are incurred with.

The report lists prepayment transactions with VAT. When a prepayment is applied, the taxable basis and tax of the invoice that it is applied to are decreased. If a prepayment is applied to an invoice using an accounting date that differs from the invoice's, the prepayment application is listed separately on the report as a negative amount.

The report also lists miscellaneous receipts entered in Oracle Receivables with an input tax code. To represent expenses such as bank charges, enter these receipts with negative amounts. The report treats the tax on the miscellaneous receipts as fully recoverable.

Use the Standard Request Submission windows to submit the Spanish Input VAT Journal report.

Prerequisites

Before you can run the Spanish Input VAT Journal report, you must:

Report Parameters

Register Type

Enter the type of tax information that you want to display on the report:

Start Sequence Number

Enter the first number that you want the report to generate a gapless sequence from.

Note: You can generate sequences only if you enter Tax Register in the Register Type parameter.

Column Headings

In this column... Oracle Payables prints...
Seq Number The sequence number. The sequence number is unique within each year and is produced while the report is run. If an invoice has more than one tax code, the sequence number appears against the first tax code only.
Document Seq/Num The name of the sequence and the unique sequence number allocated to the invoice, separated by a slash.
Invoice Date The date of the invoice, or, for example, credit memo. Because the report orders invoices by accounting date, the invoice date may not be chronological. If an invoice has more than one line of tax codes in the report, the invoice date appears against the first tax code only.
Invoice Number The number of the invoice, or, for example, credit memo. If an invoice has more than one tax code, this number appears against the first tax code only.
Supplier Name/Fiscal Number The supplier's name. If an invoice uses more than one tax code, the supplier's name appears against the first tax code only. For miscellaneous receipts, Oracle Payables prints the bank name.
The VAT registration number for the supplier. If an invoice uses more than one tax code, the fiscal number appears against the first tax code only. For miscellaneous receipts, Oracle Payables prints the bank taxpayer ID.
Tax Code The tax code.

Spanish Periodic Modelo Report

Use the Spanish Periodic Modelo report to submit the following reports:

Use the Standard Request Submission windows to submit the Spanish Periodic Modelo report.

Prerequisites

Before running the report, mark the invoice type as Modelo 349, 347, 347PR, or 415 in the Transaction Business Category column in the Invoice window.

Report Parameters

Modelo Name

Select the applicable 347, 349, 415 Payables or Receivables reports. You can also select the property rental versions of these reports.

Note: Ensure that you select the correct template; for example, if you select to run the AP Modelo 347 report, you must select the AP Modelo 347 template.

Spanish Payables Inter-EU Operations Summary Data Extract (Modelo 349)

The Spanish Payables Inter-EU Operations Summary Data Extract (Modelo 349) is a summary by supplier of Inter-EC purchases of physical goods. For transactions that correct previous declarations, the report separately lists the relevant suppliers and invoice amounts with the period and year of the correction.

The report displays invoice totals for each supplier. For more information, see Spanish Receivables Inter-EU Operations Summary Report (Modelo 349).

Use the Standard Request Submission windows to submit the Spanish Payables Inter-EU Operations Summary Data Extract (Modelo 349).

Prerequisites

Before you can run the Spanish Payables Inter-EU Operations Summary Data Extract (Modelo 349), you must:

Making Corrections and Running the Modelo 349 Report

This section provides hypothetical examples of making rectifications and running the Modelo 349 report.

Standard Invoices

In this example, invoices are entered for the first quarter of 2002, which is referred to as T1-2002, and runs from 01-JAN-2002 to 31-MAR-2002. Only invoices with GL dates that fall within that date range are reported for this period.

Rectifications

If the quarter T1-2002 is closed and declared, but you want to enter rectification invoices that relate to that quarter, you must first enter the invoices in the current open quarter. These invoices should indicate the correction year (2002) and the correction period (T1) that you are rectifying. These rectification transactions are reported in the Rectification Detail record for the Modelo 349 declaration for the GL date. For example, if a rectification invoice was entered with a GL Date of 16-MAY-2002, but the global descriptive flexfield indicates the correction period as T1-2002, the invoice is reported in the rectification detail record of the Modelo 349 declaration for the second quarter of the year (T2) but displays the correction period as T1-2002.

In the Modelo 349, the rectification record must display: Correction Year, Correction Period, Corrected Taxable Amount, and Taxable Amount Formerly Declared. To report the taxable amount that was formerly declared, the Modelo 349 report must have some record of the previously reported amount for that third party in the period and year that you are correcting.

Corrections Directed by the Authorities

The Modelo 349 report also lets you enter a correction for an already closed period. You might need to resubmit the report if the authorities have directed you to change an amount on the report that was already submitted.

Returning to the example, you have filed your report for quarter T1-2002. This table shows the amounts that you have declared:

Name Amount
Supplier A 150000 euros
Supplier B 85000 euros
Customer C 260000 euros
Customer D 225000 euros

Periods JAN-02, FEB-02, MAR-02 should now be closed in Payables and Receivables to prevent further transactions from being entered into these declared periods. You will now be entering invoices with GL dates in April, May, and June 2002 to be included in the T2-2002 report. During this time, you receive a notification from the authorities instructing you that the amount declared for T1-2002 for Supplier B must be changed to 89000 euros. You should reopen one of the periods that relate to the first quarter, either JAN-02, FEB-02, or MAR-02, and enter an invoice for 4000 euros with a GL date in one of those periods to correct the total, as instructed by the authorities. You should then resubmit the report for T1-2002. The total for Supplier B is now updated to reflect the new reported amount, 89000 euros. You can re-run the report for T1-2002 any time until the final report for T2-2002 is run.

You can reopen periods in Payables and Receivables to make these special corrections as long as the period was not permanently closed and the corresponding General Ledger period is also open. Do not permanently close an accounting period until you are certain that no additional transactions are needed.

Once you are certain that you will not be directed to change any reported amounts for the Modelo 349, you should run the Final process and report in Final mode for that quarter to indicate that no further changes can be made to the report. If you need to reprint a duplicate of a final report from a previous period, you can run the report in Reprint mode.

Spanish Payables Operations with Third Parties Data Extract (Modelo 347)

The Spanish Payables Operations with Third Parties Data Extract (Modelo 347) summarizes by supplier all domestic purchases and imports of services. The Spanish Payables Operations with Third Parties Data Extract (Modelo 347) includes all purchases that are not reported on the Spanish Payables Inter-EU Operations Summary Data Extract (Modelo 349), not reported to customs (such as movements of goods between the Canary Islands and the mainland), or not reported on your income tax withholding declarations (Modelo 190).

The Spanish Payables Operations with Third Parties Data Extract (Modelo 347) contains:

Prerequisites

Before you can run the Spanish Payables Operations with Third Parties Data Extract (Modelo 347), you must:

Spanish Payables Canary Islands Annual Operations Data Extract (Modelo 415)

The Spanish Payables Canary Islands Annual Operations Data Extract (Modelo 415) is a summary by supplier of domestic purchases (both goods and services) in the Canary Islands that are subject to the Canary Islands VAT regime Impuesto General Indirecto Canario (IGIC). Total purchases with suppliers below the specified threshold are not included in the report.

The total domestic purchases that are on the report also include prepayment invoices. All approved prepayment invoices are included in the report, whether paid or unpaid. If a transaction has a prepayment applied, the transaction must be declared for the total amount less the prepayment amount. If the prepayment has not been applied to an invoice, the prepayment must be considered at its absolute value. This is reported as a positive amount which is added to the supplier transaction total.

Any invoices, including prepayments, that you want to appear on the Modelo 415 report must have one of these values in the Transaction Business Category column in the Invoice window:

For more information, see Spanish Receivables Canary Islands Annual Operations Data Extract (Modelo 415) and Spanish Payables Canary Islands Annual Operations Magnetic Format (Modelo 415).

Use the Standard Request Submission windows to submit the Spanish Payables Canary Islands Annual Operations Data Extract (Modelo 415).

Prerequisites

Before you can run the Spanish Payables Canary Islands Annual Operations Data Extract (Modelo 415), you must:

Spanish Inter-EU Invoices Journal Report

Use the Spanish Inter-EU Invoices Journal report to review the invoices entered and posted in Oracle Payables that have offset tax distributions. These invoices normally are Inter-EU invoices that you receive from suppliers in other countries within the European Union.

The Spanish Inter-EU Invoices Journal report displays the information that would be displayed on the Spanish Output VAT Journal report (IVA Recapulativa) if you created the corresponding self invoices in Oracle Receivables. You can use this report as a guide to create the self invoices in Oracle Receivables or you can simply include this report along with the standard Spanish Output VAT Journal report that you send to tax authorities.

Note: Because offset tax codes are usually defined as fully recoverable, the Spanish Inter-EU Invoices Journal report displays the full amounts of offset tax.

The report also lists prepayment transactions with VAT. When a prepayment is applied, the taxable basis of the invoice that it is applied to is decreased. If a prepayment is applied to an invoice using an accounting date that differs from the invoice's, the prepayment application is listed separately on the report as a negative amount.

As with the Spanish Input VAT Journal report (IVA Soportado) and Spanish Output VAT Journal report (IVA Repercutido), the Spanish Inter-EU Invoices Journal report has an invoice detail section, followed by a summary of the invoices grouped by tax code.

Use the Standard Request Submission windows to submit the Spanish Inter-EU Invoices Journal report.

Prerequisites

Before you can run the Spanish Inter-EU Invoices Journal report, you must:

Spanish Inter-EU Invoice Format (Documento Equivalente)

Use the Spanish Inter-EU Invoice Format (Documento Equivalente) to print a self invoice to justify the inclusion of Inter-EC goods purchases invoices on both the Spanish Input VAT Journal report and the Spanish Output VAT Journal Report.

The Spanish Inter-EU Invoice Format (Documento Equivalente) prints details of the same invoices that appear on the Spanish Inter-EU Invoices Journal Report.

Use the Standard Request Submission windows to submit the Spanish Inter-EU Invoice Format (Documento Equivalente).

Spanish Output VAT Journal Report

Use the Spanish Output VAT Journal report to gather and report information about tax on transactions entered in Oracle Receivables. The report is required by Spanish authorities. The Spanish Output VAT Journal report has two parts: a detailed section, ordered by invoice accounting date and number of invoice, with totals at the end of the section; and a summary by tax, ordered by tax code, with totals at the end of the report. Oracle Receivables displays invoices accounted for with VAT for the balancing segment value that you choose. If an invoice has several lines with different tax codes, the lines for the same tax code are summarized.

If you want to use the balancing segment parameter to distinguish between groups of invoices, you should not enter documents such as invoices and credit memos with accounting information that relates to multiple balancing segment values.

Use the Standard Request Submission windows to submit the Spanish Output VAT Journal report.

Prerequisites

Before you can run the Spanish Output VAT Journal report, you must:

Report Parameters

Register Type

Enter the type of tax information that you want to display on the report:

Generate Sequence Number

Enter Yes to generate sequence numbers or No to not generate sequence numbers. Enter Yes if you are not using gapless sequencing.

Spanish Receivables Inter-EU Operations Summary Data Extract (Modelo 349)

The Spanish Receivables Inter-EU Operations Summary Data Extract (Modelo 349) is a summary by customer of Inter-EC sales of physical goods. For transactions that correct previous declarations, the report separately lists the relevant customers and invoice amounts, with the period and year of the correction. The report also marks transactions that are triangulation operations and displays invoice totals for each customer.

For more information, see Spanish Payables Inter-EU Operations Summary Data Extract (Modelo 349) and Spanish Inter-EU Operations Summary Magnetic Format (Modelo 349).

Use the Standard Request Submission windows to submit the Spanish Receivables Inter-EU Operations Summary Data Extract (Modelo 349).

Prerequisites

Before you can run the Spanish Receivables Inter-EU Operations Summary Data Extract (Modelo 349), you must:

Spanish Receivables Operations with Third Parties Data Extract (Modelo 347)

The Spanish Receivables Operations with Third Parties Data Extract (Modelo 347) is a summary by customer of all domestic sales and exports of services. The Spanish Receivables Operations with Third Parties Data Extract (Modelo 347) includes all sales that are not reported on the Spanish Receivables Inter-EU Operations Summary Data Extract (Modelo 349) or not reported to customs (such as movements of goods between the Canary Islands and the mainland).

The Spanish Receivables Operations with Third Parties Data Extract (Modelo 347) contains:

Use the Standard Request Submission windows to submit the Spanish Receivables Operations with Third Parties Data Extract (Modelo 347).

Prerequisites

Before you can run the Spanish Receivables Operations with Third Parties Data Extract (Modelo 347), you must:

Column Headings

In this column… Oracle Receivables prints…
Property Rental Yes, if the invoice refers to a property rental.
Location Rented location, with rates reference, street type, street name, street number, staircase number, floor number, door number, town or city, postal code.

Spanish Receivables Canary Islands Annual Operations Data Extract (Modelo 415)

The Spanish Receivables Canary Islands Annual Operations Data Extract (Modelo 415) is a summary by customer of domestic sales (both goods and services) in the Canary Islands that are subject to the Canary Islands VAT regime Impuesto General Indirecto Canario (IGIC). Total sales with customers below the specified threshold are not included in the report.

For more information, see Spanish Payables Canary Islands Annual Operations Data Extract (Modelo 415) and Spanish Canary Islands Annual Operations Magnetic Format (Modelo 415).

Use the Standard Request Submission windows to submit the Spanish Receivables Canary Islands Annual Operations Data Extract (Modelo 415).

Prerequisites

Before you can run the Spanish Receivables Canary Islands Annual Operations Data Extract (Modelo 415), you must:

Row Headings

In this row… Oracle Receivables prints…
Number of Operations Total number of customers with total sales that exceed the minimum amount in the report period.
Amount of Operations Total amount of transactions with total sales that exceed the minimum amount in the report period.
Total Operations Total amount of all transactions in the report period.

Spanish Annual Modelo Magnetic Format Report

Use the Spanish Annual Modelo Magnetic Format report to submit the following reports:

Use the Standard Request Submission windows to submit the Spanish Periodic Modelo report.

Report Parameters

Modelo Name

Select the applicable 347, 349, or 415 Payables or Receivables reports. You can also select the property rental versions of these reports.

Reference Number

Enter the reference number for the accompanying letter.

Main Activity

Enter your main financial activity, such as business activities, professional and arts activities, renters of properties, and agricultural stock or fishing activities.

Main Activity Code

Enter the tax activity code for the main activity entered in the Main Activity parameter.

Second Activity

Enter your second financial activity, such as business activities, professional and arts activities, renters of properties, and agricultural stock or fishing activities.

Second Activity Code

Enter the tax activity code for the second activity entered in the Second Activity parameter.

Total Sales

Enter the minimum of sales that the Spanish government specifies for Modelo 415 reporting.

Total Purchases

Enter the minimum of purchases that the Spanish government specifies for Modelo 415 reporting.

Tax Office Province and Region Codes

Enter the code of the tax authority office.

Medium

Select the applicable delivery medium.

Spanish Operations with Third Parties Magnetic Format (Modelo 347)

The Spanish Operations with Third Parties Magnetic Format (Modelo 347) provides an electronic report for submission to the Spanish government. The report contains operations with third parties and property rentals over a specified period whose annual total sales exceeds a threshold designated by the Spanish government.

The Spanish Operations with Third Parties Magnetic Format (Modelo 347) creates an electronic report in a format determined by the Spanish government from the contents of the JG_ZZ_VAT_TRX_DETAILS table. This table holds third party operations and property rental information transferred from the Spanish Payables Operations with Third Parties Data Extract (Modelo 347) and Spanish Receivables Operations with Third Parties Data Extract (Modelo 347). You can also manually insert data in this table from other sources, including non-Oracle systems.

The Spanish Operations with Third Parties Magnetic Format (Modelo 347) consists of four records: presenter record, declarer header record, operations with third parties detail record, and property rentals detail record. The records are fixed length, 250 uppercase characters.

Use the Standard Request Submission windows to submit the Spanish Operations with Third Parties Magnetic Format (Modelo 347).

Spanish Inter-EU Operations Summary Magnetic Format (Modelo 349)

The Spanish Inter-EU Operations Summary Magnetic Format (Modelo 349) provides an electronic report for submission to the Spanish government. The report is a magnetic format of all Inter-EC sales and purchases of goods over a period that you specify.

The Spanish Inter-EU Operations Summary Magnetic Format (Modelo 349) creates an electronic report in a format determined by the Spanish government from the contents of the JG_ZZ_VAT_TRX_DETAILS table. This table holds Inter-EC sales and purchasing transactions transferred from the Spanish Payables Inter-EU Operations Summary Data Extract (Modelo 349) and Spanish Receivables Inter-EU Operations Summary Data Extract (Modelo 349). You can also manually insert data into this table from other sources, including non-Oracle systems.

The Spanish Inter-EU Operations Summary Magnetic Format (Modelo 349) consists of three records: presenter header record, declarer header record, and detail record. The records are fixed length, 190 uppercase characters.

Use the Standard Request Submission windows to submit the Spanish Inter-EU Operations Summary Magnetic Format (Modelo 349).

Spanish Canary Islands Annual Operations Magnetic Format (Modelo 415)

The Spanish Canary Islands Annual Operations Magnetic Format (Modelo 415) provides an electronic report for submission to the Canary Islands tax authorities. The report is a magnetic format of all IGIC transactions with local suppliers and customers, for businesses whose annual total sales exceeds a threshold amount designated by the Spanish government.

The Spanish Canary Islands Annual Operations Magnetic Format (Modelo 415) creates an electronic report in a format determined by the Spanish government from the contents of the JG_ZZ_VAT_TRX_DETAILS table. This table holds IGIC transactions transferred by the Spanish Payables Canary Islands Annual Operations Data Extract (Modelo 415) and the Spanish Receivables Canary Islands Annual Operations Data Extract (Modelo 415). You can also manually insert data into this table from other sources, including non-Oracle systems.

Note: The Spanish Canary Islands Annual Operations Magnetic Format must be provided in electronic format if the number of third parties declared exceeds 500.

The Spanish Canary Islands Annual Operations Magnetic Format (Modelo 415) consists of four records: file header record, declarer header record, summary information, and each fiscal entity reported. The records are fixed length, 142 uppercase characters.

Use the Standard Request Submission windows to submit the Spanish Canary Islands Annual Operations Magnetic Format (Modelo 415).

Swiss Payables VAT Report

Use the Swiss Payables VAT report to report all Payables transactions that reference a VAT code. The Swiss Payables VAT report is ordered by date and shows the tax and net expense amounts for each invoice by account code.

Recoverable tax amounts appear in the Material/Service column or the Investment/Other column, depending on the tax regime to which the amounts belong. Non-recoverable tax amounts appear in the Net Amount column, since you account for non-recoverable tax as an expense rather than as a tax.

Note: The Swiss Payables VAT report includes only taxable transactions. Internal transactions such as contra credit memos are not included on the report.

Use the Standard Request Submission windows to submit the Swiss Payables VAT report.

Prerequisites

Before you submit the Swiss Payables VAT report, you must: .

Reverse Charge VAT

Reverse Charge VAT is an exceptional rule in the UK where the VAT is not collected from the buyer. The seller sells the products without charging VAT and it is the responsibility of the buyer to pay VAT to Her Majesty's Revenue and Customs (HMRC). The seller specifies that the reverse charge is applicable in the sales invoice and the amount the buyer must pay to HMRC. The Reverse Charge VAT applies to sale and purchase of electronic products in the UK by a VAT registered business for business purposes, such as sales to non-business customers.

Note: European customers and foreign customers are not affected by the reverse charge VAT.

Reverse Charge affects the following:

Prerequisites

Set up the following in Oracle E-Business Tax and Oracle Bill Presentment Architecture for reverse charge VAT functionality.

The following setup is recommended for Reverse Charge VAT in Oracle E-Business Tax:

The following setup is recommended in the Bill Presentment Architecture:

UK Reverse Charge Sales List Report

The UK Reverse Charge Sales Listing report includes details of the customer charged with the reverse charge and the appropriate transaction details as required by HMRC. The report contains the following information:

You can print the reports in PDF and CSV formats and submit the report online by uploading the CSV file to the Reverse Charge Sales List (RCSL) service provided by HMRC.

Note: The CSV file size must not exceed 900 KB.

Use the Standard Request Submission windows to submit the Reverse Charge Sales List report.

Report Parameters

Legal Entity

Select a legal entity to indicate the reporting unit.

Tax Registration Number

Select the applicable tax registration number for the selected legal entity.

From Date

Select the start date for the reverse VAT period.

To Date

Select the end date for the reverse VAT period.