Nsx, there is a lot more detail in yours than I track in mine. I am almost embarrassed, but here goes.

1. Trip Date

2. Departure-Arrival airports

3. Passenger name

4. PRN #

5. Funds expiration date

6. Cost of ticket

7. Type of ticket (CP, RR or paid)

8. Flight #

In separate columns, I track available PRN funds with these columns:

1. PRN #

2. Amount available on PRN

3. Expiration Date

4. Passenger

I broke this out of the main spreadsheet because I hide the flights once completed, and I wanted the PRN funds at the top of the columns for wasy viewing.

On separate tabs, I track

a) Award Tickets

b) CP flight costs & value.

c) gift card balances