Engagement 1-Mar-24

Basic 1,100.00 g1
Transport 1,200.00 g2
Overtime 120.00 g3
Nssa 4.50%
Pension 5%
Nec 2%
Union 2.50%
Medical 800 shortfalls
Disable
Blind
Elderly 900
DOB 2/3/1969
Fuel Benefit 100lts
150 g4
Taxable Jfor Jan to Feb xxx
Tax to Date Jan to Feb xxx

NET PAY
Basic 1,100.00 Nssa 31.50
Transport 1,200.00 Pension 55.00
Overtime 120.00 Nec 22.00
Union 27.50
Paye 266.90
Aids 8.01

Gross Pay 2,420.00 410.91

2,009.09
Tax Calculation
Gross Income(Gross Pay+ Benefits ) 2,570.00
Less Exemps
Income 2,570.00
Less Allowable (136.00)
Fixed Allowable( Pension & Nssa )
Nssa 31.5
Pension 55 450
Nec 22 22
Union 27.5 27.5

Taxable Income 2,434.00

Apply Rate 0.35
Tax Liability Before 666.90
Less Credits
Medical (800/2) Expenses (400.00)
Elderly -

Tax Liability 266.90 14

3% Aids 8.01

6 mrks
Name: O Thomas
Pay number: E0100417
Monthly salary: $1,500
Pension 5% of basic
Motoring benefit 1,500 cc
Sales commission $150.00
NSSA 4.5% of maximum insurable earnings of USD700
IPMZ membership $150.00
Month of payroll January 2024
Additional Information
1. Employee paid medical shortfalls of $450 to Mpilo Hospital in the current month.
2. O Thomas turn 55 years on the 14 January 2023
Bonus 900
Calculate Paye & Net Pay
Basic 1,500.00
Commission 150.00
M/Vehicle Benefits 52.08
Bonus -
Gross Income( Gross Pay + Benefits ) ###
Less Exmpt ( Bonus Tax free) -

Income 1,702.08
Lee Allowabe
Pension (75.00)
Nssa (31.50)
IPMZ Memberfees (150.00)

Taxable Income 1,445.58

0.30

Paye Before Credits 433.67

Less
Medical Shortfalls ($450/2) (225.00)
Elderly Credit ( 900/12) (75.00)

Paye After Credits 133.67

3% Aids Levy 4.01

Benefits Earning
Basic 1,500.00
Commission 150.00
M/Vehicle Benefits *** 52.08
Bonus 900.00

2,550.00
 Deduction
Pension (75.00)
Nssa (31.50)
Paye (133.67)
Aids (4.01)

(244.18)

2,305.82
Monthly basic salary

Company car 2,000 CC

Clothing Allowance
Housing Allowance 20% Basic

Current Month

Taxable Earnings to date

Tax paid to date ( Paye to date )
Tax paid to date ( Aids Levy to date )
Net credits to date Elderly
Net credits to date Medicali Expense
Employee is 58 years
Current medical expenses
Pension Contribution to being deducted at 7% per month on basic salary
NSSA contributions at 4.5% of maximum insurable ceiling of 700

Basic 1,500.00
Coy Car 104.17
Clothing 50.00
Housing 300.00
Gross Income ( Gross Pay + Benefits ) 1,954.17
Less Exemptiions -
Less Allowables
Pension (105.00)
Nssa (31.50)

Current Taxable 1,817.67

1,500.00 Cumulative Taxable (Jan to February ) 1,180.00
Plus Current Taxable ( March ) 1,817.67
1,250.00 Annual Project Gross Taxable (Jan to March ) 2,997.67
50.00 Tax Period to Date 3
300.00
Annual Taxable Income 11,990.67
Tax Rate 0.25
Mar-24 Annual Tax Payable 2,997.67
Less Tax free Portion (420.00)
1,180.00 Annual Net Tax Payable 2,577.67
124.97 YTD As At March 2024 644.42
3.75 less Credits (225.00)
150.00 Less Medical (+.63+130)/2 (65.32)
0.63

130.00 YTD Tax as At March 2024 354.10

Less Tax Paid To date Jan + Febr 124.97
31.50 March Paye 229.13
Aids 6.87

Calculate Net Pay

Basic 1,500.00

Clothing 50.00
Housing 300.00
Gross Pay 1,850.00
Less
Pension (105.00)
Nssa (31.50)
March Paye (229.13)
Aids (6.87)
Doves -
Tv Sales Hire -
Innbuck -
Salary Advance -
School fees loan
Total Deduction (372.51)

Net Pay 1,477.49

aa
bb
cc
dd

ff
gg
P Jones

Monthly basic salary

Company car 2,000 CC
Bonus

Clothing Allowance
Housing Allowance 20% Basic

Current Month

Taxable Earnings to date

Tax paid to date ( Paye to date )
Tax paid to date ( Aids Levy to date )
Net credits to date Elderly
Net credits to date Medicali Expense
Employee is 58 years
Current medical expenses
Pension Contribution to being deducted at 7% per month on basic salary
NSSA contributions at 4.5% of maximum insurable ceiling of

