Schedule C Receipt Tracker (Google Sheets): The Underbuilt-on-Purpose Setup for Sole Proprietors (2026)

Last updated: May 2026

Short answer: A six-column Google Sheet (Date, Merchant, Amount, Category, Schedule C Line, Notes) plus a phone-first receipt capture tool is enough to handle every Schedule C expense line for most sole proprietors. The categories map cleanly to Schedule C Part II line numbers, the rows are filterable and summable, and your accountant can open the file in a browser tab without installing anything. ReceiptToSheet handles the photo-to-row step so you stop typing receipts at the kitchen table in April.

The first time i actually filed Schedule C properly was in 2018, for a freelance writing side income that crossed the threshold where the standard deduction stopped covering for sloppy record-keeping. My system was a Costco shoebox full of receipts and a desperate three-day reconstruction project the weekend before filing. I missed about $1,800 in deductions because the receipts had faded or gotten lost or i'd never written down what the unmarked $87 charge at "ABS BUS SUP CO" was actually for. The reconstruction cost me a tax bill that was higher than it needed to be plus a Saturday i couldn't get back.

This post is the system i wish someone had handed me. It's deliberately under-built — a spreadsheet and a phone, not a SaaS dashboard with login screens. The whole point is that the system survives a year where you're busy with the actual business.

Why Google Sheets (and Not Hurdlr, QuickBooks Self-Employed, or Keeper)

There's a class of SaaS apps built for this exact problem: Hurdlr, QuickBooks Self-Employed, Keeper Tax, FreshBooks, Wave. They all work. They all charge a monthly fee. They all live in their own dashboard, with their own categorization scheme, their own reports, their own export formats.

If you're already running one and it sticks, keep using it. The right tool is the one you actually use.

The argument for Google Sheets specifically:

Your accountant already knows how to read it. Send them the Sheet URL. Done. No "what's your Hurdlr login" email chain.
You own the data. Nothing locks you in to a vendor's category scheme or pricing model.
It's free. Permanently. The Sheet itself doesn't cost anything and never will.
It survives a year of neglect. A spreadsheet you didn't open for two months still has your data when you come back. SaaS dashboards that you stopped logging into often become unfamiliar enough that you don't restart the habit.
It's debuggable. When a category total looks wrong, you scroll up and find the offending row. No support ticket required.

The argument against:

It doesn't automate. You have to put the row in. Which is exactly the gap a phone-first capture tool fills.

Most self-employed people who reach for SaaS for Schedule C tracking are reaching for it because they don't want to type. That's a real problem. But "type less" doesn't require a $30/month subscription and a separate dashboard — it requires a tool that turns a receipt photo into a row in your existing Sheet. Same goal, lower overhead.

The Column Structure That Survives a Tax Year

After helping a few freelancer and solo-business friends set this up, the column structure that actually works:

Date	When the expense occurred	2026-03-14
Merchant	Where you spent	Staples
Amount	Receipt total, including tax	$46.23
Category	Your internal bucket	Office supplies
Schedule C Line	The IRS line number	Line 22 (Supplies)
Notes	One-line context	"Printer toner + envelopes for client billing"

Six columns. That's it. Don't add more — the columns you'll be tempted to add (subcategory, tax-vs-non-tax-portion, billable-to-client, project tag) belong in the Notes field if they're occasional or in a separate sheet if they're consistently structured.

The Schedule C Line column is the trick that makes April filing five minutes instead of two days. When tax time comes, you filter by Schedule C Line, sum the Amount column, type that number on the form. No interpretation, no judgment calls, no reconstruction.

Mapping Categories to Schedule C Lines

Schedule C Part II has the deductible expense lines you'll mostly use. Here's the mapping that covers maybe 95% of solo-business expenses:

Line 8 — Advertising	Marketing, branding, paid ads	Google Ads, Meta, business cards, signage
Line 9 — Car & truck	Vehicle expenses (standard mileage OR actual)	Tracked separately via a mileage app
Line 11 — Contract labor	1099 contractors you paid	Independent freelancers, subcontractors
Line 13 — Depreciation	Section 179 + bonus depreciation on assets	Major equipment, vehicles >$2,500
Line 15 — Insurance (non-health)	Business insurance, liability	State Farm, Hiscox, etc.
Line 16 — Interest	Business loan/credit interest	Business credit card finance charges
Line 17 — Legal & professional	Lawyers, accountants, consultants	LegalZoom, your CPA, business coach
Line 18 — Office expense	General office expenses	Office supplies, software subscriptions
Line 20 — Rent (office/equipment)	Lease payments	WeWork, equipment rentals
Line 21 — Repairs & maintenance	Fixing business assets	Computer repair, equipment service
Line 22 — Supplies	Consumable supplies	Staples, Costco for office supplies, packing materials
Line 23 — Taxes & licenses	Business taxes, professional licenses	State franchise tax, professional license renewals
Line 24a — Travel	Business travel transportation/lodging	Hotels, flights, Ubers on business trips
Line 24b — Meals (50%)	Business meals (50% deductible)	Restaurant receipts on business trips, client lunches
Line 25 — Utilities	Business-related utilities	Phone bill (business %), business internet
Line 27a — Other expenses	Anything that doesn't fit the above lines	Specific to your business; itemized on Part V

