Payroll Data Model

Overview of the QuickBooks Payroll Data Model

Don't let anybody tell you that payroll information is not available from the Intuit Software Development Kit - it is.  However getting it, is not easy, or conventional.

All of the detail payroll check data is available, and about 95% of all employee fields are available.

See QuickBooks Data Availability in QQube

This data model uses the extended Employee HR Dimension which contains SSN, and employment information, which is suited to data imports, and larger payroll analysis.

Features

• Over 850 available fields
• 30 Measures including 20 not available in any QuickBooks report
• 393 Additional DAX measures for Power/Pivot and Power BI
• Posting Transactions and Non-Posting Adjustments

Output Examples

Schema

AVAILABLE FIELDS	DIMENSION DETAIL LINKS
	Dates and Calendar Dimensions: Effective Payroll Date Liability Period End Date Liability Period Start Date Pay Period End Date Pay Period Start Date Transaction Date Employee HIre Date Employee Release 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 Class Company Customer Customer Rep Employee (HR) Item Job Job Rep Payroll Item Service Item Vendor
	Linked Information:  NONE

Additional DAX Measures for PowerPivot and Power BI