no need to do it in excel. below is the simple and best online tool for GSTR2A reconciliation. gst-recon.com. i use this one. you can easily find matched mismatched and can search by field and also group by column. you just need to upload 2 files. gstr2a downloaded as it is from gst.gov.in and purchase register exported from your accouting software..thats too free of cost
Mam, this one is a Fantastic & Useful Video. Earlier, though I had good knowledge in excel bu I never used FILTER function and PIVOT TABLES in excel. But after seeing your video, I am glad that I understood both of these things very well. You are a good teacher. thanks.
आपका समझाने का तरीका बहुत ही आसान और सरल अल्फाजों में आप दूसरे व्यक्ति को समझाते हैं आपके पढ़ाने का तरीका भी गजब का है हर कोई आपकी इस सरल शैली को आसानी से समझ लेता है आशा करता हूं भविष्य में आप इसी तरह से अपने यूट्यूब सब्सक्राइब लोगों को इसी तरह का ज्ञान देकर हम सभी का मार्गदर्शन करते रहेंगे भविष्य में आप इससे भी अच्छी जानकारियां अपने फॉर लोगों तक पहुंचाते रहेंगे ताकि आपके द्वारा दिए गए ज्ञान से हम लोग अपनी उन्नति के पथ पर अग्रसर रहे आपका यह ज्ञान हमारे मार्गदर्शन को और भी बेहतर बनाएगा आपके ज्ञान के द्वारा हम जीएसटी के वह हर मुकाम हासिल कर पाएं जिस मुकाम पर आज आप हैं आपके ज्ञान के द्वारा या आपके द्वारा किए गए मार्गदर्शन के द्वारा हम भी एक दिन आपकी तरह ही लोगों को ज्ञान देकर उनका मार्गदर्शन करने की ख्वाहिश रखते हैं बहुत ही खूबसूरत तरीके से आप का पढ़ाने का अंदाज और आपके जो खूबसूरत अल्फाज हैं वह हर किसी को समझ में बहुत ही सरल तरीके से आप समझाते हैं पढ़ाते हैं जिससे कि हर व्यक्ति आसानी से उसको समझ लेता है यही वो आपकी खूबसूरत शायरी है जिसकी वजह से हम आपके मार्गदर्शन की हर पल हर दिन प्रतीक्षा करते हैं शुक्रिया madam ji
Thanks a lot Helped very much Sir I hope you come up with different webinar sessions And also hope you tube session on 1) Transaction Audit 2) Forensic Audit
This method is only useful if invoice number entered by supplier and recipient are "exactly" same. Or else, Pivot Table will consider both invoices as different. For instance, if supplier recorded SVA/298/18-19 as invoice number and we record just 298 then Pivot will show SVA/298/18-19 and 298 both as different invoices although the fact is that both are same invoices. if invoice number is exactly matching then vlookup with exact match is the best option.
@@m.naveenkumar2540 I will drop a short hint if you need it - you could use index/match function to return "multiple"/grouped column values for given search value.
Video bahut accha tha lakin last me aap ne data add kar ke pivot table me refresh Karna bataya lekin range agar Jada hai to pivot table me kaise range thik Kare us par video banaye please madam kyu ki vo bhi important hai kyu ki data ka jyada ho sakta hai ise liye dhanyavad madam
Join course on GSTR 2B reconciliation with adjustment enteries in books : studywudy.com/courses/gstr-2b-reconciliation-with-2a-and-books/
U explain very clearly....I m GST officer and watch ur videos to update me. Thnx. for ur effort
no need to do it in excel. below is the simple and best online tool for GSTR2A reconciliation. gst-recon.com. i use this one. you can easily find matched mismatched and can search by field and also group by column. you just need to upload 2 files. gstr2a downloaded as it is from gst.gov.in and purchase register exported from your accouting software..thats too free of cost
Jitne video hai GST 2A reco ke youtube par, yah sabse best hai,
🤦🤦🤦🤦🤦
@@Hackers1198 🥂🥂🥂🥂🥂
Mam, this one is a Fantastic & Useful Video. Earlier, though I had good knowledge in excel bu I never used FILTER function and PIVOT TABLES in excel. But after seeing your video, I am glad that I understood both of these things very well. You are a good teacher. thanks.
Very Effective and Less time consuming. Thanks Mam.
This process is very helpful to reconcile with gstr2a with my books .
very nice trick
आपका समझाने का तरीका बहुत ही आसान और सरल अल्फाजों में आप दूसरे व्यक्ति को समझाते हैं आपके पढ़ाने का तरीका भी गजब का है हर कोई आपकी इस सरल शैली को आसानी से समझ लेता है आशा करता हूं भविष्य में आप इसी तरह से अपने यूट्यूब सब्सक्राइब लोगों को इसी तरह का ज्ञान देकर हम सभी का मार्गदर्शन करते रहेंगे भविष्य में आप इससे भी अच्छी जानकारियां अपने फॉर लोगों तक पहुंचाते रहेंगे ताकि आपके द्वारा दिए गए ज्ञान से हम लोग अपनी उन्नति के पथ पर अग्रसर रहे आपका यह ज्ञान हमारे मार्गदर्शन को और भी बेहतर बनाएगा आपके ज्ञान के द्वारा हम जीएसटी के वह हर मुकाम हासिल कर पाएं जिस मुकाम पर आज आप हैं आपके ज्ञान के द्वारा या आपके द्वारा किए गए मार्गदर्शन के द्वारा हम भी एक दिन आपकी तरह ही लोगों को ज्ञान देकर उनका मार्गदर्शन करने की ख्वाहिश रखते हैं बहुत ही खूबसूरत तरीके से आप का पढ़ाने का अंदाज और आपके जो खूबसूरत अल्फाज हैं वह हर किसी को समझ में बहुत ही सरल तरीके से आप समझाते हैं पढ़ाते हैं जिससे कि हर व्यक्ति आसानी से उसको समझ लेता है यही वो आपकी खूबसूरत शायरी है जिसकी वजह से हम आपके मार्गदर्शन की हर पल हर दिन प्रतीक्षा करते हैं शुक्रिया madam ji
wah
Thank u so much mam🙏😊🌺, God bless u mam🌈
same procedure i am followed ... really its so easy....
Thanks a lot
Helped very much
Sir I hope you come up with different webinar sessions
And also hope you tube session on
1) Transaction Audit
2) Forensic Audit
Maine aaj aapki live video dekhi Jo aap parso live the. Aapki voice Bhut cute hai. .
very useful ma'am ❤💯😍
SUHAS
Very easy and simply method thnx mam
Lovely, thank you. This was quite helpful.
Very beautifully explained..... Mam
This method is only useful if invoice number entered by supplier and recipient are "exactly" same. Or else, Pivot Table will consider both invoices as different.
For instance, if supplier recorded SVA/298/18-19 as invoice number and we record just 298 then Pivot will show SVA/298/18-19 and 298 both as different invoices although the fact is that both are same invoices.
if invoice number is exactly matching then vlookup with exact match is the best option.
yes
Any other options if our and portal invoices are different
Yes very true.... .
Yehi to chakkar hain. Pivot table is creating two lines. How to solve it sir / mam ?
@Goods & Services Tax लिंक कहा है
mam apki video very helpful hoti hai
great job, Thank you so much it help us so much . again lots of thuns
try gst-recon.com. its siple esay and defintly best at free of cost
Brilliant idea to match 2A thank you so much for the knowledge
you dont need a pivot table for this - using pivot table is overkill. It can be done in more simpler and effective way
Hi madam can you tell us some simply steps to reconcile the gstr2a
Can you do some video on that
@@m.naveenkumar2540 If you are willing to pay for excel consultancy - I will do a tutorial for same functionality
@@m.naveenkumar2540 I will drop a short hint if you need it - you could use index/match function to return "multiple"/grouped column values for given search value.
@@m.naveenkumar2540jai julelal
Bahut acche se explain kiya mam aapne thank you so much 🤗
How to fill TDs return online with step by step and easy full video share
It's available in this channel only
@@mohammedsaffan7784 oolLOOlkLOOolkoooolOOoOOoo
Best reco ever scene...👍👍
Respected mam what is meaning of not submitted. Appears in your excel file. Which you have deleted.
Please guide
Its means that those invoice's returns are not submitted by ur suppliers..
May be they'll submit those in the next month or later
try this ua-cam.com/video/61xPVGxk0aw/v-deo.html, it's free and best tool
gst-recon.com/
Very nicely explained,
which any body can understand
Thanks
God Bless you
How to prepare self invoice in tally rep 9 pls let us know
Thank u maam ...too good....initially i used VLOOKUP that works......but ur method is great .........best
try this ua-cam.com/video/61xPVGxk0aw/v-deo.html, its free and easiest
It's TDS of services
Bht jada help full hain
Very very helpful video in easy understanding thank you for this
Very good information. I am use this formula.
VERY VERY HELPFUL AND EASY METHOD AS PER MY
meri best wishes apke sath hai
Apki voice bhut sweet hai
Thanks mam....Give Us to this knowledge😊
very simple and nice way of presentation
Madam,thank you so much.....NYC explanation......easy to reconciliation.......voice supperb...
Excel using excellent 👏👏🤗
Bye bye Love You Ji
I like your way of understanding........
Very nice information.
It's very very helpful vedio
Thank you ma'am
This video is very helpful for CA Article
Good Thank You .... Very Easy 🚩🚩🚩
Thank you Mam this video is very useful to us
This video gives us a better way of understanding GST Input reconciliation.. Thank you ma'am.
Thanku Pooja Mam..Very Helpfull......
Nice explanation madam
Hop u continue to make such videos I will share with my friends
Thnku mam ....I just wanna tell you that , I Love you(positive) ....thnku so much👍💜🙏🙏🙏
great job... Thank you so much it help me a lot . again lots of thanks..
best video ....I want to give 5 star
Thanku mam this is really very useful 🎉
Thank you very much maam.. this video helped me a lot...
Very nice video mam
THANKS MAM
GREAT WORK
Thanks for valuable information
Nice
Thank you ca guru ji
good presentation
Thank ypu .This was quite help ful.
thanks mam , its valued
Thank you mam. Execellent Teaching.
Very very helpful maam.
Excellent
Thanku So Much Mam Very Easy
You r a genius
Thanks for sharing
Bahut bahut dhanyawad aapka ma'am
Thanks for making this video
Thank you Madam, it was very helpful
Thank you
Thanks Mam, Super
Thank you so much video
VERY GOOD VDO ON GSTR 2A RECOCILATION 5* RATED DETAILS. THANKS & REGARDS
Didi u really grate👍👍
Use gst-recon.com. its superb cool. Just upload 2 files and it will compare automatically
Too good Mam ❤❤❤❤
Nice Explain thanks madam
Thank you so much....its really good way
this is very helpful . thank u .
Very Useful Mam
Best video. Thanks
Thanks 😊😘
try this ua-cam.com/video/61xPVGxk0aw/v-deo.html, u will forget everything
Thanku guru ji 🙏🏻
Wow mam
Well explained
Very nice thanku
Thank you mam it is really very helpful 😊👏
Most important video mam
Very useful to all... Thank you..
Thanku mam i got my problem solution from this video really hepfull
ua-cam.com/video/61xPVGxk0aw/v-deo.html
Good information
Splendid
thankful for your video and i can easily do recincilatoon
Nyc and use full Video
Nice work mam on GST 2A reconciliation, Gdnight.
this is excellent mam
Very useful 👌ma'am.
Nice video madam. Keep it up
thanks madam, very nice video.. keep it up..
Soo nicely explained
Helpful💘💘💘💘
Awesome and logical creation.
Video bahut accha tha lakin last me aap ne data add kar ke pivot table me refresh Karna bataya lekin range agar Jada hai to pivot table me kaise range thik Kare us par video banaye please madam kyu ki vo bhi important hai kyu ki data ka jyada ho sakta hai ise liye dhanyavad madam
Good work keep it up sister. 👍