Loading ...

QQUBE™ Data Engine for QuickBooks

QQube Data Engine for QuickBooks


QQube extracts the raw data from QuickBooks, and then transforms it into self-serve data models that you can use out-of-the-box in existing applications such as Excel, Power BI or Tableau.

We eliminate the need for costly project development or dealing with tables, relationships, mapping documents and complex data schemas. 

Just start with any example and pick the fields you want.

 

Rated the "best self-service business intelligence (BI) tool for in-depth analysis of your Intuit QuickBooks files" - PC Magazine

PC Magazine

Manage and Visualize your Information

Create reports and dashboards from your QuickBooks data or combine it with data from other sources to help you get the answers you want.

  • Custom financial reports
  • Job cost analytics
  • Inventory management
  • Customer profiles
  • Sales and buying patterns
  • Purchasing/cost analysis
  • General Ledger details
  • Auditing... and more

Your data is live, dynamic, actionable - and conveniently available in any form outside of QuickBooks.

With over 40 data models, hundreds of calculated measures, and  7,000 available fields - plus an additional 5,600 calculations for Power BI - QQube has the most complete data set - dwarfing any available raw connector or "competing" product.  Learn more

Manage and Visualize your Information
QQube is Out-of-the-Box Technology

QQube is Self-Serve Out-of-the-Box Technology

Open up one of our pre-built report shells and start creating. No need to configure connectors, manually map tables, or spend time understanding data structures. 

We provide over 250 starter examples, including an additional 5,600 additional DAX calculated columns in Microsoft Power BI:

  • Microsoft Excel
  • Microsoft PowerPivot
  • Microsoft PowerBI
  • Microsoft Access
  • SAP Crystal Reports
  • Tableau

 

 

Download and Try QQube for Free for 15 days.

Start My Free 15-Day Trial


Request a 30 Minute Demo or View the Full Price List

The Business Case for QQube

Accounting

A restauranteur needed 52/53 Profit and Loss Financials, including actual, budget and forecast, with a Consolidated option for aggregating 10 of his restaurants.

Sales

Sally needed sales commission reports based upon fully paid invoices, and didn't want to pay for returns or freight - and wanted to see % of discounts.

Job Cost

Joe wanted more than an actual vs estimate - he needed to know what was committed, collected, how many overtime hours, and WIP, all in the same report.

Shipping

Mary, the owner wanted to know what percentage of orders were not fulfilled on the first shipment.

Inventory Control

Larry, a small business owner wanted a method of inventory forecasting where she could view both sales history, and Open SO/PO in the same analysis.

CFO

Michael needed a 12 month side by side trial balance by class and statement of cash flows that he could re-use for all of his clients.

Key Benefits

  • Live data outside of QuickBooks. Synch process and data storage is local. Your data is available even when QB isn't running.
  • We do what QuickBooks doesn't. Considerably more comprehensive, powerful, and flexible than even QB Enterprise Advanced Reporting. 
  • Affordable price points for multiple QuickBooks files. We provide three tiers: 1 to 3 Companies, 1 to 10 Companies, and Unlimited (100) Companies
  • Exponentially more than a raw ODBC connector.  While third party connectors use this SDK to extract raw data in the form of “tables”, they do nothing to account for the nuances of QuickBooks underneath the hood, and they require weeks or months of reverse engineering.
  • Built from knowledge and experience. The two chief architects who built this tool have more experience with QuickBooks data extraction than anybody else in the Intuit Community.
  • Simplicity for end-users. Over 250 examples out-of-the-box featuring drag and drop functionality in the tool of your choice, without having to know ANYTHING about the underlying data complexities.  Free Excel Add-In included.
  • Power for advance report developers. Benefit from the years of investment we have made in our technology by getting access to our data models and pre-calculated measures, saving weeks or months of their learning curve. Plus they don’t have to be accountants to understand everything.
  • Save big on custom projects. Not everybody has the time to use, or learn about, advanced tools like Crystal Reports, Power Pivot or Power BI, driving the need to seek outside expertise.  Your savings on programmers getting up to speed on the quirks of the Intuit SDK (and QuickBooks), as opposed to using QQube, can easily run into the thousands of dollars.
  • The only tool with out-of-the-box integration with Power BI. QQube provides over 220 individual metrics for finance, general ledger, sales, inventory management, job costing, purchasing, and payroll.  Additionally, QQube provides over 5,600 additional DAX formulas to let you produce what you want in minutes - not weeks.

