Model Summary
The QQube Profit and Loss Flexible Period Data Model provides a traditional Profit and Loss structure aggregated by account and day. It supports dynamic reporting across any number of years in Power BI and Excel Power Pivot.
| Model Type | Flexible-period Profit and Loss |
|---|---|
| Date Coverage | Any number of years configured in the QQube Configuration Tool |
| Aggregation | Account and day |
| Primary Values | Actual, Budget, Forecast, and Foreign |
| QuickBooks Availability | QuickBooks Enterprise |
| Primary Use | Build dynamic Profit and Loss reports without fixed monthly columns |
Best Used For
- Building traditional Profit and Loss statements with dynamic reporting periods.
- Analyzing daily, weekly, monthly, quarterly, and yearly results.
- Comparing actual, budget, and forecast values.
- Reviewing foreign-currency results.
- Calculating EBITDA and percentage-of-sales comparisons.
- Reporting across more than three years.
Key Capabilities
- Aggregates Profit and Loss activity by account and day.
- Supports any number of configured years.
- Includes Actual, Budget, Forecast, and Foreign base measures.
- Supports dynamic calendar reporting in Power BI and Excel Power Pivot.
- Provides current, previous-period, previous-year, and comparison measures.
- Replaces the earlier Profit and Loss Freestyle model.
- Loads more efficiently than the earlier Freestyle model.
Flexible Period Logic
This model does not use fixed monthly columns.
Values are aggregated by day so Power BI and Excel Power Pivot can group them into daily, weekly, monthly, quarterly, yearly, or other dynamic reporting periods.
QuickBooks and Application Availability
This model is available only for QuickBooks Enterprise users.
It is specifically designed for Power BI and Excel Power Pivot. It is not available through the regular QQube Excel Add-In worksheet model.
Primary Model Fields
The flexible-period model contains four base measures.
Base Measures (4)
| Actual | Planning | Currency |
|---|---|---|
|
|
|
Power BI and Excel Power Pivot Measures
The prepared Profit and Loss Flexible Period examples include 228 visible DAX measures in eight display folders, plus one Power BI company-filter measure without a display folder. Hidden measures are not included.
Power BI company filtering
The measure without a display folder filters the Account slicer by the selected company in Power BI. Excel Power Pivot handles company filtering automatically.
Included Dimensions
Lists
| Account (Profit and Loss) | Company |
Technical Details
| Model Structure | One prepared Profit and Loss table with related Account and Company dimensions |
|---|---|
| Financial Model Type | Flexible-period financial model |
| Aggregation | Account and day |
| Date Range | Any number of configured years |
| QuickBooks Edition | QuickBooks Enterprise |
| Application Availability | Power BI and Excel Power Pivot |
| Regular Excel Availability | Not available through the QQube Excel Add-In worksheet model |
| Base Measures | 4 |
| DAX Support | 228 visible measures |
Expected Result
Customers can immediately build dynamic Profit and Loss reports using Actual, Budget, Forecast, and Foreign values across any configured number of years.
The prepared table, Account and Company dimensions, relationships, four base measures, and visible DAX measures are already included.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article