on my personal excel sheet (on my Mac and synchronized daily with my Palm III) I note:
horizontal:[*]Date (of planned/realized activity)[*]Activity details (flight details or hotel or rental car or 'whatever'), [*]promotion code[*]link to the saved confirmation for some promotions[*]real/basic miles[*]UA miles Rudi[*]UA status miles Rudi[*]LH miles Rudi[*]LH status miles Rudi[*]Qualiflyer miles Rudi[*]Qualiflyer status miles Rudi[*]UA miles Gisela[*]UA status miles Gisela[*]LH miles Gisela[*]LH status miles Gisela[*]Qualiflyer miles Gisela[*]Qualiflyer status miles Gisela
vertical: in add to the individual stays listed chronological it starts with the lates summaries of:[*]Diners points total[*]Marriott points (and stays of the current calendar year) (whenever I reach another 30'000 points I transfer them into UA miles)[*]HHonors points (never cashed any points in yet)[*]Starwood points (from time to time I transfer them into Qualiflyer points)[*]Joker program points (= points program of Swiss Telecom), can be transferred into Qualiflyer miles[*]Key points (Union Bank of Switzerland points program)
cell-background colour: [*]planned = white[*]done = green[*]claimed 1st time = rosa[*]claimed 2nd time = red