10 free Excel and Google Sheets templates for freelancers, 1099 contractors and small businesses: IRS-style mileage logs, receipt and expense trackers, and sheets that sort costs by Schedule C line. We opened every page on November 10, 2026 and noted any catch. Nearly all of these publishers sell an app that does the same job automatically, and we say so on each card.
Short on time? Start here.
Keeper's Google Sheet, or MileLock's Excel file if you like odometer readings.
Barespend's plain CSV or Shoeboxed's expense report.
SnapBooks' tracker or Shoeboxed's 1099 tracker fill in the tax line for you.
SimpleLifeCalc's planner tracks platform fees and product costs too.
IRS Publication 463 asks for the date, the destination, the business purpose and the miles for each business trip, plus your total miles for the year. Write trips down at or near the time; updating weekly is generally treated as timely, while rebuilding a year from memory in April often doesn't hold up. Note your odometer on January 1 and December 31, and leave out your regular commute. For 2026 the standard business rate changed mid-year (72.5 cents a mile through June, 76 cents from July 1), so pick a template that applies the rate by trip date. Ask a tax professional about your own situation.
Licenses and availability can change. Read each publisher's terms before you redistribute anything. These are record-keeping tools, not tax or accounting advice. Rates shown are the publishers' 2026 US figures; UK and Australian readers need a local template.
A Google Sheet with columns for purpose, date, start, end and miles, plus a business/personal dropdown. It works out each trip's deduction at the 2026 IRS rate for that date (72.5 cents through June, 76 cents from July).
Works out miles from odometer readings and the deduction at the right 2026 rate by date. A Summary tab totals the numbers for the car lines of Schedule C. There's also a two-page printable log and a blank CSV.
Four fields per trip (date, destination, purpose, miles) with automatic totals and the deduction at the 2026 rate. Comes as a one-click Sheets copy, an .xlsx, a one-page PDF and a CSV.
Date, destination, purpose and miles with the 2026 IRS rate built in and the deduction worked out. Driversnote also has a pre-filled version for delivery drivers on its blog.
One row per receipt with a 15-category dropdown and month-end totals. Available as .xlsx, a Sheets copy, a printable PDF and a CSV for your accountant.
A bare CSV with date, merchant, category, business purpose, amount, payment method, receipt kept and needs-reimbursing columns, plus a suggested category list. No formulas, so it's the simplest start.
20 categories matched to Schedule C lines, a business-use percentage for mixed costs, meals cut to 50%, an income tab for 1099-NEC and 1099-K amounts, and a Schedule C summary.
Schedule C category dropdown, monthly and category totals, a business-use % column, a built-in mileage tab and a dashboard of deductible totals.
Pick a category and the sheet fills in the Schedule C line and deductible amount (meals at 50%, phone at your business share). Extra tabs: a Schedule C summary, a home-office log comparing both methods, and a mileage log.
A 12-tab workbook for online sellers and side hustles: income and expense logs with 500 rows each, platform fees, product costs, a tax set-aside estimate from a percentage you pick, monthly summary and dashboard. No macros.
WorkFlow Fix Studios builds and fixes custom Excel and Google Sheets workflows for small businesses, such as an expense log that imports your bank or card export and sorts it by Schedule C line, or a mileage sheet that feeds your monthly totals. It starts with a fixed-price $149 pilot.