@foreach( $monthlyAllowedDeductions as $key => $monthlyAllowedDeduction ) @php $totalPayableSalary = (float) @$monthlyAllowedDeduction->gross_salary + (float) @$monthlyAllowedDeduction->other_allowance + (float) @$monthlyAllowedDeduction->sales_comission + (float) @$monthlyAllowedDeduction->festival_bonus + (float) @$monthlyAllowedDeduction->mobile_bill + (float) @$monthlyAllowedDeduction->arrear; $totalDeduction = (float) @$monthlyAllowedDeduction->provident_fund + (float) @$monthlyAllowedDeduction->medical_fund + (float) @$monthlyAllowedDeduction->security_deposit + (float) @$monthlyAllowedDeduction->ait + (float) @$monthlyAllowedDeduction->loan + (float) @$monthlyAllowedDeduction->adjustment + (float) @$monthlyAllowedDeduction->late_deduction + (float) @$monthlyAllowedDeduction->lwp + (float) @$monthlyAllowedDeduction->other_adjustment; $netPayableSalary = $totalPayableSalary - $totalDeduction; @endphp @endforeach

SL.No.	Employee ID	Name of Employee	Designation	Employment Status	Department	Joining Date	Gross Salary	Basic	House Rent	Medical Allowance	Other Allowance	Sales Comission	Festival Bonus	Mobile Bill	Arrear	Total Payable Salary	Provident Fund	Medical Fund	Security Deposit	AIT	Loan / Advance	Adjustment	Late Deduction	LWP/ Absence/ Days Work	Other Adjustment	Total Deduction	Net Payable Salary	Account Number
{{ $key+1 }}	{{ @$monthlyAllowedDeduction->employee->user->accessPin }}	{{ @$monthlyAllowedDeduction->employee->firstName.' '.@$monthlyAllowedDeduction->employee->middleName.' '.@$monthlyAllowedDeduction->employee->lastName }}	{{ @$monthlyAllowedDeduction->employee->designation->title }}	{{ @$monthlyAllowedDeduction->employee->type->typeTitle }}	{{ @$monthlyAllowedDeduction->employee->department->departmentName }}	{{ @$monthlyAllowedDeduction->employee->actualJoinDate }}	{{ @$monthlyAllowedDeduction->gross_salary }}	{{ @$monthlyAllowedDeduction->basic }}	{{ @$monthlyAllowedDeduction->house_rent }}	{{ @$monthlyAllowedDeduction->medical_allowance }}	{{ @$monthlyAllowedDeduction->other_allowance }}	{{ @$monthlyAllowedDeduction->sales_comission }}	{{ @$monthlyAllowedDeduction->festival_bonus }}	{{ @$monthlyAllowedDeduction->mobile_bill }}	{{ @$monthlyAllowedDeduction->arrear }}	{{ $totalPayableSalary }}	{{ @$monthlyAllowedDeduction->provident_fund }}	{{ @$monthlyAllowedDeduction->medical_fund }}	{{ @$monthlyAllowedDeduction->security_deposit }}	{{ @$monthlyAllowedDeduction->ait }}	{{ @$monthlyAllowedDeduction->loan }}	{{ @$monthlyAllowedDeduction->adjustment }}	{{ @$monthlyAllowedDeduction->late_deduction }}	{{ @$monthlyAllowedDeduction->lwp }}	{{ @$monthlyAllowedDeduction->other_adjustment }}	{{ $totalDeduction }}	{{ $netPayableSalary }}	{{ @$monthlyAllowedDeduction->employee->bankAccountNo }}