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
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.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.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 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 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 are sales forms that a customer pays later. The invoices table records any deposit information, date, line items, tax information, and customer information.The
journalentries table records AR and AP account information, including the journal entry ID, transaction date, and line item information.A
payment record includes attributes such as the payment ID, applied and unapplied amounts, transaction date, transaction type, and processing status.The
purchases table represents your expenses and includes the purchase ID, payment type, amount, and any line item information.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.The
refundreceipts table records refunds given to customers. Attributes include the refundreceipt ID, line item information, total amount, customer information, and balance.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.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.The
transfers table records information on funds moved between accounts. Attributes include the transfer ID, amount, account information, and date.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
This table includes the account ID, name, status, type, balance, currency, and creation time.
This table records all information relating to company budgets, including the budget ID, name, start and end dates, type, status, and details.
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.
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.The
departments table includes the department ID, name, and type (subdepartment vs top-level department).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.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.The
paymentmethods table records the method of payment received for goods and services. It contains the payment ID, type, and name.This table records information about tax agencies, including the tax agency ID, and tracking information on taxes for purchases and sales.
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.Tax rates are used to calculate tax liabilities. This table includes the tax rate ID, name, description, rate, tax agency, and more.
This entity represents the terms under which sales are made. The terms table includes the term ID, name, type, discount percent, and due days.
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.
e1f8a7e8-8cc7-4c99-9697-b1daa1d66dbc