16Oracle Fusion Financials for EMEA Reports

This chapter contains the following:

Oracle Fusion Financials for EMEA Predefined Reports

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

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

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

  1. Click the Schedule New Process button.

  2. Search on the Process Name.

  3. Enter the appropriate parameters.

  4. Enter the appropriate process options and schedule.

  5. Click Submit.

You can generate predefined reports for:

  • European Union

  • France

  • Germany

  • Israel

  • Italy

  • Spain

  • Turkey

  • United Kingdom

Reports for the European Union and United Kingdom

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

Display Name Description

Sales Listing Report for European Union

Declares the information related to products and services that are rendered within the European Union to VAT registered customers in other European Union member states.

Reverse Charge Sales List Report for UK

Lists the UK sales transactions that are created in Oracle Fusion Receivables. It lists transactions for high value electronic goods that are subjected to the Reverse Tax Charge and reported to HRMC (Her Majesties Revenue and Customs). The reported data is grouped by the customers.

Reports for France

The tax reports for France are:

Display Name Description

DAS2 Contractor Letters for France

Generates letters to all contractors in France whose income is reported in the DAS2 extract file for the current year. This lists income tax amounts from Oracle Fusion Payables grouped by income tax type for France.

DAS2 Extract File for France

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

DAS2 Type 210 Updates Report for France

Generates a list of all changes to data related to DAS2 reporting for France. This also lists all the changes that are made since the last run of the verification report.

DAS2 Verification Report for France

Generates DAS2 information for contractors in France and related income tax information from data entered in Oracle Fusion Payables. The report extracts information into the DAS2 temporary tables and automatically submits the DAS2 Verification Extract Execution Report for France.

Deductible VAT Declaration Report for France

Lists the deductible VAT amount and totals of invoices for France that are entered in Oracle Fusion Payables. The VAT deductibility rule, tax rate, and account number are used to group the reported data.

Audit Report for France

Creates the electronic audit file that's required to be submitted to tax authorities in France. You can create the electronic file in HTML format, and as an excel spreadsheet for data verification.

Reports for Germany

The subledger and accounting reports for Germany are:

Display Name Description

Z4 Report for Germany

Lists all incoming and outgoing payments made through a foreign bank for the selected ledger and date range. The report prints only the payments that are more than the legally defined threshold amount.

Z5A Report for Germany

Shows the sum of all outstanding receivables and liabilities of goods and services traded with foreign suppliers or customers. You can select the summarize option to print either the Z5A Reconciliation Report or the Z5A Sheet 2 Report.

Journal Details Report for Germany

Provides posted general ledger journal activity for a given period or date range. You can optionally include other criteria like journal category, ledger currency, and journal batch. You can group and sort the entries at report submission. Using this report you can print balances for actual, encumbrance, or budget balance type.

Reports for Israel

The tax reports for Israel are:

Display Name Description

Withholding Tax Report for Israel

Prints summary and details of withholding tax and income tax activities.

Withholding Tax Reconciliation Report for Israel

Prints all payments and related withholding tax transactions for suppliers and supplier sites for the selected reporting period.

Withholding Tax File for Tax Authority for Israel

Creates a text file in a predefined format for submission to the tax authorities, using the form 856. The file lists the withheld tax amounts for each supplier, supplier personal details, and the total amounts on the transactions including payments, withholding tax amounts, and liabilities.

Supplier Withholding Annual Certificate for Israel

Prints the annual summary of all supplier transactions with the entity issuing the certificate. It lists the withholding tax amounts and payments made to the supplier.

Receipt Report for Israel

Prints receipt details, taxpayer details, and payer details in a specific format.

Withholding Tax Summary Detail Report for Israel

Prints summary and details of withholding tax and income tax activities.

Reports for Italy

The tax reports for Italy are:

Display Name Description

Declarable Input VAT Register for Italy

Lists the tax declarable activities including payments of the invoices with deferred tax. The report lists supplier details and recoverable and nonrecoverable taxable and tax amounts grouped by tax rate code.

Declarable Output VAT Register for Italy

Lists the tax declarable activities including receipts of the invoices with deferred tax, adjustments, and bills receivables. The report prints customer details and transaction tax-related details grouped by tax rate code.

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

Identifies a sales VAT register for Italy for all invoices received from suppliers within the European Union or all self-billing invoices that have accounting dates within the period range being reported. The report displays recoverable and nonrecoverable elements of both tax and taxable amounts grouped by tax code.

Purchase VAT Register for Italy

Identifies all purchase invoices for Italy with document sequence numbers assigned to the selected VAT register name, and with accounting dates within the period range being reported. The report prints and groups invoices by tax rate code.

Receivables Sales VAT Register for Italy

Identifies all sales invoices for Italy assigned to the document sequence name of the selected VAT register name, and with accounting dates within the period range being reported. The report prints and groups invoices by tax rate code.

VAT Liquidation Report for Italy

Identifies a summary of the VAT amounts by tax code for each VAT type and VAT register for the selected period. It also includes the consumption per exemption limit group and the available limit at the beginning and end of the month. The transactional tax data are grouped by Declarable Output VAT Register and Declarable Input VAT Register.

European Purchase Listing of Services for Italy

Lists all Intra-EU payables transactions for services. The report prints invoice details specific to Italy such as service mode, service code, and protocol number.

European Sales Listing of Services for Italy

Lists all Intra-EU receivables transactions for services. The report prints invoice details specific to Italy such as service mode, service code, and protocol number.

Yearly Tax Report

Prints tax and taxable amount information for input and output taxes for all final reported tax periods within the year. The report can be printed in detail or summary format.

Yearly Withholding Tax Report for Italy

Shows annual taxes withheld by first-party legal entities, for the supplier for the year selected. The report data can be printed or grouped by supplier name, supplier taxpayer ID, or supplier tax registration number.

Withholding Tax Letters for Italy

Identifies letters sent to suppliers in Italy confirming tax amounts withheld on partially or fully paid purchase invoices within a calendar year. Letters can be printed for a specific supplier or for all suppliers that have tax withheld.

Exemption Letter Report for Italy

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

Subledger Letter of Intent Register for Italy

Lists all exemption letters issued to suppliers or received by customers in Italy within a given period range.

Letter of Intent Receivables Invoice Register

Lists details about Receivables transactions issued with a Letter of Intent for a given calendar year. Provides letter of intent details like protocol number, allocation type, amount and effective dates.

Supplier Exemption Limit Consumption Report for Italy

