First page of the Business Travel Emissions CalculatorExcel workbook preview

GHG Protocol carbon accounting

Business Travel Emissions Calculator

Business travel emissions calculator in Excel: flights by haul and class, rail, car, taxi and hotels with DESNZ 2025 and EPA factors and an RF switch.

Excel workbook · 18 KB Built on free official texts

3 free downloads per account. Just your email and a 6-digit code.

Need more than 3? Every template for $249, once. Lifetime access, including the templates we add later. See pricing

About this template

Business travel is Scope 3 category 6 under the GHG Protocol: flights, trains, taxis, rental cars and private cars used for work, in vehicles the company does not own. Hotel stays may be added. It is often one of the first Scope 3 categories finance is asked for, because the data already arrives through the travel agency and expense claims.

This calculator uses the distance-based method. Flights to and from the UK, rail, taxis, cars and hotels use the UK DESNZ 2025 conversion factors, with and without the non-CO2 effects of aviation. Flights within North America use the US EPA GHG Emission Factors Hub 2025, Table 10, by distance band. Each trip keeps both radiative forcing results, so the reporting choice can change without re-entering data. The summary is built from formulas.

Who it is for

The finance or HR manager asked to report the carbon footprint of staff travel from the travel agency report and expense claims.

What is inside

  • Trip Log with 12 worked trips and 20 blank rows, km or miles converted automatically
  • 24 factors: DESNZ 2025 flights by haul and class, rail, taxi, car and hotels, plus EPA Table 10
  • Radiative forcing switch for flights, with both results kept per trip
  • Hotel rows by room-night for the UK, London, US, Netherlands and Germany
  • Summary by mode, by department and by month
  • Flights with and without radiative forcing compared on the Summary
  • Red flag for a missing distance on any non-hotel row

How to use it

Paste the trips from your travel agency report into the Trip Log, one row per journey.

Files

  • XLSXbusiness-travel-emissions-calculator.xlsx18 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.

Questions about this template

Should flight emissions include radiative forcing?

DESNZ advises organisations to include the indirect, non-CO2 effects of aviation to capture the full climate impact, while noting the science is uncertain, and to report on the same basis every year. This calculator keeps both results for every trip and reports the one you choose on the Factors sheet.

Are hotel stays part of business travel emissions?

They are optional. The GHG Protocol Scope 3 Standard says companies may include emissions from business travellers staying in hotels. DESNZ publishes a factor per room-night by country, so this calculator records hotels on their own rows and shows them separately in the summary.

Where do company car trips belong?

Trips in cars the company owns or controls are Scope 1 mobile combustion, not business travel. Category 6 covers rental cars, taxis and employees' own cars used for work, because those vehicles belong to someone else. Record company cars in a Scope 1 calculator instead, using fuel or mileage.