@php $serialNumber = 1; // Initialize serial counter @endphp @foreach ($members as $member) @php $hasLoans = count($member->loans) > 0; $memberRawSpan = $hasLoans ? count($member->loans) : 1; $branchName = $branches[$member->branchId]->name ?? null; @endphp @if($hasLoans) @foreach ($member->loans as $loan) @if($loop->first) @endif @endforeach @else @endif @php $serialNumber++; // Increment serial for next member @endphp @endforeach

SL	Full client name (first and last name)	Related party (1= Employee, 2= Senior management, 3= Director, 4=Shareholder)	Client ID #	Loan Reference #	Credit Methodology (1= individual, 2= solidarity group, 3=village bank)	Product Name	Economic activity (1= agriculture, 2=industry, 3= trade, 4=services, 5=construction, 6=transport, 7=tourism, 8 = education and health, 9=mortgage, 10 = consumer, 11 = other)	Category (1=new loan, 2= renewal, 3= restructured, 4= reprogrammed, 5=other (please specify))	Date Loan Awarded	Maturity Date of Loan	Term (in months)	Grace period (in days or months, please specify)	Frequency of Interest paments (days in between) if payments are regular	Frequency of Principal payments (days in between) if payments are regular	Loan Currency	Amount Awarded in Local Currency	Amount awarded (equivalent in USD)	Outstanding Balance in Local Currency	Outstanding balance (in USD)	Date of Last PMT	Days Past Due	Principal amount past due - in Local Currency	Principal amount past due (equivalent in USD)	Loan Risk Classification (regulatory or internal, please specify)	Amount of loan provision - in Local Currency	Amount of loan provision (equivalent in USD)	Amount of provisioing coverage	Nominal Annual Interest Rate	Additional Fees or Commissions - in Local Currency	Effective Interest Rate	Accrued interest - in Local Currency	Collateral (1=none, 2=physical collateral, 3 = cash collateral, 4= guarantee), 5 = other (please specify)	Sub-type of collateral (1=land/building/house, 2=machinery, 3=vehicles, 4=account receivables, 5=deposits, 6=portfolio guarantee, 7=other (please specify))	Registration of the collateral (fully perfected, imperfect, none)	Value of Collateral pledged to MFI - in Local Currency	Collateral / Outstanding Balance	(Collateral + Provision) / Outstanding Balance	Branch	Loan Officer
{{$serialNumber}}	{{$member->name}}		{{$member->code}}	{{$loan->loanCode}}	1	{{$loan->productName}}	{{$loan->loanPurposeName}}	{{$loan->loanCycle > 2 ? 2: $loan->loanCycle}}	{{ date('d-m-Y', strtotime($loan->disbursementDate)) }}	{{ date('d-m-Y', strtotime($loan->lastInstallmentDate)) }}	{{$loan->termsInMonth}}	{{$loan->gracePeriod}}	{{$loan->mfnRepaymentFrequencyDays}}	{{$loan->mfnRepaymentFrequencyDays}}	BDT	{{$loan->loanAmount}}	{{$loan->loanAmountInUSd}}	{{number_format($loan->outstanding, 2)}}	{{$loan->outstandingInUsd}}	{{date('d-m-Y', strtotime($loan->lastCollectionDate))}}	{{$loan->totalDueDays}}	{{number_format($loan->due, 2)}}	{{$loan->dueInUsd}}	{{$loan->classificationTag}}	{{number_format($loan->llpAmount, 2)}}	{{$loan->llpAmountInUsd}}	{{$loan->llpPercentage}}%	{{$loan->nominalInterestRate}}	{{$loan->fee}}			None	None	None	None	None	None	{{$branchName}}	{{$loan->fieldOfficerName}}
{{$serialNumber}}	{{$member->name}}		{{$member->code}}																																			{{$branchName}}