Welcome, Guest. Please Login.
05/28/25 at 13:04:45
News:
Home Help Search Login


Pages: 1 
Send Topic Print
HELP! (Read 1974 times)
kerric
Member
**


I love YaBB 1G -
SP1!

Posts: 98
HELP!
12/09/05 at 08:58:32
 
This is for Lynn please. Regarding my previous post about Fiscal Year End/Retained Earnings Post that you helped me with  cry
 
I ran GLEREDO, as you said.  What I feared would happen, did in fact happen.  
 
My balance sheet still does not balance. Only it's worse, because when the old one didn't balance, I could pinpoint the exact entry and amount.  Running GLEREDO didn't fix the problem.  It made it worse.  Now it is like a needle in a haystack to me.  
 
The GL Transactions for those YE Entries are now "in balance".  Before this utility, it was out of balance by the exact amount I was off on my balance sheet and my FYE Entries.  What in the world am I supposed to do now?  My boss has been after me to get him the balance sheet and this has made it even more late.  I need to get my year end process rolling.
Back to top
 
 
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: HELP!
Reply #1 - 12/09/05 at 14:28:21
 
Run GL-D for various blocks of dates and journal types to see where you are out of balance.  Once it is identified, let me know and I can tell you how to fix it.  It is slightly different depending whether you need an entry to a balance sheet or Imcome/expense account and whether it is the current or prior year.
Back to top
 
 

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


I love YaBB 1G -
SP1!

Posts: 98
Re: HELP!
Reply #2 - 12/12/05 at 06:31:46
 
Lynn, see the problem is;  all of my journals balance now.  Up to two years past.  Can't find where it's off now.  Prior to doing this, it was at least part of the YE entries for the most current FYE.
 
So, to summarize:  The Balance Sheet is off, the journals are not.  I ran it for all journals, for the last two fiscal year ends.
 
HELP
Back to top
 
 
Email   IP Logged
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: HELP!
Reply #3 - 12/12/05 at 07:05:25
 
Have you added any new GL accounts that are not set up on your balance sheet report. If ALL journals are in balance, the report should also balance if all accounts are set up in them.
 
John
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
kerric
Member
**


I love YaBB 1G -
SP1!

Posts: 98
Re: HELP!
Reply #4 - 12/12/05 at 08:49:34
 
You had me excited there a second.....
 
 
No, the accounts on the balance sheet match the chart of accounts exactly.  Triple checked.  
 
Back to top
 
 
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: HELP!
Reply #5 - 12/12/05 at 10:03:13
 
If all accounts are on the balance sheet in the proper place and no accounts are the wrong type (as in an expense account in the middle of the assets) and GL-D for ALL dates (not just back 2 years but from 00/00/00 through 00/00/00) balances, then you may need to run UT-K-D.
Back to top
 
 

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


I love YaBB 1G -
SP1!

Posts: 98
Re: HELP!
Reply #6 - 12/12/05 at 10:37:02
 
Can you tell me why running what you had me run drastically changed everything?  I'm afraid to run another utility.  Those years have been closed.
Back to top
 
 
Email   IP Logged
kerric
Member
**


I love YaBB 1G -
SP1!

Posts: 98
Re: HELP!
Reply #7 - 12/12/05 at 10:43:39
 
Let me clarify that - those years (throught 10/31/04) have been completely processed and our financials all balanced and tax returns all filed and ........
 
I really don't understand why the utility you had me run totally changed my balances all the way to the beginning of using DBA (FYE 10/31/02).  I can't possibly troubleshoot that far back.  I am done with those years and wish it to stay so.
Back to top
 
 
Email   IP Logged
kerric
Member
**


I love YaBB 1G -
SP1!

Posts: 98
Re: HELP!
Reply #8 - 12/12/05 at 11:02:49
 
Here is the verdict on all journals:
 
FY 11/01/01 - 10/31/02 is now:
 
(dr) 4,518,141.05  (cr) 4,518,569.11; NET:  (428.06)
 
FY 11/01/02 - 10/31/03 is now:
 
(dr) 11,709,614.82  (cr) 11,708,323.49; NET 1291.33
 
The net of these two amounts, $863.27 is the amount my GL is off.
 
It appears that the utility I ran affected my first two DBA years - the FYs subsequent to 10/03 journals balance.  How to fix a four year old error?  What is the purpose of running UT-K-D, I mean what will that impact?  I'm afraid it will send me on another odyssey - not fix the problem.
Back to top
 
 
Email   IP Logged
kerric
Member
**


I love YaBB 1G -
SP1!

