Partner Commission System: Two-Level Attribution and Settlement
Dozens of partners tracked performance and commission in a shared spreadsheet. Month-end reconciliation took two to three days and regularly ended in disputes.
| Industry | Business services | Service | Business Systems |
| Timeline | 6–8 weeks | Budget | US$2,000–3,500 |
| Stack | PHP, MySQL, admin back office | ||
Background
The client runs a local services business through a partner network. Partners recruit other partners, so attribution has two levels. Commission rates change with business conditions. Everything lived in one shared Excel file, and month-end reconciliation consumed several days while arguments over calculation errors became routine.
What made it difficult
- Two-level attribution had to be unambiguous — no order counted twice, no partner missed
- Commission rules change periodically, but changing them must not rewrite already settled history
- The system touches money, so it must stay compliant: no automatic payouts, final transfer confirmed by a human
How it was solved
- Partner relationship tree — Each partner record holds referrer and referees, forming a two-level chain. Attribution is locked at the moment an order is created and cannot be silently edited afterwards.
- Calculated statements, manual settlement — The system computes each partner's entitlement under the active rules and issues a settlement statement for human review. The transfer itself happens outside the system and is back-filled with a payment reference — efficiency without crossing the regulatory line.
- Versioned rules, frozen history — Rates and tier conditions are editable in the admin console. Every change creates a new version; existing statements keep the rules that produced them.
- Audit trail — Attribution adjustments, rate changes and voided statements record who did what and when.
What was delivered
- System source code and database schema
- Partner management, attribution, commission calculation, statement export to Excel
- Role permissions (administrator / finance / partner)
- Operations manual and deployment documentation
Outcome
Month-end reconciliation dropped from two or three days to under half an hour. Commission disputes effectively disappeared, and rule changes no longer require a code change.
Tell us what you need — get a scope and quote within one business day
Describe the project in a few lines: what it is for, what it must do, and when you need it. You will get a feature list and an indicative quote. If we are not the right fit, we will say so.
WeChat: wx1566768
Phone: +86 153 1441 3839Email: 313497339@qq.com