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.