Guide

How to analyze business travel spend

For travel managers and finance leads at companies of 100 to 1,000 people: the ten KPIs worth reporting every month, each with a definition, the formula, the data it needs and a worked example.

See the sample report Open the budget planner

Before you start

Most travel spend questions come down to three: how much did we spend, was it spent the way the policy says, and is any money owed back to us. The KPIs below answer those, and each one only needs data you already have in booking records, card statements, expense claims or your travel provider's reports.

Fix three things before the first report, and keep them the same every month: the period (booking date or travel date), what counts as a trip, and whether amounts include taxes. A KPI that changes definition halfway through the year can't show a trend.

Fictional numbers. Every example uses one made-up month for Northwind Example Co., an invented company. The figures show the arithmetic; they aren't benchmarks or averages, and this guide doesn't quote any.

The KPIs, one by one

Total spend by category

What travel cost in the month, split into air, hotel, rail, ground transport and booking fees, net of refunds received.

Formula: Sum of charges in each category, minus refunds received in the month. Each category's share = category spend ÷ total spend.
Data you need: Every travel charge with its date, category and amount; refunds with the date received. Keep each currency separate rather than adding them together.
Example: Air $48,000, hotel $31,500, rail $3,200, ground $2,800 and fees $4,500 make $90,000. Air is 53.3% of the total, hotels 35% and fees 5%.

Break the same total down by department against budget with the budget planner.

Cost per trip

The average all-in cost of one trip: fares, hotel, rail, ground transport and fees.

Formula: Total spend ÷ number of trips taken. Fee per trip = booking fees ÷ trips.
Data you need: Total spend from above, and a trip count: one trip per traveler per journey, however many bookings it took. Decide once whether a trip counts in the month it was booked or the month it was taken, and keep to it.
Example: $90,000 across 120 trips is $750 per trip, of which $37.50 is fees.

Average fare

What a ticket costs on average, including taxes. Track it by trip type (domestic, short haul, long haul) and cabin, because the mix moves it more than prices do.

Formula: Air spend ÷ tickets issued, for each trip type and cabin.
Data you need: Each ticket's fare including taxes, with route, cabin and issue date. Exchanges count once, at their final value.
Example: $48,000 across 100 tickets is an average fare of $480.

Average nightly rate against the cap

What a hotel night costs, compared with the cap your policy sets for that city.

Formula: Room spend ÷ room nights, per city. Rate as a share of cap = average rate ÷ cap. For a company-wide figure, weight each city's cap by its nights.
Data you need: Each stay's city, nights and room cost before taxes (or after, as long as the cap is set the same way), plus the cap for each city.
Example: City A: 100 nights at an average of $230 against a $250 cap (92%); City B: 50 nights at an average of $170 against a $180 cap (94.4%). Overall, 150 nights averaged $210 against a night-weighted cap of $226.67, or 92.6% of cap.

To set or check city caps, start from the hotel rate benchmarks.

Advance purchase

How many days before departure flights are booked, and how many are booked at the last minute.

