Pick a From / To date range or toggle individual dates below to slice the entire Grid & Chart:
Manual Price Override Audit (19,502 Lines) & Vendor Rebate Recovery
Audited across all 71,797 Nov 2-6 Sales lines ($8,206,595.17), 30,952 Oct Purchasing PO lines ($24,298,623.11), 3,308 Br 48 Inventory SKUs ($4,661,313.61) & 10,711 AP YTD lines ($25,329,019.83).
19,502 of 71,797 Nov 2-6 invoice lines (50.1% of Sales $, Overwrite Amt: -$2,086,529.76) had manual price overrides applied instead of standard matrix pricing.
30,952 PO lines across 875 Ship-From Vendors in October 2026 (`$21,341,976.39` Status R + `$2,956,646.72` Status Y) eligible for vendor volume rebate tracking.
Highest-volume November 2026 Sales Buy Lines across all 44 branches — click below to audit SKU-level pricing & overrides.
Interactive "What-If" Margin & Override Recovery Simulator
Model the bottom-line EBITDA impact of curbing manual price overrides ($847.3K in Nov 2026) and capturing vendor rebates.
Top November 2026 Customer Accounts & Price Override Share
Live key accounts from National_Wholesale_Nov_Sales.csv across 543 active customers.
| Customer Account (CSV) | Assigned Rep | Primary Buy Line | Nov 2026 Lines | Nov 2026 Sales | 1-Click Action |
|---|---|---|---|---|---|
| 65815 • PROWORKS PROCUREMENT SRVS LLC | SILWAD (Wade Silvey) | Commercial Plumbing | 138 Lines | $106,593.73 | |
| 48492 • DONNIES HEAT & AIR LLC | WERMAT (Matt Werry) | HVAC & Purge | 17 Lines | $95,715.80 | |
| 61326 • PATRIOT PIPELINE101 | MURERI (Eric Murray) | Waterworks Pipe | 45 Lines | $68,790.17 | |
| 48617 • CLEBURNE UTILITY SERVICES | ROSHEN (Henry Rose) | Utility & Valves | 14 Lines | $50,503.15 |
Automated Monday 7:00 AM Push Digests
Every Monday at 7:00 AM, each National Wholesale Supply Rep, Branch Manager, and Buyer (Janet Rodriguez, Miranda Iracheta, Wade Silvey) receives their personalized digest:
Unlimited-User License Savings & 11-Day Payback Calculator
Legacy BI vendors charge per seat plus $10k+ add-ons for Financials & Rebates. Built By Data includes Unlimited RLS Users across all 44 Sales & 57 Purchasing Branches.
Executive Sales ($8,206,595.17) & Margin Performance Command Center
Real-time validation across 116,768 National Wholesale lines: Sales Nov 2–6 ($8.21M), Purchasing Oct ($24.30M), Inventory Oct 26 Br 48 ($4.66M), and AP YTD 2026 ($25.33M).
Nov 2–6, 2026 Daily Ext Sales ($), Ext CoGS ($) & Gross Profit ($)
71,797 lines ($8,206,595.17 Ext Sales • $6,960,639.07 CoGS • $1,245,956.10 GP $) — click any date bar to cross-filter
Nov 2–6 Sales Breakdown: Matrix vs. Manual Override & Stock Split
Standard Matrix ($4,093,571.22) vs. Manual Override ($4,113,023.95) & Stock ($7,646,627.76) vs. Direct ($559,967.41)
Top 12 Branches: Volume & Secondary Metric (Click to Cross-Filter)
Click any Branch bar to cross-filter the entire Command Center, or drill straight into the Grid
Top Product Buy Lines Share & Mix (Click Slice to Cross-Filter)
Interactive Nightingale Rose / Donut / Sunburst — click any product line slice to cross-filter all visuals
Top 12 Vendors & Product Hierarchy Map (Click Block to Cross-Filter)
Area = Dollar Volume ($), Color = Rank — click any vendor block to cross-filter the dashboard
Outside Sales Reps / Buyers Volume vs. Line Velocity Quadrant
Bubble size = Secondary Metric ($). Click any rep or buyer to cross-filter
Build & Pin Your Own Interactive Charts or Tables
Select any of our 12 chart types (Combo Bar/Line, Smooth Area, Stacked Bar, Waterfall, Nightingale Rose/Donut, Sunburst, Treemap, Funnel, Radar, Bubble Scatter, Matrix Pivot, or Data Table) and drag or tap ERP columns to generate live visuals.
📌 Your Pinned Custom Visuals 2 Pinned Visuals
Custom charts & tables pinned from the Visual Studio above.
📑 Consolidated Financial Statements (P&L, Balance Sheet & GL Tie-Out)
Reconciled 100% to your ERP General Ledger Trial Balance — click any P&L row to inspect the underlying GL accounts & journal entries.
| GL Category / P&L Line Item | Actual YTD 2026 | Budget YTD 2026 | Budget Var ($) | Prior YTD 2025 | YoY % | % of Net Sales |
|---|
Vendor Volume Rebates & Special Pricing Agreement (SPA) Contract Manager
Enter new Rebate Tiers or Customer SPAs via the Contract Wizard, Bulk CSV/Excel Import, or Automated ERP Table Sync.
Crossing any tier threshold retroactively applies that higher % to 100% of eligible purchases back to Dollar $1.00:
Upload multi-bracket vendor rebate spreadsheets or deviated-cost SPA files — supports both RETRO_DOLLAR_ONE and STEPPED_MARGINAL rules.
If your team already maintains SPAs or vendor brackets inside your ERP, bbd-sync extracts those contract tables automatically on every 15-minute sync cycle.
SPA.CONTRACTS, REBATE.MATRIX, VENDOR.CREDITSp21_view_rebate_hdr, p21_view_rebate_line, p21_spapdreb (Vendor Brackets), pdsc (Customer SPAs)Step-by-step comparison of Tier Qualification Gate Vol vs. Net Payout Vol, Stepped Marginal vs. Retroactive Dollar-One, and Next Cliff Unlock Bonus.
📋 Multi-Level Rebate & SPA Audit Ledger (Click Any Row to Inspect Math or Slice SKUs)
Handles Retroactive Back-to-Dollar-One, Stepped Marginal Brackets, YoY Growth Kickers, Buy-Line Rate Splits & SPA Anti-Double-Dip Rules.
| Contract # | Calculation Engine | Vendor / Manufacturer | Multi-Tier Bracket Ladder | Gate Vol ($) | Payout Vol ($) | Unlocked Rate | Earned Rebate ($) | Audit / Slice |
|---|
VantageBridge™ Universal ETL Pipeline Scheduler & Extraction Hub (.vantagesync.json)
Customers never need legacy third-party sync utilities. VantageBridge™ provides pre-engineered .vantagesync.json ETL extraction pipelines that push SQL queries, flat-file extract rules, and 15-minute schedules straight from VantageBI™ Cloud to our lightweight vantagebridge-agent.ps1 Edge Agent or direct Cloud APIs.
For on-prem ERPs (Epicor Eclipse C:\VantageBridge\Extracts\*.csv, Prophet 21, BisTrack, Eagle, Dynamics GP, Sage 100/300). Runs via Windows Task Scheduler with outbound HTTPS TLS 1.3 only (zero inbound firewall ports).
For cloud ERPs & warehouses (Acumatica OData, Oracle NetSuite SuiteQL, QuickBooks Online, BigQuery, Snowflake, SFTP / S3). Extracted directly from the cloud on a cron schedule with zero server install.
Instead of RDP'ing into a customer's Windows Server to edit SQL queries or change Task Scheduler times, vantagebridge-agent.ps1 pulls its .vantagesync.json manifest, SQL queries, and incremental watermarks straight from VantageBI™ Cloud.
| DataItem Name | Extraction Type | Source File Path / SQL ODBC Query / Endpoint | Incremental Watermark | Last Sync Rows | Status |
|---|
Instant Ad-Hoc Flat File / CSV Upload (100% Lossless Browser OLAP Engine)
Drag and drop or select any CSV/TXT file exported from Epicor Eclipse (Sales, Purchasing, Inventory, AP), Prophet 21, Infor, NetSuite, Excel, or SQL. Our in-browser OLAP engine parses 100% of rows with exact dollar-and-cent reconciliation!
👥 Enterprise User Access & Row-Level Security (RLS) Manager
Control exactly which Branches, Sales Rep territories, and Financial modules each user can access. Click Preview as User on any row to test their exact view.
| User | Role | Row-Level Security (RLS) Filter | Module Access | Test / Impersonate |
|---|