Freelancer Quarterly Estimated Tax 2027 Spreadsheet, Self Employment Tax & Tax Set Aside Tracker | Excel Google Sheets
Item highlights
Seller's description
Know what to set aside from each freelance payment in 2027, and what to send the IRS each quarter. This workbook estimates self-employment tax the way Schedule SE starts (92.35% of net profit, then 12.4% Social Security and 2.9% Medicare), adds a rough income-tax figure at the rate you type, then applies a simplified safe-harbor check against last year's tax. Works in Google Sheets and Excel.
WHAT'S INCLUDED
1. Workbook (Google Sheets + Excel), 8 tabs: Start Here, Dashboard, Setup, Income (300), Expenses (300), Set-Aside (200), Quarterly, and Sources.
- Dashboard: net profit, SE tax pieces, income-tax estimate, required annual payment, required per quarter, payments already sent, money moved to tax savings, and a suggested set-aside percent of each payment.
- Quarterly due dates: April 15, June 15 and September 15, 2027. The fourth date is shown as January 18, 2028 because January 15, 2028 is a Saturday and January 17, 2028 is Martin Luther King Jr. Day (26 U.S.C. 6654 and 7503). Confirm on Form 1040-ES when published.
- Social Security wage base defaults to the IRS's published 2026 figure ($184,500) in an editable cell.
2. Start Here PDF with your Google copy link.
WHY IT'S DIFFERENT
- SE tax is split into Social Security, Medicare and Additional Medicare instead of a single mystery percentage.
- Safe harbor vs 90% of this year, using last year's AGI to pick 100% or 110%.
- A set-aside log compared with what you still need to send.
- Sources tab with the IRS pages the rules come from.
- Excel + Google Sheets, tested 23/23 over 3 rounds.
HOW TO GET IT
1. Download the zip from Etsy > Purchases.
2. Open Tax-START-HERE.pdf and choose "Make a copy", or open the .xlsx in Excel.
3. Jordan Hale sample data is made up. Clear the yellow cells and add your first payment.
GOOD TO KNOW, PLEASE READ
- Not tax advice and not a prepared return. It does not handle state tax, QBI, credits, the annualized-income method or farming/fishing exceptions.
- Confirm the 2027 Social Security wage base and Form 1040-ES dates on irs.gov.
- Digital download; nothing physical ships. Message me if something isn't working.
- For your own use. Please don't resell or share the files or links.
HOW THIS WAS MADE
I designed this workbook with help from AI tools, which assisted with the formulas, layout and sample data. I chose the features after comparing public RankHero samples for self-employed and quarterly tax trackers (small shops already appear on page 1 for those phrases). I checked IRS pages on Nov 6, 2026 and tested the math against an independent model.
If something goes wrong with an order, we've got your back for all eligible purchases. View program terms
Price:$13.00
You can only make an offer when buying a single item
Delivery
Instant download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Seller's description
Specifications
Know what to set aside from each freelance payment in 2027, and what to send the IRS each quarter. This workbook estimates self-employment tax the way Schedule SE starts (92.35% of net profit, then 12.4% Social Security and 2.9% Medicare), adds a rough income-tax figure at the rate you type, then applies a simplified safe-harbor check against last year's tax. Works in Google Sheets and Excel.
WHAT'S INCLUDED
1. Workbook (Google Sheets + Excel), 8 tabs: Start Here, Dashboard, Setup, Income (300), Expenses (300), Set-Aside (200), Quarterly, and Sources.
- Dashboard: net profit, SE tax pieces, income-tax estimate, required annual payment, required per quarter, payments already sent, money moved to tax savings, and a suggested set-aside percent of each payment.
- Quarterly due dates: April 15, June 15 and September 15, 2027. The fourth date is shown as January 18, 2028 because January 15, 2028 is a Saturday and January 17, 2028 is Martin Luther King Jr. Day (26 U.S.C. 6654 and 7503). Confirm on Form 1040-ES when published.
- Social Security wage base defaults to the IRS's published 2026 figure ($184,500) in an editable cell.
2. Start Here PDF with your Google copy link.
WHY IT'S DIFFERENT
- SE tax is split into Social Security, Medicare and Additional Medicare instead of a single mystery percentage.
- Safe harbor vs 90% of this year, using last year's AGI to pick 100% or 110%.
- A set-aside log compared with what you still need to send.
- Sources tab with the IRS pages the rules come from.
- Excel + Google Sheets, tested 23/23 over 3 rounds.
HOW TO GET IT
1. Download the zip from Etsy > Purchases.
2. Open Tax-START-HERE.pdf and choose "Make a copy", or open the .xlsx in Excel.
3. Jordan Hale sample data is made up. Clear the yellow cells and add your first payment.
GOOD TO KNOW, PLEASE READ
- Not tax advice and not a prepared return. It does not handle state tax, QBI, credits, the annualized-income method or farming/fishing exceptions.
- Confirm the 2027 Social Security wage base and Form 1040-ES dates on irs.gov.
- Digital download; nothing physical ships. Message me if something isn't working.
- For your own use. Please don't resell or share the files or links.
HOW THIS WAS MADE
I designed this workbook with help from AI tools, which assisted with the formulas, layout and sample data. I chose the features after comparing public RankHero samples for self-employed and quarterly tax trackers (small shops already appear on page 1 for those phrases). I checked IRS pages on Nov 6, 2026 and tested the math against an independent model.
-
Designed by
-
Item typeDigital download
-
Digital file type(s)1 ZIP
If something goes wrong with an order, we've got your back on all eligible purchases. View program terms
Meet your seller
More from this shop
-
Digital download
Pet Sitting Spreadsheet, Dog Walking Booking Tracker & Client Pet Care Log, Key Log, Holiday Rates | Excel Google Sheets
$19.00
-
Digital download
Grocery Budget Spreadsheet, Meal Plan Cost Tracker & Shopping List, Recipe Cost Per Serving | Excel Google Sheets
$8.00
-
Digital download
Cleaning Business Spreadsheet, House Cleaning Pricing Calculator, Job & Client Tracker, Crew Hours, Invoice Log | Excel Google Sheets
$22.00
-
Digital download
Home Daycare Spreadsheet, Tuition & Attendance Tracker, Parent Year End Payment Totals, Enrollment and Forms Log | Excel Google Sheets
$22.00
-
Digital download
Medical Expense Tracker 2027, HSA & FSA Spreadsheet, Receipt Log, Contribution Limit, Use It Or Lose It, Family Bills, Google Sheets Excel
$12.00
-
Digital download
Scholarship Tracker & College Application Tracker, Deadline Countdown, Award Totals, Net Price, Senior Year | Google Sheets Excel Template
$9.00
Shoppers with similar taste loved these
-
Digital download
Web Designer Contract Template: Client Questionnaire & Launch Checklist (Digital Download)
$13.98
-
Digital download
Web Designer Services Agreement, Website Design Contract, Freelance Web Designer Agreement, Invoice Template, Business Card Template
Sale Price $4.69
Original Price $9.39
-
Digital download
Web Design Client Questionnaire Template | INSTANT DOWNLOAD | Client Intake Form | Web Design Templates | Business Forms | Website Services
Sale Price $2.46
Original Price $7.01
-
Digital download
Notion Client Portal Template | Freelancer Project Tracker (Digital Download)
$12.59
-
Digital download
Notion Template: Service Business Dashboard for Teams
$39.89
-
Digital download
Web Design Contract, Website Design Contract, Freelance Contract, Web Designer Services Agreement Templates, Questionnaire Proposal, CANVA
$11.00
-
Digital download
Social Media Audit Template, Social Analytics Canva Editable, Social Manager, Freelancer and Virtual Assistant Business Template and Guides
Sale Price $1.63
Original Price $3.26
-
Digital download
Virtual Assistant Contract Template Bundle: Legal Agreement, Canva Editable (Digital Download)
$10.56
-
Digital download
Notion Client Portal Template, Freelancer Project Management, Creative Client Dashboard
Sale Price $9.00
Original Price $18.00
-
Digital download
100 Feminine Business Stock Photos: Instagram & Blog Branding (PNG)
$14.08
-
Digital download
Virtual Assistant Template Bundle: Social Media, Legal Docs, Welcome Guide (Canva Editable)
$24.64
-
Digital download
Virtual Assistant Dashboard | Client CRM Google Sheets | Task & Project Tracker | Invoice Tracker | VA Workflow Template | Digital Download
Sale Price $6.98
Original Price $13.97