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

 QQube by Clearify is the ONLY data warehouse for QuickBooks that has prebuilt data models for Power BI to give you a solid base for your reporting

What makes QQube different is that while many alternatives exist for connecting to QuickBooks desktop 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 is also great QuickBooks consolidation software !   The data extraction engine seamlessly pulls all information into a single database to build consolidated financial statements by default.  We have partnered with the makers of QQUBE to extend our AHA tool so that even if your companies chart of accounts are not in alignment you can map your accounts into a unified view without having to change individual accounts (and the accounting history!)  This video shows how QQUBE and AHA are Better Together !

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)