Lists the details of suppliers eligible for exemption in Italy and their monthly consumption of assigned exemption limit. Lists consumption details of all the suppliers, or a specific supplier. Details include all invoices exempted during a calendar period.

Letter of Intent Report for Italy

Produces a letter of intent for each exempt supplier in Italy instructing them not to include VAT on invoices that they submit.

Reports for Spain

The tax reports for Spain are:

Display Name Description

Input VAT Journal for Spain

Identifies detail and summary information about tax on invoices and expense reports for Spain entered in Oracle Fusion Payables. Data is reported by register type: recoverable tax register and nonrecoverable tax register. The transactions can be selected based on tax reporting type and tax reporting code.

Output VAT Journal for Spain

Identifies detail and summary information entered in Oracle Fusion Receivables about tax on transactions created for Spain. Data is reported by register type: tax register and nonrecoverable tax register. The transactions can be selected based on tax reporting type and tax reporting code.

VAT Inter-EU Invoice Journal for Spain

Identifies detail and summary information about invoices received in Spain from suppliers located in any European Union member state. Invoices are entered and posted in Oracle Fusion Payables, and have offset or self-assessed tax distributions. The transactions can be selected based on tax reporting type and tax reporting code.

VAT Inter-EU Invoice Format for Spain

Lists details of the same invoices that appear on the Spanish VAT Inter-EU Invoices Journal report. The transactions can be selected based on tax reporting type and tax reporting code.

Modelo Electronic File Generation for Spain

Prepares electronic file for Modelo 340, 347, 349, or 415 declarations in a legally predefined format.

Modelo Verification Report for Spain

Lists all payables invoices and receivables transactions that are reported in the Modelo 340, 347, 349, or 415 declarations. The report prints data based on the selected legal entity, period range, source, and Modelo name. For receivables cash receipts, only receipts that are of a greater value than the entered minimum cash amount are reported.

Withholding Tax Report for Spain

Identifies summary or detail withholding tax information for Spain by invoice and withholding tax code. The report prints information for a selected legal entity, and optionally for specific supplier.

Withholding Tax Magnetic Format for Spain

Lists withholding tax transactions for the selected legal entity and tax year in a flat file format in the predefined layout.

Withholding Tax Extract Report for Spain

Extracts withholding tax transactions for Spain and stores them in an interface table to be used to report withholding tax transactions. The report selects information for a specific legal entity, and optionally for a specific supplier.

Report for Turkey

The tax report for Turkey is:

Display Name Description

Process Exchange Rate Difference Report for Turkey

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

General Ledger and Subledger Accounting Reports for EMEA

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

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

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

  1. Click the Schedule New Process button.

  2. Search on the Process Name.

  3. Enter the desired parameters.

  4. Enter the desired process options and schedule.

  5. Click Submit.

General Ledger Reports

The following table lists the General Ledger reports:

Display Name Description

General Ledger Trial Balance Report

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

General Ledger Journal Entry Report

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

General Ledger Journal and Balance Report

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

Subledger Accounting Reports

The following table lists the Subledger Accounting reports:

Display Name Description

Third-Party Detail and Balances Report

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

Third-Party Account Balance Report

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

Third-Party Balances Summary Report

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

Journals and Third-Party Report

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

General Ledger and Subledger Accounting by Journal Lines Report

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

Account Analysis by Legal Entity Report

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

General Ledger and Subledger Account Analysis Report

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

Daily Journals Report

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

Subledger Detail Journal Report

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

Journal Ledger Report

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

Reports for the European Union

Sales Listing Report for European Union

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

Overview

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

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

Sales Listing Report for the European Union

Key Insights

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

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

Report Parameters

This table describes the selected report parameters:

Parameter Name Description

Trader VAT Number

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

Country of the Tax Registration Number

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

Include Prior Period Adjustments and Credit Memos

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

Rounding Rule

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

Minimum Reportable Amount

Enter the smallest unit used for the ledger currency amounts.

Tax Reporting Type Code

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

Tax Reporting Code for Intra-EU Goods

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

Tax Reporting Code for Intra-EU Services

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

Additional Tax Reporting Code 1

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

Additional Tax Reporting Code 2

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

Frequently Asked Questions

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

FAQ Answer

How do I find this report?

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

Who uses this report?

  • Tax Manager

  • Tax Accountant

When do I use this report?

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

What type of reports are these?

Oracle Business Intelligence Publisher

Reports for France

This topic includes details about the DAS2 reports for France.

Overview

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

The DAS2 reporting includes:

  • DAS2 Contractor Letters for France: Generates letters to all contractors in France whose income is reported in the DAS2 extract file for the current year. Lists income tax amounts from Oracle Fusion Payables grouped by income tax type for France.

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

    DAS2 Contractor Letters for France
  • DAS2 Extract File for France: Generates the DAS2 electronic file for France that is submitted to the tax authorities in a predefined format.

  • DAS2 Type 210 Updates Report for France: Generates a list of all changes to data related to DAS2 reporting for France that are made since the last run of the verification report.

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

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

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

    DAS2 Verification Report for France

Key Insights

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

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

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

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

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

Report Parameter

The following table describes selected DAS2 report parameters:

Parameter Description

Legal Entity

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

Supplier

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

Year

Specify the year in which the payment is made.

Tax for Salaries

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

Frequently Asked Questions

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

FAQ Answer

How do I find this report?

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

Who uses this report?

  • Tax Manager

  • Tax Accountant

When do I use this report?

Use the DAS2 reports to:

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

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

    • Payments

    • Information reported to tax authorities

What type of reports are these?

Oracle Business Intelligence Publisher

Deductible VAT Declaration Report for France

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

Overview

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

The following figure is an example of the report.

Deductible VAT Declaration Report for France

Key Insights

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

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

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

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

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

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

Report Parameters

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

Parameters Description

Reporting Level

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

Reporting Context

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

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

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

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

Tax Registration Number

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

From Tax Point Date and To Tax Point Date

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

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

Frequently Asked Questions

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

FAQ Answer

How do I find this report?

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

Who uses this report?

  • Tax Manager

  • Tax Accountant

When do I use this report?

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

What type of reports are these?

Oracle Business Intelligence Publisher

Audit Report for France

This topic includes details about the Audit Report for France.

Overview

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

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

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

Key Insights

Before running the report, ensure that you have:

  • Set up the following entities:

    • Data security

    • Enterprise structure

    • Document sequences, if applicable

  • Completed the implementation project for your organization

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

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

