nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Portfolio value report shares times price wrong

FarmHills

The Investing>Reports>Portfolio Value is not calculating the shares times price balance properly for two securities. The Portfolio register itself is correct and agrees with my financial institution. 2 Error examples below:

2/10/2024Page 1
Security Symbol Shares Quote/Price est Cost Basis Gain/Loss Balance
Account A
SCHWAB S&P 500 INDEX FD SWPPX 75.880 77.130 * 1,984.87 3,879.94 5,864.81
Should be 5,852.62

Account B
ISHARES INTERNTINL ... IAGG 27.850 49.320 * 1,561.81 -172.58 1,389.23
Should be 1,373.56

Interestingly SWPPX is calculated correctly in Account D

Find more posts tagged with

Investment Reports

Comments

Tom Young

Very odd! If you click on the "+" sign next to the security name to expand the information to "lots", do you notice any discrepancies between that list and the same list of lots that shows up in the Holdings view over in the Account?

It seems like one of your column headings is "est Cost Basis" and I don't have that available to me in Portfolio view.

mshiggins

The “est”column is actually titled “Estimated Price” in the Portfolio Value report’s Show Columns section of the report’s Customize dialog.

Tom Young

I was thinking "Portfolio View" vs. "Portfolio Value Report." And obviously there's no ability to expand a security here to lot level information.

FarmHills

If you double click on the asterisk in the (est) column it brings up all transaction for the security across all accounts. Don't see anything unusual. Re-Pasted the error example below to make it easier to read. One more piece of info: Account D that calculates SWPPX correctly is a taxable account while all accounts with errors are IRAs.

PC is Wndows Pro, i7 CPU, 12 GB Ram, Quicken Ver. RS54.16; Build 27.1.54.16

Have been using Quicken since 1994. Data base backup is now 96 MB.

2/10/2024Page 1
(Security) (Symbol) (Shares) (Quote/Price) (est) (Cost Basis) (Gain/Loss) (Balance)
Account A
(SCHWAB S&P 500 INDEX FD) (SWPPX) (75.880) (77.130) (*) (1,984.87) (3,879.94) (5,864.81)
Should be 5,852.62

Account B
(ISHARES INTERNTINL...) (IAGG) (27.850) (49.320) (*) (1,561.81) (-172.58) (1,389.23)
Should be 1,373.56