Expected QuickBooks data

Last update: 2023-07-25
  • 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 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

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.

Related:

Previous page
Next page

On this page