Loading ...

QQube Delivers QuickBooks Reporting to PowerPivot

QuickBooks and Excel Power Pivot

Advanced QuickBooks Reporting Capabilities For Pivot Table Enthusiasts

Excel Power Pivot example using QuickBooks purchasing report data
Excel Power Pivot example of EBIDTA capable Profit and Loss with "to date" capabilities


Excel Power Pivot example using QuickBooks purchasing report data
Power Query out-of-the box example for QuickBooks Sales data model

QQube Saves you Time and Money


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 or weeks on reverse engineering data sources and mapping documents.
  • Never start from scratch - just open a data model example and choose your fields.
  • Take advantage of your Excel and Power Query investment and skills.
  • Includes measures and field combinations not found in QuickBooks reports.
  • Power users have access to schema details for advanced modeling.
  • Tiered pricing for Multiple QB companies.

QQube Provides Hundreds of Measures - So You Don't Have To


QQube Select Assistant for drag and drop into Excel
Sampling of Measures from the Flexible Period Profit and Loss Data Model

Excel PowerPivot 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

QQube Delivers Answers to your Business Questions


  • Generate financial statements, including QuickBooks P&L, Balance Sheet, Side by Side Trial Balance Activity or Statement of Cash Flows and more.
  • QuickBooks detail data models include Sales, Customers and Receivables, Vendors and Payables, Job Costing, Payroll, Inventory, General Ledger Detail, and Audit Trail.
  • QQube detail data models contain line level details and all custom fields.
  • 52/53 Tax Year for Profit and Loss and all detail data models.
  • Posting, non-posting, and linked transactions


QQube is Exponentially More Than a Connector


  • QQube consists of 40 QuickBooks data models with over 7,000 available fields.
  • Contains dozens of measures and field combinations not available in QuickBooks.
  • Saves weeks or months of reverse engineering data sources, and the nuances of how QuickBooks works underneath the hood.
  • Multi-Company Aggregation and Filtering for any subject area using the affordable QQube Multi-Company Add-On.
  • Home and foreign currencies shown in all detail data models.

QQube Makes it Easy to use PowerPivot with QuickBooks

Overcome the limitations of regular Excel pivot tables.