Le tabelle di FreshBooks in Sheets

Sheets legge la tua azienda FreshBooks come 16 tabelle. Aggiungine una a un foglio di calcolo come origine dati e le sue colonne diventano nomi che le tue formule usano.

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…