/google_sheets_tax_functions

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

Primary LanguageJavaScriptMIT LicenseMIT

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. Screen Shot 2021-03-03 at 9 39 20 PM
  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. image
  2. Click the Run button.