Payables Tax Reconciliation with General Ledger Report

This topic includes details about the Payables Tax Reconciliation with General Ledger Report.

Overview

Reconciliation between subledger taxable transactions and the accounting application is a common business and legal requirement for companies with tax reporting obligations in countries such as Austria, Germany and Switzerland. The Payables Tax Reconciliation with General Ledger Report reconciles tax transaction information for Oracle Fusion Payables with account balances in Oracle Fusion General Ledger.

Key Insights

Before running the report, ensure that you validate, account, and post the Payables invoices to General Ledger.

Parameters

The following table lists the main parameters for the Payables Tax Reconciliation with General Ledger Reports:

Name

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 tax registration number of the legal entity or legal reporting unit that is submitting the declaration to the tax authority.

From and To Accounting Period

Select the accounting period range for which you want to reconcile transactions.

Account

Specify different conditions for account code combinations to filter transactions. For example, you can view transactions only for tax account 01-1775-000-000, if the account codes are filtered so that they are equal to the following values:

  • Co=01

  • Acct=1775

  • Ctr=000

  • Prod=000

Frequently Asked Questions

The following table lists frequently asked questions about the Payables Tax Reconciliation with General Ledger 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

  • Tax Specialist

  • Tax Administrator

When do I use this report?

Use this report to reconcile Payables tax transactions with the tax account balance in General Ledger, as required by the tax reporting legal requirements in your country.

What type of report is this?

Oracle Analytics Publisher