Accountio / Templates / Self-employed expense tracker / Schedule C expense sheet

Schedule C expense template for 2026 (Excel)

Give each self-employed client one sheet to log every business expense against the 2026 Schedule C line it belongs on, so the totals arrive sorted by line. This Schedule C expense template is the Expenses sheet of a free Excel tracker, with mileage, home office and quarterly totals on the other sheets.

US firms
Free
In the pack
Self-employed expense tracker
Files
4, Word and Excel

Get the pack by email

What the tracker looks like

Schedule C expense sheet template
What the Expenses sheet coversColumn or sheet in the tracker
One row per expense
✓
Date paid, Paid to, What for (meals: who and why)Room for 1,000 expenses in the year
The amount actually paid
✓
Amount paidThe full cost, before any business use split or meals limit
The Schedule C line
✓
Schedule C lineA list of lines 8 to 27b from the 2026 form, including 16b for vehicle loan interest
Mixed business and personal costs
✓
Business use %For a phone or internet bill used partly for personal purposes; blank counts as 100%
Receipts
✓
Receipt kept?, Hotel stay?Yes or No on every row; a hotel stay without a receipt is flagged at any amount
What can be claimed
✓
Deductible amountAmount times business use, with meals on line 24b counted at 50%
The estimated tax period
✓
PeriodJan-Mar, Apr-May, Jun-Aug or Sep-Dec, from the date paid
Mistakes flagged
✓
CheckMissing date or line, a date outside 2026, meals with no note of who and why, and missing receipts
Totals by line
✓
Summary by lineAdds each line from this sheet into the Schedule C layout, through to net profit
What each line is for
✓
Schedule C linesPlain notes and examples for every line in the list

When to send the Schedule C expense template

A sole proprietor reports business expenses in Part II of Schedule C, lines 8 to 27b, before the home office on line 30. On the 2026 form, line 16 splits into mortgage interest (16a), vehicle loan interest (16b) and other interest (16c). Send the tracker when:

  • A new self-employed or freelance client needs a way to keep records from the start of the year
  • A client hands over a box of receipts and bank statements each spring
  • You want each client's expenses already sorted by Schedule C line when they arrive
  • You work out quarterly estimated tax and need the expenses for each period

How to use the Schedule C expense template

  1. Set up the workbook first. Fill in the Setup sheet with the client's name, the business and how they claim car costs, then delete the [Example] rows on Expenses.
  2. Log every expense as it is paid. Date, who was paid, what for and the full amount. Pick the Schedule C line from the list.
  3. Split shared costs. Enter the business use % for anything used partly for personal purposes. For meals, write who they met and why.
  4. Clear the Check column. Each row shows OK or a short instruction, such as adding a date or finding a receipt.
  5. Send it back each quarter. The Period column feeds the Quarterly totals sheet, and Summary by line gives the year's totals by line.

Questions

What expenses go on Schedule C?

Ordinary business costs, reported on lines 8 to 27b of Part II: advertising, car and truck, contract labor, insurance, interest, legal and professional fees, office expense, rent, repairs, supplies, taxes, travel, meals, utilities, wages and other expenses. Home office costs go on line 30 instead.

How much of a business meal can be deducted?

50% of the cost. The client logs the full amount on line 24b and the sheet counts half, so they never need to work out the split themselves.

Does every expense need a receipt?

IRS Publication 463 says documentary evidence such as a receipt is not needed for a travel, meal or gift expense under $75, other than lodging, if the log shows the amount, date, place and business purpose. Lodging always needs a receipt. For everything else the sheet asks for the receipt, bill or bank record.

Where do car costs go with the standard mileage rate?

With the standard mileage rate, the deduction is business miles times the rate, plus parking fees and tolls, and the client doesn't claim gas or repairs as well. The Mileage sheet handles this at 72.5 cents a mile to June 30, 2026 and 76 cents from July 1. With actual expenses, car costs go on Expenses under line 9 with the business use %.

Does sales tax go on line 23?

Only state and local sales tax imposed on the client as the seller, and if they collected it from the buyer it must also be in gross receipts on line 1. The Schedule C lines sheet explains this beside line 23.

Is the tracker free?

Yes. The whole tracker, the client guide and the cover letter are free. Enter your email and we send you the pack.

Also in the self-employed expense tracker

What to keep and how to fill in the trackerCover letter

See the whole pack →

Who it's for

CPA firms, enrolled agents and tax preparers with sole proprietor, freelance and gig worker clients who file Schedule C.

Last checked

Checked against the 2026 Schedule C, the Schedule C instructions, IRS standard mileage rates and Publication 463 in November 2026.