Entering CD in a Brokerage account

Leslie Jones · January 21

Most of these discussions are closed. When I create a new security as a CD (example $2,000)

What shows up in my portfolio is not the amount I purchased but a substantially lower amount, making it impossible to reconcile my balance. I get accrued interest. Need help please.

MontanaKarl · January 22

The face value and market value of any fixed income investment will not be the same… so if you entered your purchase of the CD correctly with the CUSIP number, then the portfolio value of it will change daily as interest rates fluctuate. Your transaction register, however, should always reflect the date and amount that you paid for it and so should always reconcile. Could you clarify what won't reconcile?

Leslie Jones · February 22

Hello, I should have specified in a Brokerage account when I buy a CD. I seem to have to enter 150 shares for $15,000 and then manually figure out the price.

MontanaKarl · February 22

The 150 shares/units is correct. All fixed income is based on a $100 unit. The Buy Bonds transaction in your brokerage account should list the total amount paid and the 150 units … So it will ask you to enter Face Value - which is 15,000 - and will then display "150 Quicken Shares".

Yes, QMac is utterly dumb for entering the cost basis… as it requires you to enter the price per 100… so in that field use Quicken math … enter <purchase price without accrued interest> / 150 to get the price per $100. If there was accrued interest, enter that in that blank. The price per $100 should have been displayed on your trade confirmation though.

Quicken Windows lets you optionally enter the total cost as an alternative and it works backwards to the price per $100. Maybe we'll get that with QMac some day.

Entering CD in a Brokerage account

Comments

Categories