Expected QuickBooks data

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 transactionentities

Table Name
Description
bill
The 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.
billpayments
BillPayment 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.
creditmemos
The 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.
deposits
Deposits 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.
estimates
Estimates 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.
invoices
Invoices are sales forms that a customer pays later. The invoices table records any deposit information, date, line items, tax information, and customer information.
journalentries
The journalentries table records AR and AP account information, including the journal entry ID, transaction date, and line item information.
payments
A payment record includes attributes such as the payment ID, applied and unapplied amounts, transaction date, transaction type, and processing status.
purchases
The purchases table represents your expenses and includes the purchase ID, payment type, amount, and any line item information.
purchaseorders
The 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.
refundreceipts
The refundreceipts table records refunds given to customers. Attributes include the refundreceipt ID, line item information, total amount, customer information, and balance.
salesreceipts
The 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.
timeactivities
The 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.
transfers
The transfers table records information on funds moved between accounts. Attributes include the transfer ID, amount, account information, and date.
vendorcredits
Vendor 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 namelistentities

Table Name
Description
accounts
This table includes the account ID, name, status, type, balance, currency, and creation time.
budgets
This table records all information relating to company budgets, including the budget ID, name, start and end dates, type, status, and details.
classes
Classes, 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.
customers
The customers table holds all information relating to your customers, including the customer’s ID, name, billing and shipping addresses, phone number, and email address.
departments
The departments table includes the department ID, name, and type (subdepartment vs top-level department).
employees
The 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.
items
The 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.
paymentmethods
The paymentmethods table records the method of payment received for goods and services. It contains the payment ID, type, and name.
taxagencies
This table records information about tax agencies, including the tax agency ID, and tracking information on taxes for purchases and sales.
taxcodes
Tax 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.
taxrates
Tax rates are used to calculate tax liabilities. This table includes the tax rate ID, name, description, rate, tax agency, and more.
terms
This entity represents the terms under which sales are made. The terms table includes the term ID, name, type, discount percent, and due days.
vendors
The 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.
recommendation-more-help
e1f8a7e8-8cc7-4c99-9697-b1daa1d66dbc