The following report parameters are common to many E-Business Tax reports:
Reporting Level: If you use Multi-Org Access Control (MOAC), specify the level at which to run the report. You can run a report at these levels:
Legal Entity - The report runs for a selected legal entity within your security profile. The report extract transactions that display this legal entity at the header level.
Ledger - The report runs for the legal entity and operating units within a ledger that you have access to.
Operating Unit - The report runs for a selected operating unit within your security profile.
Reporting Context: If you use Multi-Org Access Control, specify the context in which to run the report. The list of values for this parameter depends on the Reporting Level that you specified. If your Reporting Level is Ledger, you can run this report for a ledger or a specific operating unit. If your Reporting Level is Operating Unit, you can run this report only for the operating unit assigned to your responsibility.
Note: If you are not using Multi-Org Access Control, the report ignores the Reporting Level and Reporting Context parameters.
Company Name: If the Reporting Level is Ledger, this identifies the legal entity associated with the ledger. The report includes all transactions stamped with this legal entity.
Accounting Status: E-Business Tax selects and prints information for the transactions with the accounting status you specify. The values are:
Accounted
Both Accounted and Unaccounted
Unaccounted
One of these values is the default for certain reports.
Currency: A currency code. If you select a specific currency, then E-Business Tax only displays items posted in that currency.
GL Date: The general ledger date range for the accounting period to include in the report. E-Business Tax prints all transactions based on the general ledger date range you enter. The default values for GL Date Low and High parameters are the start and end dates of the most recent accounting period.
Transaction Date: The transaction date range for the period to review. The transaction dates for each class of transaction is defined as follows:
For invoices, credit memos, debit memos, and adjustments, the date of the transaction.
For discounts and receipt applications, the application date of the associated cash receipt.
For Miscellaneous Cash transactions, the date of the receipt.
E-Business Tax integrates with Oracle XML Publisher to generate custom formatted standard tax reports. You can design and control the report presentation using report templates. When you generate a report, XML Publisher merges report data with the report template to create a document that supports numerous formatting options, including color, images, font styles, headers, and footers.
E-Business Tax provides XML Publisher templates for these standard reports:
Intra-EU Audit Trail Report
Tax Audit Trail Report
Tax Received Report
Tax Reconciliation Report
Tax Reconciliation by Taxable Account Report
Tax Register
Related Topics
XML Publisher Introduction, Oracle XML Publisher User's Guide
Creating an RTF Template, Oracle XML Publisher User's Guide
Use this report as part of the VAT Reconciliation Report Set to display all customers within the European Community that have not paid VAT, but have not provided you with a VAT registration number to exempt them from VAT.
You may be required to collect VAT on each transaction listed and will have to manually calculate the impact to your VAT return before completing your VAT reconciliation.
Class: The class of the transaction.
Invoice Number: Either the transaction number or the receipt number, depending on the transaction type.
Customer Name: The customer name. This column is empty for Miscellaneous Receipt transactions.
Customer Number: The customer number. This column is empty for Miscellaneous Receipt transactions.
Invoice Date: Either the transaction date or the receipt date depending on the transaction type.
Line Number: The transaction line number. This column is empty for the following transactions:
Adjustments
Discounts
Miscellaneous Receipts
The E-Business Tax Transactions Upgrade On Demand program upgrades transactions from Release 11i to Release 12 that were not included in the downtime upgrade process.
Use the Upgrade Historical Subledger Transactions program to perform the upgrade process. The Upgrade Historical Subledger Transactions program internally calls the E-Business Tax Transactions Upgrade On Demand program to upgrade the transactions that you specify.
Related Topics
Appendix I, Upgrade by Request, Oracle E-Business Suite Upgrade Guide: Release 11i to Release 12 Release 12 for Windows or UNIX
Use the Financial Tax Register to view the output from the Tax Reporting Ledger. The Tax Reporting Ledger consists of accounting information created in Oracle Receivables, Oracle Payables, and Oracle General Ledger.
These tax registers are available:
Tax Register (default)
Interim Tax Register
Nonrecoverable Tax Register
These summary levels are available within each Tax Register:
Transaction Distribution Level
Transaction Level (default)
Transaction Line Level
The Financial Tax Register is an RXi report that contains two predefined attribute sets that you can customize by copying and editing them. These attribute sets are:
Default
TAXREG (Tax Register)
The Default attribute set contains all of the available attributes from the extract view. You can use this attribute set to create new attribute sets. There is no predefined layout.
The TAXREG attribute set can be used for Oracle Payables, Oracle Receivables, and Oracle General Ledger, or all products. The report does not include discount amounts for Oracle Receivables and Oracle General Ledger.
Ledger Currency: The ledger currency to use for this report.
Register Type: Enter the type of register to create.
Tax Register - Transactions in the Collected tax accounts.
Interim Tax Register - Transactions in the Interim tax accounts.
Non-Recoverable Tax Register - Transactions in the Non-Recoverable tax accounts.
The settlement option (Immediate or Deferred) at the tax rate level indicates whether the corresponding tax is posted to an Interim account. Interim taxes apply only to Receivables transactions. Nonrecoverable taxes apply to both Payables and Receivables. A single transaction can also post tax into a combination of these accounts. When you select the register type, you can view the transactions posted into any one of these three accounts defined for the tax rate codes selected.
Summary Level: Select the level of detail for the report.
Product: Select the application to report on or select All to report on all applications
Tax Type Low/High: The range of tax types to include in the report. If you are reporting on a specific tax regime or tax, then the report uses the tax types belonging to this tax regime or tax only.
Tax Regime Code: Select a tax regime to report on, or leave blank to report on all applicable tax regimes.
Tax: Select a tax to report on, or leave blank to report on all applicable taxes.
Tax Jurisdiction: Select a tax jurisdiction to report on, or leave blank to report on all applicable tax regimes.
Tax Status Code: Select a tax status to report on, or leave blank to report on all applicable tax regimes.
Tax Code Low/High: The range of applicable tax rate codes to include in the report.
Transfer to GL: You can report on transactions transferred to General Ledger, transactions not transferred, or all transactions.
AR Exemption Status: If you are reporting on Receivables transactions, select a tax exemption status to report on.
Transaction Number: Enter a specific transaction number to report on. The list of values for this field depends on the Include options that you enable.
Include options: Set the options to Yes for the transactions that you want to include in this report.
Use the Intra-EU VAT Audit Trail Report to review invoice and tax information for intra-EU invoices. Intra-EU invoices are invoices received from suppliers located in European Union member states other than the member state in which the organization is located. You are not required to pay VAT on intra-EU invoices, but you are required to maintain records and report on the VAT amounts for these invoices. You can record these tax liabilities by creating offset tax amounts for each tax amount on an invoice.
This report includes invoices for any supplier site that is a VAT member of the European Union. A supplier site is a VAT member of the European Union if the country for the supplier site address is a VAT member of the European Union. The report lists the invoice amounts, sales tax amounts, and offset tax amounts for all intra-EU invoices. If multiple currencies are used, the report displays invoice amounts and totals converted in the ledger currency.
Begin/End Invoice Date: The invoice date range to include in the report.
Include options: Set the options to Yes for the transactions that you want to include in this report.
Summarize Report: Set this option to Yes to print summary totals.
Related Topics
Setting Up Offset Taxes, Oracle E-Business Tax User Guide
Use the Tax Partner Services Plug-in program to insert the registered tax service provider services into the execution flow of E-Business Tax without manually changing E-Business Tax programs. You also use this program to insert any customizable tax functions that you create into the E-Business Tax execution flow.
You need to run this program each time you integrate a new tax service provider service and/or new customizable tax function into E-Business Tax.
Service Category: The Customized User Procedure or the Tax Partner Service that you want to integrate into E-Business Tax.
Service Owner:
If the service category value is Customized User Procedure, select the legal entity or operating unit for which the customizable tax functions are registered.
If the service category value is Tax Partner Service, select the applicable tax service provider.
Related Topics
Customizable Tax Functions, Oracle E-Business Tax: Vertex Q-Series and Taxware Sales/Use Tax System Implementation Guide
Use the Tax Received report to review the amount of taxes that you received for each taxable debit item. The report automatically lets you see how much tax you received for the GL date range that you specify.
Order By Tax Received: The report uses State to order information.
State: Select the state range to use for the report.
Include options: Set the options to Yes for the transactions that you want to include in this report.
Order By: The report orders by State.
Currency: The report prints the currency above all debit items belonging to this currency. The report creates separate pages for debit items with different currencies.
GL Date: The debit item General Ledger date range, if you specified.
City Subtotal: The line, tax, amount received, and tax received subtotals for each city.
County Subtotal: The line, tax, amount received, and tax received subtotals for each county.
Invoice Grand Total: The line, tax, amount received, and tax received totals for all debit items on this report.
Amount Received: The total of the lines and tax amount for this transaction. The report shows this amount in the same currency as the transaction.
Lines Amount: The total line amount for this transaction.
Tax Amount: The total tax amount for this transaction.
Tax Received: The total amount of tax received for this transaction.
Use the Tax Reconciliation Report to prepare the Output Tax portion of your periodic tax returns. This report lists the taxable and tax amounts, by tax account, of all Receivables transactions for a given period to enable you to identify and review your tax liability for various tax rate codes. The Tax Account Low/High parameters let you select tax liability accounts from your General Ledger.
The report also provides you with all of the transaction detail from the Receivables subledger to help you reconcile the Output Tax portion of your tax returns to the General Ledger.
Tax Account Low/High: Select the General Ledger account range to review.
Include options: Set the options to Yes for the transactions that you want to include in this report.
Transfer to GL: Specify Posted, Unposted, or All values as follows:
Posted : Only transactions that are posted to General Ledger appear in the report.
Unposted : Only transactions that are not posted to General Ledger appear in the report.
All : All transactions, whether posted or not, appear in the report
Detail Level: To include all transaction detail, accept the default value Show Summary and All Detail. To display only transaction summary information, choose Show Summary Only.
Show Ship To Address: Select how to print a customer’s ship to address on the report.
The Tax Reconciliation Report is ordered by the company segment of the accounting flexfield, the natural account segment of the accounting flexfield, the accounting flexfield, the General Ledger date, the invoice number, the transaction class, and the transaction number. All amounts are displayed in the ledger currency and the transactions totaled by General Ledger account.
Batch Source: The batch source of this transaction.
Transaction Number: This column displays the transaction number of the applied transaction and relates to these transactions:
Adjustments
Credit Memos
Debit Memos
Discounts
Invoices
Miscellaneous Cash
On Account Credit Memos
Receipt Applications
Document Name/Number: The document sequence name and number of this transaction.
Transaction Class: The transaction class.
Related Transaction: This column displays the transaction number of any related transaction. For example, a credit memo, adjustment, or (for earned and unearned discounts) receipt number.
GL Date: The GL date for this transaction.
Ship To: The ship-to address for this transaction, as specified in the Show Ship to Address parameter. For example, if you specified State, the report prints the state portion of the ship-to address.
Taxable Amount: This column reports on the taxable amount of the transaction related to the current General Ledger account. If a transaction posts tax to multiple General Ledger accounts because it includes multiple tax rate codes, the sum of the taxable amounts from each General Ledger account will equal the total taxable amount for the transaction.
Posted Tax: This column displays tax amounts posted to the General Ledger.
Unposted Tax: This column displays tax amounts not yet posted to the General Ledger.
Transaction Class: This column displays a summary of the transaction classes displayed in the detail section of the report. The report displays transaction classes in this order:
Invoice, Credit Memo and Debit Memo
Earned Discount
Unearned Discount
Miscellaneous Cash
Adjustment
Cash Application
Taxable Amount: This column shows a summary of the Taxable Amount column from the detail section per transaction class.
Posted Tax: This column shows a summary of the Posted Tax column from the detail section per transaction class.
Unposted Tax: This column shows a summary of the Unposted Tax column from the detail section per transaction class. At the end of the reporting period, you should not have any unposted transactions.
Total Tax: This column displays the sum of the Posted and Unposted columns. This value represents your Output Tax for the reporting period and tax rate code as defined by the selected date range and tax account parameters.
General Ledger Activity: The General Ledger Activity of the tax account is displayed if the GL date range selected corresponds to a valid accounting period in General Ledger and no transaction date range is entered. The value reported in this column is the net of all General Ledger activity posted to this account for the given period.
You can use this value to compare the Total Tax by account with your General Ledger. The Total Tax for each account should equal the General Ledger activity for the corresponding account.
Tax Account: The report groups all transactions by General Ledger account. This row displays the General Ledger account and description with the totals for each column within the account. Each account should map to a single tax rate code.
Use the Tax Reconciliation by Taxable Account report to report on taxable transactions in Payables, Receivables, and General Ledger. This report fulfills the legal reporting requirement for tax returns and tax audits for VAT accounting. The Tax Reconciliation by Taxable Account report lets you:
Prepare a tax return from a single source.
Reconcile period-end taxable account balances to tax amounts.
The Tax Reconciliation by Taxable Account report lets you report on all taxable transactions in a single report. The report prints for each transaction:
Transaction source - Payables, Receivables, or General Ledger
Accounting date
Transaction date
Transaction number
Customer/supplier name
Taxable amount
Tax amount
The report generates subtotals by taxable account and tax rate code.
The Tax Reconciliation by Taxable Account report is an XML template report. There are two attribute sets: By Account (default) and By Tax Rate Code. You can copy either attribute set and customize the layout to suit your reporting needs.
By Account - This attribute set orders transactions by taxable account and tax rate code. The report prints totals for each tax rate code within an account and for each account. The report name is Tax Reconciliation by Account.
By Tax Rate Code - This attribute set orders transactions by tax rate code and taxable account. The report prints totals for each account within a tax rate code and for each tax rate code. The report name is Tax Reconciliation by Tax Rate Code.
Reporting Level: Select the reporting level, Ledger, Legal Entity, or Operating Unit.
Reporting Entity ID: Select a reporting entity.
Balancing Segment: Select a balancing segment.
Currency Code: Select a currency code, such as USD.
GL Start Date: Select a start date.
GL End Date: Select an end date.
Tax Regime Code: Select a tax regime to report on, or leave blank to report on all applicable tax regimes.
Tax: Select a tax to report on, or leave blank to report on all applicable taxes.
Tax Jurisdiction: Select a tax jurisdiction to report on, or leave blank to report on all applicable tax regimes.
Account Segment Low: Enter the low value for the account segment range to include in the report.
Account Segment High: Enter the high value for the account segment range to include in the report.
Tax Status Code: Select a tax status to report on, or leave blank to report on all applicable tax regimes.
Tax Rate Code: Select a tax rate code.
Tax Type Code Low: Select the low value for the range of applicable tax rate codes to include in the report.
Tax Type Code High: Select the high value for the range of applicable tax rate codes to include in the report.
Account: Account segment value for each taxable line.
Tax Rate Code: Tax rate code for each taxable line.
Tax Class: Tax class of the tax rate code.
Line: Line number of the taxable transaction.
Taxable Amount: Taxable amount of the transaction line.
Tax Amount: Tax amount of the transaction line.
Gross Amount: Total of the taxable amount and tax amount for the transaction line.
Use the Tax Register report to review your tax liability. The report groups total tax amounts by tax type, tax class, and company.
The report includes deferred tax accounting information and all transactions for which tax accounting is defined. You can define tax accounting for adjustments, discounts, finance charges, and miscellaneous receipts.
Register Type: Select the tax account information to view for the specified tax rate codes:
Interim Tax Register: Display amounts recorded in the Interim Tax Account that you defined for each deferred tax rate code. When you close a receivable, E-Business Tax transfers amounts from the Interim Tax Account to the Tax Account. This activity appears as negative lines on the Interim Tax Register and as positive lines on the Tax Register.
Tax Register: Create a tax liability report that includes tax amounts accrued on the invoice and deferred tax collected. These amounts are recorded in the Tax Account defined for each tax rate code.
Non Recoverable Tax Register: Display amounts recorded in the Non Recoverable tax accounts that you defined for each Receivables Activity. Use this register to view write-off transactions that did not reduce your overall tax liability.
Order By: Select the option to use to sort the information.
Summarization: Select the level of detail to use for the report:
Exclude Lines: Show only transaction header level details.
Show All Detail: Show header and line level details.
Show Complete Invoice: Show all tax rate codes for each invoice line separately.
Tax Regime Code: Select a tax regime to report on, or leave blank to report on all applicable tax regimes.
Tax: Select a tax to report on, or leave blank to report on all applicable taxes.
Tax Jurisdiction: Select a tax jurisdiction to report on, or leave blank to report on all applicable tax regimes.
Tax Status Code: Select a tax status to report on, or leave blank to report on all applicable tax regimes.
Tax Rate Code Low/High: The range of applicable tax rate codes to include in the report.
Exemption Status:Select a tax exemption status to report on.
Show Functional Amounts: Select whether to display report values in the ledger currency or the entered currency:
No - Display amounts in the entered currency. The report groups transactions by currency code and provides a row heading to display the currency for each set of transactions.
Yes - Display the functional amount of each transaction, using the exchange rate of the transaction.
Include options: Set the options to Yes for the transactions that you want to include in this report.
Use the Tax Audit Trail report to review tax information for posted or partially posted invoices. This report provides detail tax and invoice information and the total amounts for each tax rate code in the invoice currency and ledger currency. The report lists, for each tax rate code, distributions of all posted or partially posted invoices. The report includes, for each invoice, both the tax amount and the invoice amount subject to tax.
Start/End Accounting Period: The accounting periods to include in the report.
Begin/End Invoice Date: The invoice date range for the report.
Tax Regime Code: Select a tax regime to report on, or leave blank to report on all applicable tax regimes.
Tax: Select a tax to report on, or leave blank to report on all applicable taxes.
Tax Jurisdiction: Select a tax jurisdiction to report on, or leave blank to report on all applicable tax regimes.
Tax Status Code: Select a tax status to report on, or leave blank to report on all applicable tax regimes.
Tax Rate Code Low/High: The range of applicable tax rate codes to include in the report.
Report Order By: Select the option to use to sort the information.
Include options: Set the options to Yes for the transactions that you want to include in this report.
Use the Tax-Only Open Invoices Report to review invoices where all amounts have been paid or credited except the tax amount. These are invoices where the tax amount may be in dispute. You use this report to highlight potential problems.
Order By Open Invoices: Select the value to sort by: Customer, Invoice Date, Invoice Number.
Invoice Date Low/High: The invoice date range to include in the report.
Customer Name: The customer name for the invoice.
Invoice Date: The invoice date. This is typically the date you create the invoice.
Days Overdue: The number of days the uncollected tax amount is past due.
Original Amount: The original tax charges for this invoice.
Amount Outstanding: The unpaid amount of tax for this invoice.
Amount Outstanding Grand Total: The total outstanding tax amount for the invoices on this report.
Use the VAT Exception Report as part of your VAT reconciliation to review any Receivables subledger transactions which meet one or more of the following VAT exception criteria:
The transaction has item lines with no accompanying tax lines.
To accommodate most VAT requirements, every miscellaneous cash receipt should have a tax rate code associated with it and output VAT liability should be manually accounted for using the Tax Reconciliation Report.
The transaction has item lines that reference General Ledger tax accounts.
Only tax transaction lines should be posted to tax accounts in the General Ledger.
The transaction is a Discount that references General Ledger tax accounts.
Only tax transaction lines should be posted to tax accounts in the General Ledger.
The transaction is an Adjustment that references General Ledger tax accounts.
Only tax transaction lines should be posted to tax accounts in the General Ledger.
The transaction is a Miscellaneous Receipt that references General Ledger tax accounts.
Only tax transaction lines should be posted to tax accounts in the General Ledger.
The transaction is a Miscellaneous Receipt which has no tax rate code.
To accommodate most tax reporting requirements, every VAT taxable transaction must include a tax line even if the value of the tax line is zero.
The transaction is an Adjustment of type Tax.
Tax only Adjustments are not advised in a VAT reporting environment because they are generally not accepted as valid reductions to your VAT liability.
Note: Chargebacks and Commitments are created without tax lines and will always appear on the VAT Exception Report.
You should correct every transaction on this error report or manually calculate the impact to your return before completing your VAT reconciliation.
Line Number: This column shows the transaction line number, but is empty for these transactions:
Adjustments
Discounts
Miscellaneous Receipts
Transaction Amount: This column shows the amount of the transaction in the entered currency.
Status: This column reports the reason the transaction is an exception. The column displays these warning messages:
No Tax Line - The transaction has item lines with no accompanying tax lines.
Using Tax Account - The transaction is not a tax transaction, but it references General Ledger tax accounts.
Tax Adjustment - The transaction is an Adjustment of type Tax.
Use this report to review your tax liability to the various tax authorities around the US. The US Sales Tax report includes all invoices, credit memos, and adjustments sorted by ship-to state, county, and city and lists taxable, exempt, and tax amounts. This report is used as the basis for the periodic sales tax returns required by each state. This report provides all of the transaction detail from your Receivables subledger to let you to reconcile these returns against your General Ledger balances. In addition, a summary is provided of the total amount exempt for each reason. The US Sales Tax report supports only accrual basis reporting and is only used for United States sales tax.
Reporting Level: Select a reporting level, Ledger or Operating Unit.
Reporting Context: Defaults based on reporting level chosen.
If you entered Ledger for the Reporting Level, the default is the ledger associated with your responsibility.
If you entered Operating Unit for the Reporting Level parameter, select an operating unit from the list of values.
Note: The profile option MO: Operating Unit determines the operating unit for your responsibility.
Transaction Date Low: Enter the starting date of the transaction date range.
Select and print sales tax information for the transaction date range you specify. This field is optional. If you specify a transaction date range but no GL date range, your report will not balance to the General Ledger if the transaction and GL dates for a transaction fall in different periods.
Note: For adjustment transactions, the transaction date refers to the transaction date of the invoice to which the adjustment applies
Transaction Date High: Enter the high ending date of the transaction date range.
GL Date Low: Enter the starting GL date for the GL date range.
Select and print sales tax information for the GL date range you specify. The default is the first and last date of the prior accounting period. Use a GL date range to enable you to balance your US Sales Tax report against your General Ledger.
Warning: If you specify both a GL date range and a transaction date range, transactions with transaction and GL dates in different periods will not be printed in the report.
GL Date High: Enter the ending GL date for the GL date range.
State Low: Enter the low range value for state.
The state information is generally derived from the ship–to–address of the transaction. If the ship–to–address is blank, Receivables derives the state information from the transaction’s bill–to address.
State High: Enter a high range value for state.
Currency Low: Enter the range value for currency.
Select and print sales tax information for the currency range you specify.
Currency High: Enter the high range value for currency.
Exemption Status: Select an exemption status:
Discontinued
Manual
Primary
Rejected
Unapproved
Enter an exemption status if you want the report to only list transactions which reference exemptions with that status. You can find all transactions using rejected exemptions by entering Rejected here.
Sales Tax Liability Account From: Enter the low range value for the sales tax liability account.
This parameter only restricts Receivables Adjustment transactions. An Adjustment transaction is a Receivables feature that lets you increase or decrease the amount due of your invoice, debit memo, chargeback, deposit or guarantee. The report will exclude any Adjustment transactions posted to accounts outside the selected range. Invoice, Debit Memo and Credit Memo transactions that post to a general ledger account outside the selected account range are included in the report, but are tagged with an asterisk (*) in the footnote column. If no range is selected, all Adjustments will be displayed and no transactions will be tagged.
Sales Tax Liability Account To: Enter the high range value for the sales tax liability account.
Detail Level: Select a detail level for the report
Report eXchange Header Level: This option lets you use the Report eXchange (RX) client to include transaction header level amounts in this report. If you choose this option, this report generates one line per transaction with only the Total Lines Amount and Total Tax Amount fields showing transaction level totals.
Report eXchange Line Level: This option lets you use the Report eXchange (RX) client to include transaction line level information in this report. If you choose this option, this report generates one line per transaction line and populates each line attribute for the RX client.
Show Summary: To see a summary of the total tax for transactions within each state, county and city. No transaction detail is printed.
Show Summary and Invoices: To see the information generated by the Show Summary option plus a summary of each transaction within a tax authority.
Show Summary, Invoices and Lines: To see the information generated by the Show Summary and Invoices option, plus a breakdown of each transaction line.
Show Summary, Lines-Brief Format: To see a condensed version of your transaction line information and tax totals on one printed line of the report.
Total for State: To see a single state total on each printed page of the report.
Order By: Select the option to use to sort your information. The report will first sort by tax authority and then by one of the following sort options that you select:
Customer Name
Customer Number
Exempt Reason
Invoice Date
Invoice Number
Transaction Type
Transfer to GL: Select what should be transferred to GL:
All
Not Transferred
Transferred