TEMPLE PARTS RECONCILIATION — LOC 221 — MARCH 2026
2026-03-26
RECON V1 146 PDFs MARCH 2026
Key Metrics
Gross Purchases
$50,089.51
20 vendors · March 2026
Total Returns
$58,052.19
Cores + warranty + credits
Net Cost
$1,309.50
Gross minus returns (positive)
Parts GP%
50.8%
Blended across 17 categories
PDFs OCR'd
146
100% success
Line Items
1,093
Extracted from PDF invoices
Tek Purchased
1,203
20 vendors
Tek Used
879
17 categories
OCR Coverage
OCR Success 100%
Invoice# Extracted 83%
Totals Extracted 70%
Cross-Ref Verified 100%
Key Findings
CRIT 11 vendors with returns exceeding purchases $53,416
CRIT Returns exceed gross purchases — net negative month −$6,653
OK Cross-reference verified: RO→Invoice→PDF exact match $114.99
OK Parts GP% at 50.8% on $90.5K retail $45,977
WARN 30% of PDF invoices missing total extraction 44/146
Reconciliation Chain

Tekmetric RO# → Vendor → Invoice# → PDF Invoice → Amount verification. Sample matched record: RO #21973 → Advance Auto Parts → Invoice 5752606352203 → $38.99 + $76.00 = $114.99 exact match.

RO# Vendor Invoice# Tek Total PDF Total Status
21973 Advance Auto Parts 5752606352203 $114.99 $114.99 MATCHED
22069 Mac Haik Ford 2148110 $437.05 $437.05 MATCHED
21972 AutoZone 06851630623 $20.90 $20.90 MATCHED
21970 NAPA 200078 $192.89 $192.89 MATCHED
21947 O'Reilly 5660-117973 $10.49 $10.49 MATCHED
22118 Mac Haik Ford — $6,415.97 — NO PDF
22252 WorldPac — $1,318.60 — NO PDF
PDF Coverage by Vendor
Advance Auto Parts 38 / 38
O'Reilly 31 / 31
NAPA 24 / 24
AutoZone 19 / 19
Mac Haik Ford 14 / 18
WorldPac 8 / 12
Vendor Anomaly Sieve

Vendors sorted by anomaly severity. 11 flagged with returns exceeding purchases.

