@extends('layouts.app') @section('title') Active Employees Monthly Payroll Sheet @stop @section('breadcrumb')
  1. Home
  2. All Employees Salary
@stop @section('css') @stop @section('content')

Employees Monthly Payroll


@if(Session::has('success')) @endif

{{env('APP_NAME')}}

LIST OF ACTIVE EMPLOYEES - MONTHLY PAYROLL

TAX YEAR - 2021-22--------------MONTH - {{date('F', mktime(0, 0, 0, $month))}} - {{$curent_year}}

@php $grand_total_active_emp = 0; @endphp @foreach($arrayTotal as $list) @php $total_basic_salary = 0; $total_net_salary = 0; $total_monthly_earning = 0; $total_monthly_tax = 0; $total_b_found = 0; $total_monthly_deduction = 0; $total_loan = 0; $total_opning_loan = 0; $total_closing_loan = 0; $total_advance = 0; $benevolent_found_opning = 0; $benevolent_found_deduction = 0; $benevolent_found_comp_con = 0; $closing_benevolent_found = 0; $count = 1; $total_employee_basic_salary = 0; $house_rent_allowance = 0 ; $medical_allowance = 0 ; $utility_allowance = 0 ; $arears_allowance = 0 ; $others_allowance = 0 ; $total_per_month_salaries = 0; $basic_salary_with_allowances = 0; $total_basic_salary_with_allowances = 0; $total_eobi = 0 ; $total_sessie = 0 ; @endphp @foreach($list['dataArray'] as $employees_salary ) @foreach($employees_salary_approved as $salary_approved ) @if($employees_salary->company_detail->department->id == $list['deprt_id']) @php $total = \App\HrmEmployeeMonthlyEarningDeduction::getData($employees_salary->id , $month , $curent_year ); @endphp @if( $employees_salary->status == '1' && ($total[0] > 0 && $total[1] > 0 && $employees_salary->id == $salary_approved->employ_id ) && strtotime($employees_salary->company_detail->date_of_joining) < strtotime('-30 days') ) @foreach($total[12] as $earning_amount) @php $total_p_m = ( $earning_amount['house_rent'] + $earning_amount['medical'] + $earning_amount['utility'] + $earning_amount['arears'] + $earning_amount['others']); $basic_salary_with_allowances = $total_p_m + $earning_amount['basic_salary']; $total_employee_basic_salary += $earning_amount['basic_salary']; $house_rent_allowance += $earning_amount['house_rent']; $medical_allowance += $earning_amount['medical']; $utility_allowance += $earning_amount['utility']; $arears_allowance += $earning_amount['arears']; $others_allowance += $earning_amount['others']; $total_per_month_salaries += $total_p_m; $total_basic_salary_with_allowances += $basic_salary_with_allowances; @endphp @endforeach @foreach($total[13] as $deduction_amount) @php $total_eobi += $deduction_amount['eobi'] ; $total_sessie += $deduction_amount['sessie'] ; @endphp @endforeach @php $total_basic_salary += $employees_salary->company_detail->monthly_salary ; $total_monthly_earning += $total[0]; $total_monthly_tax += $total[3]; $total_b_found += $total[4]; $total_opning_loan += $total[8]; $total_loan += $total[5]; $total_closing_loan += $total[7]; $benevolent_found_opning += $total[10]; $benevolent_found_deduction += $total[11]; $benevolent_found_comp_con += $total[9]; $closing_benevolent_found += $total[14]; $total_advance += $total[6]; $total_monthly_deduction += $total[1]; $net_salary = ($total[0]-$total[1]-$total[3]-$total[4]-$total[5]-$total[6] ); $total_net_salary += $net_salary; @endphp @endif @endif @endforeach @endforeach @php $grand_total_active_emp += $total_net_salary; @endphp @endforeach
Deductions
Loan Benevolent Fund
S.No. Name Designation Date of Joining & Length of service Location Month/Year Basic Salary House Rent Allownace Medical Allowance Utility Allowance Arears, if any. Others / Allowances Total Salary P.M. Sub Total. Leave without Pay Advance Salary Opening Loan Deduction Loan Closing Loan EOBI (Employee Cont) SESSI Tax Opening Deduction Company Cont. Closing Net Salary
{{$list['department']}}
{{$count++}} {{$employees_salary->name}} {{$employees_salary->company_detail->designation->name}} {{$date1}} , 54 years(s), 11 month(s), 2 day(s) {{$employees_salary->pemanent_address}} {{date('d-F-Y', mktime(0, 0, 0, $month))}}{{number_format($earning_amount['basic_salary'])}} {{number_format($earning_amount['house_rent'])}} {{number_format($earning_amount['medical'])}} {{number_format($earning_amount['utility'])}} {{number_format($earning_amount['arears'])}} {{number_format($earning_amount['others'])}}{{number_format($total_p_m)}} {{number_format($basic_salary_with_allowances)}} 0 {{number_format($total[6])}} {{number_format($total[8])}} {{number_format($total[5])}} {{number_format($total[7])}}{{number_format($deduction_amount['eobi'])}} {{number_format($deduction_amount['sessie'])}}{{number_format($total[3])}} {{number_format($total[10])}} {{number_format($total[11])}} {{number_format($total[9])}} {{number_format($total[14])}} {{ number_format($net_salary) }}
Sub Total {{number_format($total_employee_basic_salary)}} {{number_format($house_rent_allowance )}} {{number_format($medical_allowance )}} {{number_format($utility_allowance )}} {{number_format($arears_allowance )}} {{number_format($others_allowance)}} {{number_format($total_per_month_salaries)}} {{number_format($total_basic_salary_with_allowances)}} 0 {{number_format($total_advance)}} {{number_format($total_opning_loan)}} {{number_format($total_loan)}} {{number_format($total_closing_loan)}} {{number_format($total_eobi)}} {{number_format($total_sessie)}} {{number_format($total_monthly_tax)}} {{number_format($benevolent_found_opning)}} {{number_format($benevolent_found_deduction)}} {{number_format($benevolent_found_comp_con)}} {{number_format($closing_benevolent_found)}} {{number_format($total_net_salary )}}
Grand Total {{number_format($grand_total_active_emp)}}

