Letshego Faidika Bank — DSA/DTL Commission App

Upload Branch Manager File

Roster

Uploads are upserts: re-uploading for a period already in progress updates existing rows for that period, it never duplicates them. Rows whose DATE falls outside the period you select below are rejected and listed after submit.

Branch — admin only, leave blank if the sheet is named after the branch Period

File (.xlsx)

No file chosen

Upload Business Manager File

Payout report

Uploads are upserts, same as the roster file. Rows whose Disbursement date falls outside the period you select below are rejected and listed after submit.

Period

File (.xlsx)

No file chosen

Recent Uploads

ID	Type	Branch	Period	Filename	Status	Accepted	Rejected	Warnings	Uploaded

click a row for accepted, rejected and warning detail

Create Commission Run

A run snapshots matched sales for the period. Org-wide runs cover every branch; branch runs cover one. Runs move DRAFT → REVIEWED → LOCKED → PAID.

Type

Branch — BRANCH runs only

Period (YYYY-MM)

Commission Runs

ID	Type	Branch	Period	Status	Actions

Exceptions

Unmatched, duplicate, and match-quality-warning rows. These block nothing but must be reviewed before a run is locked.

Period (YYYY-MM, optional)

Branch — admin / business manager only

Unmatched in business file

Unmatched in branch file

Duplicates

Match warnings

Invalid top-up base

Category	Branch	Client	Acct (Branch)	Acct (Business)	DSA	Loan Type	Disb. Date	Notes

Users

ID	Email	Name	Role	Branch

Roles

Name	Description	Permissions	System?	Actions

Branches

ID	Name	Code

DSAs

DSAs normally enter the system via Branch Manager uploads. Use this to onboard one before their first sale, or to edit their branch/DTL directly — reassigning a DTL here goes through the same effective-dated history as an upload, it never overwrites past supervision records.

Code	Name	Branch	Current DTL	Actions

DTLs

Code	Name	Bank Account	Branch	Actions

DSA/DTL Commission

Sign in

Uploads

Upload Branch Manager File

Upload Business Manager File

Recent Uploads

Create Commission Run

Commission Runs

Exceptions

Users

Roles

Branches

DSAs

DTLs

Still there?