@foreach($rows as $b) @php $tokenPaid = (float) $b->payments->where('status','cleared')->where('payment_category','token')->sum('amount'); $downPaid = (float) $b->payments->where('status','cleared')->where('payment_category','down_payment')->sum('amount'); $instPaid = (float) $b->payments->where('status','cleared')->where('payment_category','installment')->sum('amount'); $paid = $tokenPaid + $downPaid + $instPaid; $balance = max(0, (float) $b->total_price - $paid); @endphp @endforeach

Project	Booking #	Customer	Unit	Total	Token Paid	Down Paid	Installments Paid	Balance	Status
{{ $b->project?->name }}	{{ $b->booking_number }}	{{ $b->customer?->name }}	{{ $b->unit?->unit_number }}	{{ number_format($b->total_price,2) }}	{{ number_format($tokenPaid,2) }}	{{ number_format($downPaid,2) }}	{{ number_format($instPaid,2) }}	{{ number_format($balance,2) }}	{{ $b->status }}