Skip to main content

How are mileage expenses calculated?

Yokoy calculates mileage costs by multiplying the distance traveled by the applicable mileage rate.

Yokoy Team avatar
Written by Yokoy Team
Updated over 3 months ago

In many countries, distance traveled with personal or corporate vehicles is a valid business spend. The most common way to reimburse mileage costs is to calculate the distance traveled and assign a corresponding rate per kilometer (or mile), giving the total amount to be expensed.

Yokoy manages mileage cost reimbursement using mileage rates. Yokoy admins can set up multiple mileage rates as required to handle various scenarios such as different reimbursement rates for electric versus combustion vehicles, or for sole drivers versus drivers with additional passengers.

Mileage rates are assigned to employees via employee policies. An employee policy can have one or more mileage rate assigned.

To calculate mileage reimbursements, Yokoy takes the destination and arrival location (from/to addresses) entered by the submitter, assigns the correct mileage rate, and calculates the amount to be expensed by multiplying the distance by the rate per kilometer (mile).

Calculating mileage distance

When creating a mileage expense, submitters can enter distances manually or calculate the distance automatically based on the departure and arrival locations by clicking Calculate the distance.

Yokoy uses the Google Maps Directions API to calculate the distance traveled between locations, according to the best/fastest route. It does not avoid tolls or highways when calculating the distance.

🚧 Differences in Yokoy mileage calculation

The Google Maps Directions API returns the most efficient route when calculating the mileage. Therefore, there may be a slight variation in the distance calculated with the Google Maps app due to other factors such as exact or approximate address of the departure and arrival locations, traffic on-route, route complexity, etc.

💡 Tip
For greater precision in automatic mileage calculation, enter exact addresses for the departure and arrival locations rather than an approximate location (i.e. Zurich city).

✏️ Note

Locations are stored in the mileage claim using the user‘s language. For example, for employees with Yokoy in German, the location is displayed using the German version of the address. However, the technical location used to calculate the distance is identical.

The route used to calculate the distance is shown on the map. A return journey can be simulated in mileage expenses by selecting the Round trip (double distance) checkbox, which simply doubles the distance calculated between the start and end location.

✏️ Calculate mileage in trips

Submitters can automatically calculate mileage in trips by selecting the Calculate mileage claim (to the next stop) checkbox. This automatically creates a mileage expense for the distance between stops.

Compliance in manually entered distances

For auto-calculated distances in mileage expenses and trips, submitters can manually override the distance by entering the number of kilometers (miles) in the Distance (one way) field. Yokoy admins can set up a compliance warning to detect any manual entries that exceed the auto-calculated distance by a given percentage.

Yokoy admins can set a threshold (%) by which manually entered mileage distances may exceed the auto-calculated distance provided by Google Maps in Admin > Company > Compliance.

The compliance message is only displayed when the user has automatically calculated the distance, either by clicking Calculate the distance or selecting the Calculate mileage claims (to next stop) checkbox. If the user enters the distance manually, the message is not displayed.

Setting up mileage rates

Mileage rates are set up in Admin > Mileage rates. Only Yokoy admins with admin user permissions can edit mileage rates.

Mileage rates can be valid indefinitely or valid for a fixed period (Valid from/to).

Mileage rate types

There are two types of mileage rate that can be used to calculate mileage costs:

  • Fixed rate

  • Stepped rate

Fixed rate calculation

With this mileage rate type, a single fixed rate is applied per number of kilometers driven by the submitter. For example, 0.30 EUR for every kilometer driven. The amount paid then is directly related to the number of kilometers driven:

In some countries, instead of a global rate for all types of vehicles, there may be a single rate for different criteria:

  • Engine size

  • Combustion type

  • Vehicle type

With the fixed rate, the rate is applied for the entire distance entered in the mileage expense. For example, with a mileage rate of 0.300 EUR/km, if an employee takes a trip from Barcelona to Stockholm (2746.4 km), then the reimbursement is calculated to be 823.92 EUR.

Stepped calculation

The stepped mileage rate type is a variable rate that depends on the number of kilometers driven. You can set up multiple intervals with different reimbursement rates. When the number of accumulated kilometers exceeds the threshold of one interval, the rate of the next interval is applied for the subsequent number of kilometers.

For example, customers can set up a range of intervals, such as:

  • Up to 5000 km: 0.300EUR/km

  • 5001 - 20000 km: 0.350 EUR/km

  • 20001+ km: 0.505 EUR/km

If an employee takes a round trip from Barcelona to Stockholm (2746.4 km x 2 = 5492.8 km) with stepped mileage rate:

  • Up to 5000 km: 0.300 EUR/km

  • 5001 - 20000 km: 0.350 EUR/km

  • 20001+ km: 0.505 EUR/km

The reimbursement is calculated as follows:

  • 5000 km x 0.3 EUR = 1500.00 EUR

  • 492.8 km x 0.35 EUR = 127.48 EUR

