Miscellaneous Accrual Reconciliation Report

The purpose of this report is to show all inventory and AP (not matched to PO) transactions that have hit the accrual accounts. Transactions are grouped by accrual code. The report can be run either in summary where only the distribution information and balance is shown or in detail where all the transaction that make up a particular distribution are shown as well.

Usually this report is run in conjunction with the Summary Accrual Reconciliation Report as part of your period end accrual reconciliation process. See: Overview of Receipt Accounting

Prerequisites

If you install Oracle Purchasing and Oracle Payables, you can run this report. If you accrue expense purchases on receipt, you can reconcile your expense AP accrual account using this report. If you accrue expense purchases at period end and you do not perform inventory receipts, no information will be available to report.

Attention: Most commercial installations accrue expense receipts at period end because this information is not required as the receipt occurs. If you accrue expense purchases on receipt, you have more entries to reconcile in the AP accrual accounts.

Report Submission

In the Submit Requests window, select Miscellaneous Accrual Reconciliation Report in the Name field.

Report Parameters

Operating Unit

Select the operating unit for the report.

Title

Enter your title for the report.

Sort By

Parameter to specify how to sort the data at the distribution level (independent of summarization parameter)

Valid Values: Item, Transaction Date (default), Amount.

Date From

Starting date of time period to display for this report.

Date To

Ending date of time period to display for this report.

Item From

Lower limit of item range to consider for this report.

Item To

Upper limit of item range to consider for this report.

Min Amount

Lower limit of transaction amount to display.

Max Amount

Upper limit of transaction amount to display.

Balancing Segment From

Lower limit of balancing segment range to consider for this report.

Balancing Segment To

Upper limit of balancing segment range to consider for this report.

Related Topics