{{ strtoupper(org_name()) }}
Payroll Report - {{ date('F Y', mktime(0, 0, 0, $payroll->month, 1, $payroll->year)) }}
@foreach($exportData as $row) @endforeach
S/N Staff No. Employee Name Basic Pay (USD) Gross Salary NSSF (Employer) NSSF (Employee) WCF HESLB SAL ADV OTHER DED LOAN TAXABLE PAYE NET PAY
{{ $row['s_n'] }} {{ $row['staff_no'] }} {{ $row['employee_name'] }} {{ number_format($row['basic_pay_usd'], 2) }} {{ number_format($row['gross_salary'], 2) }} {{ number_format($row['nssf_employer'], 2) }} {{ number_format($row['nssf_employee'], 2) }} {{ number_format($row['wcf'], 2) }} {{ number_format($row['heslb'], 2) }} {{ number_format($row['salary_advance'], 2) }} {{ number_format($row['other_deductions'], 2) }} {{ number_format($row['loan_repayment'], 2) }} {{ number_format($row['taxable'], 2) }} {{ number_format($row['paye'], 2) }} {{ number_format($row['net_pay'], 2) }}
TOTAL {{ number_format($totals['basic_pay'], 2) }} {{ number_format($totals['gross'], 2) }} {{ number_format($totals['nssf_employer'], 2) }} {{ number_format($totals['nssf_employee'], 2) }} {{ number_format($totals['wcf'], 2) }} {{ number_format($totals['heslb'], 2) }} {{ number_format($totals['salary_advance'], 2) }} {{ number_format($totals['other_deductions'], 2) }} {{ number_format($totals['loan_repayment'], 2) }} {{ number_format($totals['taxable'], 2) }} {{ number_format($totals['paye'], 2) }} {{ number_format($totals['net_pay'], 2) }}
{{ strtoupper(org_name()) }}
Bank Transfer Details - {{ date('F Y', mktime(0, 0, 0, $payroll->month, 1, $payroll->year)) }}
@foreach($exportData as $row) @endforeach
BANK TRANSFER DETAILS
Staff ID Account Name Account Number Amount Deposited Bank Branch Description Date of Payment
{{ $row['staff_no'] }} {{ $row['account_name'] }} {{ $row['account_number'] }} {{ number_format($row['net_pay'], 2) }} {{ $row['bank'] }} {{ $row['branch'] }} {{ $row['description'] }} {{ $row['payment_date'] }}
TOTAL AMOUNT {{ number_format($totals['net_pay'], 2) }}
PAYROLL SUMMARY
Description Amount (TZS)
Total Net Pay {{ number_format($totals['net_pay'], 2) }}
Total NSSF (Employee) {{ number_format($totals['nssf_employee'], 2) }}
Total NSSF (Employer) {{ number_format($totals['nssf_employer'], 2) }}
Total WCF {{ number_format($totals['wcf'], 2) }}
Total PAYE {{ number_format($totals['paye'], 2) }}
GRAND TOTAL (NSSF + WCF + PAYE) {{ number_format($totals['nssf_employee'] + $totals['nssf_employer'] + $totals['wcf'] + $totals['paye'], 2) }}