QQube Data Models Explained

Overview

QQube for QuickBooks includes approximately 40 prebuilt business data models. Each model organizes QuickBooks information around a specific business subject or reporting need.

QQube data models are designed to stand on their own. Select the model that matches the business information you need rather than combining separate QQube models to reconstruct the reporting subject yourself.

Complete subject-based data models

For example, the Job Cost Details data model brings together information from many areas of QuickBooks:

• Sales transactions.
• Cost transactions.
• Original and remaining committed costs, including purchase orders.
• Estimates.
• Receive Payments.
• Bill Payments.
• Time Tracking.
• Vehicle Mileage.
• General Ledger details.

You do not need to connect separate sales, purchasing, payroll, time, and accounting data models to create a complete job-cost report.

QQube connects the dots

QuickBooks Desktop does not provide a direct public database connection. Public data access depends primarily on the Intuit SDK and, for supported QuickBooks Enterprise editions, the Custom Reporting interface.

A raw connector can extract that information, but the customer is still responsible for determining how transactions belong together, creating relationships, accounting for QuickBooks behavior, resolving SDK limitations, and building the calculations required for reporting.

QQube performs that work before the data reaches your reporting application.

• Related QuickBooks information is organized into complete business data models.
• Relationships and accounting logic are already included.
• Known QuickBooks and SDK limitations are handled where possible.
• Calculated and reporting fields are prepared for analysis.

Select the fields you need in Excel, Power BI, Power Pivot, Access, Crystal Reports, Tableau, or another supported reporting application. You do not need to reverse-engineer the QuickBooks data structure or construct the underlying data model yourself.