The unit price printed on a distributor invoice is often not the unit price.
Wire, lugs, fittings and fasteners are frequently billed per hundred or per thousand. Read the printed unit price literally and you will book a part at a hundred to a thousand times its real cost, then price a job off it. The failure is silent — nothing errors, the invoice total still reconciles, and the wrong number quietly poisons every quote built on it.
SolarProjeX derives unit cost from the line extension against the quantity actually shipped, which is correct whatever unit of measure the distributor used. Lines that were never shipped are not treated as purchases. Credit memos land as negatives. Each imported invoice is reconciled back to its own total, so an import that does not add up tells you rather than hiding it.
Import paths exist for the way distributors really deliver invoices — PDF invoices out of the email inbox they arrive in, and CSV exports from vendor portals. Parsers cover the major solar distributors, including Greentech Renewables (CED), Soligent, The LeverEdge, BayWa r.e., ABC Supply, Signature Solar and Horner Xpress, with their individual quirks handled: shipping charges, IN-numbered invoices, and per-hundred and per-thousand pricing.
What it does, point by point
- Unit cost derived from the line extension and quantity shipped, never the printed unit price
- Per-hundred (C) and per-thousand (M) pricing handled correctly
- PDF invoice import from email, plus CSV import from vendor portals
- Parsers for major solar distributors, each with its own invoice quirks handled
- Every import reconciled against the invoice total, so a mismatch surfaces instead of hiding
- Price history and total spend per part and per vendor
- Set your own retail prices, or derive them from multipliers you control
- Vendors can be switched off without deleting their purchase history