Input Tax Credit (ITC) Reconciliation in GST: Updated Method 2023

[@learnwithvikku6427]

Sir, pls make a video on Excel for accountant.

[@WHOHAQ1975]

Sir please excel vedio

[@amanshrivastav7399]

Bhai excel + chatgpt krle alag se koi bhi excel formula & trick use nhi krna prega

[@Hickey-zb1pp]

​@@amanshrivastav7399 how ?

[@anubhabdi]

Very much appreciable guidance.Many more such guidences on the same subject with more elaborately expected in future.

[@DM-YouTube]

Sir, you videos are always very helpful. Could you please make one video on how to fill the ITC table options in 3B as per Reconciliation result. Like 1.What to do when bills are in 2B but not in books as material is not received 2.What to do when bills are in books but not in 2B Both these can be bills of allowable ITC & disallowed ITC How to show the values in 3B ITC table options & Accounting entries thereof in such cases

[@SumeetPathare]

Plsss....sir we really want a full fledged video on ms-excel... From basic to advanced... Your teaching style is amazing 😍

[@bhanudaspawar5712]

Sir your explanation is very good and appreciable.guidance

[@xioracky]

This brings tears to my eyes,seeing how hard and complicated this is, I just import JSON into tally and work there, reconciliation done in 5 minutes, If I had to do this every month I would never be able to file returns :D

[@dileepsharma3090]

Sir please make details videos on Excel

[@itsvinitsingh]

Thank you Sir ❤ bholenath ka ashirwad bana rahe aap pe

[@muhsinsinu7135]

Sir your videos are helpfull.can you make videos in English . That will help a lot of students❤

[@SAHIL_.XX6]

Hello Sir, Please make excel basic to advanced video tutorial which is beneficial for an accountant

[@FinTaxPro]

Sure I will

[@thebingefactory5881]

Sir, this vlookup function can be reduced if you add a new column in your merge data sheet, like making only 1 single sheet for merge data of 2b and books. And making a column with name source and mention 2b and tally for relevant data in the rows. And in pivot use that under column heading in pivot. This will make both tally and 2b data coming simultaneously beside each other, upon the same gst number.

[@FinTaxPro]

Yes last year i have already made a video on that.

[@GauravSharma-bt2fj]

​@@FinTaxProsir, we all value your efforts please make a video on Excel for gst professionals

[@pradipchakraborty7892]

Sir, please make a video on advanced techniques for utilization of Excel formulas .

[@nareshgohel1806]

Sir, what i suggest is, can we take data of table 8A of portal for full year reconciliation ?

[@CA_Hardev_Jadeja1]

yes sir we want detailed video on excel basic functions

[@shwetaagarwal6382]

This is a very good and informative video! Thankyou so much sir!!

[@pb0001x]

Apki sari videos ❤❤❤❤❤❤❤❤❤❤❤

[@biswajitadak6722]

Yes Sir please make a video on Excel

[@viralshorts8178]

yes sir please make the video on excel mostly for gst and income tax work

[@SurajKumar-io3wp]

Sir mai pay nhi kr skta hu course k liye par m ye sb sikhna chahta hu mujhe interest h taxation and accounting mai.mere pass pese nhi h pay krne ke aap free video dalte rahe youtube par thanks

[@raghuca5230]

Sir, please make a video on Excel.

[@Tally930]

Thanks u for making video on itc reco. I want to learn also Excel so please make a video on Excel.

[@pavanguggilam5273]

Hi, sir. I am from Andhra pradesh. I like your videos. Please make your videos and offer your courses in 100℅ English language also.

[@vikassrivastava2149]

Yes sir Excel pr bana dijiye sir all basic formula

[@DAEBAK-z4m]

Sir you are great 🎉🎉🎉❤

[@rajusaha862]

Make Excel video for accounting purposes

[@SuMantEditzOfficial]

Love for this video

[@NitileshPednekar]

Good video , simple way

