QQube pandl-class act/bud/frcst for QuickBooks | CLEARIFY

QQube for QuickBooks Profit and Loss by Class w Actual/Budget/Forecast Analytic

(QuickBooks Enterprise Only)

Features

• Aggregated by Month for 36 Periods
• 606 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
• Excel Add-In contains Presentation Clean-Up Tool

NOTE: For usage in Power/Pivot and Power BI use the Flexible Period Profit and Loss by Class data model

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

Notes

Traditional Profit and Loss Standard Analytic, but with the ability to show Budgets and Forecasts along side Actuals. This capability is not available inside of QuickBooks as it requires two different reports - one for Budget and Actual, and one for Forecast and Actual.

Filter or organize by Class.

Shortcuts for periods e.g. Current Month, Last Month.  36 Periods controlled in the QQube Configuration Tool.