Oracle ERP Cloud. Release 11. Global Catalog

Oracle ERP Cloud Release 11 Global Catalog December 2016 TABLE OF CONTENTS REVISION HISTORY ..........................................................
Author: Milton Copeland
8 downloads 2 Views 6MB Size
Oracle ERP Cloud Release 11

Global Catalog December 2016

TABLE OF CONTENTS REVISION HISTORY ................................................................................................................................................ 5 OVERVIEW............................................................................................................................................................. 6 LANGUAGES SUPPORTED ......................................................................................................................................... 7 ICONS USED IN THIS DOCUMENT ............................................................................................................................... 8 COMMON FUNCTIONALITY APPLICABLE TO MULTIPLE COUNTRIES ....................................................................... 9 COMMON FEATURES GENERALLY USED LOCALLY ........................................................................................................... 9 ASSETS .............................................................................................................................................................. 12 Assets Impairments ............................................................................................................................................ 12 Asset Register Report ......................................................................................................................................... 12 Assets Revaluations ............................................................................................................................................ 13 CASH MANAGEMENT ............................................................................................................................................ 14 Bank Statement Formats.................................................................................................................................... 14 Intraday Bank Statement Support ...................................................................................................................... 14 EXPENSES ........................................................................................................................................................... 15 Mileage Expense Processing .............................................................................................................................. 15 Policy Compliance for Gifts and Entertainment Expenses .................................................................................. 15 Policy Compliance for Meals, Accommodations and Other Expenses ................................................................ 15 GENERAL LEDGER ................................................................................................................................................. 16 General Ledger Trial Balance and Journals Reports ........................................................................................... 16 Sequencing by Legal Entity or Ledger ................................................................................................................. 16 Year-end Closing Journals................................................................................................................................... 16 PAYABLES........................................................................................................................................................... 17 Cross-Currency Payments ................................................................................................................................... 17 Invoice Update Service ....................................................................................................................................... 17 PAYMENTS ......................................................................................................................................................... 18 ISO 20022 Direct Debits and Credit Transfers (SEPA) ......................................................................................... 18 Payment and Accompanying Formats................................................................................................................ 18 RECEIVABLES ....................................................................................................................................................... 20 Automatic Receipts Reversal .............................................................................................................................. 20 Bills Receivable ................................................................................................................................................... 20 Discount Calculation Basis Date ......................................................................................................................... 20 Electronic Delivery of Customer Invoices ............................................................................................................ 20 Print Receivables in Different Formats ............................................................................................................... 20 SUBLEDGER ACCOUNTING ...................................................................................................................................... 21 Expanded Subledger Journal Entry Description .................................................................................................. 21 Subledger Accounting Reports ........................................................................................................................... 21 TAX .................................................................................................................................................................. 29 European Community Sales Listing Report......................................................................................................... 29 Interim Tax Register ........................................................................................................................................... 30 Manual and External Tax Transactions In The Tax Repository ........................................................................... 30 Select and Finalize Transactions for Tax Reporting ............................................................................................ 31 Tax Box Allocation and Reporting ...................................................................................................................... 31

2

Tax Calendar....................................................................................................................................................... 32 Tax Point Date .................................................................................................................................................... 32 Tax Reconciliation and Audit Reports................................................................................................................. 33 Tax Registration Validation ................................................................................................................................ 39 Transaction Tax Configuration ........................................................................................................................... 40 Turnover Reporting Selection and Declaration .................................................................................................. 40 Withholding Tax ................................................................................................................................................. 40 Yearly Tax Report ............................................................................................................................................... 40 LOCALIZATIONS FOR THE AMERICAS ................................................................................................................... 42 LOCALIZATIONS FOR CANADA.................................................................................................................................. 42 Capital Cost Allowance Calculations for Canada ................................................................................................ 42 LOCALIZATIONS FOR MEXICO .................................................................................................................................. 43 Electronic Accounting Reports for Mexico.......................................................................................................... 43 Electronic Invoice Integration with PAC for Mexico ........................................................................................... 43 LOCALIZATIONS FOR ASIA ................................................................................................................................... 45 LOCALIZATIONS FOR CHINA .................................................................................................................................... 45 Cash Flow Statement (CNAO Standard) ............................................................................................................. 45 Financial Data Export for Enterprise .................................................................................................................. 45 Golden Tax Adaptor ........................................................................................................................................... 45 LOCALIZATIONS FOR KOREA .................................................................................................................................... 47 VAT Reports for Korea ........................................................................................................................................ 47 Summary Billing for Korea .................................................................................................................................. 48 Withholding Tax Reports for Korea .................................................................................................................... 48 LOCALIZATIONS FOR SINGAPORE .............................................................................................................................. 50 Input Tax Gain and Loss Report for Singapore ................................................................................................... 50 Output Tax Gain and Loss Report for Singapore ................................................................................................ 50 LOCALIZATIONS FOR EUROPE, MIDDLE EAST AND AFRICA .................................................................................. 52 LOCALIZATIONS FOR FRANCE................................................................................................................................... 52 Audit File for France ........................................................................................................................................... 52 DAS2 Reporting for France ................................................................................................................................. 52 DeductIble VAT Declaration Report for France .................................................................................................. 54 International Electronic File Transfer for France ................................................................................................ 55 LOCALIZATIONS FOR GERMANY ............................................................................................................................... 56 Journal Details Report for Germany ................................................................................................................... 56 Z4 Report for Germany ....................................................................................................................................... 56 Z5A Report for Germany .................................................................................................................................... 57 LOCALIZATIONS FOR ISRAEL .................................................................................................................................... 58 Withholding Tax Report for Israel ...................................................................................................................... 58 Withholding Tax Reconciliation Report for Israel ............................................................................................... 59 Withholding Tax File to Tax Authority for IsraeL ................................................................................................ 59 Withholding Tax Annual Certificate to Suppliers for Israel ................................................................................ 60 Receipt Report for Israel ..................................................................................................................................... 61 LOCALIZATIONS FOR ITALY ...................................................................................................................................... 62

3

