Profit and Loss Detail Data Model

Overview of the QuickBooks Profit and Loss Detail Data Model

The Profit and Loss Detail data model contains all posting details and does not include any non-posting transactions.

There are several features available in this Analytic that are not available in any accounting system:

• Columns for Actual, Budget, Forecast are all available, side by side.  The date for budgets and forecast is always considered as the first date of the period. e.g. 1/1/2018, or 2/1/2018
• 52/53 Tax Year - Follows IRS specifications.

Features

• Over 1500 available fields
• 16 Pre-Calculated Measures including 7 not available in QuickBooks
• 214 additional DAX measures for Power/Pivot and Power BI
• Calendar, Fiscal or 52/53 Tax Year
• Posting and Linked Transactions
• Budgets
• Applied, Open by Line and by Document
• Home and Foreign Currencies
• Advanced Line Descriptions not available in QuickBooks
• Covers all years - not subject to any date range limitation

Output Examples

Schema

AVAILABLE FIELDS	DIMENSION DETAIL LINKS
	Dates and Calendar Dimensions: 52/53 Tax Year Billed Date Fiscal Year Fully Paid Date Service Date Transaction Date Job End Date Job Projected End Date Job Start Date More Info on Calendars
	Document Based Dimensions:  Document Attributes Line Attributes
	List Based Dimensions:  Account (Profit and Loss) Account (Summary) Class Company Currency Customer Customer Rep Employee Item Job Job Rep Other Name Payment Method Payroll Item Source Name Template Vendor
	Linked Information:  NONE

Additional DAX Measures for PowerPivot and Power BI