FreshBooks taxes in a live spreadsheet
Add the Taxes table to a sheet as a data source named taxes and its 6 columns become names your formulas, pivot tables and charts use. Sheets reads it from your FreshBooks business each time the sheet opens or refreshes.
Formulas on this table
=data.taxes.sum(rate) Total rate %. Adds up the Rate % column over every row of Taxes.
=data.taxes.sum(rate, name, A2) Rate % per name. With a name in A2, the total for that one. Fill it down next to a list of them.
=list.taxes(name) Every name, once. Spills the distinct name values down the column: the row labels for the formula above.
=data.taxes.count(id, name, "<>") Rows with a name. Counts the rows whose Name is not empty.
Columns
| Column | In formulas | Type |
|---|---|---|
| ID | id | Text |
| Name | name | Text |
| Rate % | rate | Number |
| Tax number | tax_number | Text |
| Compound | compound | Yes / no |
| Updated at | updated_at | Date and time |
Other lists tables
Your taxes, live
Invoices, payments, expenses and time entries become tables that formulas, pivot tables and charts read directly. Your numbers stay current without exporting.