Material Buyout & BOM Tracker for Plumbing Contractors

Stop Running Your Material Buyouts Out of Your Head.

If you've ever scrambled to track what's on order, what's backordered, and what the distributor actually invoiced versus what you expected — this tool was built for you. By a purchasing manager with 18 years in commercial plumbing procurement.

This isn't a generic spreadsheet. Every column, every formula, and every dropdown was designed around how plumbing purchasing actually works — BOMs, POs, distributor quotes, tier pricing, early pay terms, and invoice variances. It's the system a professional purchasing manager uses. Now you can use it too.

WHAT'S INSIDE — 6 TABS, READY TO USE

📊 Dashboard — Project info panel + 6 live KPI cards that auto-update as you work: Total BOM Value, POs Issued, Invoiced to Date, Remaining to Buy, Backorder Count, and Budget Variance. Vendor spend summary pulls totals per distributor automatically.

📋 Bill of Materials (BOM) — 50-line material tracker with dropdowns for stock status and PO status. Enter your qty and unit cost — extended cost calculates itself. Backorder items auto-flag in red. Invoice variance goes green when you're under, red when you're over.

🏷️ Vendor Quote Comparison — Side-by-side pricing from up to 3 distributors. Extended costs pull your quantities from the BOM automatically. Best price highlights in green. No more copying numbers between tabs.

📄 PO Log — Full purchase order register. Track every PO from issuance to receipt to invoice. Variance between PO amount and invoice amount calculates automatically.

💰 Tier Pricing & Early Pay Calculator — Enter list price, volume discount, project discount, early pay %, and freight. Net landed cost calculates through every step. Includes the early pay decision formula — 2/10 net 30 = 36.7% annualized return. Know when to take it every time.

📘 Instructions Tab — Color-coded guide, step-by-step workflow, and real-world purchasing tips built in.