Le tabelle di QuickBooks Online in Sheets

Sheets legge la tua azienda QuickBooks Online come 15 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., 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…