ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> A/R Aging and GL unbalance
http://www.istechforum.com/YaBB.pl?num=1240500103

Message started by Juan on 04/23/09 at 08:21:43

Title: A/R Aging and GL unbalance
Post by Juan on 04/23/09 at 08:21:43

Our GL receivables and the A/R aging are not matching, does anyone here encounter this problem before and how do we get it in balance without affecting the cash total?
Thx
Juan

Title: Re: A/R Aging and GL unbalance
Post by Lynn_Pantic on 04/23/09 at 13:24:50

First make sure you are running AR-F saying N to include Deposits and that all transactions in GL-O areposted to verify that you are in fact out of balance between the two. Then run Aging and Balance sheet backdated to prior months to determine when it went out.

Then you can look in the GL for transactions posted to the AR account that are not RS (Sales) or CR (Cash Receipt) type. It is also possible that smebody entered an AR Voucher and designated it as Beginning Balance which would hit Aging but not GL, or they entered an AR Voucher but posted the GL to the AR account rather than a sales or expense account which would also have the effect of hitting the aging but a net 0 amount to the GL.

Title: Re: A/R Aging and GL unbalance
Post by Juan on 04/23/09 at 14:11:22

Our problem is that the receivables on the Balance sheet is overstated

Title: Re: A/R Aging and GL unbalance
Post by martel-carol on 05/13/09 at 07:11:41

I am having just the opposite. Our AP ageing is more than the GL amount; and the GL amount is correct. The Ageing goes back to the beginning of our database (1999)

Title: Re: A/R Aging and GL unbalance
Post by Laura Oliver on 03/04/22 at 08:48:38

AR-F doesn’t match line on Balance Sheet. AR-F shows 3625.00 more than the balance sheet.

The problem is that 3 invoices totaling $3625.00 somehow went to the GL with a date of 1-3-22 rather than 12-31-21. The invoice date of 12/31/21 is correct in BKARHINV. The only problem I found was that the BKGL.TRN.INVC (BKGL.TRN.DATE) is 1/3/2022. I changed the dates in maintain database to 12/31/21 but AR-f is still $3625 more than my balance sheet.

Anybody know what is causing this? What other files in maintain database should I look for to change date?
Thanks
Laura

ref: 157940. 157941 175942

Title: Re: A/R Aging and GL unbalance
Post by AllanMac on 03/06/22 at 16:03:21

Wouldn't you need to post a GL transaction (by GL Journal in GL-B) for the $3625 with a transaction date of 31 December 2021? Then reverse the transaction on 1st January 2022. I presume your sales revenue is correspondingly understated by $3625.

I would be wary of making changes to the GL tables through Maintain Database.

Title: Re: A/R Aging and GL unbalance
Post by Laura Oliver on 03/09/22 at 15:21:14

I may be jinxing myself but I have made changes thru maintain data base of years with no problem.

This year I made an email entry to my CPA explaining the situation. I will him instruct him to add the $3625 to my 2021 sales. I assume I will need to remind him to subtract the $3625 from my 2022 sales.

The main thing is I really really would like to know what caused this? I don't want this to ever happen again.

Thanks,
Laura