A year-over-year comparison measures one metric for a period against the same period a year earlier, such as air spend from January to June against the same months of the prior year. In an executive travel review it holds only when both figures were counted the same way, and the review stalls when two systems disagree.
Every executive travel review turns on a comparison: spend for the year to date against the same months a year earlier, one quarter against the same quarter, one supplier's share against the last renewal. The comparison is only as good as the two figures in it, and those figures often come from systems that count travel differently.
This guide covers how to build a year-over-year comparison that survives the meeting: why three systems give three answers, which time slices a review needs, how to calculate year over year growth, and what executives ask next.
In this article
- What is a year-over-year comparison in a travel review?
- Why do three systems give three year-to-date totals?
- Which time slices should a year-over-year comparison use?
- What does an executive travel review need?
- Why does a prepared report run out of answers?
- What do executive teams ask in a travel review?
- What happens when the data contradicts the assumption?
- Why should a supplier review show share as well as spend?
- Which approach survives the follow-up question?
- Frequently asked questions
- Where Overture and Cogent fit in an executive travel review
What is a year-over-year comparison in a travel review?
A year-over-year comparison in a travel review sets one metric for a period, such as air spend, room nights or average ticket price, against the same period a year earlier. Matching the months removes seasonal swings, so the change it shows belongs to the programme rather than the calendar.
The calculation is simple, and it rests on two conditions: both periods are counted the same way, and both figures come from the same place. An executive travel review runs into trouble when either condition breaks without anyone noticing.
Why do three systems give three year-to-date totals?
Because each system defines the metric slightly differently and refreshes on a different cycle. At a global pharmaceutical manufacturer, the same year-to-date air spend figure was reported three ways: the ticket-level dataset ran 8.6% above the consolidated dataset, and the executive's own dashboard showed a third, rounded figure.
All three were right about what they counted. One included refunds and exchanges, one did not, and the dashboard rounded a figure that was already stale.
When two of the organisation's own systems disagree by 8.6% on the same months, the meeting turns from the decision to the data. The travel lead then spends the time defending a gap the systems produced.
Four differences produce these gaps:
- Different definitions: gross against net of refunds and exchanges.
- Different refresh cycles: a dashboard built on an older extract.
- Different scopes: one entity, one region or the whole group.
- Different currencies: converted at different rates on different dates.
Which time slices should a year-over-year comparison use?
Use at least two: the year to date against the same months a year earlier, for position against budget, and trailing twelve months, for the trend with seasonality removed. Quarter over quarter shows recent movement, and full year against full year settles supplier and contract performance once the year has closed.
The table sets out what each comparison shows and where it misleads.
No single slice is enough on its own. An executive shown only the year to date will ask what the trailing twelve months says, and the answer needs to exist before the question does.
How do you calculate year over year growth?
Year over year growth is the change between two matching periods, divided by the earlier period's figure and multiplied by 100. In an illustrative example, air spend of £4.0 million for January to June in one year and £4.4 million for the same months of the next is growth of 0.4 divided by 4.0, or 10%.
Read the result against the market as well as the budget. GBTA's Business Travel Index Outlook, published on 3 August 2026, forecasts global business travel spending to grow 7.2% in 2026, to a record $1.71 trillion, after growth of 8.4% in 2025.
Set beside that rough external benchmark, a programme growing faster is either buying more travel or paying more for it, and the comparison should say which.
What does an executive travel review need?
Four things: year-over-year comparisons at more than one time slice; the trajectory of spend, volume and average ticket price; breakdowns by business unit, region and supplier, with share beside spend; and figures that hold up when the follow-up question comes.
Spend, volume and average ticket price move for different reasons, and the trajectory has to show all three. Spend up 10% on flat volume means prices rose, while spend up 10% on volume up 15% means each trip got cheaper.
An executive who sees only spend cannot tell which of the two happened, and that is the first thing they will ask.
Why does a prepared report run out of answers?
Because the report is a snapshot and the questions keep moving. The deck answers what was asked when it was built, and the first question one level deeper falls outside it, so the only available answer is that someone will come back with the figure after the meeting.
The meeting then proceeds on opinion, and credibility in the room is won or lost on that follow-up question. The pattern applies with the most force to the quarterly business review deck, rebuilt each quarter with the same structure and fresh data, because its structure is fixed before anyone knows what will be asked.
What do executive teams ask in a travel review?
They ask for a comparison, then immediately for the driver behind it: which supplier, business unit or route moved the number. A prepared pack answers the first question and has to stop before the second, because nobody knew in advance which driver would be asked about.
Briefs of this kind look like this:
- "Compare year-to-date air spend and ticket volume against like-for-like periods in the two prior years."
- "Show Q1 against Q1 for room nights and hotel spend."
- "Now give me the same summary for one hotel chain specifically."
- "Compare full year against full year and identify the key cost drivers."
- "Show top ten carriers, destination countries, origin and destination pairs and departments for the period."
These query patterns are drawn from live enterprise deployments of Cogent, the agentic travel and expense management software, with route, region and business-unit names removed. PredictX does not name a client without its written permission. The deployment figures in this article were produced by Cogent from each organisation's own travel and expense data, and are held with their method in our evidence records.
The third brief is the follow-up nobody prepared for. It decides whether the review continues on evidence or on instinct.
At a global consumer brand, a year-to-date car rental query returned 1,650 rental days and the spend against them in a single pass, with property-level and chain-level drill-down available in the same session.
What happens when the data contradicts the assumption?
The decision changes before anyone acts on the assumption, because the comparison shows which way the figure actually moved. At a global healthcare group, leadership expected one entity's travel spend to be up. The analysis showed it had fallen 31.1% year on year.
An assumption that would have driven a cost-control intervention turned out to be exactly backwards. The intervention was dropped, and the budget conversation went somewhere more useful.
This is the less obvious value of a comparison that can be run during the meeting: a wrong premise is caught before decisions are built on it.
Why should a supplier review show share as well as spend?
Because spend alone cannot show whether a supplier relationship is working, and share can. Share tells you whether a volume commitment was met, whether consolidation is working and what position to take at renewal, and it comes from the same query as the spend.
At a global healthcare group, spend with one hotel chain came to roughly 36% of the group's total spend in that category.
The share is where strategic sourcing before the RFP starts: whether to consolidate further, hold the position or move volume at renewal.
Which approach survives the follow-up question?
Only live analysis answers a question nobody anticipated. A dashboard answers the questions it was modelled for, a prepared deck answers the questions asked when it was built, and an analyst on call answers the rest once the meeting is over.
The table compares four ways of running an executive travel review.
What separates the four is whether the analysis can move when the conversation does.
Sources behind the figures
Frequently asked questions
What is a year-over-year comparison?
A year-over-year comparison measures one metric for a period against the same period a year earlier, such as air spend from January to June against the same months of the prior year. Matching the months removes seasonal swings, so the change reflects the programme rather than the calendar.
How do you calculate year over year growth?
Subtract the earlier period's figure from the later one, divide the result by the earlier figure and multiply by 100. Air spend of £4.0 million in the first half of one year and £4.4 million in the same half of the next is growth of 10%. Compare like-for-like periods, counted the same way.
Why do our travel systems report different year-to-date totals?
Because each system defines the metric differently and refreshes on its own cycle. Gross against net of refunds, different entity scopes and currency converted on different dates will each produce a materially different total from the same underlying trips. Agree one definition before comparing any two periods.
What is the difference between year to date and trailing twelve months?
Year to date runs from the start of the financial or calendar year to the latest closed period, so it shows position against budget but shifts with the cut-off date. Trailing twelve months always covers the latest full year of activity, which removes seasonality but is slow to reflect a recent change.
What should an executive travel review cover?
Four things: year-over-year comparisons at more than one time slice; the trajectory of spend, volume and average ticket price; breakdowns by business unit, region and supplier, with share beside spend; and figures that hold up when the follow-up question comes. Anything less invites a question the review cannot answer.
How long should an executive travel review take to prepare?
The preparation that matters is agreeing which systems feed the figures and how each metric is defined. Once the data is consolidated, Cogent returns a year-to-date comparison in seconds, based on enterprise deployment patterns, individual results vary. The remaining time goes on deciding which comparison leads the review, and why.
Where Overture and Cogent fit in an executive travel review
Overture, PredictX's executive reporting for corporate travel, writes the monthly executive briefing from the organisation's own data: spend against the prior year, position against plan, what changed and what needs a decision. Its briefing and the workspace beneath it read from one detection run, so the number the CFO quotes is the number the travel manager is working from.
When the follow-up comes, Cogent sits on the same page, scoped to the same monthly snapshot, and answers it from the figures the briefing was written from. The quarterly review still happens, and the monthly briefing feeds it.
Before either, there is a test anyone can run. Ask your systems for the same year-to-date figure and compare what comes back: the variance is your reporting problem, stated as a number.
Related Posts
Agentic AI in Corporate Travel: The Complete 2026 Guide
.webp)
Beyond Dashboards: Cogent - The Agentic AI Revolution in T&E Reporting & Expense Audit
