Practical guide 2026
Free Business Expense Spreadsheet for Excel and Google Sheets
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.

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.
Download Your Free Business Expense Spreadsheet
Free Excel workbook
A useful expense tracker, ready to use
Record purchases, keep receipt references, and see your spending organized by month and category. The workbook includes simple instructions and customizable dropdowns.
- Four sheets: instructions, expense log, monthly summary, and categories
- Automatic monthly and category totals for a year you choose
- Room for 1,000 transactions with category and payment dropdowns
- Blank and ready for your own records; refunds can be entered as negative amounts
Free .xlsx file · No email required · Excel and Google Sheets
Prefer an editable workbook inside your account? ZuffSuite Expense Tracker template

The workbook has four sheets: Start Here explains the basics, Expense Log is where you record purchases, Monthly Summary totals the entries, and Categories holds the editable dropdown lists.
Start using it in three steps
- Download the workbook and open it in Excel, or import the .xlsx file into Google Sheets.
- Add each purchase to the Expense Log with its date, description, amount, category, and receipt reference.
- Choose the reporting year on Monthly Summary to review monthly and category totals.
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:
- Record each business cost so you can find it later.
- Sort costs into categories so you can see where the money goes.
- Link each entry to evidence, usually a receipt, invoice or statement line.
- 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 |
|---|---|---|---|---|---|---|
| 2026-09-03 | Design software, monthly | (amount) | Software & subscriptions | Business card | Email receipt, saved to folder | General |
| 2026-09-04 | Printer paper and pens | (amount) | Office supplies | Personal card | Photo of receipt | General |
| 2026-09-05 | Train to client meeting | (amount) | Travel | Business card | Ticket PDF | Client A |
| 2026-09-06 | Domain renewal | (amount) | Software & subscriptions | Business card | Invoice in email | Own site |
2026-09-03
- Vendor / description
- Design software, monthly
- Amount
- (amount)
- Category
- Software & subscriptions
- Payment method
- Business card
- Receipt / reference
- Email receipt, saved to folder
- Project / client
- General
2026-09-04
- Vendor / description
- Printer paper and pens
- Amount
- (amount)
- Category
- Office supplies
- Payment method
- Personal card
- Receipt / reference
- Photo of receipt
- Project / client
- General
2026-09-05
- Vendor / description
- Train to client meeting
- Amount
- (amount)
- Category
- Travel
- Payment method
- Business card
- Receipt / reference
- Ticket PDF
- Project / client
- Client A
2026-09-06
- Vendor / description
- Domain renewal
- Amount
- (amount)
- Category
- Software & subscriptions
- Payment method
- Business card
- Receipt / reference
- Invoice in email
- Project / client
- 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.
The free workbook above already includes this summary, so you can start with your entries instead of building formulas from scratch. Jump back to the free spreadsheet download.
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
You can download the free Excel workbook near the top of this guide and begin logging purchases right away. If you prefer to start an editable workbook inside your ZuffSuite account, use the ZuffSuite Expense Tracker template. The downloadable file does not require an account.
A quick checklist to finish:
- Create the columns listed above, and drop the ones you don't need.
- Set up a drop-down for categories, using a short list.
- Create a folder for receipts and name it somewhere you will find it.
- Add a summary tab totalling by month and category.
- Put a recurring reminder in your calendar for the weekly entry and the monthly statement check.
- 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.
When you bill a client, keep the invoice with its payment record. Our freelance invoicing guide walks through the workflow, a sample, and polite follow-ups.
Frequently asked questions
Is this business expense spreadsheet really free?
Yes. Download the .xlsx file directly from this page. No account, email address, or payment is required.
Can I use it in Google Sheets?
Yes. In Google Sheets, choose File → Import → Upload and select the .xlsx file. Review the formulas and dropdowns after import, especially if you edit the workbook structure.
Does the spreadsheet calculate expenses automatically?
Yes. The Monthly Summary uses formulas to total entries by reporting year, month, and category. Enter a refund or correction as a negative amount so it reduces the net total.
Can I customize the categories?
Yes. Add or edit categories on the Categories sheet. If you rename a category, update older Expense Log entries that use the previous name so they continue to appear in the matching summary.
Can I use it for freelance work or a small business?
Yes. The workbook is designed for individuals, freelancers, and small business owners who want a straightforward record of spending. You can add project or client names when they help you review costs.
Does this replace bookkeeping or accounting software?
No. It is an expense log and summary workbook. It does not connect to banks, reconcile accounts, file taxes, or provide accounting advice.
Ready to begin? Jump back to the free business expense spreadsheet download.
Keep exploring
More guides for your work
Template walkthrough Oct 3, 2026
Freelance Project Tracker Template: Clients, Tasks, and Deadlines
Copy the blank tracker, learn each field, and build a small overview you can maintain yourself.
Read the guide
Field guide Oct 3, 2026
How to Manage Multiple Freelance Client Projects Without Losing Track
A worked three-client week, a small project overview, and a repeatable review to keep commitments clear.
Read the guide
Workflow guide Sep 27, 2026
Project Management Workflow for Small Business: From Brief to Handoff
Projects go wrong at the handoffs between stages, not inside them. A seven-stage workflow from brief to close, the handoff at each step, and a worked example.
Read the guideA workspace for what comes next
Give your next project one clear home.
Keep notes, documents, tasks, and presentation work together in a personal workspace. Share something when you choose.