QQube FAQ
Product Information
What is the difference between a connector and the QQube Data Warehouse?
A connector uses the Intuit QuickBooks Desktop SDK to extract qbXML data and present it in a table-like format. It does not provide direct access to the QuickBooks database.
The user must still reverse-engineer the transaction structures, relationships, accounting logic, and limitations of the SDK.
QQube combines data from the Intuit SDK and, for supported QuickBooks Enterprise editions, the Custom Reporting interface. It then transforms that data into analysis-ready data models containing relationships, calculations, and hundreds of measures.
QQube also handles known SDK gaps, inconsistencies, and extraction limitations. The result is a structured data warehouse rather than a raw representation of the QuickBooks extraction interfaces.
Why isn't there a direct connection to QuickBooks?
Intuit does not provide direct access to the QuickBooks Desktop database. Outside products must use the access methods provided by Intuit.
These methods are very different from a direct database connection and can require complicated requests to retrieve related information.
This process can be slow, especially with larger QuickBooks files, and some QuickBooks data is not made available at all.
Because Intuit controls these access methods, no third-party product can bypass their extraction speed or obtain unrestricted access to the QuickBooks database. QQube works around the known limitations and organizes the available data into reporting-ready data models.
How long does it take to synchronize my data?
QuickBooks Desktop data is extracted through technology introduced by Intuit in 2001. The process can be slow, especially with larger or more complex QuickBooks files.
The first synchronization can take approximately 20 minutes for a 250 MB file, six hours or more for a 2 GB file, and longer in some cases.
Subsequent synchronizations usually take only several minutes because QQube retrieves only the information that needs to be updated. Refreshing an Excel spreadsheet or Power BI report from QQube normally takes seconds.
Can QQube change my QuickBooks data?
No. QQube is a read-only product.
It cannot add, change, or delete information in QuickBooks.
What is a QQube data model?
A QQube data model is a complete, reporting-ready collection of QuickBooks information for a specific subject, such as job costing, sales, or inventory.
It contains the related details, calculations, and relationships needed to create reports without having to determine how the QuickBooks data fits together.
Do I need to connect one data model to another?
Each QQube data model is complete for its subject area and is designed to be used on its own.
For example, the Inventory data model already includes the related sales, purchasing, and general ledger details needed for inventory reporting.
Combining data models should only be a last resort for a custom requirement when QuickBooks does not store the needed information together in the way the report requires.
Do I need to manually connect my application to QQube?
No. QQube installs the same standard connections on each computer.
This allows a spreadsheet or report created by one QQube user to be opened and refreshed by another QQube user without changing the connection information.
For other applications, use the standard QQube connection described in the Overview of QQube Implementation .
Is QQube difficult to set up and learn?
No. We provide step-by-step instructions for installing QQube, connecting it to QuickBooks, and loading your data.
Once your data is loaded, you can open one of the 250 included examples and begin creating reports.
You mainly need experience with the application you are using, such as Excel or Power BI. QQube handles the QuickBooks data structure and reporting logic for you.
Do I have access to the 5,700 DAX formulas included for Power Pivot and Power BI?
Yes. The 5,700 DAX formulas are included with QQube at no additional charge.
They were developed using a methodology created with Marco Russo and are available in the QQube Power Pivot and Power BI examples.
I am an advanced user or developer. Can I access the raw tables?
QQube provides a comprehensive series of public views that advanced users and developers can query directly.
These views contain the reporting-ready data used by our examples. They already include the QuickBooks relationships, calculations, and workarounds that would otherwise take weeks or months to develop.
The internal tables and transformation methods used to create these views are proprietary and are not exposed.
Pricing
What is the pricing structure?
QQube Data Warehouse for one QuickBooks file
- Single-User Edition for a workstation: $550
- Multi-User Edition for 5 users on a server: $1,095
- Multi-User Edition for 10 users on a server: $1,950
Multi-Company Add-Ons
- Up to 3 QuickBooks files: $195
- Up to 10 QuickBooks files: $495
- Up to 50 QuickBooks files: $795
- Up to 100 QuickBooks files: $995
A Multi-Company Add-On can be used with any QQube Single-User or Multi-User Edition.
Is QQube based on a subscription?
QQube is not a traditional subscription. Your initial purchase includes a perpetual license and one year of product updates, upgrades, and help desk support.
After the first year, you may continue using the version you already own without renewing.
An annual renewal provides another year of product updates, upgrades, and help desk support at approximately 35% of the current retail price.
Requirements
What are the hardware and software requirements?
The complete hardware, software, QuickBooks, and implementation requirements are listed in the QQube Desktop Requirements Checklist .
If I am the only QQube user, can I install the Single-User Edition on a server?
No. The Single-User Edition is designed for installation on a workstation.
A server installation requires a Multi-User Edition, even when only one person uses QQube.
The server installation uses a dedicated Windows user to isolate QQube synchronization from normal QuickBooks and server activity.
Trial Availability
Is a trial available?
Yes. Your 15-day evaluation copy includes all features with no limitations.
An additional 15-day extension is available upon request.
Do all of the examples I see in the trial come with the product?
Yes. All examples included with the trial are included with the purchased product.
Any reports or other work you create during the trial remain available after you purchase and activate QQube.
Support Options
What kind of support do you provide?
Customers with a current subscription receive help desk support through the CLEARIFY support site.
You can submit a ticket to our technical engineers at any time. We normally respond the same day.
In rare cases, remote login assistance may be required. This is arranged only by mutual agreement and is billed at $149 per incident.
Most issues can be resolved by following our step-by-step guides or working directly with an engineer through the ticket system.
Custom Reports
Do you help with custom projects?
CLEARIFY focuses its resources on developing and supporting QQube, safeguarding data accuracy, and continually improving the product.
Custom reporting, implementation, and consulting services are provided by independent Certified QQube Solution Providers. Many have extensive QuickBooks and accounting technology experience and can assist with Excel, Power BI, and other reporting applications.
View the available Certified QQube Solution Providers .
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article