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; } } }

Selling CDs creates a discrepancy between Market Value and balance

kleeberg

I am not sure what I'm doing wrong.

I have an investment account that is 50% cash and 50% CD. The market value for that account shows the total of both the cash and the CD. When I put a future date on the sale of the CD, the market value on the upper-right of the transaction view drops by the amount of the sale however the balance next to the transaction shows the correct balance.

Here are my steps:
3/32/2022 sell [security name] Total Sale: [total value of CDs]. Number of shares [X] Price per share [$100 auto filled]. No commission.

The market value falls by the total value of the sold CDs

If I use today's date for the transaction, the market value increases by the sale amount of the CD or 150% of the true value while the balance on the line of the transaction is correct.

What am I doing wrong?

Paul

Find more posts tagged with

Investments

Add/Edit Transactions

Quicken Mac

Comments

Quicken Jasmine

Hello @kleeberg,

Thank you for contacting the Community. I am sorry that you are experiencing this error.

Could you please provide screenshots of what is occurring so I may get a better understanding of the situation?

I look forward to hearing your response.

Jon

I think this is what he's seeing. I set up a test account with a made-up security purchase in January, with a total account value of $10K:

Image: https://us.v-cdn.net/6031128/uploads/editor/tf/cwrqmw5bkewt.png

Then I add a transaction selling the security later this month:

It looks like the Market Value and Account Balance in the sidebar are removing the value of the security from the total even though I still own it today; at the same time they aren't adding in the money generated by the sale because it hasn't happened yet. So that value just goes missing for a few weeks.

However, the portfolio view suggests this is only a 1 day problem. Here's what it looks like today:

Image: https://us.v-cdn.net/6031128/uploads/editor/a6/3t9065v5s1mu.png

And here's what it looks like if I move the date forward to tomorrow - the market value is back where it should be:

Image: https://us.v-cdn.net/6031128/uploads/editor/1p/ev3c0omirsn2.png

It looks like something about that transaction is getting attached to today's date even though it's dated a few weeks in the future.

Edit: I tried jumping my computer's date ahead by 1 day but the portfolio view & market value were still wrong (as in the third picture above), so it looks like the problem would persist until the date of the sale.