[@SuperAndy1983]

Yes sir .....want detail excel video

[@MailbankKbjassociates]

Sir,For Quaterly return filler, Any suggestion if the client has not claimed ITC in Q2.

[@tulasiramtripathy6446]

Very nice. Excel master class need

[@shaguftashaikh919]

amazing. thank you so much

[@arpitabhatnagar1441]

Please make video on ineligible, partly eligible ITC, reversal

[@Akhileshyadav-qi1uh]

Sir please make video on excel if possible.......its very valuable for us.

[@Rahul-tx8fo]

Yes make video on excel for account

[@actkikuwa2832]

we need excel video regarding v-lookup, h-lookup ,poivoit table

[@anirbanpatra6898]

Thank you so much Sir.

[@vickychourasia2032]

Yes sir please make excel video

[@shivajichavan1751]

Sir please send this video again & again for learning staps

[@visheshsinha1458]

Please sir basic excel mein jo daily formula use hote hai unpe ek detailed video bana do.

[@rahulsingh-ij7ur]

Same direct 2b ko download krne se or aap jaise btaya usse download krne se kya difference hoga?

[@RushikeshBodhane]

Dear Sir , Hi please make video on GST payable reco

[@meet.prajapati1999]

Sir, please make a video for a detailed Excel program.

[@Shravan1231000]

Sir credit note or amended invoices ka data kaise merge kare...amt negative le ya positive hi rakhe..??

[@SanjayKumar-kz7dg]

Great Job 👍

[@FinTaxPro]

Thank you! Cheers!

[@pmsafee7426]

Sir Please make an video on MS Excel for Tax Consultant or Tax Accountant.

[@rupeshpandit8094]

Sir transportation work ki accounting ke liye video banaiye

[@tarangpadmashali8326]

sir practice k liye ye wali sheet excel base milegi ????

[@swathivenugopal8325]

Nice method

[@dineshchauhan5871]

Dear Respected Sir, 🙏🙏 Please make one video of Excel.

[@SaifAli-ip3fq]

Thank you sir ❤

[@amankeshari5433]

Sir needed Video on Excel...

[@gauravgarg9509]

Can ITC be claimed if purchase are not recorded in books of accounts. If yes, then what is time limit to record purchases in books of accounts

[@vishalsahota1686]

Sir excel ke upper basic to advance video bna do please

[@hemantpandit1718]

Arey sir Fals formula use kar diya karo for matching

[@vartikasukhwani742]

Sir, please make a video on excel function and its shortcut so we can learn and make command

[@RahmanKhan-y4r]

please make a detailed video on excell

[@farheenahmed242]

Sir please make a video on excel for beginner to expert

[@subhashsaha6068]

Thanks

[@shivam-gupta2004]

Sir excel par ek detailed video bhi bana do

[@RajeshSharma-zh9wt]

Excel ki pivot table sikha dijiye sir

[@dewangananil4400]

Sir please make video on excell working like vlookup and pilot table.

[@bhavnasolanki7954]

Sir, please make this reconciliation video of GSTR 3B for monthly party.

[@Neeta12316]

Excel shortcuts for accountant point of view pls make video sir

[@suhana9898]

Sir kindly make a video in Excel. Thank you

[@rahulsingh-ij7ur]

Tally me ledger wise q, jay?? Tally Gst 3b summary me pura 1year ka nikl skte hai.

[@Autojat]

Sir make a video on itc restricted due to change in pos rule. How it is treated in gstr-3B and as well in tally. In my case i have not avail itc as it is restricted nor it is show in total itc available but unfortunately seller upload a credit note against this which is show in total itc available in negative

[@rautgulshan]

Sir GSTR1 Book ko kaise reconcil kre, aur kin kin chijo Ko trial Balance se match kre taki Hamara GSTR1 proper ready ho jaye

[@sanjaymukherjee6046]

Sir please make an Ms Excel detailed video.... And sir also make some more videos on chatgpt

