How to Track Business Expenses in Excel (for Freelancers)

If you freelance or run a small business, tracking expenses isn’t optional — it’s the difference between a clean tax return and a painful one, and between guessing your profit and knowing it. Excel is the perfect tool for it. This guide builds a real expense system: a log that’s ready for tax time, totals by category and by client, and a running profit figure. Prefer it pre-built? Our Freelance Business Hub bundles expenses, invoices, clients, and tax math into one workbook.

Why a spreadsheet beats a shoebox of receipts

The goal of expense tracking is to capture every deductible cost as it happens, sorted in a way your tax form understands. A spreadsheet does that and one more thing a receipt pile never will: it tells you, at any moment, how much you’ve made after costs. That’s the number that actually runs your business.

Step 1 — Build the expense log

On an Expenses tab, create columns for Date, Vendor, Category, Client (optional), Amount, and Notes. Convert it to a table with Ctrl+T.

Your Category column should map to tax-deductible buckets — Software, Equipment, Travel, Meals, Home Office, Contractors, Marketing — and it should be a drop-down list so the categories stay clean. Consistent categories are what make the totals in the next step trustworthy; one stray “Sofware” typo and a deduction goes missing.

Step 2 — Total expenses by category with SUMIF

This is the formula that turns a log into a tax summary. On a Summary tab, list your categories and use SUMIF:

=SUMIF(Expenses[Category], "Software", Expenses[Amount])

It adds every expense in that category, and updates live as you log new ones. Come tax time, you hand your accountant (or type into your tax software) a clean total per deductible category instead of adding receipts by hand. A SUM of those category totals gives you total business expenses for the year.

Step 3 — Track expenses by client

If you bill multiple clients, knowing which client costs you the most is gold. Add a second SUMIF keyed on the Client column:

=SUMIF(Expenses[Client], "Acme Co", Expenses[Amount])

Pair that with the income you’ve invoiced each client and you can see true per-client profitability — sometimes your “biggest” client is actually your least profitable once costs are in. For a deeper slice-and-dice, a pivot table can break expenses down by client and category at the same time.

Step 4 — Calculate profit and a tax set-aside

Profit is simple subtraction: total income minus total expenses.

Profit = Total Invoiced − Total Expenses

The number freelancers forget is taxes. Because no employer withholds for you, set aside a percentage of profit as you go. Multiply your profit by your estimated tax rate:

Tax to set aside = Profit × 0.25

Adjust the 25% to your bracket. Seeing that figure update every time you log income or an expense is what keeps a surprise tax bill from wrecking your year.

Step 5 — Add a dashboard

Top the whole thing off with a few headline numbers on a dashboard: income to date, expenses to date, profit, and tax set-aside — plus a pie chart of expenses by category so you can see where the money goes. Use conditional formatting to flag any month where expenses outpace income.

Skip the build — get the Freelance Business Hub

Building this yourself teaches you exactly how the pieces fit, but maintaining it across invoices, expenses, and clients is a lot of formula-wrangling. Our Freelance Business Hub ($19) does it all in one tested workbook: invoices, an expense log with deductible categories, per-client income and cost, profit, and an automatic tax set-aside — on a single live dashboard. Want it with our budget, loan, project, and savings templates too? The 5-template bundle saves 40%.

Get the Freelance Business Hub → $19

FAQ

How should I categorize business expenses in Excel?

Use categories that match deductible tax buckets — Software, Equipment, Travel, Meals, Home Office, Marketing, Contractors — and lock them in with a Data Validation drop-down. Clean categories make your SUMIF totals (and your tax return) accurate.

How do I total expenses by category for taxes?

Use =SUMIF(category_range, "Travel", amount_range) for each category. It sums every matching expense and updates as you add rows, giving you a per-category total to drop straight into your tax form. See the SUMIF guide.

How much should a freelancer set aside for taxes in the spreadsheet?

A common rule of thumb is 25–30% of profit, but it depends on your bracket and country. Multiply profit by your rate (=Profit*0.25) so the set-aside updates automatically. Treat it as a guide, not tax advice.

Can one spreadsheet handle invoices and expenses together?

Yes — that’s exactly what our Freelance Business Hub does, linking invoices, expenses, and clients on one dashboard. You can also build separate tabs in a single workbook and tie them together with SUMIF.