Business OS
Human ResourcesPayroll

Payslip Worksheet

This Payslip Worksheet template is used by businesses to calculate and record employee earnings, deductions, and net pay for a specific pay period. It helps in the accurate generation of individual payslips and for internal payroll reconciliation.

Updated 15d ago
payslippayrollworksheetearningsdeductionsnet payemployeeremuneration

Company Information

{{company_name}}

{{company_address}}

Phone: {{phone}}

Email: {{email}}

Website: {{website}}

Employee Details

Employee Name: {{employee_name}}

Employee ID: {{employee_id}}

Job Title: {{job_title}}

Department: {{department}}

Pay Period Start Date: {{pay_period_start_date}}

Pay Period End Date: {{pay_period_end_date}}

Payment Date: {{payment_date}}

Earnings

Basic Salary: {{basic_salary}}

Hours Worked: {{hours_worked}}

Hourly Rate: {{hourly_rate}}

Overtime Hours: {{overtime_hours}}

Overtime Rate: {{overtime_rate}}

Commission: {{commission}}

Bonuses: {{bonuses}}

Allowances (e.g., Travel, Housing): {{allowances_description}} {{allowances_amount}}

Gross Earnings: {{gross_earnings}}

Deductions

Pay As You Earn (PAYE) Tax: {{paye_tax}}

Unemployment Insurance Fund (UIF) Contribution: {{uif_contribution}}

Pension Fund Contribution: {{pension_fund_contribution}}

Medical Aid Contribution: {{medical_aid_contribution}}

Loan Repayments: {{loan_repayments}}

Other Deductions (e.g., union fees, garnishee orders): {{other_deductions_description}} {{other_deductions_amount}}

Total Deductions: {{total_deductions}}

Net Pay

Net Pay (Gross Earnings - Total Deductions): {{net_pay}}

Payment Method

Payment Method: {{payment_method}}

Bank Name: {{bank_name}}

Account Number: {{account_number}}

Branch Code: {{branch_code}}

Employer Contributions

Employer UIF Contribution: {{employer_uif_contribution}}

Employer Pension Fund Contribution: {{employer_pension_fund_contribution}}

Skills Development Levy (SDL): {{sdl_contribution}}

Other Employer Contributions: {{other_employer_contributions_description}} {{other_employer_contributions_amount}}

Declaration and Authorization

I, {{preparer_name}}, as the payroll administrator, confirm that the above calculations are accurate and comply with statutory requirements.

Prepared By: {{preparer_name}}

Date: {{preparation_date}}

Signature: __________________________

Approval

Approved By: {{approver_name}}

Date: {{approval_date}}

Signature: __________________________

Related templates