ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> Detail Trial Balance
http://www.istechforum.com/YaBB.pl?num=1242140736

Message started by swolfert on 05/12/09 at 08:05:36

Title: Detail Trial Balance
Post by swolfert on 05/12/09 at 08:05:36

Recently I have discovered that the beginning balance for my detail trial balance of most but not all of the g/l accounts is incorrect. For example, if I run a detail t/b for 2009 (1/1/09-12/31/09) I have balance sheet beg balances that are now incorrect from the 12/31/08 correct balances. I also have inc/exp g/l accounts that show a beginning balance when all should be zero. Somehow the beg balances are not accumulating correctly. This problem exists in prior years also if I run a prior year report. The debits and credits are fine and my financial statements are fine. It is only the beg bal for the detail t/b. We use version 2002.1. Is there a maintence program we can use to correct this?

Title: Re: Detail Trial Balance
Post by Lynn_Pantic on 05/12/09 at 10:06:39

With such an old version, it is hard to say. If the trial balance is off but the financial statements are (you say) correct then somewhere along the line somebody manipulated the balances in the chart of accounts (monthly totals) used by the financial statements without having underlying transaction detail to support it. Further, if the trial balance income/expense accounts have a balance forward from prior years then something isn't right there either with the YE entries which is because it calculated them based on the Chart of Accounts annual totals and you have already said that those numbers do not match the transaction detail in the Trial Balance. If debits and credits are equal then you can make journal entries to get the trial balance correct and then use UT-K-D to recalculate the Chart of Accounts but with your version you are limited to 2 years past. There is also a utility that can recalculate the year end entries but I recall it having some bugs and I don't remember when they were fixed relative top the version you are on.

What I recommend is that you pay for a support incident so we can help you get all the numbers in synch and also consider subscribing to the IS Tech updates which will enable 6 years of financial history along with a lot of other improvements.