Profit and Loss - Freestyle | CLEARIFY

Profit and Loss Freestyle (QuickBooks Enterprise Only)

Overview

• Traditional BI architecture with 3 Measures: Actual, Budget, Forecast
• Exponential column arrangements not possible in QuickBooks
• 30 Additional Calculated Measures in Power BI
• Aggregated by Day (Actual, Budget Forecast) for 10 years
• 2 List Dimensions with over 100 fields for Company and Account
• Both Fiscal and 52/53 Tax Year Calendar Dimensions
• 7 Out-of-the box metrics using Power BI
• Power BI examples for cell phone readability
• Excel Add-In contains Presentation Clean-Up Tool

Purpose and Usage

Attributes and Fields

AVAILABLE FIELDS	LINKS TO MORE INFORMATION
	Dates and Calendar Dimensions: 52/53 Tax Year Dates Fiscal Year Dates
	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.

Ten years of data, counting back from the latest year chosen in the QQube Configuration Tool for Financial Summary Reports. All other Financial Summary reports in QQube are 3 year summaries by period (month for non 52/53 tax year).  

Calculations for current month, previous year, are available in the PowerBI shells.

This method of aggregating is useful when you want to create YTD and MTD to the very date you want.  Developers also favor this method as it is sometimes easier for them to create custom solutions than the "fixed" period method used in other Financial Summary Subjects.

Available Application Shells

• Microsoft Excel
• Microsoft PowerPivot 2013-2016
• Microsoft PowerBI
• Microsoft Access
• SAP Crystal Reports
• Tableau