ADVANCED GSTR 2A RECONCILIATION IN EXCEL | HOW TO RECONCILE PURCHASE WITH GSTR 2A

[@ShubhamGupta-vt7zz]

Jabardast Maine try nahi kiya abhi khud se, but dekh k kaafi kuch sikhne mila hai, practically karne k baad, surely I will again get back

[@ganga6473]

Yes very simple and wonderful teaching and a great video in simple teaching. God bless you more and more wisdom in your work.

[@Excelhurdles]

Thank you ji😊 happy learning

[@pramodsaxena335]

Thanku so much for data for practise , very helpful video , maine apke video pe jitna ads aaya use pura dekha aur bar bar dekh raha hu jitna bhi ads aaya hai taki apko thanku bole saaku , once again thanku so much

[@Excelhurdles]

Thank you.❤️ i hope this video is helpful for you. But apko itna ads dekhne ki jarort nhi. usse jyada kuch frk nhi pdta revenue me. apne itna appreciate kr diya vhi bhut hai. happy learning😊

[@shyamtiwari7644]

Your explanation is very simple and even a person without having much knowledge in the pivot table can easily understand. 🎉

[@Excelhurdles]

Thank you ji😊 keep supporting❤️

[@SureshSharma-zi6qs]

I m very thankful to u..sb ki videos dekhi but..smj aap hi ka aya..

[@Excelhurdles]

Thank you❤️

[@prabhatdubey4691]

This video add more skill and create an edge over others , what a wonder full video .. Sach kaha tha apka video dekhte-2 PIVOT Table aajayega aur aa gaya 😊😊 👍👍🙏🙏

[@Excelhurdles]

Thank you for this positive feedback😊 Happy learning and keep supporting❤️

[@supriyodutta6671]

VERY USEFUL FOR BEGINNER ( SHOULD WATCH )

[@supriyodutta6671]

u described very well in manner from ZERO to SCRATCH .

[@Excelhurdles]

Thank you ji😊 keep supporting

[@sagarkamrani1643]

Such a simple and effective method.. thanks for sharing

[@Excelhurdles]

Happy learning❤ keep supporting

[@kamaldas6944]

Leaning & knowledgeable video🎥🎥

[@Excelhurdles]

Thank you😊

[@AkhtarIslamic]

Very nice explain thanks for sharing

[@Excelhurdles]

Thank you ji❤️

[@komalbid2390]

Thanks for making such videos. It was very easy to understand.🙏🙏

[@Excelhurdles]

Thank you ji😊 keep supporting

[@Utdr977]

Well explained.infomativ video share by you

[@Excelhurdles]

Thank you ji❤️

[@rajivkumarsingh597]

Very helpful in lucid language of hard topic. Thank sir.

[@ranjitamishra1098]

Wonderful sharing . You have explained everything so nicely . Thanks for sharing such a great video

[@Excelhurdles]

Thank you ji❤️

[@kiranmayekar2000]

Mind blowing Knowledge Salute To Your Information

[@Excelhurdles]

thank you ji❤️ happy learning. keep supporting

[@golapsakhatoon9498]

very helpful and useful video..every points you can explaine very easy ...it's reall very knowledgeable video..thanks for shearing

[@Excelhurdles]

Thank you ji❤️

[@Bhavin5696]

Mindblowing sir !!! thankyou so much for sharing valuable content

[@Excelhurdles]

Thank you ji😊 keep supporting

[@vijaybotkulwar8342]

I was finding it very difficult to reconcile. This video has made reconciliation easier for me. Really appreciate it and hoping you are gonna bring more videos.

[@Excelhurdles]

thank you for your positive feedback😊 and yes definitely i will bring more videos like this. if you have any suggestion or topic, feel free to comment❤️

[@baljeetsharma9874]

this vedio is very helpfuul,for reco. thanks😀

[@Excelhurdles]

happy learning❤️ keep supporting

[@shivamtraders9831]

Deep details with easy teach 👍

[@Excelhurdles]

thank you ji😊 keep supporting❤️

[@khajamoinuddin1324]

Appreciate, well explained bro. Hats-Off to you.

[@Excelhurdles]

Thank you ji😊 keep supporting

[@vishalshaw9387]

Really maza aa gya thanks for sharing

[@Excelhurdles]

Thank you ji❤️ happy learning

[@yhharishadyar7843]

Very usefull and informative video

[@Excelhurdles]

Thank you ji😊 keep supporting

[@Ansh-y1w1l]

Amazingly explained sir. 👏👏👏

[@Excelhurdles]

Thank you ji😊 keep supporting❤️

[@sandeepchauhaniuc9759]

Thank you sir your vedio very used fully 🙏

[@Excelhurdles]

Happy learning❤️

[@anayakhan5214]

Very informative video thanks for sharing

[@Excelhurdles]

Thank you ji❤️

[@techbysaddam6530]

Very helpful video sir thanks for sharing

[@Excelhurdles]

Thank you ji ❤️ support krte rhiye😊

[@sumanmukherjee4710]

