Periodic Accrual Reconciliation Report

Use this report to view detailed accounting entries in A/P accrual accounts for certain legal entity, cost type and organization cost group in a period.

The report is available in two versions:

The Periodic Accrual Rebuild Reconciliation Report collects all accounting entries from appropriate subledgers and stores them in a temporary table. This accounting information resides in a temporary table and remains until you rebuild this information again.

The Periodic Accrual Reconciliation Report uses the information stored in the temporary table by the last Periodic Accrual Rebuild Reconciliation Report. When you specify Accrual Reconciliation Report, the report does not reselect this information. Instead, it merely reports using the pre-existing information. This feature saves you time, because you do not have to recreate the accrual information every time you submit a report. Typically, you specify the Accrual Rebuild Reconciliation Report at month end and use the Accrual Reconciliation Report for interim reports.

With the Application Technology Multi-Organization Access Control (MOAC), the SRS window for this report includes an Operating Unit List of Values that lists the Operating Units attached to the Responsibility's Security Profile.

Report Submission

In the Submit Requests window, select the report name. You can choose either report. The parameters are the same.

Report Parameters

Sort By

Choose either of the following options:

Title (Optional)

Enter a title

Legal Entity

Select a legal entity

Cost Type

Select a cost type

Cost Group

Select an organization cost group

Period

Select a period

Items From / To (Optional)

To restrict the report to a range of items, select a beginning and an ending item.

Vendors From / To (Optional)

To restrict the report to a range of vendors, select a beginning and an ending vendor.

Include All Transactions

Enter Yes or No to indicate whether you want to print zero balance purchase order line subtotals on the report. The report adds up all receipts and invoices by purchase order line. When you specify Yes and the net purchase order line amount is zero, the report prints all receipt or invoice entries for that line. When you specify No, the report considers the Transaction Amount Tolerance and Transaction Quantity Tolerance parameters. When you choose the Accrual Rebuild Reconciliation Report, the default is No. When you choose the Accrual Reconciliation Report, the default is Yes.

Suggestion: To minimize the size of the report, you should specify No for this option. However, if you want to see all accrual entries, you should specify Yes.

Transaction Amount Tolerance

If you selected No for Include All Transactions, specify the net amount below which purchase order line transactions are not included in the report.

Transaction Quantity Tolerance

If you selected No for Include All Transactions, then specify the net quantity below which transactions are not included. This condition is checked only if the transaction amount tolerance is satisfied.

Dynamic Quantity Precision

Select the quantity precision.

Include Written Off Transactions

Enter Yes or No to indicate whether you want to print written off entries on the report. When you specify Yes, an asterisk appears in the far right column to indicate a written off transaction. By selecting No, you decrease the report size. The default is No.

Aging Number of Days (Optional)

Enter the number of days you would like the report to group information. For example, if you enter 60, for 60 days, then the report first groups all purchase order lines that have the earliest transaction date in the past sixty days, and then groups the next set of lines with the earliest transaction date from 60 to 120 days, and so on. If you do not specify a number, then the report displays all receipts and invoices together. This report parameter helps you separate your older activity from your current activity. When you enter a number of days, a subheading appears on the report to indicate the to and from range of days for each group of information.

See: Writing Off Accruals