Hundreds of examples out-of-the-box, leveraging existing tool sets such as Excel, Power BI or Tableau.
No need to deal with tables, relationships, mapping documents, reverse engineering, or connection strings.
Created by founder Chuck Vigeant, M.Ed. who is 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 is fully capable of providing drill down reporting as well summary information and let's you leverage tools for traditional reporting or visualization depending upon the audience within the organization.
QQube users fall primarily in the following categories:
As one of Intuit's largest and most successful 3rd party applications, we have gratefully served all manner and type of business. 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 extracted data into data models that you can connect to using everyday tools such as Excel, Power BI, Crystal Reports, or Tableau. Each data model 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.
QQube is capable of combining dozens of QuickBooks files, allowing you to aggregate or filter any QuickBooks data, 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 (or any list) 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 sheets, and invoke the QQube Add-In to drag and drop live information into your spreadsheets. Leverage your existing skill set to create dynamic lists, pivot tables, and pivot charts.
QQube provides the Power Query data models and an additional 5,700 DAX formulas to handle larger data sets for sales, inventory, job costing or general ledger which regular Excel is not capable of handling.
We make Power BI easy for everybody, by providing the Power Query data models, and an addtional 5,700 DAX formulas to allow a user - or project developer - to get up and running quickly.
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
Leverage 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, 5,700 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 and project developers who want to work underneath the hood.
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