Josue Arango
All projects

2026 · In production use · Backend & APIs

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

GoPostgreSQLHaloPSAPax8Microsoft GraphREST APIs

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

Billing and licence sources, SKU normalisation, per-site matching, over-billed and unbilled lines
Billing and licence sources, SKU normalisation, per-site matching, over-billed and unbilled lines