Unused ticket credit tracker
See which airline credits expire next
Paste or choose a CSV of your company's unused ticket credits. The tracker sorts them by expiry, flags anything due within 60 days, totals the value at risk in each currency and gives you a cleaned file back.
This tracker needs JavaScript, because it works out everything in your browser instead of sending your credits to a server. Without it, you can still download the blank template and follow the method below in any spreadsheet.
Your list stays on your device. The file is read and checked by this page in your browser. Nothing is uploaded to silentVIP, and nothing is kept once you close or reload the page.
Your results will appear here
Start from the blank template or the unused ticket credits export from your travel provider, or select Load an example to see how it works.
How it works
The method, step by step
- The first row names the columns. Column order doesn't matter, and other columns are ignored. Commas, semicolons and cells copied from a spreadsheet (tabs) all work.
- Each row is checked. A row with a blank airline, value, currency or expiry, an unknown currency code or a date that can't be read is listed with its row number and left out of the results until it's fixed. Empty rows are skipped.
- Days left are counted from today's date on your device to the expiry date. An open credit with 60 days or fewer left is flagged as expiring, the same rule the silentVIP portal's reports use. A credit whose date has passed is listed as expired.
- Credits are sorted by expiry, soonest first, with expired ones after them.
- Value at risk is totaled for each currency on its own. Amounts in different currencies are never added together.
- The cleaned CSV has one row per valid credit with its days left and status. Any cell that starts with =, +, - or @ gets a leading apostrophe, so a spreadsheet can't run it as a formula.
Columns
| Column | Needed | What to enter |
|---|---|---|
| Traveler | Optional | The person the credit belongs to. Blank shows as Unassigned. |
| Airline | Required | The airline that issued the credit. |
| Ticket (last 4) | Optional | The last 4 digits of the original ticket number. If you paste a full number, only the last 4 digits are kept. |
| Currency | Required | A 3-letter ISO 4217 code, such as USD, EUR or GBP. |
| Value | Required | What's left on the credit, such as 450.00. Currency symbols and thousands separators are ignored. |
| Expires | Required | YYYY-MM-DD or MM/DD/YYYY. |
| Transferable, Notes | Optional | Whether another traveler can use it, and any airline conditions. Carried through to the export. |
The columns match the unused ticket credits CSV that the silentVIP portal exports, so that file can be checked here too.
In the silentVIP portal
The same job, done for you
For silentVIP clients, each unused ticket credit is its own record, with its airline, value, traveler and conditions. Anything expiring within 60 days is flagged, and the credit is applied when the traveler next books that airline.
Background
Refund or credit?
Whether a canceled ticket should come back as money or as a credit, what the US DOT's 2024 refund rule says, and the conditions to record for each credit are covered in our guide.
Questions
About the tracker
Is my credit list uploaded anywhere?
Why does it flag credits within 60 days?
Why aren't the totals added together?
Which date formats work?
Stop tracking credits in a spreadsheet
We'll show you how credits and refunds are tracked in the portal, using the demo company's data.
Already a client? Get travel support.