Model Summary
The QQube Job Cost Details Data Model combines information from multiple QuickBooks reports into one line-level job-cost analytic.
| Model Type | Comprehensive job-cost and profitability analysis |
|---|---|
| Transaction Coverage | Linked posting and non-posting transactions, time tracking, payroll hours, and vehicle mileage |
| Available Fields | More than 1,750 |
| Included Activity | Estimates, income, costs, commitments, receivables, payables, payments, credits, and discounts |
| Primary Use | Compare estimated, actual, committed, paid, open, and theoretical job values |
Best Used For
- Reviewing Job Cost Details to the transaction-line level.
- Comparing estimated income and cost with actual results and remaining commitments.
- Preparing WIP, AIA, bonding, over-under, and budget-variance reports.
- Calculating cost to complete, revenue to complete, completion percentage, and earned revenue.
- Comparing theoretical billing with actual billed amounts.
- Analyzing payroll hours, time tracking, vehicle mileage, and all jobs together.
Key Capabilities
- Includes linked posting and non-posting transactions.
- Combines estimates, actual income and cost, open Purchase Orders, Accounts Receivable, and Accounts Payable.
- Includes payroll hours, time tracking, and vehicle mileage analytics.
- Separates applied, open, paid, billable, billed, unbilled, and theoretical values.
- Includes home and foreign currency values.
Cost Classification and Rate Logic
| Materials Cost | Inventory, assembly, and non-inventory items |
|---|---|
| Labor Cost | Service items |
| Other Cost | Other Charge items |
| Worker Rate | Theoretical quantity multiplied by the billing rate for the employee or vendor performing the service |
| Job Rate | Theoretical quantity multiplied by the item price level assigned to the customer:job |
| Item Rate | Theoretical quantity multiplied by the service-item sales price |
Quantity, Rate, and Amount Fields
Native fields come directly from QuickBooks. QQube field extensions combine report values, classify job costs, separate billing statuses, and calculate theoretical, time-tracking, and vehicle-mileage values.
Native Fields (26)
| Field Name |
|---|
| Line Estimate Quantity |
| Line Income Quantity |
| Line Purchase Order Original Quantity |
| Line Purchase Order Received Quantity |
| Line Purchase Order Open Quantity |
| Line Payroll Hours Quantity |
| Line Time Tracking Hours (Any Status) |
| Line Vehicle Miles Quantity (Any Status) |
| Line Rate |
| Line Rate (Foreign) |
| Line Rate Percent |
| Line Exchange Rate |
| Line Vehicle Mileage Billable Rate |
| Line Vehicle Standard IRS Mileage Rate |
| Line Estimate Cost Amount |
| Line Estimate Cost Amount (Foreign) |
| Line Estimate Markup Amount |
| Line Estimate Markup Percent |
| Line Estimate Income Amount |
| Line Estimate Income Amount (Foreign) |
| Line Income Amount |
| Line Income Paid Amount |
| Line Income Open Amount |
| Line Purchase Order Original Amount |
| Line Purchase Order Received Amount |
| Line Purchase Order Open Amount |
QQube Field Extensions (79)
| Field Name |
|---|
| Line Estimate Labor Hours Quantity |
| Line Job Cost Quantity |
| Line Job Cost Quantity (Billable) |
| Line Job Cost Quantity (Billed) |
| Line Job Cost Quantity (Unbilled) |
| Line Time Tracking Hours (Not Billable) |
| Line Time Tracking Hours (Billable) |
| Line Time Tracking Hours (Billed) |
| Line Time Tracking Hours (Unbilled) |
| Line Vehicle Miles Quantity (Not Billable) |
| Line Vehicle Miles Quantity (Billable) |
| Line Vehicle Miles Quantity (Billed) |
| Line Vehicle Miles Quantity (Unbilled) |
| Line Income Theoretical [Worker Rate] Rate |
| Line Income Theoretical [Job Rate] Rate |
| Line Income Theoretical [Item Rate] Rate |
| Line Time Tracking Service Rate [Worker Billing Rate] |
| Line Time Tracking Service Rate [Customer:Job Price Level] |
| Line Time Tracking Service Rate [Item Sales Price] |
| Line Estimate Cost Labor Amount |
| Line Estimate Cost Materials Amount |
| Line Credits Applied On Document |
| Line Credit Memo Applied To Document |
| Line Payments Applied On Document |
| Line Payments Applied To Document |
| Line Discounts Applied On Document |
| Line Discounts Applied To Document |
| Line Credit Unapplied Amount |
| Line Job Cost Amount |
| Line Job Cost Amount (Billable) |
| Line Job Cost Amount (Billed) |
| Line Job Cost Amount (Unbilled) |
| Line Job Cost Amount (No Billable Status) |
| Line Job Cost Paid Amount |
| Line Job Cost Paid Amount (Billable) |
| Line Job Cost Paid Amount (Billed) |
| Line Job Cost Paid Amount (Unbilled) |
| Line Job Cost Open Amount |
| Line Job Cost Materials Amount |
| Line Job Cost Materials Amount (Billable) |
| Line Job Cost Materials Amount (Billed) |
| Line Job Cost Materials Amount (Unbilled) |
| Line Job Cost Labor Amount |
| Line Job Cost Labor Amount (Billable) |
| Line Job Cost Labor Amount (Billed) |
| Line Job Cost Labor Amount (Unbilled) |
| Line Job Cost Other Amount |
| Line Job Cost Other Amount (Billable) |
| Line Job Cost Other Amount (Billed) |
| Line Job Cost Other Amount (Unbilled) |
| Line Income Theoretical [Worker Rate] Value |
| Line Income Theoretical [Worker Rate] Value (Billed) |
| Line Income Theoretical [Worker Rate] Value (Unbilled) |
| Line Income Theoretical [Job Rate] Value |
| Line Income Theoretical [Job Rate] Value (Billed) |
| Line Income Theoretical [Job Rate] Value (Unbilled) |
| Line Income Theoretical [Item Rate] Value |
| Line Income Theoretical [Item Rate] Value (Billed) |
| Line Income Theoretical [Item Rate] Value (Unbilled) |
| Line Time Tracking Billing [Worker Rate] Value (Not Billable) |
| Line Time Tracking Billing [Worker Rate] Value (Billable) |
| Line Time Tracking Billing [Worker Rate] Value (Billed) |
| Line Time Tracking Billing [Worker Rate] Value (Unbilled) |
| Line Time Tracking Billing [Job Rate] Value (Billable) |
| Line Time Tracking Billing [Job Rate] Value (Billed) |
| Line Time Tracking Billing [Job Rate] Value (Unbilled) |
| Line Time Tracking Billing [Item Rate] Value (Billable) |
| Line Time Tracking Billing [Item Rate] Value (Billed) |
| Line Time Tracking Billing [Item Rate] Value (Unbilled) |
| Line Vehicle Mileage Billing Value (Any Status) |
| Line Vehicle Mileage Billing Value (Not Billable) |
| Line Vehicle Mileage Billing Value (Billable) |
| Line Vehicle Mileage Billing Value (Billed) |
| Line Vehicle Mileage Billing Value (Unbilled) |
| Line Vehicle Standard IRS Mileage Value (Any Status) |
| Line Vehicle Standard IRS Mileage Value (Not Billable) |
| Line Vehicle Standard IRS Mileage Value (Billable) |
| Line Vehicle Standard IRS Mileage Value (Billed) |
| Line Vehicle Standard IRS Mileage Value (Unbilled) |
Power BI and Excel Power Pivot Measures
The prepared Job Cost Details examples include 399 visible DAX measures in 11 display folders. Hidden measures are not included.
Included Dimensions
Calendars
Document
| Document Attributes | Line Attributes | Geography |
Lists
| Account | Class | Company |
| Currency | Customer | Customer Rep |
| Employee | Item | Job |
| Job Rep | Other Name | Payroll Item |
| Sales Rep | Ship Method | Source Name |
| Template | Terms | UofM |
| Vehicle | Vendor |
Linked Information
| Job Cost Linked Transactions | Account (Cash Source) |
Technical Details
| Model Structure | One Job Cost Details FACT table with related dimensions and relationships already included |
|---|---|
| Integrated Analytics | Job cost, payroll hours, time tracking, vehicle mileage, Purchase Orders, Accounts Receivable, and Accounts Payable |
| Cost Classification | Materials, labor, and other costs are separated by item type |
| DAX Availability | Power BI and Excel Power Pivot examples |
Expected Result
Open the prepared example and analyze estimated, actual, committed, paid, open, and theoretical job values at the transaction-line level.
The FACT table, dimensions, relationships, fields, QQube extensions, and measures are already included.
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