Profit and Loss (Standard Period) Data Model

Overview of the QuickBooks Profit and Loss (Standard Period) Data Model

Traditional Profit and Loss Standard data model, with shortcuts for periods e.g. Current Month, Last Month.

The 36 monthly period range is controlled in the QQube Configuration Tool.

Features

• Aggregated by Month for 36 Periods
• 404 Pre-Calculated Measures including column arrangements not possible in QuickBooks
• DAX measures for Power/Pivot and Power BI
• Special Microsoft Access Views to get around 256 column limitations

Output Examples

Schema

AVAILABLE FIELDS	DIMENSION DETAIL LINKS
	Dates and Calendar Dimensions: NONE
	Document Based Dimensions:  NONE
	List Based Dimensions:  Account (Profit and Loss) Company
	Linked Information:  NONE