Sole Proprietor Expense Spreadsheet: Schedule C Categories, Monthly Layout and Formulas

What should a sole proprietor expense spreadsheet include?

Two tabs do most of the work: a transaction log (one row per payment in or out) and a monthly summary that totals the log by category. Add a category list that maps each category to a Schedule C line, and year-end becomes copying totals rather than sorting receipts.

I build spreadsheet maths; I am not an accountant or tax preparer, and nothing on this page is tax advice. What you can deduct depends on your circumstances, so check categories with a tax professional before you file.

Sole proprietor expense categories mapped to Schedule C

Use the expense lines printed on Schedule C (Form 1040), Profit or Loss From Business, as your category names. The 2025 form lists these in Part II (IRS: Schedule C (Form 1040)):

Direct job costs such as materials go to cost of goods sold (Part III, which feeds line 4), not to line 22. Home-office costs go only on line 30. Lines 12, 14, 19 and 27a (depletion, employee benefit programs, pension and profit-sharing plans, and the energy efficient commercial buildings deduction) exist too; add them if they apply. The IRS Instructions for Schedule C explain what belongs on each line.

Try the monthly profit calculator

Enter one month's revenue, direct costs (materials) and total operating expenses. The calculator returns gross profit, operating profit and both margins, using the same maths as the worked example below.

The small business expense and P&L spreadsheet tracks revenue, COGS, gross profit and margin, operating expenses and net profit month by month, and adds break-even revenue and a running cash position.

Worked example: one month of income and expenses

With $9,500.00 of revenue, $1,400.00 of job materials and $2,860.00 of operating expenses, the month shows $8,100.00 of gross profit and $5,240.00 before tax. Every figure is an assumption for an example service business; replace them with your own.

On the form's own logic, revenue is line 1, materials sit in cost of goods sold (line 4), gross profit is line 5, the $2,860.00 is line 28 (total expenses) and the $5,240.00 corresponds to line 29, tentative profit, before any home-office amount on line 30. The layout is the same as the profit and loss template guide, with Schedule C names on the rows.

How to track expenses as a sole proprietor, month by month

Log every transaction the week it happens, tag it with one category, and let formulas build the monthly totals. Keep a separate bank account or card for the business so the log is a download, not a sorting exercise.

1. On a Cats tab, list categories in column A and their Schedule C line in column B.
2. On a Tx tab, log Date (A), Description (B), Category (C, a drop-down from Cats), Amount (D).
3. In column E of Tx, look up the Schedule C line from the category.
4. On a Monthly tab, put categories down column A and the first day of each month across row 1 (B1 to M1), with a year-to-date column N.
5. Fill the grid with SUMIFS, add subtotal rows for revenue, COGS and expenses, then profit rows.
6. At year-end, a second SUMIFS by Schedule C line gives the totals for each line.

How much tax should a sole proprietor set aside?

Nobody can give you one right percentage without your full return, so treat the set-aside as a labelled assumption cell and revisit it with a tax professional. What the IRS does state: the self-employment tax rate is 15.3% (12.4% Social Security plus 2.9% Medicare), on top of income tax (IRS: Self-employment tax), and sole proprietors generally have to make estimated tax payments if they expect to owe $1,000 or more when they file (IRS: Estimated taxes).

With an assumed 25% set-aside on the example month's profit:

That moves $1,310.00 to a separate savings account each month and leaves $3,930.00. Put the rate in its own cell (not inside the formula), label it as an assumption, and the whole sheet updates when you change it.

What expenses can a sole proprietor deduct, and what trips people up?

The IRS instructions describe deductible business expenses as ordinary and necessary costs of the business, and exclude personal, living and family expenses. Beyond that, the details are where a spreadsheet goes wrong. These points come from the Schedule C instructions:

• Your own health insurance is not line 14 or 15. Line 14 excludes contributions made on your own behalf as a self-employed person; the instructions point to Schedule 1 instead. Keep it in its own category.
• Meals are usually 50%. In most cases only 50% of business meal expenses is deductible. Log the full amount and let the summary apply the rule.
• Equipment is not an ordinary expense row. Business equipment and furniture are generally capitalised and depreciated (line 13), not dropped into supplies. Keep a separate equipment tab.
• Home office goes only on line 30. The form says to enter business use of home expenses only there.

Two more that are about bookkeeping, not tax rules: money you take out for yourself (owner draws) is not a business expense, so give it its own row below profit; and loan principal repayments are not expenses, though interest is. This is general information, not tax advice.

Profit is not the same as cash

An expense spreadsheet tells you profit; it does not tell you whether the bank balance can cover next month. Unpaid invoices, equipment purchases, loan principal and the tax set-aside all move cash without changing profit the same way.

If customers pay 30 days after the invoice, the $9,500.00 earned this month lands next month. Pair the expense log with a running cash position; the cash flow forecast template guide shows the layout. If you are also setting your own rate, the freelance hourly rate guide turns yearly expenses and a tax reserve into the rate you need.

Expense spreadsheet vs accounting software vs free templates

A spreadsheet suits a sole proprietor with a few dozen transactions a month who wants to see every formula. Accounting software suits a business that wants bank feeds, invoicing and an accountant in the same system. Free templates are fine for learning the layout.

What to put in your expense spreadsheet: a transaction log with receipt links; a category list mapped to Schedule C lines; a monthly grid with YTD; revenue, COGS, gross profit, expenses and profit rows; a labelled tax set-aside rate; an equipment tab; and a cash position.

The Small Business P&L + Cash Flow Tracker is $14.99 one-time for Excel and Google Sheets (also in the $49 Complete Toolkit). It covers revenue, COGS, gross profit and margin, operating expenses, net profit, break-even revenue and a running cash position; you add your own Schedule C category names.

Step-by-step: Sole Proprietor Expense Spreadsheet: Schedule C Categories, Monthly Layout and Formulas

1. Set up categories. List expense categories named after Schedule C lines 8 to 27b, plus cost of goods sold and income categories.
2. Log every transaction. Record date, description, category, amount and a receipt link for each payment in or out.
3. Total by month. Use SUMIFS on the transaction log to total each category for each month column.
4. Build the profit rows. Revenue minus COGS is gross profit; minus operating expenses is profit before tax. Example: $5,240.00.
5. Set aside tax. Multiply profit by a labelled assumption rate. At an assumed 25%, the example month sets aside $1,310.00.
6. Total by Schedule C line at year-end. SUMIFS by the Schedule C line column gives one total per line to hand to your tax preparer.

Related guides