Les tables FreshBooks dans Sheets

Sheets lit votre entreprise FreshBooks sous forme de 16 tables. Ajoutez-en une à un tableur comme source de données et ses colonnes deviennent des noms utilisables dans vos formules.

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…