FlyerTalk Forums - View Single Post - Record keeping spreadsheet
View Single Post
Old Aug 17, 2011 | 8:12 pm
  #7  
rxgeek
500k
30 Countries Visited
All eyes on you!
15 Years on Site
 
Join Date: May 2011
Location: CMH
Programs: UA-Ag, TK & I Prefer-Elite, Marriott-Ti; IHG-Pt; Hilton-Dia
Posts: 1,399
Originally Posted by sam007
Guys

It's gotten to the point that I need to start maintaining systematic records of all my cards, mileage accured, etc. I could use some websites but honestly these websites come and go and don't feel like I need any online tool

I think a good spreadsheet would help and before starting, I wanted to see if anybody else has created one and could share. Any links would help too

Don't think I need to re-invent the wheel here

Thanks guys!
I use a spreadsheet stored on Dropbox. Easy access from any pc or smartphone. Here are my column headers: Program, ID#, PW, Phone, Pt Bal, Need, Verified Dt, Next Award, Expire, Notes (exp is after last activity unless otherwise). I color code the rows for hotels, car rental, airlines. The "Expire" column entries turn red if expiring within one year.
rxgeek is offline