Freelancer Expense Tracking: A Simple Spreadsheet System
A simple freelancer expense tracker in Google Sheets: tax-friendly categories, billable expenses, a receipts folder and a 15-minute month-end routine.
In short
A freelancer expense tracker spreadsheet needs one row per business expense with Date, Category, Amount, Client, Billable and Receipt columns, kept separate from personal spending. Log each expense when you pay, keep receipts in a Drive folder, and run a 15-minute month-end check. At tax time, share the sheet with your accountant instead of sending files.
A freelancer expense tracker spreadsheet only needs to do three things: separate business spending from personal, record what each cost was for, and be easy to hand to an accountant. The system below does all three in Google Sheets with seven columns, a receipts folder and a 15-minute month-end routine. You log at the till and file with a filter.
This guide is general information, not tax advice. Check deduction rules with an accountant or the IRS self-employed tax center.
Keep business and personal spending apart
The single biggest time-saver for freelancers is never mixing the two. When personal and business costs sit in one list, every tax season starts with hours of sorting.
- Use a separate spreadsheet for business. Not a tab in your personal budget, but its own file. You can share it with an accountant without exposing your grocery bill.
- Use a separate card or account if you can. It doesn't replace the spreadsheet (a statement line like "AMZN MKTP" says nothing about what you bought), but it makes missed expenses easy to spot.
- When you pay a business cost personally, log it in the business sheet anyway and mark the payment method. That's money your business owes you, and a deduction you'd otherwise lose.
Set up the spreadsheet
Create a new Google Sheet called "Business Expenses 2026" with these columns:
| Column | Type | Example | Why it matters |
|---|---|---|---|
| Date | Date | 10/15/2026 | Puts expenses in the right tax year and quarter |
| Category | Dropdown | Software | Totals by tax category |
| Amount | Currency | 29.00 | The number that ends up on your return |
| Client | Dropdown or text | Northwind | Who to bill, and which projects cost the most |
| Billable | Yes/No checkbox | Yes | What to add to the next invoice |
| Receipt | Checkbox or link | ✓ | Shows at a glance what's missing |
| Notes | Text | Annual Figma plan | The business purpose, in your own words |
The Notes column is underrated. "Lunch, 46.80" is a weak record. "Lunch with Northwind to scope the Q1 site, 46.80" is a strong one, and you'll never remember it in April.
Choose categories that match your tax return
Pick categories that map neatly to the lines your accountant fills in. For US sole proprietors that's Schedule C (form and instructions on IRS.gov). A practical starting list:
- Advertising and marketing: ads, website hosting, business cards
- Software and subscriptions: design tools, accounting software, cloud storage
- Equipment: laptop, monitor, camera (your accountant may depreciate large items)
- Office and supplies: paper, printer ink, small items
- Travel: flights, hotels, train tickets for client work
- Meals: business meals (often only partly deductible, so keep them separate)
- Car and mileage: fuel, parking, tolls, or a mileage log
- Contract labor: subcontractors you pay
- Professional fees: accountant, lawyer, professional memberships
- Phone and internet: the business share of your bills
- Other
If you're outside the US, ask your accountant for their preferred list. The structure stays the same.
Make Category a dropdown (Insert → Dropdown) so the names never drift. Our guide to tracking expenses in Google Sheets walks through dropdowns and validation step by step.
Track billable expenses so you get paid back
Billable expenses are costs a client has agreed to reimburse: travel to their site, stock photos for their project, a domain you register for them. They're easy to forget when you invoice.
Add a small summary tab that lists billable expenses not yet invoiced. If Billable is column E and you add an Invoiced checkbox in column H:
=FILTER(Expenses!A:G, Expenses!E:E=TRUE, Expenses!H:H=FALSE)
Before you send an invoice, check this tab, add those costs to the invoice, then tick Invoiced. To total what a client owes you, with the client name in A1:
=SUMIFS(Expenses!C:C, Expenses!D:D, A1, Expenses!E:E, TRUE, Expenses!H:H, FALSE)
Keep receipts in a Drive folder
Your spreadsheet is the record; the receipt is the proof. Keep both in the same Google Drive so they're easy to find together.
- Create a folder next to your spreadsheet: Receipts 2026, with a subfolder per month.
- Photograph paper receipts into the right month's folder, and save emailed receipts as PDFs there too.
- Name files
2026-10-15 Figma 29.00.pdf. Sorting by name then sorts by date. - Tick the Receipt column (or paste the file's link) when it's filed.
Voice Sheet doesn't scan receipts, so photos and PDFs go into Drive separately. What it does is make the spreadsheet entry fast: say "Figma 29 software, billable no" and the row is filled in from your columns, so the record exists even if the receipt takes another day.
Log expenses when they happen
Most freelancer bookkeeping problems start as a pile of receipts "to deal with later". The fix is to log each expense in the moment, which only works if logging is quick.
- On a laptop, type straight into the sheet.
- On your phone, use whatever gets the row in fastest: a Google Form, the Sheets app, or an app built for it. With Voice Sheet, "client lunch with Northwind 46.80, meals, billable" fills Date, Category, Amount, Client and Billable in one sentence.
- For recurring costs like software subscriptions, set a monthly reminder that opens a pre-filled entry, so they're never missed. Recurring reminders work this way in Voice Sheet.
The 15-minute month-end routine
On the first working day of each month, go through this checklist:
- Compare against your bank and card statements. Anything business-related that's not in the sheet? Add it.
- Find missing receipts. Filter the Receipt column for unticked rows and track them down while they're recent.
- Check the Notes. Any row without a business purpose? Fill it in now.
- Invoice billable expenses. Use the "not yet invoiced" tab from above.
- Glance at category totals. A quick SUMIFS by category for the month shows where the money goes, and whether any subscription has crept up.
That's 15 minutes a month. Compare that with a weekend in April reconstructing a year from bank statements.
Share the sheet with your accountant
This is where a Google Sheet beats most expense apps. Instead of exporting a CSV each quarter:
- Click Share and add your accountant's email.
- Give them Viewer access (or Commenter if you want them to leave questions on rows).
- Share the receipts folder the same way.
They see live, organised records whenever they need them, in a tool they already use. If they prefer a file, File → Download → Microsoft Excel gives them one in seconds.
At year end, make a copy of the spreadsheet for next year, clear the rows, and keep the old file and its receipts folder. The IRS generally asks you to keep records for three years, and longer in some situations.
Get started
You can set this system up in an afternoon: one spreadsheet, eleven categories, a receipts folder and a monthly reminder. Start with the free Google Sheets expense tracker template if you'd rather not build from scratch, and add the Client, Billable and Receipt columns.
If you'd rather not link your business account to yet another app, everything here works without it. See how to track expenses without linking your bank. For a freelancer's week with voice logging, have a look at Voice Sheet for freelancers.
Frequently asked questions
How should freelancers track business expenses?
Record each business expense as soon as you pay, in a spreadsheet or app kept separate from personal spending. Note the date, category, amount, client and whether it's billable, and keep the receipt. A short monthly review catches missing receipts while you still remember what each purchase was for.
What columns does a freelancer expense spreadsheet need?
Date, Category, Amount, Client, Billable (yes/no), Receipt (a link or yes/no) and Notes. Add Payment method if you sometimes pay business costs personally. Keep categories close to the ones your tax return uses, so your accountant can total them without re-sorting every row.
How long should freelancers keep expense records?
In the US, the IRS generally asks you to keep records that support your return for three years, and longer in some cases, such as six years if you under-reported income by more than 25%. Rules differ elsewhere, so check with your tax authority or accountant.
Should freelancers use a separate bank account for business?
It's strongly recommended. A separate account or card makes it obvious which spending is business, simplifies your records and makes your accountant's job faster. You still need a spreadsheet or app to record what each purchase was for, because bank statements rarely say.
