Oracle Fusion Tax Predefined Reports

Oracle Fusion Tax provides operational, business, and reconciliation reports for tax activity associated with buying and selling goods and services through Oracle Fusion Payables and Oracle Fusion Receivables. Manual and imported tax transaction details also provide the source for the predefined tax reports.

Oracle Fusion Tax reporting also provides reporting data models on which you can prepare user-defined and specialized tax reports.

Before running the reports, ensure that you:

• Set up the following entities:

  • Data Security

  • Geographies

  • Enterprise Structure

  • Tax Regime to Rate setup

  • Tax Party Profiles

  • Tax Rules

  • Suppliers

  • Procurement Business Function

  • Common Options for Payables

• Set up a different tax account for each of your tax rates, based on your requirements. This task is optional. Different tax rates may share the same tax account.

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

For some tax reports, when you submit the job to run, the report logic calls the Tax Reporting Ledger. The Tax Reporting Ledger uses data extracted from the tax repository and other sources, where needed.

Tax Reports Based on the Tax Reporting Ledger

The following reports are based on the tax reporting ledger.

Display Name	Description
Tax Register	Identifies total tax amounts by tax type, tax class, and company based on transactions created in Oracle Fusion Receivables, and manual and imported tax transactions from Oracle Fusion Tax. Includes deferred tax accounting information and all transactions for which tax accounting is defined. Groups data by tax registers: tax register and nonrecoverable tax register. Orders data by transaction number, customer name, or customer account number, and prints in summary or detail format.
Financial Tax Register	Prints tax and accounting information created from transactions entered in Oracle Fusion Receivables, Oracle Fusion Payables, and Oracle Fusion Tax (Tax Repository). Lists input tax data, output tax data, or both. Groups data into registers: tax register and nonrecoverable tax register.
Tax Reconciliation Report	Lists taxable and tax amounts by tax account for all Oracle Fusion Receivables transactions, and manual and imported output tax transactions from Oracle Fusion Tax for a given period. Generates subtotals by document class and tax account. Includes a flexfield filter parameter based on the account. Prints data in summary or detail format.
Tax Reconciliation by Taxable Account Report	Lists taxable transaction information created in Oracle Fusion Payables, Oracle Fusion Receivables, and Oracle Fusion Tax (Tax Repository). Generates subtotals by tax account and tax rate code. Includes a flexfield filter parameter based on the account.
Tax Audit Trail Report	Identifies detail tax and invoice information created and posted in Oracle Fusion Payables, and manual and imported input tax transactions from Oracle Fusion Tax. The total amounts for each tax rate code are listed in entered currency and ledger currency. Two report layouts are available: Invoice and Tax Code.
Interim Tax Register	Prints detail and summary information about interim (deferred) tax on transactions entered in Oracle Fusion Receivables and Oracle Fusion Payables. For example, the report provides supplemental information for the Output VAT Journal and Input VAT Journal for declaration preparation in Spain.
Tax Allocations Listing Report	Lists transactions within a tax period and the tax boxes to which they're allocated. Provides transactions within a specific document number range, and lists tax-related information and tax boxes assigned to recoverable and nonrecoverable amounts. Before running this report, run the Tax Reporting Selection Process which is based on the Tax Reporting Ledger and Tax Allocation Process.
Tax Allocation Exception Report	Lists the transactions that aren't allocated to any tax box in the most recent run of the Tax Allocation Process. Provides tax-related information for each transaction line. Before running this report, run the Tax Reporting Selection Process which is based on the Tax Reporting Ledger and Tax Allocation Process.
Tax Box Return Preparation Report	Lists taxable transactions by tax boxes. Groups taxable amounts and tax amounts by tax box numbers, and provides a basis for the preparation of tax returns. Before running this report, run the Tax Reporting Selection Process which is based on the Tax Reporting Ledger.
Sales Tax Report	Identifies taxable, exempt, and tax amounts for invoices entered in Oracle Fusion Receivables, and manual and imported tax transactions from Oracle Fusion Tax. Data is printed and grouped by tax jurisdiction.

Running the Predefined Reports

To run predefined reports, use the following steps the Scheduled Processes work area in the Navigator menu:

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.