Statement of Cash Flows (Standard Period) Data Model

Modified on Wed, 29 Jul at 8:22 PM

Model Summary

The QQube Statement of Cash Flow Standard Period Data Model provides a three-year Statement of Cash Flows with beginning balance, cash activity, and ending balance values. 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 Standard Period financial statement
Period Coverage	36 monthly periods controlled in the QQube Configuration Tool
Primary Values	Beginning Balance, Cash Activity, and Ending Balance
Prepared Excel Measures	84
Visible DAX Measures	88
Primary Use	Review cash-flow activity and balances across 36 periods side-by-side

Best Used For

Preparing a three-year Statement of Cash Flows.
Reviewing 36 monthly periods side-by-side.
Comparing beginning balance, cash activity, and ending balance by period.
Reviewing current, last-period, and previous-year-period cash activity.
Drilling from cash-flow sections to account-level detail.
Building Excel PivotTable, Power BI, and Excel Power Pivot financial reports.

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.
Includes 84 prepared Excel measures.
Provides 88 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 structure.

QuickBooks shows period activity. QQube adds beginning balance and ending balance values 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 Standard Period examples include 88 visible DAX measures in two display folders. Hidden measures are not included.

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

Included Dimensions

Lists

Account (Cash Flow)

Company

Technical Details

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

Expected Result

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

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