The QQube Data Warehouse connects to QuickBooks to extract available posting and non-posting payroll 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 Payroll Report.
Our QQube Configuration Tool includes examples for Excel, PowerPivot, Power BI, Tableau, Crystal Reports, and Access. Some are displayed below.
There is no need to deal with tables, relationships, or data dictionaries, and you will not find these capabilities in Enterprise Advanced Reporting
Payroll
- Payroll Registers
- Liability or Fringe Reconciliation
- Analyze Overtime Hours, Wage Categories
- Employee Weeks in Service, Vacation and Sick Hours
Features
- Over 850 Available Fields
- 30 Total Measures including 20 not available in QuickBooks reports
- 393 Additional DAX Measures for Power Pivot and Power BI
- Includes posting and non-posting including payroll adjustments
Compare to a Connector
An ODBC connector extracts and displays the raw text information available from the Intuit SDK, but this kind of functionality is not directly available in the SDK.
QQube performs magic to retrieve QuickBooks Payroll Information, and mold it into data models that you can create payroll registers and reconcile liabilities.
QQube Schema
Custom QuickBooks Payroll Register Example in Excel
Traditional Payroll Register using Columns or Rows
Custom QuickBooks Payroll Overview Example in Power BI
Wages and Hours, Historical Analysis
Custom QuickBooks Payroll Liabilities Reconciliation Example in Excel
Analysis of Accrued and Paid Liabilities
Custom QuickBooks Liability Reconciliation Example in Power BI
Visual Reconciliation Status
Custom QuickBooks Wages by Period Example in Power BI
Quarter of Any Time Comparison
