Expected QuickBooks data

Last update: July 25, 2023

CREATED FOR:

  • Beginner
  • Intermediate
  • Admin
  • Developer
  • User

After you have connected your QuickBooks account, you can use the Data Warehouse Manager to easily track relevant data fields for analysis. The following tables are created in your Data Warehouse:

To view all the fields available for tracking, click the links in the table name column.

Transaction Entities

Table NameDescription
billThe bills table contains information about AP transactions, or a request for payment from a third party. Attributes include currency type, exchange rate, total amount, due date, balance, and more.
billpaymentsBillPayment entities are the final transaction of payment of bills received from a vendor. This table includes the vendor information, payment type, total amount, transaction date, and more.
creditmemosThe creditmemos table records transactions that are refunds or credits of both full and partial payments. Some attributes include the customer’s name, the customer’s billing and shipping info, the amount, and date.
depositsDeposits include direct deposits and customer payments moved into the Asset Account after being held in the Undeposited Funds account. Attributes include the amount, deposit ID, and date.
estimatesEstimates are transactions given to customers that include proposed pricing for a good or service. This table records the amount, any discount information, customer information, and date.
invoicesInvoices are sales forms that a customer pays later. The invoices table records any deposit information, date, line items, tax information, and customer information.
journalentriesThe journalentries table records AR and AP account information, including the journal entry ID, transaction date, and line item information.
paymentsA payment record includes attributes such as the payment ID, applied and unapplied amounts, transaction date, transaction type, and processing status.
purchasesThe purchases table represents your expenses and includes the purchase ID, payment type, amount, and any line item information.
purchaseordersThe purchaseorders table holds requests for goods sent to vendors. This table includes the vendor information, purchase order ID, transaction date, line item information, total amount, and AP account information.
refundreceiptsThe refundreceipts table records refunds given to customers. Attributes include the refundreceipt ID, line item information, total amount, customer information, and balance.
salesreceiptsThe salesreceipts table records information in the sales receipts given to customers, including the salesreceipt ID, line item information, total amount, customer information, transaction date, and any deposits.
timeactivitiesThe timeactivities table holds time records for vendors and/or employees and includes the time activity ID, employee/vendor information, time logged, activity description, and date recorded.
transfersThe transfers table records information on funds moved between accounts. Attributes include the transfer ID, amount, account information, and date.
vendorcreditsVendor credits are AP transactions that are refunds or credits given to vendors. The vendorcredits table includes the vendor credit ID, line item information, vendor information, AP account, total amount, and date.

Name List Entities

Table NameDescription
accountsThis table includes the account ID, name, status, type, balance, currency, and creation time.
budgetsThis table records all information relating to company budgets, including the budget ID, name, start and end dates, type, status, and details.
classesClasses, applied to detail lines of transactions, allow you to track segments that are not tied to a client or project. This table records the class ID, name, subclass, and status.
customersThe customers table holds all information relating to your customers, including the customer’s ID, name, billing and shipping addresses, phone number, and email address.
departmentsThe departments table includes the department ID, name, and type (subdepartment vs top-level department).
employeesThe employees table records information about the people who work for your company. Attributes include the employee ID, name, address, phone number, and billable information, if the company is payroll-enabled.
itemsThe items table contains details on products or services that your company sells. This table includes the item ID, name, description, unit price, type, purchasing information, on-hand quantity, and income and asset account information.
paymentmethodsThe paymentmethods table records the method of payment received for goods and services. It contains the payment ID, type, and name.
taxagenciesThis table records information about tax agencies, including the tax agency ID, and tracking information on taxes for purchases and sales.
taxcodesTax codes are used to track the tax status (taxable vs non-taxable) of products, services, and customers. The taxcodes table includes the tax code ID, name, description, status, taxable status, tax rate, and tax group.
taxratesTax rates are used to calculate tax liabilities. This table includes the tax rate ID, name, description, rate, tax agency, and more.
termsThis entity represents the terms under which sales are made. The terms table includes the term ID, name, type, discount percent, and due days.
vendorsThe vendors table contains information about the vendors you purchase from. Table attributes include the vendor ID, company name, account number, account balance, 1099 status, billing address, phone number, email address, and web address.