Value of investment not reflecting on Net Worth report
As you can see by the screen shot, the value is correct in the register but subtracts the investment cost and shows that amount on the Net Worth Report, not the true market value.
Bill
Comments
-
Hello @BillBelanger,
Thank you for letting us know you're seeing a discrepancy in your net worth. To clarify, what exactly is happening? The screenshot you included shows an investment account with a negative cash balance. How is it reflecting in the net worth report?
If it's showing 2783.55, then considering the cash balance is negative, it makes sense that the negative cash balance would be subtracted from the value of the holdings to determine the market value.
I look forward to your response!
Quicken Kristina
Make sure to sign up for the email digest to see a round up of your top posts.
0 -
The market value is the 3783.55
The $1,000 I paid should have come out of the checking or other cash account.
The transaction is an old one and I'm new to Quicken.
I don't see how to purchase a security obviously since I was not allowed to indicate where the cash came from. I tried posting a transaction from the checking account and I don't see how to do that either.
Can you help? How do I buy a stock?
Doing a google search it looks like I should be able to indicate a cash account but I don't see that.
Mac Version 8.1.1
Bill
0 -
I don't think there's a way to enter a single transaction that both purchases an asset and simultaneously pulls the money for the purchase from a different account. AFAIK you have to enter a Payment/Deposit transaction to transfer the money and then a Buy transaction to make the purchase.
0 -
Thanks Jon.
But that's what I did, and it shows the market value less the investment. Not accurate as far as I can see.
I don't see any way to eliminate the negative cash entry that subtracts from the true market value. So that renders the Net Worth statement inaccurate.
What I read on a google search is that you enter which cash account you bought the security with, but that must be the windows version. :(
Bill
0 -
How do I buy a security?
Use the Shares Bought dialog to record the purchase of shares of a stock or mutual fund. Quicken tracks purchase price and lots; these will be important later when you use the Capital Gains Estimator to minimize the tax liability incurred by sales. Similarly, cost basis information can be captured at the time of sale.
- Open the account you want to use.
- Click Enter Transactions.
- In the Enter Transaction list, select Buy - Shares Bought.
- Use the dialog to record the purchase of a security. Click a link below for more information.
- Transaction dateEnter the date of purchase. This is important if you want to track complete investment performance and tax information.
- Security nameIf you accessed this dialog from the investment account transaction list, select the security that you're purchasing shares of.
- AccountIf you accessed this dialog from the Security Detail View, select the account that you're purchasing shares for.
- Number of shares, Price paid, and commissionEnter the number of shares you purchased and the purchase price. Enter any commissions or other fees separately in the Commission/Fee field.
- When you access this dialog to resolve a placeholder entry, you won't be asked to identify the account you're using to fund the transaction.
- Select From this account's cash balance if you're buying the shares with money from the current investment account; this decreases the cash balance of this account. Quicken enters this transaction in the transaction list as a Buy.
- Otherwise, select the Quicken account you're using to fund this purchase in the drop-down list. This decreases the cash balance of that account. Quicken enters this transaction in the transaction list as a BuyX.
- Click Enter/New to enter another transaction, or Enter/Done to finish.
It seems the Mac Version is again not updated and treated as a serious program, just a stepchild of the Windows version. I'm not sure how Quicken Kristina sees this as accurate when it leads to a completely inaccurate report. The security feature in Quicken Mac doesn't work as far as I can see. Sad…
0 -
The windows version may let you do it all in one transaction, in the Mac version it takes two.
0 -
Beyond that, I had to put in a fictitious stock, Tesla, so that anything works at all. Delete the Tesla stock and it no longer will retrieve the bitcoin values. I can't imagine I'm the lone wolf here, am I? Plus still no way to track gold bullion value other than manually. I don't mind that, just that why offer the feature if it doesn't work. Here's a screenshot of the fictitious Tesla purchase at $250 for 1 share. It shows a market value of $10.57
Bill
0 -
I MUST be wrong. I can't believe I'm the only person with a Mac that has a stock they want to track in Quicken…
0 -
So Jon, can you make a buy transaction and have it show the true current market value?
Bill
0 -
You're going to have issues with Bitcoin & other cryptocurrencies since they are not a stock, bond, or mutual fund. You can follow the advice here to create a custom security that tracks the price of Bitcoin - I don't have any myself so I don't know for sure how well it works but it's the best advice I can offer.
More run of the mill investments work fine - I've had no problems with stocks & mutual funds.
0 -
Thanks again for your help Jon. That's why I posted the Tesla stock transaction. That's a mainstream stock and displays the same error in market value.
I posted a transaction for 1 share at $250 and it shows market value of 10 bucks.
If it were solely a BTC issue, I'd completely understand. Is it just my program? Can anyone confirm the issue with Tesla TSLA stock?
Bill
0 -
Here is the TSLA transaction
0 -
Same with an Apple stock transaction.
The market value is incorrect. If it were labeled "Profit/Loss" it would make sense, but that value is used in the net worth report. Not correct…
Bill
0 -
You can't buy stock without spending money, and that money has to be in your brokerage account. If you're using a separate Quicken account to track the cash balance in your brokerage account, you have to move cash back & forth manually, Quicken Mac won't do it for you. If you don't do that, then you're going to have a negative cash balance.
0 -
I posted a sale of the 1 TSLA stock for $100 when I had purchased it for $250. The Market value shows -$150 which is the loss, while it should show Zero, since I supposedly had sold the 1 share. The -$150 also shows on the Net Worth Report. So the calculation field is in the wrong place. It's a difference calculation not the market value. Should be an easy fix, but the stock tracker is not usable as is.
Bill
0 -
Also, the gain/loss number in the upper right corner, and the gain/loss numbers on the dashboard, are set to show the gain/loss for the most recent trading day. If you want to see longer term gain loss numbers you need to switch to the portfolio tab - there are a bunch of different gain/loss columns available for display there.
0 -
You still haven't entered any cash coming into your brokerage account to pay for your stock purchase. You spent $250 on Tesla on 3/29 - where did that money come from?
0 -
I think I see. You have one "Brokerage" account and add securities to that account rather than having each stock as a separate account. Is that right?
Bill
0 -
Yes, that is the way that brokerage accounts work. You would have one Quicken account for each real world brokerage account.
0 -
Thanks so much! No wonder it wasn't working.
I was using a separate account for each security. You made my day!
Bill
0
Categories
- All Categories
- 6 Product Ideas
- 27 Announcements
- 181 Alerts, Online Banking & Known Product Issues
- 16 Product Alerts
- 718 Welcome to the Community!
- 599 Before you Buy
- 1.3K Product Ideas
- 49.5K Quicken Classic for Windows
- 15.3K Quicken Classic for Mac
- 982 Quicken Mobile
- 772 Quicken on the Web
- 72 Quicken LifeHub