As tabelas do FreshBooks no Sheets

O Sheets lê sua empresa no FreshBooks em 16 tabelas. Adicione uma delas a uma planilha como fonte de dados e suas colunas viram nomes que suas fórmulas usam.

Sales

InvoicesID, Invoice no., PO number, Date, Due date…Invoice linesDocument ID, Invoice no., Date, Client, Client ID…EstimatesID, Estimate no., PO number, Date, Client…Credit notesID, Credit note no., Date, Client, Client ID…PaymentsID, Date, Amount, Currency, Method…Other incomeID, Date, Amount, Currency, Category…

Expenses

ExpensesID, Date, Vendor, Category, Category ID…BillsID, Bill no., Date, Due date, Vendor…Bill paymentsID, Date, Amount, Currency, Method…VendorsID, Name, First name, Last name, E-mail…Expense categoriesID, Name, Parent ID, Cost of goods sold, Editable…

Time

ProjectsID, Title, Description, Client, Client ID…Time entriesID, Started at, Date, Hours, Duration (seconds)…

Lists

ClientsID, Name, Organisation, First name, Last name…ItemsID, Name, Description, SKU, Unit price…TaxesID, Name, Rate %, Tax number, Compound…