Navigator User Forums
  Begin a New Year
  update 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:   update starting balances
FINNAV_User
Member
posted 09-07-2001 05:50 PM     Click Here to See the Profile for FINNAV_User     Edit/Delete Message
I have created AAA_99 with cost basis numbers in the CofA. I started a new year AAA_00. I went back to AAA_99 and manually updated the A/L screens with FMV as of 12/31/99. The Security Portfolio Analysis 12/99 report reflects the difference between cost basis and FMV. The 12/99 Basis Balance Sheet shows cost basis in both columns. The Unrealized Gain/Loss 12/99 report has no activity. How do I get the BS to show the unrealized Gain in the equity section?

Updating starting balances of AAA_00 did not change the original A/L screens (still without FMV 12/31/99). What am I missing?

IP: Logged

John
Administrator
posted 09-12-2001 08:25 AM     Click Here to See the Profile for John     Edit/Delete Message
The balances need to be updated in the AAA_99 set of data files.
1) Verify the option to calculate the balances is set. Select Investments (Accounts in 7.5) | Investment & Account Options. Verify that Calculate Balances for: [x] Investment Accounts is checked.

2) Update the balances. Select Investments (Accounts in 7.5) | Enter Prices to Update Securities. Enter Dec 31 99 as the evaluation date. Select OK for the first security. Now the security will appear. The Dec 31 99 price should already be on the screen since the Security Portfolio Analysis report showed the correct price. If not enter the correct price per share. The new balance should already be 'Calculated'. If not then just cursor down to the next field to get the new 'Calculated' balance. Now just select Next (Page Down key) to go to the next security. Continue until the last security is updated.
(Note: Optional select Automatic to automatically go thru the securities that have already been priced.)

Now run the Balance Sheet report. The balances will be updated.

Now in the AAA_00 files, select Update Starting Balances to update to the Starting balances for 2000 to the ending balances for 99.

Notes:
Entering the price per share in the A/L info screen does NOT update the balances. This is done in the Enter Prices to Update Securities screen.

The Security Portfolio Analysis report showed the prices entered in the A/L screen. The Market Value for the report was calculated from the Price per Share times Number of Shares. When this amount is not equal to the Balance then an indication will appear in the next column. Either a "P" or a "B". The footnote says that "P" is "Price per share x Number of Shares " is used. The "B" is "Balance". So when this appear then the Balance does NOT equal the Price per share x Number of Shares.

This allows for people who want to keep the Balance Sheet at cost but obtain market value security reports.

Let me know if this does not explain the situation and the solution for you.

[This message has been edited by John (edited 09-12-2001).]

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