{{env('APP_NAME')}}

LIST OF RESIGNED EMPLOYEES - MONTHLY PAYROLL

TAX YEAR - 2021-22--------------MONTH - {{date('F', mktime(0, 0, 0, $month))}} - {{$curent_year}}

@php $grand_total_resign_emp = 0; @endphp @foreach($arrayTotal as $list) @php $total_basic_salary = 0; $total_net_salary = 0; $total_monthly_earning = 0; $total_monthly_tax = 0; $total_b_found = 0; $total_monthly_deduction = 0; $total_loan = 0; $total_opning_loan = 0; $total_closing_loan = 0; $total_advance = 0; $benevolent_found_opning = 0; $benevolent_found_deduction = 0; $benevolent_found_comp_con = 0; $closing_benevolent_found = 0; $count = 1; $total_employee_basic_salary = 0; $house_rent_allowance = 0 ; $medical_allowance = 0 ; $utility_allowance = 0 ; $arears_allowance = 0 ; $others_allowance = 0 ; $total_per_month_salaries = 0; $basic_salary_with_allowances = 0; $total_basic_salary_with_allowances = 0; $total_eobi = 0 ; $total_sessie = 0 ; @endphp @foreach($list['dataArray'] as $employees_salary ) @foreach($employees_salary_approved as $salary_approved ) @if($employees_salary->company_detail->department->id == $list['deprt_id']) @php $total = \App\HrmEmployeeMonthlyEarningDeduction::getData($employees_salary->id , $month , $curent_year ); @endphp @if( $employees_salary->status == '0' && ($total[0] > 0 && $total[1] > 0 && $employees_salary->id == $salary_approved->employ_id)) @foreach($total[12] as $earning_amount) @php $total_p_m = ( $earning_amount['house_rent'] + $earning_amount['medical'] + $earning_amount['utility'] + $earning_amount['arears'] + $earning_amount['others']); $basic_salary_with_allowances = $total_p_m + $earning_amount['basic_salary']; $total_employee_basic_salary += $earning_amount['basic_salary']; $house_rent_allowance += $earning_amount['house_rent']; $medical_allowance += $earning_amount['medical']; $utility_allowance += $earning_amount['utility']; $arears_allowance += $earning_amount['arears']; $others_allowance += $earning_amount['others']; $total_per_month_salaries += $total_p_m; $total_basic_salary_with_allowances += $basic_salary_with_allowances; @endphp @endforeach @foreach($total[13] as $deduction_amount) @php $total_eobi += $deduction_amount['eobi'] ; $total_sessie += $deduction_amount['sessie'] ; @endphp @endforeach @php $total_basic_salary += $employees_salary->company_detail->monthly_salary ; $total_monthly_earning += $total[0]; $total_monthly_tax += $total[3]; $total_b_found += $total[4]; $total_opning_loan += $total[8]; $total_loan += $total[5]; $total_closing_loan += $total[7]; $benevolent_found_opning += $total[10]; $benevolent_found_deduction += $total[11]; $benevolent_found_comp_con += $total[9]; $$closing_benevolent_found += $total[14]; $total_advance += $total[6]; $total_monthly_deduction += $total[1]; $net_salary = ($total[0]-$total[1]-$total[3]-$total[4]-$total[5]-$total[6] ); $total_net_salary += $net_salary; @endphp @endif @endif @endforeach @endforeach @php $grand_total_resign_emp += $total_net_salary; @endphp @endforeach
Deductions
Loan Benevolent Fund
S.No. Name Designation Date of Joining & Length of service Location Month/Year Basic Salary House Rent Allownace Medical Allowance Utility Allowance Arears, if any. Others / Allowances Total Salary P.M. Sub Total. Leave without Pay Advance Salary Opening Loan Deduction Loan Closing Loan EOBI (Employee Cont) SESSI Tax Opening Deduction Company Cont. Closing Net Salary
{{$list['department']}}
{{$count++}} {{$employees_salary->name}} {{$employees_salary->company_detail->designation->name}} {{$date1}} , 54 years(s), 11 month(s), 2 day(s) {{$employees_salary->pemanent_address}} {{date('d-F-Y', mktime(0, 0, 0, $month))}}{{number_format($earning_amount['basic_salary'])}} {{number_format($earning_amount['house_rent'])}} {{number_format($earning_amount['medical'])}} {{number_format($earning_amount['utility'])}} {{number_format($earning_amount['arears'])}} {{number_format($earning_amount['others'])}}{{number_format($total_p_m)}} {{number_format($basic_salary_with_allowances)}} 0 {{number_format($total[6])}} {{number_format($total[8])}} {{number_format($total[5])}} {{number_format($total[7])}}{{number_format($deduction_amount['eobi'])}} {{number_format($deduction_amount['sessie'])}}{{number_format($total[3])}} {{number_format($total[10])}} {{number_format($total[11])}} {{number_format($total[9])}} {{number_format($total[14])}} {{ number_format($net_salary) }}
Sub Total {{number_format($total_employee_basic_salary)}} {{number_format($house_rent_allowance )}} {{number_format($medical_allowance )}} {{number_format($utility_allowance )}} {{number_format($arears_allowance )}} {{number_format($others_allowance)}} {{number_format($total_per_month_salaries)}} {{number_format($total_basic_salary_with_allowances)}} 0 {{number_format($total_advance)}} {{number_format($total_opning_loan)}} {{number_format($total_loan)}} {{number_format($total_closing_loan)}} {{number_format($total_eobi)}} {{number_format($total_sessie)}} {{number_format($total_monthly_tax)}} {{number_format($benevolent_found_opning)}} {{number_format($benevolent_found_deduction)}} {{number_format($benevolent_found_comp_con)}} {{number_format($closing_benevolent_found)}} {{number_format($total_net_salary )}}
Grand Total {{number_format($grand_total_resign_emp)}}

