{{ strtoupper(session('company_name')) }}

{{ strtoupper(session('branch_name')) }}

Account Deactivation Report


Date Deactivated {{ date_format(date_create($header->created_at), 'm/d/Y h:i A') }} JO Number (JO Disconnection) {{ $header->jo_number }}
Reference Number {{ $header->reference_no }} Date Created {{ $header->jo_number != 'N/A' ? date_format(date_create($header->jo_created_at), 'm/d/Y h:i A') : 'N/A' }}
Customer's Name {{ $header->cust_name }} | {{ $header->acct_number }} | {{ $header->acct_class }}-{{ $header->acct_subclass }} Date Accomplished {{ $header->jo_number != 'N/A' ? date_format(date_create($header->jo_finished_at), 'm/d/Y h:i A') : 'N/A' }}
Service Address {{ ucwords($header->address) }} Contract Number {{ $header->contract_no }}
Remarks {{ $header->remarks ? $header->remarks : 'N/A' }}
Refundable Guarantee Deposit {{ number_format($header->gdeposit,2) }}
Remaining Advances {{ number_format($header->advances,2) }}
@if($wbills->count() > 0) @foreach($wbills AS $wb) @endforeach @endif @if($others->count() > 0) @foreach($others AS $ot) @endforeach @endif @if($gtotal_before <= 0) @else @endif @if ($athena) @endif
less WATER BILLS
Bill Number Bill Amt AtB Septage FTax MCharges Total Due Partial Senior Penalty Balance Due Date Senior Penalty Overdue Balance
{{ $wb->bill_number }} | {{ $wb->bill_type }} | {{ sprintf('%02d', $wb->bill_month) }}-{{ $wb->bill_year }} {{ number_format($wb->bill_amount,2) }} {{ number_format($wb->atb,2) }} {{ number_format($wb->septage_fee,2) }} {{ number_format($wb->franchise_tax,2) }} {{ number_format($wb->meter_charges,2) }} {{ number_format($wb->total_due,2) }} ({{ number_format($wb->advance+$wb->amount_paid,2) }}) ({{ number_format($wb->is_overdue == 1 ? $wb->senior_after : $wb->senior_before,2) }}) {{ number_format($wb->is_overdue == 1 ? $wb->penalty : 0,2) }} {{ number_format($wb->balance_before_due,2) }} {{ $wb->due_date }} ({{ number_format($wb->senior_after,2) }}) {{ number_format($wb->penalty_after,2) }} {{ number_format($wb->balance_after_due,2) }}
  {{ number_format($wbills->sum('bill_amount'),2) }} {{ number_format($wbills->sum('atb'),2) }} {{ number_format($wbills->sum('septage_fee'),2) }} {{ number_format($wbills->sum('franchise_tax'),2) }} {{ number_format($wbills->sum('meter_charges'),2) }} {{ number_format($wbills->sum('total_due'),2) }} ({{ number_format($wbills->sum('advance') + $wbills->sum('amount_paid'),2) }}) ({{ number_format($wbills->sum('senior_before'),2) }}) {{ number_format($wbills->sum('penalty_before'),2) }} {{ number_format($wbills->sum('balance_before_due'),2) }}   ({{ number_format($wbills->sum('senior_after'),2) }}) {{ number_format($wbills->sum('penalty_after'),2) }} {{ number_format($wbills->sum('total_due') - $wbills->sum('advance') - $wbills->sum('amount_paid') - $wbills->sum('senior_after') + $wbills->sum('penalty'),2) }}
less OTHER PAYABLES
{{ $ot->reference == 'Others' ? $ot->reference_others : $ot->reference }} {{ number_format($ot->amt_net,2) }} ({{ number_format($ot->amt_paid,2) }}) {{ number_format($ot->balance,2) }} {{ number_format($ot->balance,2) }}
  {{ number_format($others->sum('amt_net'),2) }} ({{ number_format($others->sum('amt_paid'),2) }}) {{ number_format($others->sum('balance'),2) }} {{ number_format($others->sum('balance'),2) }}
 
Net {{ $header->net_amount >= 0 ? 'Payable' : 'Refund' }}{{ number_format(abs($header->net_amount),2,'.',',') }}BEFORE DUE DATE: {{ $gtotal_before > 0 ? "(".number_format($gtotal_before,2,'.',',').")" : number_format(abs($gtotal_before),2,'.',',') }} AFTER DUE DATE OF LATEST BILL: {{ $gtotal_after > 0 ? "(".number_format($gtotal_after,2,'.',',').")" : number_format(abs($gtotal_after),2,'.',',') }}
Athena Loan (Guarantee Deposit will not be applied on Athena Loans)* {{ number_format(abs($athena->net_amount),2,'.',',') }}
Prepared By: Verified By: Approved By: Customer's Signature:
{{ strtoupper($header->name) }} {{ strtoupper($verified->full_name) }} {{ strtoupper($approved->full_name) }} {{ strtoupper($header->cust_name) }}
Biller/CSA {{ $verified->designation }} {{ $approved->designation }} Customer
Date Refunded: ______________________________ Teller/CSA: ______________________________