Loading ...

QuickBooks Analytics using PowerPivot and QQube

QuickBooks and Excel Power Pivot

Advanced Data Modeling For Pivot Table Enthusiasts

Excel Power Pivot example using QuickBooks purchasing report data
Excel Power Pivot example shows off its advanced capabilities using QQube for QuickBooks

QQube™ Delivers QuickBooks To Excel Power Pivot


QuickBooks to QQube to Excel Power Pivot


  • Reduce by 80% the time it takes to get started using raw connectors.
  • No need to spend days reverse engineering data relationships.
  • Never start from scratch - just drag and drop from an example.
  • Add other data sources to your QuickBooks data
  • Tiered pricing for Multiiple QB companies
  • Advantages over raw ODBC connectors with logic and measures not found in QuickBooks raw schemas.
  • Power Pivot examples for each QuickBooks reporting area to get you started.
  • Friendly field names and pre-formatted measures.
  • Power users have access to schema details for advanced modeling.

     Details and Requirements

QQube Provides More To Lessen Your Learning Curve



Excel Power Pivot Report Examples From QQube To Get You Started

Excel Power Pivot examples from the QQube Configuration Tool
QQube Configuration Tool containing out-of-the-box Excel Power Pivot examples for QuickBooks

QuickBooks Reports from QQube


  • Generate financial statements, including QuickBooks P&L, Balance Sheet, Trial Balance Activity, Side by Side Statement of Cash Flows and more.
  • QuickBooks financial statements from QQube include hundreds of shortcut columns e.g. current month, previous month, last year month, etc.
  • QuickBooks detail analytics include Sales, Customers and Receivables, Vendors and Payables, Job Costing, Payroll, Inventory, General Ledger Detail, Audit Trail, Sales Tax.
  • All QQube detail analytics are line level details including all custom fields.
  • 52/53 Tax Year for Profit and Loss and all detail analytics.


QQube is More Than a Connector


  • QQube consists of over 45 QuickBooks Subject Areas with over 7,000 available fields.
  • QQube contains hundreds of measures and logic not available in QuickBooks.
  • QQube saves weeks or months of reverse engineering raw tables, relationships, and the nuances of QuickBooks reporting.
  • Multi-Company Aggregation and Filtering for any subject area using the affordable QQube Multi-Company Add-On.
  • QQube supports QuickBooks Multi-Currency editions showing both home and foreign currencies for detail analytics.

   View QQube schemas

Excel Power Pivot

Overcome the limitations of regular Excel pivot tables.