Enter accounts and qualifying balance per DSA to calculate monthly commission.
⚙️ Settings EDITABLE
Balance ≥ this = funded. Below = unfunded. Set to 1 for "any balance above zero".
Flat amount per unfunded account. No progression.
% of total funded balance.
How it works
Funded accounts climb the progressive ladder below. Unfunded accounts earn the flat rate. Bonuses and tier are driven by funded count only.
Funded Account Rate Brackets (progressive)
Applies to funded accounts only. A DSA with 250 funded accounts earns 149 × Bracket 1 + 51 × Bracket 2 + 50 × Bracket 3.
Bracket
From Funded Acct #
To Funded Acct #
Rate ₦ per Account
Threshold Bonuses (flat)
Triggered by funded account count, not total accounts.
Bonus Name
Threshold (Funded Accts ≥)
Amount ₦
Tier / Category (labels)
Categorization only, based on funded accounts. Tier drives no commission.
Category
Min Funded Accts
Max Funded Accts
👥 DSA Entries
Two file formats supported: 1. Per-DSA summary — columns like DSA Name, Total Accounts, Funded Accounts, Funded Balance. Loaded directly. 2. Raw account export — one row per account, with a Balance column and a DSA identifier like ReferralCode, Account Officer, or Account Opened By. Automatically aggregated into per-DSA totals.
📊 Aggregation Options
Auto: use ReferralCode; fall back to Account Officer for USSD-opened accounts.
Case-insensitive: DSUMAR, Dsumar, dsumar → same DSA.