Report Parameters

This table describes selected report parameters:

Name Description

Journal Entry Source

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

Ledger

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

Legal Entity

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

Show adjustment periods

Indicate whether to create the report by adjustment period.

From and To Accounting Period

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

Account filter

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

Document Sequence Name

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

Posting status

Select the posting status to view:

  • Only posted journals

  • Journals that are transferred, but not yet posted

Frequently Asked Questions

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

FAQ Answer

How do I find this report?

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

Who uses this report?

General Ledger users.

When do I use this report?

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

What type of report is this?

Oracle Business Intelligence Publisher.

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

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

How can I review the audit reports for France?

You can review the audit reports in an excel sheet.

Reports for Germany

Reports for Germany

This topic includes details about the reports for Germany.

Overview

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

The reports for Germany include:

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

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

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

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

This image displays the Z4 Report for Germany.

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

This image displays the Z5A Reconciliation Report
for Germany.

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

This image displays the Z5A Sheet 2 Report for Germany.

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

This image displays the Journal Details Report
for Germany.

Key Insights

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

  • For Payables:

    • Record type

    • Payment reason

  • For Receivables:

    • Record type

    • Reason

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

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

Report Parameters

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

Name Description

Ledger

Specify the ledger for reporting.

Threshold

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

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

Name Description

Ledger

Specify the ledger for reporting.

Summarize

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

Party Name

Indicate a supplier or customer to reconcile specific payments.

Threshold Amount

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

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

Name Description

Ledger

Specify the ledger for reporting.

Filter Conditions Defined

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

Document Sequence Number

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

From/To Document Number

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

First Page Number

Specify the starting page number for the report.

Frequently Asked Questions

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

FAQ Answer

How do I find these reports?

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

Who uses these reports?

  • General Accounting Manager

  • Payables Manager

  • Receivables Manager

  • Financial Analyst

When do I use these reports?

Use these reports to:

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

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

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

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

  • Print journals that have posting errors.

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

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

What type of reports are these?

Oracle Business Intelligence Publisher

Reporting Features for Germany

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

The following table lists the reports that support these requirements:

Report Name Description

Z4 Report for Germany

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

  • Received from nonresidents

  • Received from residents for the account of nonresidents

  • Made to nonresidents from residents

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

Z5A Report for Germany

Provides the following reporting options:

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

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

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

Journal Details Report for Germany

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

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

Use the report to:

  • Verify that the journals are sequenced by posted date.

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

  • Verify accounting books during audits.

Reports for Israel

Withholding Tax Reports for Israel

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

Overview

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

The following reports support withholding tax for Israel:

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

  • Withholding Tax Reconciliation Report for Israel: Prints all payments and related withholding tax transactions for suppliers and supplier sites for the selected reporting period.

  • Withholding Tax File to Tax Authority for Israel: Creates a text file in a predefined format, called form 856, for submission to the tax authorities. The file lists the withheld tax amounts for each supplier, supplier personal details, and the total amounts on the transactions including payments, withholding tax amounts, and liabilities.

  • Withholding Tax Annual Certificate to Suppliers for Israel: Prints the annual summary of all supplier transactions with the entity issuing the certificate. It lists the withholding tax amounts and payments made to the supplier. The report contains the following details:

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

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

    • Else, the credit card information is listed.

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

Key Insights

Before running the reports, ensure that you:

  • Set up the following entities:

    • Data Security

    • Geographies

    • Enterprise Structure

    • Suppliers

    • Bank accounts

    • Procurement Business Function

    • Common Options for Payables

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

Report Parameters

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

Name Description

From and To Document Number

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

Ledger

Specify the ledger for reporting.

Legal Entity

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

Reporting Level

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

Frequently Asked Questions

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

FAQ Answer

How do I find these reports?

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

Who uses these reports?

  • Tax Manager

  • Tax Accountant

What type of reports are these?

Oracle Business Intelligence Publisher

Reporting Features for Israel

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

This table lists the withholding reports for Israel.

Withholding Tax Reports

Report Name Description

Withholding Tax Report for Israel

Prints summary and details of withholding tax and income tax activities.

Withholding Tax Reconciliation Report for Israel

Prints all payments and related withholding tax transactions for suppliers and supplier sites for the selected reporting period.

Withholding Tax File to Tax Authority for Israel

Creates a text file in a predefined format for submission to the tax authorities, that's, form 856. The file lists the withheld tax amounts for each supplier, supplier personal details, and the total amounts on the transactions including payments, withholding tax amounts, and liabilities.

Withholding Tax Annual Certificate to Suppliers for Israel

Prints the annual summary of all supplier transactions with the entity issuing the certificate. It lists the withholding tax amounts and payments made to the supplier.

Receipt Report for Israel

Prints receipt details, taxpayer details, and payer details in a specific format.

Reports for Italy

VAT Reports for Italy

This topic includes details about the VAT reports for Italy.

Overview

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

The VAT reports for Italy include:

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

    The following figure is an example of the report.

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

    The following figure is an example of the report.

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

    The following figure is an example of the report.

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

    The following figure is an example of the report.

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

    The following figure is an example of the report.

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

    The following figure is an example of the report.

    VAT Liquidation Report for Italy

Key Insights

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

  • Set up tax reporting entities and tax registers

  • Configure tax reporting type and tax reporting type codes

  • Associate document sequence names with tax registers

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

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

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

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

Report Name Accounting Date Tax Point Date

Declarable Input VAT Register for Italy

No

Yes

Declarable Output VAT Register for Italy

No

Yes

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

Yes

No

Purchase VAT Register for Italy

Yes

No

Receivables Sales VAT Register for Italy

Yes

No

VAT Liquidation Report for Italy

No

Yes

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

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

  • Declarable Input VAT Register for Italy

  • Declarable Output VAT Register for Italy

  • VAT Liquidation Report for Italy

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

Report Parameters

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

Parameters Description

Tax Calendar Period

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

Tax Register

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

First Page Number

Indicate the starting page for the report.

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

Parameters Description

Variation on Sales

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

Variation on Purchase

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

Frequently Asked Questions

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

FAQ Answer

How do I find this report?

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

Who uses this report?

  • Tax Manager

  • Tax Accountant

When do I use this report?

Use VAT reports for Italy to review:

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

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

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

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

What type of reports are these?

Oracle Business Intelligence Publisher

Intra-EU Reports for Italy

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

Overview

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

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

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

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

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

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

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

    European Purchase Listing of Services for Italy

