Alex-Consistent Sales vs. 14-Bucket Category Sales

A source-backed explanation of what each number measures, why the category summary does not foot to Alex-consistent sales, and where the remaining source-reconciliation variance sits.

Handi-Ramp · HR + HPI · posted Genius invoice revenue

Two valid numbers. Different questions.

2025 actual

HR + HPI
Alex-consistent sales$10,170.1k
14-category product sales$9,482.6k
Not in 14 categories$687.4k

2026 YTD · Sep 30

HR + HPI
Alex-consistent sales$8,502.0k
14-category product sales$7,926.7k
Not in 14 categories$575.3k

Method used

1 · Posted Genius data

Invoice status 1306; invoice date determines period; credit notes are signed negative.

2 · Alex inclusion

Bill-To CustomerGroup is HR or HPI. Exclude only AP, ARADJ, TAXEST, WEBTAX, and FREIGHT-RETURN-YR.

3 · 14-bucket taxonomy

Apply the Item Matrix plus Nathan-approved SKU family rules to Aluminum and Steel subcodes.

4 · Reconcile honestly

Freight, AVATAX-style tax, and CCFEES may remain Alex-included but have no approved product bucket.

Category bridge

2025 actual: why the category subtotal does not foot

Alex-consistent sales$10,170,058.08−14-category sales$9,482,618.19=$687,439.89
  • Freight charges — no approved product bucket$609,096.10
  • Tax charges — no approved product bucket$63,458.42
  • CCFEES (not in Alex's exclusion list)$14,885.37

2026 YTD · Sep 30: why the category subtotal does not foot

Alex-consistent sales$8,501,972.04−14-category sales$7,926,707.12=$575,264.92
  • Freight charges — no approved product bucket$465,463.66
  • Tax charges — no approved product bucket$94,696.69
  • CCFEES (not in Alex's exclusion list)$15,104.57

Source-field variance — separate from the category gap

The Matrix’s Route field and the warehouse’s current Bill-To CustomerGroupCode are different source fields. The Matrix export is aggregated and has no invoice/customer identifier, so this variance cannot yet be assigned to specific records.

PeriodMatrix Route HR + HPIWarehouse CustomerGroup HR + HPIMatrix − warehouse
2025 actual $10,443,979.05 $10,200,114.92 $243,864.13
2026 YTD $8,619,235.34 $8,726,564.06 $-107,328.72
See the 14-bucket sales behind the category subtotal
2025 Actual
Aluminum → AST - Resi Ramps (HR)$436,814.00
Aluminum → ATT - Commercial (HR)$232,197.32
Aluminum → Drop Ship (EZ & PVI)$105,115.18
Aluminum → Super Ramps*$246,210.20
Aluminum → Other Accessibility Ramps**$677,146.29
Aluminum → CVR's$1,383,512.70
Aluminum → STS$1,757,402.11
Steel → Yard Ramps - new$1,319,754.42
Steel → Yard Ramps Used$230,095.00
Steel → Super Ramps***$422,811.68
Steel → Platforms$75,893.55
Steel → Drop Ship (Bros., Fleming...)$526,072.79
Steel → Trailers$85,055.18
Steel → Other$1,984,537.77
2026 YTD through Sep. 30
Aluminum → AST - Resi Ramps (HR)$371,534.98
Aluminum → ATT - Commercial (HR)$241,937.05
Aluminum → Drop Ship (EZ & PVI)$111,501.14
Aluminum → Super Ramps*$527,764.27
Aluminum → Other Accessibility Ramps**$533,561.28
Aluminum → CVR's$1,619,597.24
Aluminum → STS$1,117,820.11
Steel → Yard Ramps - new$810,055.96
Steel → Yard Ramps Used$157,695.00
Steel → Super Ramps***$327,961.68
Steel → Platforms$113,123.30
Steel → Drop Ship (Bros., Fleming...)$262,685.66
Steel → Trailers$54,200.68
Steel → Other$1,677,268.77