How to Make Income Tax Calculator in Excel | How to Calculate Income Tax in Excel By The Accounts

  Рет қаралды 78,263

The Accounts

The Accounts

Күн бұрын

Пікірлер
@swapnilshinde9351
@swapnilshinde9351 5 жыл бұрын
सर आपका ये काम बहुत अच्छा हें. ये ऐसे ही चालू रखे
@asthadron9448
@asthadron9448 4 жыл бұрын
waah bahi ahmad, mere dost , bahut badhiya padhate ho
@Shaurya398
@Shaurya398 2 жыл бұрын
Thank you so much for your input .... Keep helping people and your business will also grow exponentially
@DK-sp5si
@DK-sp5si Жыл бұрын
Love you sir ... ❤❤❤
@rahulkushwaha799
@rahulkushwaha799 5 жыл бұрын
Awesome Sir Thanks
@rockykumar-hl6mq
@rockykumar-hl6mq 4 жыл бұрын
Great sir. Thank you for sharing your valuable knowledge with us.
@qaziimdadali5039
@qaziimdadali5039 3 жыл бұрын
In your calculator where to put Interest on Housing Loan interest paid.
@jagrativerma2117
@jagrativerma2117 4 жыл бұрын
Nice Explanation but the video which was more beneficial for me was by CAAJ CA arihant jain on income tax calculation FY 2019-20
@jubersid
@jubersid 5 жыл бұрын
Hello Sir, Excel Mai Creditors and Debtors A/c Kaise Maintain Krain . Pls Is pr bhi Ek Video Bna Dijiye Bahut Help Hugi. Or apki saari videos Muje kafi help Huti. Thank you very very much Sir..
@kirtiSheth17
@kirtiSheth17 4 жыл бұрын
Nice video with detail explain excel formula, but tax payer are different category i.e. for Below 60 years-Normal Individual, if he//she between 60 & 80 yrs- Senior citizen and above 80 yrs, Super Senior citizen, based on this category/class of Tax Payer, and have different slab of I-Tax, than what should be the formula in Tax on Taxable income column, please reply and send link of video to understand the correct tax Taxable amount. Thanks
@firozkhan636
@firozkhan636 4 жыл бұрын
सर बहुत ही अच्छा कार्य रहा है। इन्कम टेक्स में आपने HRA जैसी चीजों के बारे में बताया, इसके अलावा जो छूट दान में, चिकित्सा में मेडिकल इंसजोरेंस में IF कंडीशन लग सकती हैं, वो नहीं हैं, सर plz उनके बारे में भी बताएं, हमें नहीं आता किस मद का कितना प्रतिशत कटता है।
@pinchiter07
@pinchiter07 5 жыл бұрын
Very helpful everything explained 👍👍.
@Gurjeet_kaur97
@Gurjeet_kaur97 2 жыл бұрын
well explained !
@deepakjadhav1058
@deepakjadhav1058 4 жыл бұрын
Nice teaching
@Sohail.Hyderabad
@Sohail.Hyderabad 5 жыл бұрын
Make a video on bad debt
@salimali2393
@salimali2393 4 жыл бұрын
this is one of the masterpieces of your chapters. I have got knowledge about GST but I don't have knowledge about income tax.
@keshavkumar-ze6hh
@keshavkumar-ze6hh 4 жыл бұрын
Sir, pls make a video of debtor and creditor reconcilition
@animalsdiscover6112
@animalsdiscover6112 5 жыл бұрын
Sir please can u explain gst subhida center franchise business
@PawanKumar-zx3df
@PawanKumar-zx3df 5 жыл бұрын
Jai ho 80cc me Formula Thanks Very Much...
@rockeyhandsome9079
@rockeyhandsome9079 3 жыл бұрын
Sir tax in total income 2021-22 ka formula banaiye
@moinsayyed9204
@moinsayyed9204 5 жыл бұрын
Gstr9 live demo pr video banaiye
@IRFANKhan-dr4nv
@IRFANKhan-dr4nv 3 жыл бұрын
Income tax file read krne pr video banao sir please
@mangeshambhore5598
@mangeshambhore5598 Жыл бұрын
Ye latest 2022-23 me chal sakta hai kya?
@meet18upadhyay
@meet18upadhyay 5 жыл бұрын
Sir ye excel sheet chahi he to please uski link send kiji e
@vithalgoud734
@vithalgoud734 3 жыл бұрын
Sir namaste sir apan beech mein PF ya gis deductions change hua tho vo bathane ka formulae bathayiye sir please Example August mein change hua tho kaise bathasakte
@rubel.talukder3
@rubel.talukder3 2 жыл бұрын
Metro & Non metro calculation drop down list. How to create?
@jaynandangiri4401
@jaynandangiri4401 5 жыл бұрын
Dear Sir Mujhe ye bataye ki agar me packing material ka saman kharid Raha hu just like plastic, cartoon,etc wo bhi pcs or different rate me tab iski entry purchase me kese karenge jabki plastic to hamara stock nhi hai Kya me purchase ke name se alag voucher bna sakta hu jese purchase general goods Taki jab me general item purchase karu to uski report me malum pad Jaye but stock me add nhi hona chahiye...........kuch bataye bahut badi problem me hu ..........,.... Sir
@bantikhan8380
@bantikhan8380 5 жыл бұрын
Shukriya
@jubersid
@jubersid 5 жыл бұрын
You are great sir.. Again Thank you.
@salimali2393
@salimali2393 4 жыл бұрын
I would like to learn about income tax could you please help me.
@mohdiqbalkhan393
@mohdiqbalkhan393 5 жыл бұрын
Sir nice video. Pls give link of this excel sheet
@dhariwaletutorial6136
@dhariwaletutorial6136 4 жыл бұрын
AY 2021-22 ki sheet h apke pass mai khareedna chahta hu
@farhaankhanvlog3080
@farhaankhanvlog3080 5 жыл бұрын
Sir Website ke bare m v ek video banaye
@shaikosman4339
@shaikosman4339 5 жыл бұрын
Assalamualaikum sir Dear please make vedio on account audit
@rakeshkumarjena05
@rakeshkumarjena05 5 жыл бұрын
Sir please make a video of deduction U/s 80 in detail
@mukundpotdar9849
@mukundpotdar9849 4 жыл бұрын
Sir, You have my job easier to calculate income tax. Since, I m working a Senior Officer - Payroll
@kishangupta622
@kishangupta622 3 жыл бұрын
Sir Tax calculatar if function please share me link
@azizurrehman7295
@azizurrehman7295 5 жыл бұрын
Nice Vedio Plz send Excel sheet for Tax calculator link
@mdc9602
@mdc9602 2 жыл бұрын
Your formula for HRA rebate calculation will fail if the employee is not paying his rent. You can use "=IF(D18=0,0,(MIN(C18,D18-B18*10%,IF(D16="METRO",B18*50%,C18*40%))))" this for HRA REBATE calculation. Hope this fixes the anomaly.
@ghmshanumanti2980
@ghmshanumanti2980 7 ай бұрын
Formula kaha hai
@sachinkashyap6371
@sachinkashyap6371 5 жыл бұрын
Sir apsee request thi ki ke bal sale puchase se or bank statement se kaise balnace sheet banate hai ish par video banao please sir
@MdAdil-uf1hu
@MdAdil-uf1hu 2 жыл бұрын
Paid the amount but download is not starting. Why?
@dongareaniket3018
@dongareaniket3018 5 жыл бұрын
sir muze excel sheet ki link send karo na
@gangubhai5976
@gangubhai5976 4 жыл бұрын
sir one small dought HRS caculation dought
@binodkumar6392
@binodkumar6392 3 жыл бұрын
For HRA calculation 1). Actual HRA Received 25000 25,000.00 2). Rent Paid - 10% of Basic Salary + DA 20000 - 10% of 60000 14,000.00 3). 50% of Basic Salary + DA (if Metro City) 50% of 60000 30,000.00 40% of Basic Salary + DA (if Non Metro City) Which ever is less 14,000.00 Total HRA Rebate (14000 x 12) 14000 x 12 168,000.00
@RakeshKumar-qd3ix
@RakeshKumar-qd3ix 5 жыл бұрын
Sir jo metro aur non-metro formula jo h shi nhi lag rha wrong h, aap dobra lagakar dekhiye mujhe smjh nhi aa rha aap kaise lga rhey h
@swapnilshinde9351
@swapnilshinde9351 5 жыл бұрын
सर सर्विस सेक्टर अकाउंटिंग पर एक विडिओ बनाये
@Sanjaykumar16979
@Sanjaykumar16979 4 жыл бұрын
Superb
@prabhatkumarsingh2460
@prabhatkumarsingh2460 4 жыл бұрын
please provide calculation sheet
@sushilmallick2432
@sushilmallick2432 5 жыл бұрын
In excel, with formula please discus the bank reconciliation.
@Aspir8
@Aspir8 3 жыл бұрын
Sir ek doubt h ki Agricultural income ka computation nhi hota kya?
@rajeshacharyavlogs9317
@rajeshacharyavlogs9317 4 жыл бұрын
Fd interest ka calculator hai kya
@fatemarasiwala7813
@fatemarasiwala7813 4 жыл бұрын
#Budget2020 has left us very confused. New tax regime and Old tax regime has complicated our decisions while filing ITR. Your worries can end here. You don't have to complicate your calculations by doing it yourself in excel You can simply calculate your Income Tax liability here with Quicko's Income tax calculator here- tools.quicko.com/income-tax-calculator?
@mangeshambhore5598
@mangeshambhore5598 Жыл бұрын
Ye calculator update hai kya sir ji.
@VishalKumar-tp6uv
@VishalKumar-tp6uv 4 жыл бұрын
Sir 500000 lona lene ke liye ITR mein kitni income show karna pdegi ITR salary ki h sir ji plz reply me
@aniltechb9072
@aniltechb9072 4 жыл бұрын
Sir where this formula of tax in total income
@PawanKumar-zx3df
@PawanKumar-zx3df 5 жыл бұрын
Maan Gye Guru
@Soniyasaini29
@Soniyasaini29 3 жыл бұрын
Payment paid krne ke baad bi open nhi no rha hai..why?
@tomanmalekar
@tomanmalekar 4 жыл бұрын
computation file calculate karne ki excel sheet download karne ka link bheje sir ji
@greatraj134
@greatraj134 5 жыл бұрын
Bhai iska download link bhi de detA to better rahta
@Power--
@Power-- 4 жыл бұрын
("NIL") Ka formula digiye plz
@rajnimehta8
@rajnimehta8 3 жыл бұрын
I have paid the amount but no response from your site...
@ankityogi8027
@ankityogi8027 4 жыл бұрын
Sir document b btta de
@sandeepchauhan1984
@sandeepchauhan1984 4 жыл бұрын
plz provide me this file in excel sheet
@sachinmandawkar3633
@sachinmandawkar3633 3 жыл бұрын
Formula of 2020-21
@understandthewordsfeelthes3036
@understandthewordsfeelthes3036 3 жыл бұрын
👍
@iamdeepaksasmal
@iamdeepaksasmal 5 жыл бұрын
Link kahan hai file ka ? ... Kisi ko dikhe toh mujhe batana
@azizurrehman7295
@azizurrehman7295 5 жыл бұрын
Same issue with me
@mohdwaseem7048
@mohdwaseem7048 3 жыл бұрын
Ye koi nahi bata raha ki form kese kaha se download kare
@anantrane1142
@anantrane1142 5 жыл бұрын
Formula not work
@mdzeeshan5969
@mdzeeshan5969 5 жыл бұрын
Excel ka ye sheet hi send ker dijiye
@mdzeeshan5969
@mdzeeshan5969 5 жыл бұрын
Mdzeeshan065@gmail.com
@Soniyasaini29
@Soniyasaini29 3 жыл бұрын
Payment paid krne ke baad bhi buy now aa rha hai
@shelusharma9909
@shelusharma9909 4 жыл бұрын
Sir ap koi bhi file free me kiyo nahi dete h her file paid h esa kiyo me apka ek acha fan ho please sir kuch kijeye
@shyampihulkar9665
@shyampihulkar9665 4 жыл бұрын
link bejo
@udayprasad9348
@udayprasad9348 5 жыл бұрын
Ptax 2400 hoga sir 200*12= 2400
@hasmitaharchandani9409
@hasmitaharchandani9409 2 жыл бұрын
Mat calculation
@RAHMATMUSICPRODUCTION
@RAHMATMUSICPRODUCTION 4 жыл бұрын
Ye to old tha payments kr di ha ha ha
@Rizwan.Kolkata
@Rizwan.Kolkata 4 жыл бұрын
Sir, kindly text me in personal, I have something to show you.
@TheAccounts
@TheAccounts 4 жыл бұрын
Bindas33727@gmail.com
@Rizwan.Kolkata
@Rizwan.Kolkata 4 жыл бұрын
Mail sent, kindly help
@happylife3043
@happylife3043 3 жыл бұрын
Sab kuch khud kar lete ho to vedio q banate ho Kuch samajh me nahi aa ta hai
@GOPUFFLIVE
@GOPUFFLIVE 5 жыл бұрын
Sir ji is excel sheet ko mail id me send kijiye n pls.....akt.1July@gmail.com
@afnanmaloof2023
@afnanmaloof2023 Жыл бұрын
Vedio quality is bad
How To Maintain INCOME & EXPENSE With PROFIT & LOSS in Excel ?
15:45
Deepak EduWorld
Рет қаралды 1,1 МЛН
IL'HAN - Qalqam | Official Music Video
03:17
Ilhan Ihsanov
Рет қаралды 700 М.
黑天使被操控了#short #angel #clown
00:40
Super Beauty team
Рет қаралды 61 МЛН
RCM in Tally Prime | What is RCM | RCM Accounting in Tally
18:27
The Accounts
Рет қаралды 6 М.
IL'HAN - Qalqam | Official Music Video
03:17
Ilhan Ihsanov
Рет қаралды 700 М.