Trial Balance (All Dates) Data Model

Modified on Sun, 7 Jul at 1:15 AM

Overview of the QuickBooks Trial Balance (All Dates) Data Model

Traditional Trial Balance that is used to determine the health of a QuickBooks file. This is pulled directly from the QuickBooks report of the same name.

It is pulled automatically when the Financial Summary data model is chosen in the QQube Configuration Tool.

It is accrual or cash depending upon the preference within QuickBooks

Features

Over 75 fields for Company and Account
2 Measures: Debit, Credit
Only for Excel with Add-In

Output Examples

Traditional Trial Balance for all dates to check the integrity of QuickBooks file

Schema

AVAILABLE FIELDS

DIMENSION DETAIL LINKS

Dates and Calendar Dimensions:

NONE

Document Based Dimensions:

NONE

List Based Dimensions:

Account
Company

Linked Information:

NONE

Additional DAX Measures for PowerPivot and Power BI

NONE