Declarable Input VAT Register for Italy .............................................................................................................. 62 Declarable Output VAT Register for Italy ........................................................................................................... 63 European Purchases Listing of Services for Italy ................................................................................................ 64 European Sales Listing of Services for Italy ........................................................................................................ 64 Letter of Intent Processing for Italy .................................................................................................................... 65 Payables Sales VAT Register (Self Invoices, EEC, VAT) for Italy .......................................................................... 66 Purchase VAT Register for Italy .......................................................................................................................... 67 Receivables Sales VAT Register for Italy ............................................................................................................. 68 Trading Partner Declaration for Italy ................................................................................................................. 69 VAT Liquidation Report for Italy ......................................................................................................................... 69 Withholding Tax Letters for Italy ........................................................................................................................ 71 Yearly Withholding Tax Report for Italy ............................................................................................................. 72 LOCALIZATIONS FOR SPAIN ..................................................................................................................................... 73 Modelo 190 Withholding Tax Declaration for Spain .......................................................................................... 73 Modelo 340 Informative Declaration of Transactions for Spain ........................................................................ 73 Modelo 347 Operations with Third Parties Declaration for Spain...................................................................... 74 Modelo 349 Inter-EU Operations Summary Declaration for Spain .................................................................... 74 Modelo 415 Canary Islands Annual Operations Declaration for Spain .............................................................. 75 Modelo Data Extract for Spain ........................................................................................................................... 75 Input VAT Journal for Spain ................................................................................................................................ 75 Output VAT Journal for Spain ............................................................................................................................. 76 VAT Inter-EU Invoice Journal for Spain ............................................................................................................... 76 VAT Inter-EU Invoice Format for Spain ............................................................................................................... 77 LOCALIZATIONS FOR UK ........................................................................................................................................ 78 Reverse Charge Sales List Report for UK............................................................................................................. 78

4

REVISION HISTORY This document will continue to evolve as existing sections change and new information is added. All updates are logged below, with the most recent updates at the top. Date 13 DEC 2016

15 MAR 2016

What's Changed Languages Supported Section

Notes Removed ‘Spanish (Latin America)’ and ‘Portuguese’, consistent with WPTG translated languages list. Initial Document Creation

5

OVERVIEW ERP Cloud is based on a robust, global architecture and combines the power of a global business software suite with specific, integrated localizations that address financials, tax and other local business needs. It includes complete internationalization support, including number, date, names, and addresses formatting and is available in 24 languages. The application includes scalable enterprise structures for large enterprises to model their business, supporting unlimited accounting representations and statutory reporting needs, all in a single global instance using standard preferences and setup, allowing global customers to adapt their software for a specific region or country without requiring multiple implementations of the product. The solution includes tax, payments and accounting engines to meet a broad range of global business needs, you can find examples of these features and how they relate with the different countries in the Common Functionally Applicable to Multiple Countries section of this document. ERP Cloud also provides country specific localizations to meet local business requirements. They are described in the regional sections of this document grouped by country.

6

LANGUAGES SUPPORTED ERP Cloud is available in the following 24 languages. Arabic Chinese (Simplified) Chinese (Traditional) Czech Danish Dutch

English Finnish French (Canadian) French (European) German Hebrew

Hungarian Italian Japanese Korean Norwegian Polish

Portuguese (Brazil) Romanian Russian Spanish Swedish Turkish

7

ICONS USED IN THIS DOCUMENT In the title line of each feature you can see some icons that point out some characteristics of the feature. Here are the ones used in this document. New Feature: Indicates when a feature is new in the current release.

Recently Updated: Indicates when a features was recently updated in current release, either because a change in local regulations or generic enhancements. Additional Information Available: These features are described in specific documents providing details about set-up, configuration, transaction entry, process flow, output, etc. Some of them are documented as Topical Essays which can be found in the Additional Resource Section on the Financials Cloud ‘Learn More’ tab / Additional Resources Others can be found as MOS Notes in My Oracle Support. Online Video Session Available: They can be found at https://cloud.oracle.com/ under the Release Readiness Section, navigate to ‘What’s New’ and Financials Release Training. Training Videos provide an in-depth view of the feature. To access all videos you need to select different Releases at the top of the page.

8

COMMON FUNCTIONALITY APPLICABLE TO MULTIPLE COUNTRIES COMMON FEATURES GENERALLY USED LOCALLY The following matrix indicates the countries where the common functionality is typically used to address legal local requirements or major business practices. In some cases features need specific local configuration to meet individual country or entity requirements.



UK





UAE





  

Switzerland





  

Sweden







South Africa







Spain



Saudi Arabia

Italy 

Norway

Israel   

Nigeria

Ireland   

Netherlands

Germany  

Luxemburg

France  

Finland

Egypt

Denmark

Belgium

Austria

Singapore

Philippines

New Zealand

Europe, Middle East and Africa

Malaysia

Korea

Japan

Hong Kong

China

Australia

Asia

Mexico

Puerto Rico

Colombia

Chile

Canada

Americas

Assets Assets Impairments Assets Register Report Assets Revaluations

 

 



 

  



  



Cash Management Bank Statement Formats



Intraday Bank Statement Support





















 



























 

 





























Expenses Mileage Expense Processing



Policy Compliance for Gifts and Entertainment Expenses Policy Compliance for Meals, Accommodations and Other Expenses



















































 





 

General Ledger

General ledger Trial Balance and Journals Reports Sequencing by Legal Entity or Ledger Year-End Closing Journals

 



  











  



















Egypt

Finland

France

Germany

Ireland

Israel

Italy





















UK

Denmark



UAE

Belgium



Switzerland

Austria



Sweden

Singapore



South Africa

Philippines



Spain

New Zealand



Saudi Arabia

Malaysia



Norway

Korea



Nigeria

Japan



Netherlands

Hong Kong



Luxemburg

China

Europe, Middle East and Africa

Australia

Asia

Mexico

Puerto Rico

Colombia

Chile

Canada

Americas





















Payables Cross-Currency Payments



Invoice Update Service



Payments ISO 20022 Direct Debits and Credit Transfers Payment and Accompanying Formats











































































Receivables Automatic Receipts Reversal



Bills Receivable Discount Calculation Basis Date Electronic Delivery of Customer Invoices Print Receivables Transactions in Different Formats









































 





















































































































































Subledger Accounting

Expanded Subledger Journal Entry Description Subledger Accounting Reports























 

Tax European Community Sales Listing for Goods and Services Interim Tax Register

 

Manual and External Tax Transactions in the Tax Repository Select and Finalize Transactions for Tax Reporting Tax Box Allocation and Reporting











































Tax Point Date







Tax Reconciliation and Audit Reports









 

Tax Calendar

































































 

































































































































































 













10

Chile Colombia Puerto Rico Mexico

Tax Registration Validation     

Transaction Tax Configuration

Turnover Reporting Selection and Declaration Withholding Tax     

 

Yearly Tax Report   

   



  

Belgium

 





 

 

 

  

Germany

 



 

Luxemburg

  

 

    

    

   



UK

UAE

Switzerland

Sweden

South Africa

Spain

Saudi Arabia

Norway

Nigeria

Netherlands

Italy

Israel

Asia

Ireland

France

Finland

Egypt

Denmark

Austria

Singapore

Philippines

New Zealand

Malaysia

Korea

Japan

Hong Kong

China

Australia

Canada

Americas Europe, Middle East and Africa





 

11

