Process Loan Reports
Automatically
Upload your daily .xls report. We handle everything — filtering, calculations, sorting, and export.
1
Upload File
Choose your .xls report
2
Processing
Auto calculations
3
Review & Export
Download Excel file
Loan Ageing Report
LoanAgeingDetail... .xls
.xls
.xlsx
Loan Transaction Report
rptLoanTranProdCC... .xls
.xls
.xlsx
Processing...
0%
Reading source file
Detecting columns
Calculating Daily, Day, Status
Calculating Masanta, Min Day, Min Int
Sorting (Due-Expired first, then by Masanta)
Building result table
✅ Processing Complete
Total Accounts
—
Records processed
Due
—
Day > 97
Expired
—
Past expiry date
Clear
—
No issues
| # | Member Name | Contact | A/c No. | OpenDate | ExpDate | Int% | Principal | Principal Due | Interest | Fine | Int. Day | Pri. Day | 1-30 | 31-90 | 91-180 | 181-360 | >=361 | Status |
|---|
AD ↔ BS Calculator
Convert between Bikram Sambat and Gregorian calendar dates instantly
Result
Converted Date—
Day of Week—
BS Month Name—
Days in BS Month—
EMI Calculator
Calculate monthly EMI, total interest, and full repayment schedule
EMI Breakdown
Monthly EMI—
Principal Amount—
Total Interest Payable—
Total Amount Payable—
Tenure—
Interest Rate—