QQube Audit Trail Details for QuickBooks | CLEARIFY

QQube for QuickBooks Audit Trail Details

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

Attributes and Fields

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

Notes

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.