Reconcile A/P Aging and A/P GL acct

Posted By JStringer over 4 years ago

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!

Top Replies

JStringer over 4 years ago in reply to compbiz +1

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…

0 compbiz over 4 years ago

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 JStringer over 4 years ago in reply to compbiz

Unfortunately neither report returned any useful information.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 JStringer over 4 years ago 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!
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 50 US

Reconcile A/P Aging and A/P GL acct

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING