Audit Trail Data Model

Overview of the QuickBooks Audit Trail Data Model

The Audit Trail Analytic makes it easy to slice and dice the historical transaction changes - something that isn't possible by even exporting the QB Audit Trail Report to Excel.

The date range to extract should be kept to a minimum - and only for what is needed - as it takes a while to extract the audit trail information out of QuickBooks.

Features

• Over 1250 available fields
• 10 Measures including 8 not available in QuickBooks
• DAX measures for Power/Pivot and Power BI
• Posting and Non-Posting Transactions
• Slice and Dice in dozens of ways not possible in QuickBooks

Output Examples

Schema

AVAILABLE FIELDS	DIMENSION DETAIL LINKS
	Dates and Calendar Dimensions: Audit Trail Date Audit Trail Time 52/53 Tax Year Billed Date Due Date Expected Date Fiscal Year Transaction Date Job End Date Job Projected End Date Job Start Date More Info on Calendars
	Document Based Dimensions:  Document Attributes Line Attributes Geography
	List Based Dimensions:  Account Account (Summary) Bin Location Class Company Customer Customer Rep Employee Item Item Sales Tax Code Job Job Rep Payment Method Payroll Item Sales Rep Sales Tax Item Ship Method Terms Vendor
	Linked Information:  NONE

Additional DAX Measures for PowerPivot and Power BI