FreshBooks expense categories in a live spreadsheet
Add the Expense categories table to a sheet as a data source named expense_categories and its 7 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
=list.expense_categories(name) Every name, once. Spills the distinct name values down the column: the row labels for the formula above.
=data.expense_categories.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 |
| Parent ID | parent_id | Text |
| Cost of goods sold | cost_of_goods_sold | Yes / no |
| Editable | editable | Yes / no |
| Archived | archived | Yes / no |
| Updated at | updated_at | Date and time |
Other expenses tables
Your expense categories, live
Invoices, payments, expenses and time entries become tables that formulas, pivot tables and charts read directly. Your numbers stay current without exporting.