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
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 !!
Sir koi job krte hue Apna name se koi Agency ya business farm kholne ke liya ki apne name se Gst or current account banane se koi prblm honewala he? Q ki job me bhi or gst main bhi same pan number e show hoga to kiya koi prblm ho saka he infture me koi bhi tax le ke?
Very usefull video madam .. But one more question is that last when you set formula ams enter 0 shows ans then you copied and drag it to 6 colomn . So how to know no of colomn required ??
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
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.
आपका समझाने का तरीका बहुत ही आसान और सरल अल्फाजों में आप दूसरे व्यक्ति को समझाते हैं आपके पढ़ाने का तरीका भी गजब का है हर कोई आपकी इस सरल शैली को आसानी से समझ लेता है आशा करता हूं भविष्य में आप इसी तरह से अपने यूट्यूब सब्सक्राइब लोगों को इसी तरह का ज्ञान देकर हम सभी का मार्गदर्शन करते रहेंगे भविष्य में आप इससे भी अच्छी जानकारियां अपने फॉर लोगों तक पहुंचाते रहेंगे ताकि आपके द्वारा दिए गए ज्ञान से हम लोग अपनी उन्नति के पथ पर अग्रसर रहे आपका यह ज्ञान हमारे मार्गदर्शन को और भी बेहतर बनाएगा आपके ज्ञान के द्वारा हम जीएसटी के वह हर मुकाम हासिल कर पाएं जिस मुकाम पर आज आप हैं आपके ज्ञान के द्वारा या आपके द्वारा किए गए मार्गदर्शन के द्वारा हम भी एक दिन आपकी तरह ही लोगों को ज्ञान देकर उनका मार्गदर्शन करने की ख्वाहिश रखते हैं बहुत ही खूबसूरत तरीके से आप का पढ़ाने का अंदाज और आपके जो खूबसूरत अल्फाज हैं वह हर किसी को समझ में बहुत ही सरल तरीके से आप समझाते हैं पढ़ाते हैं जिससे कि हर व्यक्ति आसानी से उसको समझ लेता है यही वो आपकी खूबसूरत शायरी है जिसकी वजह से हम आपके मार्गदर्शन की हर पल हर दिन प्रतीक्षा करते हैं शुक्रिया madam ji
wah
This process is very helpful to reconcile with gstr2a with my books .
very nice trick
Very Effective and Less time consuming. Thanks Mam.
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 ruclips.net/video/61xPVGxk0aw/видео.html, its free and easiest
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
Bahut acche se explain kiya mam aapne thank you so much 🤗
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 लिंक कहा है
Maine aaj aapki live video dekhi Jo aap parso live the. Aapki voice Bhut cute hai. .
very useful ma'am ❤💯😍
SUHAS
Brilliant idea to match 2A thank you so much for the knowledge
Very nicely explained,
which any body can understand
Thanks
God Bless you
Lovely, thank you. This was quite helpful.
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
Best reco ever scene...👍👍
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
Thnku mam ....I just wanna tell you that , I Love you(positive) ....thnku so much👍💜🙏🙏🙏
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 ruclips.net/video/61xPVGxk0aw/видео.html, it's free and best tool
gst-recon.com/
This video gives us a better way of understanding GST Input reconciliation.. Thank you ma'am.
How to fill TDs return online with step by step and easy full video share
It's available in this channel only
@@mohammedsaffan7784 oolLOOlkLOOolkoooolOOoOOoo
Nice vdo
How to prepare self invoice in tally rep 9 pls let us know
mam apki video very helpful hoti hai
It's TDS of services
Very easy and simply method thnx mam
Very very helpful video in easy understanding thank you for this
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
Very beautifully explained..... Mam
Thanks mam....Give Us to this knowledge😊
meri best wishes apke sath hai
Bht jada help full hain
Very good information. I am use this formula.
Thank you ma'am
This video is very helpful for CA Article
VERY VERY HELPFUL AND EASY METHOD AS PER MY
Good Thank You .... Very Easy 🚩🚩🚩
Excel using excellent 👏👏🤗
Splendid
Madam,thank you so much.....NYC explanation......easy to reconciliation.......voice supperb...
Nice explanation madam
Hop u continue to make such videos I will share with my friends
Apki voice bhut sweet hai
great job... Thank you so much it help me a lot . again lots of thanks..
Thanks 😊😘
try this ruclips.net/video/61xPVGxk0aw/видео.html, u will forget everything
Bye bye Love You Ji
I like your way of understanding........
Mam maine abhi practice Krna chalu kiya hai pura sikhne mai kitna time lagega account work mai ..pura.
Depends on your knowledge
Awesome mam,u hve done very nice job....explanation by you is superb and very helpful
Thank you Mam this video is very useful to us
Thank you Madam, it was very helpful
Thank you
Excellent
Thanku mam this is really very useful 🎉
Very nice video mam
Thank you mam it is really very helpful 😊👏
Thanks Mam, Super
Helpful💘💘💘💘
Thank you very much maam.. this video helped me a lot...
very simple and nice way of presentation
Too good Mam ❤❤❤❤
Nice video madam. Keep it up
Thanku mam i got my problem solution from this video really hepfull
ruclips.net/video/61xPVGxk0aw/видео.html
Didi u really grate👍👍
Use gst-recon.com. its superb cool. Just upload 2 files and it will compare automatically
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
Welldone
Very nice information.
Mam mera ek questions hai ki hame electronic credit Ledger tally karna jaruri hai ya apna GSST2A check kiya to chalega pls answer dijiye
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....
best video ....I want to give 5 star
good presentation
Superb ji...
Thanku guru ji 🙏🏻
Sir koi job krte hue
Apna name se koi Agency ya business farm kholne ke liya ki apne name se Gst or current account banane se koi prblm honewala he?
Q ki job me bhi or gst main bhi same pan number e show hoga to kiya koi prblm ho saka he infture me koi bhi tax le ke?
Thankyou🙏 God bless u for giving such knowledge
Thank ypu .This was quite help ful.
Thanku Pooja Mam..Very Helpfull......
Thank you so much....its really good way
Good information
THANKS MAM
GREAT WORK
Very helpful vedio man thank you so much...
VERY GOOD VDO ON GSTR 2A RECOCILATION 5* RATED DETAILS. THANKS & REGARDS
Very Useful Mam
Good work keep it up sister. 👍
Very usefull video madam ..
But one more question is that last when you set formula ams enter 0 shows ans then you copied and drag it to 6 colomn . So how to know no of colomn required ??
How many *
Pls reply
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???
thanks mam , its valued
thankful for your video and i can easily do recincilatoon
Thanku So Much Mam Very Easy
It's very very helpful vedio
Nice
Thank you ca guru ji
Hello Mam
I wants to know whether we raise multiple invoice in same day in same state or required E way bill
Pls. suggest me soon
mam kya hm miss invoice ko usi mnth m add n kr skte h bcz gstr 2 to abhi gyi n h to hm use usi mnth m B to le skte h gstr 3b s koi frk pdega n.
this is very helpful . thank u .
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.
Nice work mam on GST 2A reconciliation, Gdnight.
Thanks for valuable information
Thanku so much mam,, I really wants this now. Thanks
Awesome mam! Your explanation is so neat and simple.
Nice video mam