Loading ...

QQUBE™ Data Warehouse for QuickBooks

QQube Analytics Technology

QQube™

 

 

Live data outside of QuickBooks using drag and drop technology in tools like Excel, Access, PowerPivot, Power BI, Crystal Reports or Tableau to quickly and efficiently organize your data and stimulate informed busines decisions.

QQube is exponentially more than a raw ODBC connector, and engineered by the two most experienced - and celebrated - accounting technologists in the Intuit Community. It provides simplicity for end-users but substantive power for advanced report developers, saving you weeks of time and money on any project.

Aggregate or filter up to 100 companies with affordable tier pricing.

 

Rated the "best self-service business intelligence (BI) tool for in-depth analysis of your Intuit QuickBooks files" - 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 make better business decisions.

  • 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 45 analytic areas, hundreds of calculated measures, and  7,000 available fields, QQube has the most complete data set - dwarfing any available raw connector or "competing" product. Learn more

Manage and Visualize your Information
How QQube Works

Affordable data warehousing for small business

QQube extracts your data from QuickBooks and transforms it into usable pieces. You can then drag and drop these pieces inside Excel, Microsoft Access, Crystal Reports, Power BI, or any reporting tool of your choice.

The traditional methods of mapping, deciphering tables, relationships, or reverse engineering are no longer necessary. It will save you hours, days, or even weeks - because everybody uses QuickBooks differently, and everybody looks at their data differently.

All you have to do is drag-and-drop and spend your precious time actually building reports - not figuring out how the data is put together.

 

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.

QQube is 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 reverse engineering data structures. 

We provide over 250 starter shells and examples - including 220 individual metrics and 200 additional DAX calculated columns in Microsoft Power BI:

  • Microsoft Excel
  • Microsoft PowerPivot
  • Microsoft PowerBI
  • Microsoft Access
  • SAP Crystal Reports
  • Tableau
QQube is Out-of-the-Box Technology

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 raw schemas 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 200 additional DAX formulas to stem the learning curve for Microsoft’s flagship data visualization product.

QQube Pricing and Requirements

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

New QQube Single User 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 8/8.1/10
  • 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 2017-2020
  • Excel Add-In: Excel 2013, 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 - 2013 and above
  • Microsoft Excel - 2013 and above
  • Excel PowerPivot - Excel 2013/2016/2019/365 ProPlus Edition)
  • Microsoft Power BI - Current Version
  • SAP Crystal Reports - 2011 and above
  • Tableau - Versions 9.x and above

Multi-User Licensing: Flexible and Cost-Effective

For server and hosted environments or where multiple people will be accessing the same data. 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 2017-2020
  • Excel Add-In: Excel 2013, 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 - 2013 and above
  • Microsoft Excel - 2013 and above
  • Excel PowerPivot - Excel 2013/2016/2019/365 ProPlus Edition)
  • Microsoft Power BI - Current Version
  • SAP Crystal Reports - 2011 and above
  • Tableau - Versions 9.x and above

Multi-Company Add-On: Unattended Data Extraction

Unattended data extraction from multiple companies.

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.

Small Business Analytics for Quickbooks

Quickly build reports and dashboards from your Quickbooks data.