Frequently Asked Questions (FAQ)

A connector uses the Intuit SDK (Software Development Kit) to display individual transactions and lists,and make them look like tables. You then have to reverse-engineer how the data works inside of QuickBooks.

The QQube Data Warehouse transforms the raw data from the Intuit SDK into data models containing hundreds of measures not even considered in a raw connector.

QQube automatically handles the QuickBooks logic and SDK gaps, which means that you don't have to worry about tables, relationships, or deal with data dictionaries.

Intuit provides no direct connection to the QuickBooks database and instead uses an SDK (Software Development Kit) which was introduced in 2001, and extracts data in XML (hierarchal text) format.

All developers must use the SDK - even connectors

The 23 year old Intuit SDK (Software Development Kit) is the only way to extract data from QuickBooks and can be slow - especially on larger files.

The first synch - depending upon the size of the file - can take anywhere from 20 minutes for a 250 Meg file, to 6 hours or more for a 2 Gig file.

Subsequent synchs only take several minutes. And to refresh your Excel spreadsheet from QQube only takes seconds.

QQube is a read only product, and is not capable of writing to QuickBooks.

A data model is a complete cube of information about a particular QuickBooks subject area, such as Job Costing Details, or Inventory Management, and is designed to minimize the data requirements, yet maximize the reporting potential.

Not unless you are trying to do something that QuickBooks does not do, or store in the actual database.

Each data model is complete unto itself. For instance, Inventory contains all of the sales, purchasing, and general ledger detail.

There are no manual connection strings necessary. We make it simple by installing the same two DSNs on everybody's machine so that you can create something on your desktop, and then send it to another QQube user, and they can just open and refresh.

If you have an application to connect to QQube you can use the DSN as listed here: Overview of Implementing QQube for QuickBooks Desktop 

We provide step-by-step guides to install and configure QQube to run with QuickBooks. Once your QuickBooks data is loaded into QQube, all you have to do is open up one of the over 200 examples, and start creating reports.

The only skills needed to use QQube is to be somewhat proficient with the application you are using such as Excel, or Power BI. You simply drag and drop a field from the list provided to you in the application.

Yes. We hired the best in the world (Marco Russo) to help produce our DAX methodology and have made that methodology available to anybody who uses our product.

QQube makes available a series of views that you can take advantage of in any of our starter examples. How the data is transformed from the Intuit SDK is proprietary, and is the lifeline that saves you weeks and months of figuring out how everything is put together, and how to overcome all of the pitfalls and shortcomings that is inherent in the Intuit SDK

A good example would be COGS. You don't have to figure out how QuickBooks calculates that field, or uses it in reports.

QQube Data Warehouse for One QuickBooks File

• Single User for Workstation - $550
• Multi-User (5) for Server - $1,095
• Multi-User (10) for Server - $1,950

Multi QuickBooks Company Add-Ons

• 2 or 3 companies - $195
• Up thru 10 companies - $495
• Up thru 50 companies - $795
• "Unlimited" companies - $995

The unlimited company option represents about 100 companies in practical use.

Your QQube purchase is based upon a yearly semi-subscription model.

When you initially purchase, you own the product, and you get free upgrades and updates for a year.

Past the year, you can renew for another year at approximately 35% of the current retail price.

First, we post bug fixes, and improvements several times a year. Second, Intuit can make changes to its SDK (Software Development Kit from year to year, and we often have to accommodate those changes for the product to work with your QuickBooks.

Requirements for Implementing QQube Desktop for QuickBooks.

A server implementation requires the use of a dedicated server user, where the communications between QQube and QuickBooks takes place and are isolated from other processes. This allows you to work in QuickBooks or perform other tasks while a synch is occurring.

Yes, we have a fully functional 15-day trial with no limitations. Trial extensions (additional 15 days) are available upon request..

Yes. The trial is fully functional, and whatever you create during the trial period will still be available once you purchase and activate the product.

We provide free support every day at https://support.clearify.com where you can submit a ticket to our technical engineers, and expect a same day answer.

In rare cases, login support might be required, and mutually agreed upon. There is a $149.00 per incident charge.

95% of all issues - outside of QuickBooks data corruption - have to do with improper implementation, and can be resolved by following our step-by-step guides, or communicating with an engineer via our ticket system.

We spend 100% of our resources on making a robust product, safeguarding data accuracy, and adding enhancements so we don't rest on our laurels.

We have several dozen Certified QQube Solution Providers who provide a wide variety of custom services including Power BI integration. Most are long-term certified QuickBooks pro advisors, and well known in the Intuit community for several decades. We have assembled the cream of the crop.