Navigator User Forums
  Account Information
  asset account starting balance change

Post New Topic  Post A Reply
profile | register | preferences | faq | search

UBBFriend: Email This Page to Someone! next newest topic | next oldest topic
Author Topic:   asset account starting balance change
jimkenney
Member
posted 03-04-2004 11:05 AM     Click Here to See the Profile for jimkenney     Edit/Delete Message
Noticed a possible bug in the asset screen of a marketable security after it has been sold. To get my year end balance sheet accurate for unrealized gains for the year I revise my 1/1/03 starting values to the actual market value. I had estimated some of them when I started using the software last July. Later when I ran 12/31/03 balance sheets , there were small balances in stocks I had sold during the year. After some time checking everything out , I noticed from an audit trail I had on hard copy that the problem occurs when you change the 1/01/03 starting balance in the chart of account screen AFTER you have sold the stock.The amount which shows up in the balance sheet is the difference in the first starting balance and the revised 1/1/03 balance which is the market value on that day. This difference shows in the asset screen right below the top item . In one of the stocks I sold on Oct. 20 it said Oct. Balance $351. The valuation date is Oct 20 put in by the system . All the other info on the asset screen for the security is correct. The FORMAT type is "soldAsset-security".

Please explain the logic in why the system lists a stock on the balance sheet in a month after it was sold and at the value which is the difference of 2 starting values as described above?? The last valuation date before the sale was in August B4 the sale in Oct.. So I don't understand the system using the starting value to determine 12/31/03 balance sheet amounts . I did not update the market values for the stocks I sold in the year since I thought the software would exclude stoks which had been sold from printing out on the balance sheet. Thanks

IP: Logged

John
Administrator
posted 03-05-2004 02:01 PM     Click Here to See the Profile for John     Edit/Delete Message
Yes, the balance in the account should appear on the balance sheet in order for the balance sheet to balance. True, the sold asset should have a zero balance after it is sold.

Since the starting balance was changed after the security was sold, then the sell transaction or some transaction should be adjusted to account for the change.

If the change to the starting balance was from unrealized gain then unrealized gain should also be correct. If it was from unrealized gain, it may have been ignored since unrealized gain is relieved for the difference between cost and balance at the time of the sale.

If the adjustment was to the cost basis then the cost and tax basis should be adjusted so the Schedule D is correct.

Yes, if the starting balance of a sold asset is changed then the sold transaction also needs to be changed.

Any change to the starting balance affects the monthly balances since the transaction activity is added to the starting balance to determine the monthly balances.

I hope this explains the situation for you. If you need futher explanation then let us know.


[This message has been edited by John (edited 03-05-2004).]

[Note: This message has been edited by radiodave]

IP: Logged

All times are PT (US)

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply
Hop to:

Contact Us | Home

Copyright 2010 Financial Navigator, Inc.


Ultimate Bulletin Board 5.47e