Free Business Expense Spreadsheet: What to Track and How to Set One Up When You Work Solo

If you work for yourself, your expenses are probably spread across card statements, email receipts, a few paper slips and a handful of subscriptions you half remember signing up for. Nothing is wrong yet. The trouble comes when you need the full picture, whether for a tax return, a quote, or a plain "am I making money on this?" check.

A free business expense spreadsheet fixes this if it is built simply and kept up with minimal effort. Most downloadable templates hand you a file with a dozen columns and no explanation. This guide covers what each column is for, which ones you can drop, how to set categories without overcomplicating them, and a routine light enough to survive past the first busy month. It works in Excel, Google Sheets or any spreadsheet tool.

What a solo expense sheet needs to do

A solo sheet has fewer jobs than a company's. It does not need approval workflows or reimbursement tracking, because you are the only person spending and the only person being paid back. It needs to:

1. Record each business cost so you can find it later.
2. Sort costs into categories so you can see where the money goes.
3. Link each entry to evidence, usually a receipt, invoice or statement line.
4. Total things by month and category so the numbers are usable without extra work.

If a column doesn't serve one of those jobs, leave it out.

The columns worth keeping

Date

The date you paid, not the date you got round to logging it. This lets you sort by month and match entries against a bank or card statement.

Vendor or description

Who you paid and, in a few words, what for. "Cloud storage, annual plan" beats "software". Your future self, looking at this a year later, will not remember what a vague entry meant.

Amount

One column, with one currency. If you sometimes pay in another currency, add a second column for the original amount and keep the main one in your home currency. Don't mix currencies in a single column.

Category

Pick from a short fixed list rather than typing freely. A drop-down (data validation in Excel or Google Sheets) stops "Software", "software" and "Softwares" from becoming three categories. More on choosing the list below.

Payment method

Business card, personal card, cash, bank transfer. This matters more than it looks. If you sometimes pay for business things from a personal account, this column lets you reconcile later and shows what you've spent that you haven't been paid back for by your own business.

Receipt or reference

A file name, a link to a folder, or a note like "emailed receipt, in Receipts folder". This one column prevents most end-of-year panic. An expense without evidence is harder to defend and harder to check.

Project or client (optional)

If you bill clients, tagging costs to a project helps you see which jobs are profitable and what you can pass on to a client. If you only have one line of work, skip it. If you do track projects elsewhere, such as in a project tracker, use the same project names so the two line up.

Notes (optional)

Only for things that need explaining: why a purchase was business, or that it was shared with personal use.

What to leave out

• Tax rate and tax amount columns, unless you've confirmed with an accountant or your local tax authority how you should record them. Rules differ by country and by how you are registered.
• Approval status, "submitted by", "reimbursed on". Those belong to team expense reports.
• Dozens of categories. Too many choices make you hesitate with every entry, so the sheet gets skipped.
• Running balance. That is bookkeeping for an account, not an expense log. Keep income elsewhere or in a separate tab.

An example layout

Here is how the sheet might look. The rows are invented for illustration only, and the amounts are placeholders.

| Date | Vendor / description | Amount | Category | Payment method | Receipt / reference | Project / client | |---|---|---|---|---|---|---| | (date) | Design software, monthly | (amount) | Software & subscriptions | Business card | Email receipt, saved to folder | General | | (date) | Printer paper and pens | (amount) | Office supplies | Personal card | Photo of receipt | General | | (date) | Train to client meeting | (amount) | Travel | Business card | Ticket PDF | Client A | | (date) | Domain renewal | (amount) | Software & subscriptions | Business card | Invoice in email | Own site |

The second row is paid from a personal card, which is exactly why the payment method column exists. You'll want to know later that the business owes you for that one.

Setting up categories without overthinking it

Start with a short list based on what you actually spend money on, not a list copied from a form. For many solo workers a handful covers most things:

• Software & subscriptions
• Office supplies and equipment
• Travel
• Professional services (accountant, legal, design help)
• Marketing and advertising
• Training and courses
• Other

Two principles keep this manageable.

