Affiliate Simulation — V2 User Guide and Acceptance

Acceptance dataset dated 20/10/2026 · Currency: Vietnamese dong · Time zone: Vietnam.

The simulation includes 9 members F0–F8, 32 orders and 5 months from June to October 2026. Use the order codes, member codes and amounts in this document to find records on screen and verify acceptance. June–September are closed; October is provisional. Payable amounts are commission results and do not confirm bank transfers.

1. Colour guide and key figures

Cells also include colour symbols for readers that do not support HTML background colours. All rows in each month's detail tables belong to that month; negative-balance tables identify amounts carried forward.

Balance after offset = Current-period net amount + Opening negative balance
Payable = positive part of the balance after offset; otherwise 0
Closing negative balance = remaining negative part; otherwise 0

2. Simulation policy

Commission is calculated at the product rate, then adjusted for KPI achievement. Each month retains the policy applied.

F6–F8 can still purchase and generate benefits for eligible members above them, but are outside the F0–F5 recipient levels. The product rate is selected by order date; the month in which money is recorded follows the recognition date upon approval.

Each regular order: 2 boxes × 500.000 − discount 100.000 = 900.000 as the calculation basis. The two large orders in June and July: 20 boxes × 500.000 − discount 1.000.000 = 9.000.000. The rate and KPI are two separate steps: 900.000 × 6% = 54.000, then with a KPI achievement of 25%, the earned commission is 54.000 × 25% = 13.500.

3. How commission is recorded

Sample products and units

Find products using the product codes in the table.

In the tables below, order codes omit the common prefix P4-CLOSE-V2- for readability. For example, JUN-F8 is the full code P4-CLOSE-V2-JUN-F8. The number # is the record ID for detailed reconciliation.

Approve an order to record commission and KPI. To cancel an order, change its status to Rejected. The commission screen may update after the order screen.

4. June: new transactions, cancellations within the period and 25% KPI

F0 has 108.000 commission from valid orders and an adjustment of −408.000, giving a current-period net amount of −300.000. F5 has 54.000 original commission, KPI 900.000/3.600.000 = 25%, and earns 13.500. Orders cancelled within the month have a positive entry and a matching reversal; their KPI is also reversed. Orders rejected before approval have no commission entry.

Status: 🟩 Closed at 2026-07-01 00:05:00

Orders and status changes during the month

The table shows the status at that month's reporting date. JUN-F8 remains approved in June; its cancellation is recorded in July.

KPI sales and earned percentage

Monthly money movements — all nine members

Add the four monetary columns across each row to obtain the current-period total. Original commission and KPI reductions are recorded separately. This table separates increases and clawbacks to show money movements; the on-screen 100% commission field may already exclude the original commission of cancelled orders. Do not add original commission again to an existing total.

Offset negative balances and finalise payable amounts

Sources of remaining negative balances at month-end

All money entries recorded this month

All KPI sales entries for the month

Related adjustment vouchers for the month

5. July: cancelling prior-month orders and clawing back the amount actually earned

Order JUN-F8 was cancelled on 02/07 after June closed. F0 has a clawback of 9.000; F5 has a clawback of exactly 13.500 earned, rather than the original 54.000. June KPI and closing results stay unchanged. F0 has another 90.000 and an adjustment of +119.000: 90.000 − 9.000 + 119.000 = 200.000; offsetting −300.000 leaves −100.000. F5 has no new income to offset, so −13.500 carries forward. F1–F4 earned 0 in June, so their actual-earned clawback is 0; money never earned is not clawed back.

Status: 🟩 Closed at 2026-08-01 00:05:00

Orders and status changes during the month

KPI sales and earned percentage

Orders JUL-THIEU-TY-LE and JUL-TY-LE-0 each add +900.000 KPI for F5 on approval and −900.000 on cancellation, giving 0. One product has no configured rate; the other has an explicit 0% rate. Neither generates original commission.

Monthly money movements — all nine members

Offset negative balances and finalise payable amounts

Sources of remaining negative balances at month-end

All money entries recorded this month

All KPI sales entries for the month

Related adjustment vouchers for the month

6. August: negative balances remain even without orders

August has no new orders, money entries or adjustment vouchers. The system still closes the period and carries forward negative balances: F0 −100.000, F5 −13.500; both have 0 payable. An empty month does not clear outstanding obligations.

Status: 🟩 Closed at 2026-09-01 00:05:00

Orders and status changes during the month

KPI sales and earned percentage

Monthly money movements — all nine members

Offset negative balances and finalise payable amounts

Sources of remaining negative balances at month-end

F0 still has 91.000 from the June downward adjustment and 9.000 from the July order cancellation, totalling 100.000; F5 still has 13.500 from the order cancellation. Full offset in September does not change the negative balance in the historical August snapshot.

All money entries recorded this month

All KPI sales entries for the month

