Workflow · Reconcile · Opening soon

Mileage reimbursement log

Upload your exported Excel trip log and turn it into a mileage reimbursement report by employee and month. Commute trips are excluded and mileage is totalled at the IRS business rate.

Book a demo

Someone typed

“turn our trip log into a mileage reimbursement report by employee and month at the IRS rate”

The agent read it as

Turn our Mileage trip log into a mileage reimbursement report by employee and month at the IRS rate, using the 2026 business rate (72.5¢/mile) and excluding Commute trips.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

File

Mileage trip log

CSV export · 21 rows

Step

Exclude commutes and total mileage

Step 1

Result

Mileage reimbursement report

14 rows

Schedule

Runs when you say

Proposed

File
Mileage trip log
CSV export · 21 rows
Step
Exclude commutes and total mileage
Step 1
Result
Mileage reimbursement report
14 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 14 rows came out.

Download Mileage trip log sample (21 rows)Excel: Trip Log worksheet > select used range > Copy as values

What you get back

The result of that run, the rows to look at first.

Mileage reimbursement reportSample data14 rows

Employee	Month	Reimbursable miles	Reimbursement
Avery Chen	2026-09-01	51.50	37.34
Mina Patel	2026-09-01	27.60	20.01
Jalen Brooks	2026-09-01	14.20	10.30
Mina Patel	2026-10-01	47.60	34.51
Priya Shah	2026-10-01	33.40	24.22
Ethan Ross	2026-10-01	82.60	59.88
Jalen Brooks	2026-10-01	28.40	20.59
Lena Morgan	2026-10-01	25.60	18.56
Avery Chen	2026-10-01	18.40	13.34
Jalen Brooks	2026-11-01	14.20	10.30
Avery Chen	2026-11-01	18.40	13.34
Sofia Nguyen	2026-09-01	9.80	7.11

14 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you turn a trip log into a mileage reimbursement report?

Export your trip log from Excel and upload the file. Mammoth excludes commute trips, totals the mileage, and calculates reimbursement by employee and month at the IRS business rate.

How it works

How to use the Mileage reimbursement report workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Mileage reimbursement report: questions

What file should I export from Excel?

Export the trip log as a spreadsheet file from Excel. Use the file that has the trip details you want to report on, such as employee, date, trip type, and mileage.

What happens to rows that do not match the rules?

Rows that do not meet the rules are left out of the result. For this workflow, that means commute trips are excluded before the mileage is totalled.

How do I change the rules?

You change the rules by changing the words that describe the workflow. For example, you can adjust which trip types to exclude, how to group the results, or which rate to use for reimbursement.