Guides
Expense report template with mileage log: field review
Review an expense report template with mileage log for report fields, approvals, per diem, and mileage records; field completion does not prove tax treatment.
What to take away
- Use 95 percent as an internal field-completion target on a sample of at least 20 mileage lines. It is not an IRS threshold; a low result is a cue to review the form and submission process.
- For an expense report template with mileage log, count lines carrying all four elements the IRS expects: date, destination, business purpose and miles driven.
- The score measures completed fields only. It cannot show that a drive happened, that it was ordinary and necessary, or who paid for it.
- Per diem is determined from a published schedule rather than measured, and the first and last travel days may be prorated under the applicable policy.
- Employee reimbursements and the self-employed deduction land on different forms, so one log can feed two filings.
What each mileage line must carry
Reusable blank expense report template
- Report headerEmployee ____ | Department ____ | Reporting period ____ | Submitted ____ | Due date (policy-defined) ____.
- Expense rowTransaction date ____ | Merchant/payee ____ | Category ____ | Business purpose ____ | Amount ____ | Payment method ____ | Receipt attached? ____ | Exception explanation ____.
- Travel/per diemLocality ____ | Travel dates ____ | Nights ____ | Rate schedule ____ | Lodging ____ | Meals and incidental expenses ____.
- Mileage log rowDate ____ | Destination ____ | Business purpose ____ | Miles driven ____. Record tolls and parking on separate expense lines.
- Review and approvalEmployee certification ____ | Manager reviewer, decision, and date ____ | Finance review and reimbursement status ____.
Set receipt thresholds, eligible categories, and submission deadlines in employer policy; the blank fields do not imply a universal threshold or deadline.
Call it the field-completion rate. For a review sample, count all mileage lines in the sample. Count the lines holding a date, a destination, a stated business purpose and a miles figure. Divide that count by the number of mileage lines in the sample.
The IRS asks for the same four elements. Publication 463 sets the recordkeeping rule and the standard mileage rate for the tax year; it does not set a 95 percent field-completion target. This review checks whether the log is complete, not which reimbursement rate applies or how much to reimburse.
[figure 1]
The substantiation rate
95% | threshold to clear
4 | required elements per line
date, destination, business purpose, miles | what to count
A log that names the purpose in three words beats a log carrying a receipt and no explanation.
| Line type | What proves it | Frequent failure |
|---|---|---|
| Local business miles | Date, destination, purpose, miles | Purpose left blank |
| Client site visit | The same four fields plus the client name | Destination written as office |
| Airport run | Date, airport, purpose, miles | Round trip logged as one line |
| Tolls and parking | Receipt tied to a dated trip | Receipt with no trip attached |
[figure 2]
Line type proof
- Local business milesdate, destination, purpose, miles
- Client site visitsame four fields plus client name
- Airport rundate, airport, purpose, miles
- Tolls and parkingreceipt tied to a dated trip
Tolls and parking sit beside mileage rather than inside the business total, so keep them on their own lines. None of the table holds unless the purpose field is mandatory at entry, and that rule is policy. Check the wording against an employee handbook template by state before you adopt it.
Example: a quarter that clears the line
One driver logs 40 mileage lines in a quarter. Two lines have no purpose and one has no destination. Three failures in 40 works out at 92.5 percent, below the internal target.
- Make the business purpose a required field, so the report cannot be submitted without it.
- Re-measure next quarter using mileage lines as the unit of count.
- If two quarters in a row stay under 95 percent, review both the form and submission habits before deciding what to change.
The next quarter holds 40 lines and one failure. That reads 97.5 percent and clears the internal field-completion target, but it does not by itself establish the report's accuracy or tax treatment.
Per diem is a schedule, not a measurement
Meals and lodging rates are published by city and by month. GSA per diem rates list them for federal travel, and many employers adopt the same schedule. Use the Phoenix / Scottsdale FY 2026 lookup as an example; its page displays daily lodging rates and Meals and Incidental Expenses rates. What is left to count is nights and days.
If you pay contractors rather than employees, the payer side changes, and the W-9 and W-8BEN guidance for contractor payments explains which form to collect first.
Under the GSA federal travel schedule, the meals and incidental expenses rate for the first and last travel days is generally 75 percent of the locality's daily rate. Employers using per diem should state in policy whether they follow that proration.
Per diem is a schedule
| Day | Type | Meals rate applied |
|---|---|---|
| Wednesday | Travel out | 75 percent of the daily rate |
| Thursday | Full work day | 100 percent |
| Friday | Travel home | 75 percent of the daily rate |
That trip runs to two nights of lodging and 2.5 full meal days. A three-day trip with two travel days is never three full days of meals.
What the field-completion rate cannot show
The field-completion rate measures paperwork completeness. A neatly formatted log of personal errands scores 100 percent, so the number says nothing about whether a drive was ordinary and necessary.
It also says nothing about accuracy. A log can score 100 percent while the miles are inflated, because the rate counts fields rather than distances.
It cannot show who paid. A reimbursement under an accountable plan stays off the employee's W-2 and lands on the employer's return. The self-employed claim mileage on Schedule C instead.
Form 2106 covers unreimbursed employee expenses, though the itemized deduction for those has been suspended since 2018. Scope is the final limit, since per diem, tolls and client meals all sit outside the rate.
Mileage claimed without a purpose note sits with the other quiet failures in the profit and loss forms mistakes list, because a total on its own is not evidence.
Review quarterly, then stop
Measure quarterly rather than weekly. A weekly review produces noise and no decisions. A quarterly rate above the internal 95 percent target means the template's required fields are being completed consistently, not that the report is accurate or tax-deductible. Use the usual review process before filing.
Below 95 percent, change one thing and re-measure. If two quarters in a row sit under the line, review both the template and submission habits before deciding what to change.
Once the log clears the threshold, the work left is retention. Publication 535 covers which business expenses are deductible and which records support them.
