Google Sheets Tax Functions

Functions for Google Sheets to calculate income tax and short/long term capital gains tax.

US Federal tax only.

Supports 2020 through 2024 tax years, all filing statuses.

Usage

Calculate federal income tax for 2023 on $50,000 of income if you are Married Filing Jointly:

=INCOMETAX(50000, "MFJ", 2023)

Calculate federal short term capital gains tax for 2023 on $40,000 of capital gains if you had $50,000 of regular income and are Married Filing Jointly:

=STCGTAX(50000, 40000, "MFJ", 2023)

Calculate federal long term capital gains for 2023 tax on $40,000 of capital gains if you had $50,000 of regular income and are Married Filing Jointly:

=LTCGTAX(50000, 40000, "MFJ", 2023)

Installation

1. Make a Google sheet.
2. Choose Extensions: Apps Script from the menu.
3. Remove the contents of the file (the function called myFunction).
4. Paste the contents of tax_functions.js into the file.
5. Click the 'Save project" button in the toolbar at the top.
6. Now they're available for use in the sheet.

Testing

To run tests:

1. In the Script Editor, select the TEST_ALL function to run.
2. Click the Run button.