@include('templates.pdf_header', [ 'organisation' => $organisation, 'title' => 'Income Statement (Comparison)', 'currency_code' => $currency ]) @php $incomeCurrent = 0; $incomePrevious = 0; $expenseCurrent = 0; $expensePrevious = 0; @endphp {{-- ================= INCOME ================= --}} @foreach($data as $section) @if($section->group_name === 'Revenue') @foreach($section->subcategories as $subcat) @php $incomeCurrent += $subcat->total; $incomePrevious += $subcat->previous_total; $variance = $subcat->total - $subcat->previous_total; @endphp @endforeach @endif @endforeach {{-- ================= EXPENSES ================= --}} @foreach($data as $section) @if(in_array($section->group_name, ['Expenses','Interest & Taxes'])) @foreach($section->subcategories as $subcat) @php $expenseCurrent += $subcat->total; $expensePrevious += $subcat->previous_total; $variance = $subcat->total - $subcat->previous_total; @endphp @endforeach @endif @endforeach {{-- ================= NET PROFIT ================= --}} @php $netCurrent = $incomeCurrent - $expenseCurrent; $netPrevious = $incomePrevious - $expensePrevious; $netVariance = $netCurrent - $netPrevious; @endphp

Particulars	Current	Previous	Variance
Incomes
{{ $subcat->name }}	{{ number_format($subcat->total,2) }}	{{ number_format($subcat->previous_total,2) }}	{{ number_format($variance,2) }}
Total Incomes	{{ number_format($incomeCurrent,2) }}	{{ number_format($incomePrevious,2) }}	{{ number_format($incomeCurrent-$incomePrevious,2) }}
Expenses
{{ $subcat->name }}	{{ number_format($subcat->total,2) }}	{{ number_format($subcat->previous_total,2) }}	{{ number_format($variance,2) }}
Total Expenses	{{ number_format($expenseCurrent,2) }}	{{ number_format($expensePrevious,2) }}	{{ number_format($expenseCurrent-$expensePrevious,2) }}
Net Profit / Loss	{{ number_format($netCurrent,2) }}	{{ number_format($netPrevious,2) }}	{{ number_format($netVariance,2) }}