Reconciling Cash Clearing Account in GL Journal Entry
For ADP payroll, we are interfacing the Journal Entries into GL. However the account used is Cash Account(and not Cash Clearing). But what we want is to route these entries through Cash Clearing Account(similar to other subledgers). But as per standard Oracle, Journal Entries with Cash Clearing Account do not show up in Cash Management module for reconciliation.
So the requirement is:
Through Interface:
Expense..Dr
To Cash Clearing
After Reconciliation(this is where te issue is)
Cash Clearing..Dr
To Cash
Any suggestions as how to achieve this since I am guessing this may be a common requirement when we interface payroll entries directly to GL and then reconcile.