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 |
- View all Statement of Cash Flow Standard Period DAX measures
- Learn how QQube DAX measures are constructed
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 |
| Prepared DAX Measures | 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.
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