New Tanzania PAYE and Pension Salary Excel Calculator 2013 – 2014


mwambojoke

mwambojoke

JF-Expert Member
Joined
Oct 12, 2011
Messages
863
Likes
330
Points
80
mwambojoke

mwambojoke

JF-Expert Member
Joined Oct 12, 2011
863 330 80
The concept of PAYE is based on 6 levels as following:

Level 1
Pension amount equal to 10% of the gross salary is not taxable
Hence
Taxable salary = Gross Salary – Pension amount

Level 2

Taxable salary that is equal or less than TZS. 170,000/= is not chargeable

Level 3

Taxable salary Between TZS. 170,000/= and TZS. 360,000/= is charged 14%

Level 4

Taxable salary Between TZS. 360,000/= and TZS. 540,000/= is charged 20% Plus tax from Level 3

Level 5

Taxable salary Between TZS. 540,000/= and TZS. 720,000/= is charged 25% Plus tax from Level 4

Level 6

Taxable salary above TZS. 720,000/= is charged 30% Plus tax from Level 5

Download hii excel calculator hapa

http://www.kivuyo.com/?file_id=24


Based on this concept
A staff whose gross salary is TZS 1,000,000/= (One million Tanzanian Shillings) as an example is taxed as follows:

 
IGUDUNG'WA

IGUDUNG'WA

JF-Expert Member
Joined
Oct 22, 2011
Messages
2,044
Likes
944
Points
280
IGUDUNG'WA

IGUDUNG'WA

JF-Expert Member
Joined Oct 22, 2011
2,044 944 280
ngoja nidownload nione maana huwa naona jamaa wanakwangua tu salio langu.... hawa TRA wakuda sana aisee yani mtu unakuta pension fund unayochangia ni ndogo kuliko unayokwanguliwa na TRA... pumbafu sana hawa jamaa
 
DZUDZUKU

DZUDZUKU

JF-Expert Member
Joined
Nov 8, 2012
Messages
3,693
Likes
1,107
Points
280
DZUDZUKU

DZUDZUKU

JF-Expert Member
Joined Nov 8, 2012
3,693 1,107 280
Mh, kumbe mambo ndo yalivyo,nasikiaga tu watu wana lalamika kwamba makato makubwa...............
 
mwambojoke

mwambojoke

JF-Expert Member
Joined
Oct 12, 2011
Messages
863
Likes
330
Points
80
mwambojoke

mwambojoke

JF-Expert Member
Joined Oct 12, 2011
863 330 80
ngoja nidownload nione maana huwa naona jamaa wanakwangua tu salio langu.... hawa TRA wakuda sana aisee yani mtu unakuta pension fund unayochangia ni ndogo kuliko unayokwanguliwa na TRA... pumbafu sana hawa jamaa
Download uone mwenyewe
 
andrewk

andrewk

JF-Expert Member
Joined
Apr 13, 2010
Messages
3,104
Likes
59
Points
145
andrewk

andrewk

JF-Expert Member
Joined Apr 13, 2010
3,104 59 145
Ungetumia...... IF function, mfano kwa kutumia rate za zamani

[TABLE]
[TR]
[TD="class: xl65, width: 105"] =IF(E4>540000,(((E4-540000)*30%)+96000),IF(E4>360000,(((E4-360000)*25%)+51000),IF(E4>180000,(((E4-180000)*20%)+15000),IF(E4>80000,((E4-80000)*15%),0))))
[/TD]
[/TR]
[/TABLE]
 
B

BekaNurdin

JF-Expert Member
Joined
Dec 21, 2012
Messages
1,778
Likes
1,046
Points
280
B

BekaNurdin

JF-Expert Member
Joined Dec 21, 2012
1,778 1,046 280
Ninakamuliwa kodi kubwa sana hadi inaniuma! Halafu nenda dukani unapigwa kodi nyingine tena, kama hiyo haitoshi huduma za kijamii ndio kama hivyo zilivyo. Kila kona ni maumivu!
 
mwambojoke

mwambojoke

JF-Expert Member
Joined
Oct 12, 2011
Messages
863
Likes
330
Points
80
mwambojoke

mwambojoke

JF-Expert Member
Joined Oct 12, 2011
863 330 80
Ninakamuliwa kodi kubwa sana hadi inaniuma! Halafu nenda dukani unapigwa kodi nyingine tena, kama hiyo haitoshi huduma za kijamii ndio kama hivyo zilivyo. Kila kona ni maumivu!
Hapo ndo uone wabunge walivo wajanja. Wamejiwekea kamshahara kadogo, halafu kinachobaki eti posho ili kisikutane na PAYE.
 
mwambojoke

mwambojoke

JF-Expert Member
Joined
Oct 12, 2011
Messages
863
Likes
330
Points
80
mwambojoke

mwambojoke

JF-Expert Member
Joined Oct 12, 2011
863 330 80
Ungetumia...... IF function, mfano kwa kutumia rate za zamani

[TABLE]
[TR]
[TD="class: xl65, width: 105"] =IF(E4>540000,(((E4-540000)*30%)+96000),IF(E4>360000,(((E4-360000)*25%)+51000),IF(E4>180000,(((E4-180000)*20%)+15000),IF(E4>80000,((E4-80000)*15%),0))))
[/TD]
[/TR]
[/TABLE]
Karibu
 
Shark

Shark

JF-Expert Member
Joined
Jan 25, 2010
Messages
23,424
Likes
11,996
Points
280
Shark

Shark

JF-Expert Member
Joined Jan 25, 2010
23,424 11,996 280
Ungetumia...... IF function, mfano kwa kutumia rate za zamani

[TABLE]
[TR]
[TD="class: xl65, width: 105"] =IF(E4>540000,(((E4-540000)*30%)+96000),IF(E4>360000,(((E4-360000)*25%)+51000),IF(E4>180000,(((E4-180000)*20%)+15000),IF(E4>80000,((E4-80000)*15%),0))))
[/TD]
[/TR]
[/TABLE]
Kuna mwenye rate mpya iliyo katika formula hii hapa juu??
 
vaikojoel

vaikojoel

JF-Expert Member
Joined
Jun 30, 2011
Messages
2,046
Likes
215
Points
160
vaikojoel

vaikojoel

JF-Expert Member
Joined Jun 30, 2011
2,046 215 160
nilikua najaribu ku attach apa nimeshindwa
 

Forum statistics

Threads 1,273,091
Members 490,268
Posts 30,470,990