Privacy

Every app that Google approves must go through a strict security & privacy approval process. Google’s Cloud Platform/API Trust & Safety Team has approved Tax Functions for following “scopes”.

1. See, edit, create, and delete your spreadsheets in Google Drive – Scope: https://www.googleapis.com/auth/spreadsheets. This permission allows Tax Functions to execute the custom tax functions in your Sheet. User data is only gathered as needed for the basic funcitonality of the functions.

2. Connect to an external service – Scope: https://www.googleapis.com/auth/script.external_request. This permission is necessary for Tax Functions to show information about the functions in a sidebar and dialogue box.

Tax Functions uses https://www.googleapis.com/auth/spreadsheets to take numbers entered into a Sheet by a user and return values calculated with custom functions. The functions calculate tax amounts. The user inputs the function specific parameters such as "=tax_ord(100000, "MFJ", 2022)". The function takes in (ordinary income, filing status, year) and returns the amount of ordinary income tax. The result is returned to the in the sheet cell containing the function call. The app usage is similar to Sheets cell formulas such as "=sum(1,2)". My app extends the in cell formulas available to users in Sheets.

Tax Functions uses https://www.googleapis.com/auth/script.container.ui to render html in in a sidebar and modal that communicate information about the app. Users can launch the modal from the sidebar to view detailed information about the custom functions. The html information provides definitions for all inputs required by the user to correctly use the functions to calculate taxes. The sidebar will also provide a button that populates a sample Sheet that demonstrates usage of the custom functions.

Custom functions provided by my app are:

=tax_ord(ordinary income, filing status, year) //returns ordinary income tax

=tax_gains(gains, taxable income, filing status, year) //returns capital gains tax

=tax_se(self-employment income, wages, year) //returns self-employment tax