ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> HELP!
http://www.istechforum.com/YaBB.pl?num=1134147512

Message started by kerric on 12/09/05 at 08:58:32

Title: HELP!
Post by kerric on 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 :'(

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.

Title: Re: HELP!
Post by Lynn Pantic on 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.

Title: Re: HELP!
Post by kerric on 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

Title: Re: HELP!
Post by JNAPIER on 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

Title: Re: HELP!
Post by kerric on 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.

Title: Re: HELP!
Post by Lynn Pantic on 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.

Title: Re: HELP!
Post by kerric on 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.

Title: Re: HELP!
Post by kerric on 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.

Title: Re: HELP!
Post by kerric on 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.

Title: Re: HELP!
Post by kerric on 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.

Title: Re: HELP!
Post by Lynn Pantic on 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.

Title: Re: HELP!
Post by kerric on 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?

Title: Re: HELP!
Post by Lynn Pantic on 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.

Title: Re: HELP!
Post by kerric on 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.

Title: Re: HELP!
Post by shadowcaster on 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

Title: Re: HELP!
Post by shadowcaster on 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

Title: Re: HELP!
Post by kerric on 12/14/05 at 12:48:57

Thank you Shadowcaster, that is encouraging. It didn't affect your prior year financials?

Title: Re: HELP!
Post by kerric on 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.

Title: Re: HELP! THE SAGA - 12/19
Post by kerric on 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?

Title: Re: HELP!
Post by shadowcaster on 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