Incentive Report Builder

Frontend-only tool to turn your two CSV exports into a clean incentive report (download as CSV).

1) Upload CSVs

Report A (bill-wise + customer details) Needs columns: Receipt number, BILLAMOUNT (and optionally SALESTYPE). Report B (bill-wise sales report) Needs columns: Receipt number, SALESMAN, LINETOTAL (and optionally SALESTYPE).

2) Rules

From what amount? Bills with amount strictly greater than this are eligible. Incentive % Applied on total eligible sale (e.g., 1% of 177801.81 = 1778.0181). Exclude SALESTYPE values Comma-separated (case-insensitive). Example: SERVICE INVOICE, RETURN

Upload both files, then click Build report.

Preview

Run summary

No run yet.

Column detection (advanced)

This app auto-detects columns by name (case-insensitive). It expects:

Report A: Receipt number, BILLAMOUNT, optional SALESTYPE
Report B: Receipt number, SALESMAN, LINETOTAL, optional SALESTYPE

If your export uses different names, open app.js and add aliases in COLUMN_ALIASES.

3) Petrol Payout

Configure petrol payouts (saved in this browser). Amount = Base / Days × Times.

Petrol base amount Month days Month key (for saving) Optional. If blank, the app auto-uses current month.

Add payout row

Person Other name Times Note

No petrol rows yet.