I know several people have posted or referenced their own spreadsheets in their AOR threads. But, I did not find any comprehensive listing of spreadsheets or methods. If you're interested in sharing your method, post it here. If not, disregard this thread and it will slowly drift away into oblivion.
I'll go first.
I use a Google spreadsheet with 4 tabs/sheets:
Personal Cards - A place to list all open personal accounts and all important details. This sheet has a column that calculates expected balance transfer profits. That formula could use some work. Currently it takes into account number of months in the BT offer, APR, BT fee, and expected yield on the account where the BT money will earn interest. It does not take into account a BT with anything other than 0% or the declining balance due to monthly payments. The thing I like best is that it calculates % utilization and shows clearly when I'm over 89% on one card or 50% on all.
Business Cards - A place to list all open business accounts and all important details. Same issue with the expected profits on this one.
Credit Profile - last AOR I kept close track things like FAKO score, inquiries, etc. on a daily basis. The plan was to to better learn how various events affect our scores. I grew tired of it after a month or so and never really looked into it in any depth.
New Apps - I plan my new applications here, business and personal on the same sheet
You can take a look at the template here (sign in with your own Gmail or Google account): Credit Organizer Template
If you like it enough to want to use it yourself, do this (you must be signed in under your own Gmail or Google account):
1. Use the link above to view the sheet
2. Under the 'File' menu select 'Copy Spreadsheet'
3. Now you should have your own version of the sheet. Use it however you want.
Or, follow the instructions below and share it with your own account.
If you'd like to help out and improve the sheet for others, do this:
1. Go to Google Docs
2. Login with Email - 'fatwallet08@live.com' ; Password - 'creditcards'
3. Select the spreadsheet 'Credit Organizer Templates'
2. Improve at will
Do me a favor and post any improvements you make. If someone adds a change that horribly disfigures the sheet, we can always use the edit history feature to go back in time to a nicer version.
I will be doing an AOR - my 3rd, so it will be more of a mini AOR, mostly business - and will post a link to the spreadsheet for others to follow the progress, if they wish.
Edit: Posted a much simpler way to get your own version.


