Check on the basic information tab, have you filled out the correct return dates? Ensure to save the excel worksheet as macro enabled, close it then reopen and fill out the basic information tab details it should pick correct details. ^CW
Good job sir. My workbook doesn't have the rows for January-June, June-December Income and Pension hence my sheet keep registering a big negative or positive value mismatch at the Tax refund sheet. Also my personal relief keep saying "Please enter positive numeric value less than or equal to 13944. What could be the problem?
Hope you are filling everything the way. Have you tried starting afresh and download the workbook again. I noted when you dont fill jan-june, june- Dec, you end up with huge figure in tax refund/due..kindly repeat the process again
It can be either..only that when the +ve or -ve is quite big..you should recheck if you followed the right procedure..Again, tax due or tax refunds depends on the p9 form..it varies from person to person
on Tax computation, when I add relief tax 28,800 it rejects and msg pops up stating that " please enter positive numeric value less than or equal to 13944" Why is it so?
To get the rows for pension, just ensure you enable macros
How?
Mine indicates Microsoft has blocked Marcos from running because the source of this file is untrusted
Once i enable macros, I'm not allowed to edit anything again. What can one do?
It's still not appearing even after enabling macros
Check on the basic information tab, have you filled out the correct return dates? Ensure to save the excel worksheet as macro enabled, close it then reopen and fill out the basic information tab details it should pick correct details. ^CW
Very good tutorial. You've shown the steps clearly and are quite succinct.
hio succ ... ndio nini. otherwise great
excellent job ,5 stars rating
THIS IS REALLY HELPFUL AND VERY WELL DETAILED INFORMATION. THANK YOU SO MUCH
Nothing to add, Atwoli said it all. Thanks so much
Very clear explanation. Thank you for your assistance
Wow! very well explained. God Bless You mate.
You are the best. Just did mine step by step with you
Good Job , extremely helpful
Thank you so much, this was very helpful and easy.
Good stuff and straight to the point
The version 18.0.10 does not have the Jan-june income part hence when you input personal relief it doesnt accept any value over 13944
True.
Use the latest version of MS office if at all you encounter problems
What if the P9 form has MANUAL PAYE? SHOULD I USE THE TOTAL PAYE?
Very helpful. Thank you
What is the procedure when your p9 has manual PAYE and arrears?
Very clear, good job
great work👏👏👏👏
Thanks a lot!
The problem is that Junior School intern teachers cannot file nil returns so I'm wondering how to go about it.
Very gud explanation
Good job got it
Thanks man. You saved a lot
Hi, Thanks for the infor ,Do you mind sharing the it2 sheet coz my portal is producing sheet with NAME errors
Thanks..You mean the excel sheet or?
Drop ur email pls
What is the pin of insurance, name,type of policy , insurance policy cover etc that row mnajaza nn?
Very helpful indeed
what if there is no that part of january to june...
Very helpful.
Good job. Thank you!
What if it's a teacher and he or she has a withholding certificate after participating in marking national examinations....
That has a different procedure..for now kindly search in yt..I will upload myn soon..thanks
Great
Good job sir. My workbook doesn't have the rows for January-June, June-December Income and Pension hence my sheet keep registering a big negative or positive value mismatch at the Tax refund sheet. Also my personal relief keep saying "Please enter positive numeric value less than or equal to 13944. What could be the problem?
Hope you are filling everything the way. Have you tried starting afresh and download the workbook again. I noted when you dont fill jan-june, june- Dec, you end up with huge figure in tax refund/due..kindly repeat the process again
Me too. I have tried severally, and am not getting the same workbook like his
Iko hapo chini kwa employment details
Nice workflow. ❤
@@KcseMathsTutorials Did you find a solution facing the same issue now
I am the employer, how do i get the p9 form for my employee?
Very helpful
What if after validating amount is negative
It can be either..only that when the +ve or -ve is quite big..you should recheck if you followed the right procedure..Again, tax due or tax refunds depends on the p9 form..it varies from person to person
Kindly help under cell 9,15 and 31 am getting the same error #NAME? where might I have gone wrong please?
nice kindly tell how to go about if you are an examiner
That's filling withholding tax..for now I haven't uploaded a video on that..there are couple of videos on the same in yt
Help. My excel sheet does not have the Jan-June, July-Dec rows.
Have you tried using the latest version of mocrosoft office?
What about negative figures at the end
on Tax computation, when I add relief tax 28,800 it rejects and msg pops up stating that " please enter positive numeric value less than or equal to 13944" Why is it so?
That's were am stuck too
How do we treat arrears?
Add to taxable income
I got 2800 at the end, what do I do?
Where does NHIF relief fall into?
Nice job. Thumbs up
what if i have an exemption certificate
How is it your sheet is balancing at tax computation yet at employment income January to June figures are wrong and don't add up to the gross pay?
Really?
I have noticed that too.
Where are we putting manual payee
the excel i got didnt have those Jan-june , July -Dec things
Have you enabled macros in excel sheet?
@@KcseMathsTutorials YES I HAVE. STILL IT HAS NOT DISPLAYED.
Update your ms office and use the latest version
Update your ms office and use the latest version
How comes mine does not bring about the option for Jan -July income, anyone?
Same here it doesnt have that section
@@antonymurimi4121 Enable macros in Excel, it will work
in properties of that document, enable edit of document
Thanks a lot
Thank you.
Thanks
What if I find -5250
Where is nhif tax relief return?
First page click on "do you have insurance relief?" Click on yes ,another page for insurance will be added for filling
Good
Does it mean end of balance sheet you get +positive figures and not 0?
@@johnndirangu1053can only see " do you have insurance policy?
Barely will you get zero..it may be a small + or _ve
Followed through,but when I entered the mpr...it keep saying I input a way much lower value?
On sheet A, please delete the dates 'return period from' and 'return period to' and retype them, it will work.
cool
name of employee is TSC just like that or their is another
That has no impact if you write in full or just TSC
😂😂😂 A few minutes to the deadline and I'm getting negative values. I'm tossed
Lol same😭😂
No o o channvj ae