QuickBooks Data Models
What is a QuickBooks Data Model?
“A QuickBooks Data Model contains all of the pieces you need to report on 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 – Available to Developers
Transparent to End Users Available to Developers
Use Right Out of the Box or Develop a Project and Save Thousands of Dollars
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