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.
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.
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.
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.
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.
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.