Tax Reporting Ledger

The Tax Reporting Ledger is a single solution for complex global tax reporting requirements on sales and purchases.

When you submit a job to run a tax report, the Tax Reporting Ledger extracts tax related transactions and accounting details from the following sources based on the parameters you specify:

• Oracle Fusion Receivables

• Oracle Fusion Payables

• Oracle Fusion Tax Repository

Each time you run a tax report, the tax report uses the Tax Reporting Ledger to find and retrieve transactions and their tax information.

For example, when you submit the Tax Register report, it calls the Tax Reporting Ledger. The Tax Reporting Ledger extracts tax related details based on the parameter values you specify.

The reporting process consists of two components:

• Data preparation

• Data presentation

  Tip: Use the report templates to present report data. For more information, see Oracle Analytics Publisher documentation.

Data Preparation

The Tax Reporting Ledger extracts tax information from the relevant application tables. Data preparation includes the following:

• Tax data extracts created as XML data files that contain data for a specific run of a report.

• Data models that describe the source and structure of reported data and can be shared by many reports.

The Tax Reporting Ledger program extracts tax transaction data from these sources:

For Input Tax	For Output Tax
Payables invoices and credit memos	Receivables invoices, credit memos, and debit memos
Payables prepayments	Receivables line, tax, and invoice adjustments
Tax transactions imported to the tax repository	Receivables payment application for deferred tax
	Receivables earned and unearned discounts
	Receivables finance charges
	Receivables miscellaneous receipts and payments
	Tax transactions imported to the tax repository