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
आपका समझाने का तरीका बहुत ही आसान और सरल अल्फाजों में आप दूसरे व्यक्ति को समझाते हैं आपके पढ़ाने का तरीका भी गजब का है हर कोई आपकी इस सरल शैली को आसानी से समझ लेता है आशा करता हूं भविष्य में आप इसी तरह से अपने यूट्यूब सब्सक्राइब लोगों को इसी तरह का ज्ञान देकर हम सभी का मार्गदर्शन करते रहेंगे भविष्य में आप इससे भी अच्छी जानकारियां अपने फॉर लोगों तक पहुंचाते रहेंगे ताकि आपके द्वारा दिए गए ज्ञान से हम लोग अपनी उन्नति के पथ पर अग्रसर रहे आपका यह ज्ञान हमारे मार्गदर्शन को और भी बेहतर बनाएगा आपके ज्ञान के द्वारा हम जीएसटी के वह हर मुकाम हासिल कर पाएं जिस मुकाम पर आज आप हैं आपके ज्ञान के द्वारा या आपके द्वारा किए गए मार्गदर्शन के द्वारा हम भी एक दिन आपकी तरह ही लोगों को ज्ञान देकर उनका मार्गदर्शन करने की ख्वाहिश रखते हैं बहुत ही खूबसूरत तरीके से आप का पढ़ाने का अंदाज और आपके जो खूबसूरत अल्फाज हैं वह हर किसी को समझ में बहुत ही सरल तरीके से आप समझाते हैं पढ़ाते हैं जिससे कि हर व्यक्ति आसानी से उसको समझ लेता है यही वो आपकी खूबसूरत शायरी है जिसकी वजह से हम आपके मार्गदर्शन की हर पल हर दिन प्रतीक्षा करते हैं शुक्रिया madam ji
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.
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
Nice work. But there is still a better way. Which makes it much easier. 1) Importing gstr2a to a dummy tally account & then exporting to excel. This will eliminate clubbing / deleting data from different sheets. 2) The next variation is : after appending book data to gstr data, I sort them by date & amount so book row falls below gstr row & setting them off with each other. 3) Now the pivot report gives just simple 2 reports. A) Report of bills in books but not in Gstr2a B) Other way around. 4) I do for multiple suppliers - all in one sheet. On pivot report just select name of supplier !!
It’s a great way to reconcile but tell me one thing, how is it possible to match jab bill to books m kch or sequence m hongey or portal m kch sequence m hongey, tab kesey hoga???
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
आपका समझाने का तरीका बहुत ही आसान और सरल अल्फाजों में आप दूसरे व्यक्ति को समझाते हैं आपके पढ़ाने का तरीका भी गजब का है हर कोई आपकी इस सरल शैली को आसानी से समझ लेता है आशा करता हूं भविष्य में आप इसी तरह से अपने यूट्यूब सब्सक्राइब लोगों को इसी तरह का ज्ञान देकर हम सभी का मार्गदर्शन करते रहेंगे भविष्य में आप इससे भी अच्छी जानकारियां अपने फॉर लोगों तक पहुंचाते रहेंगे ताकि आपके द्वारा दिए गए ज्ञान से हम लोग अपनी उन्नति के पथ पर अग्रसर रहे आपका यह ज्ञान हमारे मार्गदर्शन को और भी बेहतर बनाएगा आपके ज्ञान के द्वारा हम जीएसटी के वह हर मुकाम हासिल कर पाएं जिस मुकाम पर आज आप हैं आपके ज्ञान के द्वारा या आपके द्वारा किए गए मार्गदर्शन के द्वारा हम भी एक दिन आपकी तरह ही लोगों को ज्ञान देकर उनका मार्गदर्शन करने की ख्वाहिश रखते हैं बहुत ही खूबसूरत तरीके से आप का पढ़ाने का अंदाज और आपके जो खूबसूरत अल्फाज हैं वह हर किसी को समझ में बहुत ही सरल तरीके से आप समझाते हैं पढ़ाते हैं जिससे कि हर व्यक्ति आसानी से उसको समझ लेता है यही वो आपकी खूबसूरत शायरी है जिसकी वजह से हम आपके मार्गदर्शन की हर पल हर दिन प्रतीक्षा करते हैं शुक्रिया madam ji
wah
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.
Jitne video hai GST 2A reco ke youtube par, yah sabse best hai,
🤦🤦🤦🤦🤦
@@Hackers1198 🥂🥂🥂🥂🥂
This process is very helpful to reconcile with gstr2a with my books .
very nice trick
Very Effective and Less time consuming. Thanks Mam.
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. .
Thank u so much mam🙏😊🌺, God bless u mam🌈
Thank u maam ...too good....initially i used VLOOKUP that works......but ur method is great .........best
try this th-cam.com/video/61xPVGxk0aw/w-d-xo.html, its free and easiest
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 लिंक कहा है
Brilliant idea to match 2A thank you so much for the knowledge
very useful ma'am ❤💯😍
SUHAS
same procedure i am followed ... really its so easy....
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
Very nicely explained,
which any body can understand
Thanks
God Bless you
Lovely, thank you. This was quite helpful.
Thnku mam ....I just wanna tell you that , I Love you(positive) ....thnku 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
Bahut acche se explain kiya mam aapne thank you so much 🤗
This video gives us a better way of understanding GST Input reconciliation.. Thank you ma'am.
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
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
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 th-cam.com/video/61xPVGxk0aw/w-d-xo.html, it's free and best tool
gst-recon.com/
Nice work. But there is still a better way. Which makes it much easier.
1) Importing gstr2a to a dummy tally account & then exporting to excel. This will eliminate clubbing / deleting data from different sheets.
2) The next variation is : after appending book data to gstr data, I sort them by date & amount so book row falls below gstr row & setting them off with each other.
3) Now the pivot report gives just simple 2 reports. A) Report of bills in books but not in Gstr2a B) Other way around.
4) I do for multiple suppliers - all in one sheet. On pivot report just select name of supplier !!
For complicated and high volume reconciliations with multiple files, I have been using Foxpro programs since a long time....
How to prepare self invoice in tally rep 9 pls let us know
Really nyc Mam 👍👍
Actually I was finding the easiest way to reconcile nd after seeing this video i m so happy😊 I will be try this definitely 👍👍
try gst-recon.com. its siple esay and defintly best at free of cost
Tough lga mujhe
It's TDS of services
Nice explanation madam
Hop u continue to make such videos I will share with my friends
Thank you ma'am
This video is very helpful for CA Article
mam apki video very helpful hoti hai
Very good information. I am use this formula.
Very very helpful video in easy understanding thank you for this
Best reco ever scene...👍👍
Madam,thank you so much.....NYC explanation......easy to reconciliation.......voice supperb...
Very easy and simply method thnx mam
Thanks mam....Give Us to this knowledge😊
Very beautifully explained..... Mam
Thank Mam your explanation was very nice . U make so easy to reconsilation
Excel using excellent 👏👏🤗
Apki voice bhut sweet hai
Good Thank You .... Very Easy 🚩🚩🚩
Thanku mam i got my problem solution from this video really hepfull
th-cam.com/video/61xPVGxk0aw/w-d-xo.html
Great video.. Well explained and will save lot of time
Being Practicing CA I Following your channel is helping alot in Practice.
Awesome mam! Your explanation is so neat and simple.
very simple and nice way of presentation
Bye bye Love You Ji
I like your way of understanding........
VERY VERY HELPFUL AND EASY METHOD AS PER MY
Thank you Mam this video is very useful to us
VERY GOOD VDO ON GSTR 2A RECOCILATION 5* RATED DETAILS. THANKS & REGARDS
Thanku mam this is really very useful 🎉
Awesome mam,u hve done very nice job....explanation by you is superb and very helpful
Thank you Madam, it was very helpful
Thank you
Thankyou🙏 God bless u for giving such knowledge
great job... Thank you so much it help me a lot . again lots of thanks..
meri best wishes apke sath hai
Thank you mam it is really very helpful 😊👏
Thank you very much maam.. this video helped me a lot...
Didi u really grate👍👍
Use gst-recon.com. its superb cool. Just upload 2 files and it will compare automatically
Bht jada help full hain
Thankx mam..
Its help me.to.solve my 10000 & above invoices....
Hllo Bai lekin tally Wala data kaise lete h
Bhai digi tax India software hai hamara 2minute me reconciliation ho jayega. Manual me to galti bhi ho skti hai.
Thank you so much....its really good way
Thank ypu .This was quite help ful.
Thanku Pooja Mam..Very Helpfull......
Thank u Very much Ma,am
For good step Gst 2A reconciliation according pivot tables
Nice work mam on GST 2A reconciliation, Gdnight.
Too good Mam ❤❤❤❤
Thanku guru ji 🙏🏻
Thank you mam. Execellent Teaching.
To be very honest this trick is amazing to get rid from burdon......
Arif Ali bakwas Trick h
thankful for your video and i can easily do recincilatoon
Good work keep it up sister. 👍
Thanks for valuable information
THANKS MAM, APPRECIATE YOUR WORK AND HELPING US IN EDUCATING 2A RECO.
Thanks Mam, Super
Very nice video mam
this is very helpful . thank u .
Thanku So Much Mam Very Easy
The information you provide is very good, keep it up...
Thanks 😊😘
try this th-cam.com/video/61xPVGxk0aw/w-d-xo.html, u will forget everything
Thank you so much mam really nice video
Nice video, please make efforts to explain in details of excell worksheet so that it becomes more easier to work with pivot tables
Thanks mam helpful viedeo ✨👍🏻
10:01
i know ki aap mera reply nhi kroge but is jgh pr aap calculated field bhi to use kr skte the. i think vo jyada better hota.
THANKS MAM
GREAT WORK
Very nice information.
very nicely explained , Thank You So Much Mam !
Helpful💘💘💘💘
very useful vedio again app advanced per bhi vedio
Nice
Thank you ca guru ji
Best technique❤️
It’s a great way to reconcile but tell me one thing, how is it possible to match jab bill to books m kch or sequence m hongey or portal m kch sequence m hongey, tab kesey hoga???
It's very very helpful vedio
thanks madam, very nice video.. keep it up..
Tysm mam... most helpful video 👍
Excellent
Thanks for making this video
nice i like this video
i want more videos like this gstr-3b, gstr1, or compression between GST3B and GST2A and GST1
Thnku so much ma'am... Really like your videos .. Thanx for your help
Very very helpful maam.