1 / 20
Tap any image to enlarge, then swipe or use the arrows to page through every sheet.
This is for United States FEDERAL tax, tax year 2026, and nothing else — a buyer in Canada, the UK or the EU should stop reading here, and a buyer filing for 2025 should too. It says so on the workbook title, on the first line of the first sheet, in a red banner at the top of every one of the twelve sheets, and against all thirty constants on the Sources sheet. It does not compute state tax, and it computes tax before credits. Being unmistakably one thing is the point.
Every other self-employed tax template does the same trick: a yellow box marked "your tax rate %", and then it multiplies. That is not a tax calculator, it is a percentage. There is no such cell anywhere in this file and there never will be. Instead it runs the actual arithmetic on the actual forms — Schedule SE lines 3 to 13, Form 8959 for the 0.9% Additional Medicare Tax, the 2026 rate schedules, Form 8995-A for the section 199A deduction — with the IRS line numbers printed next to every figure so you can check it against the form in front of you.
The headline sheet is Form 2210 Schedule AI, the annualised income installment method, worked in full: Section B first, then Section A, with a complete section 199A block and a complete Form 8959 block inside each of the four columns. Nobody else builds this, and for anyone with a lumpy year it is the single most valuable page in the file. Four equal quarterly payments assume you earn evenly; if the money lands in July you are handing the IRS cash in April out of income you have not received. On the sample data that ships in the file, four equal quarters demand $10,013 on 15 April and Schedule AI demands $509. That is not a loophole — it is the IRS's own form, and the workbook shows you every line of it.
The four periods are the Form 1040-ES ones, not calendar quarters: 1 January to 31 March, 1 April to 31 May, 1 June to 31 August, 1 September to 31 December. The third is three months long and the fourth is four. Getting that wrong is the most common mistake in self-employed tax planning and most spreadsheets get it wrong; this one is built around it.
Twelve linked sheets and just under a thousand formulas. Schedule C by IRS category with the mileage helper, the 50% meals limit and the home-office line. Self-employment tax with the 92.35% adjustment, the 12.4% Social Security part capped at the $184,500 wage base for 2026, the uncapped 2.9% Medicare part and the deductible half. The section 199A deduction with the SSTB applicable percentage, the W-2 and UBIA cap, the phased-in reduction and the new $400 minimum that applies for the first time in 2026. All three safe-harbour tests side by side — 90% of this year, 100% of last year, 110% if your 2025 AGI was over the line — with the single lowest legal number and which test produced it. A payment calendar with the four due dates and a running shortfall. And a set-aside sheet that tells you what share of every invoice belongs to the IRS, then re-runs the entire engine at your profit plus $1,000 so you can see exactly what the next job costs you at the margin.
You can check every number. The Sources sheet lists all thirty constants with the IRS or SSA document each was read from, the URL, the day it was verified and whether it is inflation-indexed, statutory or a form mechanic — so whoever builds the 2027 version knows precisely which rows have to be re-fetched. It also sets out, in plain English, the six places where the law is genuinely unsettled, including one where this engine deliberately takes the more conservative reading and charges about $140 more tax than a well-known open-source model does. We tell you that, we tell you which way we went and why, and we tell you to ask your preparer. A tool you use to decide what to pay the IRS has to be honest about its own edges.
It ships filled in with a fictional single freelance consultant whose year is violently uneven — $200,500 of receipts, $28,500 of expenses, $172,000 of profit and $150,000 of it landing between June and August — so every sheet is alive the moment you open it. Clear the yellow cells and it is yours. Classic formulas only, so it behaves identically in Excel 2016 and later, Excel 365, Excel for Mac and Google Sheets. A seven-page print pack comes with it in US Letter and A4, colour and ink saver.
What you get
- United States FEDERAL tax, tax year 2026 only — stated on the title, the first sheet, every sheet header and against every constant
- No "type your own tax rate" cell anywhere: every rate comes from a named IRS or SSA document with a URL and a verification date
- 12 linked sheets, ~1,000 formulas — no macros, no add-ins, nothing locked
- The four Form 1040-ES periods, not calendar quarters: Jan–Mar, Apr–May, Jun–Aug, Sep–Dec
- Schedule SE in full: 92.35%, 12.4% to the $184,500 wage base, 2.9% uncapped, the $400 floor and the deductible half
- Form 8959 Additional Medicare Tax, 0.9%, with the household threshold and the self-employment interaction
- Section 199A on Form 8995-A: the SSTB applicable percentage, the 50%-of-W-2 and UBIA cap, the phased-in reduction, the 20%-of-taxable-income limitation and the new $400 minimum for 2026
- All three safe-harbour tests side by side, which one binds, the $1,000 de minimis and the single lowest legal number
- ★ Form 2210 Schedule AI, the annualised method, worked in full — Section B, Section A, and a whole 199A and 8959 block in each of the four columns
- Payment calendar with the four fixed 2026 due dates, what is owed, what you paid and a running shortfall
- Set-aside rate on every invoice, plus an exact re-run of the whole engine at profit + $1,000 to show your true marginal rate
- Sources sheet: 30 constants with document, URL, verification date and basis — and the 6 places the law is genuinely unsettled, in plain English
- Checks sheet: 29 live reconciliations, including Schedule AI column (d) tested line by line against the full-year return
- Verified against an independent Python model of the 2026 tax across 20 scenarios and 3,440 cell-by-cell assertions, to the dollar
- Excel 2016+ and Google Sheets · 7-page print pack in US Letter and A4, colour and ink saver · Google Sheets set-up PDF included
Preview every page
Click any page to zoom.
What's inside
Questions
Which country and which tax year is this for?
United States federal tax, tax year 2026, and nothing else. It does not compute state or city income tax, it is not for 2025 or 2027, and it is not for any other country. That is on the workbook title, the first line of the Start here sheet, a red banner at the top of every sheet and against every one of the thirty constants on the Sources sheet. The State dropdown even includes "Other / outside the United States", and choosing it puts a line on the sheet telling you plainly that this file is not for you.
Why is there no cell where I type my tax rate?
Because that cell is the reason every other template on the market is worth $12. "Set aside 30%" is a guess dressed up as a spreadsheet: it does not know that your Social Security tax stops at $184,500 of net earnings, that the 0.9% Additional Medicare Tax starts at $200,000, that the section 199A deduction takes a fifth off your taxable income and then phases out, or that your bracket is not your marginal rate. This workbook computes all of it from the published forms. The rate it gives you is an output, not an input.
What is the annualised method, and why does it matter?
Four equal quarterly payments assume you earn evenly through the year. If you earned almost nothing until July and then landed a large project, the flat method makes you pay the IRS in April out of income you had not yet received — and if you do not, you are charged an underpayment penalty for a quarter in which you genuinely had nothing. Form 2210 Schedule AI lets you charge each instalment against what you had actually earned by that date. On the sample data in the file, the flat method wants $10,013 on 15 April and Schedule AI wants $509. It is an IRS form, not a loophole: you attach Form 2210 to your return with box C ticked in Part II. This workbook computes every line of it, which as far as we know no other spreadsheet does.
How do I know the numbers are right?
Three ways. First, every constant is on the Sources sheet with the IRS or SSA document it was read from, the URL and the day it was verified — check any of them yourself. Second, the workbook was built against an independent Python model of the 2026 tax written from the primary sources, and the build refuses to produce a file unless 20 scenarios agree cell by cell, to the dollar: 3,440 assertions in all. Third, the Checks sheet in your copy runs 29 reconciliations live, the strongest of which test Schedule AI column (d) against the full-year return line by line. If you change an input and something stops agreeing, you will see it.
What does it deliberately not do?
Ten things, listed in full on the Start here sheet. The big ones: it computes tax BEFORE credits, so if you have children or qualify for the premium tax credit your real bill is lower. No state or city tax. Ordinary rates only — no preferential rate on capital gains or qualified dividends. No Net Investment Income Tax and no AMT. Itemised deductions are taken as one number without applying the SALT cap, the new 0.5%-of-AGI charitable floor or the section 68 reduction. One trade or business, no aggregation, no loss carryforward, no K-1s. And it works out what to pay so there is no penalty; it does not compute the penalty itself.
Is it tax advice?
No, and it says so on four separate sheets. It reproduces the arithmetic printed on published IRS forms. It does not decide whether your business is a specified service trade or business, whether you materially participate, or whether a particular expense is ordinary and necessary. What it will do is make the conversation with a preparer much shorter, because you will arrive with the working already done — and the print pack has a page listing the four questions actually worth their fee.
You mention a disagreement with another model. What is that about?
Section 199A(i), the new $400 minimum QBI deduction, was added by the OBBBA in July 2025 and applies for the first time in 2026. There are no regulations on it, no IRS guidance and no case law, and the 2026 Form 8995-A had not been published when this engine was built. For one specific taxpayer — a specified service business with taxable income above the top of the phase-out range — the statute can be read two ways. This engine gives no deduction; PolicyEngine US gives $400, worth about $140 of tax. We take the reading that makes you pay more, we write it up on the Sources sheet with the statutory argument on both sides, and we tell you to ask your preparer. Six such places are documented; that is the one with money on it.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive, open it and choose File → Save as Google Sheets. Every formula is a classic one — ROUND, IF, INDEX, MATCH, COUNTIF, MIN, MAX, SUM, AND, OR, NOT, TEXT, ABS, ISNUMBER, IFERROR, ROW — with no macros, no XLOOKUP, no FILTER, no dynamic arrays and no external links, so the tax comes out to the same dollar in Excel 2016, Excel 365, Excel for Mac and Sheets. The file is recalculated in LibreOffice as part of every build and must report zero formula errors, both as shipped and with every input cleared. A set-up PDF walks you through it, sheet by sheet.
The four periods look wrong — aren't quarters three months each?
No, and this catches almost everyone. Form 1040-ES divides the year into 1 January–31 March, 1 April–31 May, 1 June–31 August and 1 September–31 December. The second period is two months, the fourth is four, and the payment for the last one is not due until 15 January of the following year. The whole workbook is built on those four periods, which is what makes the annualised method work properly.
What about the standard mileage rate?
2026 is a two-rate year: 72.5 cents per business mile driven before 1 July (IRS Notice 2026-10) and 76 cents from 1 July onward (IRS Announcement 2026-11 raised the rate mid-year). The Schedule C Summary sheet carries both in two ordinary input cells, pre-filled with those verified figures and dated on the Sources sheet, with the miles split to match — and a live check on the Checks sheet refuses miles in a half-year whose rate cell is empty. The cells stay inputs on purpose: when the IRS sets the 2027 rate next December, you overtype two cells and nothing else moves.
Is the sample data really deletable?
Yes. It is a fictional single freelance consultant in Colorado: $200,500 of gross receipts, $28,500 of expenses across the real Schedule C categories, $172,000 of net profit — and a deliberately brutal shape, with $150,000 of it arriving between June and August, so the annualised method visibly does something the moment you open the file. Every sample value sits in a yellow input cell. Clear Start here C16:C25, the yellow blocks on Income & Expenses by Period and Schedule C Summary, and the Payment Calendar, and the file is yours. The Start here sheet lists the exact ranges.
I have a W-2 job as well as freelance income. Does that work?
Yes, and it is handled properly, which is unusual. Your own W-2 Social Security wages eat into your $184,500 wage base on Schedule SE line 8d; your spouse's do not, because Schedule SE is a per-person form and a joint return carries one for each of you. Both sets of wages count towards the Additional Medicare Tax threshold, because that one is a household test. Federal income tax withheld from either job comes off the safe harbour pound for pound — and raising withholding is usually easier than making quarterly payments, because withheld tax is treated as paid evenly across the year.
Reviews
No reviews yet — this product is new. Every review here comes from a verified purchase.
Personal-use license for one household. No resale or redistribution. Delivered as a ZIP download immediately after payment. No physical item will be shipped.
US Self-Employed Tax Engine — 1099 & Quarterly Estimated Taxes · Tax Year 2026
United States federal, tax year 2026 only. Self-employment tax, income tax, the section 199A deduction and the exact quarterly payment that keeps you penalty-free — with Form 2210 Schedule AI worked in full, which is the sheet that pays for the file if your year is uneven.
Pay with PayPal or any card
- United States only · tax year 2026
- Download link on the confirmation page and by email
- What you need: Excel 2016+ · Google Sheets · PDF (US Letter + A4) · United States federal, tax year 2026
- Full refund within 24 hours — just message us, no reason needed
- 7 pages
- 12 sheets · 1,008 formulas
- Formats: .xlsx (Excel 2016+, Google Sheets) + PDF guide
- ZIP: 521 KB
Ask within 24 hours of paying and we refund the whole amount — no form, no reason needed. Up to 30 days we still refund, minus the 4% payment processing fee. Files that will not open are always refunded in full, with no time limit.

