Plainfield Media
Google Sheets + Excel

2027 Freelancer Tax & Profit Tracker

Know what you earned, what you kept and what to set aside for taxes, without building a spreadsheet from scratch.

$19

Instant download through Gumroad. Includes a free update once the IRS publishes its 2027 figures.

2027 Freelancer Tax and Profit Tracker cover

What's inside

Income log

Invoices, clients, dates sent and paid, amounts received and payment method.

Expenses

Pick a category from a list. Each category is mapped to a Schedule C line, with business-use percentages where they apply.

Mileage

Log trips with date, purpose and miles. The deduction uses the rate you set in Settings.

Quarterly estimates

Self-employment tax and income tax estimates for each 2027 payment period, with the due dates built in.

1099 reconciliation

Compare what each client reports on a 1099 with what you logged, and spot the gaps.

Schedule C summary

Totals by Schedule C line, ready to hand to your tax preparer or use when you file.

The dashboard

A one-page view of profit, tax set-aside, the next payment due and monthly trends. This is a real screenshot with the included sample data.

Dashboard tab of the tracker showing sample income, expenses, profit and estimated tax

Good to know

  • One .xlsx file that opens in Excel or imports into Google Sheets, plus a 4-page PDF setup guide.
  • Sample data is included so you can see how it works. Clear it when you're ready.
  • The 2027 Social Security wage base ($192,300) is official. Brackets, the standard deduction and the mileage rate use 2026 IRS figures until the 2027 numbers are out. They live on one Settings tab, so you can update them in a minute.
  • Built for U.S. sole proprietors and single-member LLCs that file Schedule C. Federal only. It doesn't figure state tax.
  • It's a planning tool, not tax advice and not tax-filing software.

Get the tracker for $19

Learn the math behind it