{{env('APP_NAME')}}

LIST OF TERMINETED EMPLOYEES - MONTHLY PAYROLL

TAX YEAR - 2021-22--------------MONTH - {{date('F', mktime(0, 0, 0, $month))}} - {{$curent_year}}

@php $grand_total_terminated_emp = 0; @endphp @foreach($arrayTotal as $list) @php $total_basic_salary = 0; $total_net_salary = 0; $total_monthly_earning = 0; $total_monthly_tax = 0; $total_b_found = 0; $total_monthly_deduction = 0; $total_loan = 0; $total_opning_loan = 0; $total_closing_loan = 0; $total_advance = 0; $benevolent_found_opning = 0; $benevolent_found_deduction = 0; $benevolent_found_comp_con = 0; $closing_benevolent_found = 0; $count = 1; $total_employee_basic_salary = 0; $house_rent_allowance = 0 ; $medical_allowance = 0 ; $utility_allowance = 0 ; $arears_allowance = 0 ; $others_allowance = 0 ; $total_per_month_salaries = 0; $basic_salary_with_allowances = 0; $total_basic_salary_with_allowances = 0; $total_eobi = 0 ; $total_sessie = 0 ; @endphp @foreach($list['dataArray'] as $employees_salary ) @foreach($employees_salary_approved as $salary_approved ) @if($employees_salary->company_detail->department->id == $list['deprt_id']) @php $total = \App\HrmEmployeeMonthlyEarningDeduction::getData($employees_salary->id , $month , $curent_year ); @endphp @if( $employees_salary->status == '2' && ($total[0] > 0 && $total[1] > 0 && $employees_salary->id == $salary_approved->employ_id )) @foreach($total[12] as $earning_amount) @php $total_p_m = ( $earning_amount['house_rent'] + $earning_amount['medical'] + $earning_amount['utility'] + $earning_amount['arears'] + $earning_amount['others']); $basic_salary_with_allowances = $total_p_m + $earning_amount['basic_salary']; $total_employee_basic_salary += $earning_amount['basic_salary']; $house_rent_allowance += $earning_amount['house_rent']; $medical_allowance += $earning_amount['medical']; $utility_allowance += $earning_amount['utility']; $arears_allowance += $earning_amount['arears']; $others_allowance += $earning_amount['others']; $total_per_month_salaries += $total_p_m; $total_basic_salary_with_allowances += $basic_salary_with_allowances; @endphp @endforeach @foreach($total[13] as $deduction_amount) @php $total_eobi += $deduction_amount['eobi'] ; $total_sessie += $deduction_amount['sessie'] ; @endphp @endforeach @php $total_basic_salary += $employees_salary->company_detail->monthly_salary ; $total_monthly_earning += $total[0]; $total_monthly_tax += $total[3]; $total_b_found += $total[4]; $total_opning_loan += $total[8]; $total_loan += $total[5]; $total_closing_loan += $total[7]; $benevolent_found_opning += $total[10]; $benevolent_found_deduction += $total[11]; $benevolent_found_comp_con += $total[9]; $closing_benevolent_found += $total[14]; $total_advance += $total[6]; $total_monthly_deduction += $total[1]; $net_salary = ($total[0]-$total[1]-$total[3]-$total[4]-$total[5]-$total[6] ); $total_net_salary += $net_salary; @endphp @endif @endif @endforeach @endforeach @php $grand_total_terminated_emp += $total_net_salary; @endphp @endforeach
Deductions
Loan Benevolent Fund
S.No. Name Designation Date of Joining & Length of service Location Month/Year Basic Salary House Rent Allownace Medical Allowance Utility Allowance Arears, if any. Others / Allowances Total Salary P.M. Sub Total. Leave without Pay Advance Salary Opening Loan Deduction Loan Closing Loan EOBI (Employee Cont) SESSI Tax Opening Deduction Company Cont. Closing Net Salary
{{$list['department']}}
{{$count++}} {{$employees_salary->name}} {{$employees_salary->company_detail->designation->name}} {{$date1}} , 54 years(s), 11 month(s), 2 day(s) {{$employees_salary->pemanent_address}} {{date('d-F-Y', mktime(0, 0, 0, $month))}}{{number_format($earning_amount['basic_salary'])}} {{number_format($earning_amount['house_rent'])}} {{number_format($earning_amount['medical'])}} {{number_format($earning_amount['utility'])}} {{number_format($earning_amount['arears'])}} {{number_format($earning_amount['others'])}}{{number_format($total_p_m)}} {{number_format($basic_salary_with_allowances)}} 0 {{number_format($total[6])}} {{number_format($total[8])}} {{number_format($total[5])}} {{number_format($total[7])}}{{number_format($deduction_amount['eobi'])}} {{number_format($deduction_amount['sessie'])}}{{number_format($total[3])}} {{number_format($total[10])}} {{number_format($total[11])}} {{number_format($total[9])}} {{number_format($total[14])}} {{ number_format($net_salary) }}
Sub Total {{number_format($total_employee_basic_salary)}} {{number_format($house_rent_allowance )}} {{number_format($medical_allowance )}} {{number_format($utility_allowance )}} {{number_format($arears_allowance )}} {{number_format($others_allowance)}} {{number_format($total_per_month_salaries)}} {{number_format($total_basic_salary_with_allowances)}} 0 {{number_format($total_advance)}} {{number_format($total_opning_loan)}} {{number_format($total_loan)}} {{number_format($total_closing_loan)}} {{number_format($total_eobi)}} {{number_format($total_sessie)}} {{number_format($total_monthly_tax)}} {{number_format($benevolent_found_opning)}} {{number_format($benevolent_found_deduction)}} {{number_format($benevolent_found_comp_con)}} {{number_format($closing_benevolent_found)}} {{number_format($total_net_salary )}}
Grand Total {{number_format($grand_total_terminated_emp)}}

