Self Employed Tax Spreadsheet, 1099 Expense Tracker and Mileage Log, Google Sheets

One spreadsheet for 1099 and side gig records: income, expenses by Schedule C line, a mileage log and a quarterly plan for what to set aside. For keeping records and planning. Not tax advice. Check with a tax professional.

WHAT YOU GET
• Self-Employed Tax and Mileage spreadsheet (.xlsx), blank and ready for your year
• The same spreadsheet filled in with a freelancer's year we made up, so you can see how it works
• A Start Here guide (PDF) with steps for Google Sheets and Excel
• Works with Google Sheets (free) and Excel 2016 or newer
• Set up for tax year 2026 or 2027

WHAT'S INSIDE
• Income: every payment by client or platform, with fees taken out and what landed in your account
• Expenses: pick a category and the matching Schedule C line fills in. Use your phone for work 60% of the time? Type 60%
• Mileage: date, purpose, start and end, miles. The deduction uses the IRS standard mileage rate for that date (2026: 72.5¢ a mile to June 30, 76¢ from July 1)
• Home Office: the simplified method, $5 per square foot up to 300 square feet
• Quarterly Taxes: the four due dates, the share you choose to set aside, a rough estimate and what you paid
• Year Summary: totals laid out like Schedule C, plus Part IV vehicle miles, ready to hand to your preparer
• IRS Figures: every rate and date the sheet uses, with where it comes from

HOW IT WORKS
1. Pick your tax year and the share of each payment you want to set aside.
2. Log income and expenses as they happen. Log drives the same day.
3. Check Quarterly Taxes before each due date and record what you paid.
4. At the end of the year, take Year Summary to your tax preparer or tax software.

HOW TO USE IT
• Google Sheets: the guide has a Make a copy link that puts your own copy in your Google Drive. Or upload the .xlsx to Drive yourself.
• Excel: open the .xlsx and start typing.
• White cells are yours to fill in. Shaded cells work themselves out.

GOOD TO KNOW
• For keeping records and planning. Not tax advice. Check with a tax professional.
• The tax estimate is rough on purpose. It leaves out the standard deduction, credits and other income, so your real bill can differ.
• IRS and Social Security figures were checked in October 2026. The 2027 mileage rate was not out yet; type it on the IRS Figures tab once the IRS announces it.
• Your records stay in your own file. We never see them.
• The names and numbers in the photos are made up.
• Designed by SoeSan Holdings LLC. The spreadsheet was built with the help of AI tools, and every formula was tested with a full sample year.
• For your own use. Please don't resell or share the file.
• Digital files only. Nothing is shipped.