Expense Monthly Report - {{ $year ?? date('Y') }}

Expense Monthly Report

@if(isset($year)) Year: {{ $year }} @endif @if(isset($filters) && !empty($filters)) @if(!empty($filters['category_name'])) | Category: {{ $filters['category_name'] }} @endif @if(!empty($filters['location_name'])) | Location: {{ $filters['location_name'] }} @endif @if(!empty($filters['created_by_name'])) | Created By: {{ $filters['created_by_name'] }} @endif @endif

Generated on {{ date('F j, Y \a\t g:i A') }} | Page

@if(isset($summary))

Total Categories

Total Transactions

Total Expenses

${{ number_format($summary['total_expense'] ?? 0, 2) }}

Avg per Category

${{ number_format($summary['average_per_category'] ?? 0, 2) }}

@endif

@if(isset($expenseData) && count($expenseData) > 0) @php $monthTotals = [ 'jan' => 0, 'feb' => 0, 'mar' => 0, 'apr' => 0, 'may' => 0, 'jun' => 0, 'jul' => 0, 'aug' => 0, 'sep' => 0, 'oct' => 0, 'nov' => 0, 'dec' => 0 ]; $grandTotalExpenses = 0; @endphp @foreach($expenseData as $expense) @php $totalExpense = $expense['total_expense'] ?? 0; $grandTotalExpenses += $totalExpense; // Add to month totals foreach(['jan', 'feb', 'mar', 'apr', 'may', 'jun', 'jul', 'aug', 'sep', 'oct', 'nov', 'dec'] as $month) { $monthTotals[$month] += $expense[$month] ?? 0; } @endphp @endforeach

Category	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total Expense
{{ $expense['category_name'] ?? 'No Category' }}	${{ number_format($expense['jan'] ?? 0, 2) }}	${{ number_format($expense['feb'] ?? 0, 2) }}	${{ number_format($expense['mar'] ?? 0, 2) }}	${{ number_format($expense['apr'] ?? 0, 2) }}	${{ number_format($expense['may'] ?? 0, 2) }}	${{ number_format($expense['jun'] ?? 0, 2) }}	${{ number_format($expense['jul'] ?? 0, 2) }}	${{ number_format($expense['aug'] ?? 0, 2) }}	${{ number_format($expense['sep'] ?? 0, 2) }}	${{ number_format($expense['oct'] ?? 0, 2) }}	${{ number_format($expense['nov'] ?? 0, 2) }}	${{ number_format($expense['dec'] ?? 0, 2) }}	${{ number_format($totalExpense, 2) }}
TOTAL:	${{ number_format($monthTotals['jan'], 2) }}	${{ number_format($monthTotals['feb'], 2) }}	${{ number_format($monthTotals['mar'], 2) }}	${{ number_format($monthTotals['apr'], 2) }}	${{ number_format($monthTotals['may'], 2) }}	${{ number_format($monthTotals['jun'], 2) }}	${{ number_format($monthTotals['jul'], 2) }}	${{ number_format($monthTotals['aug'], 2) }}	${{ number_format($monthTotals['sep'], 2) }}	${{ number_format($monthTotals['oct'], 2) }}	${{ number_format($monthTotals['nov'], 2) }}	${{ number_format($monthTotals['dec'], 2) }}	${{ number_format($grandTotalExpenses, 2) }}

@else

No Data Available

No expense data found for the selected criteria.

@endif