GSTR 2A RECONCILIATION WITH EXCEL IN 10 MINUTES VERY EASY, HOW TO RECONCILE PURCHASE WITH GSTR 2A,

♥watch this video to Reconcile GSTR 2A with purchase and GSTR 3B with Excel in 10 minutes
♥Visit www.legalsahayak.com to get paid services
or
BEST GST SOFTWARE-MY RECOMMENDATION IS CLEAR TAX
CLEARTAX OFFERS ARE LISTED BELOW:
♥BUY CLEARTAX GST SOFTWARE (SMEs ONLY): clr.tax/2E121q2
♥BUY CLEARTAX GST SOFTWARE (FOR PROFESSIONALS): clr.tax/2ufezsq
♥ ♥♥FOR CA GURU JI VIEWERS ONLY (UNIQUE COUPON CODE): CAGURUJI50
♥Cleartax Signup link: clr.tax/2Jj3U4s
♥GSTR 2A RECONCILIATION WITH PURCHASES AND GSTR 3B is very important every year and now most relevant due to latest change in GST that ITC can only be claimed if it is in GSTR 2A.
watch video to know more: • GST ITC लेने का नियम ब...
Important videos:
♥How to sign up for cleartax: • Best GST Software by C...
♥NOW NO NEED TO TAKE OTP FROM CLIENT: • Good News for GST Prof...
♥GSTR2A RECONCILIATION IN 5 MINTUES: • GSTR 2A RECONCILIATION...
♥HOW TO FILE GSTR 9 QUICKLY: • GSTR-9 FILING & RECONC...
WATCH THESE VIDEO TO FILE INCOME TAX RETURN YOURSELF:
♥FILE ITR1 YOURSELF: • HOW TO FILE INCOME TAX...
♥FILE ITR4 YOURSELF: • HOW TO FILE INCOME TAX...
Recommended items for your business & work:
♥ BUY Antivirus for your computers: amzn.to/2KPKrdl
♥BUY LAPTOPS: amzn.to/2f1WZgQ
♥BUY LATEST MOBILE PHONE: amzn.to/2Kup9lf
♥Mike for Audio recording: amzn.to/2xb0FVh
♥Camera Stand: amzn.to/2xNB9FE
#GSTR2A
#GSTR2ARECONCILIATION
#GSTR2ARECOINEXCEL
#GSTR2ARECONCILIATIONINEXCEL
#GST
#GSTR1
#GSTRETURNS
#HOWTORECONCILEGSTR2A
#WHATISGSTR2A
#RECONCILIATIONOFGSTR2A
#GSTR2AEXCEL
#HOWTORECONCILEPURCHASEWITHGSTR2A
#GSTR2ARECONCILIATIONLASTDATE
♥♥Follow Us♥♥
♥♥Facebook Page: / caguruji
♥♥Twitter: / cagurujii
♥♥Instagram: / caguruji
♥Our another channel
♥♥Right Info Corner: / rightinfocorner
Please ♥Like ♥ Share ♥Subscribe
#gstr2amatching
#Caguruji
#gst
#incometax
#TDS
#taxsaving
#itr
#dailynews
#currentaffairs
#GSTUPDATES
#incometaxupdates

[@CAGuruJi]

Join course on GSTR 2B reconciliation with adjustment enteries in books : studywudy.com/courses/gstr-2b-reconciliation-with-2a-and-books/

[@yrrao2009]

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.

[@manojsinha6280]

U explain very clearly....I m GST officer and watch ur videos to update me. Thnx. for ur effort

[@mukesh13th]

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

[@shyamallrounder]

Jitne video hai GST 2A reco ke youtube par, yah sabse best hai,

[@Hackers1198]

🤦🤦🤦🤦🤦

[@shyamallrounder]

@@Hackers1198 🥂🥂🥂🥂🥂

[@uniindia07]

आपका समझाने का तरीका बहुत ही आसान और सरल अल्फाजों में आप दूसरे व्यक्ति को समझाते हैं आपके पढ़ाने का तरीका भी गजब का है हर कोई आपकी इस सरल शैली को आसानी से समझ लेता है आशा करता हूं भविष्य में आप इसी तरह से अपने यूट्यूब सब्सक्राइब लोगों को इसी तरह का ज्ञान देकर हम सभी का मार्गदर्शन करते रहेंगे भविष्य में आप इससे भी अच्छी जानकारियां अपने फॉर लोगों तक पहुंचाते रहेंगे ताकि आपके द्वारा दिए गए ज्ञान से हम लोग अपनी उन्नति के पथ पर अग्रसर रहे आपका यह ज्ञान हमारे मार्गदर्शन को और भी बेहतर बनाएगा आपके ज्ञान के द्वारा हम जीएसटी के वह हर मुकाम हासिल कर पाएं जिस मुकाम पर आज आप हैं आपके ज्ञान के द्वारा या आपके द्वारा किए गए मार्गदर्शन के द्वारा हम भी एक दिन आपकी तरह ही लोगों को ज्ञान देकर उनका मार्गदर्शन करने की ख्वाहिश रखते हैं बहुत ही खूबसूरत तरीके से आप का पढ़ाने का अंदाज और आपके जो खूबसूरत अल्फाज हैं वह हर किसी को समझ में बहुत ही सरल तरीके से आप समझाते हैं पढ़ाते हैं जिससे कि हर व्यक्ति आसानी से उसको समझ लेता है यही वो आपकी खूबसूरत शायरी है जिसकी वजह से हम आपके मार्गदर्शन की हर पल हर दिन प्रतीक्षा करते हैं शुक्रिया madam ji

