KOL Monthly Settlement
Generation
Two ways to generate:
- Cron auto: 1st day of each month at 00:30 MYT, system auto-generates settlement for all KOL Pages (draft status)
- Manual batch: "Finance → KOL Settlement" → click "Generate Current Month" → system parallel-generates per Page
State Machine
| Status | Meaning | Available Actions |
|---|---|---|
| draft | Initially generated | Confirm / void |
| confirmed | Blogger reviewed and approved | Mark paid / void |
| paid | Paid to KOL | (final, not editable) |
| void | Voided | (final, not editable) |
⚠️ Rule: Paid status cannot be voided. If error found after payment, manual journal adjustment is needed.
Export xlsx
Settlement list can be filtered by status + one-click xlsx export (real Excel via exceljs, no encoding issues). Columns include:
- Settlement period / Page / KOL
- Gross sales / refunded / net sales
- Commission rate / commission amount
- Order count / status / payment date
Pay KOL Commission
- Bank transfer to KOL
- In settlement detail page, click "Mark Paid"
- Fill in payment method / reference / payment date
- Status changes to paid