How to reconciled AP Trial Balance with Payable Transactions for a period

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);

  1. Now run following reports within Oracle payables
  1. Accounts Payable Trial Balance (End of Nov-17)
  2. Payables Posted Invoice Register (for that account and for the month of Dec-17)
  3. Payables Posted Payment Register (for that account and for the month of Dec-17)
  4. Accounts Payable Trial Balance (End of Dec-17)
  1. Perform following calculations
  1. Accounts Payable Trial Balance (End of Nov-17) Remaining Amount
  2. Add : Payables Posted Invoice Register (for that account and for the month of Dec-17) (Accounted Credit-Accounted Debit) 
  3. 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)

  1. 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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s