The QQube Data Warehouse connects to QuickBooks to extract relevant inventory data transforming it into two data models containing fields that you can just drag and drop in the tool of your choice to create any type of custom QuickBooks Inventory report or Bill of Materials Explosion.
Our QQube Configuration Tool contains includes QuickBooks Inventory examples for Excel, PowerPivot, Power BI, Tableau, Crystal Reports, and Access; and it includes QuickBooks Bill of Material Explosion reports in Excel, PowerPivot and Access.
There is no need to deal with tables, relationships, or data dictionaries.
Inventory Management
- Historical Analysis tied to inventory forecasts
- Lots and Serial Numbers
- Item, Customer, Vendor First and Last Purchase Dates
- All in one reporting
- Inventory Qty and Valuation
- Sales and Purchasing
- Assembly Consumption
- Pending Assemblies
- Forecast with Expected PO and SO and exploded BOM
- Transfers and Adjustments
Features
- Over 1,750 Available Fields
- 54 Total Measures including 45 not available in QuickBooks reports
- 443 Additional DAX Measures for Power Pivot and Power BI
- Includes Posting and Non-Posting Transaction Line Details
Bill of Materials
- Total parts needed for a main assembly or sub assembly
- Explode assembly into sub-assembly and parts
- Explode to any number of sub-levels
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 have added hundreds of measures for Power BI and PowerPivot.
QQube Schema Details
Custom QuickBooks Inventory Overview Example in Power BI
Retail Value, Gross Margin ROI, Days Sales (DSI), Turnover Ratio, Inventory to Sales
Custom QuickBooks Inventory Specific Item Analysis in Power BI
Retail and Balance Sheet Value, Days Out of Stock, Gross Margin ROI, Days Sales (DSI), Turnover
Custom QuickBooks Inventory Forecast Example in PowerPivot
Combine Historical Sales, Open SO, PO, Pending Builds, Lots and Serial Numbers
Custom QuickBooks Inventory Margin Analysis Example in PowerPivot
Compare Cost vs Selling Averages, Margin/Markup KPI
Custom QuickBooks Bill of Materials Example in Excel
BOM Explosion Showing Item Quantities in Assemblies
Custom QuickBooks Bill of Materials Explosion Example in Excel
BOM Explosion by Assembly and Item
