Dedicated to Deposits: Deals, Data, and Discussion
Featured Savings Rates
Featured Accounts

Tracking Your Certificate Of Deposits

Saturday, August 24, 2013 - 1:43 PM
Does anyone use an on-line spreadsheet that could track your CD's, the name of the institution, the phone number, the APY, date purchased, amount you purchased it for, date due. The columns would sort if the column header was clicked on, such as if on APY's then it would be in numerical order, or the header of the institutions was clicked on, it would go to alphabetical order and you could keep track of how much was in each institutions, also separate regular CD's, from traditional and Roth CD's. A column for yearly interest when added and the end of each years balance for each CD and for the sum total of each of  the columns. Also one that would track each CD if money was added to it when the CD matured, where it moved to etc. Have done this on ledgersheets for ourselves and for the township when I was treasurer for 23 years,  but looking for something on line now that can be printed. Of course the columns would not sort when I used ledger sheets.  I kept track of each CD on a separate ledger sheet. Used to do the macros in DOS for the monthly report but haven't a clue how to do it in my new Mac.
6
Ally6770Ally6770936 posts since
Jan 16, 2010
Rep Points: 2,722
1. Saturday, August 24, 2013 - 4:26 PM
I keep track of our CDs etc. on ledger sheets in a manual where I also post the interest checks when they arrive.  This way I can know instantly if I miss a check or it is mailed late. I also can list those electronically sent to our bank. 

I would be very concerned about using a software program to list all our financial information out of concern for hackers.  As they say, nothing we put on the web is private, and I would not want any of my financial information to be able to get into anyone else's possession.   I don't even like to do our taxes electronically for the same reason. 
4
paoli2paoli21,401 posts since
Aug 10, 2011
Rep Points: 6,135
2. Saturday, August 24, 2013 - 5:03 PM
Was hoping you could download the form fill it out and print it and save the form on a USB.  I have done my taxes on the computer with a disk since the 1990's. But this year the new Apple will not take a disk.

 I just found a lot of preprogrammed spreadsheets on Apple's NUMBERS program but none are what I want. Many of them do have the macros. 
1
Ally6770Ally6770936 posts since
Jan 16, 2010
Rep Points: 2,722
3. Saturday, August 24, 2013 - 5:06 PM
I have always had our interest checks compounded. So I check the balanaces on July 1 and Dec 31 or Jan 1 and post them on the ledger sheets. 
2
Ally6770Ally6770936 posts since
Jan 16, 2010
Rep Points: 2,722
4. Saturday, August 24, 2013 - 6:21 PM
With interest rates being so low there is not much difference in what we get with the compounding so I just take the checks and use them.  I am no longer in the saving mode but now in the using mode.  I keep track of it all to verify at tax time.
3
paoli2paoli21,401 posts since
Aug 10, 2011
Rep Points: 6,135
5. Saturday, August 24, 2013 - 7:31 PM
When you get the monthly, quarterly or semi-annual interest checks you do not get the APY as stated. The APY is the amount you would get if you let the money stay there for the entire year. 

Because I always go for highest rate no matter how long I still have some paying 5%, 6% and 6.25% but by the middle of 2015 all of those will have all matured.

I am using part of the CD money as they mature to pay taxes on traditional IRA's that I convert to a Roth.  
3
Ally6770Ally6770936 posts since
Jan 16, 2010
Rep Points: 2,722
6. Monday, August 26, 2013 - 8:41 AM
 

I created a financial spreadsheet to track my accounts with all the pertinent information. I have the dates opened, date of maturity and the approximate monthly interest of each account which is totaled. In addition, the total amount of the cds that mature in a given year. I don’t need to sort because the only mature date I am concerned about is the next one. I keep that date on my computer screen .

There is a separate column for liquid cash in stocks, MM and savings vs CD/IRA  money and a total  % of liquid vs cd’s.

In addition, when I open a cd I use a calculater to determine the approximate total interest to be earned on the full term of the account and enter that figure into a column.There is another column showing the amount left to be earned on each account and the total % of interest yet to be earned on the accounts.

When a cd matures, I cut and paste the information on page 2 of the spreadsheet so I when I feel nostalgic can refer back to the good old days when my accounts earned 5 and 6 % interest.

I try and update once a month with the active amount in each account. Once this figure is entered the spreadsheet  calculates all the other information so I know pretty much where I stand each month.

 

 
2
FARFAR108 posts since
Feb 26, 2013
Rep Points: 386
7. Monday, August 26, 2013 - 8:55 AM
Thank you FAR.

My cousin told me last night that the blank spreadsheet in numbers (the Mac spreadsheet) will do all or most of what I want to do. I have that program but never used it for this. I will have to check it out. 
2
Ally6770Ally6770936 posts since
Jan 16, 2010
Rep Points: 2,722
8. Monday, August 26, 2013 - 8:56 AM
My cousin suggested color coding each year that the CD's mature. Then the sort would not be necessary. 
2
Ally6770Ally6770936 posts since
Jan 16, 2010
Rep Points: 2,722
Reply