Let's put our heads together and see if we can come up with a killer spreadsheet for tracking reservations. Then some kind person can add it to the FAQ.

Here are my spreadsheet columns:

A: Passenger initials or, for a canceled or past reservation, hand-entered numeric value of available funds. I have no way to show residual value in a current reservation due to re-faring to a lower fare. You need to add a column if you want that capability. Note that I manually set this column to zero after the flight is flown or the funds are used.

B: Current value in the Bank of Southwest, meaning either the residual value from column A or the total fare from column H. For row 83, this is computed as "=IF(ISBLANK(D83),0,IF(ISERR(VALUE(A83)),H83,VALUE (A83)))". The ISBLANK(D83) checks for a blank PNR, because I often populate the spreadsheet with planned future flights before I buy them. This way the Bank of Southwest balance properly excludes those rows.

C: Expiration date of funds.

D: PNR

E: Type of booking. D for Ding, C for Companion, R for award, F for freedom award, P if booked by phone, O if booked online

F: Flown? Y if yes, blank if unflown, X if canceled.

G: RR credit: blank if unposted, hyphen if no credit is due (awards), 1 (or 1.25 or 2 for BS) if credit is posted.

H: Total ticket price. I do not retain any breakdown of the fare.

I: Origin airport code

J: Outbound date

K: Outbound time

L: Outbound flight number

M: Destination or connection airport code

N: Return or connection date. For a connection (same date as outbound) I put arrival time for the outbound here.

O: Return or connection time

P: Return or connection flight number

I can show one connecting trip on one line or a RT using nonstops. More than that requires 2 lines. I do not have a column for arrival time at the destination, but you could add one.

Q: Source of funds. This column is vital if you hope to keep track of where your funds went. I could probably have broken this into multiple columns, but I show multiple PNRs plus a credit card like this: "ABC123 25.60 + DEF456 38.40 + SW4321 12.00"

R: Comments. Anything that doesn't fit in the other columns. Bonus promo booking, arrival time at destination, passenger initials (because they disappear from column A after I enter zero there).

I have a separate worksheet for awards, showing award number, expiration date, PNR for "A" half, and PNR for "B" half.

A third worksheet is a simple list of refunds applied for: amount due, PNR, credit card identifier (e.g., SW4321), date requested, type of request (online or phone), and date received. Phone refunds sometimes require a second request.