ASSETS ASSETS IMPAIRMENTS Capital assets may incur unexpected or sudden decline in value. This decline in value could be due to physical damage to the asset, obsolescence due to technological innovation, or changes to legal codes. You can control the recoverable cost of an asset. When the recoverable cost is less than its carrying cost, the difference is treated as an impairment loss and is recognized as the expense on the income statement. ASSET REGISTER REPORT Asset Register Report helps companies gain better visibility and control of their assets; they can track the value of their assets, confidently compute depreciation for tax and insurance purposes, and prevent misappropriation. Use the Assets Register report to comply with country specific reporting for assets located worldwide and control capital budgeting. The report lists the cost-related details, current activity, and retirements for every asset within the selected asset category, totals per asset category, cost account, year placed in service and includes all transactions that impact asset cost during the chosen period.

12

ASSETS REVALUATIONS Assets Revaluation functionality supports International Accounting Standards (IAS 16) to restate the carrying cost of property, plant, and equipment assets to their fair values, less any subsequent accumulated depreciation and accumulated impairment losses. Use spreadsheets to revalue your fixed assets using the cost or net book value methods and accurately assess the accounting impacts on equity and profit-and-loss accounts

13

CASH MANAGEMENT BANK STATEMENT FORMATS The electronic bank statement process transfers bank statements and imports them into Oracle Fusion Cash Management. You can load data to interface tables using the following predefined bank statement formats:    

BAI2 Format EDIFACT FINSTA Format ISO20022 MX CAMT053.001.01 Format SWIFT MT940 Format

INTRADAY BANK STATEMENT SUPPORT Native support for ISO 20022 CAMT052 V2, SWIFT MT942, BAI2, and EDIFACT FINSTA intraday bank statements formats reduces the time and costs associated with processing and proving intraday cash balances. This enables users to better analyze and manage liquidity based on daily cash position reports that reflect confirmed cash flows from intraday bank statements.

14

EXPENSES MILEAGE EXPENSE PROCESSING Companies allow their employees to claim mileage reimbursement to offset travel expenses incurred when using their personal vehicles. In some countries, mileage reimbursement rates are regulated by local authorities. Your company administrators can configure mileage rates and mileage eligibility rules based on the local regulations or company policies. When you enter mileage, mileage reimbursement is automatically calculated based on the defined rates and eligibility rules. Mileage reimbursement calculation also supports passenger rates and additional company-specified rates. POLICY COMPLIANCE FOR GIFTS AND ENTERTAINMENT EXPENSES Several industries and local authorities have enacted gifts and entertainment regulations to provide transparency and to curtail the amount spent to influence business decision makers. By utilizing gifts and entertainment expense policies you can configure spending rules, identify policy violations, and capture information about event attendees and gift recipients. POLICY COMPLIANCE FOR MEALS, ACCOMMODATIONS AND OTHER EXPENSES Oracle Fusion Expenses supports control of travel costs and helps enforce company or country specific policy compliance by defining spending rules for accommodations, meals, and miscellaneous expenses. Managers can view policy violations that are automatically highlighted in approval requests, and auditors can actively monitor policy violations with automated selections of noncompliant reports.

15

GENERAL LEDGER GENERAL LEDGER TRIAL BALANCE AND JOURNALS REPORTS Oracle Fusion General Ledger reports, such as the trial balance and journal reports provide a broad range of run-time options and also show account balances and account activity totals by accounting sequences and reporting sequences, to better meet country-specific content and auditing requirements. The predefined formats and templates are enabled for user adjustments using Oracle Business Intelligence Publisher including: General Ledger Journal and Balance Report. General Ledger Journal Entry Report, General Ledger Trial Balance Report. SEQUENCING BY LEGAL ENTITY OR LEDGER Sequential numbering of documents and accounting entries is a legal requirement in many countries. In the USA, UK and other Commonwealth countries document sequencing is used for internal control purposes, for financial statement audits, and other audits. Southern European, Latin-American and Asian countries require document sequencing by legal entity to meet statutory requirements. You can apply sequencing by legal entity or by ledger and enforce the chronological date order. Document and Accounting sequences and their versions can be automatically created, based on the commonly used sequencing settings, at time of configuring the enterprise, defining new receivables transaction types, receipt methods and receivables activities. You also have an option to override the sequencing defaulted configuration manually. Document and journal sequencing setup is simplified and automated using a spreadsheet upload. YEAR-END CLOSING JOURNALS Comply with local accounting standards in several European countries by automatically generating yearend closing journal entries that net debit and credit balances for Profit and Loss and Balance Sheet accounts.

16

PAYABLES CROSS-CURRENCY PAYMENTS Effectively manage your global, cross-border and cross-business-units transactions with cross-currency payments. Pay invoices in any currency, irrespective of the invoice currency. This allows you to make payments in the most stable currency or comply with legal regulations that mandate payment in a specific currency. INVOICE UPDATE SERVICE In countries where Electronic Invoice is regulated by Tax Authorities you can streamline the updating of invoices in the invoice interface tables using the Payables Invoice web service directly from the Government e-billing sites.

17

PAYMENTS ISO 20022 DIRECT DEBITS AND CREDIT TRANSFERS (SEPA) Standardize the process for customer (Direct Debit – pain.008.001.02) and supplier (Credit Transfer – pain.001.001.03) payments to comply with Single European Payment Area (SEPA) and Common Global Implementation (CGI) initiatives, which are based on the ISO 20022 framework. Direct Debits processing includes customer authorizations (mandates), amendments and cancellations, pre-notification of direct debit transactions and acknowledgments before the actual settlements. PAYMENT AND ACCOMPANYING FORMATS In Oracle Fusion Payments, formatting is the placement of data in a file by using a template that contains generic and country specific prescribed formatting attributes, such as data location, font type, and font size. Templates are accessible in Oracle Business Intelligence Publisher to correctly format funds capture and disbursement transactions and to enable you to easily manage or modify them according to local legislatives and your bank standards. Use existing country specific or generic templates to modify them with minimal effort by using a standard text editor, such as Microsoft Word. The predefined, sample templates are:                   

Belgian EFT Format Belgian Foreign EFT Format Finnish LMP2 EDFT Format Finnish LMP2 EDFT Format Finnish LUM EDFT Format French Check Format French Check Format (Stub after Payment) French Promissory Note Format French EFT Format French International EFT Format French Bills Receivable Remittance Format German Check Format German Check Format (Stub after Payment) German Domestic EFT Format German International EFT Format German Wire Format German Domestic EFT Accompanying Letter Format German International EFT Accompanying Letter Format German Direct Debit Format 18

                          

