Stop guessing what you owe in April, June, September, January. Quarterly estimated tax calculator for Airbnb and STR hosts. Avoid the IRS underpayment penalty. Editable Excel. You got hit with a $400 underpayment penalty last April. The IRS doesn’t care that your STR income was lumpy — they care that you didn’t pay enough as you went. The fix is the quarterly schedule: April 15, June 15, September 15, January 15. Pay roughly 25% of your projected annual tax each quarter, and the penalty goes away. The hard part is “roughly.” This workbook does the math. WHAT’S INCLUDED 📋 Annual Income Forecast · Project STR income from current YTD + seasonal pattern · Account for spouse W-2 withholding (joint filers) · Other 1099 / side-gig income line · Auto-recommended Safe Harbor (110% of last year’s tax) 📋 Quarterly Schedule (4 quarters × line items) · Q1 due April 15, Q2 due June 15, Q3 due September 15, Q4 due January 15 · Income tax + SE tax + state estimate per quarter · Already-paid column (deduct what you’ve sent in) · “What to send” cell — bottom-line dollar amount per quarter 📋 SE Tax Worksheet · Schedule E filers: typically $0 (rental income is not SE) · Schedule C filers: 15.3% × 92.35% × net SE earnings · Auto-routes based on your filing classification 📋 Safe-Harbor Check · 100% prior-year (under $150K AGI) or 110% (over $150K) · 90% current-year as alternative · Whichever is lower — that’s your safe harbor target 📋 IRS Form 1040-ES Quick-Reference · Voucher line numbers, payment URL · IRS Direct Pay link (no fees) · State estimated-tax pointers
Related
- Self-Employment Tax Calculator
- Home Office Deduction Allocator
- TOT Filing Calendar
- Schedule C Tax Prep Workbook (Active STR)
- Section 179 Planner
Get the workbook
Format: Excel .xlsx + how-to PDF. Excel 2016+, Excel 365, Google Sheets compatible. Instant download after checkout. 14-day refund, no questions. Lifetime updates within v1.