Accountants Travel Expense (Hourly) Formula
Learn how hourly travel time, mileage, parking, tolls, other costs, and the billable percentage determine a client travel expense estimate.
This calculator estimates the total cost of a work-related trip and the share allocated to a client. It separates travel time, mileage, and direct expenses so firms can see both the total trip cost and any amount left non-billable.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Billable Travel Expense
Where:
First add the cost of travel time, mileage, parking, tolls, and other eligible trip costs. Then multiply that total by the percentage that will be charged to the client.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| travelHours - Travel time | Total time spent travelling for the trip, including both directions when applicable. | hours |
| hourlyRate - Hourly travel rate | Hourly amount charged or internally allocated for travel time. | currency |
| mileage - Total mileage | Total miles travelled for the work-related trip. | mile |
| mileageRate - Mileage rate | Amount reimbursed or allocated per mile. | currency |
| parkingTolls - Parking and tolls | Combined parking fees, tolls, congestion charges, and similar direct costs. | currency |
| otherExpenses - Other travel expenses | Other directly related travel costs entered separately. | currency |
| billablePercentage - Billable percentage | Percentage of the total travel expense allocated to the client. | percent |
Step-by-Step Calculation
Calculate travel time cost
Multiply total travel hours by the hourly travel rate.
travelTimeCost = travelHours * hourlyRate
Calculate mileage cost
Multiply total trip mileage by the entered per-mile rate.
mileageCost = mileage * mileageRate
Add direct expenses
Combine parking, tolls, and other direct trip expenses.
directExpenses = parkingTolls + otherExpenses
Find total travel expense
Add time cost, mileage cost, and direct expenses.
totalTravelExpense = travelTimeCost + mileageCost + directExpenses
Apply the billable percentage
Calculate the portion of the total allocated to the client.
billableTravelExpense = totalTravelExpense * billablePercentage / 100
Find the non-billable amount
Subtract the client-billable amount from the total trip cost.
nonBillableTravelExpense = totalTravelExpense - billableTravelExpense
Worked example: fully billable client meeting trip
Travel time cost
3.5 * 85
$297.50
Mileage cost
42 * 0.67
$28.14
Direct expenses
18 + 12
$30.00
Total travel expense
297.50 + 28.14 + 30.00
$355.64
Billable travel expense
355.64 * 100 / 100
$355.64
Final Result
Estimated total travel expense: $355.64. Estimated billable travel expense: $355.64. Non-billable amount: $0.00.
Assumptions
- ✓Travel hours represent the complete work-related travel time entered by the user.
- ✓The hourly rate applies uniformly to every entered travel hour.
- ✓The mileage rate is applied to all entered miles.
- ✓Parking, tolls, and other expenses are additive and are not already included in the mileage rate.
- ✓The billable percentage is applied to the total trip cost rather than to individual cost categories.
Limitations
- !The calculation does not determine whether a particular expense is permitted, reimbursable, or chargeable under an engagement agreement.
- !It does not add, remove, or assess VAT, sales tax, payroll treatment, or other taxes.
- !Mileage and time rates can differ by firm, client, vehicle, location, or trip type.
- !Actual invoices, receipts, caps, and rounding policies may produce a different final amount.
Common Mistakes to Avoid
Entering one-way mileage when the entered travel time includes a return trip.
Using a standard client-service rate when the applicable travel rate is lower or different.
Adding parking or tolls twice when they are already covered by an internal mileage policy.
Entering 50 instead of 50% only where an input is expected as a percentage value.
Applying the billable percentage to travel time only instead of to the full calculated trip cost.
Treating the estimate as confirmation that a client or firm will approve the charge.
Related Formulas
Frequently Asked Questions
How is hourly travel expense calculated?
Travel hours are multiplied by the hourly travel rate. Mileage cost and direct expenses are added, then the billable percentage is applied to the total.
What is the formula for billable travel expense?
Billable travel expense equals (travel hours × hourly rate + mileage × mileage rate + parking and tolls + other expenses) × billable percentage ÷ 100.
How do I calculate non-billable travel cost?
Subtract the billable travel expense from the total travel expense.
Is mileage included in hourly travel cost?
No. In this calculation, mileage is a separate component based on miles travelled and the entered per-mile rate.
Does a 75% billable percentage mean 75% of every cost is charged?
Yes. The calculator applies 75% to the combined total of time, mileage, parking, tolls, and other entered expenses.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.