Vehicle Wise Profit & Loss Report

Period: {{ \Carbon\Carbon::parse($filters['from_date'])->format('d-m-Y') }} to {{ \Carbon\Carbon::parse($filters['to_date'])->format('d-m-Y') }}  |  Generated At: {{ $generated_at }}
@php $sumRevenue = 0; $sumTripCost = 0; $sumFuel = 0; $sumMaint = 0; $sumOther = 0; $sumTotalCost = 0; $sumNetProfit = 0; @endphp @forelse($items as $item) @php $sumRevenue += $item['trip_revenue']; $sumTripCost += $item['trip_cost']; $sumFuel += $item['fuel_expenses']; $sumMaint += $item['maintenance_expenses']; $sumOther += $item['other_expenses']; $sumTotalCost += $item['total_cost']; $sumNetProfit += $item['net_profit']; @endphp @empty @endforelse @if(!empty($items)) @php $overallMargin = $sumRevenue > 0 ? ($sumNetProfit / $sumRevenue) * 100.0 : 0.0; @endphp @endif
Registration Model Trip Revenue Trip Cost Fuel Expenses Maintenance Other Expenses Total Cost Net Profit Margin %
{{ $item['registration'] }} {{ $item['vehicle_model'] }} ₹{{ number_format($item['trip_revenue'], 2) }} ₹{{ number_format($item['trip_cost'], 2) }} ₹{{ number_format($item['fuel_expenses'], 2) }} ₹{{ number_format($item['maintenance_expenses'], 2) }} ₹{{ number_format($item['other_expenses'], 2) }} ₹{{ number_format($item['total_cost'], 2) }} ₹{{ number_format($item['net_profit'], 2) }} {{ number_format($item['margin_pct'], 2) }}%
No records found for the selected period.
TOTAL ₹{{ number_format($sumRevenue, 2) }} ₹{{ number_format($sumTripCost, 2) }} ₹{{ number_format($sumFuel, 2) }} ₹{{ number_format($sumMaint, 2) }} ₹{{ number_format($sumOther, 2) }} ₹{{ number_format($sumTotalCost, 2) }} ₹{{ number_format($sumNetProfit, 2) }} {{ number_format($overallMargin, 2) }}%