Total reimbursement: 1627.48 EUR

Mileage rate eligibility

Yokoy controls the number of kilometers (miles) entered as part of mileage expenses or trips by employee. Yokoy tracks an employee’s accumulated mileage over a given period using an internal counter. The mileage counter can be configured by the Yokoy admin (Admin > Company > Expense report definition) to be reset at the end of every month, end of the year, or never.

The eligibility of a mileage rate for a mileage expense is determined by three factors:

  • the employee’s mileage counter

  • the mileage rate’s minimum number of kilometers

  • the mileage rate’s maximum number of kilometers

When employees create a mileage expense, Yokoy tries to automatically assign the correct mileage rate based on its eligibility. Only rates whose minimum number of kilometers matches the employee’s mileage counter are shown. For example, a Yokoy admin has set up these mileage rates:

  • Mileage rate A: minimum mileage 2000 km

  • Mileage rate B: minimum mileage 50000 km

If the employee’s accumulated mileage counter is 20000 km, only mileage rate A is eligible. The maximum mileage determines the cutoff rate after which a mileage rate is no longer eligible for application.

If no minimum or maximum number of kilometer is set in the mileage rate, the mileage rate can be used in all mileage expenses created by the employee.

Where a Yokoy admin has set up multiple mileage rates with similar minimum and maximum mileage, the order in which the mileage rates are selected can be determined by setting a value in the Mileage rate priority field. The higher the value, the higher the priority the mileage rate has over other eligible mileage rates.

Minimum distance for trips

Yokoy admins can establish a minimum threshold for reimbursement of mileage for a journey in a trip using the Minimum distance to travel to apply mileage checkbox in Admin > Company settings, Enable trips. If set, Yokoy only calculates mileage after an initial distance has been traveled. In other words, mileage is only calculated after the submitter has driven the distance specified as part of a trip.

✏️ Note
If the distance is less than the minimum distance to travel, then the mileage expense is not created in the trip.

🚧 Warning

This setting does not apply to mileage expenses not created as part of a trip. To set a minimum distance, you need to set up a zero amount mileage rate (i.e. a rate of 0 with minimum distance 0 to 100 km to set a minimum distance of 100 km).

Minimum distance for reimbursement

As an alternative to setting up a stepped mileage rate with a zero rate for kilometers (or miles) traveled up to a specific threshold, you can set the minimum distance for reimbursement in each mileage rate in which you indicate to Yokoy the number of kilometers to be ignored before starting to calculate the reimbursement.

For example, if an employee travels 121.57 km. The company uses a simple mileage rate of 0.16 EUR per kilometer and sets a minimum distance for reimbursement of 100 km.

The calculation for reimbursement is as follows:

  • 1st calculation = 100 km * 0 = 0 EUR

  • 2nd calculation = 21.57 km * 0.16 EUR/km = 3.45 EUR

Mileage rates by applicable countries

Mileage rates can have a global scope or be country-specific (Applicable countries). By default, rates are applied globally.

You can set up a mileage rate that applies to a specific country only. For trips taken within the country, that mileage rate is applied. For cross-border trips, several mileage rates may be taken. For example, you may want to set up separate mileage rates for Germany, Switzerland, and France.

  • Mileage rate 1 (Germany only)

  • Mileage rate 2 (Switzerland only)

  • Mileage rate 3 (France only)

If an employee takes the following journeys, Yokoy calculates the applicable mileage rate as follows:

  • Munich to Zurich - Mileage rate 1 is applicable

  • Zurich to Paris - Mileage rate 2 is applicable

  • Zurich to Munich - Mileage rate 2 is applicable

  • Paris to Munich - Mileage rate 3 is applicable

  • Barcelona to Paris - No mileage | No rate applicable as there is no rate set up for Spain

  • Paris to Barcelona - Mileage rate 3 | The journey originated in France

  • Lisbon to Barcelona - No mileage | No rate applicable as there is no rate set up for Portugal

VAT in mileage expenses

Mileage expenses may or may not include tax (VAT) according to the country. You can choose whether VAT is applicable to mileage expenses by going to Admin > Company, Enable VAT input tax deduction, and selecting the Enable VAT for mileage expenses checkbox.

In mileage expenses generated as part of a trip, VAT can be automatically populated by enabling Auto generate VAT for mileage expenses. In mileage expenses created individually, users must enter the corresponding VAT amount manually.

Mileage analytics

Managers and finance users can generate a report on mileage expenses in Analytics. The report displays the distance traveled as a dimension.

To generate a mileage report:

  1. Choose the filter criteria and the row data you want to see, and select Travelled distance (Mileage) in the Values (aggregated) dropdown field:

  2. Press Generate Report. The report looks similar to this:

You can download the generated report by clicking the report link displayed in the Results section.

Did this answer your question?