As tabelas do QuickBooks Online no Sheets

O Sheets lê sua empresa no QuickBooks Online em 15 tabelas. Adicione uma delas a uma planilha como fonte de dados e suas colunas viram nomes que suas fórmulas usam.

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…