Two notes:

Office supplies vs Supplies (Line 18 vs Line 22) is a common confusion. Line 18 (Office expense) is for the general operating-an-office overhead — pens, paper, printer ink, software, the small recurring buys. Line 22 (Supplies) is for materials consumed in the business itself — packing materials for a Shopify store, hair products for a stylist, art supplies for an illustrator. If you're not sure which, the conventional fallback is Line 22 for anything tactical and Line 18 for anything administrative.
Health insurance premiums are NOT a Schedule C line. Self-employed health insurance is deducted on Schedule 1, above-the-line. Different form, different treatment. Don't put your health premiums in the Schedule C tracker — keep them in a separate row in a parallel sheet or in your tax prep notes.

For a side income that's small and clean, you might only ever use 4–5 of these lines in a given year. Don't pre-populate every row with a Schedule C number you'll never use. Add the numbers as you encounter expenses that need them.

What About Mileage?

Mileage is a separate workflow and shouldn't live in the receipt tracker.

Track miles continuously with a GPS app — Stride (free), Hurdlr ($), MileIQ. The IRS prefers a contemporaneous mileage log (one logged as you drive) over a reconstruction from memory.
At tax time, the mileage app exports a total business-mile number. You multiply by the IRS standard mileage rate (or run actual-expenses math if you picked that method in year one). That number lands on Schedule C Line 9.
The receipt tracker captures everything that stacks on top of standard mileage — tolls, parking, car washes if your business drives a vehicle. These go in the appropriate Schedule C line (Line 22 Supplies for car washes/supplies; Line 24a Travel for tolls; Line 9 if you're on actual-expenses and tracking gas).

The two systems together cover Schedule C completely for a sole-proprietor with vehicle expenses. Mileage app for the miles, receipt tracker for everything else.

What Should Your "Receipts" Even Include?

The word "receipt" sometimes makes people think only of physical thermal-paper printouts from a store. For Schedule C substantiation, the receipts you should be capturing include:

Printed thermal receipts from physical retail purchases
Emailed receipts from online purchases (forward to a tax-tracking folder or screenshot)
Subscription invoices for software, hosting, professional tools
Credit card statements as a backup substantiation when a primary receipt is lost (line items missing, but date + merchant + amount is there)
Tax-deductible service invoices from contractors, accountants, lawyers
Estimated quarterly tax payments to the IRS (these aren't Schedule C deductions — they're prepayments toward your annual tax — but you want to track them in a separate tab)
Bank-issued business expense reports (some business credit cards generate categorized year-end summaries that are useful for reconciliation)

A modern receipt tracker should handle the printed and the digital alike. The capture step is "get the data into a row" regardless of where the receipt came from.

A Working Receipt-Tracking Workflow

For someone setting this up clean from scratch:

Create the Google Sheet with the six columns above. Title it something like "2026 Schedule C Tracker."
Pin the Sheet in your browser bookmarks bar AND share the URL with your accountant. Make sure their access is set to View at minimum — Comment if you want them to be able to flag rows.
Set up two sister tabs: one for the receipts (the main tab), one for mileage (if you have vehicle expenses), one for the quarterly estimated tax payments. Three tabs, one Sheet.
Pick your capture tool. Three approaches:
- Manual entry — you type each row yourself. Works for low-volume side incomes (say <30 receipts/month). Free.
- CSV-based — capture receipts in an app (Hurdlr, QBSE, Keeper), export monthly, paste into the Sheet. Adds friction. Works.
- Direct-to-Sheet — a tool that writes the row to the Sheet for you. ReceiptToSheet is built for this. Photo, confirm, row appears.
Capture at the moment of purchase. Parking-lot, post-checkout. Two seconds. The capture habit is what makes the rest of the workflow function.
Weekly Sunday-night sweep. Open the Sheet, fix any miscategorizations, add Schedule C line numbers to the rows that don't have them yet. Two minutes for a typical week.
Quarterly: send the Sheet link to your accountant for a 10-minute review. Catch anything obviously wrong before it compounds for nine more months.
April: filter by Schedule C Line, sum, type into your tax prep software or hand to your accountant. Done.

The biggest behavioral change is the parking-lot capture. Once that's muscle memory, the system runs itself.

When to Step Up to Real Bookkeeping Software

This setup is the floor — the thing that beats a shoebox of receipts. There are points where you should consider stepping up:

You've crossed $100K+ in self-employment income and a CPA is now a real working relationship. They may want QuickBooks (full version, not Self-Employed) integration. Talk to them about whether they want the Sheet or a different system.
You've hired your first employee or contractor regularly and payroll is in the picture. The complexity now extends beyond Schedule C and a spreadsheet starts to creak.
You have inventory. A real inventory-tracking system (Cost of Goods Sold on Line 36 etc.) is more than a spreadsheet should hold. Wave, Xero, or QBO are reasonable next steps.
You're at the line between sole proprietor and S-corp. Once you elect S-corp status, you have payroll, reasonable-compensation analysis, distributions vs salary — a CPA is in the loop and they pick the system.

Until one of those hits, a Sheet + a phone scanner + a mileage app is enough.

Frequently Asked Questions

Can my accountant actually work with a Google Sheet for Schedule C?

Yes. Most CPAs working with sole proprietors and freelancers are perfectly happy to receive a Google Sheet link. The categories map to Schedule C lines, the totals are filter-and-sum, and the source receipts are linked (or, in ReceiptToSheet's flow, the image is one click away from each row). What CPAs usually prefer is one source of truth — don't send them three half-finished spreadsheets and a folder of CSVs. Send the Sheet.

Do I need a separate business bank account if I'm a sole proprietor?

The IRS does not require a separate business bank account for sole proprietors. But it's strongly recommended for record-keeping cleanliness — it makes the audit story simpler ("here's the business account, every transaction is business") and removes ambiguity. The receipt tracker doesn't care whether you used a personal or business card, only that the expense was business-related. But your accountant will thank you for the separation.

How do I handle a receipt where part of the purchase was business and part personal?

Two approaches. Either log only the business portion as the amount, with the merchant and date matching the original receipt and a note like "business portion only — full receipt $X." Or log two rows: one for the business amount (with the Schedule C line) and one for the personal amount (categorized as "Personal — non-deductible" and excluded from Schedule C sums). The two-row approach is cleaner for audit defense; the single-row approach is faster.

What if I lose a receipt entirely?

For Schedule C substantiation, a credit card statement entry showing date + merchant + amount is often acceptable, especially when paired with a written note about what the expense was for. The IRS Cohan rule allows reasonable estimation of deductible expenses when records are lost. Reconstruction is acceptable but always weaker than a contemporaneous receipt — and the kind of reconstruction the IRS challenges hardest is the rounded-number, no-supporting-doc kind. Capture the receipt the day of, every day.

Does ReceiptToSheet handle the Schedule C category mapping automatically?

ReceiptToSheet's Schedule C tax mode (added 2026-05-08) routes receipts to a default Schedule C category based on merchant patterns — Costco for office supplies routes to Line 22 by default, Staples to Line 18, hotel chains to Line 24a — with a one-tap dropdown to change before the row is committed. The mapping isn't perfect (no auto-categorization is) but it's a meaningful time-saver over typing every row from scratch.

How long do I need to keep Schedule C receipts?

The IRS generally recommends three years from the date you filed. For Schedule C income (which the IRS considers higher risk than W-2 income), seven years is the safer floor — particularly if any deductions are large or unusual. Digital images count for substantiation; you don't need to keep physical paper. A Google Sheet linked to cloud-stored receipt photos handles the full retention requirement cleanly.

Should I worry about the meals deduction being only 50%?

If you're claiming business meals on Schedule C Line 24b, the deduction is 50% of the actual receipt amount (with limited exceptions for office events and similar). The right way to handle this in the Sheet: log the full receipt amount in the Amount column, put the Schedule C line as 24b, and in your filing step apply the 50% reduction once at the line-total level. Don't try to halve the amounts at the row level — that loses the actual receipt total for any future audit reconstruction.

Bottom Line

Schedule C is approachable. The form has 20-ish lines, your spend lives in 5–8 of them, and a Google Sheet with the right columns turns tax prep into a filter-and-sum exercise.

The hard part isn't the categorization — it's getting the receipts into the Sheet in the first place. Parking-lot capture, photo flows into the Sheet as a row, Sunday-night two-minute sweep, quarterly accountant glance, April filter-and-sum. Done.

The systems built for this problem cost $25–50/month and live in their own dashboard. A Sheet you already know how to read costs zero, your accountant can open it without installing anything, and the data is yours forever.

Try ReceiptToSheet free — 20 scans/month, Schedule C tax mode included →

Written by Daniel Shao, creator of ReceiptToSheet. I built ReceiptToSheet after years of tracking shared expenses with my wife in a Google Sheet — photographing receipts, then typing them in one by one. The product is the tool I wanted to exist. Tax statements in this post are general information for self-employed sole proprietors filing Schedule C — your specific situation, particularly anything involving inventory, S-corp election, or large depreciation choices, should go through your accountant.