Side Hustle Bookkeeping Spreadsheet – Income, Expenses and Mileage for Excel and Google Sheets

Use this side hustle bookkeeping spreadsheet to log income, expenses and business mileage in Excel or Google Sheets. Review monthly profit and prepare an organized year-end summary, with tax set-aside estimates for planning.

WHAT'S INCLUDED
• Sample edition (.xlsx): the full 9-tab workbook filled with a fictional sample business, so you can see every feature working
• Blank edition (.xlsx): the same workbook ready for your business, with the sample entries cleared and every formula, drop-down, chart and setting kept
• Start Here PDF guide: which edition to use, plus setup steps for Google Sheets and Excel

9 TABS
• Start Here: quick start, color key and good habits
• Dashboard: gross income, expenses, net profit, margin, estimated tax set-aside, take-home, profit goal progress, missing receipts, next estimated payment, top expense categories and income by stream, with charts
• Income: up to 500 payments; gross, platform fees, net, payment account and expected tax form (1099-NEC, 1099-K, 1099-MISC)
• Expenses: up to 500 expenses with Schedule C categories, business use %, meals at 50% and a receipt check
• Mileage: up to 300 trips by odometer or miles, using the 2026 IRS standard mileage rates (72.5¢ through June 30, 76¢ from July 1). Both rates are editable
• Monthly Summary: income, expenses, mileage, profit and running total by month, plus income by stream
• Tax Estimator: an estimate of self-employment tax plus federal and state income tax on your side income, using the bracket and state rate you enter, a set-aside rate, and a quarterly payment planner
• Schedule C Summary: year-end totals arranged like IRS Schedule C, ready to hand to your tax preparer
• Settings: business name, tax year, goals, income streams, categories, payment accounts and yearly tax constants

COMPATIBILITY
✔ Google Sheets (free Google account; upload the file and open it with Google Sheets)
✔ Excel 2016 or newer, Windows or Mac
✘ Not designed for Numbers or LibreOffice
A computer is recommended for setup.

DIGITAL DOWNLOAD
This is a digital product. No physical item will be shipped. You'll receive a download link after purchase.

LICENSE
For your personal or single-business use. Please don't resell, share or redistribute the template.

PLEASE NOTE
• This is a record-keeping and planning tool, not tax, legal or accounting advice. Tax figures are estimates based on simplified rules for U.S. sole proprietors, and the Schedule C line placements are common choices for planning. Confirm with a qualified tax professional.
• Tax constants (mileage rates, Social Security wage base and others) are set for 2026. Update them in Settings each year.
• All sample names and amounts are fictional.

PAIRS WELL WITH
• Invoice and Quote Tracker
• Small Business Spreadsheet Bundle

Questions? Contact us through the shop and we'll help.

Designed by The Tidy Blueprint with the help of AI tools.