General Ledger Detail Data Model

Overview of the QuickBooks General Ledger Data Model

The General Ledger Detail data model contains all posting details and does not include any non-posting transactions.

There are several features available in this Analytic that are not available in any accounting system:

• Linked Transactions - Using a Master linking number (and type), you can view the original invoice on top, and any other applied transactions, e.g. receive payment, journal entries right beneath it.
• Enhanced Descriptors - The description for the summary account of a receive payment will show "Applied to Invoice #71049 (2016-12-31)".  A Bill Payment Check will show "Applied to Bill #78654 (2017-01-08)"
• Columns for Actual, Budget, Forecast are all available, side by side.  The date for budgets and forecast is always considered as the first date of the period .e.g. 1/1/2018, or 2/1/2018
• 52/53 Tax Year - Use the 52/53 tax year dimension in conjunction with the General Ledger to produce a detailed Profit and Loss, or even detailed Balance Sheet

Features

• Over 1,500 available fields
• 16 Pre-Calculated Measures including 7 not available in QuickBooks
• 214 additional DAX measures for Power/Pivot and Power BI
• Calendar, Fiscal or 52/53 Tax Year
• Posting and Linked Transactions
• Budgets
• Applied, Open by Line and by Document
• Home and Foreign Currencies
• Advanced LIne Descriptions not available in QuickBooks

Output Examples

Schema

AVAILABLE FIELDS	DIMENSION DETAIL LINKS
	Dates and Calendar Dimensions: 52/53 Tax Year Billed Date Due Date Fiscal Year Fully Paid Date Service Date Transaction Date Job End Date Job Projected End Date Job Start Date More Info on Calendars
	Document Based Dimensions:  Document Attributes Line Attributes
	List Based Dimensions:  Account Account (Summary) Class Company Currency Customer Customer Rep Employee Item Job Job Rep Other Name Payment Method Payroll Item Sales Tax Item Site Source Name Template Vendor
	Linked Information:  General Ledger Linked Transactions

Additional DAX Measures for PowerPivot and Power BI