Last updated September 28, 2026. This article is general information, not tax advice. For advice about your situation, talk with a tax professional.
Quick answer
A self-employed expense tracker in Excel is a spreadsheet where you log every business expense with its date, vendor, amount, payment method, and category. The categories should match the expense lines on IRS Schedule C, so you can copy your totals straight onto your tax return. A good tracker also totals each category automatically and shows your profit month by month.
Key takeaways
- Log every expense with a date, a vendor, an amount, a payment method, a category, and a note about the business purpose.
- Use categories that match the Schedule C expense lines, such as Advertising, Office expense, and Supplies.
- Use a dropdown list for categories so you never type the same category two different ways.
- Use SUMIFS formulas to total each category by month.
- Keep the receipt or statement that proves each expense. The IRS lists receipts, invoices, canceled checks, and credit card statements as supporting documents.
Why self-employed people need an expense tracker at all
When you work for yourself, nobody else keeps your records for you. The IRS puts it plainly in Publication 583, its guide to starting a business and keeping records. It lists the reasons you keep records, and two of them are to "Keep track of deductible expenses" and to "Support items reported on tax returns."
In practical terms, every business expense you track lowers the profit you pay tax on. Every expense you forget is money you paid for the business that never shows up on your return. An expense tracker is the simplest way to catch those costs as they happen instead of hunting for them in April.
A spreadsheet works well for this when your business is small. You don't need an app with a monthly fee to log a few dozen expenses a month. You need a clear layout, consistent categories, and a habit.
What columns should a self-employed expense tracker have?
Set up one tab for your expense log. Put one expense on each row, and use these columns across the top.
| Column | What goes in it | Example |
|---|---|---|
| Date | The day you paid | 03/14/2026 |
| Vendor | Who you paid | Office Depot |
| Description | What you bought | Printer ink and shipping envelopes |
| Amount | What you paid | 64.18 |
| Payment method | How you paid | Business debit card |
| Category | The Schedule C category | Office expense |
| Business purpose | Why the business needed it | Print and mail client invoices |
| Receipt saved? | Yes or No | Yes |
| Month | A formula that pulls the month from the date | 3 |
The Month column makes your monthly totals easy. In the first row of that column, enter this formula, where A2 is the date cell:
=MONTH(A2)
Then copy it down the column.
The Business purpose column matters more than most people think. For travel and meals, IRS Publication 463 says "you must still keep records to prove the time, place, and business purpose of your travel." Writing the purpose on the day you spend the money is much easier than trying to remember it a year later.
Which expense categories should you use?
Use the categories from Part II of Schedule C, the form sole proprietors use to report business profit or loss. The IRS instructions describe the form this way: "Use Schedule C (Form 1040) to report income or (loss) from a business you operated or a profession you practiced as a sole proprietor."
These are the expense lines as printed on the 2025 Schedule C:
- Line 8: Advertising
- Line 9: Car and truck expenses
- Line 10: Commissions and fees
- Line 11: Contract labor
- Line 12: Depletion
- Line 13: Depreciation and section 179 expense deduction
- Line 14: Employee benefit programs
- Line 15: Insurance (other than health)
- Line 16: Interest, split into mortgage and other
- Line 17: Legal and professional services
- Line 18: Office expense
- Line 19: Pension and profit-sharing plans
- Line 20: Rent or lease, split into vehicles and equipment, and other business property
- Line 21: Repairs and maintenance
- Line 22: Supplies
- Line 23: Taxes and licenses
- Line 24: Travel and meals, split into travel and deductible meals
- Line 25: Utilities
- Line 26: Wages
- Line 27b: Other expenses, which you list in Part V
- Line 30: Expenses for business use of your home
Most solo business owners use only eight to twelve of these. A freelance designer might use Advertising, Office expense, Supplies, Legal and professional services, Utilities, and Other expenses. A contractor might add Car and truck expenses, Contract labor, and Insurance. Keep the ones you use and hide the rest so your dropdown list stays short.
For a plain-English explanation of every line, read our guide to Schedule C expense categories.
How do you add a category dropdown in Excel?
A dropdown list keeps your categories consistent. If you type "Office" one day and "office supplies" the next, your totals will split into two rows. A dropdown stops that.
- Create a second tab and name it Categories.
- In column A of that tab, type one category per row.
- Go back to your expense log and select the whole Category column.
- On the Data tab, click Data Validation.
- In the Allow box, choose List.
- In the Source box, select the list of categories on your Categories tab.
- Click OK.
Now every cell in the Category column shows a small arrow. Click it and pick the category.
How do you total expenses by category and month?
Create a third tab called Summary. List your categories down column A. Put the months 1 through 12 across row 1, starting in column B.
In cell B2, enter this formula. It adds up every amount in the expense log where the category matches the row and the month matches the column.
=SUMIFS(Expenses!$D:$D, Expenses!$F:$F, $A2, Expenses!$I:$I, B$1)
In that formula, column D is Amount, column F is Category, and column I is Month on a tab named Expenses. Adjust the letters if your columns are in a different order. Copy the formula across and down to fill the table.
Add a Total column at the end of each row with a SUM formula, and a Total row at the bottom. Your yearly total for each category is the number you bring to your tax preparer or enter on Schedule C.
Should you track income in the same spreadsheet?
Yes. An expense tracker tells you what you spent. You also need to see what you earned, so you can see your profit.
Add an Income tab with these columns: Date, Client or source, Description, Amount, Payment method, and Month. Then add a Profit row to your Summary tab that subtracts total expenses from total income for each month.
The IRS lists the documents that support your income, which it calls gross receipts. The list includes "Cash register tapes, Deposit information (cash and credit sales), Receipt books, Invoices, Forms 1099-MISC." If you get paid through platforms, keep their payout reports too.
If you get 1099 forms, compare them with your Income tab at the end of the year. Our 1099 freelance tax organization guide walks you through that check.
What records should you keep with the tracker?
The spreadsheet is your summary. The proof is your supporting documents. The IRS describes supporting documents this way: "Supporting documents include sales slips, paid bills, invoices, receipts, deposit slips, and canceled checks."
For expenses, the IRS lists these documents:
- Canceled checks or other documents reflecting proof of payment or electronic funds transferred
- Cash register tape receipts
- Account statements
- Credit card receipts and statements
- Invoices
You can keep these digitally. IRS Publication 583 says, "All requirements that apply to hard copy books and records also apply to electronic storage systems that maintain tax books and records." A simple system is a folder for each month on your computer or in cloud storage, with each file named by date and vendor.
For more detail, read what receipts you need to keep for taxes.
How often should you update your expense tracker?
Pick a rhythm you'll keep. Here are two that work:
- As it happens. Log each expense the day you pay it. It takes about two minutes and your tracker is always current.
- Once a week. Block fifteen minutes on the same day each week. Open your bank and card statements and log everything from the past seven days.
Either way, close out each month. Compare your tracker with your bank and card statements, find anything you missed, and check that every row has a category. Our monthly financial close-out workflow gives you a step-by-step checklist.
If you're already months behind, don't try to start from January. Read how to catch up on overdue bookkeeping first.
Common mistakes with self-employed expense sheets
- Mixing personal and business spending. When personal purchases land in your business log, your totals are wrong. Keep a separate business account. Read our guide on how to separate business and personal expenses.
- Using "Miscellaneous" for everything. Miscellaneous isn't a Schedule C line. Put the expense in the category it belongs in, or list it under Other expenses with a clear description.
- Skipping the business purpose. For meals and travel especially, the purpose is part of the record.
- Counting transfers as expenses. Moving money from your business account to your personal account isn't a business expense. Label it as an owner's draw so it doesn't lower your profit on paper.
- Forgetting small recurring charges. Software subscriptions, phone plans, and web hosting add up. Check your statements for anything that charges every month.
- Deducting the wrong taxes. The Schedule C instructions say not to deduct "Federal income taxes, including your self-employment tax" on the Taxes and licenses line. Keep estimated tax payments out of your expense categories.
Free template or a ready-made kit?
You can build everything in this guide yourself in an afternoon. If you'd rather start with it already built, the Bookkeeping Rescue Kit is an Excel template pack with five connected tabs: a Transaction Tracker with category dropdowns, a Monthly Dashboard, a Category Reference that explains each category and its Schedule C line, a Close-Out Checklist, and Step-by-Step Instructions.
It's a one-time purchase of $9.99 with a 30-day satisfaction guarantee.
The Bookkeeping Rescue Kit includes a Transaction Tracker with category dropdowns, a Monthly Dashboard, a Category Reference, a Close-Out Checklist, and Step-by-Step Instructions. One-time purchase, yours forever.
Get the Kit →Frequently Asked Questions
The best way is the one you'll keep up with. For most solo business owners, that means a spreadsheet or app where you log every expense with its date, vendor, amount, category, and business purpose, plus a separate business bank account so business spending is easy to find.
Yes. Excel works well for small businesses. Set up categories that match the Schedule C expense lines, use a dropdown list to keep them consistent, and total each category with SUMIFS formulas. Keep your receipts and statements as proof.
Use the expense lines from Part II of Schedule C, such as Advertising, Car and truck expenses, Contract labor, Insurance, Legal and professional services, Office expense, Supplies, Travel, Deductible meals, and Utilities. Keep only the categories your business uses.
Yes. The spreadsheet summarizes your expenses, but the IRS lists receipts, invoices, canceled checks, account statements, and credit card statements as the documents that support them. You can keep them digitally.
Update it as expenses happen or once a week, and close out each month by comparing your tracker with your bank and card statements.
They overlap. An expense tracker logs your spending. A tax tracker usually adds your income, your profit, and an estimate of what you may owe. If you track both income and expenses in the same workbook, you have most of what a tax tracker does.