Calculator Inputs
Use this tracker for one trip at a time. Enter cost items, deduction settings, reimbursement assumptions, and your target budget.
Example Data Table
| Example Field | Example Value |
|---|---|
| Trip Name | Client Discovery Tour |
| Client or Project | Northwind Studio |
| Trip Days | 4 |
| Airfare | 350.00 |
| Local Transport | 95.00 |
| Lodging | 480.00 |
| Meals | 165.00 |
| Miscellaneous | 75.00 |
| Distance Traveled | 140 miles |
| Mileage Rate | 0.65 |
| Per Diem Rate | 50.00 |
| Tax Percentage | 8% |
| Deductible Percentage | 80% |
| Reimbursable Percentage | 60% |
| Travel Budget | 1500.00 |
| Project Revenue | 3000.00 |
Formula Used
Mileage Cost = Distance Traveled × Mileage Rate Per Unit
Per Diem Total = Trip Days × Per Diem Rate Per Day
Subtotal = Airfare + Local Transport + Lodging + Meals + Miscellaneous + Mileage Cost + Per Diem Total
Tax Amount = Subtotal × (Tax Percentage ÷ 100)
Grand Total = Subtotal + Tax Amount
Deductible Amount = Subtotal × (Deductible Percentage ÷ 100)
Reimbursable Amount = Grand Total × (Reimbursable Percentage ÷ 100)
Out of Pocket = Grand Total − Reimbursable Amount
Remaining Budget = Travel Budget − Grand Total
Profit After Travel = Project Revenue − Out of Pocket
Converted Total = Grand Total × Exchange Rate
Tax, deduction, and reimbursement treatment vary by country, client contract, and bookkeeping method.
How to Use This Calculator
Enter the trip name, client, trip days, currencies, and exchange rate first.
Fill in each major travel cost, including airfare, local transport, lodging, meals, and miscellaneous spending.
Add distance traveled and a mileage rate if you bill or deduct mileage separately.
Enter your per diem rate, tax percentage, deductible percentage, reimbursable percentage, budget, and expected project revenue.
Press the calculate button to view totals above the form, study the category chart, and download the summary as CSV or PDF.
Frequently Asked Questions
1. What does this travel expense tracker calculate?
It totals your trip costs, mileage, per diem, taxes, deductible amount, reimbursable amount, out-of-pocket cost, budget status, converted total, and profit after travel.
2. What is the difference between deductible and reimbursable?
Deductible means the portion that may qualify for tax deduction. Reimbursable means the share a client repays. One affects taxes, while the other affects cash you recover.
3. Can I track mileage and transport together?
Yes, but avoid double counting. Use mileage for personal vehicle use, and local transport for taxis, rideshares, trains, buses, or rentals billed separately.
4. Why is there a converted total?
Freelancers often spend in one currency and report income in another. The converted total helps compare your actual trip spend against home-currency budgets and income.
5. What happens if my remaining budget is negative?
A negative value means your trip exceeded the planned budget. This can signal underpricing, overspending, or the need to renegotiate reimbursement terms.
6. Can I use this for per diem only travel tracking?
Yes. Enter zero for categories you did not spend on and keep the per diem rate active. The tracker will still calculate totals correctly.
7. Is this suitable for multiple trips?
This page evaluates one trip at a time. For multiple assignments, calculate each trip separately and save the CSV files for later consolidation.
8. Does this replace bookkeeping or tax advice?
No. It is a planning and tracking tool. Final reporting rules depend on your contracts, tax jurisdiction, reimbursement policy, and accounting practice.