[@swapnilpachpande1176]

Sir Excel ke upar ek Detailed video banaye Sir

[@manishkeshorts0007]

You can export input cgst and igst ledgers

[@ramsahu7298]

Sir duties and taxes me jaakr hum data export kr skte hai kyu ki usme Sare expenses and purchase aa jata hai....

[@RakeshKumar-eq6ir]

T̤h̤a̤n̤k̤ y̤o̤ṳ s̤i̤r̤ 😍🇮🇳🥰🙏🏽

[@mehtabshaikh7454]

Sir how did you arrange tally and GST data so chronologically??? I mean Agar Mai export bhi Karu toh same party ka data Ek dusre k opposite Mai nhi hota ooper niche hota hai nd it's only possible when We use software like winman and other... Can you please clarify this

[@harshgohil4367]

Same doubt

[@sandeepkumar-jh1vy]

Sir excel detail video leke aaiye sbki demand hai

[@behappychildren1437]

But sir, kuch ITC 2A mai show hoti hai but ham 3B mai bhee claim nhi krte hai woh kaise Match karenge

[@girishkumar3358]

Sir plz make the video on excel for excel working

[@imtiyazsheikh6597]

Sir Pivot table se hi reco kar sakte hai

[@amichand3138]

Sir Facebook ki bill date or 2B me difference hota hai to us case me ITC kaise le

[@snehalpawar9154]

Sir pls make a video on excel for accountant

[@vinodkumarprajapati5221]

Sir Excel par full detail video bana do bhaiya GST and tax use

[@ashishsahu4041]

Sir Excel details Wali video bano

[@taxnetconsultancy674]

please sir make a videos for advance excel function

[@RAJEEVKUMAR-xl1xp]

Hi Please make an advance excel video

[@FinTaxPro]

Okay

[@rajeshgupta2218]

Thanku Sir

[@pradeepshende9416]

Sir if we can't avail itc after oct then can supplier show his sale? He also not liable to show his sale. Correct

[@fatemapresswala5023]

Can u pls make video on gstr3b working as ur videos r v usefu

[@rajutanwar5476]

Sir apne Merge karna nhi btaya B2B,CN,import kaise merge kiyas

[@SurajYadav-lt8df]

sir bna do ek complete video excel pe

[@sujitkumarmishra8021]

Sir excel pr v ek video bna do please

[@jitendrathakur4377]

Tally se export IGST CGST and SGST ka ledger ko kar sakte esse koi bhi ledger nhi chhutega

[@varsha2016]

Sir, agr kisi company mein 2021-2022 tk sirf purchase kri ho. Toh uska portal pr ITC claim pending rehta hai.Aur 2022-2023 mein sale bhi start ho gyi ho....toh sir 2023 se lekar abtk tk jo bhi challan mein payable amount bnegi sale bill ki vajah se vo pending ITC se neglect hoti rhgi na???jbtk pura credit balance khtm na hojaye... please tell me ye shi h,??

[@abidmeer9753]

Great.... ❤

[@sunilkumarprajapati1262]

Sir isme debit or credit bhi merge kar sake hai kya

[@Scalpdaytrader]

Sir Excel detailed video benaiye 🙏

[@FinTaxPro]

Ok sure

[@lalitkedia8140]

Sumif formula on GSTIN is more easy rather then pivot

[@azimkhan5792]

Please banaye sir excel complete video

[@SunilY03.]

Sir please detailed guide video on excel chahiye

[@arpitraj4546]

Tally Mai backup & restore aur ek company Mai _ four log kasi kaam kargaya

[@ramgopalyadav3522]

Sir itne saare ledger export karne se better hai sirf input IGST, input CGST Ke ledger ko columnar me karke export kar sakte Hain, correct me if I am wrong

[@Rahul-tx8fo]

Pata hai

[@Rahul-tx8fo]

You are correct

[@AlwaysLookGood]

Sir ek excel pe detailed video bna do