Related adjustment vouchers for the month

7. September: all F0–F8 levels, two channels and full offset

There are 18 regular orders: one retail and one wholesale order for each F0–F8 level; plus one order approved and cancelled within the month. Each F0–F5 recipient has KPI sales of 7.200.000, above the 3.600.000 target, so the earned percentage is capped at 100%. F0 receives a 338.000 adjustment; the total negative balance of 113.500 is fully offset. Pending orders, rejected vouchers and unposted vouchers do not enter September's money total.

Status: 🟩 Closed at 2026-10-01 00:05:00

Orders and status changes during the month

KPI sales and earned percentage

One member's KPI: 4 buyer levels × 2 channels × 900.000 = 7.200.000. The sum of all 6 members' KPI is 43.200.000, with overlapping scopes between members; this is not unique order sales. The calculation basis of the month's 18 valid orders is 16.200.000.

Monthly money movements — all nine members

Offset negative balances and finalise payable amounts

Sources of remaining negative balances at month-end

All money entries recorded this month

All KPI sales entries for the month

Related adjustment vouchers for the month

8. October: late approval, cancellation after delivery and provisional amounts

Order LATE-F8 dated 30/09 was approved on 02/10, so its commission and KPI enter October; the product rate still follows the September order date. Delivered order SEP-1-F8 was rejected on 05/10: claw back 189.000 in October while preserving September. The voucher requested in September posts +10.000 only on 03/10. Order OCT-TY-LE-MOI dated 07/10 uses the new F0=2% rate and generates 18.000. F0 currently has 9.000 − 9.000 + 10.000 + 18.000 = 28.000 provisionally; this is not the period-end amount.

Status: 🟨 Open — October KPI not closed

Orders and status changes during the month

KPI sales and earned percentage

Monthly money movements — all nine members

Offset negative balances and finalise payable amounts

October has no final closing balance yet. Provisional columns do not confirm that month-end obligations are fully offset: KPI may still reduce order commission, while clawbacks from earlier periods must retain the actual amounts earned.

All money entries recorded this month

All KPI sales entries for the month

Related adjustment vouchers for the month

If no further transactions occur, closing October under the current policy gives F0 a KPI of 25%: the 27.000 from two orders earns 6.750; add the 10.000 adjustment and subtract the 9.000 clawback, leaving 7.750. F5 earns 13.500 from the late order but has a clawback of 54.000 from the September order, leaving −40.500. This is a future illustration, not a finalised closing result. F1–F4 must also apply October KPI to new orders before determining their period-end amounts.

9. On-screen viewing and reconciliation guide

F0 summary across five months

Trace F5's JUN-F8 order

September: tab totals differ but must reconcile

Order commission after KPI                   2.142.000
+ Posted adjustments                         338.000
= Current-period commission total          2.480.000
− F0 opening negative balance                100.000
− F5 opening negative balance                 13.500
= Total payable                            2.366.500

Available functions depend on account permissions. Admin screen: /system/affiliate?month=9&year=2026&receiver_referrer_code=P4CLOSEF0#tab-member. Web: /hoa-hong/P4CLOSEF0?month=202609, still requiring the correct login permissions. A data-loading error on the website must not be interpreted as zero or no negative balance.

Members with no amount requiring closing may still see a provisional label and 0 in their individual panel. Check the overall monthly status to confirm that the month is closed.

All 32 input product lines

The order period is the month of the order date; money-entry periods may include both recognition and clawback months. For example, a June order can generate money in June and a clawback in July; LATE-F8 has a September order period but records money in October.

Original commission entry statuses — all 104 entries

This table shows the current status after all sample closings/cancellations. Amounts clawed back and remaining tracked earnings belong to individual original commission entries, rather than bank transfers. Use the monthly tables above for historical periods; do not use today's remainder to revise a closed month.

KPI closing results — all 13 entries

Negative-balance sources as of now — all 18 sources

Negative-balance sources include KPI reductions already fully offset by positive money in the same month. Thus the number of sources is not the number of members still owing money. All sources are fully offset at the end of September; the June–August snapshots above preserve their negative amounts at those dates.

Individual offsets by negative-balance source — all 20 entries

10. Test results and acceptance procedure

The entire simulation was rerun across all 5 months: 32 orders, 135 money entries, 74 KPI entries and 45 member-month results.

Test results: 56 simulation data checks and 43 Affiliate workflow tests all passed.

On-screen acceptance procedure

1. Open Affiliate and select the month and member code from the monthly tables.
2. Compare KPI sales, current-period commission, opening negative balance, payable and closing negative balance.
3. Open order or adjustment voucher details to compare approval, cancellation and posting dates.
4. Compare the same month and member across retail, wholesale and the commission website.
5. Mark as passed when amounts and statuses match. For discrepancies, record the month, member code, order code and displayed amount.