Managing CD
droopydog53
Member ✭✭✭
I would like someone to validate my process. I have chosen to do this manually. I have read a lot of the articles and understand how to create the securities and the accounts but I couldn't find anything really that explained the proper "daily" process to manage the account. I am looking for the most correct and efficient way. I have broken down the process into its basic steps. Thanks in advance!
I have two CDs (one 6 mo and one 12 mo) that I got through my bank. In Quicken, I added each CD as an individual security (named as the duration and the last couple #s of the account). I then created a brokerage account and named it the same as the bank. The first transaction was a "cash transferred into account" transaction, i.e. a cash transfer from another bank account to the bank that sold me the CDs. Then the next transaction is a "Buy - Shares bought" transaction. In this transaction I entered the individual security name, followed by the price paid. For the purposes of this, the number of shares = the amount of money that I put into the CD and the price paid is $1.00. Then when it comes time for the monthly reconciliation, I find the interest earned and select "Inc - Income (Div, Int, etc.)," I select the correct security and enter the interest earned for the month in the interest box and click done. Then to actually reconcile the account, I select "Reconcile" and add the ending cash balance and go through the normal reconciling process.
Do I have that correct?
What do I do with the resulting interest?
Is the account supposed to have a positive cash balance (i.e. the interest) or is there another transaction that I am supposed to make??
Is this process the same for an index fund? Cash in, followed by a bought, followed by a reconcile....
I have two CDs (one 6 mo and one 12 mo) that I got through my bank. In Quicken, I added each CD as an individual security (named as the duration and the last couple #s of the account). I then created a brokerage account and named it the same as the bank. The first transaction was a "cash transferred into account" transaction, i.e. a cash transfer from another bank account to the bank that sold me the CDs. Then the next transaction is a "Buy - Shares bought" transaction. In this transaction I entered the individual security name, followed by the price paid. For the purposes of this, the number of shares = the amount of money that I put into the CD and the price paid is $1.00. Then when it comes time for the monthly reconciliation, I find the interest earned and select "Inc - Income (Div, Int, etc.)," I select the correct security and enter the interest earned for the month in the interest box and click done. Then to actually reconcile the account, I select "Reconcile" and add the ending cash balance and go through the normal reconciling process.
Do I have that correct?
What do I do with the resulting interest?
Is the account supposed to have a positive cash balance (i.e. the interest) or is there another transaction that I am supposed to make??
Is this process the same for an index fund? Cash in, followed by a bought, followed by a reconcile....
Tagged:
0
Comments
-
I always treat bank CDs like savings accounts. The interest gets recorded just like savings account interest gets recorded, whenever it gets credited to the CD. When the CD matures, if I don't roll it into another CD then I transfer the money out to wherever it goes & close the CD account.
If I purchased a CD in the secondary market inside a brokerage account, I might do something more like what you're describing.2 -
This content has been removed.
-
Thanks for your insight! Your method is a cleaner approach than the one I outlined.0
-
Intuit needs to add a function to create a CD in a savings account. this is not available at this time-1
-
Richard Eshelbrenner said:Intuit needs to add a function to create a CD in a savings account. this is not available at this time
WHY? A CD is a security and should be treated as such.
Q user since February, 1990. DOS Version 4
Now running Quicken Windows Subscription, Business & Personal
Retired "Certified Information Systems Auditor" & Bank Audit VP0 -
When I owned CDs, I typically used the 'security' approach but used a Reinvest Interest action at the $1.00 / share rate. "Shares" sold @ $1.00/share upon maturity.
If I had a ladder of 10 CD's, I think I'd rather have 10 securities in one account rather than 10 accounts. Greatly personal preference.0
This discussion has been closed.