You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Compare balances originating from many external sources

in Account Reconciliation

Summary:

We have many external source systems that are going to generate accounting entries into Oracle GL. At the end of the month, each external system is going to send a reconciliation file with the aggregated balances for the period for each account code combination. Each external system can be distinguished through a unique COA segment value.

We are then going to compare the aggregated balances in the external systems with the corresponding aggregated balances in GL in ARCS.

We want to compare on the basis of Company- Natural Account. However, natural accounts are not uniquly tied to each external system so to get an accurate comparission of account X we need to pull the balance of account X from GL but also from Oracle subledgers + external systems into one reconciliation.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!