Small Business
Small Business Quarterly Estimated Tax Tracker
Know what to set aside and pay the IRS each quarter, calculated straight from your income and expense log.
- Delivery
- Instant download
- Purchase
- One-time payment
- Format
- Google Sheets
- Excel
- Updated
- August 2026
Net income YTD
$48,140
Avg. quarterly set-aside
$3,611
- Q1$12,260 → $3,678
- Q2$12,320 → $3,696
- Q3$12,560 → $3,768
- Q4$11,000 → $3,300
Sample data preview of the Small Business Quarterly Estimated Tax Tracker spreadsheet, shown for illustration only.
What this spreadsheet does
Quarterly estimated taxes are easy to underpay or forget entirely when income and expenses live in a dozen different places, and the penalty for underpaying is avoidable with a running calculation.
What you can do with it
- See what to set aside for taxes as income comes in
- Know exactly what's due by each quarterly deadline
- Test how a tax rate change affects the quarterly set-aside
What's included
Sheet tabs
- Instructions
- Quarterly Summary
- Income & Expense Log
- Tax Rate Assumptions
Features
- Income and expense log with automatic quarter assignment
- Configurable self-employment, federal and state tax rates
- Automatic net income, estimated tax owed and suggested set-aside per quarter
- Standard IRS quarterly due dates built in
How it works
- 1Log every income and expense entry with its date and type
- 2Set your tax rates on the Tax Rate Assumptions tab
- 3Check the Quarterly Summary tab for what to set aside and pay by each due date
Who it's for
Small business owners who pay quarterly estimated taxes.
This spreadsheet estimates quarterly set-asides and does not replace professional tax advice.
Frequently asked questions
Does this file the taxes for me?
No, this calculates what to set aside and pay based on your income log. You still file and pay through the IRS directly.
Can I adjust the tax rates?
Yes, self-employment, federal and state rates are all editable inputs on the Tax Rate Assumptions tab.
Are the due dates exact?
The due dates shown are the standard IRS quarterly estimated tax deadlines. Confirm exact dates on the IRS calendar, since they can shift for weekends and holidays.
You might also need
Small Business Cash Flow Tracker
See money in, money out and projected balance by month.
- Google Sheets
- Excel
Break-Even Calculator
Find the sales volume needed to cover fixed and variable costs.
- Google Sheets
- Excel
Pricing & Profit Margin Calculator
Set a price from cost and target margin, or check margin on an existing price.
- Google Sheets
- Excel
Inventory Tracker
Track stock levels, reorder points and inventory value.
- Google Sheets
- Excel