Balance Sheet
As of {{ \Carbon\Carbon::parse($asOfDate)->format('F d, Y') }}
@php
$assets = $groupedAccounts->filter(function($items, $type) {
return str_contains(strtolower($type), 'asset');
});
$liabilities = $groupedAccounts->filter(function($items, $type) {
return str_contains(strtolower($type), 'liability');
});
$equity = $groupedAccounts->filter(function($items, $type) {
return str_contains(strtolower($type), 'equity');
});
// Calculate totals correctly by account type, not normal balance
$totalAssets = $accounts->filter(function($item) {
return str_contains(strtolower($item->account_type), 'asset');
})->sum('balance');
$totalLiabilities = $accounts->filter(function($item) {
return str_contains(strtolower($item->account_type), 'liability');
})->sum('balance');
$totalEquity = $accounts->filter(function($item) {
return str_contains(strtolower($item->account_type), 'equity');
})->sum('balance');
@endphp
ASSETS
@foreach($assets as $accountType => $items)
{{ $accountType }}
@foreach($items as $account)
{{ $account->account_code }} - {{ $account->account_name
}}
{{ number_format((float) $account->balance, 2)
}}
@endforeach
Total {{ $accountType }}
{{ number_format((float) $items->sum('balance'), 2) }}
@endforeach
TOTAL ASSETS
{{ number_format($totalAssets, 2) }}
LIABILITIES & EQUITY
@foreach($liabilities as $accountType => $items)
{{ $accountType }}
@foreach($items as $account)
{{ $account->account_code }} - {{ $account->account_name
}}
{{ number_format((float) $account->balance, 2)
}}
@endforeach
Total {{ $accountType }}
{{ number_format((float) $items->sum('balance'), 2) }}
@endforeach
@foreach($equity as $accountType => $items)
{{ $accountType }}
@foreach($items as $account)
{{ $account->account_code }} - {{ $account->account_name
}}
{{ number_format((float) $account->balance, 2)
}}
@endforeach
Total {{ $accountType }}
{{ number_format((float) $items->sum('balance'), 2) }}
@endforeach
Current Period
NET - Net Income (Current Period)
{{ number_format((float) $netIncome, 2) }}
TOTAL LIABILITIES & EQUITY
{{ number_format($totalLiabilities + $totalEquity + $netIncome, 2)
}}
@php
$difference = abs($totalAssets - ($totalLiabilities + $totalEquity + $netIncome));
@endphp
@if($difference > 0.01)
⚠️ Balance Sheet does not balance! Difference: {{ number_format($difference, 2) }}
Assets: {{ number_format($totalAssets, 2) }} |
Liabilities + Equity + Net Income: {{ number_format($totalLiabilities + $totalEquity + $netIncome,
2) }}
@else
✓ Balance Sheet is balanced
Assets: {{ number_format($totalAssets, 2) }} = Liabilities: {{ number_format($totalLiabilities, 2)
}} + Equity: {{ number_format($totalEquity, 2) }} + Net Income: {{ number_format($netIncome, 2) }}
@endif