LoanTrack CRM

Sign in to your account

LoanTrack CRM
Dashboard
Synced
A
Admin
Total Portfolio
₹0
0 active loans
Collection Rate
0%
0 Overdue
0 NPA
0 Closed
₹0
Avg Loan Size
0
Due in 7 Days
Top Scheme
Low
Portfolio Risk
All Loans
Int. Due
Due Today
Renewal
PNPA
NPA
Sort:

Customers with No Active Loan

Loading…

Loading…

Total Interest Collected

From/To date choose karke "Show" dabayein

Interest Leakage (abhi tak collect nahi hua)

Loading…

Customer Details
Loan Details
Naya scheme banane ke liye Settings → Schemes mein jaayein
Live Interest & Scheme Summary
ANNUAL RATE
EST. MONTHLY DUE
DUE CYCLE
Khaali chhodein agar abhi tak koi payment nahi hui

Har scheme apna interest rate, tenure aur renewal/PNPA rules khud define karti hai.

Add New Scheme

Tenure khatam hone ke baad itne mahine PNPA rahega, uske baad NPA ho jaayega
Pay-Early Rebate Slabs (optional, max 4)
Jitni jaldi customer interest pay karega, utna rebate milega. "Max Months" = us slab ki upar ki seema (mahino mein), "Rebate %" = base rate se kitna kam ho jaayega. Us se aage koi slab match na ho to poora base rate lagega.

Add New User

All Users

1
Upload CSV
2
Preview
3
Import
Drop CSV file here or click to browse
Accepted: .csv · Max 500 rows per upload

CSV Format

First row must be the header. Column names are flexible — the app auto-maps common names.

${['Customer Name *','Customer ID','Mobile','Scheme *','Loan No','Amount *','Loan Date *','Net Weight(g)','Last Paid','Status','Notes'].map(h=>' ').join('')} ${['Rajesh Kumar','1426','9876543210','Gold Loan','1236','150000','2024-01-15','','2024-02-15','Active','Good customer'].map(v=>'').join('')}
'+h+'
'+v+'

Run SQL

Schema change (ALTER TABLE, CREATE TABLE, UPDATE, INSERT) yahan se seedha chala sakte hain — phpMyAdmin ki zaroorat nahi.
DROP / TRUNCATE / DELETE-without-WHERE block hai.

Recent Migrations

Loading…

Activity Log

Har Paid / Renewed / Closed / Edit / Waiver action yahan record hoti hai — galti se kiya gaya koi bhi action yahan se undo kiya ja sakta hai.

Loading…

API Connection

Connected via PHP + MySQL

Data

Install App

Android Chrome: Menu (⋮) → Add to Home screen
iPhone Safari: Share → Add to Home Screen

If link doesn't open on mobile: make sure you are using Chrome or Safari browser, not a social media webview.

Loan Details

Loading…