Les tables QuickBooks Online dans Sheets

Sheets lit votre entreprise QuickBooks Online sous forme de 15 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., Date, Due date, Customer…EstimatesID, Estimate no., Date, Expires, Customer…Sales receiptsID, Receipt no., Date, Customer, Customer ID…Payments receivedID, Date, Customer, Customer ID, Amount…Credit memosID, Credit memo no., Date, Customer, Customer ID…

Expenses

BillsID, Bill no., Date, Due date, Vendor…Bill paymentsID, Reference no., Date, Vendor, Vendor ID…ExpensesID, Reference no., Date, Payment type, Payee…

Accounting

DepositsID, Date, Account, Account ID, Total…Journal entriesID, Journal no., Date, Total, Adjusting entry…Chart of accountsID, Name, Full name, Account no., Classification…

Lists

CustomersID, Name, Company, First name, Last name…VendorsID, Name, Company, E-mail, Phone…Products and servicesID, Name, SKU, Type, Description…EmployeesID, Name, E-mail, Phone, Hired…