Month | {{ date('M-Y', strtotime($dates['year'] . '-' . $dates['month'])) }} | @if(Auth::user()->franchise && Auth::user()->franchise->countries && Auth::user()->franchise->countries->currency_code) | (Amounts are in {{ Auth::user()->franchise->countries->currency_code }}) | @else(Amounts are in TZS) | @endif
Withholder WHT Log Report |
PV / PC Number | TIN | WHT (%) | Company Name | Receipt Invoice Number | Receipt Date | Description | WHT Exclusive | WHT Amount |
---|---|---|---|---|---|---|---|---|
@if($wht_log->is_payment_voucher) PV{{ $wht_log->pv_serial_number ?? '' }} @else PC{{ $wht_log->serial_number ?? '' }} @endif | {{ $wht_log->company->registrations[0]->registration_value ?? '' }} | {{ $wht_log->tax_value ?? '' }}% | {{ $wht_log->company->name ?? '' }} | @if($wht_log->is_payment_voucher) {{ $wht_log->lpo_receipt_invoice_number }} @else {{ $wht_log->receipt_number }} @endif | @if($wht_log->is_payment_voucher) {{ $wht_log->receipt_date_formatted }} @else {{ $wht_log->date_formatted }} @endif | @if($wht_log->is_payment_voucher) {{ $wht_log->description }} @else {{ $wht_log->short_description }} @endif | @if($wht_log->is_payment_voucher) {{ round($wht_log->total_amount_converted, 2) }} @else {{ round($wht_log->total_amount, 2) }} @endif | {{ round($wht_log->vat_amount, 2) }} |
{{ round($whtExclusive, 2) }} | {{ round($whtAmount, 2) }} |
WHT Allocation |
@foreach($departmentList as $dept) | subdepts_count > 0) colspan="{{ $dept->subdepts_count }}" @endif style="border: 1px solid black; text-align: center; background-color: @if($loop->odd) #CCB2FF @elseif($loop->even) #FFE6AB @endif">{{ $dept->name }} | @endforeachTotal | |
---|---|---|---|
{{ $sub_dept->name }} | @endforeach @else- | @endif @endforeach||
WHT Amount | @foreach($departmentList as $dept) @if($dept->subdepts_count > 0) @foreach($dept->subdepts as $sub_dept)@isset($whtLogExpense['subdepts'][$sub_dept->id]) @php $tempAmount['sub_dept'][$sub_dept->id] = (isset($whtLogExpense['subdepts'][$sub_dept->id]) ? $whtLogExpense['subdepts'][$sub_dept->id] : 0); @endphp @if($tempAmount['sub_dept'][$sub_dept->id] > 0) @php if(isset($totalWhtAmount)) $totalWhtAmount += $tempAmount['sub_dept'][$sub_dept->id]; else $totalWhtAmount = $tempAmount['sub_dept'][$sub_dept->id]; @endphp {{ round($tempAmount['sub_dept'][$sub_dept->id], 2) }} @endif @endisset | @endforeach @else@isset($whtLogExpense['depts'][$dept->id]) @php $tempAmount['dept'][$dept->id] = $whtLogExpense['depts'][$dept->id]; @endphp @if(isset($tempAmount['dept'][$dept->id]) && $tempAmount['dept'][$dept->id] > 0) @php if(isset($totalWhtAmount)) $totalWhtAmount += $tempAmount['dept'][$dept->id]; else $totalWhtAmount = $tempAmount['dept'][$dept->id]; @endphp {{ round($tempAmount['dept'][$dept->id], 2) }} @endif @endisset | @endif @endforeach@isset($totalWhtAmount) @if($totalWhtAmount > 0) {{ round($totalWhtAmount, 2) }} @endif @endisset |
Allocation | @foreach($departmentList as $dept) @if($dept->subdepts_count > 0) @foreach($dept->subdepts as $sub_dept)@if(isset($whtLogExpense['subdepts'][$sub_dept->id]) && isset($tempAmount['sub_dept'][$sub_dept->id]) && isset($totalWhtAmount)) @php $tempPercentage = ($tempAmount['sub_dept'][$sub_dept->id] * 100) / $totalWhtAmount; @endphp @if($totalWhtAmount > 0 && $tempPercentage > 0) @php if(isset($totalPercentage)) $totalPercentage += $tempPercentage; else $totalPercentage = $tempPercentage; @endphp {{ round($tempPercentage, 2) }}% @endif @endif | @endforeach @else@if(isset($whtLogExpense['depts'][$dept->id]) && isset($tempAmount['dept'][$dept->id]) && isset($totalWhtAmount)) @php $tempPercentage = ($tempAmount['dept'][$dept->id] * 100) / $totalWhtAmount; @endphp @if($totalWhtAmount > 0 && $tempPercentage > 0) @php if(isset($totalPercentage)) $totalPercentage += $tempPercentage; else $totalPercentage = $tempPercentage; @endphp {{ round($tempPercentage, 2) }}% @endif @endif | @endif @endforeach@if(isset($totalPercentage)) {{ round(($totalPercentage > 100) ? '100.00' : $totalPercentage, 2) }}% @endif |