QuickBooks Data Models
What is a QuickBooks Data Model?
“A QuickBooks Data Model contains all of the pieces you need to report on in a particular area of your business.”
Everything Put Together for You
Connectors give you individual “tables” and expect you to figure it out. QQube combines the necessary transactions for a specific subject area in one data cube.
Complete Information in a Data Set
QQube contains 40 complete data models and eliminates the need to tie one data model to another to get an answer. You can, however, combine data models.
Measures Not Available in QuickBooks
QQube contains calculated fields, some of which are not available in QuickBooks. Connectors don’t create calculations, just a raw measure or two per transaction.
Transparent to End Users but Available to Developers
Built by Experts
Our Founder is considered the foremost expert on QuickBooks data extraction and contracted by Intuit to work in the QB database. Our chief engineer built two of the top five 3rd party QuickBooks apps.
Save Thousands on Custom Projects
Why would you use the Intuit SDK, or an ODBC connector (that must use the SDK). A QQube data model is out-of-the-box in the application of your choice. Thousands of additional DAX measures for Power BI.
Why Work so Hard?
The whole purpose of QQube is to not have to deal with tables, relationships, connection strings, data dictionaries. Our QQube for QuickBooks Data Warehouse is the most comprehensive in the market.
The QQube for QuickBooks Data Models
Customers and Receivables
- Sales Details – Posting and Non-Posting
- Open Sales Orders
- Accounts Receivable
Vendors and Payables
- Purchase Details – Posting and Non-Posting
- Open Purchase Orders
- Accounts Payable
Inventory
- Inventory Management
- Bill of Materials
Payroll and Human Resources
- Payroll Details
Jobs and Time
- Job Cost Details (Including Time and Mileage)
- Time Tracking
- Vehicle Mileage
- Profit and Loss (Aggregated by Day)
- Profit and Loss by Class (Aggregated by Day)
General Ledger and Accountant
- Standard Trial Balance
- Trial Balance Activity
- Trial Balance Activity by Class
- General Ledger Detail
- Profit and Loss Detail
- Cash Position
- Fixed Assets
Financial Statements
- Standard Monthly Period Balance Sheet (36 Months)
- Standard Monthly Period Profit and Loss (36 Months)
- Standard Monthly Period Statement Cash Flows (36 Months)
- Advanced Monthly Period Profit and Loss (36 Months)
- Flexible Custom Period Balance Sheet (Daily Aggregation)
- Flexible Custom Period P&L /w EBITDA (Daily Aggregation)
Financial Statements by Class
- Standard Monthly Period Balance Sheet (36 Months)
- Standard Monthly Period Profit and Loss (36 Months)
- Standard Monthly Period Statement Cash Flows (36 Months)
- Advanced Monthly Period Profit and Loss (36 Months)
- Flexible Custom Period P&L /w EBITDA (Daily Aggregation)
Financials for 52/53 Tax Year
- Profit and Loss for 52/53 Tax Year
- Profit and Loss by Class for 52/53 Tax Year