SD–TOOL–01 · United States · federal IRS rates · tax year 2026
One spreadsheet · 3 worksheets · it adds up as you type
The IRS changed the business mileage rate in the middle of 2026: 72.5 cents a mile to 30 June, then 76 cents from 1 July. Every mileage template that prints one rate for the whole year is wrong for half of it, and the driver using it has no way of knowing. The error is invisible until the return is questioned.
COLUMNS ONLY
You fill the first six columns. The last two work themselves out.
A mileage log that works out the claim for you. Type the date, where you went, why, and the miles. The sheet finds the rate that applied on that date and works out the dollars, so the July change is handled without you thinking about it. Business, medical and charitable rates are all in it. The formulas are locked so a stray paste cannot break them, and the columns you fill in are open. If you type a date the IRS has not published a rate for, it says so instead of quietly using the wrong number.
Before a document is downloaded, Simply Digital checks that its listed information is still current.
What lands in your inbox
There is no bundle here and nothing to assemble. It opens in any spreadsheet app and adds the total up for you as you type, which is the whole reason it is not a PDF.
The rest of the set
Businesses like yours usually start with these. It is where a trade starts, not a complete legal inventory of everything it could ever be asked for — no list on any website is that. Every line below says where it came from.
Showing what a bookkeeping & accounting practice is asked to carry. It is the only trade on our list that needs this document.
Bookkeeping & accounting practiceSix items on the list, one of them a multi-file kit rather than a single document. You are looking at one of them. We sell three of the other five; two we do not have yet.
REGA regulator asks for this, and which one depends on your state.
OURSNot a rule we can point at — this is what the trade gets asked for.
Also answers: Client onboarding questionnaire.
OURSNot a rule we can point at — this is what the trade gets asked for.
OURSNot a rule we can point at — this is what the trade gets asked for.
Named because leaving them out would make the list look complete when it is not. Tell us which one you need and it goes on the build queue with your trade attached.
OURSNot a rule we can point at — this is what the trade gets asked for.
COMPNot a rule we can point at — it is standard in this trade.
Your state can add to this. We have written down two places where this trade’s set differs from one state to the next. What we sell is written to the federal baseline, and a state that runs its own programme can ask for more than the federal rule does.
Print this checklistInside the file
01A 300-row mileage log that works out the dollar claim as you type
02The rate is picked from the date you enter, so the 1 July 2026 change from 72.5 to 76 cents is handled without you tracking it
03Business, medical and charitable rates, all three, each applied by date
04A running total of miles and dollars pinned at the top where you can always see it
05A dropdown on the type column, so a typo cannot silently break the calculation
06The published IRS rate table on its own sheet, each period showing the IRS release it came from
07A plain-English page on what the IRS expects a mileage record to contain, and what this sheet deliberately will not do
08Every sheet protected so a stray paste cannot destroy the formulas, with your entry columns left open
Plain-English Monday actions
Questions
For business miles, 72.5 cents a mile from 1 January to 30 June 2026, and 76 cents from 1 July to 31 December 2026. The rate sheet shows both periods with the IRS release each came from, IR-2025-128 and IR-2026-29, read from irs.gov on 16 September 2026.
It reads the date you type and applies the rate that was in force on that date, then works out the dollar claim. You type the date, where you went from and to, why, and the miles, and pick Business, Medical or Charity.
The log's own guidance: a record kept at or near the time of the trip, showing the date, the mileage, the destination and the business purpose. There is a column for each, and the purpose column is the one people leave blank.
No. It does not decide whether a trip is deductible or choose between the standard mileage rate and actual vehicle expenses. It is not tax advice; that choice belongs with your accountant.
Official-source registry
These are the real rules this plan is built on. Every citation was read against the published text on the date shown above, and each link goes to the official source, not to a summary.
Exclusions
