Model Summary
The QQube Trial Balance Data Model provides the current debit and credit balances for QuickBooks accounts. It is based on the QuickBooks Trial Balance report and uses the as-of date configured in QQube.
| Model Type | Current Trial Balance |
|---|---|
| Record Coverage | Company and account balances from the QuickBooks Trial Balance report |
| Snapshot Date | As-of date selected in the QQube Configuration Tool |
| Accounting Basis | Accrual or cash, according to the QuickBooks reporting preference |
| Primary Use | Review current account debit and credit balances |
Best Used For
- Reviewing current account balances.
- Checking bank and other control accounts.
- Comparing debit and credit balances by account.
- Producing a traditional Trial Balance.
- Refreshing a daily Trial Balance snapshot.
Key Capabilities
- Uses the QuickBooks Trial Balance report as its source.
- Includes more than 75 Company and Account fields.
- Provides separate Debit and Credit values.
- Uses the configured QQube as-of date.
- Follows the cash or accrual reporting basis selected in QuickBooks.
- Provides prepared hierarchy measures for Power BI and Excel Power Pivot.
Current Snapshot Logic
This model represents the Trial Balance as of one configured date.
The as-of date is controlled in the QQube Configuration Tool. The model is commonly refreshed daily to provide current balances.
Primary Model Fields
The model includes two native balance fields.
Native Fields (2)
| Balance Fields |
|---|
|
Power BI and Excel Power Pivot Measures
The prepared Trial Balance examples include 6 visible DAX measures in two display folders. Hidden measures are not included.
| Measure Folder | Visible Measures |
|---|---|
| .Base Measures | 3 |
| .Base Measures For Hierarchies | 3 |
Included Dimensions
Lists
| Account | Company |
Technical Details
| Model Structure | One prepared Trial Balance table with related Account and Company dimensions |
|---|---|
| Source Report | QuickBooks Trial Balance |
| Date Basis | Current snapshot using the configured as-of date |
| Accounting Basis | Cash or accrual according to QuickBooks preferences |
| Primary Values | Debit and Credit |
| DAX Support | 6 visible measures for Power BI and Excel Power Pivot |
Expected Result
Customers can immediately review current debit and credit balances by account and company.
The prepared Trial Balance table, Account and Company dimensions, relationships, native fields, 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