Basic 3,500.00
Coy Car 104.17
Clothing 150.00
Bonus -
Housing 300.00
Gross Income ( Gross Pay + Benefits ) 4,054.17
Less Exemptiions -
Less Allowables
Pension (245.00)
Nssa (31.50)

Current Taxable 3,777.67

Basic 3,500.00
Coy Car 104.17
Clothing 150.00
Bonus 850.00
Housing 300.00
Gross Income ( Gross Pay + Benefits ) 4,904.17
Less Exemptiions (700.00)
Less Allowables
Pension (245.00)
Nssa (31.50)

Current Taxable 3,927.67

3,500.00 Cumulative Taxable (Jan to March ) 2,997.67
1,250.00 Annual Plus Current Taxable ( April ) Regualar 3,777.67
850
Project Gross Taxable (Jan to April ) 6,775.34
150.00 Tax Period to Date 4.00
300.00
Annual Taxable Income 20,326.01
Apr-24 Add Taxable Portion on Bonus 150.00
Taxable Income ( 20,476.01
2,997.67
354.10 Tax Rate 0.30
10.62 Annual Tax Payable 6,142.80
225.00 Less Tax free Portion (1,020.00)
130.63 Annual Net Tax Payable 5,122.80
YTD As At April 2024 1,707.60
350.00 less Credits (300.00)
Less Medical (130.63+350)/2 (240.32)
31.50

YTD Tax as At April 2024 1,167.29

Less Tax Paid To date Jan + Febr+March 354.10
April Paye 813.19
Aids 24.40

Monthly basic salary 3,500.00

Bonus 850.00
Clothing 50.00
Housing 300.00
Gross Pay 4,700.00
Less
Pension 245.00
Nssa (31.50)
March Paye (813.19)
Aids (24.40)
Doves -
Tv Sales Hire -
Innbuck -
Salary (1,000.00)
Net Pay 3,075.92
aa
bb

cc
dd

ff Taxable Bonus Amount

Taxable Bonus Amount

gg
=if(Bonus is 700 or less, taxable bonus is equal zero)
=if (Bonus is greater than 700, taxable bonus is equal to Actual Paid Bonus minu 700)
Please attempt question 2 & 3 ( Section B )
Cumulative Taxable (Jan to March ) 2,997.67
Plus Current Taxable ( April ) Regualar -

Project Gross Taxable (Jan to April ) 2,997.67

Tax Period to Date 4.00

Annual Taxable Income 11,990.68

Add Taxable Portion on Bonus 150.00
Taxable Income ( 12,140.68

Tax Rate 0.35

Annual Tax Payable 4,196.74
Less Tax free Portion (2,220.00)
Annual Net Tax Payable 1,976.74
YTD As At April 2024 658.91
less Credits (300.00)
Less Medical (130.63+350)/2 (240.32)

YTD Tax as At April 2024 118.60

Less Tax Paid To date Jan + Febr+March -
April Paye 118.60
Aids 3.56

Monthly basic salary 3,500.00

Bonus 850.00
Clothing 50.00
Housing 300.00
Gross Pay 4,700.00
Less
Pension -
Nssa (31.50)
March Paye (118.60)
Aids (3.56)
Doves -
Tv Sales Hire -
Innbuck -
Salary (1,000.00)
Net Pay 3,546.34
aa
bb

cc
dd

ff Taxable Bonus Amount

Taxable Bonus Amount

gg
=if(Bonus is 700 or less, taxable bonus is equal zero)
=if (Bonus is greater than 700, taxable bonus is equal to Actual Paid Bonus minu 700)
FDS Average Method

Description Amounts
YTD Taxable Income aa
Add Current Month Taxable Income bb
Total YTD Earnings As At Date of Payroll Proceeing cc

Tax Period n
0 dd
Tax Rate ee
Annual Tax Liability ff

Expected YTD To Date Tax gg

Less YTD Credits including for the current Run
Less Paye Deduccted previous period YTD
Formulae

add aa plus bb

divide cc by Tax Period then Multiple by 12

multiple dd by tax rate - tax free amount

divide ff by 12 then multiple by number of tax periods

 Deemed (USD) Value
Engine Capacity
(Annual ) Monthly
Up to 1500cc 625.00 52.08
Over 1500cc -2000cc 830.00 69.17
Over 2000cc -3000cc 1,250.00 104.17
Over 3000cc 1,660.00 138.33

Ficxed Credit Annual

Blind 900.00 75.00
Elderly 900.00 75.00
Disability 900.00 75.00
11/05/202403:04:04 810856985.xlsx Per EmployeeRe-Calculation of FDS Tax Page 24of 27

Payroll Redenomination Factor 1.0000 for values entered in green coloured cells (converts tax tables for tax on cross-rates)
LIMITS 2024 TAX BANDS for 12 month period VEH BENEFIT
Tax Year Start 1/1/2024 0% 0.00 to 1,200.00 1-1500cc
Tax Year End 12/31/2024 20% 1,200.01 to 3,600.00 1501-2000cc
Taxfree Bonus Allowed 700.00 25% 3,600.01 to 12,000.00 2001-3000cc
Taxfree Severance Lower p.a. 3,200.00 30% 12,000.01 to 24,000.00 3001 & above
Taxfree Severance Upper p.a. 15,600.00 35% 24,000.01 to 36,000.00 VEH BENEFIT
Pension Deduct Allowed p.a. 5,400.00 40% 36,000.01 to 999,999,999.00 1-1500cc
Aids Levy Rate 3% 45% 999,999,999.00 to 9,999,999,999.00 1501-2000cc
45% 9,999,999,999.00 to & over 2001-3000cc
Emp Start Date (in curr year) 1/1/2024 FIXED CREDITS for 12 month period 3001 & above
Tax Period End Date 4/30/2024 Elderly, born before 1/1/1969 ALL CALCULATIONS ARE R
No of Tax Periods 12 Elderly 900.00 THE NEAREST USD C
Days per Tax Period 30 Blind 900.00
Taxed to Period 4 Disabled person 900.00 CALCULATIONS HAVE NO
Taxed over Total Tax Periods 12 Disabled child 900.00 UP FOR RETRENCHM
Tax Annualised Total (Reg & Irreg)
EARNINGS & BENEFITS YTD Value Free within limit Taxable Income pa
YTD REGULAR R 6,775.34 20,326.01
YTD BONUS I 850.00 700.00 150.00
YTD CAR BENEFIT R 0.00 0.00
YTD OTHER BEN REG R 0.00 0.00

YTD OTHER BEN IRREG I 0.00 0.00

YTD CASH IN LIEU I 0.00 0.00
YTD OTHER IRREGULAR I 0.00 0.00
YTD SEVERANCE I 0.00 0.00 0.00 20,476.01

LIMITED TAX DEDUCTIONS

YTD PENSION R 0.00 0.00
YTD NSSA R 0.00 0.00
YTD RETIRE ANNUITY R 0.00 0.00 0.00

UNLIMITED TAX DEDUCTIONS

YTD UNION R 0.00 0.00
YTD NEC/NIC R 0.00 0.00
YTD PROFESSIONAL SUBS I 0.00 0.00
YTD TRADESMAN TOOLS I 0.00 0.00
YTD DONATIONS I 0.00 0.00 0.00

Total Taxable Tax p.a. on Regular Only

TAX TABLES CONVERTED BY GIVEN FACTOR % Per Annualised Total Taxable Annualised
SPLIT INTO AMOUNTS PER TAX BAND Band 20,476.01 20,326.01
0% 0 1,200 5.86% 1,200.00 0.00 1,200.00
20% 1,200 3,600 11.72% 2,399.99 480.00 2,399.99
25% 3,600 12,000 41.02% 8,399.99 2,100.00 8,399.99
30% 12,000 24,000 41.39% 8,476.00 2,542.80 8,326.00
35% 24,000 36,000 0.00% 0.00 0.00 0.00
40% 36,000 999,999,999 0.00% 0.00 0.00 0.00
45% 999,999,999 9,999,999,999 0.00% 0.00 0.00 0.00
45% 9,999,999,999 & over 0.00% 0.00 0.00 0.00
99.99% 20,475.98 5,122.80 20,325.98

Tax on Regular Only 5,077.80 Pro-Rated

Tax on Irregular Only 45.00 Not Pro-rated
LESS FIXED CREDITS PER ANNUM
BLIND PERSONS pa 0.00 0.00
DISABLED PERSONS pa 0.00 0.00
ELDERLY PERSONS pa 900.00 900.00 900.00 Pro-Rated

Theoretical YTD Tax After Fixed Credits Pro-Rated back to Current Period
LESS YTD VARIABLE CREDITS
YTD MEDICAL AID 0.00
YTD MEDICAL EXPENSES 480.63
11/05/202403:04:04 810856985.xlsx Per EmployeeRe-Calculation of FDS Tax Page 25of 27

CHECK YTD TOTAL TAX Actual Theoretical Variance $

YTD PAYE 1,167.29 1,197.28 30.00
YTD AIDS LEVY 35.02 35.92 0.90
YTD ADD VOL TAX 0.00 0.00 0.00
YTD TAX PAID 1,202.30 YTD TAX DUE 1,233.21 30.90
 11/05/202403:04:04 810856985.xlsx Per EmployeeRe-Calculation of FDS Tax Page 26of 27

Per Month
52.08 100
69.17
104.17
138.33
Per 12 months
625.00
830.00
1,250.00
1,660.00
LL CALCULATIONS ARE ROUNDED TO
THE NEAREST USD CENT

CALCULATIONS HAVE NOT BEEN SET

UP FOR RETRENCHMENTS
Regular Only
Taxable Income pa

20,326.01

0.00

0.00

Tax p.a. on
Regular Only

0.00
480.00
2,100.00
2,497.80
0.00
0.00
0.00
0.00
5,077.80

1,692.60
45.00

300.00

1,437.60

240.32
11/05/202403:04:04 810856985.xlsx Per EmployeeRe-Calculation of FDS Tax Page 27of 27

Variance %
2.57%
2.57%
0.00%
2.57%