If you're self-employed — freelancer, sole proprietor, single-member LLC, gig worker — you file IRS Schedule C. It's where you report business income and expenses. The form itself takes 20 minutes if your books are organized. It takes 4 hours if they're not.
The difference is whether you tracked expenses correctly throughout the year. Here's how to set up a Schedule C spreadsheet that makes April painless.
The IRS defines specific expense categories on Schedule C (Form 1040), lines 8 through 27. If your expense tracker uses these same categories, your year-end totals transfer directly to the tax form. If your tracker uses custom categories like "misc" or "other stuff," you'll spend hours recategorizing at tax time.
Build the spreadsheet right once. Benefit every year.
Here are the categories the IRS uses, with what actually goes in each one:
| Line | Category | What Goes Here |
|---|---|---|
| 8 | Advertising | Google Ads, Facebook Ads, business cards, website hosting |
| 9 | Car & truck expenses | Mileage (67 cents/mile for 2024) or actual expenses |
| 10 | Commissions & fees | Platform fees (Stripe, PayPal, Etsy), referral commissions |
| 11 | Contract labor | 1099 contractors you hired (not W-2 employees) |
| 12 | Depletion | Rarely used for service businesses. Skip unless you mine minerals. |
| 13 | Depreciation | Equipment, computers, vehicles (Section 179 or MACRS) |
| 14 | Employee benefits | Health insurance, retirement plan contributions for employees |
| 15 | Insurance | Business liability, E&O, professional indemnity (NOT health insurance — that's personal) |
| 16a/b | Interest | Business loan interest, business credit card interest |
| 17 | Legal & professional | CPA fees, lawyer fees, bookkeeping services |
| 18 | Office expenses | Office supplies, printer ink, paper, small tools under $200 |
| 19 | Pension & profit-sharing | Solo 401(k), SEP-IRA, SIMPLE IRA employer contributions |
| 20a/b | Rent/lease | Office rent, equipment leases, coworking space |
| 21 | Repairs & maintenance | Equipment repairs, website fixes, facility maintenance |
| 22 | Supplies | Raw materials, packaging, consumables used in delivering your service |
| 23 | Taxes & licenses | Business licenses, franchise taxes, state registration fees |
| 24a | Travel | Flights, hotels, Uber for business trips (NOT commuting) |
| 24b | Meals | Business meals (50% deductible in most cases) |
| 25 | Utilities | Phone, internet (business-use portion), electricity for office |
Lines 26 (wages) and 27 (other expenses) round out the form. "Other expenses" is your catch-all for legitimate business expenses that don't fit the categories above — software subscriptions, professional development, etc.
Your spreadsheet needs three things to be useful:
One row per expense. Columns: Date, Description, Category (from the list above), Amount, Payment Method. This is your audit trail. When you enter an expense, categorize it immediately using the IRS categories. The two seconds it takes now saves you twenty minutes of guessing in March.
Auto-sum each category by month and year-to-date. This is your profit and loss statement. Revenue minus total expenses = net profit. That net profit number is what flows to Schedule C line 31 and determines your tax liability.
Self-employed people owe estimated taxes quarterly (April 15, June 15, September 15, January 15). The penalty for underpaying is real — roughly 8% annualized on the shortfall.
Safe harbor rule: Pay at least 100% of last year's total tax liability in estimated payments (110% if your AGI exceeds $150K). If you hit that threshold, you owe zero underpayment penalty regardless of what you actually owe in April. This is the single most useful tax rule for freelancers.
Your spreadsheet should calculate estimated quarterly payments automatically from your YTD income. Self-employment tax (15.3% on 92.35% of net earnings) plus your marginal income tax rate, divided by four. Update it monthly as income comes in.
QuickBooks Self-Employed costs $15-25/month ($180-300/year) and does three things well: bank feed auto-import, receipt scanning, and mileage tracking. If you process 100+ transactions per month, the auto-import alone justifies the cost.
But if you process 20-50 transactions per month — which covers most freelancers and solopreneurs — a well-built spreadsheet does the same job for a one-time cost. You categorize expenses manually (takes 5 minutes per week), and the Schedule C output is identical.
The right tool depends on your transaction volume. Don't pay $300/year for software when a $29 spreadsheet (one-time) handles your actual workload.
The entire system is simple: categorize expenses as they happen using the IRS's own categories, run a quarterly tax estimate, and hand your CPA a clean Schedule C at year end. The spreadsheet is the tool. The habit is what makes it work.
Pre-built with all 19 Schedule C categories, quarterly tax estimator with safe harbor, and auto-populated year-end output.
Small Business Dashboard — $29 Freelancer Command Center — $29What is Schedule C and who has to file it?
Schedule C is IRS Form 1040's "Profit or Loss from Business" section. If you received income as a freelancer, sole proprietor, single-member LLC, or gig worker — and that income was not reported on a W-2 — you file Schedule C. Even with no profit (or a loss), you still file it if you had business activity. The net profit on Schedule C flows to Form 1040 line 8 and is subject to both income tax and the 15.3% self-employment tax.
What is the self-employment tax rate in 2026?
The self-employment tax rate is 15.3% on net self-employment income — 12.4% Social Security (up to the annual wage base) plus 2.9% Medicare (no cap). The SE tax applies to 92.35% of net earnings, not the full 100%, to account for the employer-equivalent portion. You deduct half of SE tax paid as an above-the-line deduction on Form 1040, which reduces your income tax but not the SE tax itself.
Can I deduct my home office on Schedule C?
Yes, if you have a dedicated space used regularly and exclusively for business. The simplified method allows $5 per square foot, up to 300 square feet ($1,500 maximum). The regular method calculates your actual home expenses multiplied by the percentage of your home used for business. Both report on Form 8829, which flows to Schedule C line 30. The home office deduction cannot create or increase a Schedule C loss — it is limited to the gross income from the business.
What records do I need to keep in case of a Schedule C audit?
IRS auditors look for business purpose documentation for every deduction. For each expense: a bank statement or credit card record showing the payment, a receipt or invoice showing what was purchased, and a brief note on the business purpose. For vehicle deductions, a contemporaneous mileage log — date, destination, business purpose, miles — is required. Keep records for at least three years from the filing date, or six years if you underreported income by more than 25%.