QQube extracts the spaghetti code from QuickBooks, and transforms the data, using traditional data warehouse methodology, into drag and drop columns that can be used out-of-the-box with tools like Excel, PowerPivot, Power BI, Access, Crystal Reports, and Tableau.
There is no need to deal with tables, relationships, mapping documents, reverse engineering, or connection strings.
QQube includes thousands of fields, and hundreds of additional calculations to provide ease of use for the end-user, and power and flexibility for the most advanced devloper.
QQube, created in 2010, is the brain child of founder Chuck Vigeant, M.Ed. who is known as the father of Crystal Reports for QuickBooks, and widely regarded as the most knowledgeable expert on QuickBooks data extraction.
Chief Engineer and database extraction architect, is Matt Froncek, who designed the QODBC Driver included with QuickBooks Enterprise.
QQube provides a level of granular detail that empowers those who require both summary and drill down reporting, while furnishing ease of use capabilities for users who want visualization for dashboards, and tools for dynamic analysis.
QQube users fall primarily in the following categories:
As one of Intuit's largest and most succefful 3rd party applications, we serve a variety of industries around the globe. Here is a list of our most prevalent industry types:
STEP 1. QQube establishes a connection to QuickBooks using the Intuit SDK and auto extracts data periodically - or upon demand - into our proprietary Sybase database. This can be one - or dozens of QuickBooks companies.
STEP 2. QQube transforms the raw spaghetti code data into usable - and recognizable - pieces. Each analytic is organized as a traditional warehouse "Star Schema", where there is one FACT table containing measures, and links to multiple DIMENSIONS e.g. accounts, items, customers, etc.
STEP 3. Open up one of our pre-built shells - and the data will refresh from the QQube database automatically. There are no connection strings or configuration needed.
QQube is capable of combining dozens of QuickBooks files, allowing you to aggregate or filter any of our analytics information, including Financial Statements, A/R, A/P, Purchases, Sales, Inventory, or even Job Costing.
A unique side-feature of this capability is that you can see chart of accounts for multiple companies side-by-side.
QQube opens each QuickBooks file programmatically and extracts the data, with options to permanently skip files after they are initially loaded, or even files that have had no activity since the last synch.
Three affordable tiers are available.
Start with one of the pre-built Excel sheels, and invoke the QQube Add-In to drag and drop live information into your spreadsheets, then take advantage of your Excel knowledge and skills. Create dynamic lists, pivot tables, and pivot charts.
Use the pre-built QQube shells for Excel PowerPivot to create advanced analysis for inventory, job costing, general ledger, and sales analytics. QQube provides several hundred additional DAX formulas for convenience.
QQube provides over 220 out-of-the-box metrics including an additional 200 DAX formulas to stem the learning curve for Microsoft’s flagship data visualization product. Use the Power BI desktop authoring tool or upload into the cloud for access on any device.
If you have years of Microsoft Access skills, put them to use, by taking advantage of our out-of-the-box QQube shells for each analytic area. No tables to connect, or engineering to reverse. Just open one of the examples, start with a pre-built query, and create your report.
After 3 decades, SAP Crystal Reports is still the number one desktop tool for conventional reporting with pinpoint layouts, and complex data groupings. Use with QQube for financial statements, 52/53 tax year reporting, inventory analysis, and job cost layouts
Tableau provides stunning Quickbooks dashboards, and is a standard bearer of the Gartner "Magic Quadrant" for visualization. Use the pre-built QQube shells to get started without the need to deal with tables, relationships, or mapping documents.
We save up to 80% of the time it takes to create any report or dashboard
We do what QuickBooks doesn’t
Data is live outside of QuickBooks – whether on the desktop or the cloud
Hundreds of column combinations that are not available in QuickBooks Reporting, Custom Reporting or Advanced Reporting
52/53 tax year
Actual, Budget AND forecast in one report
General Ledger linked transactions
Side-by-side periods of trial balance activity and statement of cash flows
Inventory forecasting with both consumption sales history, including sites, U of M nesting, serial and lot numbers
Job costing that combines five or more reports into one
Traditional KPI’s and much, much more
We have what other offerings don’t
No reverse engineering and dealing with raw tables
No need for mapping documents, and knowledge of data modeling techniques
No agnostic front end – plug into every day tools, like Excel, PowerBI, Crystal
Hundreds of measures and calculations that take into effect the various ways that people use QuickBooks
Granular detail down to the line level
Multi-Currency with home currency and foreign currency side-by-side
The only tool with out-of-the-box integration with Power BI (220 Metrics, 200 additional DAX formulas)
Affordable tiered price points for multiple QuickBooks files
We infuse knowledge and experience that nobody else has
CEO Chuck Vigeant, M.Ed. Is considered the foremost authority on QuickBooks data extraction, was a Pro Advisor with over 400 QB customers, and is the only outside accounting technologist contracted by Intuit to work in the actual database
Chief engineer Matt Froncek has actualized the two most successful 3rd party data extraction tools in the Intuit Community
We engineer simplicity for end-users who want self-serve options
We provide power for advanced report developers who want to “get dirty”
Multi-Company Add-On
Semi-subscription model with yearly renewals at approximately 35% of current retail value.
Upgrades and updates included during the yearly subscription periods.
White Paper