Formula: Average days ahead = sum of (departure date − booking date) ÷ tickets. Late-booking share = tickets booked fewer than 7 days ahead ÷ tickets (use your own policy's threshold).
Data you need: Booking date and first departure date for each ticket.
Example: 100 tickets booked a total of 1,400 days ahead average 14.0 days. 22 were booked fewer than 7 days ahead: 22%.

Policy compliance and exception rate

The share of bookings that met the travel policy, and the share that didn't.

Formula: Exception rate = out-of-policy bookings ÷ all bookings. Compliance = 1 − exception rate. Report the exceptions by rule broken, so the number leads to an action.
Data you need: Each booking with an in-policy or out-of-policy flag, the rule broken, the justification and the approver.
Example: 18 of 180 bookings were out of policy: an exception rate of 10% and compliance of 90%.

Out-of-policy cost

What the exceptions cost above what the policy allowed. It's the excess, not the whole booking.

Formula: For each exception, amount paid − the policy amount (the cap, or the lowest in-policy option offered). Sum them, then divide by exceptions for the average.
Data you need: For each exception, what was paid and what the policy would have allowed. Without the in-policy alternative recorded at booking, this number can't be worked out reliably.
Example: The 18 exceptions cost $2,340 above policy, $130 each on average and 2.7% of travel spend before fees.

Unused credit value

Airline credits from canceled nonrefundable tickets that haven't been used yet, and how much of that value is close to expiring.

Formula: Open credit value = sum of unused credits. Expiring share = value expiring within 60 days ÷ open value. Report credits applied in the month separately, and count a credit as recovered only when it's applied.
Data you need: A register of credits: airline, traveler, value, expiry date, whether it can be transferred, and the date applied.
Example: 12 open credits are worth $6,480. 4 of them, worth $1,950 (30.1%), expire within 60 days. Credits worth $1,120 were applied to new tickets this month.

Check your own list with the unused ticket credit tracker.

Booking channel mix

How many bookings went through your managed channel (your travel management company or booking tool) and how many were booked directly with airlines and hotels, often called leakage.

Formula: Each channel's share = bookings in that channel ÷ all bookings.
Data you need: Managed bookings from your provider's data; direct bookings from card statements or expense claims, matched to travel suppliers.
Example: 144 bookings went through the managed channel and 36 were booked direct: 80% and 20%. Direct bookings also miss the policy checks and traveler records the managed channel keeps.

Emissions, if you report them

Estimated CO2e for the month's travel, mainly flights, with hotels and rail if your method includes them.

Formula: For each flight, distance × the emission factor for its haul and cabin; sum the month. Per trip = total ÷ trips. Use one factor set and one method all year.
Data you need: Each flight's route and cabin; hotel nights and rail distance if you include them.
Example: The month's flights come to an estimated 18.4 tonnes CO2e, or 153 kg per trip.

The emissions estimator's method shows one way to calculate it, step by step.

The example month at a glance

Put together, the example month reads like this. One table, a line per KPI, is usually enough for finance; the detail behind each line is for when it moves.

Northwind Example Co. (fictional): September KPIs
KPI	Value
Total spend	$90,000
Cost per trip	$750
Average fare	$480
Average nightly rate	$210 (92.6% of cap)
Days booked ahead (flights)	14.0 (22% under 7 days)
Exception rate	10% (18 of 180)
Out-of-policy cost	$2,340
Unused credits open	$6,480 ($1,950 expiring within 60 days)
Managed channel share	80%
Flight emissions	18.4 t CO2e

Turn the numbers into a report

A number on its own rarely changes anything. For each KPI that moved, write what changed, why, the action, who owns it and when you'll check again. If the exception rate went up, say which rule was broken most and whether the cap or the behavior should change. If credits are close to expiring, name the travelers who can use them.

The sample monthly report shows that format on a fictional company: spend against budget by department, exceptions, refunds, credits and emissions, each finding with an action, an owner and a date.

In silentVIP

In the silentVIP portal, spend is reported net of refunds by entity, department, project, supplier and traveler, with policy exceptions, outstanding refunds and unused ticket credits, and a monthly report that ends with actions rather than charts; see Reporting & savings.

Questions

Which travel KPIs should finance see every month?

Total spend by category against budget, cost per trip, policy exceptions with what they cost above policy, refunds outstanding and unused credit value. Add average fare, nightly rate against cap and advance purchase when you're looking for the cause of a change.

How do you calculate the policy exception rate?

Divide out-of-policy bookings by all bookings in the month. Compliance is the remainder. Report the exceptions by rule broken, with the justification and approver, so the number leads to an action.

What's the difference between out-of-policy cost and out-of-policy spend?

Out-of-policy spend is the full cost of the bookings that broke a rule. Out-of-policy cost is only the amount above what the policy allowed, which is the money the exception actually cost the company.

Is there a benchmark for these KPIs?

This guide gives none. Published averages mix companies with different routes, cabins and policies, so your own trend month over month, and the cause behind each change, tells you more than a comparison with someone else's average.

Last reviewed: Oct 22, 2026. Spotted something out of date? Email support@silentvip.com.

See a finished monthly report

The sample report puts these KPIs together for a fictional company, with findings, owners and dates.

See the sample report Book a Demo

Already a client? Get travel support.