Loan Collection Sheet

Staff: {{ $staff->name ?? '—' }} | Date: {{ \Carbon\Carbon::parse($today)->format('d-m-Y') }}

@php $grandLoanAmount = 0; $grandInstallment = 0; $grandPaid = 0; $grandTotalDue = 0; $grandExtraCharge = 0; $grandTotal = 0; @endphp @forelse($groupedMembers as $groupName => $members) @php $grpLoanAmount = $members->sum('loan_amount'); $grpInstallment = $members->sum('installment'); $grpPaid = $members->sum('paid_amount'); $grpTotalDue = $members->sum('total_due'); $grpExtra = $members->sum('extra_charge'); $grpGrandTotal = $members->sum(fn($m) => $m->total_due + $m->extra_charge); $grandLoanAmount += $grpLoanAmount; $grandInstallment += $grpInstallment; $grandPaid += $grpPaid; $grandTotalDue += $grpTotalDue; $grandExtraCharge += $grpExtra; $grandTotal += $grpGrandTotal; @endphp

Group: {{ $groupName }} ({{ $members->count() }} {{ $members->count() == 1 ? 'Member' : 'Members' }})

@foreach($members as $i => $m) @endforeach

#	A/C No	Loan A/C No	Member Name	Father/Husband	Mobile	Open Date	Loan Type	Loan Amount	Paid Amount	Total Due	Installment	Loan Collect	Savings Collect	Extra Charge
{{ $i + 1 }}	{{ $m->account_number }}	{{ $m->loan_ac_number }}	{{ $m->member_name }}	{{ $m->fat_hus_name }}	{{ $m->member_mobile }}	{{ \Carbon\Carbon::parse($m->opening_date)->format('d-m-Y') }}	{{ $m->loan_type }}	{{ number_format($m->loan_amount, 2) }}	{{ number_format($m->paid_amount, 2) }}	{{ number_format($m->total_due, 2) }}	{{ number_format($m->installment, 2) }}			{{ number_format($m->extra_charge, 2) }}
Group Subtotal								{{ number_format($grpLoanAmount, 2) }}	{{ number_format($grpPaid, 2) }}	{{ number_format($grpTotalDue, 2) }}	{{ number_format($grpInstallment, 2) }}			{{ number_format($grpExtra, 2) }}

@empty

No collection entries found for today or overdue for this staff.

@endforelse {{-- Grand Total --}} @if($groupedMembers->isNotEmpty())

GRAND TOTAL (All Groups)

@endif {{-- Signature row --}}

Prepared By

Field Staff

Authorized By

{{ $shop_infos->shop_name ?? '' }}