ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> Bal. Sheet and AP Aging are off
http://www.istechforum.com/YaBB.pl?num=1416601195

Message started by JereC on 11/21/14 at 13:19:55

Title: Bal. Sheet and AP Aging are off
Post by JereC on 11/21/14 at 13:19:55

I am trying to correct an old AP entry. Right now the Balance Sheet shows more than the AP aging. What is the best way to fix this? AP-A shows an invoice to pay, AD-F does not show anything due and does not show up on the AP aging. Should I delete this from the maintain data base, or a journal entry? Would like to fix this correctly and not have a trail of errors in getting aging and bal. sheet to balance.

Thanks

Title: Re: Bal. Sheet and AP Aging are off
Post by Lynn_Pantic on 11/21/14 at 15:58:51

If it is not on the aging and AP-F does not show it as available to pay, what is there to get rid of? What do you mean AP-A shows an invoice to pay?

Title: Re: Bal. Sheet and AP Aging are off
Post by JereC on 11/24/14 at 14:43:04

Sorry I know this did't make sense so let me start over. We have to separate error both on the same customer. Both problems initiated with a Deposit on Account and a refund.

The first problem is the AR aging vs the Balance sheet do not match and is off by the amount of the refund. the Balance sheet shows more money. The Trial Balance entries are:

DR. CR.
AR 488.40
AP 488.40
CUST. DEP. 488.40
CUST. DEP. 488.40

Even though this was supposed to be a refund there was never a check written for this but there is no open invoice

The second problem is the Customer Deposit Aging Report shows a deposit of $831.60 but the aging says used up. Even though the DEP Rem is zero my boss wants this cleared off the report. The Trial Balance entries are the same as above only for $831.60. There was a check written for this amount.

I have inherited this problem and need to get it cleared off the books and at this point I am not sure how to correct either entry.

Thanks.