Profit and Loss (Flexible Period) Data Model

Modified on Sun, 7 Jul at 2:36 AM

Overview of QuickBooks Profit and Loss (Flexible Period) Data Model

Traditional Profit and Loss Standard data model, aggregated by account by day.


The number of years is controlled in the QQube Configuration Tool and is only available for QuickBooks Enterprise Users.


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


Features

  • Aggregated by day for any number of years you designate in the QQube Configuration Tool 
  • Specifically designed for Power Pivot and Power BI
  • 4 basic QQube measures:
    • Actual
    • Budget
    • Forecast
    • Actual Foreign
  • 251 DAX measures for Power/Pivot and Power BI


Output Examples

  • Traditional Profit and Loss with EBITDA
  • Shortcuts e.g.  Current Month, Last Month, Previous Year Month, Month to Date, Year to Date, etc
  • Compare Actuals vs Budget including % of Sales


Schema

AVAILABLE FIELDS (DAX Measures)DIMENSION DETAIL LINKS
Additional DAX measures for the QQube for QuickBooks Profit and Loss (Flexible Period) Data Model

Dates and Calendar Dimensions:

  • NONE

Document Based Dimensions: 

  • NONE

List Based Dimensions: 

Linked Information: 

  • NONE

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article