Using Spreadsheets for Tax Transaction Entry

Depending on the type of tax transactions you're entering, use one of the taxable transaction spreadsheets or the Tax Entry Repository Data Upload spreadsheet to upload your tax transaction data.

These spreadsheets let you enter simple taxable journals to high volume transactions from external applications containing customers, suppliers, and other tax attributes for tax calculation.

Using spreadsheet-based entry options and existing tax configuration, you can calculate, account, and centrally report transactions taxes for tax on journals and transactions that are created in proprietary applications that are not from Oracle.

Taxable Transaction Spreadsheets

Use the taxable transaction spreadsheets online or offline to enter taxable journal and taxable transaction data. You can enter transaction data for simple tax on journals to complex rule-based tax calculation. These ADF Desktop Integration spreadsheets provide some online validation and are intended for lower volume transaction entry.

Taxable transaction spreadsheets can be used for the following event classes:

• Purchase journal

• Purchase transaction

• Sales journal

• Sales transaction

The following table lists the event class and the journal category for the journal created for each of the event classes in the spreadsheet:

Event class and the journal category

Event Class in Taxable transaction spreadsheet	Event Class of the subledger journal entry	Journal Category of the subledger journal entry
Purchase journal	PURCHASE_TRANSACTION	Tax Purchase Transactions
Purchase transaction	PURCHASE_TRANSACTION	Tax Purchase Transactions
Sales journal	SALES_TRANSACTION	Tax Sales Transactions
Sales transaction	SALES_TRANSACTION	Tax Sales Transactions

Use the taxable transaction spreadsheets for the following types of entry:

Type of Entry	Usage	Access
Taxable journals	Purchase or sales journals using: Tax calculation or tax recovery determination Manual tax lines Ledger and legal entity-specific data	Navigator > Journals > Create Taxable Transactions in Spreadsheet
Taxable transactions	Purchase or sales transactions using: Tax calculation or tax recovery determination Manual tax lines Business unit-specific data Third-party customer or supplier details More robust set of tax attributes for tax determination Lower volume data	Navigator > Journals > Create Taxable Transactions in Spreadsheet

List of Value for Accounts

Use the lists of values in the Debit Account and Credit Account columns of the Create Taxable Transactions and Correct Taxable Transactions spreadsheets. These spreadsheets are used to create taxable journals or transactions in Oracle Fusion Cloud ERP, for transactions from external applications, and contain customer, supplier, and other tax attributes for tax calculation.

The list of values for these fields allows you to select a particular account code combination, improves the user experience, and reduces the possibility of making errors.

Double-click on the Debit Account or Credit Account field columns to open the accounts list of values. You can search by specifying the values for one or more accounting flexfield segments and choose a specific account code combination from the search results.

Tax Entry Repository Data Upload Spreadsheet

Use the Tax Entry Repository Data Upload spreadsheet for simple to complex tax data distributions. This spreadsheet is typically intended for high volume imports.

Note: You can load the spreadsheet data to an interface table using the predefined Tax Entry Repository Data Upload Spreadsheet and the Load Interface File for Import scheduled process, which are both part of the External Data Integration Services for Oracle Cloud feature. For more information about file-based data import, see the File Based Data Import for Oracle Financials Cloud guide.

Use Tax Entry Repository Data Upload spreadsheet for the following type of entry:

Type of Entry	Usage	Access
Taxable transactions	Purchase or sales transactions using: Third-party customer or supplier details Specific item distributions for more complex accounting requirements Tax distributions for specific recovery scenarios from external systems Summary tax line allocations to support scenarios beyond prorated allocation of purchase transaction tax Higher volume data	Download the Tax Entry Repository Data Upload Interface spreadsheet for Oracle Fusion Applications. Follow the instructions on the Instructions and CSV Generation tab to process your spreadsheet data.