{{ session('company_name') }}

FINAL STATEMENT OF ACCOUNT

@foreach ($account as $a) {{-- --}} @endforeach

Account Number	{{ $a->acct_number }}	Contract Number	{{ $a->contract_no }}
Account Number	{{ $a->acct_number }}	Contract Number	{{ $a->contract_no }}
Customer Name	{{ $a->cust_name }}	Address	{{ $a->address }}
Classification	{{ $a->acct_class }}	JO Number	{{ $a->jo_number }}
Guarantee Deposit			{{ $a->gdeposit }}
Remaining Advances			@php if($a->advances == 0){ $a->advances = '0.00'; } @endphp {{ $a->advances }}

less Unpaid Water Bills

@foreach ($waterbills as $d) @php $t_bill_amount += $d->bill_amount; $t_atb += $d->atb; $t_penalty += $d->penalty; $t_septage_fee += $d->septage_fee; $t_amount_paid += $d->amount_paid; $t_total_due += $d->total_due; $t_offset += $d->offset_gd; $t_net_amount += $d->net_amount; @endphp @endforeach

Bill Type	Bill Period	Bill Number	Bill Amount	Others	Penalty	Septage Fee	Amount Paid	Total Due	Offset	Net Amount
{{ $d->tran_description }}	{{ $d->bill_period }}	{{ $d->bill_number }}	{{ $d->bill_amount }}	{{ $d->atb }}	{{ $d->penalty }}	{{ $d->septage_fee }}	{{ $d->amount_paid }}	{{ $d->total_due }}	{{ $d->offset_gd }}	{{ $d->net_amount }}
Total			{{ number_format((float)$t_bill_amount, 2,".",",") }}	{{ number_format((float)$t_atb, 2,".",",") }}	{{ number_format((float)$t_penalty, 2,".",",") }}	{{ number_format((float)$t_septage_fee, 2,".",",") }}	{{ number_format((float)$t_amount_paid, 2,".",",") }}	{{ number_format((float)$t_total_due, 2,".",",") }}	{{ number_format((float)$t_offset, 2,".",",") }}	{{ number_format((float)$t_net_amount, 2,".",",") }}

less Other Payables

@foreach ($ot__payables as $o) @php $o_total_due += $o->total_due; $o_offset += $o->offset_gd; $o_net_amount += $o->net_amount; @endphp @endforeach

Transaction Type								Total Due	Offset	Net Amount
{{ $o->tran_description }}								{{ number_format((float)$o->total_due, 2,".",",") }}	{{ number_format((float)$o->offset_gd, 2,".",",") }}	{{ number_format((float)$o->net_amount, 2,".",",") }}
Total								{{ number_format((float)$o_total_due, 2,".",",") }}	{{ number_format((float)$o_offset, 2,".",",") }}	{{ number_format((float)$o_net_amount, 2,".",",") }}

{{--

--}}

Summary

@foreach ($account as $ac) @php $balance = $ac->gdeposit + $ac->advances; $payable_amt = $ac->total_payables - $balance; @endphp @endforeach

Total Payables	{{ number_format((float)$ac->total_payables, 2,".",",") }}
GD + Advances	{{ number_format((float)$balance, 2,".",",") }}
@php if($payable_amt < 0){ echo 'Refundable Amount'; } else { echo 'Payable Amount'; } @endphp	{{ $payable_amt < 0 ? "(".number_format(abs($payable_amt), 2).")" : number_format($payable_amt, 2) }}

Remarks

Prepared By:	Verified By:	Approved By:
@foreach ($created as $c) {{ ucwords($c->name) }} @endforeach	@foreach ($verified as $v) {{ $v->full_name }} @endforeach	@foreach ($approved as $a) {{ $a->full_name }} @endforeach
@foreach ($created as $c) {{ 'Branch' . " " . ucfirst(strtolower($c->designation)) }} @endforeach	@foreach ($verified as $v) {{ $v->designation }} @endforeach	@foreach ($approved as $a) {{ $a->designation }} @endforeach

Reference Number

@foreach ($account as $ac) {{ $ac->ref_number }} @endforeach