Rent Collection Report

Total Collected

UGX {{ number_format($total_collected, 2) }}

{{ $total_transactions }} transactions

Expected Rent

UGX {{ number_format($expected_rent, 2) }}

For the period

Collection Rate

{{ number_format($collection_rate, 1) }}%

Average Payment

UGX {{ number_format($average_payment, 2) }}

Per transaction

Payment Status Distribution

Status	Count	Percentage
✅ On Time Payments	{{ $status_distribution['on_time'] }}	{{ $total_transactions > 0 ? number_format(($status_distribution['on_time'] / $total_transactions) * 100, 1) : 0 }}%
⚠️ Late Payments	{{ $status_distribution['late'] }}	{{ $total_transactions > 0 ? number_format(($status_distribution['late'] / $total_transactions) * 100, 1) : 0 }}%

Collections by {{ ucfirst($group_by) }}

@if(count($grouped_data) > 0)

@foreach($grouped_data as $label => $amount) @php $maxAmount = max($grouped_data); $percentage = $maxAmount > 0 ? ($amount / $maxAmount) * 100 : 0; @endphp

UGX {{ number_format($amount, 2) }}

@endforeach

@else

No data available for the selected period.

@endif

{{-- Top Tenants --}} @if(count($top_tenants) > 0)

Top Paying Tenants

@foreach($top_tenants as $tenant => $amount) @endforeach

Tenant Name	Total Paid	Percentage of Total
{{ $tenant }}	UGX {{ number_format($amount, 2) }}	{{ $total_collected > 0 ? number_format(($amount / $total_collected) * 100, 1) : 0 }}%

@endif