Balance Sheet (Flexible Period) Data Model

Modified on Sun, 7 Jul at 2:36 AM

Overview of QuickBooks Balance Sheet (Flexible Period) Data Model

Traditional Balance Sheet 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.

Aggregated by Day for any number of years you designate in the QQube Configuration Tool
Specifically designed for Power Pivot and Power BI
3 basic QQube measures:
- Actual
- Budget
- Actual Foreign
82 DAX measures for Power/Pivot and Power BI

Traditional Balance Sheet
Shortcuts e.g. Current Month, Last Month, Previous Year Month, Month to Date, Year to Date, etc.
Compare Actual vs Budget

AVAILABLE FIELDS (DAX Measures)

DIMENSION DETAIL LINKS

Dates and Calendar Dimensions:

Document Based Dimensions:

List Based Dimensions:

Linked Information: