Model Summary
The QQube Trial Balance Activity Data Model provides monthly beginning balances, current activity, and ending balances across a configured three-year period. It supports actual and budget analysis that is not available as a standard QuickBooks report.
| Model Type | Three-year Trial Balance Activity |
|---|---|
| Period Coverage | 36 monthly periods controlled in the QQube Configuration Tool |
| Primary Values | Beginning balance, activity, ending balance, debit, credit, actual, and budget |
| Primary Use | Compare monthly Trial Balance activity and balances across three years |
Best Used For
- Reviewing beginning balance, current activity, and ending balance together.
- Comparing monthly account activity side by side.
- Comparing actual activity with budget.
- Reviewing debit and credit activity by account.
- Analyzing balance changes across a three-year period.
Key Capabilities
- Provides a Trial Balance Activity structure not available as a standard QuickBooks report.
- Includes 36 monthly periods across three years.
- Provides current, last-period, and previous-year shortcuts.
- Includes beginning and ending Trial Balance values.
- Includes separate debit and credit values.
- Supports actual and budget reporting.
- Provides special Microsoft Access views for the wide financial structure.
Three-Year Period Logic
The 36 monthly periods are controlled in the QQube Configuration Tool.
The period labels change with the configured financial reporting range. The prepared model retains the same measure structure for Periods 01 through 36.
QuickBooks Data Limitations
QuickBooks does not provide this Trial Balance Activity structure as a standard report or the ability to compare up to 36 monthly periods side-by-side.
QQube combines beginning balance, current activity, ending balance, debit, credit, actual, and budget values in one prepared model across the configured three-year period.
Prepared Excel Measures
The Excel and Excel PivotTable model includes 348 prepared measures. Repeating period measures are summarized by range instead of listing every month separately.
Current Measures (14)
| Activity | Beginning Balance | Ending Balance |
|---|---|---|
Current Activity Amount Current Activity Budget | Current Beginning Debit Amount Current Beginning Debit Budget Current Beginning Credit Amount Current Beginning Credit Budget Current Beginning TB Amount Current Beginning TB Budget | Current Ending Debit Amount Current Ending Debit Budget Current Ending Credit Amount Current Ending Credit Budget Current Ending TB Amount Current Ending TB Budget |
Last Period Measures (14)
| Activity | Beginning Balance | Ending Balance |
|---|---|---|
Last Period Activity Amount Last Period Activity Budget | Last Period Beginning Debit Amount Last Period Beginning Debit Budget Last Period Beginning Credit Amount Last Period Beginning Credit Budget Last Period Beginning TB Amount Last Period Beginning TB Budget | Last Period Ending Debit Amount Last Period Ending Debit Budget Last Period Ending Credit Amount Last Period Ending Credit Budget Last Period Ending TB Amount Last Period Ending TB Budget |
Previous Year Measures (14)
| Activity | Beginning Balance | Ending Balance |
|---|---|---|
Previous Year Activity Amount Previous Year Activity Budget | Previous Year Beginning Debit Amount Previous Year Beginning Debit Budget Previous Year Beginning Credit Amount Previous Year Beginning Credit Budget Previous Year Beginning TB Amount Previous Year Beginning TB Budget | Previous Year Ending Debit Amount Previous Year Ending Debit Budget Previous Year Ending Credit Amount Previous Year Ending Credit Budget Previous Year Ending TB Amount Previous Year Ending TB Budget |
Specific Period Measures
| Activity | Ending Balance | Additional Period 01 Measures |
|---|---|---|
Periods 01-36 Activity Amount Periods 01-36 Activity Budget | Periods 01-36 Ending Debit Amount Periods 01-36 Ending Debit Budget Periods 01-36 Ending Credit Amount Periods 01-36 Ending Credit Budget Periods 01-36 Ending TB Amount Periods 01-36 Ending TB Budget | Period 01 Beginning TB Amount Period 01 Beginning TB Budget |
Power BI and Excel Power Pivot Measures
The prepared Trial Balance Activity examples include 343 visible DAX measures in four display folders. Hidden measures are not included. Repeating period measures are summarized by range in the companion reference.
| Measure Folder | Visible Measures |
|---|---|
| Antecedent Measures | 14 |
| Current Measures | 14 |
| Previous Year Measures | 14 |
| Specific Period Measures | 301 |
Included Dimensions
Lists
| Account | Company |
Technical Details
| Model Structure | One prepared Trial Balance Activity table with related Account and Company dimensions |
|---|---|
| Financial Model Type | Three-year financial statement |
| Aggregation | Monthly account activity and balances |
| Period Range | 36 configured monthly periods |
| Prepared Excel Measures | 348 |
| Prepared DAX Measures | 343 visible measures for Power BI and Excel Power Pivot |
| Microsoft Access | Special views are included for the wide financial structure |
Expected Result
Customers can immediately compare beginning balances, monthly activity, ending balances, debit, credit, actual, and budget values across a configured three-year period.
The prepared financial statement table, Account and Company dimensions, relationships, Excel measures, and 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