Key Insights

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

  • Display report level totals for invoice amount.

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

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

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

  • In Oracle Fusion Functional Setup Manager, use the:

    • JG_ESL_EPL_SERVICE_CODE lookup type to specify the service code.

    • JG_ESL_EPL_SERVICE_MODE lookup type to specify the service mode.

    • JG_ESL_EPL_RCPT_PYMT_MODE lookup type to specify the reporting payment method.

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

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

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

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

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

Report Parameters

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

Parameter Description

Tax Registration Number

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

Tax Reporting Type

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

Tax Reporting Code

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

Frequently Asked Questions

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

FAQ Answer

How do I find this report?

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

Who uses this report?

  • Tax Manager

  • Tax Accountant

When do I use this report?

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

  • Meet the reporting requirements of the Italian tax authorities.

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

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

What type of reports are these?

Oracle Business Intelligence Publisher

This topic includes details about the exemptions reports for Italy.

Overview

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

  • Instructions to invoice without VAT.

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

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

The following reports support exemption handling for Italy:

  • Exemption Letter Report for Italy: Produces a letter of intent for each exempt supplier in Italy instructing them not to include VAT on invoices that they submit.

    The following figure is an example of the report.

    Exemption Letter Report for Italy
  • Letter of Intent Receivables Invoice Register: Lists details about receivables transactions issued with a Letter of Intent for a given calendar year. Provides letter of intent details such as protocol number, allocation type, amount, and effective dates.

    The following figure is an example of the report.

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

    The following figure is an example of the report.

    Subledger Letter of Intent Register for Italy
  • Supplier Exemption Limit Consumption Report: Lists the details of suppliers eligible for exemption in Italy and their monthly consumption of assigned exemption limit. Lists consumption details of all the suppliers, or a specific supplier. Details include all invoices exempted during a calendar period.

Key Insights

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

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

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

Report Parameters

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

Parameter Description

Tax Reporting Type Code

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

Tax Reporting Code

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

From Period and To Period

Indicate the period range for the report data.

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

Parameter Description

Calendar Year

Indicate the year for the report data.

From Customer and To Customer

Indicate the customer range for the report data.

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

Parameter Description

Calendar Year

Indicate the year for the report data.

Month

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

From Supplier and To Supplier

Indicate the supplier range for the report data.

Invoices with Letter of Intent

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

Frequently Asked Questions

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

FAQ Answer

How do I find this report?

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

Who uses this report?

  • Tax Manager

  • Tax Accountant

  • Tax Specialist

  • Accounts Receivables Manager

  • Accounts Receivables Specialist

  • Accounts Payables Manager

  • Accounts Payables Specialist

When do I use this report?

Use the exemption reports for Italy to:

  • Specify VAT exemption limit on transactions

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

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

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

  • Review the monthly consumption of assigned exemption limit.

What type of reports are these?

Oracle Business Intelligence Publisher

Withholding Tax Reports for Italy

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

Overview

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

The following reports support withholding tax handling for Italy:

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

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

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

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

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

This image displays the Withholding Tax Letters for
Italy report.

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

This image displays the Yearly Withholding Tax
Report for Italy.

Key Insights

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

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

Report Parameters

The following table describes selected process parameters:

Name Description

Legal Entity

Specify the legal entity for reporting.

Year

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

Frequently Asked Questions

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

FAQ Answer

How do I find these reports?

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

Who uses these reports?

  • Tax Manager

  • Tax Accountant

  • Payables Manager

  • Payables Specialist

When do I use these reports?

Use these reports to:

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

  • Reconcile the withholding tax letters sent to your suppliers.

  • Review withheld taxes for each invoice or supplier.

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

What type of reports are these?

Oracle Business Intelligence Publisher

Report for Poland

How You Print Commercial Documents Execution Report

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

Overview

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

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

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

Key Insights

Before running the reports, ensure that you:

  • Set up the following entities:

    • Data Security

    • Geographies

    • Address Style Format

    • Enterprise Structures

    • Tax Regimes to Rate Flow

    • Tax Profiles for Parties

    • Tax Rules

    • Customers and Suppliers

    • First Party Bank, Branch, and Account

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

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

The image describes the Print Commercial Documents
Execution Report.

Report Parameters

This table describes the process parameters:

Parameter Description

Legal Entity

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

Tax Registration Number

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

Business Unit

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

Start Date

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

End Date

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

Third Party Type

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

Third Party

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

Third Party Site

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

Print Mode

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

Document Type

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

Start Document Number

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

End Document Number

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

Print Currency

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

Print Template

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

Order By

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

Frequently Asked Questions

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

FAQ Answer

How do I find this report?

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

Who uses this report?

This report is used by:

  • Receivables Supervisor

  • Receivables Manager

When do I use this report?

Use the Print Commercial Documents Execution report to check:

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

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

  • The reason for transactions not getting printed.

What type of report is this?

Oracle Business Intelligence Publisher

Reports for Spain

VAT Reports for Spain

This topic includes details about the VAT reports for Spain.

Overview

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

The VAT reports for Spain include:

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

    The following figure is an example of the report.

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

    The following figure is an example of the report.

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

    The following figure is an example of the report.

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

    The following figure is an example of the report.

    VAT Inter-EU Invoice Format for Spain

Key Insights

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

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

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

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

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

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

Report Parameters

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

Parameter Description

From Tax Calendar Period and To Tax Calendar Period

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

Tax Reporting Type

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

Tax Reporting Code

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

Enable Reporting Sequence

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

Register Type

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

  • Input VAT Journal for Spain

  • Output VAT Journal for Spain

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

Start Invoice Sequence

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

Frequently Asked Questions

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

FAQ Answer

How do I find this report?

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

Who uses this report?

  • Tax Manager

  • Tax Accountant

When do I use this report?

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

  • Invoices and transactions entered in Payables and Receivables

  • Transactions that are manually entered in the tax repository

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

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

What type of reports are these?

Oracle Business Intelligence Publisher

Modelo Reports for Spain

This topic details about the tax box allocation reports.

Overview

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

The Modelo reports for Spain include the following :

  • Modelo Electronic File Generation for Spain: Prepares electronic file for Modelo 340, 347, 349 or 415 declarations in a legally predefined format.

  • Modelo Verification Report for Spain: Lists all payable invoices and receivables transactions that are reported in the Modelo 340, 347, 349, or 415 declarations. The report prints data based on the selected legal entity, period range, source, and modelo name. For receivables cash receipts, only receipts with a value more than the entered minimum cash amount are reported.

