Assets Reconciliation Reports

This topic includes details about the Assets reconciliation reports.

Overview

The Assets Reconciliation reports are designed to reconcile journal entries to your general ledger accounts.

Assets reconciliation reports include:

Report Name

Description

Cost Clearing Reconciliation Report

Lists all asset additions and cost adjustments performed during the specified period for which accounting entries are created for cost clearing accounts. The report is sorted by and groups totals for each transaction type, balancing segment, and clearing account.

Cost Detail Report

Lists asset-level asset cost account balances for the specified periods. The report is sorted by and groups totals for each balancing segment, asset cost account, and cost center.

Cost Summary Report

Lists asset cost account summary balances for the specified periods. The report is sorted by and groups totals for each balancing segment and asset cost account.

Journal Entry Reserve Ledger

Lists asset depreciation amounts for the specified period. The report is sorted by and groups totals for each balancing segment, expense account, reserve account, and cost center.

CIP Detail Report

Lists asset-level construction-in-process (CIP) cost account balances for the specified periods. The report is sorted by and groups totals for each balancing segment, CIP cost account, and cost center.

CIP Summary Report

Lists CIP cost account summary balances for the specified periods. The report is sorted by and groups totals for each balancing segment and CIP cost account.

Reserve Detail Report

Lists asset level asset reserve account balances for the specified periods. The report is sorted by and groups totals for each balancing segment, reserve account, and cost center.

Reserve Summary Report

Lists reserve account summary balances for the specified periods. The report is sorted by and groups totals for each balancing segment and reserve account.

Revaluation Reserve Detail Report

Lists asset revaluation reserve account balances for a specified period for an asset level. The report is sorted by and groups totals for each balancing segment, asset cost account, and cost center.

Revaluation Reserve Summary Report

Lists asset level revaluation reserve account balances for the specified periods. The report is sorted by and groups totals for each balancing segment, reserve account, and cost center.

Asset Balances Register Report

Lists initial costs, current reserve, year-to-date amounts, depreciation rules, and retirements for a range of assets for the specified corporate book and for each associated tax book. The report sorts the data by asset number.

Asset Register Report Lists the cost-related details, current activity, and retirements for every asset within the selected asset category. The report also lists all transactions that impact asset cost during the chosen period.

Asset Leases Expense Report

Lists asset lease interest and expense amounts for the specified period. The report sorts by and groups totals for each balancing segment, expense account, and cost center.

Asset Leases Liability Report

Lists asset lease liability for the specified period. The report sorts by and groups totals for each balancing segment, liability account, and cost center.

Asset Cost and Reserve Report

The Asset Cost and Reserve Report lists the asset cost and depreciation reserve balances at the asset or cost center level. The report sorts and totals by category, asset type, asset cost account, and cost center. You can run the report only for closed periods.

The following table describes selected report parameters:

Name

Description

Book

Use this parameter to specify the book to be included for reports.

Currency

Use this parameter to specify the currency to be included for reports.

From Asset Number and To Asset Number

Use these parameters to enter the asset number range for which you want to run the report.

Period

Use this parameter to specify the period to be included for reports.

Frequently Asked Questions

The following table lists frequently asked questions about the Asset reconciliation reports:

FAQ

Answer

How do I find these reports?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

When do I use these reports?

Use these reports to:

  • Review your asset transactions to make sure they're being accurately posted.

  • Keep track of your assets, and to reconcile Oracle Assets to your general ledger.

How do I reconcile journal entries to Oracle General Ledger accounts?

Use the Unposted Journals Report in Oracle General Ledger to match General Ledger batch totals with the asset batch totals found in the Subledger Accounting Account Analysis report.

How do I change the default report format?

To change from Oracle Business Intelligence Publisher (BI Publisher), edit the fixed asset catalog and choose the output format from the layout table in the view list.