ABCDEFLMNOPQRSTUVWXYZAAABACADAE
1
Net Pay Calculator by @ MsGillyJ
2
www.financialcentsibliity.com
Last update:15-Mar-24
Enter Your Compulsory Pension Rate
5.0%
(Enter 0 if you do not pay Pension)
3
Fill the yellow fields out
Enter Your Voluntary Pension Rate
7.5%
(Enter 0 if you do not pay Pension)
4
Go To 'File' and 'Download as' to make changes to the sheet
5
6
Period:April 1, 2019April 1, 2020April 1, 2021April 1, 2022April 1, 2024
7
Gross Emoluments300,000.00300,000.00300,000.00300,000.00300,000.00
8
Statutory Income259,062.50258,750.00255,000.00253,500.00253,500.00
9
Taxable Income134,054.50133,742.00129,992.00128,492.00111,826.00
10
PAYE33,513.6333,435.5032,498.0032,123.0027,956.50
11
Enter Your Monthly Gross Salary
300,000.00Compulsory Pension15,000.0015,000.0015,000.0015,000.0015,000.00
12
Voluntary Pension22,500.0022,500.0022,500.0022,500.0022,500.00
13
Enter any Other Income0.00NHT6,000.006,000.006,000.006,000.006,000.00
14
NIS3,437.503,750.007,500.009,000.009,000.00
15
Enter Any Non-Taxable Income
10,000.00Ed Tax5,828.915,821.885,737.505,703.755,703.75
16
Loan Deductions20,000.0020,000.0020,000.0020,000.0020,000.00
(Enter 0 if you do not pay Loans)
17
Other Deductions30,000.0030,000.0030,000.0030,000.0030,000.00
(Enter 0 if you have no other deductions)
18
19
20
Gross Income310,000.00Gross Deductions136,280.03136,507.38139,235.50140,326.75136,160.25
21
22
Net Payment173,719.97173,492.63170,764.50169,673.25173,839.75
23
24
Difference-227.34-227.34-2,728.13-1,091.254,166.50
25
26
Notes:
27
MonthlyAnnually
28
29
Tax Free ThresholdApr-2024141,674.001,700,088.00
30
Apr-2017125,008.001,500,096.00
31
"Jul-201683,356.001,000,272.00
32
"Jan-201649,400.00592,800.00
33
34
EE/ER RateMonthly Ceiling
35
NIS RateApr-20226.0%12,500.00
36
"Apr-20216.0%7,500.00
37
"Apr-20206.0%3,750.00
38
"Apr-20195.5%3,437.50
39
"Before5.0%3,125.00
40
41
42
Email: financialcentsibility@gmail.com
43
www.financialcentsibility.com
44
Twitter: @MsGillyJ
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100