German Direct Debit Accompanying Letter Format Italian EFT Format Italian Wire Format Italian Bills Receivable Remittance Format Japanese Zengin Format Netherlands Domestic EFT Format Netherlands Foreign EFT Format Bank of New Zealand EFT Format Norwegian BBS Format Norwegian Telepay Format Spanish Bill of Exchange Format Spanish Check Format Spanish Magnetic Format Spanish CSB 19 Direct Debit Magnetic Format Spanish CSB 32 Remittance Format Spanish CSB 58 Remittance Format Swedish Domestic Bankgiro Format Swedish Domestic Postgiro Format Swedish Foreign Postgiro Format Swedish SISU Bankgiro Format Swedish UTLI Bankgiro Format Swiss DTA Format Swiss SAD Format Swiss DTA Accompanying Letter Format Swiss SAD Accompanying Letter Format UK BACS ½ Inch Tape Format US NACHA IAT FORMAT

19

RECEIVABLES AUTOMATIC RECEIPTS REVERSAL Support for reversal of receipts per ISO 20022 standard in Oracle Fusion Cash Management. Receipts that cannot be processed by the bank due to issues either with the receipt itself or receipt transmission are automatically reversed in Oracle Fusion Receivables. The ISO 20022 rejection codes in the ‘pain’ message are mapped to the reversal categories for processing by Oracle Fusion Payments. Use Automatic Receipts Reversal and Reversal Status Report to support local country requirements which implemented ISO 20022. BILLS RECEIVABLE Comprehensive solution in Oracle Fusion Receivables to manage the entire lifecycle of bills receivable: creation, acceptance, remittance, maturity, risk elimination, accounting, clearing, and history tracking. DISCOUNT CALCULATION BASIS DATE Enhanced discount calculations during receipt application to meet different countries’ and business legislatives. The Create and Edit Payment Terms pages contain a new field called Discount Basis Date. This field determines what date to use as the basis for calculating discounts on transactions: receipt date, receipt application date, or deposit date. ELECTRONIC DELIVERY OF CUSTOMER INVOICES Generate and transfer invoices in XML format to your buyers through Oracle B2B gateway. Formats conforming to the Open Applications Group standard are seeded for standard invoice, credit memo, debit memo, and chargeback document types. Oracle B2B gateway can be configured to communicate directly with a buyers system, or through Oracle Supplier Network, or a third party electronic document broker. PRINT RECEIVABLES IN DIFFERENT FORMATS Printing and delivery of Receivables transactions is now supported with new output file types available from the Print Receivables Transactions process: HTML, Excel, PDF, and Zipped PDFs depending on local country or business needs. The Zipped PDFs can include an XML index file for faster sorting of the PDF files.

20

SUBLEDGER ACCOUNTING EXPANDED SUBLEDGER JOURNAL ENTRY DESCRIPTION Configure your journal entries descriptions in accordance with your local rules. Subledger Accounting now provides expanded descriptions for subledger journal entries. Expanded descriptions include transaction references (such as transaction numbers), source, and type. SUBLEDGER ACCOUNTING REPORTS Use Fusion Subledger Accounting reports for account analysis, daily journals, and third-party reporting and to meet local reporting requirements. The following predefined formats and templates are enabled for user adjustments using Oracle Business Intelligence Publisher: •

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

21



General Ledger and Subledger Accounting by Journal Lines Report The report lists account balances or selected segment balances with subledger journal details including entered amounts, third party name, journal source, journal category and reporting and accounting sequences. Total number of debit and credit documents is listed.



Third Party Balances Summary Report The report displays information for each account of the third party and third-party site, and account identification. This report can be used as a tool for auditing third-party accounts.

22



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

23



Third Party Detail and Balances Report The report provides third party account balances and accounting activity details for the requested accounting period range. You can review the accounting process details by third party and audit third-party accounts in detail.

24



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

25



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

26



Third Party Account Balance Report The report prints account and original third-party transactions impacting the account during a particular period of time. The report is run to ensure that subledger and general ledger balances reconcile, and to identify possible reasons for any discrepancies.

27



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

28

TAX EUROPEAN COMMUNITY SALES LISTING REPORT European Sales Listing supports declaration of goods and services delivered within the European Union (EU) to VAT-registered customers in other EU member states. It can be used to display the Intra EU service, goods, or triangulation transactions in EU member states other than your own. For these transactions to appear jointly or in separate European Sales Listing reports, you must specify the Intra EU tax reporting code associated with the Intra EU transactions for goods or services as a selection parameter for the report. Report remains generic for official goods and services reporting, however we have introduced the enhanced version of the report with additional, country specific information on Intra-EU transactions for services including declaration progression number, Service Code, Service Mode, Receipt Method, rectification information in “European Sales Listing of services for Italy” and “European Purchase Listing of services for Italy” (see listed below).

29

INTERIM TAX REGISTER Report lists detail and summary information about interim (deferred) tax on transactions entered in Oracle Fusion Receivables and Oracle Fusion Payables. For example, the report can be used as supplemental information for Output VAT Journal and Input VAT Journal for declaration preparation in Spain MANUAL AND EXTERNAL TAX TRANSACTIONS IN THE TAX REPOSITORY Reduce integration costs and duplication efforts by integrating external, taxable transactions with Oracle Fusion Tax. Customers who have disparate legacy systems can leverage Oracle Fusion Tax’s open gateway and central tax repository to import taxable transactions, optionally calculate tax, create accounting, and centrally report on tax transactions. Benefit from the spreadsheet-based taxable journal entry to enter simple to complex taxable transactions, whether you only use Oracle Fusion Applications or use disparate applications. This allows you to enter ad hoc taxable transactions, miscellaneous adjustments, and direct tax adjustments outside the normal payables or receivables business flows. By leveraging Oracle Fusion Tax’s central tax repository, you can set up taxes once and deploy them across legal entities for both internal and external applications This functionality facilitates compliance for taxable transactions that are entered manually via journal entries, for certain type of taxes in various countries.

30

SELECT AND FINALIZE TRANSACTIONS FOR TAX REPORTING The tax selection and final reporting processes provide a single solution to meet country specific tax reporting and VAT declaration requirements. Tax reporting is based on the tax registration number and driven by the reporting identifier. Use Select Transactions for Tax Reporting process to run tax reports in a preliminary mode, review transactions selected for reporting and make corrections before submitting tax reports to the tax authority. Generate preliminary versions of tax reports in open tax periods and verify and correct tax details before finalizing the reports. The Finalize Transactions for Tax Reporting process allows you to control which transactions cannot be changed, once the reports are filed with the tax authorities. Once you generate the final reports, the tax period is closed to prevent updates or duplicate reporting. You report any updates as adjustments in subsequent periods. TAX BOX ALLOCATION AND REPORTING Enable periodic or annual reporting of tax activities in different country-specific report formats by configuring tax boxes for each country declaration in Oracle Fusion Tax. Generate reports with taxable and tax amounts in tax boxes defined using the tax box allocation rules. Oracle Fusion Tax also supports VAT declarations preparation using Tax Allocation Process, Tax Box Return Preparation Report, Tax Allocation Exceptions Report and Tax Allocations Listing Report to apply country specific formatting using Oracle Business Intelligence Publisher.