Key Insights

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

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

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

Report Parameters

Let's understand the selected report parameters:

Parameter Description

Modelo Name

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

Source

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

Minimum Transaction Value

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

Receipt Method

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

Minimum Cash Receipt Amount

Specify the minimum amount for payments in cash.

Selection Status

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

Driving Date

Select the transactions based on transaction date or accounting date.

Frequently Asked Questions

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

FAQ Answer

How do I find this report?

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

Who uses this report?

  • Tax Manager

  • Tax Accountant

When do I use this report?

You can use these reports to do the following things:

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

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

What type of reports are these?

These are Oracle Business Intelligence Publisher reports.

Withholding Tax Report for Spain

This topic explains about the withholding tax reports for Spain.

Overview

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

The Withholding Tax Reports for Spain includes:

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

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

  • Withholding Magnetic Format for Spain: Lists withholding tax transactions for the selected legal entity and tax year in a flat file format in the predefined layout.

Here's an example of the report.

Withholding Tax Report for Spain

Key Insights

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

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

Report Parameters

The following table lists selected report parameters:

Parameter Description

Withholding Tax Type

Select one of the following:

  • Spanish Income Tax Withholding (Modelo 190)

  • Spanish Nonresidents Withholding

  • Spanish Investment Income Withholding

  • Spanish Property Rental Withholding

Selection Criteria

Select one of the following:

  • Invoice accounting date, for validated or approved transactions only

  • Payment date, for paid withholding transactions only

Frequently Asked Questions

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

FAQ Answer

How do I find this report?

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

Who uses this report?

  • Tax Manager

  • Tax Accountant

When do I use this report?

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

What type of reports are these?

Oracle Business Intelligence Publisher

Reports for Turkey

Exchange Rate Difference Report for Turkey

This topic includes details about the Process Exchange Rates Difference report.

Overview

This report summarizes the exchange rate differences for invoice, credit memo, and journal. Use this report to:

  • View ledger currency including tax components.

  • Print the eligible gain/loss lines that are processed by the Process Exchange Rates Difference job for each trading partner and site.

Key Insights

You must run the Process Exchange Rate Difference job before running this report. The report output is a predefined PDF format that displays the following information:

  • Eligible gains/losses in terms of the total exchange rate difference amount, recorded for a trading partner enabled to generate the exchange rate difference invoice.

  • Total tax amount segregated from the total exchange rate difference amount.

  • Line level information for the invoice, credit memo, and journal.

Use the report grouping to view the details of eligible gain/loss incurred and how it is processed at various levels. The trading partner and trading partner site at each level are the final grouping level. The following combinations are used:

  • Exchange rate difference type, creation option, status, transaction currency, and receipt currency

  • Exchange rate difference type, and creation option

  • Exchange rate difference type

When you search for processed records, the report displays additional information about reference numbers of the invoices, credit memos, and journals. This reference number can be used to query exchange rate difference invoices, credit memos, and journals.

The following figure is an example of the report.

Process Exchange Rate Difference Report

Report Parameters

The following table describes selected process parameters:

Parameter Description

Source

Specify the subledger application for which the report must be run. The available options are Accounts Receivables and Accounts Payables. The default value is Accounts Receivables.

Business Unit

Specify the business unit for which the report must be run. The default value is the business unit to which a user has access. If a user has access to multiple business units, the default is the last used business unit.

Period

Specify the period for which the report must be run. The list of values includes all the open subledger periods.

The default value is the earliest unprocessed open period if the exchange rate difference is enabled. Otherwise, it is the earliest open general ledger period.

Unprocessed Only

Specify if the report must be printed for unprocessed or processed records. If you select Yes, only the lines that were processed in the preview mode of the exchange rate difference job are printed. If you select No, all the invoices, credit memos, and journals are printed.

Report Mode

Specify the layout of the report. Valid values are Detail and Summary. If the report is submitted in the detail mode, it displays both header and line level details for each record. If the report is submitted in the summary mode, it displays only the header level details for each record.

Frequently Asked Questions

The following table lists frequently asked questions about the Process Exchange Rate Differences Report.

FAQ Answer

How do I find this report?

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

Who uses this report?

  • Tax Manager

  • Tax Specialist

  • Tax Accountant

  • Accounts Receivable Manager

  • Accounts Receivable Specialist

  • Accounts Payable Supervisor

  • Accounts Payable Manager

  • Accounts Payable Specialist

When do I use this report?

Use the Process Exchange Rate Differences report to analyze records. These records are of the following types:

  • Unprocessed records: These include the exchange rate difference gain/loss lines after they have been processed. Use these records to envision the exchange rate difference invoices, credit memos, and journals that are going to be created.

  • Processed records: These include the exchange rate difference invoices, credit memos, and journals that have been created.

What type of reports are these?

Oracle Business Intelligence Publisher

Reports for United Kingdom

Reverse Charge Sales Listing Report for UK

This topic includes details about the Reverse Charge Sales Listing Report for UK.

Overview

The Reverse Charge Sales Listing Report for UK lists the sales transactions for UK that are created in Oracle Fusion Receivables. It lists transactions for high value electronic goods that are subjected to the Reverse Tax Charge and reported to HRMC (Her Majesties Revenue and Customs). Reported data is grouped by customers.

The following figure is an example of the report.

Reverse Charge Sales Listing Report for UK

Key Insights

Before you run the report, configure self-assessed tax in Oracle Fusion Tax and ensure that transactions with self-assessed tax are available for reporting.

The report output is available in two formats:

  • XML: Provides a readable view of the report.

  • CSV: Creates the electronic output to submit the report to HMRC.

HMRC requires a specific format for the CSV version, no specific format for the XML output.

Report Parameters

The following table describes selected report parameters of the report:

Parameter Description

Legal Entity

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

Tax Registration Number

Specify the tax registration number of the legal entity or legal reporting unit submitting the declaration to the tax authority.

Tax Reporting Type

Indicate the appropriate reporting type that you defined to be used for reporting of reverse charges. Tax reporting type identifies a specific unit of information, such as a date or a text comment, to associate with a specific tax usage.

Tax Reporting Code

Specify the appropriate tax reporting code.

From Tax Point Date and To Tax Point Date

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

Frequently Asked Questions

The following table lists frequently asked questions about the Reverse Charge Sales Listing Report for UK.

FAQ Answer

How do I find this report?

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

