Tabele FreshBooks w Sheets

Sheets czyta dane Twoja firma w FreshBooks jako tabele (16). Dodaj jedną do arkusza jako źródło danych, a jej kolumny staną się nazwami, których używają Twoje formuły.

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…