Job Cost Details Data Model

Overview of the QuickBooks Job Cost Details Data Model

Job Cost Details is one of the most comprehensive and powerful analytics in QQube because of the ability to combine multiple QuickBooks report information into one analytic.

Specific Measure Notes:

• Line Job Cost Amount - Billing Rate Based = Theoretical Qty * Billing Rate for Person who performed service
• Line Job Cost Amount - Price Level Based = Theoretical Qty * Job Assigned Price Level for Item
• Line Job Cost Materials Amount = Inventory, Assembly, and Non-Inventory Items
• Line Job Cost Labor Amount = Service Items
• Line Job cost Other Amount = Other Charge Items

Time Tracking information included:

• Item Rate - based strictly upon the service item sales price
• Billing Rate - based upon item and billing rate assigned to the vendor/employee performing the job
• Price Level Rate - based upon item and price level assigned to the customer:job

Time Tracking Calculations:

• Item Rate * Qty
• Billing Rate * Qty
• Price Level * Qty

Features

• Over 1750 available fields
• 80 Measures including 70 not available in any QuickBooks report
• 498 Additional DAX measures for Power/Pivot and Power BI
• Posting, Non-Posting, Time Tracking, Mileage, Linked Transactions
• Applied, Open, Billable, Billed, Unbilled, Theoretical Billing
• Payments and Discounts
• Home and Foreign Currencies

Output Examples

Schema

AVAILABLE FIELDS	DIMENSION DETAIL LINKS
	Dates and Calendar Dimensions: Billed Date Due Date Estimate Date Expected Date Fiscal Year Fully Paid Date Service Date Ship Date Suggested Discount Date Transaction Date Trip End Date Trip Start Date Job End Date Job Projected End Date Job Start Date More Info on Calendars
	Document Based Dimensions:  Document Attributes Line Attributes Geography
	List Based Dimensions:  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)

Additional DAX Measures for PowerPivot and Power BI