What it is
Commissioning is a billing-automation pipeline that replaced a manual, multi-hour monthly process with a repeatable, auditable one. A sequence of steps imports payments, reconciles charges, generates branded commission statements, files them to shared storage, and queues partner payments — all driven from a dashboard with test/live switching and dry-run safety nets.
Why it exists
The month-end routine used to mean copying records into spreadsheets, running macros, rendering PDFs by hand, renaming files, and submitting payments manually — fragile, slow, and easy to get wrong. The pipeline turns each of those steps into something that can be re-run safely, logs everything, and previews changes before anything is touched for real.
Who it's for
Finance and operations teams managing multi-partner billing, commissions, and payables on a monthly cadence.
What it does
- Step-by-step import, reconciliation, statement generation, filing, and payment
- Branded PDF commission statements generated from a template
- A dashboard with live execution streaming and a test/live switch
- Dry-run mode and preview files for every step that writes data
- Machine-bound credential encryption so secrets never travel in plaintext
- JSONL audit logs capturing every production run
How it works
What made it interesting to build
Two challenges stood out. First, the work spans two machines, and credentials could never cross the wire — solved with encryption keyed to the hardware itself, so secrets only decrypt where they belong. Second, the generated statements had to match a legacy spreadsheet exactly, down to rounding and edge cases — solved by producing both a verification file and the PDF so any discrepancy surfaces before anything is imported. Every destructive step defaults to a preview-and-confirm flow.