Loan Portfolio • Collections • Compliance • Treasury

Financial Services (Non-Bank)
Bookkeeping Built for Lenders.

For NBFCs and non-bank lenders: loan portfolio dashboards, DPD aging, collection efficiency, IRAC provisioning, borrowing facilities, and ALM — all in one place, aligned with RBI and Ind-AS.

Loan Portfolio Dashboard

AUM, product mix, DPD aging, top exposures

Total AUM
248.6 Cr
1,247 active loans
Disbursed Q3
42.8 Cr
186 new loans
GNPA
2.84%
7.06 Cr gross NPA
NNPA
1.62%
4.03 Cr net NPA
Avg Yield
14.82%
+34 bps vs Q2

Product Mix

MSME Term Loan118.4 Cr (47.6%)
Gold Loan62.0 Cr (24.9%)
Vehicle Finance42.2 Cr (17%)
Personal Loan26.0 Cr (10.5%)

DPD Aging Buckets

Current 0
216.4 Cr
1089 accounts
SMA-0 1-30
14.6 Cr
82 accounts
SMA-1 31-60
6.2 Cr
34 accounts
NPA 91+
7.1 Cr
24 accounts

Top Borrower Exposures

BorrowerProductOutstandingDPDRating
Reliance MSMEMSME Term4.82 Cr0A+
Patel GoldGold Loan3.24 Cr0A
Sharma TransportVehicle2.86 Cr15B+
Sunrise FoodsMSME Term1.68 Cr92C
Group 1

Loan Origination & Borrower Management

Track Total AUM, disbursements, GNPA/NNPA, and average yield. View product mix (MSME, Gold, Vehicle, Personal), DPD aging buckets, and top borrower exposures — with filters and MIS export.

  • Portfolio KPIs

    AUM, disbursed, GNPA/NNPA, yield, tenure.

  • Product Mix & DPD

    Product-wise book and aging buckets.

  • Top Exposures

    Borrower-level outstanding, DPD, rating.

Loan Portfolio Dashboard

AUM, product mix, DPD aging, top exposures

Total AUM
248.6 Cr
1,247 active loans
Disbursed Q3
42.8 Cr
186 new loans
GNPA
2.84%
7.06 Cr gross NPA
NNPA
1.62%
4.03 Cr net NPA
Avg Yield
14.82%
+34 bps vs Q2

Product Mix

MSME Term Loan118.4 Cr (47.6%)
Gold Loan62.0 Cr (24.9%)
Vehicle Finance42.2 Cr (17%)
Personal Loan26.0 Cr (10.5%)

DPD Aging Buckets

Current 0
216.4 Cr
1089 accounts
SMA-0 1-30
14.6 Cr
82 accounts
SMA-1 31-60
6.2 Cr
34 accounts
NPA 91+
7.1 Cr
24 accounts

Top Borrower Exposures

BorrowerProductOutstandingDPDRating
Reliance MSMEMSME Term4.82 Cr0A+
Patel GoldGold Loan3.24 Cr0A
Sharma TransportVehicle2.86 Cr15B+
Sunrise FoodsMSME Term1.68 Cr92C

Collection Dashboard

DPD aging, collection efficiency, overdue register

Collection Eff.
96.8%
14.2 Cr / 14.68 Cr demand
Demand Feb
14.68 Cr
1,186 EMIs due
Collected
14.21 Cr
1,148 collected
Overdue
0.47 Cr
38 accounts
Bounce Rate
6.8%
81 mandates bounced

DPD Aging and Collection

SMA-0 1-30
82 accounts
Demand
14.6 Cr
Collected
12.8 Cr
Eff.
87.7%
SMA-1 31-60
34 accounts
Demand
6.2 Cr
Collected
4.1 Cr
Eff.
66.1%
SMA-2 61-90
18 accounts
Demand
4.3 Cr
Collected
2.2 Cr
Eff.
51.2%
NPA 91+
24 accounts
Demand
7.1 Cr
Collected
0.9 Cr
Eff.
12.7%

Collection Register

Loan IDBorrowerEMIPaidDPDStatus
LN-2025-0342Patel Fabrics1,24,0001,24,0000Collected
GL-2024-0812Meera Jewellers42,00042,0000Collected
VF-2024-0567Kamal Transport68,000016Overdue
PL-2024-0123Rakesh Verma18,000062Defaulted
Group 2

Collections, Risk & NPA

Monitor collection efficiency, demand vs collected, overdue and bounce rate. DPD aging with collection by bucket and a collection register (Loan ID, borrower, EMI, paid, DPD, status) with filters.

  • Collection KPIs

    Efficiency, demand, collected, overdue, bounce rate.

  • DPD Aging & Collection

    Bucket-wise demand and collected with efficiency.

  • Collection Register

    Loan-level EMI, paid, DPD, status (Collected/Overdue/Defaulted).

