Navigator User Forums
  Troubleshooting Navigator
  Starting Balances

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:   Starting Balances
FNuser216
Member
posted 11-11-2008 08:43 AM     Click Here to See the Profile for FNuser216   Click Here to Email FNuser216     Edit/Delete Message
I am trying to change the starting balances of securities to the cost basis from the FMV. If I manually type it in the Chart of Accounts screen, my month balance changes. Why does the month balance change if it is the current FMV for that month? Is there a way to change the opening balances to cost without affecting the current FMV?

IP: Logged

David
Administrator
posted 11-11-2008 09:19 AM     Click Here to See the Profile for David     Edit/Delete Message
Lisa:

It's probably not a good idea to change the starting balances. If you track investments at FMV, you want the starting balances to show the Jan 1 FMV. Otherwise you will have a huge Unrealized Gain in the current year that actually happened in prior years.

But if you still want to change it, here's some information:

The balance in accounts is the starting balance + all the transactions in the account. So if you change the starting balance, Navigator adds the transaction amounts and comes up with a new balance.

The FMV is normally calculated using PriceLink, StockWeb, or manual entry using Investments | Enter Prices to Update Securities. Any of those processes creates the appropriate transaction in the Unrealized Gain & Loss (UGL) account, which in turn changes the balance in the investment account.

If you change the starting balance, you need to change the UGL account to match. You could make a manual entry, but it is easier to update prices. Updating prices will make whatever adjustment is needed to the UGL account so that the investment account balance shows the correct FMV.

This is easy if you only need the current FMV. Just update prices for today or at the end of the month. It is much more complicated if you want to correct the FMV for each past month. The problem is that if you have sold some shares in an account Navigator will calculate the wrong FMV because it will be using the wrong number of shares.

- David
FNI Technical Support
Case #38-10853

[This message has been edited by David (edited 11-11-2008).]

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