Commodity Manager
Aggregate and commodity flow management for construction. Track what was received, what was billed, and what was agreed upon — then reconcile them automatically.
The Problem
Construction projects receive hundreds or thousands of delivery tickets for aggregates and materials. Matching these against supplier invoices is tedious, error-prone, and often done too late. Duplicate tickets, billing discrepancies, and pricing errors slip through, costing projects thousands of dollars. Commodity Manager automates this reconciliation.
Features
Ticket Management
Import, list, edit, and export delivery ticket lines. Filter by material. Flag duplicates and merge them. Tickets represent quantities received on a project.
Invoice Management
Import and manage invoices with full line-item detail. View reconciliation status (e.g. "Missing Tickets"). Find potential ticket matches for invoice lines based on date, quantity tolerance, and ticket number normalization.
Contracts & POs
Create and manage commodity contracts with line-level detail: material, UOM, quantity, unit price, total price. Import contracts from files. Contract prices serve as the benchmark for checking invoice prices.
Overview Dashboard
Per-material analytics: JTD (job-to-date) received tons from tickets, project totals, daily delivery pivots, and cumulative curves comparing JTD received vs. JTD invoiced over time.
Validation Rules
Org-scoped rules that automatically flag ticket and invoice lines for review: quantity range checks, UOM validation, date validation, ticket number format checks. Users can dismiss flags per line with overrides.
Vendor & Supplier Management
Track vendors (suppliers) and supplier pricing per project, vendor, material, and UOM. Optionally include contract quantities for reference and automatic price comparison.
Import & Export
Bulk import tickets, invoices, and contracts from Excel, PDF, and CSV files. Track import history with audit logs for complete traceability.
Audit Logging
All commodity operations are tracked for compliance. Know who imported what, when tickets were flagged, and how discrepancies were resolved.
How It Works
Set Up Your Project
Create a project and configure your vendors (suppliers) who deliver materials to your site.
Import Delivery Tickets
As materials arrive on site, import delivery tickets. The system tracks quantities received by material type and flags duplicates.
Import Invoices
Import supplier invoices as they arrive. Each invoice is broken into line items for granular matching.
Record Contracts & POs
Enter contracts and purchase orders with agreed pricing. These serve as benchmarks for validating invoice prices.
Review the Dashboard
Check the Overview dashboard for received vs. invoiced discrepancies, daily delivery pivots, and cumulative JTD curves.
Validate & Reconcile
Use validation rules to catch data quality issues. Reconcile invoices against tickets using automated potential matches.
Export Reports
Export reconciliation reports, ticket summaries, and audit logs for billing review and compliance.
Frequently Asked Questions
What problem does Commodity Manager solve?
Commodity Manager ensures that what you received on site matches what you were billed. It catches discrepancies, duplicate tickets, and pricing issues before they become costly by reconciling delivery tickets against invoices automatically.
How does invoice reconciliation work?
When you import invoices, Commodity Manager automatically finds potential ticket matches for each invoice line based on date proximity, quantity tolerance, and ticket number normalization. It flags lines with no matches ("Missing Tickets") so you can investigate before approving payment.
What are validation rules?
Validation rules are org-scoped automated checks that flag ticket and invoice lines for review. They include quantity range checks, UOM validation, date validation, and ticket number format checks. Users can dismiss flags per line with overrides when exceptions are legitimate.
Can I track supplier pricing across projects?
Yes. Commodity Manager includes supplier pricing management per project, vendor, material, and UOM. You can optionally include contract quantities for reference and automatically compare invoice prices against agreed contract rates.
What file formats does Commodity Manager support?
Commodity Manager supports bulk import of tickets, invoices, and contracts from Excel (.xlsx, .xls), PDF, and CSV files. All imports are tracked in the import history with audit logs.
Ready to automate invoice reconciliation?
See how Commodity Manager catches billing discrepancies before they cost you.