Statement of Cash Flows Class (Standard Period) Data Model

Modified on Wed, 29 Jul at 8:38 PM

Model Summary

The QQube Statement of Cash Flow by Class Standard Period Data Model provides a three-year Statement of Cash Flows with beginning balance, cash activity, and ending balance values analyzed by Class. It displays 36 monthly periods side-by-side, a reporting structure that is not available in QuickBooks.

Model Type	Three-year Statement of Cash Flow by Class Standard Period financial statement
Period Coverage	36 monthly periods controlled in the QQube Configuration Tool
Primary Values	Beginning Balance, Cash Activity, and Ending Balance by Class
Prepared Excel Measures	84
Visible DAX Measures	86
Primary Use	Review cash-flow activity and balances by Class across 36 periods side-by-side

Best Used For

Preparing a three-year Statement of Cash Flows by Class.
Reviewing 36 monthly periods side-by-side.
Comparing beginning balance, cash activity, and ending balance by period and Class.
Reviewing current, last-period, and previous-year-period cash activity.
Filtering cash-flow results by Class.
Drilling from cash-flow sections to account-level detail.

Key Capabilities

Includes 36 monthly periods across three years.
Displays all 36 periods side-by-side in one prepared financial statement.
Provides Beginning Balance at the start of each financial year.
Provides Cash Activity and Ending Balance for every monthly period.
Provides nine current, prior-period, and previous-year shortcut measures.
Supports filtering and comparison by Class.
Includes 84 prepared Excel measures.
Provides 86 visible DAX measures for Power BI and Excel Power Pivot.

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. Cash Activity and Ending Balance are available for Periods 01 through 36. Beginning Balance is provided for Periods 01, 13, and 25, representing the start of each financial year.

QuickBooks Data Limitations

QuickBooks does not provide this 36-period Statement of Cash Flows by Class structure.

QuickBooks shows period activity. QQube adds beginning balance and ending balance values, analyzes them by Class, and presents all 36 monthly periods side-by-side.

Prepared Excel Measures

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

Shortcut Measures (9)

Current Period	Last Period	Previous Year Period
Current Period Beginning Balance Current Period Cash Activity Current Period Ending Balance	Last Period Beginning Balance Last Period Cash Activity Last Period Ending Balance	Previous Year Period Beginning Balance Previous Year Period Cash Activity Previous Year Period Ending Balance

Specific Beginning Balance Measures (3)

Beginning Balance
Periods 01, 13, and 25 Beginning Balance

Specific Cash Activity Measures (36)

Cash Activity
Periods 01-36 Cash Activity

Specific Ending Balance Measures (36)

Ending Balance
Periods 01-36 Ending Balance

Power BI and Excel Power Pivot Measures

The prepared Statement of Cash Flow by Class Standard Period examples include 86 visible DAX measures in two display folders. Hidden measures are not included.

Measure Folder	Visible Measures
Comparison Measures	2
Period/Month Measures	84

Included Dimensions

Lists

Account (Cash Flow)

Class

Company

Technical Details

Model Structure	One prepared Statement of Cash Flow by Class Standard Period table with related Account, Class, and Company dimensions
Financial Model Type	Three-year standard financial statement by Class
Aggregation	Monthly by Class
Period Range	36 configured monthly periods displayed side-by-side
Excel Availability	Available for Excel and Excel PivotTables
Prepared Excel Measures	84
DAX Support	86 visible measures for Power BI and Excel Power Pivot

Expected Result

Customers can immediately review beginning balance, cash activity, and ending balance by Class across 36 monthly periods side-by-side.

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