ISTech Support Forum

Welcome, Guest. Please Login.

	05/28/25 at 12:57:15 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › Accounting

‹ Previous topic | Next topic ›

Pages: 1 2

HELP! (Read 1973 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.

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 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	IP Logged

JNAPIER Active Member Evil-Evo Bad Dog! Posts: 533 Gender:	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 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	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 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	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.

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.

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	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 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	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 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.

IP Logged

shadowcaster Active Member I'm not here because I know what to do. Posts: 678 Gender:	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	IP Logged

Pages: 1 2

ISTech Support Forum › Evo-ERP and DBA Classic › Accounting

‹ Previous topic | Next topic ›