Estimated Quarterly Tax Spreadsheet

✓ Automatically keep your tax finances organized
✓ Effortless tax prep with everything in one place
✓ See real-time estimates of state and federal taxes owed
✓ Know when your next tax payment is due
✓ Updated with 2020 mileage and tax rates

A spreadsheet template for people who need to track and estimate quarterly tax payments.

The Estimated Quarterly Tax Spreadsheet is perfect for freelancers, small business owners, consultants, and anyone who makes money without having state and federal taxes automatically withheld at payment.

Get this free template with the Tiller Labs Add-on for Google Sheets. This template works best with spreadsheets powered by Tiller Money Feeds.


Tax prep that takes minutes, not hours

Tiller Money automatically collects your personal and small business bank data throughout the year and keeps it organized in easy-to-share spreadsheets.

Effortlessly categorize business transactions

See business transactions from your credit cards, bank accounts, loans, and other accounts together in one dashboard.

Categorize and tag business transactions in minutes, or use AutoCat for Google Sheets to automatically categorize transactions based on your custom rules.

Estimate what you’ll owe in real-time

See real-time estimations of what you owe for the quarter. Use manual adjustments to project liability for the year ahead.

See net profit & estimated tax detail by quarter

The Net Profit & Estimated Tax Detail by Quarter report offers a view of your quarterly earnings, spending, net profit, and estimated taxes. It also includes helpful reminders of reporting period date ranges and payment due dates.

Easily track income & expense transaction data

The Income & Expense from Transactions report provides a summary of business income and expenses based on categorized data in the Transactions sheet.

Profit & Tax Payments Summary

The Profit and Tax Payments Summary provides a quick view of quarterly net profit and estimated tax payments. The estimated tax payments are broken down by cumulative quarterly total, estimated federal and state payments, and the tax payments you’ve already made.

Business Income/Expense Category Detail by Quarter

See a breakdown of your spending and earnings organized by type (income vs expense), group, and categories.

Easily track itemized deductions

The Estimated Quarterly Tax sheet defaults to the standard deduction based on your filing status. However, you can itemize your deductions by following these rules. Consult with your tax advisor on whether you should use the standard deduction or an itemized deduction.

  • See quick expense totals and spending for all business expense categories.
  • Track and estimate home office deductions, including rent or mortgage interest, utilities, and insurance on your office.
  • Track business mileage based on the IRS’s standard rate for the tax year.

Easily adjust income & expenses

Easily make manual adjustments to spending and earnings for accuracy

Share your tax sheet with a partner

Because the Estimated Quarterly Tax template is based in Google Sheets, it’s easy to share access with your accountant, tax preparer, and business partners.


Note: this tool is not recommended for those with complex tax situations, those who may be subject to Alternative Minimum Tax, multi-member LLCs, partnerships, or LLCs taxed as an S-Corp. Review the Assumptions and Expectations for more information about how to use this tool.

  • How do I get this template?

    This template is installed via the free Tiller Labs Add-on for Google Sheets.  Simply install and run the add-on. You'll then be presented with a sidebar that includes this template (along with many others). 

  • What is Tiller Labs?

    Tiller Labs builds templates, tools, and workflows for spreadsheets powered by Tiller Money Feeds. About the Tiller Labs Add-on →

  • How do I get help with a Tiller Labs template?

    Need help with a Tiller Labs project, or want to know more about how it works? Visit the Tiller Labs category of the Tiller Money Community, where you can get help from the Tiller team and spreadsheet enthusiasts around the world.

  • Do I need a Tiller Money subscription to use this?

    This template is designed to work in spreadsheets powered by the Tiller Money Feeds Add-on for Google Sheets. 

    Tiller Money Feeds automatically imports your daily spending, account balances, and transactions directly into Google Sheets. See everything in one place, with one login, and manage your finances in your spreadsheets 10x faster.

    You can try Tiller completely free for 30 days. Easily cancel anytime.

    If you want to get right to the template, install the free the Tiller Labs Add-on into any Google spreadsheet and open the template from the Google Sheets sidebar.

  • Works with AutoCat

    This template is compatible with AutoCat for Google Sheets, which can automatically categorize transactions for you. Learn about AutoCat →

     

Works great with these templates:

You may also like…

Start Your Free 30-Day Trial

Tiller Money is completely free for 30 days
After 30 days, Tiller is $59/year
Just $4.92/month

✓ Completely free 30-day trial ✓ Cancel anytime ✓ Keep your imported data