Freelance work blurs business and personal spending: a laptop, a software subscription, a coffee with a client, a train to a shoot. Sort a whole year of it at tax time and you end up digging through receipts again. Choosing categories and filling them in every month takes most of the pain out of year end.
1. Keep it to about ten categories
Too many categories and every entry becomes a decision; too few and you'll have to split them later. Start with around ten.
| Category | Examples | What to note |
|---|---|---|
| Equipment | Laptop, monitor, camera | Purchase date, whether it lasts years |
| Software and subscriptions | Design tools, cloud storage | Monthly or annual |
| Phone and internet | Mobile plan, broadband | Share used for work |
| Travel | Trains, taxis, parking | Which job it was for |
| Client meals and gifts | Meeting lunches | Who and what for |
| Training and books | Courses, reference books | How it relates to your work |
| Workspace | Coworking desk | Period covered |
| Supplies | Stationery, printer ink | |
| Fees | Platform fees, payment fees | Which income it relates to |
| Other | Anything that doesn't fit | One-line description |
When Other grows past about 10% of your spending, pull out whatever keeps appearing into its own category.
2. Spreadsheet layout
Next to the Date, Store and Total columns from the receipt tool, add:
- Category: one of the names above, picked from a Data Validation list to avoid typos
- Business purpose: one line on who and why, such as "Branding kickoff with Acme, coffee"
- Paid with: business card, personal card, cash
- Receipt type: itemized receipt, card slip, invoice
- Business share: only for mixed-use costs (for example 50%)
Rather than a sheet per month, keep adding to one sheet and filter by date. Totals are much simpler that way.
3. Costs that are partly personal
For costs you use for both work and life, like your phone, a home workspace or your car, record the share used for work rather than claiming the whole amount. Leave the receipt total as it is, add a Business share column, and add a "Business amount" column with something like =D2*G2. The original amount and the reasoning stay side by side.
How to set that share, and whether a cost is deductible at all, depends on your country and business structure. Check your tax authority's guidance or ask an accountant.
4. Flag things that last for years
Equipment such as a laptop or camera is often not expensed all at once in the year you buy it. Mark those receipts "long-lived item" in a Notes column and keep the original purchase receipt or photo somewhere safe. How it's treated is worth confirming with an accountant.
5. A package that's ready for tax time
Different countries have different forms. In the US, for example, sole proprietors report business expenses on Schedule C, which has its own expense lines. Whatever the form, a tidy file makes the conversation with your accountant or your bookkeeping software much faster.
- One sheet with the year's expenses, with category, purpose and receipt type filled in
- A summary sheet with totals by category
- A folder of receipt photos matched to rows by file name or a Photo column
- Notes on the business share of mixed-use costs and how you arrived at it
Summary
Freelance expense tracking comes down to about ten categories, one line on who and why, and a separate share for mixed-use costs. Fill those in each month as you turn receipt photos into rows, and tax time no longer means a year-long receipt hunt.