{{-- div for Company --}} {{$data['company']->name}}
{{$data['company']->address}}
{{'Reporting Branch: '. $data['branchName']}}
MRA {{ $data['reportType'] }}ly Savings Report
Reporting Period : {{ date_format( date_create($data['startDate']),"dS F Y") }} to {{ date_format( date_create($data['endDate']),"dS F Y") }} Print Date : 2026-07-21
{{-- end report info div --}}
{{-- Branch wise Savings Information --}}
Branch wise Savings Information
Branch : {{ $data['branchName'] }}
{{-- --}} @php $grandTotal_no_of_savers_male = 0; $grandTotal_no_of_savers_female = 0; $grandTotal_no_of_savers_total = 0; $grandTotal_openingBalance = 0; $grandTotal_deposit = 0; $grandTotal_withdraw = 0; $grandTotal_interestPayable = 0; $grandTotal_interestPaid = 0; $grandTotal_closingBalance = 0; $total_comp_vol = $total_comp_vol_m = $total_comp_vol_f = 0; $count = 0; @endphp @foreach($data['savingsInfos'] as $key => $value) @php $count++; $value = (object) $value; if( $value->scheme != 'sub-total' ) { $total_comp_vol_m += $value->no_of_savers_male; $total_comp_vol_f += $value->no_of_savers_female; } if( $value->scheme == 'sub-total' ) $total_comp_vol_m = $total_comp_vol_f = 0; if( $value->scheme == 'sub-total' ) { $comp_u_m = $comp_u_f = $vol_u_m = $vol_u_f = $term_u_m = $term_u_f = 0; $comp_m = $comp_f = $vol_m = $vol_f = $term_m = $term_f = 0; } if( $value->scheme == 'compulsory' ) { $comp_m = $value->no_of_savers_male - $value->no_of_savers_male; $comp_f = $value->no_of_savers_female - $value->no_of_savers_female; } if( $value->scheme == 'voluntary' ) { $vol_u_m = $value->no_of_savers_male; $vol_u_f = $value->no_of_savers_female; $vol_m = $value->no_of_savers_male - $value->no_of_savers_male; $vol_f = $value->no_of_savers_female - $value->no_of_savers_female; } if( $value->scheme == 'term' ) { $term_m = $value->no_of_savers_male - $value->no_of_savers_male; $term_f = $value->no_of_savers_female - $value->no_of_savers_female; $term_m = $total_comp_vol_m - ( $comp_m + $vol_m + $vol_u_m ); $term_f = $total_comp_vol_f - ( $comp_f + $vol_f + $vol_u_f ); } @endphp @if($key == 0) @elseif($key == 4) @endif @if( $value->scheme == 'sub-total' ) @elseif( $value->scheme == 'compulsory' ) @elseif( $value->scheme == 'voluntary' ) @elseif( $value->scheme == 'term_old' ) @elseif( $value->scheme == 'term' ) @endif {{-- tempporary adjustment --}} @php if($value->scheme == 'sub-total'): $grandTotal_no_of_savers_male += (int) $value->no_of_savers_male; $grandTotal_no_of_savers_female += (int) $value->no_of_savers_female; $grandTotal_no_of_savers_total += (int) $value->no_of_savers_total; $grandTotal_openingBalance += (float) $value->openingBalance; $grandTotal_deposit += (float) $value->deposit; $grandTotal_withdraw += (float) $value->withdraw + (float) $value->interestPaid; $grandTotal_interestPayable += (float) $value->interestPayable; $grandTotal_interestPaid += (float) $value->interestPaid; //$grandTotal_closingBalance += (float) $value->closingBalance; $grandTotal_closingBalance += floatVal($value->openingBalance) + floatVal($value->deposit) + floatVal($value->interestPaid) - ( floatVal($value->withdraw) + floatVal($value->interestPaid) ); endif; @endphp @endforeach
Type Name of Savings/Deposit Scheme No. of Depositors/Savers Savings Balance at the Start of this {{ $data['reportType'] }} Savings Collection in this {{ $data['reportType'] }} Savings Withdraw/Refund/Adjustment in this {{ $data['reportType'] }} Interest Payable in this {{ $data['reportType'] }} Total Interest Paid in this {{ $data['reportType'] }} Deposit/Savings Balance Declared Interest Rate (%)
Male Female Third Gender Total
1 2 3 4 = 1+2+3 5 6 7 8 9 10 = 5 + 6 + 9 - 7 11
Savers {{ ucfirst($value->type) }} in reporting dateSavers {{ ucfirst($value->type) }} in reporting date{{ ucfirst($value->scheme) }}{{ $value->no_of_savers_male}} {{ $value->no_of_savers_female }} 0 {{ $value->no_of_savers_total }} {{ $value->no_of_savers_male }} {{ $value->no_of_savers_female }} 0 {{ $value->no_of_savers_total }} {{ $value->no_of_savers_male }} {{ $value->no_of_savers_female }} 0 {{ $value->no_of_savers_total }} {{ $value->no_of_savers_male }} {{ $value->no_of_savers_female }} 0 {{ $value->no_of_savers_total }} {{ $value->no_of_savers_male }} {{ $value->no_of_savers_female }} 0 {{ $value->no_of_savers_total }} {{ number_format( $value->openingBalance ,2) }} {{ number_format( $value->deposit ,2) }} {{ number_format( $value->withdraw + $value->interestPaid ,2) }} {{ number_format( $value->interestPayable ,2) }} {{ number_format( $value->interestPaid ,2) }} {{ number_format( $value->openingBalance + $value->deposit + $value->interestPaid - ( $value->withdraw + $value->interestPaid ) ,2) }} @if( !empty($value->interestRate) ){{ $value->interestRate }}% @endif
Grand total {{ $grandTotal_no_of_savers_male }} {{ $grandTotal_no_of_savers_female }} 0 {{ $grandTotal_no_of_savers_total }} {{ number_format($grandTotal_openingBalance ,2) }} {{ number_format($grandTotal_deposit ,2) }} {{ number_format($grandTotal_withdraw ,2) }} {{ number_format($grandTotal_interestPayable ,2) }} {{ number_format($grandTotal_interestPaid ,2) }} {{ number_format($grandTotal_closingBalance ,2) }}
{{-- Savings Information on Savings Size --}}
Savings Information on Savings Size
{{-- For temporrary mra report submit adjustment --}} @php // $savingSizeTotalMale = $data['savingSizeInfos']['_below_2000']['saver_male'] + $data['savingSizeInfos']['_2001_to_5000']['saver_male'] + $data['savingSizeInfos']['_5001_to_10000']['saver_male'] + $data['savingSizeInfos']['_10001_to_20000']['saver_male'] +$data['savingSizeInfos']['above_200001']['saver_male']; // $savingSizeTotalFemale = $data['savingSizeInfos']['_below_2000']['saver_female'] + $data['savingSizeInfos']['_2001_to_5000']['saver_female'] + $data['savingSizeInfos']['_5001_to_10000']['saver_female'] + $data['savingSizeInfos']['_10001_to_20000']['saver_female'] +$data['savingSizeInfos']['above_200001']['saver_female']; // if($grandTotal_no_of_savers_male > $savingSizeTotalMale){ // $data['savingSizeInfos']['_below_2000']['saver_male'] = $data['savingSizeInfos']['_below_2000']['saver_male'] +($grandTotal_no_of_savers_male - $savingSizeTotalMale); // $data['savingSizeInfos']['_below_2000']['saver_female'] = $data['savingSizeInfos']['_below_2000']['saver_female'] - ($savingSizeTotalFemale - $grandTotal_no_of_savers_female); // }else if($grandTotal_no_of_savers_female > $savingSizeTotalFemale ){ // $data['savingSizeInfos']['_below_2000']['saver_female'] = $data['savingSizeInfos']['_below_2000']['saver_female'] +($grandTotal_no_of_savers_female - $savingSizeTotalFemale); // $data['savingSizeInfos']['_below_2000']['saver_male'] = $data['savingSizeInfos']['_below_2000']['saver_male'] - ( $savingSizeTotalMale - $grandTotal_no_of_savers_male); // } // $totalBalanceSum = $data['savingSizeInfos']['_below_2000']['balance']+$data['savingSizeInfos']['_2001_to_5000']['balance']+$data['savingSizeInfos']['_5001_to_10000']['balance']+$data['savingSizeInfos']['_10001_to_20000']['balance']+$data['savingSizeInfos']['above_200001']['balance']; // if($grandTotal_closingBalance > $totalBalanceSum){ // $data['savingSizeInfos']['_below_2000']['balance'] = $data['savingSizeInfos']['_below_2000']['balance'] + ($grandTotal_closingBalance - $totalBalanceSum); // } @endphp {{-- For temporrary mra report submit adjustment end --}} {{-- --}}
Size of Savings Number of Savers Balance of Savings
Male Female Third Gender Total
Up to 2000 TK. {{ $data['savingSizeInfos']['_below_2000']['saver_male'] }} {{ $data['savingSizeInfos']['_below_2000']['saver_female'] }} 0 {{ $data['savingSizeInfos']['_below_2000']['saver_male'] + $data['savingSizeInfos']['_below_2000']['saver_female'] }} {{ number_format( $data['savingSizeInfos']['_below_2000']['balance'] ,2) }}
2001 TK. to 5000 TK. {{ $data['savingSizeInfos']['_2001_to_5000']['saver_male'] }} {{ $data['savingSizeInfos']['_2001_to_5000']['saver_female'] }} 0 {{ $data['savingSizeInfos']['_2001_to_5000']['saver_male'] + $data['savingSizeInfos']['_2001_to_5000']['saver_female'] }} {{ number_format( $data['savingSizeInfos']['_2001_to_5000']['balance'] ,2) }}
5001 TK. to 10000 TK. {{ $data['savingSizeInfos']['_5001_to_10000']['saver_male'] }} {{ $data['savingSizeInfos']['_5001_to_10000']['saver_female'] }} 0 {{ $data['savingSizeInfos']['_5001_to_10000']['saver_male'] + $data['savingSizeInfos']['_5001_to_10000']['saver_female'] }} {{ number_format( $data['savingSizeInfos']['_5001_to_10000']['balance'] ,2) }}
10001 TK. to 20000 TK. {{ $data['savingSizeInfos']['_10001_to_20000']['saver_male'] }} {{ $data['savingSizeInfos']['_10001_to_20000']['saver_female'] }} 0 {{ $data['savingSizeInfos']['_10001_to_20000']['saver_male'] + $data['savingSizeInfos']['_10001_to_20000']['saver_female'] }} {{ number_format( $data['savingSizeInfos']['_10001_to_20000']['balance'] ,2) }}
20001 TK. and Above {{ $data['savingSizeInfos']['above_200001']['saver_male'] }} {{ $data['savingSizeInfos']['above_200001']['saver_female'] }} 0 {{ $data['savingSizeInfos']['above_200001']['saver_male'] + $data['savingSizeInfos']['above_200001']['saver_female'] }} {{ number_format( $data['savingSizeInfos']['above_200001']['balance'] ,2) }}
Grand total {{ $data['savingSizeInfos']['_below_2000']['saver_male'] + $data['savingSizeInfos']['_2001_to_5000']['saver_male'] + $data['savingSizeInfos']['_5001_to_10000']['saver_male'] + $data['savingSizeInfos']['_10001_to_20000']['saver_male'] +$data['savingSizeInfos']['above_200001']['saver_male'] }} {{ $data['savingSizeInfos']['_below_2000']['saver_female'] + $data['savingSizeInfos']['_2001_to_5000']['saver_female'] + $data['savingSizeInfos']['_5001_to_10000']['saver_female'] + $data['savingSizeInfos']['_10001_to_20000']['saver_female'] +$data['savingSizeInfos']['above_200001']['saver_female'] }} {{ 0 }} {{ $grandTotal_no_of_savers_total }} {{ $data['savingSizeInfos']['_below_2000']['saver_male'] + $data['savingSizeInfos']['_2001_to_5000']['saver_male'] + $data['savingSizeInfos']['_5001_to_10000']['saver_male'] + $data['savingSizeInfos']['_10001_to_20000']['saver_male'] +$data['savingSizeInfos']['above_200001']['saver_male'] + $data['savingSizeInfos']['_below_2000']['saver_female'] + $data['savingSizeInfos']['_2001_to_5000']['saver_female'] + $data['savingSizeInfos']['_5001_to_10000']['saver_female'] + $data['savingSizeInfos']['_10001_to_20000']['saver_female'] +$data['savingSizeInfos']['above_200001']['saver_female'] }} {{ number_format($data['savingSizeInfos']['_below_2000']['balance']+ $data['savingSizeInfos']['_2001_to_5000']['balance']+ $data['savingSizeInfos']['_5001_to_10000']['balance']+$data['savingSizeInfos']['_10001_to_20000']['balance']+$data['savingSizeInfos']['above_200001']['balance'] ,2) }}