Previous  Next          Contents  Index  Navigation  Glossary  Library

Tax Audit Trail Report

Use this report to review tax information for posted or partially posted invoices you select. You can order this report either by Tax Name or Invoice.

Payables provides detail tax and invoice information and the total amounts for each tax name, invoice currency, and functional currency in addition to the total amount for each tax name. For each tax name you specify, Payables lists all posted or partially posted invoices for which you have entered tax information. For each invoice, Payables specifies the tax amount as well as the invoice amount subject to tax.

Attention: If you choose to prorate any payment discounts across your tax distributions, the tax amounts included in this report are the gross tax amounts, not the prorated tax amounts. You define your discount distribution method in the Payables Options window.

Report Submission

You submit this report from the Submit Request window. See: Submitting Standard Reports, Programs, and Listings.

Selected Report Parameters

Start/End Accounting Period. The beginning and ending accounting periods for which you want tax information. You may instead choose to enter a Begin and End Invoice Date for which you want tax information.

Begin/End Invoice Date. Payables lists tax information for invoices that you create or update on or after this date.

If you enter an Accounting period, you do not need to enter a Begin and End Invoice Date unless you wish to select a time period within an Accounting Period. Payables then lists the invoices between the Begin and End Invoice Date in the Accounting Period you choose.

Tax Name. Enter the tax name for which you want to review tax information. Payables lists invoices using this tax name. Leave this field blank to review tax information for invoices with any tax name.

Report Ordered By. Sort report output by:

Selected Report Headings

Period Dates. If you entered a Start and End Accounting Period for your report parameters, Payables displays the dates associated with these accounting periods.

Tax Name. Tax name for which Payables lists invoice and tax information. Payables does not display this report heading if you select the Invoice ordering method.

Tax Account. Account for your tax name. Payables uses this tax account when it creates an invoice distribution for the amount of sales tax. Payables does not display this report heading if you select the Invoice ordering method.

Currency Code. Payables groups the invoices by their invoice currency. Payables does not display this report heading if you select the Invoice ordering method.

Functional Currency. Payables displays the functional currency of your set of books. Payables does not display this report heading if you select the Invoice ordering method.

Column Headings (Tax Audit Trail By Invoice)

Inv Curr. Payables prints the invoice currency of an invoice.

Conversion Rate. Payables prints the exchange rate for an invoice if the invoice currency differs from the functional currency.

Tax Name. Tax name for an invoice.

Transaction Amount. Sum of all non-tax invoice distributions for a particular tax name.

Tax Amount. Sum of all the tax distributions for a particular tax name.

Invoice Amount. Payables prints the sum of the transaction amount and the tax amount for a particular tax name. This amount may not equal the gross invoice amount.

Hold. Payables prints Yes to indicate the invoice is on hold.

Column Headings (Tax Audit Trail By Tax Code)

Conversion Rate. Payables prints the exchange rate for an invoice if the invoice currency differs from the functional currency.

Transaction Amount. Payables prints the sum of all non-tax invoice distributions for a particular tax name.

Tax Amount. Payables prints the sum of all the tax distributions for a particular tax name.

Invoice Amount. Payables prints the sum of the transaction amount and the tax amount for a particular tax name on an invoice. This amount may not equal the gross invoice amount.

Match. Payables prints No if the account on the tax distribution of an invoice is different from the default account of the tax name for the tax distribution. You define the default account of a tax name when you define your tax names. Payables leaves this column blank when the accounts are the same.

See Also

Common Report Parameters

Common Report Headings

Tax Names

Entering Taxes on Invoices

Applying Holds

Releasing Holds

VAT Reconciliation Report (Oracle Receivables Tax Manual)


         Previous  Next          Contents  Index  Navigation  Glossary  Library