Balance Sheet by Class (Standard Period) Data Model

Modified on Wed, 29 Jul at 8:35 PM

Model Summary

The QQube Balance Sheet by Class Standard Period Data Model provides a traditional three-year Balance Sheet with Actual values analyzed by Class. It includes fixed shortcut measures and 36 configured monthly periods.

Model Type	Three-year Balance Sheet by Class Standard Period financial statement
Period Coverage	36 monthly periods controlled in the QQube Configuration Tool
Primary Values	Actuals by Class
Prepared Excel Measures	61
Visible DAX Measures	73
Primary Use	Prepare and compare Balance Sheet results by Class across three financial years

Best Used For

Preparing a traditional three-year Balance Sheet by Class.
Reviewing monthly, quarterly, and yearly balances by Class.
Filtering Balance Sheet results by Class.
Displaying Classes side by side or across report columns.
Using fixed shortcuts such as Current Month, Last Month, and Previous Year Month.
Analyzing current assets, current liabilities, working capital, and current ratio in Power BI or Excel Power Pivot.

Key Capabilities

Includes 36 monthly periods across three years.
Provides 10 current, prior-period, and previous-year shortcut measures.
Includes monthly, quarterly, and yearly Actual measures.
Supports filtering and comparison by Class.
Includes 61 prepared Excel measures.
Provides 73 visible DAX measures for Power BI and Excel Power Pivot.
Includes prepared DAX comparisons and liquidity calculations.
Includes the Excel Add-In Presentation Clean-Up Tool.

Three-Year Period Logic

The 36 monthly periods are controlled in the QQube Configuration Tool.

The displayed month and year labels change with the configured financial reporting range. The prepared model retains the same measure structure for Periods 01 through 36, Quarters 1 through 4 for each of three years, and Years 1 through 3.

QuickBooks Data Limitations

Budget values are not available for Balance Sheet by Class reporting in QuickBooks.

This model therefore includes Actual values only.

Prepared Excel Measures

The Excel and Excel PivotTable model includes 61 prepared measures. Repeating monthly, quarterly, and yearly measures are summarized below instead of listing every dated field separately.

Shortcut Measures (10)

Current and Prior-Period Measures	Previous-Year Measures
Current Month Actuals Current Quarter Actuals Current Year Actuals Last Month Actuals Last Quarter Actuals	Previous Year Month Actuals Previous Year Quarter Actuals Previous Year Actuals Previous Year Last Month Actuals Previous Year Last Quarter Actuals

Specific Monthly Period Measures (36)

Actuals
Periods 01-36 Actuals

Specific Quarter Measures (12)

Actuals
Quarters 1-4 for Years 1-3 Actuals

Specific Year Measures (3)

Actuals
Years 1-3 Actuals

Power BI and Excel Power Pivot Measures

The prepared Balance Sheet by Class Standard Period examples include 73 visible DAX measures in four display folders. Hidden measures are not included.

Measure Folder	Visible Measures
Comparison Measures	8
Period/Month Measures	44
Quarter Measures	16
Year Measures	5

Included Dimensions

Lists

Account (Balance Sheet)

Class

Company

Technical Details

Model Structure	One prepared Balance Sheet by Class Standard Period table with related Account, Class, and Company dimensions
Financial Model Type	Three-year standard financial statement by Class
Aggregation	Monthly
Period Range	36 configured monthly periods
Excel Availability	Available for Excel and Excel PivotTables
Prepared Excel Measures	61
DAX Support	73 visible measures for Power BI and Excel Power Pivot
Excel Add-In	Includes the Presentation Clean-Up Tool

Expected Result

Customers can immediately build a traditional three-year Balance Sheet by Class using Actual, monthly, quarterly, yearly, and shortcut values.

The prepared financial statement table, Account, Class, and Company dimensions, relationships, 61 Excel measures, and 73 visible DAX measures are already included.