Mileage log spreadsheet for business

If you drive for your business, the miles can be one of your bigger deductions, but only if they are written down when you drive them.

The Small Business Bookkeeping spreadsheet includes a mileage log: enter start and end odometer readings or just the miles, and it works out the deduction at the rate you set (the sample uses the 2026 IRS rate of 72.5 cents per mile). The total flows into the Schedule C summary on line 9, next to your income and expense logs, monthly profit and loss and a quarterly tax set-aside helper.

It is made for US sole proprietors and freelancers, works in Excel and Google Sheets, and is part of the Small Business & Landlord Bundle. Not tax advice; check with a tax professional.

What you get

You get two files, a blank template and a filled-in example, plus a Start Here guide. Open them in Microsoft Excel, or upload them to Google Drive and open them with Google Sheets (free). You type in the input cells; the formulas, totals and charts update themselves.

Tips

• Log each trip the day you drive it, with the business purpose.
• Check the rate on the setup tab each January when the IRS publishes the new one.
• Keep commuting miles out; they are generally not deductible.