Las tablas de QuickBooks Online en Sheets

Sheets lee tu empresa de QuickBooks Online como 15 tablas. Añade una a una hoja de cálculo como fuente de datos y sus columnas se convierten en nombres que tus fórmulas usan.

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…