Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#1056 Balance Sheet Out of balance

1.4
closed-invalid
nobody
None
2
2014-02-10
2014-02-09
John Locke
No

This one seems much more critical: The balance sheet run with no filter selection is out of balance.

Comparing to the same exact data set in 1.3, there is a difference in the "Current Earnings" row of $13.12, and this same difference is showing between "Total Assets" and "Total Liabilities Plus Equity". All other rows are the same (other than 1.4 is showing asset/liability accounts with a zero balance, and also showing account numbers for all except the Current Earnings line showing the erroneous value).

Not sure how to go about further diagnosing this.

Discussion

  • Chris Travers
    Chris Travers
    2014-02-09

    is your trial balance out of balance for the same amount? If so this may be an issue of old (pre-1.2) data and we should probably look at tracking it down that way.

     
  • John Locke
    John Locke
    2014-02-10

    Trial Balance was also incorrect, by a larger amount.

    Tracked these down to two transactions from years ago -- one from 2010-02-15, LSMB 1.2 era, two different tax accounts adding tax credits but not equivalent AR or cash debits. Deleting those two from acc_trans brought my balance sheet back to in balance.

    Found one other AP transaction where a COGS account was $100 short -- probably corrupted during an attempted upgrade to 1.3, because this transaction also rounded a qty field that should have been 9.5, was rounded to 10.

    Closing invalid due to these being legacy data cleanup issues. However, I opened a new bug because my trial balance -- ignore "none" year ends is still way out of balance and is missing a bunch of accounts.

     
  • John Locke
    John Locke
    2014-02-10

    • status: open --> closed-invalid