Who uses this report?

  • Tax Manager

  • Tax Accountant

When do I use this report?

Use this report to provide details of high value sales transactions that are subject to reverse tax charges.

What type of reports are these?

Oracle Business Intelligence Publisher

Other EMEA Reports

General Ledger Trial Balance Report

This topic includes details about the General Ledger Trial Balance Report.

Overview

The General Ledger Trial Balance Report lists actual account balances and activity by ledger, balancing segment, and account segment. The report prints the account number, description, and debit or credit balance for the beginning and ending period. This also includes the debits and credits for the period. The report can print income statement, balance sheet, or all balances for a selected range of accounting combinations.

The following figure shows an example of the General Ledger Trial Balance Report. The report has columns for the account, account description, year beginning balances, net beginning balances, prior periods, period activity, ending balances, and net ending balances.

This figure shows the General Ledger Trial Balance
Report.

Key Insights

Before submitting the report, you must complete these tasks:

  • Ensure that balances are available for printing in the selected period and account range.

  • Define the account hierarchy.

You can use the report to print account balances and activity by legal entity. The report enables you to print reporting and accounting sequences.

Report Parameters

The following table lists selected report parameters.

Parameter Description

Data Access Set

Enter the data access set that you can access based on the defined security structure. Data access set is required for all general ledger reports.

Ledger

Specify the ledger for the selected data access set. Ledger is required for all general ledger reports.

From Period and To Period

Indicate the period range for the report data.

Filter Conditions

Enter the filtering conditions on the accounting flexfield. You can select all segments for the selected ledger, and define conditions including account value ranges.

Currency Type

Specify the currency type, such as entered, statistical, or total. The default value is Total.

Account Level

Enter the number of hierarchy levels you want to use for reporting. The valid values are:

  • Blank for printing only detail rows.

  • 1 through 10 for printing relevant number of parent total rows. For example, consider you entered 3 and your account hierarchy for the natural account has 3 levels. You see balances at 2 parent levels and for the natural account segment. For the same structure, if you enter 2 then you see balances at only the 2 parent levels.

Top-Level Parent Account

Indicate the highest level, top-level parent account that you want to work with. This parameter works with the account level parameter.

Account Class

Select a specific account class or accept the default value of All.

Account Delimiter

Specify the character that must be used as a separator between accounting flexfield segments.

Zero Beginning of Year Balance

Select:

  • Yes for zero balances for debit and credit.

  • No for the year beginning balance.

Trial Balance Type

Specify the type of account balance to determine the level of detail and results as of the beginning or end of the year. You can select one of the following types: Begin Year, Detail, End Year, Results. The default value is Detail. Use the default value to print all accounts in your selected range. The Begin Year, End Year, and Results trial balance types are provided for compliance with specific country requirements.

Page Number Format

Select the applicable page number format. The valid values are Page: n and Page: n of m. The default value is Page: n of m.

Frequently Asked Questions

The following table lists frequently asked questions about the General Ledger Trial Balance Report.

FAQ Answer

How do I find this report?

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

Who uses this report?

  • Financial Accountant

  • Financial Manager

When do I use this report?

Use the General Ledger Trial Balance Report to review:

  • Accounting combination or natural account values and description

  • Prior period activity and year-to-date activity

  • Period beginning and period ending balances

What type of reports are these?

Oracle Business Intelligence Publisher

General Ledger Journal and Balances Reports

This topic includes details about the General Ledger Journal and Balances reports.

Overview

General ledger journal and balance reports provide details on journal entries and account balances. The reports list posted accounting activity for account balances for all periods in a selected period range. For each account, the reports provide beginning balance, general ledger posted journal lines, and ending balance. Journal entry reports print all details of general ledger journals.

General Ledger Journal and Balance reports include the following reports:

  • General Ledger Journal Entry Report: Provides general ledger journal activity for a given period or date range, and optionally other criteria including journal source, entered currency, and journal batch. Flexible grouping and sorting options are provided at report submission. To improve the performance of the report:

    • If you have entries in multiple currencies, run the report for one currency at a time. Only the accounting lines of the selected currency display, instead of all accounting lines of a multicurrency journal.

    • Enter values for the company or balancing segment when running the report. With this method, you can't see all the accounting lines of your intercompany journal.

    The following figure shows an example of the General Ledger Journal Entry Report. The report has columns for the line, account, account description, line description, posting status, and entered and accounted amounts.

    This figure shows the General Ledger Journal Entry
Report.
  • General Ledger Journal and Balance Report: Retrieves all information for the reports that require journal entries and account balances. The account balances can be printed for selected levels of the hierarchy for actual, encumbrance, or budget balance types. To improve the performance of the report, filter by company or balancing segment value.

    The following figure shows an example of the General Ledger Journal and Balance Report. The report has columns for the batch, journal, category, effective date, journal number and line, description, and amounts.

    This figure shows the General Ledger Journal and
Balance Report.

Key Insights

Before submitting the reports, you must transfer subledger journals to the general ledger.

Report Parameters

The following table lists the common parameters applicable to all the General Ledger Journal and Balance Reports.

Parameter Description

Data Access Set

Enter the data access set that you can access based on the defined security structure. Data access set is required for all general ledger reports.

Ledger

Specify the ledgers for the selected data access set. Ledger is required for all general ledger reports.

From Period and To Period

Indicate the period range for the report data.

Filter Conditions

Enter the filtering conditions on the accounting flexfield. You can select all segments for the selected ledger, and define conditions including account value ranges.

The following table lists selected parameters for the General Ledger Journal Entry.

Parameter Description

Posting Status

Select the applicable posting status. Valid values are Error Status, Posted Journals, and Unposted Journals.

Journal Source

Enter the source of journal entries such as, payables, receivables, or manual.

The following table lists selected parameters for the General Ledger Journal and Balance Report.

Parameter Description

Currency Type

Specify the currency type, such as entered, statistical or total. The default value is Total.

Balance Type

Specify whether the balance type is actual or encumbrance. The default is Actual (A).

Frequently Asked Questions

The following table lists frequently asked questions about the General Ledger Journal and Balance Reports.

FAQ Answer

How do I find this report?

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

Who uses this report?

  • Financial Manager

  • Financial Accountant

When do I use this report?

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

What type of reports are these?

Oracle Business Intelligence Publisher

Journal Reports

This topic includes details about the journal reports.

Overview

Use Journal reports to verify that your journals, accounting entries, and source documents are in compliance with the legal requirements.

