Navigator User Forums
  Investment Transactions
  Error Unrealized Gain/Loss on Sold securities

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:   Error Unrealized Gain/Loss on Sold securities
cbrumback
Member
posted 01-26-2002 12:43 PM     Click Here to See the Profile for cbrumback   Click Here to Email cbrumback     Edit/Delete Message
Twice during 2001 when I sold a security, a credit is generated and posted to the sold security account and a debit is posted to the Unrealized Gain/Loss account. This happens the next time I run stock web to update the value of all securities. This leaves a negative balance in the sold asset account that shows up on Investment Reports and trial balances. To correct this I create and post a journal entry debiting the sold security account and crediting the Unrealized Gain/Loss account.

The surprise posting carries the following message: "QTxxxx.xx" where xxxx.xx is the number of shares sold in the original transaction.

Any thoughts on this?

------------------

IP: Logged

Renee
Member
posted 01-28-2002 12:47 PM     Click Here to See the Profile for Renee   Click Here to Email Renee     Edit/Delete Message
To make sure I understand your question, please allow me to restate the situation. The problem happens as follows:

- First you sell part of the shares you own of a particular security. (i.e., a "partial sale." I say this because you refer to a "sold account." Did I understand this correctly?) This results in an account with a zero balance that FN uses to account for the sold shares. For purposes of this example, let's say the account name of the original lot of stock was ABC CO and that you sold part of it, resulting in a new account called ABC CO_SLD #1.

- Then you run StockWeb to update all your securities to market value.

- You then notice that the account ABC CO_SLD #1 now has a credit balance in it, which you correct with a journal entry.

Please post a reply to this topic (don't start a new topic) and let me know if I have this sequence of events right. In the meantime, I will try to duplicate this situation.

------------------
Renée Trudeau
Financial Navigator Int'l
Manager, Technical Services

IP: Logged

cbrumback
Member
posted 01-28-2002 01:17 PM     Click Here to See the Profile for cbrumback   Click Here to Email cbrumback     Edit/Delete Message
No, these were not partial sales. The entire lot was sold in all cases.

After the stock web update the original account, not the ABC CO_SLD#1 account, has the credit balance. The QT error message contains the number of shares in the sold lot.

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