The QQube Data Warehouse connects to QuickBooks to extract relevant purchasing and accounts payable data transforming it into several data models containing fields that you can just drag and drop in the tool of your choice to create any type of custom QuickBooks Vendor Purchases or Accounts Payable Report:
- Purchases – includes the applicable QuickBooks posting purchases transactions and open purchase orders
- Open Purchase Orders – a variety of details based upon open purchase orders only
- Accounts Payable – which gives you granular line-item information for A/P transactions and pre-check reporting capabilities
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.
Purchases
- Vendor Profiles
- Item Rate Purchase Analysis
- Purchasing Patterns
- Discounts
Features
- Over 1,050 Available Fields
- 22 Total Measures including 10 not available in QuickBooks reports
- 208 Additional DAX Measures for Power Pivot and Power BI
- All Transactions with Items
Open Purchase Orders
- Group By Daily, Weekly, Monthly Expecting Dates
- Remaining Job Commitments
- Open Purchase Orders Only
Features
- Over 750 Available Fields
- 16 Total Measures including 7 not available in QuickBooks reports
- 54 Additional DAX Measures for Power Pivot and Power BI
Accounts Payable
- Aging by Due Date and Transaction Date Side by Side
- Full Vendor Notes
- Average Days Past Due vs Average Terms
- Pre-Check Reporting
- Filter by Job and Job Attributes
Features
- Over 850 Available Fields
- 22 Total Measures including 9 not available in QuickBooks reports
- 35 Additional DAX Measures for Power Pivot and Power BI
Compare to a Connector
An ODBC connector extracts and displays the raw text information into a series of individual table-like structures with basic quantity and dollar measures.
QQube transforms all of the available raw data, and puts it together for you, while adding dozens of measures not available in any QuickBooks report.
We also include hundreds of additional measures for Power BI and PowerPivot.
Complete Data Model Details
Combine Multiple Company Files
QQube has Multi-Company Add-Ons to allow you to aggregate or filter your purchases for any number of QuickBooks files.
Custom QuickBooks Vendor Item Rate Purchase History Example in Excel
Average Rate by Period
Custom QuickBooks Rate vs Quantity Visualization in Power BI
Rate Comparison by Quantity Breakdown
Custom QuickBooks Vendor Purchases by Period Report Example in PowerPivot
Pattern Analysis by Variable Period
Custom QuickBooks Open Purchase Orders Visualization in Power BI
Open Purchase Order Expected Date buckets
Custom QuickBooks Open Purchase Orders in Excel
Traditional Listing
Custom QuickBooks Accounts Payable Visualization in Power BI
Payables Overview
Custom QuickBooks Accounts Payable Offset Report in Power BI
Pre-Check Information
