Created a sample payroll sheet using Excel,
Must Go Now Limited
Payroll for the Month of April 2025
Employee
Achiek Magok
Ahmed Adan
anne kadenge
Bethsua Moruri
betty Toma
Total
Prepared by
Basic Salary Allowances Gross Salary Housing Levy NSSF Relief
500,-,-,000.00
1,000,-,000.00
2,400,000.00
500,-,-,000.00
1,000,-,-,400,000.00
7,500.00
3,750.00
9,-,-,000.00
4,320.00
4,320.00
4,320.00
4,320.00
4,-,600.00
Taxable Pay Tax Charged
Relief
488,-,-,-,-,930.00
2,342,400.00
2,400.00
2,400.00
2,400.00
2,400.00
2,-,000.00
141,-,-,-,521.35
8,-,337.75
Lower
Upper
0.00
24,-,-,-,-,-,-,-,000.00 1,000,000.00
PAYE
138,-,-,-,121.35
5,-,337.75
Deductions
NSSF
SHIF
Housing Levy
4,-,750.00
7,500.00
4,320.00
6,875.00
3,750.00
4,-,500.00
9,000.00
4,-,-,000.00
4,320.00
1,-,-,-,000.00
Difference %tax
Tax Amount Cummulative Tax
24,-% 2,400.00
2,400.00
8,-% 2,083.25
4,-,-% 140,-,-,-% 97,-,-,-% 70,-,283.35
Total Deductions Net Pay
164,-,-,-,-,-,937.75
335,-,-,-,-,692.65
1,593,062.25