Model Summary
The QQube Trial Balance (All Dates) Data Model provides debit and credit balances from the QuickBooks Trial Balance report using an all-dates scope. It is designed for reviewing the overall health and integrity of a QuickBooks file.
| Model Type | Trial Balance for all dates |
|---|---|
| Record Coverage | Company and account balances from the QuickBooks Trial Balance report |
| Date Coverage | All dates |
| Accounting Basis | Accrual or cash, according to the QuickBooks reporting preference |
| Application Availability | Excel with the QQube Add-In |
| Primary Use | Review debit and credit balances across the complete report period |
Best Used For
- Reviewing a traditional Trial Balance for all dates.
- Checking the overall health of a QuickBooks file.
- Reviewing bank and other control-account balances.
- Comparing debit and credit balances by account.
- Supporting file-integrity review in Excel.
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 an all-dates reporting scope.
- Follows the cash or accrual reporting basis selected in QuickBooks.
- Is pulled automatically when the Financial Summary data model is selected in the QQube Configuration Tool.
All-Dates Logic
This model uses the QuickBooks Trial Balance report for all dates.
It is pulled automatically when the Financial Summary data model is selected in the QQube Configuration Tool.
Primary Model Fields
The model includes two native balance fields.
Native Fields (2)
| Balance Fields |
|---|
|
Included Dimensions
Lists
| Account | Company |
Technical Details
| Model Structure | One prepared Trial Balance (All Dates) table with related Account and Company dimensions |
|---|---|
| Source Report | QuickBooks Trial Balance |
| Date Basis | All dates |
| Accounting Basis | Cash or accrual according to QuickBooks preferences |
| QQube Extraction | Automatically included when the Financial Summary data model is selected |
| Application | Excel with the QQube Add-In |
| Primary Values | Debit and Credit |
| DAX Support | None |
Expected Result
Customers can review debit and credit balances by account and company across the all-dates Trial Balance report.
The prepared table, Account and Company dimensions, relationships, and native fields 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