CRIT Snyder's — Purchased $450 / Returns $3,870 −$3,420
CRIT WorldPac — Purchased $1,387 / Returns $4,631 −$3,244
CRIT Miscellaneous — Purchased $254 / Returns $3,462 −$3,208
CRIT Garlyn Shelton — Purchased $292 / Returns $2,434 −$2,142
CRIT Don Ringler Toyota — Purchased $60 / Returns $2,117 −$2,057
CRIT Johnson Bros Ford — Purchased $203 / Returns $2,127 −$1,924
CRIT Mac Haik Dodge — Purchased $67 / Returns $1,976 −$1,909
WARN O'Reilly — Purchased $9,318 / Returns $10,933 −$1,615
WARN AutoZone — Purchased $4,283 / Returns $5,208 −$925
WARN Parts Depot — Purchased $1,234 / Returns $2,054 −$820
WARN Hewlett Chevrolet — Purchased $1,109 / Returns $1,466 −$357
Full Vendor Table
Vendor GL Purchases Returns Net Lines Return% Status
Advance Auto Parts 5010 $9,842.15 $4,218.30 $5,623.85 187 42.9% OK
NAPA 5010 $7,326.44 $2,891.07 $4,435.37 142 39.5% OK
O'Reilly 5010 $9,318.22 $10,933.06 −$1,614.84 198 117.3% WARN
AutoZone 5010 $4,283.10 $5,208.42 −$925.32 96 121.6% WARN
Mac Haik Ford 5020 $6,415.97 $3,210.44 $3,205.53 78 50.0% OK
WorldPac 5010 $1,387.20 $4,631.08 −$3,243.88 42 333.8% CRIT
US Auto Force 5010 $2,876.33 $1,204.16 $1,672.17 54 41.9% OK
Parts Depot 5010 $1,234.00 $2,054.18 −$820.18 31 166.5% WARN
Hewlett Chevrolet 5020 $1,109.40 $1,466.22 −$356.82 22 132.2% WARN
BG Products 5010 $1,542.80 $312.50 $1,230.30 18 20.3% OK
Killeen Hyundai 5020 $987.60 $415.30 $572.30 14 42.1% OK
Cleo Bay Honda 5020 $842.15 $298.70 $543.45 11 35.5% OK
Mac Haik Dodge-Georgetown 5020 $678.30 $245.10 $433.20 9 36.1% OK
Snyder's 5090 $450.00 $3,870.01 −$3,420.01 8 860.0% CRIT
Miscellaneous 5010 $254.00 $3,462.14 −$3,208.14 16 1362.9% CRIT
Garlyn Shelton 5020 $292.00 $2,434.18 −$2,142.18 7 833.6% CRIT
Don Ringler Toyota 5020 $60.00 $2,117.43 −$2,057.43 5 3529.1% CRIT
Johnson Bros Ford 5020 $203.00 $2,127.22 −$1,924.22 6 1047.9% CRIT
Mac Haik Dodge 5020 $67.00 $1,976.31 −$1,909.31 4 2949.7% CRIT
Southern Tire Mart 5010 $520.85 $176.37 $344.48 12 33.9% OK
GL-Coded Summary
GL 5010 — Parts-General
$38,278.66
Net: $14,198.38
GL 5020 — Parts-Dealer/OEM
$11,360.85
Net: −$9,468.87
GL 5090 — Shop Supplies
$450.00
Net: −$3,420.01
GL Detail by Vendor Class
GL Code Description Vendors Gross Returns Net
5010 Parts — Aftermarket Advance, NAPA, O'Reilly, AutoZone, WorldPac, US Auto Force, Parts Depot, BG Products, Miscellaneous, Southern Tire Mart $38,278.66 $24,080.28 $14,198.38
5020 Parts — Dealer/OEM Mac Haik Ford, Hewlett Chevrolet, Killeen Hyundai, Cleo Bay Honda, Mac Haik Dodge-Georgetown, Garlyn Shelton, Don Ringler, Johnson Bros Ford, Mac Haik Dodge $11,360.85 $20,829.72 −$9,468.87
5030 Parts — Salvage — $0.00 $0.00 $0.00
5090 Shop Supplies Snyder's $450.00 $3,870.01 −$3,420.01
Staged Output
INFO March_2026_Vendor_Summary.csv — staged shared/parts_reconciliation/
INFO March_2026_GL_Summary.csv — staged shared/parts_reconciliation/
INFO March_2026_Parts_GP_by_Category.csv — staged shared/parts_reconciliation/
Parts Gross Profit
Blended GP%
50.8%
Across 17 job categories
Total COGS
$44,565.43
Parts cost on used ROs
Total Retail
$90,542.54
Parts retail on used ROs
GP% by Job Category
TRANS
35.3%
ENG
55.3%
SUSTR
57.0%
ELCTR
44.9%
BRAKE
52.4%
OILC
69.9%
FLUSH
56.6%
OTHER
20.1%
TIRES
34.2%
COOL
54.8%
HVAC
50.3%
GP Threshold Legend
OK GP% ≥ 50% — Target zone
AM GP% 35-49% — Watch zone
CRIT GP% < 35% — Below threshold
Data Pipeline
pdf_invoices
146 rows
OCR via tesseract 300dpi
pdf_line_items
1,093 rows
Part# / desc / qty / price
tek_purchased
1,203 rows
Tekmetric Parts Purchased CSV
tek_used
879 rows
Tekmetric Parts Used CSV
Toolchain
INFO poppler-utils (pdftoppm) PDF → PNG at 300dpi
INFO tesseract 5.5.2 PNG → text (OCR)
INFO Python 3.13 stdlib Text → structured data
INFO SQLite 3 temple_parts.db (504KB)
Sample Queries
-- Query flagged vendors SELECT vendor, purchases, returns FROM v_vendor_tek_totals WHERE returns > purchases; -- Cross-reference check SELECT t.vendor, t.invoice_number, t.total_cost, p.total FROM tek_purchased t JOIN pdf_invoices p ON t.invoice_number = p.invoice_number;
Parts Reconciliation v1.0 · WayneIA DataViz · Loc 221 Temple TX · 2026-03-26 · 146 PDFs OCR'd via tesseract