Group 3

Regulatory, Compliance & Accounting

RBI IRAC provisioning: total provisions, standard asset, NPA, restructured. Shortfall alerts and IRAC table (category, rate, required, held, gap). Ind-AS ECL staging (Stage 1/2/3) with ECL amounts.

  • Provision KPIs

    Total provisions, PCR, standard/NPA/restructured.

  • IRAC Requirements

    Category-wise required vs held and gap.

  • ECL Staging

    Stage 1/2/3 with accounts, book, and ECL.

Provisioning & Compliance

RBI IRAC norms, stage-wise provisioning, ECL model

Total Provisions
₹4.86 Cr
PCR: 68.8%
Standard Asset Prov.
₹0.62 Cr
0.40% of standard book
NPA Provisions
₹2.82 Cr
39.9% of GNPA
Restructured Prov.
₹1.42 Cr
10% additional
Provision Shortfall: ₹0.35 Cr on Standard Assets — top-up before Q4 close

IRAC Provision Requirements

CategoryRateRequiredHeldGap
Standard Assets0.40%₹0.97 Cr₹0.62 Cr₹0.35 Cr
Sub-Standard15%₹0.49 Cr₹0.49 Cr
Doubtful (1 yr)25%₹0.55 Cr₹0.55 Cr
Loss Assets100%₹0.10 Cr₹0.10 Cr

Ind-AS ECL Staging

Stage 1 (Performing)
1089 accounts · ECL rate 0.20%
₹0.43 Cr
on ₹216.4 Cr
Stage 2 (Under-performing)
134 accounts · ECL rate 5.00%
₹1.28 Cr
on ₹25.6 Cr
Stage 3 (Non-performing)
24 accounts · ECL rate 40.0%
₹2.64 Cr
on ₹6.6 Cr

Borrowing Facility Management

Bank lines, NCDs, CP, utilization, ALM buckets

Total Borrowings
₹186.4 Cr
12 facilities
Utilization
78.2%
Limit: ₹238.5 Cr
Wt. Avg Cost
7.24%
+12 bps vs Q2
Maturing (90 days)
₹28.4 Cr
3 facilities
Undrawn Lines
₹52.1 Cr
Available buffer

Borrowing Facilities

12 facilities · ₹238.5 Cr limit
LenderTypeLimitDrawnRateMaturityStatus
State Bank of IndiaTerm Loan₹50.0 Cr₹48.2 Cr6.80%Mar 2028Active
HDFC BankCC/OD₹35.0 Cr₹28.6 Cr7.40%Jun 2026Active
ICICI BankTerm Loan₹40.0 Cr₹38.4 Cr7.15%Sep 2027Active
NCD Series ANCD₹25.0 Cr₹25.0 Cr8.20%Apr 2026Maturing

ALM Maturity Buckets

BucketAssetsLiabilitiesGapCum. Gap
0-30 days₹12.4 Cr₹8.2 Cr₹4.2 Cr₹4.2 Cr
31-90 days₹18.6 Cr₹22.8 Cr−₹4.2 Cr₹0.0 Cr
91-180 days₹24.2 Cr₹18.4 Cr₹5.8 Cr₹5.8 Cr
1-3 years₹86.4 Cr₹68.4 Cr₹18.0 Cr₹30.2 Cr
Group 4

Treasury, Analytics & Co-Lending

Manage borrowing facilities: total borrowings, utilization, weighted average cost, maturing and undrawn lines. Facilities table (lender, type, limit, drawn, rate, maturity, status) and ALM maturity buckets with gap.

  • Borrowing KPIs

    Total borrowings, utilization, WAC, maturing, undrawn.

  • Facilities Table

    Lender, type, limit, drawn, rate, maturity, status.

  • ALM Buckets

    Maturity-wise assets, liabilities, gap, cumulative gap.

Everything in one place

Four integrated areas: loan origination and borrower management, collections and risk/NPA, regulatory and compliance, and treasury and analytics — built for NBFCs and non-bank lenders.

Loan Origination & Borrower Mgmt

Portfolio dashboard, product mix, DPD aging, top exposures

Collections, Risk & NPA

Collection efficiency, DPD aging, collection register

Regulatory & Compliance

IRAC provisioning, ECL staging, shortfall alerts

Treasury & Analytics

Borrowing facilities, ALM buckets, utilization

FAQs

Ready to automate your books?

Join 2,000+ businesses saving 20+ hours per month. Start your free trial — no credit card required.

Subscribe to our newsletter

Stay up to date with the latest news and announcements. No credit card required.

By subscribing, you agree to our Privacy Policy.