Freelancer Expense Tracker

Freelancer Expense Tracker — Every Business Dollar, Categorized and Tax-Ready

Freelance money leaks out in small pieces: a subscription here, a train ticket there, a course in October. This tracker puts every business expense in one log, sorts it into categories, and marks what is tax-deductible — so at tax time you hand your accountant one clean number instead of a shoebox of receipts.

Log each expense once — date, category, what it was, how much — and the sheet works out your total spent, your tax-deductible total, and your biggest spending category. A categories view shows where the money actually goes, and a monthly view shows your running total so you can see spending creep up before it becomes a problem.

What you get:

• Expenses — every business expense with date, category, description, amount, tax-deductible? (Yes/No), deductible amount and month
• Categories — per-category totals, entry count, deductible total, share of spending
• Summary — total spent, deductible total, non-deductible total, average expense, biggest expense, top category, average per month
• Monthly — per-month totals, deductible totals, entry count and running total
• README sheet — 5-minute setup guide, no macros, no add-ins

How it works: Yellow cells are the only ones you type in. Everything else is a formula. Mark each expense Yes or No for tax-deductible and the deductible total updates itself. Works in Microsoft Excel 2016 and newer, and in Google Sheets (File > Import > Upload). No sign-in, no subscription, no macros.

Who it is for: Freelancers and self-employed workers who pay for tools, travel, courses and software out of their own pocket and want one clean deductible total at tax time — instead of digging through bank statements in April.

This tracker is a record-keeping tool, not tax advice. Deductibility rules differ by country — check your local rules or ask your accountant.

You get: 1 Excel file (.xlsx), 5 sheets, instant download. For personal use only.