Reconcile A/P Aging and A/P GL acct

I'm tasked with reconciling the A/P aging report with the A/P GL account on the Balance Sheet.  Going way back in time, the last date that it was balance was 07/2019.  Does anyone have any tips on an easy way to reconcile the two totals?  I've have found a few issues by luck but at the rate I'm going it will takes weeks to sort out.  I've tried every variation of reports and none really help me. Thanks!

Parents
  • 0

    Try running an Internal Accounting Review -- there are 2 checks there that may help:   1) It checks for Purchases or Bills that do not credit an AP account; 2) It checks for Transactions that debit and credit the same general ledger account

  • 0 in reply to compbiz

    I did figure out a way to narrow my search.  I wasn't even thinking about the Trial Balance and the fact that it can be ran by date vs. period so running it and the A/P Aging for the same dates I'm able to pinpoint the exact day that the error occurred.  It's not a perfect solution, still very time consuming, but it is better than nothing at this point.  Thanks!

Reply
  • 0 in reply to compbiz

    I did figure out a way to narrow my search.  I wasn't even thinking about the Trial Balance and the fact that it can be ran by date vs. period so running it and the A/P Aging for the same dates I'm able to pinpoint the exact day that the error occurred.  It's not a perfect solution, still very time consuming, but it is better than nothing at this point.  Thanks!

Children
No Data