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.

Two-level distributionCommission calculationPermissionsCompliance
IndustryBusiness servicesServiceBusiness Systems
Timeline6–8 weeksBudgetUS$2,000–3,500
StackPHP, 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

  1. 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.
  2. 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.
  3. 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.
  4. 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 QR code WeChat: wx1566768 Phone: +86 153 1441 3839
Email: 313497339@qq.com