De QuickBooks Online-tabellen in Sheets

Sheets leest je QuickBooks Online-bedrijf als 15 tabellen. Voeg er een toe aan een spreadsheet als gegevensbron en de kolommen worden namen die je formules gebruiken.

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…