{{-- div for Company --}} @php $company = DB::table('gnr_company')->where('id', Auth::user()->company_id_fk)->select('name','address')->first(); $operationalConfig =DB::table('mfn_cfg')->where('name','operationalPolicy_cfg')->value('config'); $operationalConfiguration = json_decode($operationalConfig,true); @endphp {{$company->name}}
{{$company->address}}
Branch Wise Classification of Loan and LLP statement
{{--

Ambala Foundation

House # 67, Block # Ka, Piciculture Housing Society, Shyamoli, Dhaka- 1207

--}} {{--

Member Ledger Report

--}}
Organization Name : {{$company->name}}
Licence No./Application Receipt No. : {{$operationalConfiguration['araLicenceNo']}}
Reporting Date
: {{$requestPeriod}} @php // dd($requestPeriod); @endphp
Print Date
: 2026-07-21

{{--
A) Classification of Loan Disbursement and Loan Outstanding by Size
--}}
{{--
--}} A) Classification of Loan Disbursement and Loan Outstanding by Size {{-- {{$collection}} --}}
Loan Disbursement (P)
No. of Borrowers
Total LD Amount (P)
Loan Outstanding (P)
Male
Female
Total
Upto 5,000 TK. {{$uptoFiveKdisbursedNumberM}} {{$uptoFiveKdisbursedNumberF}} {{$uptoFiveKdisbursedNumberM + $uptoFiveKdisbursedNumberF}} {{number_format($uptoFiveKdisbursedAmountF + $uptoFiveKdisbursedAmountM, 2)}} {{number_format($uptoFiveKOutstandingF + $uptoFiveKOutstandingM, 2)}}
5,001TK. to 10,000TK. {{$FiveKToUptoTenKdisbursedNumberM}} {{$FiveKToUptoTenKdisbursedNumberF}} {{$FiveKToUptoTenKdisbursedNumberM + $FiveKToUptoTenKdisbursedNumberF}} {{number_format($FiveKToUptoTenKdisbursedAmountF + $FiveKToUptoTenKdisbursedAmountM, 2)}} {{number_format($FiveKToUptoTenKOutstandingF + $FiveKToUptoTenKOutstandingM, 2)}}
10,001TK. to 30,000TK. {{$TenKToUptoThirtyKdisbursedNumberM}} {{$TenKToUptoThirtyKdisbursedNumberF}} {{$TenKToUptoThirtyKdisbursedNumberM + $TenKToUptoThirtyKdisbursedNumberF}} {{number_format($TenKToUptoThirtyKdisbursedAmountF + $TenKToUptoThirtyKdisbursedAmountM, 2)}} {{number_format($TenKToUptoThirtyKOutstandingF + $TenKToUptoThirtyKOutstandingM, 2)}}
30,001TK. to 50,001TK. {{$ThirtyKToUptoFiftyKdisbursedNumberM}} {{$ThirtyKToUptoFiftyKdisbursedNumberF}} {{$ThirtyKToUptoFiftyKdisbursedNumberM + $ThirtyKToUptoFiftyKdisbursedNumberF}} {{number_format($ThirtyKToUptoFiftyKdisbursedAmountF + $ThirtyKToUptoFiftyKdisbursedAmountM, 2)}} {{number_format($ThirtyKToUptoFiftyKOutstandingF + $ThirtyKToUptoFiftyKOutstandingM, 2)}}
50,001TK. to 1,00,000TK. {{$FiftyKToOneLakhdisbursedNumberM}} {{$FiftyKToOneLakhdisbursedNumberF}} {{$FiftyKToOneLakhdisbursedNumberM + $FiftyKToOneLakhdisbursedNumberF}} {{number_format($FiftyKToOneLakhdisbursedAmountF + $FiftyKToOneLakhdisbursedAmountM, 2)}} {{number_format($FiftyKToOneLakhOutstandingF + $FiftyKToOneLakhOutstandingM, 2)}}
1,00,001TK. to 3,00,000TK. {{$OneLakhToThreeLakhdisbursedNumberM}} {{$OneLakhToThreeLakhdisbursedNumberF}} {{$OneLakhToThreeLakhdisbursedNumberM + $OneLakhToThreeLakhdisbursedNumberF}} {{number_format($OneLakhToThreeLakhdisbursedAmountF + $OneLakhToThreeLakhdisbursedAmountM, 2)}} {{number_format($OneLakhToThreeLakhOutstandingF + $OneLakhToThreeLakhOutstandingM, 2)}}
3,00,001TK. to above {{$ThreeLakhToMoredisbursedNumberM}} {{$ThreeLakhToMoredisbursedNumberF}} {{$ThreeLakhToMoredisbursedNumberM + $ThreeLakhToMoredisbursedNumberF}} {{number_format($ThreeLakhToMoredisbursedAmountF + $ThreeLakhToMoredisbursedAmountM, 2)}} {{number_format($ThreeLakhToMoreOutstandingF + $ThreeLakhToMoreOutstandingM, 2)}}
Total {{$uptoFiveKdisbursedNumberM + $FiveKToUptoTenKdisbursedNumberM + $TenKToUptoThirtyKdisbursedNumberM + $ThirtyKToUptoFiftyKdisbursedNumberM + $FiftyKToOneLakhdisbursedNumberM + $OneLakhToThreeLakhdisbursedNumberM + $ThreeLakhToMoredisbursedNumberM }} {{$uptoFiveKdisbursedNumberF + $FiveKToUptoTenKdisbursedNumberF + $TenKToUptoThirtyKdisbursedNumberF + $ThirtyKToUptoFiftyKdisbursedNumberF + $FiftyKToOneLakhdisbursedNumberF + $OneLakhToThreeLakhdisbursedNumberF + $ThreeLakhToMoredisbursedNumberF }} {{$uptoFiveKdisbursedNumberM + $FiveKToUptoTenKdisbursedNumberM + $TenKToUptoThirtyKdisbursedNumberM + $ThirtyKToUptoFiftyKdisbursedNumberM + $FiftyKToOneLakhdisbursedNumberM + $OneLakhToThreeLakhdisbursedNumberM + $ThreeLakhToMoredisbursedNumberM + $uptoFiveKdisbursedNumberF + $FiveKToUptoTenKdisbursedNumberF + $TenKToUptoThirtyKdisbursedNumberF + $ThirtyKToUptoFiftyKdisbursedNumberF + $FiftyKToOneLakhdisbursedNumberF + $OneLakhToThreeLakhdisbursedNumberF + $ThreeLakhToMoredisbursedNumberF }} {{number_format($uptoFiveKdisbursedAmountF + $uptoFiveKdisbursedAmountM + $FiveKToUptoTenKdisbursedAmountF + $FiveKToUptoTenKdisbursedAmountM + $TenKToUptoThirtyKdisbursedAmountF + $TenKToUptoThirtyKdisbursedAmountM + $ThirtyKToUptoFiftyKdisbursedAmountF + $ThirtyKToUptoFiftyKdisbursedAmountM + $FiftyKToOneLakhdisbursedAmountF + $FiftyKToOneLakhdisbursedAmountM + $OneLakhToThreeLakhdisbursedAmountF + $OneLakhToThreeLakhdisbursedAmountM + $ThreeLakhToMoredisbursedAmountF + $ThreeLakhToMoredisbursedAmountM, 2)}} {{number_format($uptoFiveKOutstandingF + $uptoFiveKOutstandingM + $FiveKToUptoTenKOutstandingF + $FiveKToUptoTenKOutstandingM + $TenKToUptoThirtyKOutstandingF + $TenKToUptoThirtyKOutstandingM + $ThirtyKToUptoFiftyKOutstandingF + $ThirtyKToUptoFiftyKOutstandingM + $FiftyKToOneLakhOutstandingF + $FiftyKToOneLakhOutstandingM + $OneLakhToThreeLakhOutstandingF + $OneLakhToThreeLakhOutstandingM + $ThreeLakhToMoreOutstandingF + $ThreeLakhToMoreOutstandingM, 2)}}

