Magento Business Intelligence Help Center

Expected Quickbooks data

BROUGHT TO YOU BY

Avatar

Once you’ve connected your Quickbooks account, you can use the Data Warehouse Manager to easily track relevant data fields for analysis. The following tables will be 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 Purchase orders are 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 This 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 Time activities are time records for vendors and/or employees. The timeactivities table 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 The accounts 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 aren't 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 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:

Was this article helpful?
0 out of 0 found this helpful

Comments

Powered by Zendesk