Dashboard Overview
0
Total Borrowers
+12 this month
0
Active Loans
+5 this month
0
Total Disbursed (BWP)
+8.3%
0
Overdue Loans
-2 from last month
0
Repayment Rate
+1.2%
0
Revenue This Month
+11.5%
Loan Disbursement Trend
Disbursed
Repaid
Loan Status Distribution
Recent Loan Applications
| Borrower | Amount | Purpose | Status | Date |
|---|
Recent Activity
Upcoming & Due Loans (Due today & next 3 days)
Overdue Loans — Send Reminders
Portfolio At Risk (PAR)
Loading PAR data…
Awaiting Contract Signature
Borrower Management
| # | Full Name | Omang No. | Phone | Employer | Active Loans | Risk Level | Status | Actions |
|---|
Unverified Accounts
Loading…
Loan Management
| Loan Ref | Borrower | Amount | Interest | Term | Monthly | Balance | Status | Actions |
|---|
Repayment System
—Collected Today
—This Month
—Payments Today
—Overdue Balance
Pending Payment Proofs
Loading…
Recent Repayments
| Receipt # | Loan ID | Borrower | Amount Paid | Method | Date | Balance After | Recorded By | Actions |
|---|
Collections & Defaults
Good Standing
Warning (1-30 days)
High Risk (31-60 days)
Defaulted (61-90 days)
Blacklisted (90+ days)
| Borrower | Loan ID | Overdue Balance | Days Overdue | Last Contact | Risk Level | Promise Date | Actions |
|---|
Reports & Analytics
Daily Collections
Summary of all collections made today
Loan Disbursement
All loan disbursements by date range
Defaulters Report
List of all defaulting borrowers
Revenue Report
Interest income and fees collected
Loan Aging Report
Loans grouped by aging buckets
Branch Performance
Compare loans, collections & defaults across branches
Balance Sheet
Assets, liabilities and net equity position
Cash Flow Statement
Monthly inflows, outflows and net position
Loan Aging Report
Overdue loans grouped into 30/60/90/120+ day buckets
Monthly Collections
All repayments for a selected month with CSV export
Portal Loan Applications
Review and approve/reject applications submitted by borrowers
Officer Commissions
Track and pay loan officer commissions (7% of approved loan)
Collections vs Disbursements
to
Messages
Notifications
PushActive
SMSActive
EmailActive
WhatsAppSetup Needed
Staff & Role Management
| Name | Role | Branch | Last Login | Status | Actions |
|---|
System Settings
System Behaviour
Controls how frequently the dashboard auto-refreshes data in the background. Minimum: 30 seconds. Default: 120 seconds.
Business Information
Branding
or paste a URL below
or paste a URL below
Dark Mode
Color Scheme
Loan Products
Default Loan Settings
Require Collateral by Default
Require Guarantor by Default
Important — Changes apply to NEW loans only
Updating these interest rate and loan settings will only affect new loans created after saving.
All existing active loans retain their original terms and interest rates. Existing repayment schedules will not be modified.
To adjust an existing loan's term, use the Reduce Term tool on the individual loan detail.
Branch Management
Loading branches…
Borrower Portal Settings
Portal Enabled
Website Landing Page (index.php must be on server)
If ON, root URL shows the marketing website. If OFF, shows the borrower portal.
Self-Registration Allowed
Payment Methods
Orange Money
Bank Transfer
Cash
M-Pesa (if applicable)
Loan Payment Plans
Manage available repayment plans. Plans are shown to staff when creating a loan. The calculation type (Interest Only or Equal Installment) determines how repayments are computed.
Current Plans
Loading…
SMS Settings
Enable SMS
Overdue Alerts
Email Settings
Enable Email
WhatsApp Business API
Connect the Meta WhatsApp Business Cloud API to send messages to borrowers directly from LendBW.
Setup Required
Enable WhatsApp Messaging
Enable WhatsApp
The WhatsApp number shown to your borrowers.
Meta Cloud API Credentials
Get these from Meta for Developers → Your App → WhatsApp → API Setup.
Found in WhatsApp → API Setup section.
Create a System User token in Business Manager for production use.
Quick Setup Guide
- Create a Meta App at developers.facebook.com
- Add WhatsApp product to your app
- Copy the Phone Number ID from API Setup
- Generate a permanent System User token in Business Manager
- Paste both values above and save
- Use "Test Send" to verify the connection
Website Content Manager
All content on your public website is managed here. Changes are live immediately after saving.
Site Identity
Website Colours
Penalty Management
| Date Applied | Borrower | Loan Ref | Type | Months Overdue | Balance Before | Penalty (30%) | Balance After | Status | Actions |
|---|
Audit Logs
| Timestamp | User | Action | Module | IP Address | Details |
|---|
Database Backup & Recovery
Backups are stored in the
backups/ folder on the server. Download and keep copies off-site regularly.
Each backup is a full SQL dump of the database. Restore by importing the SQL file in phpMyAdmin or cPanel MySQL.
| Filename | Size | Created | Actions |
|---|---|---|---|
| Loading… | |||
Raw Data Export
Export all data as a ZIP of human-readable CSV files — open in Excel, Google Sheets, or any spreadsheet app
borrowers.csv
loans.csv
repayments.csv
collateral.csv
auctions.csv
auction_bids.csv
staff.csv
notifications.csv
loan_officer_commissions.csv
README.txt
Collateral & Security Management
| # | Loan Ref | Borrower | Type | Description | Est. Value | Condition | Photos | Verified | Status | Actions |
|---|
Vehicle Custody
| # | Item | Borrower | Loan Ref | Storage Yard | Bay | Check-In | Check-Out | Status | Actions |
|---|
Key Management
| # | Item | Borrower | Loan Ref | Keys | Tag | Storage | Received | Returned | Status | Actions |
|---|
Digital Contracts
| # | Ref | Borrower | Loan Ref | Type | Status | Signatures | Signed At | Expires | Actions |
|---|
Auction Management
Active Auctions
| # | Item | Borrower | Start Bid | Current Bid | Ends | Bids | Status | Actions |
|---|
Auction Wins & Payments
—
Total Wins
—
Awaiting Payment
—
Proof Uploaded
—
Confirmed
| # | Item | Winner | Contact | Winning Bid | Ended | Status | Proof | Actions |
|---|
Receipts & Invoices
| # | Invoice No. | Type | Borrower | Loan Ref | Total | Issued At | Actions |
|---|
Banking Details
Our Banking Details — Accept Repayments To
—
Account Name
—
Account Number
—
Branch
—
Branch Code
—
Borrowers must use their Loan Reference as the payment reference when making EFT payments.
Client Banking Details
| Ref | Borrower | Bank | Account No. | Branch Code | Status | Actions |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Ownership Changes
| Date | Vehicle / Collateral | Reg No. | Borrower | Change Type | New Owner | Transport Dept Ref | Notified | Notes |
|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||
Bluebook / Registration Book
| Date | Vehicle / Collateral | Reg No. | Borrower | Collected By | Omang | Phone | Type | Notified | Notes |
|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||
GPS Tracker Management
| Device ID | IMEI | SIM | Vehicle / Collateral | Borrower | Loan Ref | Install Date | Status | Last Seen | Actions |
|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||
GPS Tracker Inventory
| Device ID | IMEI | SIM | Brand/Model | Status | Installed On | Borrower | Installed | Actions |
|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||
GPS Installations
| Date | Vehicle | Reg No. | Borrower | Device ID | Installer | Location | Status | Photos | Actions |
|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||
Loan Officer Reports
| Officer | Role | Loans Disbursed | Total Disbursed | Active Portfolio | Collected | Interest Collected | Defaulted | Commission Rate | Commission Earned | Actions |
|---|---|---|---|---|---|---|---|---|---|---|
| Select a date range and click Run Report | ||||||||||
Loan Contracts
| Contract # | Borrower | Loan Ref | Type | Status | Borrower Signed | Officer Signed | Actions |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Contract Templates
Pawn & Park and Pawn & Drive templates are pre-loaded from CashOnKeys standard agreements. You can edit them or create custom templates. Supported placeholders:
{{customer_name}}, {{id_number}}, {{loan_amount}}, {{interest_rate}}, {{loan_term}}, {{vehicle_registration}}, {{contract_date}}, {{contract_number}}.
| Template Name | Type | Status | Created | Actions |
|---|---|---|---|---|
| Loading… | ||||
QUICK SEED TEMPLATES
Click Seed to create a pre-filled template based on your CashOnKeys standard agreements. Leave the body blank when creating to auto-populate the default content.
Extra Charges
Add extra fees or charges to a borrower's loan (e.g. late fees, insurance, admin costs). Each charge immediately increases the outstanding balance and is visible in the borrower portal.
| Loan Ref | Borrower | Charge Name | Amount | Description / Reason | Added By | Date | |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||