Model Summary
The QQube Balance Sheet Flexible Period Data Model provides a traditional Balance Sheet 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 Balance Sheet |
|---|---|
| Date Coverage | Any number of years configured in the QQube Configuration Tool |
| Aggregation | Account and day |
| Primary Values | Actual, Budget, and Foreign |
| QuickBooks Availability | QuickBooks Enterprise |
| Primary Use | Build dynamic Balance Sheet reports without fixed monthly columns |
Best Used For
- Building traditional Balance Sheet statements with dynamic reporting periods.
- Analyzing daily, weekly, monthly, quarterly, and yearly balances.
- Comparing actual and budget values.
- Reviewing foreign-currency balances.
- Using current, previous-period, and previous-year reporting shortcuts.
- Reporting across more than three years.
Key Capabilities
- Aggregates Balance Sheet values by account and day.
- Supports any number of configured years.
- Includes Actual, Budget, and Foreign base measures.
- Supports dynamic calendar reporting in Power BI and Excel Power Pivot.
- Provides current, previous-period, previous-year, and comparison measures.
- Is specifically designed for Power BI and Excel Power Pivot.
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 three base measures.
Base Measures (3)
| Actual | Budget | Currency |
|---|---|---|
|
|
|
Power BI and Excel Power Pivot Measures
The prepared Balance Sheet Flexible Period examples include 74 visible DAX measures in seven 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 (Balance Sheet) | Company |
Technical Details
| Model Structure | One prepared Balance Sheet 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 | 3 |
| DAX Support | 74 visible measures |
Expected Result
Customers can immediately build dynamic Balance Sheet reports using Actual, Budget, and Foreign values across any configured number of years.
The prepared table, Account and Company dimensions, relationships, three 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