How to reconcile AP Trial Balance with Payable Transactions for a given period
Get the output of the following for account and period where the difference was observed (In Detail);
- Now run following reports within Oracle payables
- Accounts Payable Trial Balance (End of Nov-17)
- Payables Posted Invoice Register (for that account and for the month of Dec-17)
- Payables Posted Payment Register (for that account and for the month of Dec-17)
- Accounts Payable Trial Balance (End of Dec-17)
- Perform following calculations
- Accounts Payable Trial Balance (End of Nov-17) Remaining Amount
- Add : Payables Posted Invoice Register (for that account and for the month of Dec-17) (Accounted Credit-Accounted Debit)
- Minus :Payables Posted Payment Register (for that account and for the month of Dec-17) (Accounted Debit-Accounted Credit)
= Expected Closing Balance of Accounts Payable Trial Balance (End of Dec-17)
- Confirm this calculated balance matches with Accounts Payable Trial Balance (End of Dec-17)
If there is any difference then you may refer Oracle Doc ID 758531.1 for further analysis