Make categories broad, not clever. You can always split one later if it grows too large. It is much harder to merge a dozen thin categories after a year of inconsistent use.

Check your local categories before the end of the year. If your tax return or accountant uses specific headings, adjust your list to match them. Don't assume that a template's categories do. Which costs count as deductible, and how they're classed, varies by country and situation, and a spreadsheet cannot tell you that.

If you track office supplies in particular, a single "Office supplies" category is usually enough. Separate columns for pens, paper and toner add effort without adding insight. Put the detail in the description.

Add a summary so the data is actually useful

A log on its own is just a list. Add a second tab that totals by month and by category, using SUMIFS in Excel or Google Sheets, or a pivot table. Once it's in place, every new row updates the summary automatically, and you can see at a glance where the money is going.

If you also record income, keep it on its own tab with similar columns and compare totals on the summary tab. For a broader view that includes planned spending, a small business budget template is a natural next step. It answers "what do I expect to spend?" where the expense log answers "what did I spend?"

A routine that keeps the sheet alive

Most expense spreadsheets fail the same way. They start well, then get skipped for a few weeks, and recreating the missing entries becomes a chore nobody wants. A light routine in three parts helps.

On the day: capture, don't complete. When you buy something, save the receipt or invoice into a single folder straight away, by photo, forwarded email or download. You don't have to enter it in the sheet yet. The only job is making sure the evidence exists in one place.

Weekly: a short check. Pick a regular slot and enter whatever has built up in the folder. Doing it in one sitting is faster than doing it item by item.

Monthly: a review against statements. Compare your sheet with your card and bank statements. Look for:

• charges you forgot to log
• subscriptions you no longer use
• personal items that landed on a business card, or the reverse
• entries missing a receipt

This is also where recurring costs show up, which is useful when you are deciding what to cut or what to price into your work.

Excel, Google Sheets, Word or PDF?

People searching for this often ask about format, so briefly:

• Excel or Google Sheets are the sensible choices. They calculate totals, filter, sort and support drop-downs. Google Sheets is easier if you want to log from your phone or share the file with an accountant. Excel is fine if you prefer working offline.
• Word or PDF forms are fine for one-off printouts but poor for tracking. They can't total across a year or filter by category.
• A free app may suit you if you'd rather scan receipts than type. Apps often make the receipt side easier but give you less control over categories and layout, and free tiers vary, so check what is included before moving your records into one.

The structure above works in any of them. Pick the tool you will open without effort.

Where a spreadsheet stops working

A spreadsheet is a good starting point, but it has limits.

• Receipts. The sheet only points to evidence. You still need a tidy system for storing the receipts themselves, and a spreadsheet will not read them for you.
• Mileage. If you claim for business travel by car, you may need dated, detailed records of each trip. You can log those in a sheet, but it is tedious, and many people prefer a dedicated method.
• Tax rules. What counts as a business expense, what you can claim, and how long you must keep records all depend on where you live and how you operate. Check with your local tax authority or an accountant. Treat the spreadsheet as your records, not as tax advice.
• Volume. If you handle a large number of transactions, manual entry gets slow, and importing statements or using accounting software may be a better fit.

None of this means a spreadsheet is the wrong choice, only that you should know when you have outgrown it.

Getting started

If you'd rather not build from scratch, there is an expense tracker template on this site you can use as a starting point. You can equally build the layout above in a blank sheet in about the time it takes to drink a coffee. Whichever you choose, make sure it has the date, description, amount, category, payment method and receipt reference columns, and that your category list is short.

A quick checklist to finish:

1. Create the columns listed above, and drop the ones you don't need.
2. Set up a drop-down for categories, using a short list.
3. Create a folder for receipts and name it somewhere you will find it.
4. Add a summary tab totalling by month and category.
5. Put a recurring reminder in your calendar for the weekly entry and the monthly statement check.
6. Before the end of your tax year, check your category names against what your accountant or tax authority expects.

A sheet that is slightly less detailed but kept current is far more useful than a thorough one abandoned in the second week.