Trial Balance (Current) Data Model

Overview of the QuickBooks Trial Balance (Current) Data Model

Traditional Trial Balance that is used to quickly assess account balances such as bank or other control accounts.  This is pulled directly from the QuickBooks report of the same name. 

Traditional Trial Balance generally automated on a daily basis. The as of date is controlled 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

Output Examples

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