Navigator User Forums
  Balance Sheets
  Statement of Financial Condition - cost basis

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:   Statement of Financial Condition - cost basis
Connie gowland
Member
posted 03-19-2001 09:45 AM     Click Here to See the Profile for Connie gowland   Click Here to Email Connie gowland     Edit/Delete Message
In the Investments Options box, I have nothing checked. When I print a Statement of Financial Condition for Novemeber, 2000 (this happens in only 1 of 9 entities) I get cost figures, which is what I want. When I print the same report in December, I get Market figures. Why? I want cost figures on my 12/31/00 report, but I don't want to use the cost basis balance sheet option.

IP: Logged

Renee
Member
posted 03-19-2001 11:51 AM     Click Here to See the Profile for Renee   Click Here to Email Renee     Edit/Delete Message
To make this more understandable for a new user who may read this, let's clarify something.

quote:
Originally posted by Connie gowland:
In the Investments Options box, I have nothing checked.

I take this to mean that you went to Investments | Investment & Account Options and made sure that both the boxes under Calculate Balances weren't checked.

With these boxes unchecked, FN will still allow you to enter market values for your securities. These prices will not show up in account balances, and the Balance Sheet (or Statement of Financial Condition) continues to show cost basis. The investment reports make the necessary calculations to report
current market values and unrealized gains or losses.

Somehow, FN has created transactions to update the balance of your securities to market value. I'm thinking that possibly the Investment Options got checked by mistake. Then market prices were entered, causing the accounts to be updated. Going back to Investment Options and
unchecking the box can't undo the "damage" of these incorrect entries, although it will prevent this from happening again.

Don't despair, though, because fixing the problem is relatively easy.

  1. First, verify that this is the problem. Verify that there are transactions by looking at a Transactions by Account report for one of the investments affected (for the entire year). If my assessment of this situation is correct, you should see an unrealized gain or loss transaction in December.
  2. If you saw an unrealized gain or loss transaction in step 1 above, then proceed. If not, "reply" to this topic and give us more information about the situation.
  3. Now determine whether you have any sales of securities in December. Print out a Transactions by Account for each account that has a sale recorded. Determine whether each security had balances updated in
    Dec before the sale. (simply determine whether the "unrealized gain" transaction comes before the sale transaction.)
  4. Go to Transaction Activity and cancel each security sale that was
    • Recorded in December;
    • Has an Unrealized Gain or Loss Transaction in December, AND
    • The Unrealized Gain transaction took place before the sale transaction.

  5. Go to Transaction Activity (Change/Review Transactions) for December.
  6. Select category - Unrealized Gains or Losses and the UNREALIZED GAINS OR LOSSES account. Hit Apply.
  7. A list of all transactions updating the accounts to market value will be displayed.
  8. Delete every one of the Unrealized Gain or Loss transactions. Do this by typing an "X" in the status field for each transaction, then hit "enter."
  9. The system asks, "Delete Transaction?" Hit "Yes."
  10. Do this for each transaction listed under Unrealized Gains or Losses.
  11. Re-enter any of the securities sales you deleted above.

------------------
Renée Trudeau
Financial Navigator Service Provider

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