My Oracle Support Banner

How to Run the AP and PO Accrual Reconciliation Report (Doc ID 2400564.1)

Last updated on FEBRUARY 27, 2024

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.


This note provides basic step to setup and run the AP and PO Accrual Reconciliation Report

Excerpt from the Oracle Purchasing User's Guide - Chapter 14 - Reports

The purpose of this report is to show all Oracle Payables (AP) and Oracle Purchasing
(PO) transactions where the AP transactions are matched to PO (could be receipt as
well). The AP and PO Accrual Reconciliation Report provides a transactional
breakdown of each accrual account with a net balance not equal to zero in a
summarized or full transaction details version. In summarized mode, for each accrual
account, only the distribution information and PO, AP, WO (Write-Off) and Total
Balances are displayed. For detailed mode, the individual transaction details for each
distribution are also shown.

You can also see the age of the distribution on this report. Age of the distribution is
calculated based on the value of a system profile "CST: Age in Days". If this profile is set
to "Last Receipt Date", then age is calculated based on the date of the latest receipt
transaction corresponding to this distribution. If the profile is set to "Last Activity Date"
then age is calculated based on date of the latest invoice or receipt transaction
corresponding to this distribution.

The report is first grouped by accrual account, then by aging bucket and then by
purchase order distribution ID. Aging bucket is calculated depending on user specified
value of "Aging period days" while submitting the report. Transactions are grouped
according to their age into aging buckets.

Usually this report is run in conjunction with the Summary Accrual Reconciliation
Report as part of your period end accrual reconciliation process


For more detailed information, view the associated notes, and the Oracle Purchasing User's Guide 


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.