31

TAX CALENDAR Tax calendar allows you to meet country specific reporting requirements, for example, determine monthly or quarterly reporting for your tax reporting entity. The functionality helps you control the transactions so they are not reported more than once in the same tax period. TAX POINT DATE Oracle Fusion Tax supports tax reporting and declarations of your tax liability or recoverability at different tax points. You can report taxes for invoices on invoice date, payment date, invoice accounting date, or goods delivery date. This allows you to comply with specific tax regulations and properly report and declare on taxes calculated for purchases and sales transactions.

32

TAX RECONCILIATION AND AUDIT REPORTS Oracle Fusion Tax supports tax reconciliation reports and audit reports when you are preparing or auditing your tax returns. Tax reconciliation reports reflect the tax determined on transactions and are used to verify taxes applied on transactions. These reports support period end and close processes of reconciling taxes on transactions with accounted transactions: The following generic reports are available as Oracle Business Intelligence Publisher reports and can be modified easily by end users if required: •

Tax Audit Trail Report. Identifies detail tax and invoice information created and posted in Oracle Fusion Payables, and the total amounts for each tax rate code in entered currency and ledger currency. Two report layouts are available: Invoice and Tax Code.



Tax Reconciliation By Taxable Account Report Lists taxable transaction information created in Oracle Fusion Payables, Oracle Fusion Receivables, and Oracle Fusion Tax (Tax Repository). Generates subtotals by tax account and tax rate code. Includes flexfield filter parameter based on the account. 33

34



Tax Reconciliation Report The report lists the taxable and tax amounts, by tax account, for all Oracle Fusion Receivables transactions for a given period. It generates subtotals by document class and tax account. The reported data can be printed in summary or detail format.

35



Payables Tax Reconciliation with General Ledger Report The report supports Payables tax transactions reconciliation with the tax account balance in General Ledger. Such reconciliation is a common business requirement and also a legal requirement for companies with tax reporting obligations in countries such as Austria, Germany and Switzerland. Transactions can be listed by Ledger or Legal Entity and account code combinations.

36



Tax Register Report Identifies total tax amounts by tax type, tax class, and company from transactions created in Oracle Fusion Receivables. The report includes deferred tax accounting information and all transactions for which tax accounting is defined. Report data is grouped by tax registers: tax register and non-recoverable tax register. The reported data is ordered by transaction number, customer name, or customer account number. Data can be printed in detail or summary format.

37



Financial Tax Register Report Prints tax and accounting information created from transactions entered in Oracle Fusion Receivables, Oracle Fusion Payables, and Oracle Fusion Tax (Tax Repository). The report lists input, output tax data, or both input and output tax data. The data is grouped into registers: tax register and non-recoverable tax register.

38



Interim Tax Register Report The report identifies detailed and summary information of unpaid or partially paid receivables transactions that have a tax liability created on the payment date. The report prints customer details, transaction tax-related details, and the tax totals by tax rate code.

TAX REGISTRATION VALIDATION Oracle Fusion Tax provides the latest registration validations for most countries to automatically validate the registration numbers provided by your suppliers and customers when they are registered in the system.

39

TRANSACTION TAX CONFIGURATION Oracle Fusion Tax enables you to define tax content offline, using spreadsheet templates that are designed to simplify data entry, use common tax terminology and provide you relevant functional context that enables rapid implementation tax configuration. These spreadsheet templates can be accessed directly from the Define Transaction Taxes for Rapid Implementation task list. Completed spreadsheets can be uploaded using the actions provided within the setup tasks, which automates creation of relevant country specific tax configuration. TURNOVER REPORTING SELECTION AND DECLARATION Turnover reporting process extracts Oracle Fusion Payables and Oracle Fusion Receivables transactions selected for country specific turnover reports like European Sales Listing of Services for Italy or European Purchase Listing of Services for Italy or Spanish reports, where deferred VAT must be declared. In addition to generic information, the Turnover Reporting Selection Process extracts additional information including: unique declaration identification, Service Code and Mode, Payment/Receipt details, Declaration Authority, Year, Period, and Declaration Number. Turnover Declaration Closure Process records the details of declaration required for final submission to the tax authorities. WITHHOLDING TAX Comply with global withholding tax regulations with the flexibility to configure your rules, regardless of how simple or complex they are. Use the rules-based configuration to automatically meet exceptionsbased scenarios enforced by federal and local tax authorities. With this enhanced solution, you can minimize implementation and maintenance efforts because the relevant legal entities can now share tax withholding configurations by subscribing to them. You can also maintain period-based thresholds and rate schedules for your legal entities. YEARLY TAX REPORT Yearly Tax Extract and Report uses the Oracle Fusion Tax Reporting Ledger to gather and report all active transactions from the subledgers and tax entry repository. Finalize Transactions for Tax Reporting process stamps transactions as final and closes the tax calendar periods, thus the tax calendar period cannot be reopened. If a tax calendar period is not closed, the report can still be run; although it will return a warning message stating the information may be inaccurate due to an open tax period. The report groups tax activity according to four tax categories: Declarable Output Tax, Declarable Input Tax, Manual Tax Entries, and Tax Exemption.

40

41

LOCALIZATIONS FOR THE AMERICAS LOCALIZATIONS FOR CANADA CAPITAL COST ALLOWANCE CALCULATIONS FOR CANADA Comply with the Capital Cost Allowance under the Canadian Income Tax Act to claim depreciation on assets that are expected to be used for several years, such as buildings, plant and equipment, or machinery, as well as additions and improvements to such assets. You can group fixed assets into classes, associate enhanced depreciation methods and reduction rates to classes, and report on the depreciation claims.

42

LOCALIZATIONS FOR MEXICO ELECTRONIC ACCOUNTING REPORTS FOR MEXICO Companies in Mexico must submit periodically or at Tax Authority (SAT) request accounting information uploading XML files to the SAT internet portal through a registered e-mail account. Oracle ERP Cloud provides specific reports and generic reporting capabilities like Oracle Hyperion Financial Reporting Studio and Oracle Fusion Transaction Business Intelligence to create the following reports. • Chart or Accounts Report for Mexico. • Trial Balance Report for Mexico. • Journals Report for Mexico • Auxiliary Report for Mexico Journal Report XML output example.

ELECTRONIC INVOICE INTEGRATION WITH PAC FOR MEXICO Companies operating in Mexico are required to integrate with Mexican Tax Authority (SAT) through a certified e-billing company (PAC) for real-time issuance and approval of electronic invoices. This CFDI (Comprobante Fiscal Digital) or Electronic Invoice confirms the performance of a business transaction in accordance with SAT rules and need to be generated, transmitted and protected by electronic means. Oracle ERP Cloud provides integrated way to generate the electronic invoices and update the CFDI number on Invoices post validation and filling by PAC. The process involves 43

• • • •

