@if(Auth::user()->franchise && Auth::user()->franchise->countries && Auth::user()->franchise->countries->currency_code) @else @endif
Month {{ date('M-Y', strtotime($dates['year'] . '-' . $dates['month'])) }} (Amounts are in {{ Auth::user()->franchise->countries->currency_code }})(Amounts are in TZS)
@foreach($taxList as $tax) @endforeach @foreach($departments as $department) @endforeach @foreach($departments as $department) @if($department->subdepts->count() != 0) @foreach($department->subdepts as $sub_dept) @endforeach @else @endif @endforeach @foreach($departments as $department) @if($department->subdepts->count() != 0) @foreach($department->subdepts as $sub_dept) @endforeach @else @endif @endforeach @foreach ($taxList as $tax) @endforeach @foreach($departments as $department) @if($department->subdepts_count > 0) @foreach($department->subdepts as $sub_dept) @endforeach @else @endif @endforeach @foreach($pettyCashes as $petty_cash) @php if(isset($credit_general_dept)) $credit_general_dept += $petty_cash->credit_general; else $credit_general_dept = $petty_cash->credit_general; if(isset($debit_general_dept)) $debit_general_dept += $petty_cash->debit_general; else $debit_general_dept = $petty_cash->debit_general; $totalTax = 0; $taxes = $petty_cash->taxes->pluck('tax_value', 'tax_title')->toArray(); foreach($taxes as $key => $val) { if($petty_cash->tax_excluded_values && isset($petty_cash->tax_excluded_values[$key]) && $petty_cash->tax_excluded_values[$key] == 1) { $totalTax += $taxes[$key]; } } if(isset($totalAmount[$petty_cash->entry_type])){ $totalAmount[$petty_cash->entry_type] += getPercentageAndAdd($petty_cash['total_' . $petty_cash->entry_type . '_amount'], $totalTax); } else { $totalAmount[$petty_cash->entry_type] = getPercentageAndAdd($petty_cash['total_' . $petty_cash->entry_type . '_amount'], $totalTax); } if(isset($totalDebitTax) && $petty_cash->entry_type == 'debit') { $totalDebitTax += getPercentage($petty_cash['total_debit_amount'], $totalTax); } elseif($petty_cash->entry_type == 'debit') { $totalDebitTax = getPercentage($petty_cash['total_debit_amount'], $totalTax); } if($petty_cash->entry_type == 'credit') { $carriedOverAmounts[$petty_cash->payment_mode . 'BalanceAmount'] += getPercentageAndAdd($petty_cash['total_' . $petty_cash->entry_type . '_amount'], $totalTax); } else if($petty_cash->entry_type == 'debit') { $carriedOverAmounts[$petty_cash->payment_mode . 'BalanceAmount'] -= getPercentageAndAdd($petty_cash['total_' . $petty_cash->entry_type . '_amount'], $totalTax); } @endphp @foreach ($taxList as $tax) @endforeach @foreach($departments as $department) @if($department->subdepts_count > 0) @foreach($department->subdepts as $sub_dept) @php if(isset($subDeptTotal[$petty_cash->entry_type][$sub_dept->id])){ $subDeptTotal[$petty_cash->entry_type][$sub_dept->id] += getPercentageAndAdd($petty_cash[$petty_cash->entry_type . '_sub_split_' . $sub_dept->id], $totalTax); } else { $subDeptTotal[$petty_cash->entry_type][$sub_dept->id] = getPercentageAndAdd($petty_cash[$petty_cash->entry_type . '_sub_split_' . $sub_dept->id], $totalTax); } if(isset($subDepttotalDebitTax[$sub_dept->id]) && $petty_cash->entry_type == 'debit') { $subDepttotalDebitTax[$sub_dept->id] += getPercentage($petty_cash['debit_sub_split_' . $sub_dept->id], $totalTax); } elseif($petty_cash->entry_type == 'debit') { $subDepttotalDebitTax[$sub_dept->id] = getPercentage($petty_cash['debit_sub_split_' . $sub_dept->id], $totalTax); } @endphp @endforeach @elseif ($petty_cash['credit_split_' . $department->id] != null || $petty_cash['debit_split_' . $department->id] != null) @php if(isset($deptTotal[$petty_cash->entry_type][$department->id])){ $deptTotal[$petty_cash->entry_type][$department->id] += getPercentageAndAdd($petty_cash[$petty_cash->entry_type . '_split_' . $department->id], $totalTax); } else { $deptTotal[$petty_cash->entry_type][$department->id] = getPercentageAndAdd($petty_cash[$petty_cash->entry_type . '_split_' . $department->id], $totalTax); } if(isset($deptTotalDebitTax[$department->id]) && $petty_cash->entry_type == 'debit') { $deptTotalDebitTax[$department->id] += getPercentage($petty_cash['debit_split_' . $department->id], $totalTax); } elseif($petty_cash->entry_type == 'debit') { $deptTotalDebitTax[$department->id] = getPercentage($petty_cash['debit_split_' . $department->id], $totalTax); } @endphp @else @endif @endforeach @endforeach @foreach ($taxList as $tax) @endforeach @foreach ($departments as $department) @if($department->subdepts_count > 0) @foreach($department->subdepts as $sub_dept) @endforeach @elseif($department->subdepts_count == 0) @endif @endforeach @foreach ($taxList as $tax) @endforeach @foreach ($departments as $department) @if($department->subdepts_count > 0) @foreach($department->subdepts as $sub_dept) @endforeach @elseif($department->subdepts_count == 0) @endif @endforeach @foreach ($taxList as $tax) @endforeach @foreach ($departments as $department) @endforeach @foreach ($departments as $department) @if($department->subdepts_count > 0) @foreach ($department->subdepts as $sub_dept) @endforeach @elseif ($department->subdepts_count == 0) @endif @endforeach @foreach ($departments as $department) @if($department->subdepts_count > 0) @foreach ($department->subdepts as $sub_dept) @endforeach @elseif ($department->subdepts_count == 0) @endif @endforeach @foreach ($departments as $department) @if($department->subdepts_count > 0) @foreach ($department->subdepts as $sub_dept) @endforeach @elseif ($department->subdepts_count == 0) @endif @endforeach @foreach ($departments as $department) @if($department->subdepts_count > 0) @foreach ($department->subdepts as $sub_dept) @endforeach @elseif ($department->subdepts_count == 0) @endif @endforeach @foreach ($departments as $department) @if ($department->subdepts_count > 0) @foreach ($department->subdepts as $sub_dept) @php $tempTotalPl = 0; $tempTotalCr = isset($subDeptTotal['credit'][$sub_dept->id]) ? $subDeptTotal['credit'][$sub_dept->id] : 0; $tempTotalDr = isset($subDeptDebitTaxExcl[$sub_dept->id]) ? $subDeptDebitTaxExcl[$sub_dept->id] : 0; $tempTotalPl = $tempTotalCr - $tempTotalDr; @endphp @endforeach @elseif ($department->subdepts_count == 0) @php $tempTotalPl = 0; $tempTotalCr = isset($deptTotal['credit'][$department->id]) ? $deptTotal['credit'][$department->id] : 0; $tempTotalDr = isset($deptDebitTaxExcl[$department->id]) ? $deptDebitTaxExcl[$department->id] : 0; $tempTotalPl = $tempTotalCr - $tempTotalDr; @endphp @endif @endforeach
Date PC ID Type Payment Mode Description Added By{{ ($tax->tax_title == 'Withholding Tax') ? 'WHT' : $tax->tax_title }} (%)General {{ $department->name }} General Empower Balance Cash Balance Digital Balance Card
{{ $sub_dept->name }}-
CRCR DRCR DRDR CR DR
Carried Over {{ round($carriedOverAmounts['cashBalanceAmount'], 2) }} {{ round($carriedOverAmounts['digitalBalanceAmount'], 2) }} {{ round($carriedOverAmounts['cardBalanceAmount'], 2) }}
{{ $petty_cash->date_formatted }} {{ $petty_cash->serial_number }} {{ ucfirst($petty_cash->entry_type) }}-{{ $petty_cash->entry_type == 'credit' ? ucfirst($petty_cash->credit_type) : ucfirst($petty_cash->debit_type) }} {{ ucfirst($petty_cash->payment_mode) }} {{ $petty_cash->short_description }} {{ $petty_cash->owner->full_name }}{{ $petty_cash[$tax->tax_title] ? $petty_cash[$tax->tax_title] . '%' : '' }} {{ $petty_cash->credit_general ? round($petty_cash->credit_general, 2) : '' }} {{ isset($petty_cash['credit_sub_split_' . $sub_dept->id]) ? round(getPercentageAndAdd($petty_cash['credit_sub_split_' . $sub_dept->id], $totalTax), 2) : ''}} {{ isset($petty_cash['debit_sub_split_' . $sub_dept->id]) ? round(getPercentageAndAdd($petty_cash['debit_sub_split_' . $sub_dept->id], $totalTax), 2) : '' }} {{ isset($petty_cash['credit_split_' . $department->id]) ? round(getPercentageAndAdd($petty_cash['credit_split_' . $department->id], $totalTax), 2) : '' }} {{ isset($petty_cash['debit_split_' . $department->id]) ? round(getPercentageAndAdd($petty_cash['debit_split_' . $department->id], $totalTax), 2) : '' }} {{ isset($petty_cash->debit_general) ? round($petty_cash->debit_general, 2) : '' }} {{ isset($petty_cash->total_credit_amount) ? round(getPercentageAndAdd($petty_cash->total_credit_amount, $totalTax), 2) : '' }} {{ isset($petty_cash->total_debit_amount) ? round(getPercentageAndAdd($petty_cash->total_debit_amount, $totalTax), 2) : '' }} {{ isset($carriedOverAmounts['cashBalanceAmount']) ? round($carriedOverAmounts['cashBalanceAmount'], 2) : '' }} {{ isset($carriedOverAmounts['digitalBalanceAmount']) ? round($carriedOverAmounts['digitalBalanceAmount'], 2) : '' }} {{ isset($carriedOverAmounts['cardBalanceAmount']) ? round($carriedOverAmounts['cardBalanceAmount'], 2) : '' }}
{{ isset($credit_general_dept) ? round($credit_general_dept, 2) : ''}} {{ isset($subDeptTotal['credit'][$sub_dept->id]) && $subDeptTotal['credit'][$sub_dept->id] != 0 ? round($subDeptTotal['credit'][$sub_dept->id], 2) :'' }} {{ isset($subDeptTotal['debit'][$sub_dept->id]) && $subDeptTotal['debit'][$sub_dept->id] != 0 ? round($subDeptTotal['debit'][$sub_dept->id], 2) : '' }} {{ isset($deptTotal['credit'][$department->id]) && $deptTotal['credit'][$department->id] != 0 ? round($deptTotal['credit'][$department->id], 2) :'' }} {{ isset($deptTotal['debit'][$department->id]) && $deptTotal['debit'][$department->id] != 0 ? round($deptTotal['debit'][$department->id], 2) : '' }} {{ isset($debit_general_dept) && $debit_general_dept != 0 ? round($debit_general_dept, 2) : ''}} {{ isset($totalAmount['credit']) ? round($totalAmount['credit'], 2) : '' }} {{ isset($totalAmount['debit']) ? round($totalAmount['debit'], 2) : '' }} {{ isset($carriedOverAmounts['cashBalanceAmount']) ? round($carriedOverAmounts['cashBalanceAmount'], 2) : '' }} {{ isset($carriedOverAmounts['digitalBalanceAmount']) ? round($carriedOverAmounts['digitalBalanceAmount'], 2) : '' }} {{ isset($carriedOverAmounts['cardBalanceAmount']) ? round($carriedOverAmounts['cardBalanceAmount'], 2) : '' }}
{{ isset($credit_general_dept) && $credit_general_dept != 0 ? round($credit_general_dept, 2) : ''}} @php if(isset($subDeptTotal['credit'][$sub_dept->id]) && isset($subDeptTotal['debit'][$sub_dept->id])) $tempSubDeptTotal[$sub_dept->id] = $subDeptTotal['credit'][$sub_dept->id] - $subDeptTotal['debit'][$sub_dept->id]; elseif(isset($subDeptTotal['credit'][$sub_dept->id]) && !isset($subDeptTotal['debit'][$sub_dept->id])) $tempSubDeptTotal[$sub_dept->id] = $subDeptTotal['credit'][$sub_dept->id]; elseif(!isset($subDeptTotal['credit'][$sub_dept->id]) && isset($subDeptTotal['debit'][$sub_dept->id])) $tempSubDeptTotal[$sub_dept->id] = 0 - $subDeptTotal['debit'][$sub_dept->id]; else $tempSubDeptTotal[$sub_dept->id] = null; if(isset($deptSubTotal[$department->id])) { $deptSubTotal[$department->id] += $tempSubDeptTotal[$sub_dept->id]; } else { $deptSubTotal[$department->id] = $tempSubDeptTotal[$sub_dept->id]; } @endphp {{ isset($tempSubDeptTotal[$sub_dept->id]) && $tempSubDeptTotal[$sub_dept->id] != 0 ? round($tempSubDeptTotal[$sub_dept->id], 2) : '' }} @php if(isset($deptTotal['credit'][$department->id]) && isset($deptTotal['debit'][$department->id])) $tempDeptTotal[$department->id] = $deptTotal['credit'][$department->id] - $deptTotal['debit'][$department->id]; elseif(isset($deptTotal['credit'][$department->id]) && !isset($deptTotal['debit'][$department->id])) $tempDeptTotal[$department->id] = $deptTotal['credit'][$department->id]; elseif(!isset($deptTotal['credit'][$department->id]) && isset($deptTotal['debit'][$department->id])) $tempDeptTotal[$department->id] = 0 - $deptTotal['debit'][$department->id]; else $tempDeptTotal[$department->id] = null; if(isset($deptSubTotal[$department->id])) { $deptSubTotal[$department->id] += $tempDeptTotal[$department->id]; } else { $deptSubTotal[$department->id] = $tempDeptTotal[$department->id]; } @endphp {{ isset($tempDeptTotal[$department->id]) && $tempDeptTotal[$department->id] != 0 ? round($tempDeptTotal[$department->id], 2) : '' }} {{ isset($debit_general_dept) && $debit_general_dept != 0 ? round($debit_general_dept, 2) : ''}} {{ round((isset($totalAmount['credit']) ? $totalAmount['credit'] : 0) - (isset($totalAmount['debit']) ? $totalAmount['debit'] : 0), 2) }}
{{ isset($deptSubTotal[$department->id]) && $deptSubTotal[$department->id] != 0 ? round($deptSubTotal[$department->id], 2) : '' }}
Total CR {{ isset($subDeptTotal['credit'][$sub_dept->id]) && $subDeptTotal['credit'][$sub_dept->id] != 0 ? round($subDeptTotal['credit'][$sub_dept->id], 2) :'' }} Total CR {{ isset($deptTotal['credit'][$department->id]) && $deptTotal['credit'][$department->id] != 0 ? round($deptTotal['credit'][$department->id], 2) :'' }} Total CR {{ isset($totalAmount['credit']) ? round($totalAmount['credit'], 2) : '' }}
Total DR {{ isset($subDeptTotal['debit'][$sub_dept->id]) && $subDeptTotal['debit'][$sub_dept->id] != 0 ? round($subDeptTotal['debit'][$sub_dept->id], 2) :'' }} Total DR {{ isset($deptTotal['debit'][$department->id]) && $deptTotal['debit'][$department->id] != 0 ? round($deptTotal['debit'][$department->id], 2) :'' }} Total DR {{ isset($totalAmount['debit']) ? round($totalAmount['debit'], 2) : '' }}
DR Vat Excl @php $tempTotalExcl = 0; $tempTotalDr = isset($subDeptTotal['debit'][$sub_dept->id]) ? $subDeptTotal['debit'][$sub_dept->id] : 0; $tempTotalTax = isset($subDepttotalDebitTax[$sub_dept->id]) ? $subDepttotalDebitTax[$sub_dept->id] : 0; $subDeptDebitTaxExcl[$sub_dept->id] = $tempTotalDr - $tempTotalTax; @endphp {{ isset($subDeptDebitTaxExcl[$sub_dept->id]) && $subDeptDebitTaxExcl[$sub_dept->id] != 0 ? round($subDeptDebitTaxExcl[$sub_dept->id], 2) : '' }} DR Vat Excl @php $tempTotalExcl = 0; $tempTotalDr = isset($deptTotal['debit'][$department->id]) ? $deptTotal['debit'][$department->id] : 0; $tempTotalTax = isset($deptTotalDebitTax[$department->id]) ? $deptTotalDebitTax[$department->id] : 0; $deptDebitTaxExcl[$department->id] = $tempTotalDr - $tempTotalTax; @endphp {{ isset($deptDebitTaxExcl[$department->id]) && $deptDebitTaxExcl[$department->id] != 0 ? round($deptDebitTaxExcl[$department->id], 2) : '' }} DR Vat Excl @php $tempTotalExcl = 0; $tempTotalDr = isset($totalAmount['debit']) ? $totalAmount['debit'] : 0; $tempTotalTax = isset($totalDebitTax) ? $totalDebitTax : 0; $totalTaxExcl = $tempTotalDr - $tempTotalTax; @endphp {{ isset($totalTaxExcl) && $totalTaxExcl != 0 ? round($totalTaxExcl, 2) : '' }}
DR VAT {{ isset($subDepttotalDebitTax[$sub_dept->id]) && $subDepttotalDebitTax[$sub_dept->id] != 0 ? round($subDepttotalDebitTax[$sub_dept->id], 2) : '' }} DR VAT {{ isset($deptTotalDebitTax[$department->id]) && $deptTotalDebitTax[$department->id] != 0 ? round($deptTotalDebitTax[$department->id], 2) : '' }} DR VAT {{ isset($totalDebitTax) && $totalDebitTax != 0 ? round($totalDebitTax, 2) : '' }}
Total P/L {{ isset($tempTotalPl) && $tempTotalPl != 0 ? round($tempTotalPl, 2) : '' }} Total P/L {{ isset($tempTotalPl) && $tempTotalPl != 0 ? round($tempTotalPl, 2) : '' }} Total P/L @php $tempTotalPl = 0; $tempTotalCr = isset($totalAmount['credit']) ? $totalAmount['credit'] : 0; $tempTotalDr = isset($totalTaxExcl) ? $totalTaxExcl : 0; $tempTotalPl = $tempTotalCr - $tempTotalDr; @endphp {{ isset($tempTotalPl) && $tempTotalPl != 0 ? round($tempTotalPl, 2) : '' }}