Business Tax Tracker Spreadsheet Template for Excel & Google Sheets
A year-round estimated-tax tracker for self-employed and small-business operators. Log income by source, deductible expenses by category, and the four quarterly payments. The workbook computes federal, self-employment, and state liability, effective rate, balance due, and a safe-harbor underpayment check. One spreadsheet, dual compatible with Microsoft Excel and Google Sheets.
One-time purchase
Business Tax Tracker Spreadsheet
Everything in This Tax Tracker
Your Tax Picture at a Glance
Open the dashboard and see where you stand. Net taxable, projected total tax, payments to date, and balance due across the top - effective rate, safe-harbor target, and total deductible across the bottom. A status banner flags whether payments to date meet the safe-harbor target.
- 7 KPI cards covering taxable, liability, paid, and balance
- Safe-harbor status banner
- Quarterly Payments and Deductible by Category charts
Track Every Source by Month
Three sample income sources - consulting, recurring retainers, and product sales - across all 12 months, with row totals and a grand total. Add or rename sources to match your business; the dashboard, Tax Summary, and effective rate read from the totals.
- Three sources by default, add as needed
- 12 months of monthly entries per source
- Row totals and grand total auto-calculated
Deductible Expenses, Per-Category %
Eight default categories - home office, mileage, equipment, software, professional fees, travel, meals, other - each with a deductibility percentage you can override. Deductible amount equals raw amount times percentage, so meals at 50% works out of the box.
- Eight default deductible categories
- Editable deductibility percentage per category
- Raw and deductible totals on every row
All Four Quarters, Federal and State
Each quarter has a due date and two inputs - federal and state payment. Row totals show what you sent that quarter; the column total feeds the Paid KPI on the dashboard. Q1 and Q2 are filled with sample data; Q3 and Q4 are blank, ready for entry.
- Q1 through Q4 with official due dates
- Federal and state inputs per quarter
- Year-to-date payments roll into the dashboard
Step-by-Step Calculation
Walk down the page from gross income to balance due. Gross income, total deductions, net taxable - then federal, self-employment, and state liability applied at the rates you set - with total liability, payments to date, and balance due on bold rows.
- Gross to net taxable to liability
- Federal + SE + state shown on separate lines
- Total liability, paid, and balance due footer
Quarterly Pace and Top Deductions
Two charts on the dashboard tell the story. Quarterly Payments shows what you sent each quarter as a column chart. Deductible by Category ranks the eight deduction categories so you can spot what is driving your deductible total.
- Quarterly Payments column chart
- Deductible by Category column chart
- Both update from the source sheets
Rates and Safe-Harbor, in One Place
Business name, tax year, and currency at the top. Then editable rates - federal, self-employment, and state - applied to net taxable. Safe-harbor inputs include prior-year tax and the safe-harbor percentage (110% by default) so the dashboard can show whether year-to-date payments are on pace.
- Business name, tax year, currency
- Federal, SE, and state rates - all editable
- Prior-year tax and safe-harbor percentage
Up and Running for the Year
On Settings, enter your business name, tax year, rates, and prior-year tax. Log income each month on Income, log deductible expenses on Deductions, and record each quarterly payment on the Quarterly Payments sheet. The Tax Summary, Dashboard, and charts update automatically.
- Settings, then monthly Income and Deductions
- Record each quarterly payment as you send it
- Summary and Dashboard build themselves
Customizable & Flexible
Adapt the template to your situation. Add income sources, rename deduction categories, or change tax rates to match your jurisdiction - every figure updates. Planning tool only; confirm specifics with a qualified professional. Works identically in Excel and Google Sheets.
- Add sources and rename deduction categories
- Tune federal, SE, state rates and safe-harbor %
- Excel and Google Sheets compatible
Ready to take control of your finances?
Set Up in 15 Minutes
How the Tax Tracker Works
Open in Excel or Google Sheets
Get instant access after purchase. Open in Microsoft Excel directly, or import into Google Sheets - no software to install, no add-ons.
Set Rates and Safe-Harbor
On Settings, enter your business name, tax year, federal / SE / state rates, prior-year tax, and the safe-harbor percentage. The default placeholders are starting points - tune them to your jurisdiction.
Log Income and Deductions
Record income each month by source on Income, and deductible expenses by category on Deductions. Net taxable, projected liability, and effective rate update automatically.
Record Quarterly Payments
As each estimated payment goes out, log federal and state amounts on the Quarterly Payments sheet. The dashboard shows balance due and whether you are on pace against safe harbor.
Customer Reviews
Used by Self-Employed Operators Worldwide
"If I get half as good at handling my finances as you are at customer service, this'll be the best $26 I've spent lately."
"Great tool! Simplifies financial planning without the hassle of complex spreadsheets."
"I recently purchased your super convenient spreadsheet, it really helps me!"
"They're great and super intuitive. Thank you!"
Built for Results
Why This Tax Tracker Works
Year-Round Estimated-Tax Tracking
Log income, deductions, and quarterly payments as you go - the workbook computes federal, SE, state liability and a balance due all year long.
No Formulas to Write
Enter values in highlighted input cells. Tax amounts, effective rate, safe-harbor target, and charts are pre-built and update automatically.
Excel and Google Sheets
Works identically in Microsoft Excel and Google Sheets. No macros, no add-ons, no proprietary functions.
Free Lifetime Updates
All future improvements to the tax tracker included at no extra cost.
Your Financial Data Stays Private
Runs entirely in your spreadsheet. Income, deductions, and payment amounts stay in your file - we never see or store them.
One-Time Purchase
Pay once, use forever. No subscriptions, no monthly fees, no recurring charges.
Got Questions?
Frequently Asked Questions
Is this template free to use?
This template is not free, but it is available for a one-time purchase. This purchase gives you lifetime access to the template and all future updates.
What do you mean by lifetime access?
Lifetime access means that you will have access to this template for as long as you need it. You will not be required to pay any additional fees for continued access to the template or any future updates.
Do I need to sign up to use this template?
You don't need to create an account with us. The template works in Google Sheets, so you'll need a Google account. If you don't have one, you can create one for free at google.com. After you purchase the template, copy it to your Google Drive, and start using.
What are the benefits of using this template?
This template offers a range of benefits, including: Easy-to-use interface, Customizable to suit your needs, Secure and private, Regular updates and improvements, One-time purchase for lifetime access.
Can I get future updates?
Yes, you will receive all future updates to this template at no additional cost. This ensures that you always have access to the latest features and improvements.
Do you offer any discounts?
At this time, we do not offer any discounts on this template. However, the template is available for a one-time purchase, which provides lifetime access and free updates.
Do you have any access to my financial data?
No, we do not have access to your financial data when you use this template. The template is designed to be used in your own Google Sheets account, ensuring that your financial information remains private and secure.
Is this template financial advice?
Our templates are not financial advice. They are tools designed to help you manage your personal finances more effectively. If you need personalized financial advice, consider consulting with a financial advisor or accountant.
Can I make my own changes and customize this template?
Yes, you can make your own changes and customize this template to suit your needs. The template is designed to be flexible and adaptable, allowing you to add or remove sections, change formulas, and adjust formatting as needed.
Do you offer technical support?
This is a self-service product, and we do not offer technical support. However, if you encounter any issues or have any questions about the template, please contact our team for assistance. Because everyone's financial situation is unique, consider consulting with a financial advisor or accountant if you need personalized financial advice.
Do you offer refunds?
All sales are final. Because these are digital products delivered instantly, we do not offer refunds.
Can't find the answer you're looking for? Contact our team
Highlights:
Stay on Top of Estimated Taxes
Get the Business Tax Tracker and stop guessing on quarterly payments. Income, deductions, liability, and safe-harbor status in one workbook.