Freelancer Income & Tax Tracker — Excel Template

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📋 WHAT'S INSIDE

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Stop guessing what you owe in taxes. This Excel template gives 

freelancers and self-employed professionals a complete financial 

system — track every dollar earned, every deductible expense, 

and know exactly how much to set aside for quarterly taxes.

No accounting degree required. Just fill in the yellow cells 

and let the formulas do the rest.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

💰 SHEET 1: INCOME LOG

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

→ 50-row log for all client payments received

→ Tracks: date, client name, project, invoice #, 

 payment method, gross amount, platform fee, net received

→ Quarter (Q1–Q4) auto-detected from payment date

→ Totals by quarter and annually — updated automatically

→ Statistics: unique clients, largest payment, average invoice size

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🧾 SHEET 2: EXPENSE TRACKER

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

→ 50-row log for all business expenses

→ 9 categories: Software & Subscriptions, Home Office, 

 Equipment, Marketing, Travel & Meals, Professional 

 Development, Professional Services, Office Supplies, Other

→ Deductible % column — enter 50% for meals, 100% for software

→ Deductible amount calculated automatically

→ Summary by category and by quarter

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📊 SHEET 3: TAX ESTIMATOR

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

→ Enter your Federal tax bracket and State tax rate

→ Automatically calculates:

  • SE Tax = Net Profit × 92.35% × 15.3%

  • SE Tax Deduction (50% of SE Tax)

  • Federal income tax owed

  • State income tax owed

  • Total quarterly tax due

→ Payment tracker: log what you've paid each quarter

→ Overpaid / Underpaid balance per quarter

→ Quarterly deadlines: Apr 15 / Jun 16 / Sep 15 / Jan 15

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📈 SHEET 4: ANNUAL SUMMARY

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

→ Full-year P&L: gross income → expenses → taxes → net take-home

→ Year-over-year comparison (enter prior year manually)

→ Income breakdown by quarter

→ Expense breakdown by category with % of total

→ Freelance health indicators:

  • Effective hourly rate

  • 3-month emergency fund target

  • Recommended retirement contribution (15%)

  • Income vs $60k salary benchmark

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

✅ WHO THIS IS FOR

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

→ Freelancers, consultants, and independent contractors

→ Anyone who receives 1099 income in the US

→ Self-employed professionals tired of surprise tax bills

→ Designers, writers, developers, marketers, photographers, 

 coaches — anyone billing clients

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📦 WHAT YOU GET

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

→ 1 Excel file (.xlsx) — works in Excel and Google Sheets

→ 5 sheets: Instructions, Income Log, Expense Tracker, 

 Tax Estimator, Annual Summary

→ 361 live formulas, 0 errors

→ Color-coded: yellow = input, white = formula, green = total

→ Instant digital download

→ One-time purchase — use every year

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

⚠️ DISCLAIMER

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

This template is for estimation and planning purposes. 

Consult a CPA or tax professional for official tax advice.