Welcome, Guest. Please Login.
04/28/24 at 14:22:06
News:
Home Help Search Login


Pages: 1
Send Topic Print
A/R Aging and GL unbalance (Read 1036 times)
Juan
Full Member
***


I love YaBB 1G -
SP1!

Posts: 105
A/R Aging and GL unbalance
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
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: A/R Aging and GL unbalance
Reply #1 - 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.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Juan
Full Member
***


I love YaBB 1G -
SP1!

Posts: 105
Re: A/R Aging and GL unbalance
Reply #2 - 04/23/09 at 14:11:22
 
Our problem is that the receivables on the Balance sheet is overstated
Back to top
 
 
  IP Logged
martel-carol
Member
**




Posts: 75
Re: A/R Aging and GL unbalance
Reply #3 - 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)
Back to top
 
 
  IP Logged
Laura Oliver
Active Member
*****




Posts: 984
Gender: female
Re: A/R Aging and GL unbalance
Reply #4 - 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
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
AllanMac
Browser
*




Posts: 24
Re: A/R Aging and GL unbalance
Reply #5 - 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.
Back to top
 
 
  IP Logged
Laura Oliver
Active Member
*****




Posts: 984
Gender: female
Re: A/R Aging and GL unbalance
Reply #6 - 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
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Pages: 1
Send Topic Print