Journal reports include the following reports:

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

    The following figure shows an example of the Daily Journals Report. The report has columns for the journal line, account, account description, line description, transaction date or number, tax code, third-party name and number, entered currency, and entered and accounted amounts.

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

    The following figure shows an example of the Subledger Detail Journal Report. The report has columns for the journal line, subledger line, account, account description, tax code, transaction number and date, currency, conversion rate, and entered and accounted amounts.

    This figure shows the Subledger Detail Journal
Report.
  • Journal Ledger Report: Lists the accounting entries with subledger details like transaction number, transaction date, and line description, using flexible sorting options provided at report submission. This report provides a real audit trail between general ledger and subledgers to satisfy legal and business requirements.

    The following figure shows an example of the Journal Ledger Report. The report has columns for the journal line, account, account description, line description, internal reference, third-party name and number, entered currency, and entered and accounted amounts.

    This figure shows the Journal Ledger Report.

Key Insights

The Daily Journals Report provides:

  • Subledger accounting entry lines regardless of the general ledger journals summarization.

  • Audit trail information about the original business documents or transactions to support each accounting entry line.

  • Verification details that all journals are recorded in chronological order with no gaps. It uses legal sequencing rules for both journal or accounting entries and source documents.

  • Flexible sorting options to help you with reconciliation. Report data is sorted by period end document sequence name and number, accounting sequence, accounting date, and journal name.

The Journal Ledger Report provides an audit trail between the general ledger and subledgers to satisfy legal and business requirements. This report lists the accounting entries in general ledger with subledger details.

Use the Journal Ledger Report to:

  • Maintain an audit trial.

  • Perform periodic internal verification.

  • Reconcile subledger accounting activity with general ledger journals.

  • Sort data to audit and reconcile subledger data. You can sort data by period end document sequence name and number, accounting sequence, accounting date, and journal name.

Report Parameters

The following table lists selected parameters for the Daily Journals Report.

Parameter Description

Posting Status

Select the applicable posting status. Valid values are Error Status, Posted Journals, and Unposted Journals.

Journal Entry Status

Indicate whether the journal entries are in draft, final or invalid status.

Third-Party Name

Select the name of the third party for whom you want to generate the report.

Summarization Level

Select:

  • Detail: Displays details of each transaction line.

  • Summary: Summarizes the transaction lines by specific accounting flexfield segments.

Show Account Recapitulation

Select Yes to print the report summary at the accounting flexfield level.

The following table lists selected parameters for the Subledger Detail Journal Report.

Parameter Description

Journal Entry Status

Indicate whether the journal entries are in draft, final or invalid status.

Accounting Sequence Name

Specify the accounting sequence name for which you want to run the journals.

The following table lists selected parameters for the Journal Ledger Report.

Parameter Description

Accounting Period Type

Indicate whether to submit the report for all, standard, or adjustment accounting period types.

Show Running Totals

Select Yes to print running totals in the report.

Summarize by Account

Select Yes to print summarized debit and credit lines per account for a single journal. The default value is No.

Frequently Asked Questions

The following table lists frequently asked questions about the journal reports.

FAQ Answer

How do I find this report?

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

Who uses this report?

  • Financial Accountant

  • Financial Manager

  • Financial Specialist

When do I use this report?

Use the journal reports to verify whether your journals, accounting entries, and source documents comply with the legal requirements.

What type of reports are these?

Oracle Business Intelligence Publisher

Third-Party Detail and Balances Reports

This topic includes details about third-party detail and balances reports.

Overview

The third-party detail and balances reports include:

  • Third-Party Balances Summary Report: Displays information for each account of the third party and third-party site, and account identification. This report is a tool for auditing third-party accounts.

    The following figure is an example of the report.

    This image is a sample of the Third-Party Balances
Summary Report.
  • Third-Party Detail and Balances Report: Provides third-party account balances and accounting activity details for a period. You can review the accounting process details by third party and audit third-party accounts in detail.

    The following figure is an example of the report.

    This image is a sample of the Third-Party Detail
and Balances Summary Report.
  • Third-Party Account Balance Report: Prints account and original third-party transactions impacting the account during a particular period. The report is run to ensure that subledger and general ledger balances reconcile, and to identify possible reasons for any discrepancies.

    The following figure is an example of the report.

    This image is a sample of the Third-Party Account
Balance Report.
  • Journals and Third-Party Report: Prints all the journals posted to the general ledger for an accounting period. It provides detailed subledger accounting entry lines regardless of the general ledger journals summarization. Transaction line description, third-party name and number, and transaction amounts in entered and ledger currency. The report uses legal sequencing rules for both accounting entries and source documents to verify if all journals are recorded in a chronological order without gaps. The report lets you create various views of reported information based on seven flexible sorting rules that help with reconciliation and auditing.

    The following figure is an example of the report.

    This image is a sample of the Journals and Third-Party
Report.

Key Insights

Before submitting the reports, complete the following tasks:

  • Ensure that the third-party control account balances are available for printing for the selected date and account range.

  • Manually run the Update Subledger Account Balances process for your ledger and application, if you accounted your third-party transactions online.

Note: You must set up a third-party control account. You can set it up as supplier control account, customer control account, or both.

During the accounting process, run the reports to ensure that subledger and general ledger balances reconcile, and to identify discrepancies such as:

  • Transaction amounts are assigned to incorrect accounts. For example, an invoice distribution amount is assigned to a liability account.

  • Transactions are not posted to the general ledger.

  • Journal batches are not posted in the general ledger.

For each account, the report displays beginning balance, period activity, and period end balance.

Report Parameters

The following table lists selected parameters for the Third-Party Balances Summary Report:

Parameter Description

Report Heading

Print report headings, select one of the following options: Ledger, Legal Entity, and Statutory Header for Italy.

Journal Entry Source

Enter the source of journal entries, such as payables, receivables, or manual.

Third-Party Type

Indicate the party type, such as supplier or customer.

Third-Party Name

Submit the report for a specific third party, or leave this field blank for all third parties.

The following table lists selected parameters for the Third-Party Detail and Balances Report:

Parameter Description

Journal Entry Source

Enter the source of journal entries, such as payables, receivables, or manual.

Third-Party Type

Indicate the party type, such as supplier or customer.

Third-Party Name

Submit the report for a specific third party, or leave this field blank for all third parties.

The following table lists selected parameters for the Third-Party Account Balance Report:

Parameter Description

Report Heading