QQube Pricing and Requirements

QQube is a desktop application and uses a yearly subscription model.

New QQube Single-User (Workstation Only) License

$450

For use only on a desktop computer or laptop where one person creates and runs reports for themselves or to share with others. Includes the complete set of tools and examples.

Buy QQube Now

Yearly Subscription Renewal

$160

Allows you to receive periodic enhancements, performance improvements, and bug fixes.

Hardware and Software

  • Operating System (64 Bit Only): Windows 10, 11
  • CPU: 6th Generation Intel Core ix Processors
  • Memory: 3 Gig Minimum
  • Hard Drive Space: 150 MB. Extracted data for each QB file ~ 1 to 3 Gig.
  • All QuickBooks Desktop Versions 2020-2023
  • Excel Add-In: Excel 2016, Office 365. 64 Bit Excel encouraged

Implementation

  • QuickBooks client must be installed and registered
  • Admin Permissions Required only for installation
  • Cannot be installed on a server
  • Learn More

Requirements to Run Examples

  • Microsoft Access - 2016 and above
  • Microsoft Excel - 2016 and above
  • Excel PowerPivot - Excel 2016 and above)
  • Microsoft Power BI - Current Version
  • SAP Crystal Reports - 2011 and above
  • Tableau - 2020 and later

Multi-User Licensing: Flexible and Cost-Effective

For local network server, remote desktop server or hosted environment. Users are concurrent

 

1-5 Users   $895    Buy
1-10 Users $1,595    Buy
1 CPU $2,595    Buy

Yearly Subscription Renewal

Receive periodic enhancements and bug fixes.

 

1-5 Users $315
1-10 Users $560
1 CPU $910

Hardware and Software

  • Operating System (64-Bit Only): Windows Server2012/R2, Server 2016, Server 2019
  • CPU: Intel 6th Generation Intel Core ix or Xeon Professors
  • Memory: 4 Gig Minimum
  • Hard Drive Space: 150 MB. Extracted data for each QB file ~ 1 to 3 Gig.
  • All QuickBooks Desktop Versions 2020-2023
  • Excel Add-In: Excel 2016, Office 365

Implementation

  • Supported Configurations: Local Area Networks, Remote Desktop, Citrix, 3rd Party Hosters
  • Dedicated, always on, server user where synch takes place
  • Full administrative rights required only for installation
  • QuickBooks client must be installed and registered under dedicated server user
  • Learn More

Requirements to Run Examples

  • Microsoft Access - 2016 and above
  • Microsoft Excel - 2016 and above
  • Excel PowerPivot - Excel 2016 and above)
  • Microsoft Power BI - Current Version
  • SAP Crystal Reports - 2011 and above
  • Tableau - 2020 and later

Multi-Company Add-On: Unattended Data Extraction

Automated data extraction of multiple QB files.

1 to 3 $195 Buy
1 to 10 $395 Buy
Unlimited (Approx 100)
$495 Buy

What you can do with it

  • Consolidate Financial Statements
  • Look up account balances without having to physically open up each company file
  • Aggregate any information including A/R, A/P, Sales Purchases, Payroll, Inventory, General Ledger
  • Filter by a specific company or multiple companies

Requirements

An active QQube Single-User or Multi-User license

How it works

QQube will programmatically open each company file - without manual intervention - and extract the appropriate data according to a scheduled option.

Users will also be able to extract any data from any file upon demand.

QQube Data Engine for QuickBooks

Transforms your QuickBooks information into answers