Invoice Processing. Data Extraction: PAC can extract the invoice data using Out-Bound Integration Services to generate the SAT compliance xml. PAC Processing: The CFDI compliance solution (from PAC) receives the outbound extract and performs fiscal validation, signature and approval. ERP Cloud Update: PAC can invoke Web Services to stamp UUID to receivables Invoices.

44

LOCALIZATIONS FOR ASIA LOCALIZATIONS FOR CHINA CASH FLOW STATEMENT (CNAO STANDARD) CNAO standard requires the export of Cash Flow Statement related data in XML format. This includes details of cash inflows and outflows for a specific period, enabling a company to report overall cash flows, validate intercompany transactions, and forecast future cash needs. Companies are then free to produce a company specific Cash Flow Statement using the direct method based on the cash related information from Oracle Fusion General Ledger, Oracle Fusion Payments, Oracle Fusion Receivables and Oracle Fusion Financials Common Module. FINANCIAL DATA EXPORT FOR ENTERPRISE State Owned Enterprises in China have to provide accounting audit filing information to the China National Audit Office (CNAO) by following the China Financial Information Technology - Data Interface of Accounting Software Standard (GB/T 24589-2010) for enterprise. Export Financial Data, Project, Settlement Method, Department and Employee records in XML files which comply with CNAO standards, using the Export Shared Information for China: Enterprise Process. These files retrieve data from Oracle Fusion General Ledger, Oracle Fusion Payables, Oracle Fusion Payments, Oracle Fusion Receivables, Oracle Fusion Assets, and Oracle Fusion Human Resources. You can also maintain two additional account value attributes for the natural account segment: Balance Side for China and CashRelated Account for China. Simply utilize the Create Enterprise Additional Account Attributes for China process. GOLDEN TAX ADAPTOR Businesses operating in mainland China are required to use a government certified tax application, known as the Aisino Golden Tax system, to perform VAT calculation, VAT invoice generation, and statutory tax reporting. Golden Tax Adaptor provides a seamless integration between Oracle Fusion Receivables and the Golden Tax system, including mapping a single Golden Tax transaction to multiple VAT invoices. The Golden Tax Adaptor supports: •

Receivables invoices, debit memos and credit memos



Flexible transfer rules for selected Receivables transactions based on business needs



Defaulting of VAT invoice types to match Receivables transactions.

45

You can now use global descriptive flexfields (GDFs) at the Master Item level to maintain item model and tax denomination information for the classification of items on VAT invoices for China. The use of global descriptive flexfields provides a more simplified experience for Oracle Cloud users.

46

LOCALIZATIONS FOR KOREA VAT REPORTS FOR KOREA The following statutory reports are provided in Fusion Cloud Financials to meet your reporting requirements for VAT filing with Korean Tax Authority. • • • • • •

Tax Invoice Summary by Customer Tax Invoice Summary by Supplier Tax Summary by Customer Electronic Media Report Tax Summary by Supplier Electronic Media Report Exempt Tax Invoice by Customer Exempt Tax Invoice by Supplier

47

SUMMARY BILLING FOR KOREA In case several invoices need to be combined into a single Tax Invoice you can use the ‘Tax Invoice for Output Transactions’ report to print the required invoice format for the “Summary Billing”. A Tax Invoice is printed into two identical copies with different colors where the Red one is kept by supplier and the Blue one is sent to customer.

WITHHOLDING TAX REPORTS FOR KOREA The following reports in Fusion Cloud Financials enable you to comply with Korean Withholding Tax statutory reporting requirements (format pre-defined by authorities): • • • •

Resident Business Income Withholding Form for Korea Resident General Income Withholding Form for Korea Non-Resident General Income Withholding Form for Korea Resident Business Income Withholding Tape for Korea 48

• • •

Resident General Income Withholding Tape for Korea Non-Resident Business and General Income Tape for Korea Non-Resident Business and General Income Tape for Korea

For your convenience, you can also print out the ‘Withholding Tax Listing Report for Korea’ for review and checking, which provides all the necessary reference information for the statutory reports listed above.

49

LOCALIZATIONS FOR SINGAPORE INPUT TAX GAIN AND LOSS REPORT FOR SINGAPORE The Input Tax Gain/Loss Report for Singapore allows you to report to the Tax Authority, the GST paid to Suppliers, as well as track the gain/loss on foreign invoices due to the use of an exchange rate for corporate accounting which may be different from the one used by the Supplier entered in Oracle Fusion Payables. This report displays the Singapore Dollar tax information required for filing the GST Form 5, including the minority case where the functional (ledger) currency is not the Singapore Dollar tax currency. •

Input Tax Gain/Loss Report for common case where functional (ledger currency) is the Singapore Dollar.

OUTPUT TAX GAIN AND LOSS REPORT FOR SINGAPORE The Output Tax Gain/Loss Report for Singapore allows you to report to the Tax Authority, the GST billed to Customers, as well as track the gain/loss on foreign invoices due to the use of an exchange rate for corporate accounting which is different from the spot rate used to bill the Customer entered in Oracle Fusion Receivables. This report displays the Singapore Dollar tax information required for filing the GST Form 5, including the minority case where the functional (ledger) currency is not the Singapore Dollar tax currency.

50



Output Tax Gain/Loss Report for common case where functional (ledger currency) is the Singapore Dollar.

51

LOCALIZATIONS FOR EUROPE, MIDDLE EAST AND AFRICA LOCALIZATIONS FOR FRANCE AUDIT FILE FOR FRANCE All companies subject to tax in France and under audit by the French tax authorities have to produce audit documentation in a prescribed electronic format. The audit report output can be saved as a text, data or csv file. For easier review you can open the file in an excel spreadsheet.

DAS2 REPORTING FOR FRANCE The DAS2 is an annual fiscal declaration which must be completed by every legal entity in France having paid a sum to independent consultants and individual subcontractors that exceeds a certain limit. These third party payments include fees, commissions, and rebates. The DAS2 solution in Fusion includes: DAS2 Verification extract and execution report for France, DAS2 Type 210 Updates handling, DAS2 contractor letters report preparation and submission, DAS2 File extraction and DAS2 Extract File Incompatibility for France.

52

53

DEDUCTIBLE VAT DECLARATION REPORT FOR FRANCE Use the report to prepare your monthly VAT declaration in France. The Deductible VAT Declaration Report for France lists VAT based on an Invoice Tax Point Date and Payment Tax Point Date. Deferred

54

VAT is accounted to an interim account at the time of invoice. Final accounting (either to Collected VAT for Output Tax or Deductible VAT for Input Tax) is done at the time of payment.

INTERNATIONAL ELECTRONIC FILE TRANSFER FOR FRANCE French International payment format is standardized by French Bank Standard Association (CFONB 120). The 320 characters long flat file format also supports French domestic EFT and Electronic order formats through seeded “code operation”.

