Loading ...

Small Business Analytics for Quickbooks

QQUBE ANALYTICS

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 and 7,000 available fields and calculated columns, QQube has the most complete data set anywhere on the planet. 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.  These situations require 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 & Plans

QQube is a desktop application.  Pricing is based upon the number of users.

New QQube Single User License

$450

For use on a single computer 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

Upgrade

$160

Upgrades are available to customers who purchased and installed an earlier release.

Upgrade QQube Now

Pricing Details

  • Updates and upgrades are free for one year from date of purchase
  • Product will be supported until the version is sunsetted - usually about three years
  • Upgrades to newer versions - past the initial yearly period - will be approximately 35% of the current rate

Requirements

  • 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 Additional space of 2 Gig or more for extracted data
  • Excel Add-In: Excel 2013, 2016, Office 365. 64 Bit Excel encouraged

Multi-User Licensing: Flexible and Cost-Effective

For server environments where multiple people will be accessing and reporting on the same data.

5 users $895 Buy now
10 users $1,595 Buy now
1 CPU $2,595 Buy now

Pricing Details

  • Updates are free for one year from date of purchase
  • Product will be supported until the version is sunsetted - usually about three years
  • Upgrades to newer versions - past the initial yearly period - will be approximately 35% of the current rate

Requirements

  • 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 Additional space of 4 Gig or more for extracted data for each application file
  • Excel Add-In: Excel 2013, 2016, Office 365. 64 Bit Desktop versions encouraged

Supported Network Configurations

  • Local Area Networks
  • Remote Desktop (formerly Terminal Services) Networks
  • Citrix
  • Hosted environments (e.g. Noobeh, gotomyerp, skyline, insynq, etc. )

Multi-Company Add-On: More Power

Allows you to aggregate any information from multiple companies.

This add-on can be used with either the Single-User or Multi-User versions of QQube.

up to 3 companies $195 Buy now
up to 10 companies $395 Buy now
Unlimited companies (100) $495 Buy now

What you can do with it

  • Aggregate Financial Statements
  • Consolidate A/R or A/P
  • Inventory forecasting for multiple stores
  • Look up escrow balances without having to open up each company file
  • Compile aggregation for any type of information contained in each file
  • Reports and analytics can be filtered by a specific company or companies

Requirements

An active Single-User or Multi-User license

How it works

QQube will programmatically open each company file, to extract and identify the appropriate data according to a scheduled option. Users will also be able to extract upon demand.

Using Excel, Crystal, etc. you will have the option of multi-company aggregation - or the ability to filter by a single company.

Small Business Analytics for Quickbooks

Quickly build reports and dashboards from your Quickbooks data.