Die FreshBooks-Tabellen in Sheets

Sheets liest die Daten aus Ihr FreshBooks-Unternehmen als 16 Tabellen. Fügen Sie eine davon als Datenquelle zu einem Arbeitsblatt hinzu, und ihre Spalten werden zu Namen, die Ihre Formeln verwenden.

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…