1099 / Schedule C Self-Employed Tax Spreadsheet
Never get ambushed by a quarterly tax bill again.
A Schedule C spreadsheet for freelancers and the self-employed who earn unevenly and find out what they owe when it's too late to save for it.
1099 / Schedule C Self-Employed Tax Spreadsheet is a 9-tab Excel and Google Sheets workbook. 2 you type into, 5 calculated from those and 2 you set once. No macros, so it opens without a security warning.
- Dashboard Net profit this period, the estimated tax on it, what is still likely owed at filing, and quarterly payments made so far.
- Dashboard (Dark) The same dashboard in a dark theme, for screens that are easier on the eyes at night.
- Income & Expense Date, description, type, expense category, location, amount, and which quarter it counts toward.
Filed under tax & self-employed.
This is exactly what I wanted. I checked out several, and none of them were quite right. This one fit the bill, and I will use it to stay on track with taxes for the upcoming year. Thanks for a great product!
An educational tool, not tax advice. It organizes your own records and estimates; check your return against the IRS's Schedule C instructions or with a tax professional before you file.
8 of the 9 tabs, exactly as they look in the file. Click a tab to look inside.
Sound familiar?
What's inside, tab by tab
You only ever type in the highlighted input cells. Everything else is calculated from what you type.
| Tab | What you do | What it does |
|---|---|---|
| Tab 1Start Here | Set once, never again | A one-page setup guide inside the workbook. Enter your basics once, in about 5 to 10 minutes. |
| Tab 2Dashboard | Calculated for you | Net profit this period, the estimated tax on it, what is still likely owed at filing, and quarterly payments made so far. |
| Tab 3Dashboard (Dark) | Calculated for you | The same dashboard in a dark theme, for screens that are easier on the eyes at night. |
| Tab 4Income & Expense | You type here | Date, description, type, expense category, location, amount, and which quarter it counts toward. |
| Tab 5Tax Estimate | Calculated for you | Self-employment and income tax, worked out from the figures on the sheet before it. |
| Tab 6Quarterly Schedule | You type here | You fill in amount paid and date paid. Amount due, still to pay, days until due and status work themselves out. |
| Tab 7Scenario Manager | Calculated for you | The same year at 75%, 100% and 130% of your projected income, so a slow or busy rest-of-year is priced before it happens. |
| Tab 8Year-End Tax Summary | Calculated for you | Income, deductible expenses and net profit month by month, with each expense category mapped to its Schedule C line. |
| Tab 9Settings & Lists | Set once, never again | The dropdown lists and defaults the rest of the workbook reads. Change them once and every sheet follows. |
Want one quick number first? Three free tools run in your browser, no sign-up: the quarterly estimated tax calculator shows what to pay the IRS each quarter under the safe harbor, the mileage deduction calculator applies the IRS rate for each trip date, and the freelance rate calculator works back to the hourly rate you need to charge.
Built like software, priced like a spreadsheet
Enter your data; totals, flags and the dashboard update instantly.
Checked cell by cell before release. Find one and we will fix it.
Formula cells are protected. You can only type where typing is safe.
Both versions in every purchase. No converting, no broken references.
Clean report pages for your records, your accountant, or your next meeting.
Delivered by Etsy the moment you pay. Free updates to this template forever.
How it works
Secure checkout through Etsy, no account needed here.
The Excel file and the Google Sheets link arrive immediately.
Type into the highlighted cells and every total is calculated from what you typed.
Questions, answered
Do I need a paid Excel version?
Any desktop Excel from 2016 onward works, including Microsoft 365. If you don’t have Excel at all, use the included Google Sheets version. It’s free.
Does it fully work in Google Sheets?
Yes. The Google Sheets version is made from the same file as the Excel one and checked in Google Sheets before release. Every formula uses functions that work the same in both.
Is this a one-time purchase?
Yes. One payment, no subscription. You keep the files forever and get free updates to this template.
What does it not do?
There are no tax tables, brackets, standard deduction or credits inside, and it will never tell you what to pay. You supply the rates and figures; it does the arithmetic and shows every step, so you and your accountant can check it. The quarterly due dates are left for you to enter.
What’s the refund policy?
Refunds follow Etsy’s rules for digital downloads. If a template doesn’t work as described, email support@elecart.us and we will fix it.
What if I get stuck?
Email support@elecart.us and the person who built the template answers, usually within one business day. Etsy Messages works too.
How much data can it handle?
Input tabs are sized generously and tested with full sample data: enough for years of typical use. Need more room? Duplicate the file per year, or email support for an extended version.
Never get ambushed by a quarterly tax bill again.
$3.80, once, 70% off until Nov 28. Yours forever, with free updates.
Get it on Etsy →Also in Small Business
