ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> A/P & A/R Agings Do Not Match Balance Sheet
http://www.istechforum.com/YaBB.pl?num=1159981982

Message started by Doughmakers on 10/04/06 at 09:13:02

Title: A/P & A/R Agings Do Not Match Balance Sheet
Post by Doughmakers on 10/04/06 at 09:13:02

Since I can remember, our agings have not matched our balance sheet. The differences vary from month to month. We don't enter anything into the master A/P or A/R accounts, so I don't understand how the Balance Sheet could be out of balance with the agings. I need to know why this could be happening and how I could fix it. ;D

Title: Re: A/P & A/R Agings Do Not Match Balance Shee
Post by JNAPIER on 10/04/06 at 10:01:59

I have seen this when an entry has a future date, either Ap or AR. Print your agings as of 01-01-2010 or something like that. Make certain that all GL-O transactions have been posted also...

John

Title: Re: A/P & A/R Agings Do Not Match Balance Shee
Post by Lynn Pantic on 10/04/06 at 11:46:17

Also, for AR, make sure you are saying N to include Deposits as they belong to a different GL Account (Customer Seposits).

And check AD-A and AD-B and Item classes to be sure nothing else is posting there.

Finally, make sure nobody is entering the AR or AP account as the distribution account when entering vouchers.

Title: Re: A/P & A/R Agings Do Not Match Balance Shee
Post by wtsconnects on 10/04/06 at 13:56:48

We share this issue. Have been for a long time too. (I posted another set of problems today which came up as we were investigating this one.)

Based on some of my research of discussions, I'm wondering if non-matching problem is at all related to the issues of reversing recorded payments and the screwy postings that often happens.

Any thoughts?

Title: Re: A/P & A/R Agings Do Not Match Balance Shee
Post by wtsconnects on 10/04/06 at 13:59:27

Title: Re: A/P & A/R Agings Do Not Match Balance Shee
Post by Doughmakers on 10/05/06 at 06:43:32

I have checked the AD-A and the AD-B defaults and they look fine. I also printed the agings without the deposits. No one has entered anything into the AP or AR accounts. I have already ran detail reports af those accounts to check for that possibility. What else could it be????? :-/

Title: Re: A/P & A/R Agings Do Not Match Balance Sheet
Post by wontonsnowy on 02/22/07 at 07:58:39

I've also experienced the same problem - it could be from voiding cks - i have items showing up on the aged ap that you can not see in the AP-F . Try manually checking your open AP against your physical invoices to verify that all is truely open that appear on the aged AP. you may find your answer there. Good luck