Subscription Source of Truth
Go · cross-vendor billing reconciliation

A read-only report that answers one question a managed service provider cannot otherwise answer reliably: is what we bill each client the same as what the vendors say is actually licensed? Every SKU is sourced from the vendor's own API rather than from a spreadsheet, then compared per site against what was invoiced, so an over-bill or an unbilled seat shows up with the line it came from.
Technologies
My role
Feature owner on a team platform. I designed and built this report end to end — the per-SKU sourcing, the matching rules and the provenance model — inside a codebase led by another engineer.
Highlights
- Each SKU line tagged with its provenance: vendor API, Entra, Intune, manual or fixed
- Per-user and per-device rosters showing exactly who is billed and who is not
- Surfaces the M365 purchased-versus-assigned licence pool, excluding free SKUs
- Handles the awkward cases: consumption billing, arrears lines, site-less attribution, vendor SKU aliases
- 89% test coverage against an 80% enforced floor
Screenshots and diagrams
