How Previous Year Tax Report Import Data Is Processed

Use the Import Previous Year Tax Report Data template to import and store the previous year's tax report data for Japanese Depreciable Assets Tax Reports.

To access the template, complete the following steps:

1. Navigate to the File-Based Data Import for Oracle Financials Cloud guide.

2. In the Table of Contents, click File-Based Data Imports.

3. Click Import Previous Year Tax Report Data.

4. In the File Links section, click the link to the Excel template.

Follow these guidelines when preparing your data in the worksheet:

• Enter the required information for each column. Refer to the tool tips on each column header for detailed instructions.

• Do not change the order of the columns in the template.

• You can hide or skip the columns you do not use, but do not delete them.

Settings That Affect the Import Previous Year Tax Report Data Process

The Import Previous Year Tax Report Data import template contains an instructions tab, plus a tab that represents the table where the data is loaded:

Spreadsheet Tab	Description
Instructions and CSV Generation	Contains instruction information about preparing and loading data, the format of the template, submitting the Japanese Depreciable Assets Tax Reports process, and correcting import errors.
FA_DEPRNTAXREP_INTERFACE	Enter information about the previous year tax data, such as the fiscal year, cost, evaluated net book value, and the life in years.

You can import data using either of the following scenarios:

Scenario	Description
1	Import the cost, evaluated net book value, and theoretical net book value for the prior year. The import process calculates the evaluated net book value based on the net book value of the prior year. After running the Japanese Depreciable Assets Tax reports, the cost, evaluated net book value, and theoretical net book value are stored in the table. The import process checks the imported cost to determine whether it has increased or decreased.
2	Import only the cost for the prior year. The import process calculates the evaluated net book value from the start date using the asset cost. After running the Japanese Depreciable Assets Tax reports, only the cost is stored in the table. The import process checks the imported cost to determine whether it has increased or decreased.

How Previous Year Tax Report Data Is Processed

After you successfully load your data, you must submit the Japanese Depreciable Assets Tax Reports process to import the data into the application.

To submit the Japanese Depreciable Assets Tax Reports process:

1. Navigate to the Scheduled Processes page.

2. Click the Schedule New Process button.

3. Search for the Japanese Depreciable Assets Tax Reports process.

4. Click OK.

5. Select the book, fiscal year, From tax asset type, and To tax asset type.

6. For the Summary Report, select Yes or No.

7. For the All Assets Report, select 132 characters, 180 characters, or Not Specified.

8. For the Asset Additions Report, select 132 characters, 180 characters, or Not Specified.

9. For the Decrease Assets Report, select Yes or No.

10. Click Submit.