Trial Balance Activity by Class Data Model

Modified on Wed, 29 Jul at 4:36 AM

Model Summary

The QQube Trial Balance Activity by Class Data Model provides monthly beginning balances, current activity, and ending balances by class across a configured three-year period. It supports actual activity analysis that is not available as a standard QuickBooks report.

Model Type	Three-year Trial Balance Activity by Class
Period Coverage	36 monthly periods controlled in the QQube Configuration Tool
Primary Values	Beginning balance, activity, ending balance, debit, and credit
Primary Use	Compare monthly Trial Balance activity and balances by class across three years

Best Used For

Reviewing beginning balance, current activity, and ending balance by class.
Comparing monthly account activity side by side.
Reviewing debit and credit activity by class.
Filtering Trial Balance activity by class.
Comparing classes side by side.
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.
Adds Class analysis to the prepared financial statement.
Includes more than 75 Company and Account fields.

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 by Class structure as a standard report.

Budget information is not included because QuickBooks does not allow budgeting for balance sheet accounts when classes are used.

Prepared Excel Measures

The Excel and Excel PivotTable model includes 174 prepared measures. Repeating period measures are summarized by range instead of listing every month separately.

Current Measures (7)

Activity	Beginning Balance	Ending Balance
Current Activity Amount	Current Beginning Debit Amount Current Beginning Credit Amount Current Beginning TB Amount	Current Ending Debit Amount Current Ending Credit Amount Current Ending TB Amount

Last Period Measures (7)

Activity	Beginning Balance	Ending Balance
Last Period Activity Amount	Last Period Beginning Debit Amount Last Period Beginning Credit Amount Last Period Beginning TB Amount	Last Period Ending Debit Amount Last Period Ending Credit Amount Last Period Ending TB Amount

Previous Year Measures (7)

Activity	Beginning Balance	Ending Balance
Previous Year Activity Amount	Previous Year Beginning Debit Amount Previous Year Beginning Credit Amount Previous Year Beginning TB Amount	Previous Year Ending Debit Amount Previous Year Ending Credit Amount Previous Year Ending TB Amount

Specific Period Measures

Activity	Ending Balance	Additional Period 01 Measure
Periods 01-36 Activity Amount	Periods 01-36 Ending Debit Amount Periods 01-36 Ending Credit Amount Periods 01-36 Ending TB Amount	Period 01 Beginning TB Amount

Power BI and Excel Power Pivot Measures

The prepared Trial Balance Activity by Class examples include 166 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	7
Current Measures	7
Previous Year Measures	7
Specific Period Measures	145

Included Dimensions

Lists

Account

Class

Company

Technical Details

Model Structure	One prepared Trial Balance Activity by Class table with related Account, Class, and Company dimensions
Financial Model Type	Three-year financial statement by Class
Aggregation	Monthly account and class activity and balances
Period Range	36 configured monthly periods
Prepared Excel Measures	174
Budget Availability	Not included
DAX Support	166 visible measures for Power BI and Excel Power Pivot

Expected Result

Customers can immediately compare beginning balances, monthly activity, ending balances, debit, and credit values by class across a configured three-year period.

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