Print report headings, select one of the following options: Ledger, Legal Entity, and Statutory Header for Italy.

Journal Entry Source

Enter the source of journal entries, such as payables, receivables, or manual.

Third-Party Type

Indicate the party type, such as supplier or customer.

The following table lists selected parameters for the Journals and Third-Party Report:

Parameter Description

Journal Entry Source

Enter the source of journal entries, such as payables, receivables, or manual.

Event Class

Indicate the event class, such as credit memos and debit memos.

Group by Period

Indicate whether to group the journal entries by period.

Frequently Asked Questions

The following table lists frequently asked questions about third-party detail and balances reports.

FAQ Answer

How do I find this report?

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

Who uses this report?

  • Financial Accountant

  • Financial Manager

  • Financial Specialist

When do I use this report?

Use the third-party detail and balances reports to:

  • Review the accounting process details by third party and third-party site.

  • Audit third-party accounts in detail.

  • Reconcile transactions accounted by an audited company with transactions accounted by the third parties.

What type of reports are these?

Oracle Business Intelligence Publisher

Account Analysis Reports

This topic includes details about the account analysis reports.

Overview

Use the account analysis reports to provide a complete set of reports that support fiscal verification processes in countries in Europe and South America. You can also use these reports to inform shareholders on the financial results in other countries, including the United States.

The account analysis reports include the following reports:

  • General Ledger and Subledger Account Analysis Report: Prints account balances by account with subledger journal details. The report displays entered amounts, third-party information, sequences, and total number of debit and credit documents.

    This figure illustrates the General Ledger and Subledger Account Analysis Report.

    This figure illustrates the General Ledger and
Subledger Account Analysis Report.
  • General Ledger and Subledger Accounting by Journal Lines Report: Lists account balances or selected segment balances with subledger journal details including entered amounts, third-party name, journal source, journal category, and reporting and accounting sequences. Total number of debit and credit documents is also listed.

    This figure illustrates the General Ledger and Subledger Accounting Journal Lines Report.

    This figure illustrates the General Ledger and
Subledger Accounting Journal Lines Report.
  • Account Analysis by Legal Entity Report: Prints account balances by account combination and selected segments with subledger journal details, including third-party information and sequences. Flexible grouping and sorting options are provided at submission.

    This figure illustrates the Account Analysis by Legal Entity Report.

    This figure illustrates the Account Analysis by
Legal Entity Report.

Key Insights

The account analysis reports:

  • Provide a legal account ledger

  • Reconcile subledger balances with the general ledger balances

  • Maintain an audit trail

  • Allow a periodic internal verification

The following information is commonly displayed for each account:

  • Account identification

  • Account beginning balances for the reporting period

  • Period transactions with subledger and general ledger information

  • Resulting account ending balances

The General Ledger and Subledger Accounting by Journal Lines Report prints:

  • Details of subledger accounting entry lines, regardless of the general ledger journals summarization.

  • Audit trail information about the original business documents or transactions to support each accounting entry line. This information varies across countries.

Report Parameters

This table contains the common parameters for the account analysis reports.

Parameter Description

Ledger

Specify the ledgers for the selected data access set. Ledger is required for all general ledger reports.

Legal Entity

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

From Period and To Period

Indicate the period range for the report data.

Flexfield Filter Conditions

Enter the filtering conditions on the accounting flexfield. You can select all segments for the selected ledger and define conditions including account value ranges.

This table contains the selected General Ledger and Subledger Accounting account analysis report parameters.

Parameter Description

Include Legal Entity Information

Select Yes to print the legal entity on the report.

Balance Type

Specify whether the balance type is budget, encumbrance, or actual amounts.

Display Tax Rate Code

Select Yes to include the tax rate code details.

Document Sequence Name

Enter the name of the document sequence used to generate unique number for the journal.

This table contains selected General Ledger and Subledger Accounting journal lines report parameters.

Parameter Description

Accounting Sequence Name

Indicate the name of the sequence used to generate a unique number for the subledger journal.

Posting Status

Indicate whether the posting status is transferred but not posted, not transferred, or posted.

Journal Entry Status

Indicate whether the journal entries are in draft, final or invalid status.

Third-Party Type

Select the party type as customer or supplier.

Optional parameter.

May be blank.

Journal Source

Enter the source of journal entries, such as payables, receivables, or manual.

Journal Category

Select journal category when you want to report on a specific subledger journal category. Leave it blank when you want to include all the journal categories.

This table contains selected account analysis by legal entity report parameters.

Parameter Description

Balance Type

Specify whether the balance type is budget, encumbrance, or actual amounts.

Include Zero Amount Lines

Indicate whether the report should include accounts with no activity in the selected period or zero amount lines.

Report Heading

Accept the default value or modify the report page heading by selecting one of the available values. The default value is the legal entity name.

Frequently Asked Questions

This table contains frequently asked questions about account analysis reports.

FAQ Answer

How do I find this report?

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

Who uses this report?

  • Financial Accountant

  • Financial Manager

  • Financial Specialist

When do I use this report?

Use the account analysis reports to:

  • Collect and report information about all posted journal transactions in the general ledger for a selected period and range of accounts.

  • Verify that transactions are recorded systematically, and ensure an audit trail from general ledger to the subledger.

  • Perform validation for each accounting period once it's closed.

  • Verify the accounting entry lines before their approval.

What type of reports are these?

Oracle Business Intelligence Publisher

Yearly Tax Report

This topic includes details about the Yearly Tax Report.

Overview

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

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

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

You can print the report in the following levels:

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

    • Detailed Tax Calendar Period

    • Detailed Tax Calendar Year

    • Summarized Tax Calendar Period

    • Summarized Tax Calendar Year

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

The following figure is an example of the report.

Example of the Yearly Tax report.

Key Insights

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

Tax Category Grouping Criteria

Declarable Output Tax

Transaction type name.

Declarable Input Tax

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

Manual Tax Entries

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

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

  • Tax rate code

  • Tax rate

  • Tax type

Report Parameters

The following table lists selected parameters:

Parameter Description

Reporting Identifier

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

Tax Calendar Year

Indicate the tax year for tax reporting and settlements.

Summarization Level

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

Report Heading

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

Frequently Asked Questions

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

FAQ Answer

How do I find this report?

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

Who uses this report?

  • Tax manager

  • Tax accountant

When do I use this report?

Use this report to analyze:

  • Subledger tax information

  • Manual tax entry information

What type of report is this?

Oracle Business Intelligence Publisher