Schedule C Tax Expense Tracker
A six-tab Excel expense tracker organized by IRS Schedule C category with a drop-down picker, monthly and year-end summaries that build themselves, and a mileage log with the IRS standard rate baked in. The natural Sheets companion to the free Tax Deduction Cheat Sheet PDF.
A six-tab Excel workbook for U.S. sole-proprietor and single-member LLC sellers who want tax season to be a Sunday afternoon, not an April nightmare. Tab one is a Read Me with the math written out plainly. Tab two is the Expense Log — every business expense, line by line, with a Schedule C drop-down picker on every row and a per-row business-use % so meals, vehicle, and home expenses calculate the right deductible amount. Tab three is a Monthly Summary that pivots Jan–Dec totals per category with a YTD column for quarterly estimated-tax check-ins. Tab four is the Schedule C Summary — the year-end form-line view your CPA will recognize on sight, mapped to Lines 8–27a (Part II) and the Part III COGS sub-totals. Tab five is a Mileage Log with the IRS standard rate built in (set it once each January). Tab six is a Categories Reference with what belongs on each line and what doesn't. The natural Sheets companion to the shipped Tax Deduction Cheat Sheet PDF — together they form the complete tax bundle.
- An Expense Log tab with a drop-down picker covering all 26 Schedule C categories — pick once per row instead of looking up the right line each April
- Per-row business-use % so meals (50%), vehicle, and home expenses calculate the right deductible amount automatically
- A Monthly Summary tab with Jan–Dec totals by category and a YTD column — your quarterly estimated-tax data, ready when you are
- A Schedule C Summary tab mapped to IRS Lines 8–27a (Part II expenses) plus Part III COGS sub-totals — copy these straight to your return or hand them to your CPA
- A Mileage Log with the IRS standard rate built in (currently $0.70/mile for 2025) and round-trip handling so each drive becomes a deduction in two columns
- A Categories Reference tab with what belongs on each line and what doesn't — the drop-down picker's back-of-the-card cheat sheet
- 20 sample expense rows across candles, soap, baked goods, and Etsy fees you can replace with your own ledger in minutes
Educational tool only — not tax, accounting, or legal advice. Tax rules change and circumstances vary; review with a CPA or enrolled agent before filing. Schedule C line numbers reflect the 2024 form layout and may shift in subsequent years.
How Schedule C is organized — Part II vs. Part III
Schedule C splits the expense side of your business into two sections that are not interchangeable. Part II is operating expenses — Lines 8 through 27a — covering advertising, supplies, fees, travel, insurance, and the rest of running the business. Part III is Cost of Goods Sold — the raw materials, production labor, and freight-in that becomes the product itself. Wax for a candle goes in Part III. Tape that wraps the shipping box goes on Line 22 Supplies in Part II. The mistake most makers make is dumping everything into Supplies; the IRS expects raw materials to flow through COGS so beginning + purchases − ending inventory ties out.
This tracker uses one drop-down list that mixes Part II and Part III categories, so you don't have to think about which section a line belongs to while you're logging. The Schedule C Summary tab puts each category back on the right line at year-end.
Why the per-row business-use % matters
Three Schedule C lines almost never apply at 100%: meals (limited to 50% by IRS rule), vehicle (allocated by your business-use percentage), and home utilities (allocated by the percentage of your home used regularly and exclusively for business). A naive expense tracker treats every row as 100% deductible — which means at year-end you have to go back through and discount the meal rows, prorate the gas rows, and pull out the home utilities. This tracker prompts you for the percentage on the row itself, so the deductible amount is correct the moment you log the expense.
For most rows you'll leave the column at 100. For business meals, drop it to 50. For vehicle (if using actual expenses instead of standard mileage), use your business-use %. For home utilities, use your home-office percentage from Form 8829.
The quarterly estimated-tax workflow
Self-employed sellers owe estimated taxes four times a year — Apr 15 (covers Jan–Mar), Jun 15 (Apr–May), Sep 15 (Jun–Aug), and Jan 15 of the following year (Sep–Dec). On each due date, open the Monthly Summary tab and read the YTD column. That total minus your year-to-date estimated payments is the net deductible figure that feeds Line 12 of the 1040-ES worksheet.
Logging weekly during the quarter is what makes this workflow easy. Logging at the deadline is what makes it miserable. The Read Me tab walks the cadence in detail.
Or skip the spreadsheet entirely
A spreadsheet runs your tax tracking once a week, if you remember. Ardent Seller tags every transaction to a Schedule C line as you record it, sums by category in real time, and exports a Schedule C-mapped P&L in one click — so on April 15 you're downloading a report, not reconstructing a year of receipts.
Schedule C tax categories
Tag every expense and income transaction to a Schedule C line — system defaults plus per-account overrides — and the categorizing happens once, when you record the transaction.
Profit & Loss and Schedule C reports
Pull a year-end summary mapped to Schedule C lines in seconds, broken down by month or quarter, ready to hand off.
Receipt attachments on transactions
PDF or photo receipts attached to the transaction record itself — no separate filing cabinet, no missing-receipt audit risk.
Frequently asked questions
How does an Excel Schedule C expense tracker work?
The pattern: log each business expense once on the Expense Log tab, pick the matching Schedule C category from a drop-down, and the workbook adds your deductions by month and by category automatically. At year-end the Schedule C Summary tab shows the totals lined up by IRS form line — Line 8 Advertising, Line 22 Supplies, Line 27a Other, Part III COGS Purchases, etc. — exactly the way your tax preparer expects to see them.
What expense categories does Schedule C use?
Schedule C Part II has 19 numbered expense lines (8 Advertising; 9 Car & truck; 10 Commissions and fees; 11 Contract labor; 12 Depletion; 13 Depreciation; 14 Employee benefits; 15 Insurance; 16a/b Interest; 17 Legal and professional; 18 Office expense; 19 Pension; 20a/b Rent; 21 Repairs; 22 Supplies; 23 Taxes and licenses; 24a/b Travel and meals; 25 Utilities; 26 Wages; 27a Other expenses). Part III separately tracks Cost of Goods Sold (Purchases, Materials and supplies/labor used in production, Other costs) and Line 30 handles the home office. This tracker covers all the lines that apply to a typical maker, baker, or craft seller.
How do I track business mileage for Schedule C?
The IRS requires a contemporaneous log: date, destination, business purpose, and miles for each trip. The deduction at the standard mileage rate (currently 70¢/mile for 2025; 67¢/mile for 2024) goes on Line 9. The Mileage Log tab in this workbook handles the math — set the year's rate once in cell C5 each January and every drive turns into a Line 9 deduction. Drives between home and a regular workplace are commuting and not deductible; drives to suppliers, post office, and craft shows are.
Can a sole proprietor use this tracker?
Yes — Schedule C is the form sole proprietors and single-member LLCs file alongside their personal Form 1040. If you receive a 1099-K from Etsy, Square, Shopify, or PayPal and you don't have employees other than yourself, this is the right form and this is the right tracker. Multi-member LLCs file Form 1065 (partnership) and S-corps file Form 1120-S — those have similar but different category lists, so this tracker isn't the right fit.
What's the difference between Supplies (Line 22) and Cost of Goods Sold?
COGS is what becomes the product — wax, fragrance, jars, and wicks for a candle; flour, butter, and sugar for a cookie; fabric, thread, and notions for a quilt. Supplies (Line 22) is what supports the operation but doesn't become the product — packaging tape, label rolls, gloves, cleaning supplies, software subscriptions, postage. Drawing the line wrong inflates Line 22 and understates COGS, which in turn breaks your beginning-plus-purchases-minus-ending-inventory math. This is the most common Schedule C mistake; the Categories Reference tab spells out the boundary for each line.
Related resources
Quarterly Estimated Tax Worksheet
A working Excel worksheet for self-employed makers — log income, set filing status, and the four quarterly estimated-tax payments calculate themselves. SE tax (15.3%) plus federal income tax math built in, with a safe-harbor escape hatch on its own tab.
Small Business Tax Deduction Cheat Sheet
Every Schedule C line that matters to a maker — what belongs, what doesn't, and the mistakes that cost money.
End-of-Month Closeout Checklist
Seven steps to a clean monthly close — sales reconciliation, inventory counts, expense review, P&L, planning, reordering, and backup. Print one each month.
Product Pricing Calculator
A working Excel pricing calculator — materials, labor, packaging, and platform fees in, a defensible retail price out. Plus a batch tab that shows what 50 vs. 10 actually costs.
Digital Product Seller's Profit Dashboard
A working Excel profit tracker for printable, template, and digital download sellers on Etsy / Gumroad / Shopify / Payhip / your own site. Per-listing units, fees, ad spend, net profit, and a top-earner / underperformer / bundle-candidate signal — no email required.
Spreadsheet vs Inventory Software: The Decision Guide
When a spreadsheet is enough, when it stops working, and how to tell the difference before it costs you.