Thanks for giving the workbook...

[@swatichavan.795]

Very helpful information thank you for sharing

[@Excelhurdles]

Thank you ji❤️ happy learning

[@AnishVerma-vw2kr]

Very big helpful video thanks brother 🎉❤

[@sethrollins1837]

Very nicely explain thanx for sharing

[@Excelhurdles]

Thank you ji❤️

[@yhharishadyar7843]

Thanks brother, I seen so many videos but your video is super

[@Excelhurdles]

Thank you❤️ keep supporting😊

[@rakshagangwar866]

Thanks a lot for practicesheet

[@Excelhurdles]

happy learning😊

[@rajadey1552]

Really u r knowledgeable person

[@Excelhurdles]

Thank you ji😊 happy learning❤️

[@NehaSingh-hn8kl]

No one have shared such a wonderful video. Thanks

[@Excelhurdles]

Thank you ji happy learning❤️

[@ManuSharmaCA]

You are wrong shefali mam has shared this 2 years ago and i am using it since then

[@AnishVerma-vw2kr]

Thank you so very much brother ❤❤

[@Excelhurdles]

keep supporting😊

[@SurajKumar-sk22]

Best video for reconciliation 🔥🔥

[@Excelhurdles]

Thank you ❤️ keep supporting

[@unnie786]

Thank you for easy learning 😊

[@neetassatvikrasoi]

Very informative n knowledgeable sharing as usual such a very useful content 👏 👍 thanks for sharing 👍

[@Excelhurdles]

Thank you ji❤️ happy learning

[@halimasultana9577]

Very interesting and informative video

[@Excelhurdles]

Thank you. ji happy learning

[@happylife2483]

Very well.......explain.....

[@Excelhurdles]

Thank you ji❤️

[@wizajit1]

VERY HELPFUL VIDEO. KUDOS TO U N YOUR TEAM :)

[@Excelhurdles]

Thank you ji❤️ happy learning😊

[@Technicalsrk01]

Very nice video sir

[@Excelhurdles]

Thank you ji❤️ happy learning

[@ayushshethO8]

Hi absolutely superb trick but one problem I am facing that when I am combining data of tally and portal to create pivot table after that pivot table is created but only tally data is shown only portal data is showing then please tell me what I can do so that both my tally and portal data can be shown in pivot table please help sir?? How to solve this problem????

[@sahanikhanam8677]

Waw wonderful explain

[@Excelhurdles]

Thank you ji happy learning❤️

[@manjamanju1572]

Thank you sir.. iam a new learner. This video helps me lots

[@Excelhurdles]

Glad to hear that. Happy learning ❤️😊

[@nikunj5656]

Aur bhi GST ke reco ki video upload kariye 🎉🎉🎉

[@rja2z886]

Really u well explained

[@Excelhurdles]

Thank you ji❤️

[@swapnilpachpande1176]

very very excellent sir

[@Excelhurdles]

Thank you ji❤️

[@dhairyakumar796]

Amazing information Thanks for sharing

[@Excelhurdles]

Thank you ji happy learning❤️

[@rohitprajapati02]

Very well explain good job 👍👍

[@Excelhurdles]

Thank you ji❤️

[@ritasingh2089]

Superb video Sir Thanks

[@Excelhurdles]

Thank you😊 happy learning

[@aazamshaikh2054]

bhai bhtt badiya smjhaya apne

[@Excelhurdles]

Thank you ji😊❤️

[@jayaramans3203]

Thank you sir. Very nice.

[@Excelhurdles]

Happy learning

[@sachinbishtofficial]

Very informative video.. thank you.

[@Excelhurdles]

Thank you ji❤️ happy learning😊

[@moazzamkhan3885]

This is magic bro...loved it

[@SharmaBunny-v8w]

Sir make more विडियोज on this topic

[@CAAMEYA80772]

Good Job 👍👍👍👍👍

[@Excelhurdles]

Thank you❤️ keep supporting

[@relaxverse1833]

Thank you so much sir 🙏

[@Excelhurdles]

you're welcome❤️ happy learning

[@rohitjanaskar4030]

Nice explanation

[@Excelhurdles]

Thank you ji❤️ keep supporting

[@meerasharma2310]

Nice 👍 good post.

[@Excelhurdles]

Thank you ji❤️

[@maahijaan5826]

Nice explain

[@Excelhurdles]

Thank you ji❤️

[@enjoyableplate3098]

Well done sharing

[@Excelhurdles]

Thank you ji❤️

[@avinash7747]

Wowww 🥳🥳🥳🥳

[@Excelhurdles]

Thank you ji😊

[@vikasdate1788]

Tally aur 2A data (invoices) rows uprr niche ho sakte hai. To difference nikalne ka aur missing invoices pata karne koi shortcut batate to achha rahta.

[@Excelhurdles]

