Profit and Loss by Job Data Model

Overview of the QuickBooks Profit and Loss by Job Data Model

The Profit and Loss by Job flexible period data model contains only profit and loss accounts - as opposed to the Job Cost Details data model which contains balance sheet accounts used for expense accruals.

This replaces the Profit and Loss by Job Freestyle option used in earlier versions of QQube. It is more efficient to load, and specifically designed for Power BI and Power Pivot.

Features

• Over 250 available fields
• 3 base measures
• 219 Additional DAX measures for Power/Pivot and Power BI
• Aggregated by Day for any number of years
• Actual and Budget
• Home and Foreign Currencies

Output Examples

Schema

AVAILABLE FIELDS	DIMENSION DETAIL LINKS
	Dates and Calendar Dimensions: Job End Date Job Projected End Date Job Start Date More Info on Calendars
	Document Based Dimensions:  NONE
	List Based Dimensions:  Account (Profit and Loss) Company Customer Customer Rep Job Job Rep
	Linked Information:  NONE

Additional DAX Measures for PowerPivot and Power BI