Freelance expense categories for a spreadsheet: a starter list that stays short
Too many categories and you stop filling the sheet in; too few and you can't see where the money goes. Nine expense categories cover most one-person businesses.
A starter list
- Software & subscriptions: apps, hosting, domains, cloud storage.
- Equipment: computer, monitor, camera, desk, anything you buy once and use for a while.
- Contractors: other people you pay to help deliver client work.
- Marketing: portfolio site, ads, printed cards, directory listings.
- Travel: trains, fuel, parking, accommodation for client work.
- Home office: the business share of internet, phone and similar.
- Professional fees: bookkeeping, legal, consulting, bank and payment-processor fees.
- Taxes & licenses: business licence and registration fees you pay.
- Other expense: the honest catch-all, reviewed every quarter.
This is a tracking list, not a statement about what you can claim. What counts as a business cost for tax purposes depends on where you live and your situation, so confirm that with your tax authority or a qualified professional.
Rules that keep the list useful
- Pick by "what was it for", not "where did I buy it". A coffee with a client is Travel or Marketing, not "Food", whichever you decide, then stay consistent.
- One category per row. If a payment covers two things (a laptop and a software licence on one receipt), split it into two rows.
- Review "Other" every quarter. If the same thing keeps landing there, give it its own category. If "Other" is more than about a tenth of your spending, your categories don't match your business.
- Part-personal items: log only the business share, and write the share in the description (for example "phone, 30% business"), so you can see how you arrived at the number.
Wire it to a dropdown
Put the list on its own tab and point a data-validation dropdown at it (Data > Data validation > List from a range). A dropdown stops "Software", "software " and "Soft." becoming three different categories, which would quietly break any summary formula such as SUMIFS. The same list then drives your monthly P&L and the income and expense tracker.
More freelancer finance guides
- Excel or Google Sheets for freelancer finances? What actually differs
- How to build a freelance income and expense tracker in a spreadsheet
- A simple 12-month cash flow forecast for freelancers
- Freelancer profit and loss (P&L) in a spreadsheet: a one-page layout
- Freelancer runway: three spreadsheet formulas for how long your cash lasts
- Freelancer tax set-aside: what goes into the number, and how to track it
- Invoice tracker spreadsheet: formulas for paid, due and overdue
- Budgeting on irregular freelance income: the baseline-pay method
- How to track freelance income by client in a spreadsheet
Already built
The Freelancer Finance Spreadsheet Kit ships with this category list wired to dropdowns, a P&L that fills itself from it, and "Other" catch-all rows so totals always match. One Excel file, $29.
Free: the Tax Set-Aside tab as a standalone Excel file
One working tab: type your quarterly income, expenses and the rate you choose, and it shows what is still to put aside. Confirm your email and the file arrives right away, plus an occasional note (at most one a week) on tracking freelance money. Unsubscribe in one click. Privacy.
General information about using spreadsheets, not financial, tax or accounting advice. The categories here are for tracking only and do not say what is deductible.