pivot table me jo tally data and 2a data different rows me hote hai vo generally invoice no. me mismatch ki vjh se hi hota hai. agr me koi formula de bhi du tb bhi vo completely dono ko match nhi kr payega. kuch na kuch fir bhi difference reh jayega. iske liye apko GSTIN wise hi hr party ka reconcile krna pdega agr apko different rows me dono ka data dikh raha hai to.

[@mahaksharma8687]

Nyc sharing

[@Excelhurdles]

Thank you ji❤️

[@chhayasspecialrecipe4528]

Great sharing

[@Excelhurdles]

Thank you ji❤️

[@priyakumari7760]

Very well explained. Surely I'll try this

[@Excelhurdles]

Thank you ji❤️

[@Manishmkm100]

Keep on...

[@sujitscreativeworld5198]

Nice video.. well explanation

[@Excelhurdles]

Thank you ji❤️ happy learning

[@appesharma6443]

Very good explanation

[@Excelhurdles]

Thank you ji❤️

[@kaushikmojumder8457]

Excellent

[@Excelhurdles]

Thank you ji❤️

[@dularemiyen7256]

Thank you 💕

[@Excelhurdles]

Keep supporting❤️

[@Kannu1523.]

Very informative video brother

[@Excelhurdles]

Thank you ji❤️

[@khairulanamuthmani2095]

Thanks for sharing

[@TradingZone98]

Thank you brother ❤

[@Excelhurdles]

keep supporting😊❤️

[@vivektiwari9830]

Awesome vikas.

[@Excelhurdles]

Thank you sir😊❤️

[@shwetapandey7513]

Really really appreciate you for such a good Content..wish u the very best ❤️❤️

[@Excelhurdles]

Thank you for your feedback. i hope it was helpful for you. happy learning😊

[@ViveckThackar]

Thanks a Ton,🙏🙏🙏

[@SimplifyYourHomewithPriya]

Hey, thank you very much for the review. How do you add electric app to the tracks? (Real electric app)

[@entertenmasti7379]

It is a trend of half face pic

[@bankim0760]

Very good

[@Excelhurdles]

Thank you ji❤️ keep supporting

[@anaizamahtab]

Well explained...great sharing Keep it up 👍

[@Excelhurdles]

Thank you ji❤️

[@techieankiitxyz]

Well explained

[@Excelhurdles]

Thank you ji❤️

[@PrateekAgarwal-c2x]

you can do that more easily using finexo gstr2 reco tools which is also 100% free without any limits.

[@priyankasharma3566]

If I will give an excel sheet of gstr2b and purchase data from tally for the whole year..will you make like this and send it to me

[@BeSerious03]

Very nice video

[@Excelhurdles]

Thank you ji❤️ Happy learning

[@gauravsharma-qr4sm]

Ok very nice

[@Excelhurdles]

Thank you😊❤️

[@sivayyaduddu8385]

Exlent

[@Excelhurdles]

Thank you ji keep supporting❤️

[@SharmaBunny-v8w]

Waah

[@babulal1235]

sir very goods

[@Excelhurdles]

Thank you ji❤️ keep supporting

[@gagansaini3126]

Sir kaafi cases mein hota hai ki portal prr invoice ki wording alag hoti hai and books mein alag too uss case mein reco kaise bnaye..pivot se

[@Excelhurdles]

us case me apko jaha pr difference hai tally and gstr2a ke data me us sabhi entries ko manually check krna pdega. jarori hoto amount wise bhi check kr skte ho. esa to nhi hoga ki poora hi invoice no. different ho. kuch na kuchsimilar hota hi hai gstr2a and tally data ki entries me.

[@AnkitaKishore-b5n]

Sir mereko GSTR 2A aor GSTR 2B ka reco chahiye jisme mereko ye 2A me jo invoice hai vo kon se month k 2B me aaya hai kya iske liye kon shortcut trick hai agar hum pure year ke 2A aor 2B ko combine kar le to ye kaise pata karege

[@preetimourya1120]

Superb

[@Excelhurdles]

Thank you ji😊❤️

[@pv12pro12]

Bahut shahi

[@Excelhurdles]

Thank you ji❤️ Happy learning

[@sprrathorrudrapur769]

Thank you sir

[@Excelhurdles]

happy learning

[@Sk786..]

What about if there is slightly difference in invoice number..will pivot work same?

[@Excelhurdles]

no. only pivot will not be able to solve this problem. if you are well aware about partial match tricks of excel by using vlookup or other related function with a "*" then you can fix this issue. if you are not aware about this, and want me to make a video on it, i will make a dedicated video on this issue.

[@Sk786..]

@@Excelhurdles yes please, I would love it

[@saravanakumar8160]

@@Excelhurdles yes please make a separate video

[@raginivloggify]

Very well explained,nice

[@Excelhurdles]

Thank you ji❤️

[@nisthamusraf2653]

Sir jo tally data liya h purchase ka usme debit note include h kya?

[@Excelhurdles]

Apko excel sheet provide kr rkhi ha description me. ap download krke dekh skte hai jo bhi data liya hai mene.

[@baburaj6764]

Nice

[@Excelhurdles]

Thank you ji❤️