Self-Employed Expense Tracker For Google Sheets

Use the Self-Employed Expense Tracker as a starting point for organising business expenses in Google Sheets. Keep a consistent record, retain supporting documents and review the totals with your accountant.

Who it is for

Freelancers, consultants, sole proprietors and independent contractors who prefer to work in a spreadsheet. Business structure and tax elections affect filing requirements; the tracker does not determine which return you need.

Build a useful expense record

Review the fields and formulas in your copy before using it. Your recordkeeping routine should capture:

• The date, vendor and amount of each expense.
• The business purpose and a category reviewed with your accountant.
• A receipt or reference to the supporting document.
• Notes explaining any business-use allocation or correction.

Reconcile the records against your statements and resolve missing or duplicate entries. Categorising an expense does not establish that it is deductible.

What this tracker does not do

This spreadsheet is not a tax return, a verified tax-reserve calculator or a guarantee of compliant records. Use reviewed totals as inputs to a separate tax calculation with your tax professional. Do not rely on an illustrative percentage to determine quarterly payments.

When to add Avery

Enter records manually, or use Avery for Google Sheets for optional imports from supported bank accounts. Check how imported records map to your worksheet, review suggested categories and reconcile the totals.

For accounts, invoices and reports in the app, compare Pro and Business. Avery does not calculate a verified tax reserve or make estimated tax payments for you.

Continue your recordkeeping workflow

• Self-employed expense tracker guide — a routine for recording and reviewing business costs.
• Tracker questions and answers — setup, records and sharing.
• Schedule C expenses worksheet — organise categories for a tax review.
• Self-employed profit and loss template — bring income and expenses into a reporting period.
• 1099 write-offs guide, tax set-aside guide and quarterly tax guide — background to discuss with your tax professional.