Client story · Partner since 2018A commission is a paycheck. A paycheck is trust.
MedTech MedCare is a medical sales organization in Forestdale, Massachusetts, selling on behalf of a hundred-plus organizations. In 2018, commissions ran months behind, by hand, with zero transparency — their salespeople had trust issues, in their own words.
Today a rep logs in and sees exactly why every dollar is theirs. The month closes in ten days. Every calculation is audited to any point in time. Five chapters follow.
A commission only a custom system could untangle
The sell-through problem, in full: vendor reports arriving monthly in every conceivable format — clean CSVs to multi-tab workbooks — each vendor on its own payment lag: some two months, some one, some none. Territories drawn to the zip code and redrawn constantly. Splits cut between house, sales group, and rep — reps sitting in multiple groups on different deals, some on draws, some on guarantees.
They evaluated the market. Nothing off the shelf could hold it. So four people did — months behind, mistakes compounding.
- Multi-tab workbook
- Clean CSV
- Portal export
- Email attachment
- Varied-lag report
The commission KPI board — what four people used to assemble by hand.
The loader that became a framework
Rather than hand-coding each vendor, SEAD built configuration over code. A template is tied to an email handle: the file arrives, gets parsed by its configuration — where the headers start, which tabs hold data, which rows are totals to ignore — lands in staging, passes quality checks, and runs its custom rules before or after load.
- A vendor file arrives on its email handleThe inbox
- Template match — the configuration recognizes its vendor
- Parsed to staging: where headers start, which tabs hold data, which rows are totals to ignore
- Quality checks pass the file — or hold it
- Custom rules run, before or after load, as the vendor's payment lag demands
- Loaded — one more month in the record
A new vendor is a configuration, not a project.
That framework — born here — now runs at Wright's Impact Window & Door and Direct Supplies Warehouse , part of what Co-Wright builds custom.
The quality checks — where a bad file stops before it can touch a paycheck.
Trust, engineered
The machinery that turned skeptics into users: logins showing each rep exactly what they earned and why. A pre-approval pass, so one reviewer checks every sheet before anything sends. Selective reruns for just the reports that need a fix. Automatic distribution the moment the period closes. Disputes handled as in-system transfer requests, with approval and a full audit trail. Contracts viewable as of any date in history.
One division needed to be paid as a team while each member saw only their own number — a custom blend of transparency and privacy, permissioned to the row and the column.
The nomenclature came fast, as it had at Leahy: team base rate, net base commission rate, guarantees split across two payments, retirement contributions, mid-month payments. The business within the business, learned fast.
Millions of rows, one search
Commission history runs past the point a spreadsheet can even open the file — and it is searchable instantly, the way Co-Wright Intelligence treats any large result set. Bulk transfers ingest through the same loader logic when a rep needs fifty lines moved at once. And territory analytics map to the zip code.
MTMC has more coverage than any cell provider — the zip-code map beats what you see in the carrier commercials.
Territory analysis — drawn to the zip code, redrawn without a project.
The specialist in the loop
The client runs it now. Their own team loads the monthly files with SEAD oversight, and SEAD stays the level-1-through-level-4 specialist for the nuances — a vendor's changed format, a new rule, a permissioning question — on a standing weekly cadence.
The Profit Optics feed graduated from file drops to a live API with a real-time monitor. And sales history now flows outbound into HubSpot, so an account manager sees any group's trajectory the moment they open the record — the CRM integration completing the loop this page anchors for the commissions workflow.
The data-feed monitor — the feed that graduated from file drops to a live API.
On cost, one sentence: we don't believe in scopes — we grow with your business, at a price competitive with the salary of a single software developer, with unlimited data, storage, and users, proprietary software, and service included. The comparison, in full.
If your people don't trust their own numbers
Eight years in, MTMC's reps open the portal and see why every dollar is theirs. The preview of your portal is built and shown by engineers, not a sales script.