AP GL Reconciliation-How TO?

I am a very new user and am trying to reconcile my AP GL balance to my AP Aged Invoice and AP Trial Balance.  What are the steps to do so?  In previous systems I have used, you could reconcile an account like this by reviewing the "schedule" for lingering PO's or amounts that didn't clear out during the PO to Payable to Check process.  I can't figure out how to cross reference what I have as unpaid with what is sitting in the GL.

Thanks in advance!

  • 0

    You will want to reconcile the AP General Ledger Account (from GL Trial Balance); to the AP Trial Balance Report.  That is the one that is run by "transaction date" and will match to your General Ledger.  An Aging Report is based on invoice data instead, and not a good source report for reconciling the general ledger to a subsidiary module like Accounts Payable. 

    There will be nothing in Accounts Payable, on the AP Trial Balance that is not posted to the General Ledger. 

    To see the Purchases Clearing Dollars (Goods received, pending Invoice ); then from the Purchase Order Module, run the Purchases Clearing Report.  That should reconcile to your PO Clearing GL Account,.