Schedule SE Excel - Free Template

1. Open the Instructions tab and read the worksheet flow before you enter any numbers. The file is set up around the three tabs shown in the screenshots.
2. Go to the SE Tax Worksheet and enter your net profit from Schedule C or other self-employment income in the input cells. Use the same annual figure you would use for your return.
3. Check the worksheet calculations for the tax base and self-employment tax amount. The formulas are already laid out, so you only need to replace the placeholder or sample values with your own.
4. Review the Summary Dashboard for the final total and any highlighted results. This is the view you use when you want a quick answer before a quarterly payment.
5. Compare the worksheet output with your own records, such as profit & loss reports, prior-quarter estimates, or bookkeeping summaries. A mismatch usually means you missed income, expenses, or an adjustment.
6. Update the workbook when your profit changes during the year. If your year-to-date income moves by a few thousand dollars, your estimated tax payment can move by hundreds of dollars.

This worksheet is for the people who actually have to turn business income into a tax number: a sole proprietor on Schedule C, a single-member LLC taxed as disregarded, or a partner with ordinary self-employment income. If you made $68,000 of net profit, the question is not theoretical; you need a worksheet that shows the amount that flows into Schedule SE and then to Form 1040.

The file fits the moment when you are doing a quarterly tax check, a year-end close, or a return prep session with a banker’s box of receipts. A bookkeeper at an LLC with $12,500 of monthly gross receipts can use it to estimate the owner’s tax hit before cutting the 1040-ES payment.

Where This Helps Most

It is most useful when your income is uneven. One month you clear $9,000, the next month you clear $3,400, and you still need a clean annual estimate for self-employment tax.

Why the Dashboard Matters

The dashboard gives you a fast review point. If your year-to-date profit is $54,000 and you know roughly 92.35% of that is the tax base, you can see immediately whether your payment plan is too light.

Practical Timing

People usually open a worksheet like this at tax season, after a strong quarter, or right before an estimated payment deadline. That is when the difference between a $7,800 tax estimate and a $9,200 tax estimate affects cash flow in a real way.

The IRS treats self-employment tax as the Social Security and Medicare portion owed on net earnings from self-employment. The combined rate is 15.3%: 12.4% for Social Security and 2.9% for Medicare, with the deductible half reflected on the return.

For the calculation, the worksheet should follow the standard 92.35% net-earnings base used in Schedule SE. If your net profit is $80,000, the base is $73,880, and the tax before any additional Medicare considerations is materially higher than a flat 15.3% of gross receipts would suggest.

What Lands On Your Return

The result feeds into Form 1040, and the payment planning side usually runs through 1040-ES. The quarterly due dates are April 15, June 15, September 15, and January 15, so this worksheet is useful long before the return is filed.

Why The Tax Base Is Not Gross Revenue

You do not pay self-employment tax on every dollar that came into the business bank account. A contractor with $120,000 of receipts and $42,000 of expenses may only be taxed on the remaining net profit, which is why a worksheet built around net income is the correct tool.

Business Entity View

A S-corp is different because wages run through payroll and are subject to FICA rather than self-employment tax. For a plain Schedule C filer, though, this worksheet stays the simplest way to see the amount that really matters.

The biggest mistake is treating self-employment tax like a rough guess and then discovering the shortfall when the quarter is already closed. If you understate tax by $1,500 and miss an estimated payment, that is not just a number on paper; it is cash you no longer have when the 1040-ES deadline hits.

Another common error is using gross receipts instead of net profit. A business with $95,000 in sales and $61,000 in expenses should not be taxed as if every dollar were income, and that mistake can overstate the tax bill by thousands.

Bad Inputs Create Bad Tax

If you forget to include all business income, the worksheet will look clean and still be wrong. I have seen owners miss a $6,800 side-job check or a few thousand dollars of app revenue, then scramble when the return shows a much larger amount due than expected.

Late Payments Hit Cash Flow

Skipping a quarterly estimate can create a penalty and a cash flow squeeze at the same time. A quarter that should have been covered by a $2,200 payment can turn into a larger year-end balance that competes with rent, payroll, or vendor bills.

Why The Worksheet Structure Matters

When input cells and formula cells are not separated, you overwrite calculations and lose the trail. That is how a $74,000 profit gets entered as $47,000, and the owner then makes a payment based on the wrong base for the next three months.

Use the worksheet on the same day you close the books or pull the monthly profit & loss report. If you do it every quarter, you will see whether your estimated payment is drifting before the amount gets large enough to hurt cash flow.

Turn It Into A Fixed Date Habit

• Run it on the same day you prepare payroll or reconcile the business bank account.
• Copy the prior quarter’s numbers first, then replace only the new profit figures.
• Check the dashboard before you send the 1040-ES payment.

Keep The Data Clean

• Use one line for annual net profit so the calculation stays easy to audit.
• Do not mix owner draws with business income.
• Use a simple update note when the profit changes by more than $5,000 in a quarter.

Know When You Have Outgrown It

If you are tracking multiple owners, payroll, and recurring deductions, move the tax workflow into QuickBooks or a payroll system. A spreadsheet is still fine for a solo filer with one profit number, but it stops being the best tool once the process turns into monthly entity-level accounting.