{{-- {{$endDate}} --}}
{{--
B) Loan Loss Provision (LLP) and Written Off
--}}
{{--
--}} B) Loan Loss Provision (LLP) and Written Off @php $WatchfulTotal = 0; $SubStandardTotal = 0; $DoutfulTotal = 0; $BadLoanTotal = 0; $GoodLoanOutstadingAmountTotal = 0; $OutstadingAmountTotal = 0; $ServiceChargeTotal = 0; $writtenOffTotal = 0; @endphp @foreach ($loanProductCategory as $key => $loanProductCategory1) @php if ($requestedFundingOrganization == 'All') { $loanProducts = DB::table('mfn_loans_product') ->select('id') ->where([['productCategoryId', $loanProductCategory1->id]]) ->pluck('id') ->toArray(); } elseif ($requestedFundingOrganization != 'All' and $requestedFundingOrganization != -1) { $loanProducts = DB::table('mfn_loans_product') ->select('id') ->where([['productCategoryId', $loanProductCategory1->id], ['fundingOrganizationId', $requestedFundingOrganization]]) ->pluck('id') ->toArray(); } elseif ($requestedFundingOrganization == -1) { $loanProducts = DB::table('mfn_loans_product') ->select('id') ->where([['productCategoryId', $loanProductCategory1->id], ['fundingOrganizationId', '!=', 3]]) ->pluck('id') ->toArray(); } // dd($loanProducts); if ($requestedBranch == 'All') { $Watchful = DB::table('mfn_month_end_process_loans') ->where([['date', $endDate]]) ->whereIn('productIdFk', $loanProducts) ->sum('watchfulOutstanding'); $SubStandard = DB::table('mfn_month_end_process_loans') ->where([['date', $endDate]]) ->whereIn('productIdFk', $loanProducts) ->sum('substandardOutstanding'); $Doutful = DB::table('mfn_month_end_process_loans') ->where([['date', $endDate]]) ->whereIn('productIdFk', $loanProducts) ->sum('doubtfullOutstanding'); $BadLoan = DB::table('mfn_month_end_process_loans') ->where([['date', $endDate]]) ->whereIn('productIdFk', $loanProducts) ->sum('badOutstanding'); $OutstadingAmount = DB::table('mfn_month_end_process_loans') ->where([['date', $endDate]]) ->whereIn('productIdFk', $loanProducts) ->sum('closingOutstandingAmount'); $OutstadingAmountWithServiceCharge = DB::table('mfn_month_end_process_loans') ->where([['date', $endDate]]) ->whereIn('productIdFk', $loanProducts) ->sum('closingOutstandingAmountWithServicesCharge'); $writtenOff = DB::table('mfn_loan_write_off') ->where([['date', '<=', $endDate]]) ->whereIn('productIdFk', $loanProducts) ->sum('amount'); } else { $Watchful = DB::table('mfn_month_end_process_loans') ->where([['date', $endDate], ['branchIdFk', $requestedBranch]]) ->whereIn('productIdFk', $loanProducts) ->sum('watchfulOutstanding'); $SubStandard = DB::table('mfn_month_end_process_loans') ->where([['date', $endDate], ['branchIdFk', $requestedBranch]]) ->whereIn('productIdFk', $loanProducts) ->sum('substandardOutstanding'); $Doutful = DB::table('mfn_month_end_process_loans') ->where([['date', $endDate], ['branchIdFk', $requestedBranch]]) ->whereIn('productIdFk', $loanProducts) ->sum('doubtfullOutstanding'); $BadLoan = DB::table('mfn_month_end_process_loans') ->where([['date', $endDate], ['branchIdFk', $requestedBranch]]) ->whereIn('productIdFk', $loanProducts) ->sum('badOutstanding'); $OutstadingAmount = DB::table('mfn_month_end_process_loans') ->where([['date', $endDate], ['branchIdFk', $requestedBranch]]) ->whereIn('productIdFk', $loanProducts) ->sum('closingOutstandingAmount'); $OutstadingAmountWithServiceCharge = DB::table('mfn_month_end_process_loans') ->where([['date', $endDate], ['branchIdFk', $requestedBranch]]) ->whereIn('productIdFk', $loanProducts) ->sum('closingOutstandingAmountWithServicesCharge'); $writtenOff = DB::table('mfn_loan_write_off') ->where([['date', '<=', $endDate], ['branchIdFk', $requestedBranch]]) ->whereIn('productIdFk', $loanProducts) ->sum('amount'); } $GoodLoanOutstadingAmount = $OutstadingAmount - ($Watchful + $SubStandard + $Doutful + $BadLoan); $ServiceCharge = $OutstadingAmountWithServiceCharge - $OutstadingAmount; $WatchfulTotal = $WatchfulTotal + $Watchful; $SubStandardTotal = $SubStandardTotal + $SubStandard; $DoutfulTotal = $DoutfulTotal + $Doutful; $BadLoanTotal = $BadLoanTotal + $BadLoan; $GoodLoanOutstadingAmountTotal = $GoodLoanOutstadingAmountTotal + $GoodLoanOutstadingAmount; $OutstadingAmountTotal = $OutstadingAmountTotal + $OutstadingAmount; $ServiceChargeTotal = $ServiceChargeTotal + $ServiceCharge; $writtenOffTotal = $writtenOffTotal + $writtenOff; @endphp {{-- {{$OutstadingAmountTotal}} --}} @endforeach
Types of Loan
Amount of Default Loan between 1 to 30 days
Amount of Default Loan between 31 to 180 days
Amount of Default Loan between 181 to 365 days
Amount of Default Loan Above 365 days
Amount of Good Loan at the end of this Half Year
Balance of Loan Loss Provision (LLP) at the end of this Half Year
Balance of Loan (LO) at the end of the Half Year
Cumulative Written-off Loan at the end of this Half Year
Category
Watchful(P*)
Sub-Standard(P*)
Doutful(P*)
Bad Loan(P*)
Principal
Service Charge
{{$loanProductCategory1->name}}{{number_format($Watchful, 2)}} {{number_format($SubStandard, 2)}} {{number_format($Doutful, 2)}} {{number_format($BadLoan, 2)}} {{number_format($GoodLoanOutstadingAmount, 2)}} {{number_format($OutstadingAmount, 2)}} {{number_format($ServiceCharge, 2)}} {{number_format($writtenOff, 2)}}
Total {{number_format($WatchfulTotal, 2)}} {{number_format($SubStandardTotal, 2)}} {{number_format($DoutfulTotal, 2)}} {{number_format($BadLoanTotal, 2)}} {{number_format($GoodLoanOutstadingAmountTotal, 2)}} {{number_format($OutstadingAmountTotal, 2)}} {{number_format($ServiceChargeTotal, 2)}} {{number_format($writtenOffTotal, 2)}}
@php // dd($collectionArrayM, $collectionArrayF); @endphp
Prepared By :
Signature :
Designation :
Verified By :
Signature :
Designation :
Approved By :
Signature :
Designation: :