// selected work
Custom software · Dealer operationsSales-commission automation for a dealer network
Turns a messy Excel sales report into per-dealer commission statements — calculated, PDF'd, and emailed automatically.
- Flow
- Excel → PDF → email
- Commission tiers
- base + 3
- API routes
- 38
// note: a real system in production. The client is kept anonymous for privacy; the numbers above are pulled straight from the live app.
// The problem
Paying dealer commissions by hand is slow and error-prone: export sales to a spreadsheet, apply tiered rates, account for credits and repos, build a statement for each dealer, then email them all out. Every month, that's hours of tedious, mistake-prone work.
// What I built
The commission app takes the whole thing off their plate. You upload the multi-sheet Excel sales report and it parses every sheet, calculates tiered commissions per dealer (a base plus three tiers, with different handling for new versus used/repo sales), applies credits and cancellations, and generates a clean PDF statement for each dealer. Then it batch-emails them with delivery tracking. It also exposes a public, token-authenticated API so other systems — like the dealer inventory app — can pull commission data.
// The result
A monthly slog becomes an upload and a click: parsed, calculated, documented, and delivered. Built on Next.js with MongoDB, Postmark for email, and Vercel Blob for files — a real production system with 38 API routes.
What's in it
- Multi-sheet Excel upload and parsing
- Tiered commission calc (base + 3 tiers), new vs. used/repo
- Credits, cancellations, and adjustments
- Per-dealer PDF statements
- Batch email with delivery tracking (Postmark)
- Public, token-authenticated API for integrations
Highlights
// more work
Have a system that needs building?
Tell me what you need. I reply the same day — usually within the hour, with honest next steps and a free quote.