The QQube Data Warehouse connects to QuickBooks to extract relevant audit trail data and then transforms it into a complete data model containing fields that you can just drag and drop in the tool of your choice to create any type of custom QuickBooks Audit Trail report.
Our QQube Configuration Tool contains options to control the amount of Audit Trail data you want to analyze, and also includes examples for Excel, PowerPivot, Power BI, Tableau, Crystal Reports, and Access some of which are displayed below.
There is no need to deal with tables, relationships, or data dictionaries.
Custom Audit Trail Highlights
- Number of changes per transaction
- Total dollar changes per transaction or item
- Analyze activity by transaction type
- Analyze user activity by time of day
Features
- Over 1,250 Available Fields
- 10 measures including 8 not available via QuickBooks
- Additional DAX Measures for Power Pivot and Power BI
- Posting and Non-Posting Transaction Line Details
Compare to a Connector
An ODBC connector extracts and displays the raw text information available from the Intuit SDK.
QQube adds additional logic, extended details, calculated fields, and enhanced analysis capabilities into one custom QuickBooks data model.
For instance, we provide the total number of dollars or changes per transaction, or tools to analyze by user and time of day.
QQube Schema Details
Custom QuickBooks Audit Trail Example in Power BI
Data entry analysis by activity, user, and transaction
Custom QuickBooks Audit Trail Report Example in Excel
Document and Line Details including total dollar and number of changes by user or transaction
