# Total your mileage log for taxes

> Markdown version of https://stella.sh/how/money-household/mileage-log-for-taxes for agents and LLMs.
> Total business miles per month from your car log, personal trips out, and the 2026 claim at both IRS rates (72.5¢, then 76¢ from 1 July). Excel, or Stella (stella.sh).

Add up the business trips in your log month by month, working out miles from the odometer where you didn't write them down, and leave out personal driving and commuting. For 2026 the IRS standard rate is 72.5¢ a mile for January to June and 76¢ from 1 July, so multiply each half separately. Stella (stella.sh) totals the log you already kept, looks the current rate up on IRS.gov, and saves a spreadsheet you can keep adding to. Not tax advice.

- Checked: 14 November 2026
- Stella does it on: Windows, Mac, Linux

## Stella doing it

Recorded 14 November 2026 on Linux (Omarchy) with Claude Code with Opus, on a Claude plan.
Result: About 3 minutes. Checked afterwards against an answer key written before the run: business miles right for every month January to October, 2,799 for the year, personal trips left out, and the claim worked out with both 2026 rates: $2,071.77 against the key's $2,071.76, the cent from rounding each month. The car log is fictitious, made for this run. Using 72.5¢ for the whole year, as older calculators do, would have failed. The work is sped up 15×.

Video (49 s): https://stella.sh/media/proofs/money-household/mileage-log-for-taxes/proof.mp4

Transcript:

- 0:00 Stella on a Linux computer. A car log spreadsheet for 2026 is in Documents.
- 0:02 The prompt: business miles per month and for the year, and the claim at this year's IRS rate.
- 0:16 Stella replies: it will total the business miles and use the official 2026 rate from irs.gov.
- 0:21 Reading 113 trips and checking the IRS rate, sped up 15×.
- 0:34 Done: 2,799 business miles, $2,071.77 using both 2026 rates, and one trip to check.

What Stella does:

1. Finds `Car log 2026.xlsx` in Documents: 113 trips from January to October, many with blank miles
2. Works out the missing miles from the start and end odometer readings, and reads entries like `24 (round trip)` as 24
3. Leaves out every trip marked Personal, including a 388-mile vacation, and counts the rest as business
4. Looks up the 2026 rate on IRS.gov and finds the mid-year change: 72.5¢ to June, 76¢ from July
5. Saves `Business mileage 2026.xlsx` next to the log with miles and claim per month, a Trips tab, and notes on how each trip was read
6. Flags one trip whose odometer readings don't fit its dates, and says moving it wouldn't change the claim

## The prompt to paste

```text
My car log for this year is in my Documents. Work out my business miles for each month and for the year so far, and how much I can claim at this year's IRS mileage rate. Save it as a spreadsheet.
```

## Total it yourself

1. **Fill in missing miles.** In your log, add a Miles used column: `=IF(D2="",C2-B2,D2)` takes the miles you wrote down, or end odometer minus start where you didn't. Check any trip that comes out negative or huge.
2. **Mark business and personal.** Add a Business? column. Commuting from home to your regular workplace is personal for the IRS; so are errands, school runs and holidays.
3. **Total each month.** Excel: `=SUMIFS(E:E, A:A, ">="&DATE(2026,1,1), A:A, "<"&DATE(2026,2,1), F:F, "Yes")` for January, and so on. Numbers: a Pivot Table with month in Rows.
4. **Apply the right rate.** For 2026: January to June miles × $0.725, July to December miles × $0.76, then add the two. Check IRS.gov for the year you're claiming; rates are set each December and occasionally changed mid-year.
5. **Keep the log itself.** The IRS expects a record made at the time: date, miles, where and why. Keep the original log with your tax papers, not only the totals.

## Where Stella stops

- Not tax advice. Whether you can claim mileage, and whether the standard rate or actual costs suit you better, depends on your situation; ask a tax professional.
- Stella counted everything not marked Personal as business, because that's how the log was kept. If your log mixes in commuting without saying so, it can't tell.
- It uses the rate IRS.gov shows on the day you ask. If the IRS changes it again, an old spreadsheet won't update itself.
- Your trip notes go to the AI model you use in Stella while it reads them, and it looks the rate up on the web.
- Recorded on Linux. On a Mac or Windows PC Stella may first install Python or a small spreadsheet library, which wasn't recorded.

## Questions

**What is the IRS mileage rate for 2026?**
For business driving, 72.5¢ a mile from 1 January to 30 June 2026 and 76¢ from 1 July to 31 December 2026, after the IRS raised it mid-year because of fuel costs (Announcement 2026-11).

**Can I claim my commute?**
No. Driving between home and your regular place of work is personal. Trips from work to a client, or between work sites, can count.

**What does a mileage log need for the IRS?**
For each business trip: the date, the miles, where you went and the business reason. Odometer readings at the start and end of the year help too.

**Can it total hours worked the same way?**
Yes: see [calculate hours worked from a timesheet](https://stella.sh/how/money-household/calculate-hours-worked-from-timesheet). Receipts for parking and tolls go in a spreadsheet with [receipts to spreadsheet](https://stella.sh/how/pdf-excel/receipts-to-spreadsheet).

**Is Stella free for this?**
Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.

**Can I control what Stella changes on my computer?**
Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.

Sources: [IRS: 2026 business standard mileage rate set at 72.5 cents a mile](https://www.irs.gov/newsroom/irs-sets-2026-business-standard-mileage-rate-at-725-cents-per-mile-up-25-cents), [Journal of Accountancy: IRS raises standard mileage rates for remainder of 2026 (76 cents from 1 July)](https://www.journalofaccountancy.com/news/2026/jul/irs-raises-standard-mileage-rates-for-remainder-of-2026/), [IRS Topic 510: Business use of car](https://www.irs.gov/taxtopics/tc510).

## Related problems

- [Calculate hours worked from a timesheet](https://stella.sh/how/money-household/calculate-hours-worked-from-timesheet.md)
- [Turn receipts into a spreadsheet for your expense report](https://stella.sh/how/pdf-excel/receipts-to-spreadsheet.md)
- [Make a budget from your bank statements](https://stella.sh/how/money-household/make-a-budget-from-bank-statement.md)
- [Find duplicate charges on your credit card](https://stella.sh/how/money-household/find-duplicate-charges-on-credit-card.md)
- [Convert OFX, QFX and QIF files to Excel](https://stella.sh/how/money-household/convert-ofx-to-excel.md)
- [How much have I spent on Amazon each year?](https://stella.sh/how/money-household/how-much-have-i-spent-on-amazon.md)

Get Stella: https://stella.sh/download. Free with the ChatGPT or Claude plan you already have.
