Accounts payable aging not balanced with trial

[chillax_90]

So I got a head scratcher right here. i have working on this AP Aging report trying to reconcile it with the Trial Balance AP. what could I have missed?
and maybe you can also share what are your best practices when it comes to issues like this?

 

[chrishemsnorth]

Check for manual journal entries posted straight to the AP control, those won't show on the aging report, then no vendors should be linked to GL accounts that bypass the subledger. I log everything and reconcile often to catch issues early.

 

[SlightlyLost]

what could I have missed?

have you checked the manual GL entries? yeah, this is usually the #1 culprit. Did anyone post directly to the AP GL account, bypassing the AP module? This immediately throws things off

 

[newyorkcheesecake]

So I got a head scratcher right here. i have working on this AP Aging report trying to reconcile it with the Trial Balance AP. what could I have missed?
and maybe you can also share what are your best practices when it comes to issues like this?

Hahaha... I've been there more times than I care to admit. Do verify old credits or manual journal entries that didn't flow through AP. So how I go about it is I pull vendor-level detail and matching it line by line.