55

LOCALIZATIONS FOR GERMANY JOURNAL DETAILS REPORT FOR GERMANY Journal Detail Report for Germany supports verification that the journals are sequenced by posted date, as per the prevailing legal requirement. Use the report to support your Balance Sheet, Profit and Loss statements and accounting books verification during the auditing process in Germany, Austria and Switzerland.

Z4 REPORT FOR GERMANY Companies must submit statistical reports to Deutsche Bundesbank. The report details all payments through residents' accounts held with non-resident financial institutions as well as payments related to netting and clearing arrangements. The report lists incoming and outgoing payments above the statutory limit.

56

Z5A REPORT FOR GERMANY Companies must submit statistical reports to Deutsche Bundesbank. The report shows all open receivables and liabilities for goods and service trade with foreign non-banks. It is prepared on paper or electronically. The report lists the outstanding receivables and liabilities of foreign non-banks. Supported are “Z5A Reconciliation” and “Z5A Sheet2” reporting templates.

57

LOCALIZATIONS FOR ISRAEL WITHHOLDING TAX REPORT FOR ISRAEL Withholding Tax Report for Israel lists all withholding tax transactions during a given period. The report can be run in a detail or a summary level. In the detail level, all transactions with withholding tax are listed. In the summary level, only the total by supplier is listed and the supplier balance is also displayed. Reported information can be ordered by the supplier number or supplier taxpayer ID. The report totals summarize the listed amounts for gross amount and withholding bank amount.

58

WITHHOLDING TAX RECONCILIATION REPORT FOR ISRAEL The Withholding Tax Reconciliation Report for Israel prints all payments and related withholding tax transactions for suppliers and supplier sites in the selected reporting period.

WITHHOLDING TAX FILE TO TAX AUTHORITY FOR ISRAEL The Withholding Tax File to Tax Authority creates a text file in a predefined format for submission to the tax authorities in the so form 856. The file lists the withheld tax amounts for each supplier, supplier personal details and the total amounts on the transactions. The total amounts on the transaction include payments, withholding tax amounts, and liabilities.

59

WITHHOLDING TAX ANNUAL CERTIFICATE TO SUPPLIERS FOR ISRAEL The Withholding Tax Annual Certificate to Suppliers Report for Israel lists the annual summary of all supplier transactions with the entity issuing the certificate. It lists the withholding tax amounts and payments made to the supplier.

60

RECEIPT REPORT FOR ISRAEL The Receipt Report for Israel lists each receipt, the receipt details and the payer information. The original receipt is printed only once. After the first printing the receipt is printed as a copy. In case the receipt is in the form of a check, the account, bank, branch and check number information is listed. For bank transfers the account, bank, branch information is listed.

61

LOCALIZATIONS FOR ITALY DECLARABLE INPUT VAT REGISTER FOR ITALY Use Declarable Input VAT Register for Italy to audit recoverable input VAT amounts. The report lists the tax declarable activities including payments of the invoices with deferred tax, supplier details, recoverable and non-recoverable taxable and tax amounts grouped by tax rate code.

62

DECLARABLE OUTPUT VAT REGISTER FOR ITALY Use Declarable Output VAT Register for Italy to audit payable VAT amounts. The report lists the tax declarable activities including receipts of the invoices with deferred tax, adjustments, bills receivable, customer details and transaction tax-related details grouped by tax rate code.

63

EUROPEAN PURCHASES LISTING OF SERVICES FOR ITALY Use the European Purchases Listing for Italy to prepare declaration of Intra-EU purchase of services transactions. The report includes Italian specific declaration details like for Service Code, Service Mode, Payment Method and declaration rectification information. Declarations can be submitted on periodical basis using select transactions for turnover reporting and finalize transactions for tax reporting processes.

EUROPEAN SALES LISTING OF SERVICES FOR ITALY Use the European Sales Listing for Italy to prepare declaration of Intra-EU sales of services transactions. The report includes Italian specific declaration details like Service Code, Service Mode, Receipt Method and declaration rectification information. Declarations can be submitted on periodical basis using select transactions for turnover reporting and finalize transactions for tax reporting processes.

64

LETTER OF INTENT PROCESSING FOR ITALY Regular exporters in Italy (those who have a 10% or higher ratio between annual export and total sales transactions) have the option to exempt VAT on transactions by amount over a specific period from their suppliers. Suppliers trading with a customer, who is a regular exporter, can invoice without VAT up to certain limit. Letters of intent received from customers can be recorded, and assigned to sales invoices, where applicable. Subledger Letter of Intent Register for Italy can be user to list purchase or sales invoices with an assigned letter of intent. Functionality provided for Italy also includes: Exemption Letter Report for Italy, Italian Exemption Limit Declaration Report, Letter of Intent Receivables Invoice Register and Supplier Letter of Intent Limit Consumption Report.

65

PAYABLES SALES VAT REGISTER (SELF INVOICES, EEC, VAT) FOR ITALY Payable Sales VAT Register for Self-Invoices, Inter-EU Invoices and VAT for Italy supports periodic VAT reporting in Italy and is submitted to Italian Tax Authority on request. In accordance with law the report lists all Inter-EU invoices and self invoices accounted in the VAT reporting period irrespective of tax settlement (immediate/deferred) and payment status (invoices with the deferred tax are reported).

66

PURCHASE VAT REGISTER FOR ITALY Purchase VAT Register for Italy supports periodic VAT reporting in Italy and is submitted to Italian Tax Authority on request. The report lists in statutory format all purchase invoices accounted in the VAT reporting period irrespective of tax settlement (immediate/deferred) and its payments status (invoices with the deferred tax are reported independently on whether paid/no paid). The report displays the recoverable, non-recoverable and deferred tax amounts and corresponding taxable amounts. Reported invoices and credit memos include information on applicable letter of intent.

67

RECEIVABLES SALES VAT REGISTER FOR ITALY Use Receivables Sales VAT Register for Italy as the legal report when requested by Italian Tax Authority. The report lists all Sales Invoices accounted in the VAT reporting period irrespective of tax settlement status (immediate/deferred) and payments status (invoices with the deferred tax are reported. Reported invoices transactions include information on applicable letter of intent.

68

TRADING PARTNER DECLARATION FOR ITALY The Trading Partner Declaration for Italy generates an electronic file and a detailed audit report for a given reporting entity, declaration type, transmission type and reporting period. Trading Partner Declaration for Italy allows supports reporting of 3 declaration types required by Italian authorities i.e. Customer and Supplier Lists Declaration, Restricted Countries, Transactions List Declaration and The Republic of San Marino Purchases Declaration. The audit report is also available in electronic file format and Transmission Number and Document Protocol Numbers assigned by Italian Revenue Agency can be recorded and used to rerun the transmission in substitution or cancellation modes.

VAT LIQUIDATION REPORT FOR ITALY The report lists summary of VAT to be paid to tax authority as part of the VAT settlement process in Italy. Use VAT Liquidation Report for Italy to calculate and prepare your VAT declaration at the end of the tax period.

69

70

WITHHOLDING TAX LETTERS FOR ITALY Withholding Tax Letters are sent to suppliers in Italy to indicate the tax amounts withheld on purchase invoices that have been partially or fully paid within a calendar year. Letters can be printed for a specific supplier or for all suppliers that have tax withheld.

71

YEARLY WITHHOLDING TAX REPORT FOR ITALY Withholding Tax Yearly Report for Italy lists annual taxes withheld by first-party legal entities for a supplier during a specified year. The report is ordered by supplier name, supplier taxpayer ID, or supplier tax registration number.

72

LOCALIZATIONS FOR SPAIN MODELO 190 WITHHOLDING TAX DECLARATION FOR SPAIN Modelo 190 is an annual report required by Spanish Tax Authorities to report withholding amount and payments on account, of income from employment, economic activities, prizes, certain capital gains and income allocations. It is submitted to the Tax Authorities in January for the prior calendar year operations. The report identifies summary or detail of withholding tax information for Spain by invoice and withholding tax type and prints information for a selected legal entity, and optionally for specific supplier. Verify a draft report version using “Withholding Tax Report for Spain”. Then you can submit electronic version using “Withholding Magnetic Format for Spain”.

MODELO 340 INFORMATIVE DECLARATION OF TRANSACTIONS FOR SPAIN Modelo 340 is a declaration delivered by most corporations with business operations in Spain to Spanish Tax Office in an electronic form. It can be delivered monthly or quarterly. Use the report to list received and issued transactions including: domestic invoices, selected Inter-EU operations and IGIC transactions. Verify draft report version using “Modelo Verification Report for Spain” with “Modelo 340 Informative Declaration of Transactions Report for Spain” template. Then you can submit and electronic version of

73

“Modelo 340 Informative Declaration of Transactions Magnetic Format for Spain” using “Modelo Electronic File Generation for Spain” process.

MODELO 347 OPERATIONS WITH THIRD PARTIES DECLARATION FOR SPAIN Modelo 347 report is a legally required on a quarterly or annual basis from companies in Spain that do not submit Modelo 340. Use the report to list sales and purchase transactions of goods and services including domestic, certain Inter-EU and certain IGIC transactions. Verify draft report version using “Modelo Verification Report for Spain” with “Modelo 347 Operations with Third Parties Report for Spain” template. Then you can submit an electronic version of “Modelo 347 Operations with Third Parties Magnetic Format for Spain” using “Modelo Electronic File Generation for Spain” process. MODELO 349 INTER-EU OPERATIONS SUMMARY DECLARATION FOR SPAIN Modelo 349 declaration must be submitted monthly or quarterly. Declaration includes all Inter-EU purchases and sales operations summarized by supplier/customer and categories predefined by tax legislatives. For transactions related to corrections of previous declarations, are separately listed with the relevant customers, invoice amounts and the period and year of the correction. The report also marks transactions related to the triangulation operations and displays invoice totals for each customer/supplier. Verify draft report version using “Modelo Verification Report for Spain” with “Modelo 349 Inter-EU Purchases Operations Summary Report for Spain” or “Modelo 349 Inter-EU Sales Operations Summary Report for Spain” template. Then you can submit an electronic version of “Modelo 349 Inter-EU Operations Summary Magnetic Format for Spain” using “Modelo Electronic File Generation for Spain” functionality. 74

MODELO 415 CANARY ISLANDS ANNUAL OPERATIONS DECLARATION FOR SPAIN Modelo 415 Canary Islands Annual declaration is required by the Canary Island’s tax authorities by companies located on Canary Islands and operating in the IGIC (Impuesto General Indirecto Canario) tax regime when trading with third parties whose tax reporting site is in Spain and annual turnover exceeds a legally defined amount. Verify a draft report version using “Modelo Verification Report for Spain” with “Modelo 415 Purchase Canary Islands Annual Operations Report for Spain” or “Modelo 415 Canary Islands Annual Sales Operations Report for Spain” template. Then you can submit electronic version of “Modelo 415 Canary Islands Annual Operations Magnetic Format for Spain using “Modelo Electronic File Generation for Spain” process.

MODELO DATA EXTRACT FOR SPAIN Use the generic template to define own Modelo reports for internal control and audit purposes using Oracle Business Intelligence Publisher capabilities.

INPUT VAT JOURNAL FOR SPAIN The Input VAT Journal for Spain report (“Registro de IVA Soportado”) is required by the Spanish VAT legislation. Use the report to gather and list information about VAT that is charged on Payables invoices and expense reports. Input VAT Journal report for Spain displays invoices and expense reports that are accounted for with VAT amounts for the company with optional filtering by tax reporting code. Data is reported by register type: recoverable tax register and non- recoverable tax register. The transactions can be selected based on tax reporting type and tax reporting code.

75

OUTPUT VAT JOURNAL FOR SPAIN The Output VAT Journal for Spain report (“Registro de IVA Repercutido) is required by Spanish tax authorities and VAT legislation. Use the report to gather and report information on declarable tax on Receivables transactions. The Output VAT Journal for Spain report has two sections: detailed, ordered by invoice accounting date and invoice number, with totals at the end of the section; and summary by tax, with totals at the end of the report. Use Interim Tax Register report to print detail and summary information about interim (deferred) tax on Receivables transactions.

VAT INTER-EU INVOICE JOURNAL FOR SPAIN Report lists detail and summary information on taxable invoices entered and posted in Oracle Fusion Payables with offset / reverse charge tax distributions. These invoices normally are Inter-EU invoices that you receive from suppliers in other countries within the European Union. The VAT Inter-EU Invoices Journal for Spain report displays the information that would be normally displayed on the Output VAT Journal for Spain if you created the corresponding self invoices in Oracle Fusion Receivables. 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 Output VAT Journal for Spain report that you send to tax authorities.

76

VAT INTER-EU INVOICE FORMAT FOR SPAIN Use the VAT Inter-EU Invoice Format for Spain (Documento Equivalente) to print a self invoice to justify the inclusion of Inter-EU goods purchase invoices on both the Input VAT Journal for Spain and the Output VAT Journal for Spain.

77

LOCALIZATIONS FOR UK REVERSE CHARGE SALES LIST REPORT FOR UK Reverse Charge Sales Listing for UK provides transaction and tax details on the sale of high-value electronic goods requested by HM Revenue & Customs (HMRC) in UK. Report can be run in preliminary mode for a specific tax period. When the transactions are finalized, the report is run in final mode for submission to HMRC. Only invoices with additional legal text that fall within the HMRC legislation are reported.

78

Copyright © 2016, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only, and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

79