Navigator User Forums
  Begin a New Year
  Valuation Dates & 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:   Valuation Dates & balances
Kwilson
Member
posted 03-01-2001 01:53 PM     Click Here to See the Profile for Kwilson   Click Here to Email Kwilson     Edit/Delete Message
When balancing January's books, I have found a problem with some of the Asset/Liability information. The "valuation date" on a select number of the assets (mostly quarterly statement accounts) has reverted back to Sep 30 00. All Jan. beginning balances tie with December ending balances, but this date is incorrect. I am looking into this b/c I do not balance at month end, but at the same time all of my unrealized numbers tie out perfectly. It is as if there is something "behind the scenese" changing and I can not see it. I updated one of the January A/L screens to show the "valuation date" as Dec 31 00 just to see what that would do to my balances. There is no activity to be seen in any of the accounts affected, but yet, I am out of balance by an even larger amount now that I changed the date.

I printed the A/L Information report, and that is where I noticed the valuation dates of a few that reverted back to Sep 30 00. If you print the same report for '00, the valuation date of these same assets shows a valuation date of Dec 31 00 - which is correct.

This is getting long, but...another problem found in balancing January. For some assets, there is one amt. for the balance on the Balance Sheet and a different amt for the balance of the same asset on the Sec. Port Analysis or the Other Invest. Analysis report b/c "price" has reverted to earlier month or quarter. If you try to see activity in January there is not any to reflect the changes that were made by the dates and "prices" reverting back to the latest update amounts.

Any suggestions on how to correct the out of balance problem will be greatly appreciated. Also, any ideas on why these numbers revert back to previous updates will help also. Oh, and when updating balances and asked if the A/L information should be updated to last year, we selected "Yes".

IP: Logged

Kwilson
Member
posted 03-02-2001 11:20 AM     Click Here to See the Profile for Kwilson   Click Here to Email Kwilson     Edit/Delete Message
Update on one of my questions. The "Out of balance" amount did not increase b/c I corrected the "Valuation Date" in the A/L screen. My January Other Invest. #'s changed due to a March deposit of returned capital. However, we would still like to know why the dates & prices reverted back to old updates.

IP: Logged

John
Administrator
posted 03-02-2001 05:07 PM     Click Here to See the Profile for John     Edit/Delete Message
Whenever on the investment reports, the balance for a security does not equal the price/share times # of shares, there will be an indication in the next column.
The footnote at the bottom of the report shows B= Balance or P= Price x Qty.
Balance is the same balance as the balance sheet.
Price x Qty is the price per share times the number of shares.

Now that you understand what the report is telling us then let see why and when this will happen.

Basically when is the balance not equal to the price x qty. Normally it always is but here are some situation when they will not be equal.
1) Keep balance at cost. If the Account option, Calculate Balances For: []Investment Accounts is not checked, then the balance is not updated when entering new prices. Therefore the investment report will calculate this for the market value. The "P" indication will be printed.

2) Running the investment report for a past month. If price have been updated for Dec and the report is run for a past month such as Nov then the balance for Nov will not be equal to the price (for Dec) x the number of shares. The balance will be printed with the "B" indicated.

3) The same problem can occur if the number of shares has changed because of either purchase or sales since the securities were priced. The solution is just to reprice the securities for that month.

4) Another situation can occur if securities are repriced for past months and not for current months. Since the repricing security affects the balance for that month but it will also affect the balance for all the remaining months since that activity has already been entered. The solution is to always price the months going forward. If you some reason you need to reprice a older month then also reprice that security for the remaining months so the ending balance is correct.

Changing the evaluation date in the A/L info will not affect the balance. But for the investment report it will think the latest market price is for that date. For example, if the evaluation date is change to Sep 30 but the price/share stays the same. Then if the report is run for Sep it will use the price/share x qty for the market value on the report instead of the balance as describe above.

Hope this helps to explain how the investment reports work. Also look at the help file for more info.


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