{{env('APP_NAME')}}

LIST OF NEW EMPLOYEES - MONTHLY PAYROLL

TAX YEAR - 2021-22--------------MONTH - {{date('F', mktime(0, 0, 0, $month))}} - {{$curent_year}}

@php $grand_total_new_emp = 0; @endphp @foreach($arrayTotal as $list) @php $total_basic_salary = 0; $total_net_salary = 0; $total_monthly_earning = 0; $total_monthly_tax = 0; $total_b_found = 0; $total_monthly_deduction = 0; $total_loan = 0; $total_opning_loan = 0; $total_closing_loan = 0; $total_advance = 0; $benevolent_found_opning = 0; $benevolent_found_deduction = 0; $benevolent_found_comp_con = 0; $closing_benevolent_found = 0; $count = 1; $total_employee_basic_salary = 0; $house_rent_allowance = 0 ; $medical_allowance = 0 ; $utility_allowance = 0 ; $arears_allowance = 0 ; $others_allowance = 0 ; $total_per_month_salaries = 0; $basic_salary_with_allowances = 0; $total_basic_salary_with_allowances = 0; $total_eobi = 0 ; $total_sessie = 0 ; @endphp @foreach($list['dataArray'] as $employees_salary ) @foreach($employees_salary_approved as $salary_approved ) @if($employees_salary->company_detail->department->id == $list['deprt_id']) @php $total = \App\HrmEmployeeMonthlyEarningDeduction::getData($employees_salary->id , $month , $curent_year ); @endphp @if( $employees_salary->status == '1' && ($total[0] > 0 && $total[1] > 0 && $employees_salary->id == $salary_approved->employ_id ) && strtotime($employees_salary->company_detail->date_of_joining) > strtotime('-30 days') ) @foreach($total[12] as $earning_amount) @php $total_p_m = ( $earning_amount['house_rent'] + $earning_amount['medical'] + $earning_amount['utility'] + $earning_amount['arears'] + $earning_amount['others']); $basic_salary_with_allowances = $total_p_m + $earning_amount['basic_salary']; $total_employee_basic_salary += $earning_amount['basic_salary']; $house_rent_allowance += $earning_amount['house_rent']; $medical_allowance += $earning_amount['medical']; $utility_allowance += $earning_amount['utility']; $arears_allowance += $earning_amount['arears']; $others_allowance += $earning_amount['others']; $total_per_month_salaries += $total_p_m; $total_basic_salary_with_allowances += $basic_salary_with_allowances; @endphp @endforeach @foreach($total[13] as $deduction_amount) @php $total_eobi += $deduction_amount['eobi'] ; $total_sessie += $deduction_amount['sessie'] ; @endphp @endforeach @php $total_basic_salary += $employees_salary->company_detail->monthly_salary ; $total_monthly_earning += $total[0]; $total_monthly_tax += $total[3]; $total_b_found += $total[4]; $total_opning_loan += $total[8]; $total_loan += $total[5]; $total_closing_loan += $total[7]; $benevolent_found_opning += $total[10]; $benevolent_found_deduction += $total[11]; $benevolent_found_comp_con += $total[9]; $closing_benevolent_found += $total[14]; $total_advance += $total[6]; $total_monthly_deduction += $total[1]; $net_salary = ($total[0]-$total[1]-$total[3]-$total[4]-$total[5]-$total[6] ); $total_net_salary += $net_salary; @endphp @endif @endif @endforeach @endforeach @php $grand_total_new_emp += $total_net_salary; @endphp @endforeach
Deductions
Loan Benevolent Fund
S.No. Name Designation Date of Joining & Length of service Location Month/Year Basic Salary House Rent Allownace Medical Allowance Utility Allowance Arears, if any. Others / Allowances Total Salary P.M. Sub Total. Leave without Pay Advance Salary Opening Loan Deduction Loan Closing Loan EOBI (Employee Cont) SESSI Tax Opening Deduction Company Cont. Closing Net Salary
{{$list['department']}}
{{$count++}} {{$employees_salary->name}} {{$employees_salary->company_detail->designation->name}} {{$date1}} , 54 years(s), 11 month(s), 2 day(s) {{$employees_salary->pemanent_address}} {{date('d-F-Y', mktime(0, 0, 0, $month))}}{{number_format($earning_amount['basic_salary'])}} {{number_format($earning_amount['house_rent'])}} {{number_format($earning_amount['medical'])}} {{number_format($earning_amount['utility'])}} {{number_format($earning_amount['arears'])}} {{number_format($earning_amount['others'])}}{{number_format($total_p_m)}} {{number_format($basic_salary_with_allowances)}} 0 {{number_format($total[6])}} {{number_format($total[8])}} {{number_format($total[5])}} {{number_format($total[7])}}{{number_format($deduction_amount['eobi'])}} {{number_format($deduction_amount['sessie'])}}{{number_format($total[3])}} {{number_format($total[10])}} {{number_format($total[11])}} {{number_format($total[9])}} {{number_format($total[14])}} {{ number_format($net_salary) }}
Sub Total {{number_format($total_employee_basic_salary)}} {{number_format($house_rent_allowance )}} {{number_format($medical_allowance )}} {{number_format($utility_allowance )}} {{number_format($arears_allowance )}} {{number_format($others_allowance)}} {{number_format($total_per_month_salaries)}} {{number_format($total_basic_salary_with_allowances)}} 0 {{number_format($total_advance)}} {{number_format($total_opning_loan)}} {{number_format($total_loan)}} {{number_format($total_closing_loan)}} {{number_format($total_eobi)}} {{number_format($total_sessie)}} {{number_format($total_monthly_tax)}} {{number_format($benevolent_found_opning)}} {{number_format($benevolent_found_deduction)}} {{number_format($benevolent_found_comp_con)}} {{number_format($closing_benevolent_found)}} {{number_format($total_net_salary )}}
Grand Total {{number_format($grand_total_new_emp)}}
@stop @section('js') @stop