[@CAGuruJi]

wah

[@samratbanerjee9083]

This process is very helpful to reconcile with gstr2a with my books .

[@balramgarg1764]

very nice trick

[@modassirislam9288]

Very Effective and Less time consuming. Thanks Mam.

[@hitensugnani6231]

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

[@aditya26121996]

Brilliant idea to match 2A thank you so much for the knowledge

[@Yoganjali_24]

Thank u so much mam🙏😊🌺, God bless u mam🌈

[@dilipbhambhwani1551]

Very nicely explained,
which any body can understand
Thanks
God Bless you

[@cavyommmehta]

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.

[@advrathod414]

yes

[@dilipjain8852]

Any other options if our and portal invoices are different

[@suvarnakhaire980]

Yes very true.... .

[@SDLifestyles2024]

Yehi to chakkar hain. Pivot table is creating two lines. How to solve it sir / mam ?

[@ashwani_0551]

@Goods & Services Tax लिंक कहा है

[@vinayheda5941]

Thank u maam ...too good....initially i used VLOOKUP that works......but ur method is great .........best

[@dipgupta1986]

try this th-cam.com/video/61xPVGxk0aw/w-d-xo.html, its free and easiest

[@zameerchaush007]

very useful ma'am ❤💯😍

[@suhaskn4842]

SUHAS

[@saurabhjaiswal9288]

Thank you ma'am
This video is very helpful for CA Article

[@dirghangiamit9997]

great job, Thank you so much it help us so much . again lots of thuns

[@mukesh13th]

try gst-recon.com. its siple esay and defintly best at free of cost

[@deepakrawat1282]

Thnku mam ....I just wanna tell you that , I Love you(positive) ....thnku so much👍💜🙏🙏🙏

[@UraverageTSBplayer10]

you dont need a pivot table for this - using pivot table is overkill. It can be done in more simpler and effective way

[@m.naveenkumar2540]

Hi madam can you tell us some simply steps to reconcile the gstr2a

[@m.naveenkumar2540]

Can you do some video on that

[@UraverageTSBplayer10]

​@@m.naveenkumar2540 If you are willing to pay for excel consultancy - I will do a tutorial for same functionality

[@UraverageTSBplayer10]

@@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.

[@rameshkundnani5360]

​@@m.naveenkumar2540jai julelal

[@dhparmar2810]

Excellent

[@raajesharya]

Lovely, thank you. This was quite helpful.

[@rteducational58]

How to fill TDs return online with step by step and easy full video share

[@mohammedsaffan7784]

It's available in this channel only

[@aniketandranuchannel3493]

@@mohammedsaffan7784 oolLOOlkLOOolkoooolOOoOOoo

[@akshaysshenoy1314]

This video gives us a better way of understanding GST Input reconciliation.. Thank you ma'am.

[@toufik9714]

How to prepare self invoice in tally rep 9 pls let us know

[@hemendravakharia2502]

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 !!

[@innovativelearning8212]

For complicated and high volume reconciliations with multiple files, I have been using Foxpro programs since a long time....

[@SantoshKumar-sv1vx]

Respected mam what is meaning of not submitted. Appears in your excel file. Which you have deleted.
Please guide

[@danjan5583]

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

[@dipgupta1986]

try this th-cam.com/video/61xPVGxk0aw/w-d-xo.html, it's free and best tool
gst-recon.com/

[@dushyantsharma2749]

Very easy and simply method thnx mam

[@rituchopra274]

It's TDS of services

[@vikassonar3757]

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

[@vivekkumarmishra6955]

Thank u Very much Ma,am
For good step Gst 2A reconciliation according pivot tables

[@hamidakhatun4797]

great job... Thank you so much it help me a lot . again lots of thanks..

[@durgacharandas9681]

Good

[@92Nihar]

same procedure i am followed ... really its so easy....

[@deepagawde4903]

Thankyou🙏 God bless u for giving such knowledge

[@mohammadazhar364]

Madam,thank you so much.....NYC explanation......easy to reconciliation.......voice supperb...

[@pawan054]

Bahut acche se explain kiya mam aapne thank you so much 🤗

[@farhanrana8000]

Thanku mam i got my problem solution from this video really hepfull

[@mukesh13th]

th-cam.com/video/61xPVGxk0aw/w-d-xo.html

[@arvindparmar9041]

Very very helpful video in easy understanding thank you for this

[@angshumanbagh4686]

VERY VERY HELPFUL AND EASY METHOD AS PER MY

[@aadarshyadav1681]

