Custom functions in your spreadsheet to calculate taxes.
Listing updated:December 14, 2023
Works with:
571
Overview
Tax Functions will enable you to calculate Federal Income Tax, Capital Gains Tax and Self-employment Income Tax directly in a Sheet. Available for years 2020 - 2024 and all filing statuses. Launch the extension from the menu bar and begin by entering a tax function in a Sheet cell.  Auto complete will be available to provide assistance.  

Launching the extension will open a sidebar.  A sample sheet is available from the sidebar that demonstrates the usage of Tax Functions. More info about the functions and their parameters are also from the sidebar.  Menu Bar / Extensions / Tax Functions/ Launch
 
Additional information
PricingFree of charge
Developer
Privacy policy
Terms of service
Tax Functions will ask for the permissions shown below. Learn more
Tax Functions will need access to your Google account
This will allow Tax Functions to :
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Lee White
January 3, 2024
Mixed bag. - Description says it will only require permissions to access your name and email but installation requires granting access to all Sheets documents you own. Then you need to enable the app in sheets, and then again enable it in each document you want to use it in. - Does not provide insight into the formulas used so you are unable to verify the calculations are correct. - Does not appear to account for the standard deduction. This is reasonable but it should be stated in the documentation. - Would be more useful for retirement planning purposes if you had a reverse tax function to allow you to say "I want $100,000 in after-tax money from my traditional IRA. How big of a withdrawal allows this?" or stated another way, "How much do I have to earn to take home $100,000?"
Is this review helpful?
Yes
No
Profile Picture
James Fulford
June 8, 2023
This was helpful for doing a rough self-employment estimated tax payment calculation, instead of hamfisting in an arbitrary % rate.
Is this review helpful?
Yes
No
Profile Picture
Ken Hui
February 10, 2023
Doesn't work. Formula doesn't show up after typing "=tax.." in a cell.
Is this review helpful?
Yes
No
1-3 of 3
Search
Clear search
Close search
Google apps
Main menu