difference GL <> AP subledger 2

[johnhugh]

Hi,

I'm using Accpac 5.5.
How would I go about to find out why my AP account in GL has a higher balance than my AP ageing in the subledger?
I checked for journal entries in the GL account but couldn't find any.

 

[ettienne]

Check the dates for the AP aging.
I always run an AP aging for the end of the year and compare to the GL balance at the end of the year - you may have future dated transactions. Otherwise it is a reconciliation exercise between AP and GL.

 

[johnhugh]

Thanks ettienne.
I ran for end of year but no luck.

What report in AP would be best suited for reconcilliation with GL?
Vendor Transactions?

 

[ettienne]

AP open payables.
Give it to the accountant to reconcile... that's why they get the big bucks.

 

[johnhugh]

Thanks again.

 

[ettienne]

Just another thought... I did a similar exercise a couple of months ago. You can print a summary AP open payables report at the end of each period and compare the balance with the GL, figure out in which period the balance went out and then take it from there. My approach was to check the balance at each year end to establish in which year it went out, then I took a stab at mid year to see if it was in the first half or second half of the year and narrowed it down from there.

 

[DjangMan]

Export the GL transactions in your AP account to Excel (from GLPOST). Sort by reference and see if you have any ins and outs. I've seem people reverse a GL batch thinking that it would flow all the way back to the AP sub-ledger.

The hardest things to track down are GL batches that were deleted and when AP is set up to append to an open GL batch.

Also - the AP posting journal reports have a date on them that should batch the GL batch date - that will be the date the batch was posted which will be separate from any fiscal/posting dates within the batch itself.

 

[johnhugh]

Thank you for the great feedback.