Shares in Brokerage account Transaction view do not match Portfolio view.
Mike Mowry
Member ✭✭
I've tried several things to resolve this. I entered 39.334 shares for IGAIX fund as a buy transaction on my initial investment on 4/8/19. Portfolio view shows 31.875 shares for that date. However, the transaction on 5/6 matches. 38.484 shares in both places. The 6/6 transaction also matches. I just created the account on 9/5/2020 and am entering history off my paper statements.
Tagged:
0
Best Answer
-
Have you connected this account to your brokerage to download transactions?
=============
A procedure to find out where things are going wrong:
Make sure the columns Shares, Share Balance, and Memo/Notes are visible in the Transactions register.
Make sure no filter is active. Click on the Clear Filters button if it is visible at the top of the register.
Make sure the register is sorted by Date.
Search for all transactions related to the IGAIX fund by entering the Security name in the Search box at the top of the register.
Check for a placeholder transaction on 4/7/2019, or on any other date. Placeholder transactions are in lighter (gray) text and have "Placeholder" in the Memo/Notes field. The presence of a placeholder transaction is a likely cause of the problem you are encountering. You can delete the placeholder if everything looks good after doing that. You can undo the deletion (Command-Z) if deleting does not fix things.
Otherwise, for each transaction starting with the oldest, check that adding the amount in the transaction's Shares column to the Share Balance from the previous transaction produces the expected Share Balance for the current transaction.
Quicken Mac Subscription • macOS Monterey 12.6 on MacBook Pro 13" M15
Answers
-
Have you connected this account to your brokerage to download transactions?
=============
A procedure to find out where things are going wrong:
Make sure the columns Shares, Share Balance, and Memo/Notes are visible in the Transactions register.
Make sure no filter is active. Click on the Clear Filters button if it is visible at the top of the register.
Make sure the register is sorted by Date.
Search for all transactions related to the IGAIX fund by entering the Security name in the Search box at the top of the register.
Check for a placeholder transaction on 4/7/2019, or on any other date. Placeholder transactions are in lighter (gray) text and have "Placeholder" in the Memo/Notes field. The presence of a placeholder transaction is a likely cause of the problem you are encountering. You can delete the placeholder if everything looks good after doing that. You can undo the deletion (Command-Z) if deleting does not fix things.
Otherwise, for each transaction starting with the oldest, check that adding the amount in the transaction's Shares column to the Share Balance from the previous transaction produces the expected Share Balance for the current transaction.
Quicken Mac Subscription • macOS Monterey 12.6 on MacBook Pro 13" M15 -
Thanks for the advice. I took another look at it and found the problem. I sold 7.459 shares at a later date (7/26/19) and specified the lot as the 4/8/19 buy, which is the one in question. Transaction view shows the purchase from 4/8 and the sale against that purchase on separate lines. Portfolio view shows the net holdings which is the balance of the 4/8 purchase less the sale of 7.459 shares. Simply a matter of one view consolidating by lot and the other showing separate transactions by date. Both views have the correct total shares.0
This discussion has been closed.