Posts: 98
Re: HELP!
Reply #9 - 12/12/05 at 12:05:10
 
The ($1291.33) was an entry done incorrectly at the time we converted to DBA.  Without this entry, our GL will be out of balance.  
 
I'm still trying to figure the other $428.06.  
 
This seems to be a bit of a conundrum that has no ending.
Back to top
 
 
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: HELP!
Reply #10 - 12/12/05 at 14:06:57
 
UT-A, program EDITGL can be used to fix the entries.  Then UT-K-D and then you may need to run GLEREDO again.
Back to top
 
 

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


I love YaBB 1G -
SP1!

Posts: 98
Re: HELP!
Reply #11 - 12/13/05 at 04:42:15
 
Thank you, Lynn.
What do those utility programs actually do, or rather what is occurring when I run them?
Back to top
 
 
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: HELP!
Reply #12 - 12/13/05 at 09:03:33
 
UT-K-D recalculates all the monthly totals you see in GL-A for each account based on the detail transactions.
 
GLEREDO deletes all the YE closing entries to Retained Earnings and then recalculates new ones.
Back to top
 
 

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


I love YaBB 1G -
SP1!

Posts: 98
Re: HELP!
Reply #13 - 12/14/05 at 12:03:56
 
Thank you, I really appreciate your help.  
 
The concern I have with running them is that we have filed our tax returns based on the financials for those years (2002-2004).  From what you are saying, it sounds like the totals may change.  
 
This doesn't sound like a good idea to me.  Is there some utility I should have been running all this time, monthly, annually, or otherwise that would prevent this?  I still understand why the first error occurred.
 
  I'm not trying to be difficult, but I do wish to understand what is happening and how I could have avoided it?  We are holding up our Year-End until this is fixed.  I feel caution is definitely warranted here.
Back to top
 
 
Email   IP Logged
shadowcaster
Active Member
*****


I'm not here because
I know what to do.

Posts: 678
Gender: male
Re: HELP!
Reply #14 - 12/14/05 at 12:25:32
 
My GL was a mess so I ran these programs
 
do they only work in classic ?
 
I ran Gl-K-D and GLEREDO
 
im not sure what it did but the account was happy
 
J Dub
Back to top
 
 
WWW   IP Logged
shadowcaster
Active Member
*****


I'm not here because
I know what to do.

Posts: 678
Gender: male
Re: HELP!
Reply #15 - 12/14/05 at 12:45:31
 
Now Im told we have the same problem all journals ballence but the GL is off by 19 bucks or something
 
its an adventure
 
J Dub
Back to top
 
 
WWW   IP Logged
kerric
Member
**


I love YaBB 1G -
SP1!

Posts: 98
Re: HELP!
Reply #16 - 12/14/05 at 12:48:57
 
Thank you Shadowcaster, that is encouraging.  It didn't affect your prior year financials?
Back to top
 
 
Email   IP Logged
kerric
Member
**


I love YaBB 1G -
SP1!

Posts: 98
Re: HELP!
Reply #17 - 12/19/05 at 07:03:54
 
So, Lynn.  With what Shadowcaster says, do you still say that is the way to go?  How do you find something like his/her $16 off for all of your fiscal years?  It just seems there should be an easier way.
Back to top
 
 
Email   IP Logged
kerric
Member
**


I love YaBB 1G -
SP1!

Posts: 98
Re: HELP! THE SAGA - 12/19
Reply #18 - 12/19/05 at 08:36:09
 
Hello again.  The epic battle between Beginning balances and Balance Sheets is still going.  Beg. Balances is winning (not good).
 
I ran UT-K-D and then GLEREDO, and the balance sheet is still off by the two amounts from when we converted to DBA.  
 
How exactly do I fix these two in EDITGL?  The first one, $1291.33,  is an entry to bring GL into balance because something was wrong when we converted.  
 
The second item, (428.06), is the NET of a large BEG BAL entry done when we transferred our GL to DBA.  There is no one entry for the $428.06 so I don't have a clue how this would be fixed.  
 
If we do come up with a way to fix this in EDITGL, what posting date would we use?  Same as the original entry?
Back to top
 
 
Email   IP Logged
shadowcaster
Active Member
*****


I'm not here because
I know what to do.

Posts: 678
Gender: male
Re: HELP!
Reply #19 - 12/28/05 at 11:31:57
 
they seem to have fixed this
 
June found it in an old transaction
now its all fine    I guess !!
 
the GL is  old news as far as im concerned.
 
by the time its correct we are always in a new quarter
 
 
J Dub
Back to top
 
 
WWW   IP Logged
Pages: 1 
Send Topic Print