Thank Mam your explanation was very nice . U make so easy to reconsilation

[@sireendoddamani5623]

Very nice video mam

[@sahilsharma-iu6wk]

Maine aaj aapki live video dekhi Jo aap parso live the. Aapki voice Bhut cute hai. .

[@kamleshbhaishah744]

VERY GOOD VDO ON GSTR 2A RECOCILATION 5* RATED DETAILS. THANKS & REGARDS

[@sunnysrivastav7586]

Thanks for sharing

[@mitulshah2033]

Awesome mam,u hve done very nice job....explanation by you is superb and very helpful

[@dhparmar2810]

Wow

[@rakeshparmar6635]

Nice explanation madam
Hop u continue to make such videos I will share with my friends

[@LalitSharma-wj5zb]

Thanks mam....Give Us to this knowledge😊

[@anilbhambishte1841]

Very good information. I am use this formula.

[@SunilKumar-hw7ik]

mam apki video very helpful hoti hai

[@pkkeyboardist]

Bye bye Love You Ji
I like your way of understanding........

[@dineshsuryavanshi6609]

Good information

[@Vairagi_108]

Very beautifully explained..... Mam

[@NishantSharma-vc3ox]

Bht jada help full hain

[@amitkumarjha6536]

Thank you so much video

[@lokeshthakur688]

Thanku guru ji 🙏🏻

[@bhoopendrakumar7871]

Very nice thanku

[@entertainmentadda7071]

THANKS MAM
GREAT WORK

[@mahesh50495]

Nice video

[@caharishreddy9768]

Great video.. Well explained and will save lot of time
Being Practicing CA I Following your channel is helping alot in Practice.

[@nancyverma3206]

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 👍👍

[@mukesh13th]

try gst-recon.com. its siple esay and defintly best at free of cost

[@monikabudhani2829]

Tough lga mujhe

[@jai6093]

Thank you Mam this video is very useful to us

[@ravishankarchimkod1229]

Nice work mam on GST 2A reconciliation, Gdnight.

[@gauravsharma1773]

Thnku so much ma'am... Really like your videos .. Thanx for your help

[@snehakasiraju218]

Awesome mam! Your explanation is so neat and simple.

[@KaileshHambireIJ-G-]

Nice video, please make efforts to explain in details of excell worksheet so that it becomes more easier to work with pivot tables

[@mohammadakbar8203]

Thanks Mam, Super

[@abhilashprasad8984]

Thank you very much

[@dhparmar2810]

Splendid

[@anythingtoeverything1870]

Apki voice bhut sweet hai

[@Vikas_Gupta1126]

nice i like this video
i want more videos like this gstr-3b, gstr1, or compression between GST3B and GST2A and GST1

[@jainshivi921]

Thank you mam it is really very helpful 😊👏

[@shawarjun719]

Mam, reconciliation between GSTR2A, GSTR2B with my books.. ek video iss par v banaiye..🙏🙏

[@akash_1502]

Best reco ever scene...👍👍

[@metubersiva8465]

Excel using excellent 👏👏🤗

[@karthikrajgopal8627]

thanks madam, very nice video.. keep it up..

[@k.balasubrahmaniannair3128]

very simple and nice way of presentation

[@vikashkumar-jl2jv]

thanku

[@cmautomation-q6j]

thanks mam , its valued

[@Curious0511]

Thank you Madam, it was very helpful

[@CAGuruJi]

Thank you

[@mukeshkumar-yk4kg]

Thanks for valuable information

[@rohitkasbe7883]

Good Thank You .... Very Easy 🚩🚩🚩

[@bavkarprerana16]

Thank you so much....its really good way

[@nikhilgarg3735]

Thanku Pooja Mam..Very Helpfull......

[@wonderfulshreya9709]

Thank you ma'am

[@RAMESHKUMAR-rs4en]

Thank you very much maam.. this video helped me a lot...

[@cashaludad6661]

Thanks.

[@ankitgoel9624]

Thanku mam this is really very useful 🎉

[@accountssharptanks3801]

THANKS MAM, APPRECIATE YOUR WORK AND HELPING US IN EDUCATING 2A RECO.

[@SunilKumar-hw7ik]

meri best wishes apke sath hai

[@ShriRangNatural]

Very nice information thanks 👍

[@sabarakumari3202]

Thank ypu .This was quite help ful.

[@shreebalajiaccounting5011]

Thanku So Much Mam Very Easy

[@shoaibrahman1480]

Very helpful vedio man thank you so much...

[@lokeshdandwani7309]

it will be easy to use vlook up formula instead of pivot table. It won't work if there is slight difference in invoice number.

[@VipulJain40]

Can u please share the link... How to use vlook up for gstr 2a

[@vyasautomationengineers7539]

Thanks for making this video

[@nileshkumaryadav1000]

Nice
Thank you ca guru ji

[@rajeshvisani3597]

It's very very helpful vedio

[@bikashrout7991]

thanks

[@rajeshvisani3597]

Very nice information.

[@rahulanandkar123]

Very Useful Mam