Balance Sheet (Standard Period) Data Model

Overview of the QuickBooks Balance Sheet (Standard Period) Data Model

Traditional Balance Sheet Standard data model, with shortcuts for periods e.g. Current Month, Last Month.

The 36 monthly period range is controlled in the QQube Configuration Tool.

Features

• Aggregated by Month for 36 Periods
• 122 Pre-Calculated Measures including column arrangements not possible in QuickBooks
• DAX measures for Power/Pivot and Power BI
• Excel Add-In contains Presentation Clean-Up Tool

Output Examples

Schema

AVAILABLE FIELDS	DIMENSION DETAIL LINKS
	Dates and Calendar Dimensions: NONE
	Document Based Dimensions:  NONE
	List Based Dimensions:  Account (Balance Sheet) Company
	Linked Information:  NONE