This example of  QQube in Excel shows a sampling of the depth of the inventory information information thru the QQube solution to analyzing your inventory.

QuickBooks Analytics
powered by QQUBE™ Technology

One example of business information that is available is the inventory information. On Clearify's website you can find the full list of information that is accessible here.

The thing to take noticeof when you look at that is  the document category. Unlike the tools that only give you access to QB data,  the documents listed here:

  • "History - Inventory"  representing all posting transactions), 
  • Sales Order
  • Pending Builds
  • Purchase Order

each represent a different data source that has been merged together to give you complete data.   Without QQube each report would have to merge that information together to get accurate reports.

 QQube by Clearify is the ONLY data warehouse for QuickBooks.

What makes QQube different is that while many alternatives exist for connecting to QuickBooks data,  QQube combines and reorganizes the raw data from QuickBooks into complete subject areas that provide businesses a unique opportunity to analyze their QuickBooks  information in a way that is not possible without QQUBE. 

QQube Subject Area's


  • Profit and Loss by Job /Class
  • Job Costing
  • Time Tracking
  • Vehicle Mileage


  • Inventory
    -Actual COGS, Margins for Inventory and Assembly Items
    -Consumption and Sales History
  • Bill of Materials
    -expand assembly into sub-assembly(ies) and parts
Customer and Sales Analysis
  • Sales
  • Accounts Receivable
  • Open Sales Orders

 Vendors and Payables

  • Purchases
  • Open A/P
  • Open Purchase Orders
Financial Statements
  • Summary Financial Statements (by account/class/period):                     
    • Balance Sheet
    • Profit and Loss
      *support for  52/53 week also
    • Trial Balance Activity 
    • Trial Balance Current
    • Statement of Cash Flows 
  • Detailed Profit and Loss
  • Detailed General Ledger transactions including linked transactions
  • Profit and Loss Detail
  • Cash Position 
  • Fixed Assets 

Other information available

    • Preferences
    • Custom Fields
    • Price Level (by customer by item)
    • Billing Rate (by customer by item)
    • All Lists (e.g. Accounts, Items, Classes, Customer, Vendors, etc.)  
  • Human Resources
    • Payroll
  • Audit Trail 
  • Sales Tax (USA Only) 

​We empower QuickBooks users to have the information they need to effectively run their business by transforming QuickBooks data into actionable information that is always available, always current.