Self-Employed Expense Tracker Template for Google Sheets (Free, 2026)

When you work for yourself, a consistent expense record helps you see what the business spent and prepare for your accountant. Record the business purpose of each cost, retain receipts and review the totals against your statements. This guide explains that routine; the spreadsheet does not determine deductibility or calculate a complete tax bill.

Who counts as self-employed

If you earn money working for yourself rather than as someone's employee, you're self-employed in the eyes of the IRS. Common examples include:

• Sole proprietors — a one-person business with no separate legal entity.
• Single-member LLC owners taxed as sole proprietorships — other tax elections can change filing requirements.
• Gig and contract workers — rideshare and delivery drivers, freelance shifts, and anyone paid on 1099 contracts.
• Side-hustlers — even if you have a day job, profit from a side business is self-employment income.

Sole proprietors generally report business activity on Schedule C. Other business structures or tax elections can require different forms. Confirm the requirements with your tax professional.

Why self-employment tax makes tracking matter more

Employees split Social Security and Medicare with their employer. When you're self-employed, you pay both portions yourself. The standard combined self-employment tax rate is 15.3%, generally applied to 92.35% of net earnings, with a Social Security wage cap and possible additional Medicare tax. Income tax is separate. See the IRS self-employment tax guidance. The number that matters is net profit, which is income minus your deductible expenses.

Missing records make it harder to assess your expenses accurately. Keep supporting documents and discuss the tax treatment with your accountant rather than assuming every recorded cost reduces every part of your tax bill.

Why Google Sheets is the right home for it

You could track expenses in an app, in Excel, or on paper. Google Sheets hits the sweet spot for self-employed people:

• Accessible in Google Drive. Keep a working copy and a separate backup of important records.
• Works everywhere. Log an expense on your phone right after you pay, review it on a laptop later.
• Easy to share. Give your accountant view access at tax time instead of emailing files back and forth.
• Optional bank imports. Avery for Google Sheets can import supported bank transactions, with categories and rules for you to review.

Choose the workflow you can maintain and review consistently.

How to track self-employment expenses (step by step)

Start from a template or build your own record. Check the fields and formulas before relying on the totals.

Step 1: Separate business from personal

The single biggest favor you can do your future self is a dedicated business bank account or card. Clean separation means almost every transaction is automatically a business one, which makes categorizing fast and makes your deductions far easier to defend. If you can't separate everything, document which costs are personal and how you determined any business-use share.

Step 2: Record your business details

Note which business and reporting period the records belong to. Ask your accountant which filing rules apply; a single-member LLC can have a different tax treatment if it has made an election.

Step 3: Use Schedule C categories

This is what separates a real self-employed tracker from a plain spending log. Each expense gets a category that maps to a line on Schedule C, so you have organised records to review before filing. The next section breaks these down in detail.

Step 4: Log expenses with documentation

For each business expense, record the date, amount, vendor, category, and a link to the receipt. Photograph receipts into a Google Drive folder and paste the link into the Receipt column. For anything part-personal — a phone plan, internet, a car used for both — enter the business percentage and review the calculation with your accountant.

Step 5: Review totals before planning tax payments

Reconcile your records against statements and share the reviewed totals with your tax professional. Estimated payments depend on more than business expenses, including other income, withholding and credits. The tracker is not a complete tax calculation or a verified tax-reserve tool.

Deductible self-employment expense categories (Schedule C)

The IRS standard for a deductible business expense is that it's ordinary and necessary for your line of work. Use the Schedule C expenses worksheet to help organise these categories. These are general categories, not a ruling on your specific situation — confirm anything borderline with your accountant.

• Advertising — ads, sponsored posts, business cards, and your website.
• Car and truck expenses — business mileage or actual vehicle costs for business use.
• Contract labor — payments to other contractors or freelancers who help you.
• Supplies — consumables and small items used in your work.
• Office expense — the everyday cost of running the business.
• Insurance — business liability and related coverage (handled separately from health insurance).
• Legal and professional services — accountants, lawyers, and other professional help.
• Rent or lease — workspace, equipment, or vehicle leases used for the business.
• Travel — flights, lodging, and transport for business trips.
• Meals — business meals, generally deductible at 50%.
• Utilities and phone — the business share of phone, internet, and similar costs.
• Software and subscriptions — the tools you run your business on.

Two deductions worth extra attention because self-employed people often miss them:

The home office deduction

If you use part of your home regularly and exclusively for business, you may be able to deduct it. There are two methods — a simplified per-square-foot calculation and an actual-expense method based on your business-use percentage of housing costs. The right choice depends on your numbers, so it's a classic "run both, ask your accountant" situation.

Business mileage

If you drive for work, mileage is often one of the larger deductions, especially for gig and contract workers. Keep a log of business trips with dates and purpose. Use a separate mileage log and review the applicable method with your tax professional.

Keeping the tracker current (the part that matters)

Choose a regular time to enter missing records, check categories and reconcile the sheet against your statements. Review formula changes and retain supporting documents so you can explain the totals later.

Avery for Google Sheets can import transactions from supported accounts and suggest categories. You review them, add missing records and reconcile totals. If you want accounts, invoices and reports together in the app, compare Pro and Business.

For optional bank imports and app features, compare Avery plans. Review categories with your accountant; Avery does not calculate a verified tax reserve or make estimated tax payments for you.

Related templates and guides

Mapping spending to Schedule C lines? Pair this tracker with the Schedule C expenses worksheet. Funding quarterly payments? Use a tax set-aside and quarterly tax guide.

• Self-Employed Expense Tracker template — the free Google Sheet this guide is built around.
• Self-employed expense tracker Q&A — quick answers to the most common setup and self-employment tax questions.
• 1099 write-offs and deductions — what to track, and how to document it.
• Schedule C expenses guide — the Part II list behind the worksheet.
• Self-employed profit and loss — where these expenses meet income.
• Sinking funds tracker — a free sheet for the tax holdback between quarterly dates.
• Freelancer Expense Tracker template — another spreadsheet starting point for freelance expense records.
• Expense Tracker template — a general-purpose spending log if you don't need the tax layer.
• Simplify bookkeeping in Google Sheets — how to run lightweight books without leaving Sheets.
• Browse all free templates — the full Avery library.

Keep the record up to date, retain supporting documents and review the totals with your accountant before using them for a return or estimate.