Total your mileage log for taxes
A year of car-log entries as business miles per month and a claim at the right rates.
A real run on 14 November 2026, on a Linux computer, using Claude Code with Opus, on a Claude plan. The waiting is sped up; it took 3 min 56 s in real time.
The short answer.
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.
Stella does this on Windows, Mac and Linux.
What happened.
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×.
How Stella does it.
- Finds
Car log 2026.xlsxin Documents: 113 trips from January to October, many with blank miles - Works out the missing miles from the start and end odometer readings, and reads entries like
24 (round trip)as 24 - Leaves out every trip marked Personal, including a 388-mile vacation, and counts the rest as business
- Looks up the 2026 rate on IRS.gov and finds the mid-year change: 72.5¢ to June, 76¢ from July
- Saves
Business mileage 2026.xlsxnext to the log with miles and claim per month, a Trips tab, and notes on how each trip was read - Flags one trip whose odometer readings don't fit its dates, and says moving it wouldn't change the claim
The prompt.
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.
This is the exact prompt from the recording. If your files are somewhere else, say where.
Do it yourself.
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.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.
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.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.
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 it 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. Receipts for parking and tolls go in a spreadsheet with 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.
- IRS: 2026 business standard mileage rate set at 72.5 cents a mile
- Journal of Accountancy: IRS raises standard mileage rates for remainder of 2026 (76 cents from 1 July)
- IRS Topic 510: Business use of car
Checked against these sources on 14 November 2026.