Navigator User Forums
  Investment Reports
  Current Portfolio Evaluation Report shows price 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:   Current Portfolio Evaluation Report shows price change
FN_User
Member
posted 03-26-2009 01:01 PM     Click Here to See the Profile for FN_User     Edit/Delete Message
I created a new entity in Navigator 9.0 and manually entered cost & tax basis, balance, etc. on the A&L Info screen and the Balances screen for each security that was purchased long ago.

The Current Portfolio Evaluation Report shows a Price Change for each security, which doesn't make any sense since there have been no changes yet. I have not entered any transactions nor repriced to market value.

Also the 12 Month A/L Info Activity report shows $0 and 0 shares for each security's beginning balance. Then it shows a Calculated amount and a Difference. Does not make sense since I already entered beginning values.

IP: Logged

David
Administrator
posted 03-26-2009 01:32 PM     Click Here to See the Profile for David     Edit/Delete Message
The Price Change in the Current Portfolio Evaluation Report is because you have not revauled your securities yet. This report looks at the Price per Share and Valuation Date fields on the Asset and Liability Info screen, which are zero until you first update prices.


The zeros on the 12 Month A/L Info Activity report are there because Navigator 9.0 has a new feature "12 Month A/L Info" that tracks Cost Basis, Number of Shares, etc. month-by-month.

The amounts you entered on the A&L Info and Balances screens show up correctly as monthly balances on the 12 Month A/L Info screen. But they beginning amounts are still zero on the 12 Month A/L Info screen. That is why both reports have unexpected numbers.

Note that you should enter new account with balances only when you are starting a new entity. It would not make sense suddenly to have a new account with $1,000 in 2009 if that entity is already in Navigator for 2008. Use a buy security transaction instead.

To fix the accounts you have already entered:

  1. Select Investments | Investment and Account Options.
  2. Select Allow Changes to 12 Month A/L Info so that there is a checkmark in the box.
  3. Select Accounts | Asset and Liability Info.
  4. Select an account.
  5. Select OK. The Asset and Liability Info screen appears.
  6. Select January or whatever the first month of your accounting period is.
  7. Verify the amounts are correct.
  8. Select 12 Month A/L Info. The 12 Month A/L Info screen appears.
  9. Note that the Begin amounts are all 0 except for Balance.
  10. Enter Cost Basis$, Tax Basis$, and Number of Shares.
  11. Select OK to return to the Asset and Liability Info screen.
  12. Select OK again to return to the Asset and Liability Info account selection screen.
  13. Repeat steps 4-12 for each new account.
  14. Select Investments | Investment and Account Options.
  15. Select Allow Changes to 12 Month A/L Info so that the box does not have a checkmark.

- David
FNI Technical Support

[This message has been edited by David (edited 03-26-2009).]

[This message has been edited by David (edited 03-26-2009).]

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