@php
    // Helper for formatting negatives
    function fmt($amount) {
        return $amount < 0
            ? '(' . number_format(abs($amount), 2) . ')'
            : number_format($amount, 2);
    }

    // Rebuild grouped data (same as in controller)
    $assets = $data->where('account_type', 'asset');
    $liabilities = $data->where('account_type', 'liability');
    $equity = $data->where('account_type', 'equity');

    $total_assets = $assets->sum('debit') - $assets->sum('credit');
    $total_liabilities = $liabilities->sum('credit') - $liabilities->sum('debit');
    $total_equity = $equity->sum('credit') - $equity->sum('debit');
    $total_liab_equity = $total_liabilities + $total_equity;
@endphp


<h3 class="text-center" style="text-align:center;">{{ get_business_name() }}</h3>
<h3 class="text-center" style="text-align:center;">{{ trans_choice('accounting::general.balance_sheet', 1) }}</h3>
<h4 class="text-center" style="text-align:center;"> @if (!empty($location_id) && !empty($data->first()->business_location))
                    {{ trans_choice('accounting::lang.business_location', 1) }}:
                    {{ $data->first()->business_location }}
                @endif</h4>
                
<h4 class="text-center" style="text-align:center;">{{ trans_choice('accounting::general.as_on', 1) }}: {{ readable_date($end_date) }}</h4>
 <table width="100%" cellspacing="0" cellpadding="10" style="border-collapse: collapse;">
      
    <tr>
        <!-- Assets Column -->
        <td width="50%" valign="top" style="border: 1px solid #ddd; padding: 15px;">
            <h4><strong>{{ __('Assets') }}</strong></h4>
            <table class="table table-bordered table-striped" width="100%">
                <thead>
                    <tr>
                        <th>{{ trans_choice('accounting::lang.account', 1) }}</th>
                        <th class="text-right">{{ trans_choice('accounting::general.balance', 1) }}</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach ($assets as $acc)
                        @php $balance = $acc->debit - $acc->credit; @endphp
                        <tr>
                            <td>{{ $acc->name }}</td>
                            <td class="text-right">{{ fmt($balance) }}</td>
                        </tr>
                    @endforeach
                    <tr class="font-weight-bold bg-subtotal">
                        <td>{{ __('Total Assets') }}</td>
                        <td class="text-right">{{ fmt($total_assets) }}</td>
                    </tr>
                </tbody>
            </table>
        </td>

        <!-- Liabilities & Equity Column -->
        <td width="50%" valign="top" style="border: 1px solid #ddd; padding: 15px;">
            <h4><strong>{{ __('Liabilities and Equity') }}</strong></h4>
            <table class="table table-bordered table-striped" width="100%">
                <thead>
                    <tr>
                        <th>{{ trans_choice('accounting::lang.account', 1) }}</th>
                        <th class="text-right">{{ trans_choice('accounting::general.balance', 1) }}</th>
                    </tr>
                </thead>
                <tbody>
                    <tr class="bg-light">
                        <td colspan="2"><strong>{{ __('Liabilities') }}</strong></td>
                    </tr>
                    @foreach ($liabilities as $acc)
                        @php $balance = $acc->credit - $acc->debit; @endphp
                        <tr>
                            <td>{{ $acc->name }}</td>
                            <td class="text-right">{{ fmt($balance) }}</td>
                        </tr>
                    @endforeach
                    <tr class="font-weight-bold bg-subtotal">
                        <td>{{ __('Total Liabilities') }}</td>
                        <td class="text-right">{{ fmt($total_liabilities) }}</td>
                    </tr>

                    <tr class="bg-light">
                        <td colspan="2"><strong>{{ __('Equity') }}</strong></td>
                    </tr>
                    @foreach ($equity as $acc)
                        @php $balance = $acc->credit - $acc->debit; @endphp
                        <tr>
                            <td>{{ $acc->name }}</td>
                            <td class="text-right">{{ fmt($balance) }}</td>
                        </tr>
                    @endforeach
                    <tr class="font-weight-bold bg-subtotal">
                        <td>{{ __('Total Equity') }}</td>
                        <td class="text-right">{{ fmt($total_equity) }}</td>
                    </tr>
                    <tr class="font-weight-bold bg-grand-total">
                        <td>{{ __('Total Liabilities and Equity') }}</td>
                        <td class="text-right">{{ fmt($total_liab_equity) }}</td>
                    </tr>
                </tbody>
            </table>
        </td>
        
        
        <tr>
            <td>{{ __('Total Assets') }}:  <span style="float:right;">{{ fmt($total_assets) }}</span></td>
            <td>{{ __('Total Liabilities and Equity') }}:  <span style="float:right;">{{ fmt($total_liab_equity) }}</span></td>
        </tr>
    </tr>
</table>