Welcome, Guest. Please Login.
06/07/25 at 11:38:25
News:
Home Help Search Login


Pages: 1
Send Topic Print
Detail Trial Balance (Read 530 times)
swolfert
Browser
*


hmmm DBA!!!

Posts: 5
Gender: male
Detail Trial Balance
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?
Back to top
 
 

Sean Wolfert
Suburban Plastics Company
847-741-4900 x118
swolfert@suburbanplastics.com
swolfert84   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Detail Trial Balance
Reply #1 - 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.
 
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print