[@ankitagarwal9772]

this is helping me a lot in my office and saving a lot of time and very fast and informative pivot.

[@adilChai-WaLa]

Apke batane ka style totally different hai from others, sabse jiyada badhiya ye hai ke ap excel ki bhi knowledge dete ho, joki freshers ke lye kafi helpful hai. Finally maza aya dekhne me.
Mai bas aese hi click kiya tha dekhne ke lye ke ap reconciliation kese karte hai but dekhne me itna maza aaya ke dekhta hi chala gya sir ❤❤❤ . Thaks sir

[@caakashagarwal7951]

For 2A sheet for deleting Total n black rows you can also select column of rate and after aplying filter select and delete "blank" and"-" (i.e dash rates rows).

[@deepaksuryavanshi]

Absolutely right.

[@deepaksuryavanshi]

Sabse asaan yehi steps hain

[@praphullatarde8844]

अमित जी बहोत ही बढ़िया ज्ञान आपने 2A का दिया.
लास्ट वन वीक से मै सोच रहा था इसे कैसे match किया जाय. but In one hour you solved my problem And I thankful to you for you share your knowledge with all and your last sentence is too much beautifully you said ज्ञान बाटो ज्ञान देने से ज्ञान बढ़ता है. very nice and once again thanks. And lots of blessing. भगवान आपको बहोत कमीयाबी दे.

[@fintaxprime]

Thank you for you kind words and support 🙏🙏

[@suniljawale9075]

Sir You have capacity of give knowledge eazily to all level from simple to intelligent people...Great work

[@klugbots243]

Have you tried TriacleGST? Its free software www.klugbots.com/solutions
th-cam.com/video/s7HHVPGTjL8/w-d-xo.html

[@SUCCESSDINESH]

Sir ji, Very simple for filter.
Apply filter for I column. And apply filter to
- and blanks
Thn delete filtered thn go to I clmn filter and select all option.
After this unwanted blank rows and totals delered.

[@yogeshjoshi7691]

In large amount of data due to variation in Invoice number how it work? Cz to match all invoice number also time consuming work

[@fintaxprime]

Hi, if there is difference in invoice number then it will be very difficult to reconcile. I have provided solution of this in this video: th-cam.com/video/ocDalPOZ-EE/w-d-xo.html

[@prakashlakshman9418]

Thanks it's very useful shortcuts for everyone

[@veerabhadraraop3855]

Thank you ....AMIT JI...its very usefull for all accountants...

[@manisharajaurya1433]

superb sir...bhut kuch sikhne ko mila thanku so much sir.... ese hi helpful video bnate rho..

[@ahamed2syed213]

Awesome sir, love your teaching and techniques

[@DilipKumar-fp1xe]

Sir, your all videos are unique and easy to understand......... Right 👍

[@javedqureshi-gf8zs]

Sir,
This is correct but I am facing invoice number not match as per our record or as per 2A,
Then how we resolve. ( Sample We put Inv # 123 but party mention T-123/18-19 that was a big issue in huge data.
Can you please suggest how can resolve )

[@alfatexinds4662]

SO JAO

[@darshan5726]

@@alfatexinds4662 lmao

[@jaysavla]

Contact Prashant Gupta 9769599848 from Firmway Services (firmway.in/). Their software is excellent. it helps in such cases and supports huge data.

[@pannalalpatodia2429]

Irrespective of number of data and mistake in invoice no, gsting number or any other mistake, please visit www.match-lists.com. This software can reconcile 50,000 invoices in 8 seconds.

[@rkpal5012]

Bhot clear ans simple aur advance ke sath aao ne sikhaya h amit bhai thans a lot gst ke upar essi vedio and ecxel ke sath bnate rahi bhai thank u

[@manikanav1612]

mind blowing. appreciated. please keep doing great work.

[@mohaktextile3243]

sir u r great the way u teach is wonderful..i am really great ful mujhe aap mile....thanks a lot sir

[@GPavanKumarDJ]

Excellent Tech to save minutes of time thank you...

[@klugbots243]

Have you tried TriacleGST? Its free software www.klugbots.com/solutions
th-cam.com/video/s7HHVPGTjL8/w-d-xo.html

[@sadiqtm]

Shabash saab,apne gyan bata wo bhi bahut ache tareeke se...thanks

[@DS_012]

Awesome technique Sir, was searching for the same. Thank you.

[@thepakkumar9753144]

Awesome guru ji

[@giridharkommendala3305]

Thank you sir

[@syedaakeeb2912]

Very informative, superb tool

[@FaizanMobh020]

Sir aapki sample file hi share kr digie hum usi me data modified krlenge. Bahot aasan hoga hamare lie

[@fintaxprime]

Thank you for liking my Video. Due to heavy demand, and time constraint, I have uploaded utility on below link. Please down load the same from here.
www.dropbox.com/sh/wbmpah1r2fz8gpz/AADlAALR4xWKvfcC_2KoHUZ5a?dl=0

[@kameshwarpathak5600]

Fintax Prime

[@kameshwarpathak5600]

Sir please share excel file

[@jusabmalek6227]

please send me utility of gstr2a reconcilation

[@dknayak2019]

Its good but my pivot table date show double like as per our Record and as per gate 2a extra ...If any formula plz share

[@jyotindrasanghavi2793]

I have prepared RECO through your RECO Tool and it is ok but last column difference did not understand so pl do for the same your reply is awaiting . Thanks.

[@savya103]

Best thing I've come across, tried all the formulas this one is best and simple. Thanks for your time.

[@Aisudash]

App k samjhane k tarika bahut achha hai sir app k channel ko like aur subscribe aur bell icon bhi mera taraf se,bahut se pivot table vedio mene dekha mere samaj k bahar tha

[@fintaxprime]

Janke bahut acha laga ki apko Video and knowledge pasand ayi

[@nagasekarmn6984]

Explained nicely and understood the excel technics. It will solve 2A Reconciliations in short time. Thank you.

[@sallu6620]

Sir kindly suggest if there is any invoice s mismatch...how to tackle with that situation sir.plz guide me...

[@fintaxprime]

Hi, That is not possible through pivot table. I have provided solution of this issue through one of my automated utility. You can refer this video for the same.
th-cam.com/video/AAZCtG5C9QQ/w-d-xo.html

[@SunilSharma-bv7pg]

Dear Sir,
I seen your video and its good. But when I tried I face many issues such as 1) I downloaded data from tally, whose date format is fixed and not changing from format cell that is DD/MM/YYYY and date format from Govt portal is also fixed that is DD-MM-YYYY it is also not changing, What should I do?

[@SunilSharma-bv7pg]

I got the solution. I change Region format from Control Panel. But again issue raise is that Govt. Portal date format have General formatting but tally excel now have date formatting due to which same date and record showing one line up and down in pivot table. What to do?

[@vipinkumarindirecttaxation2519]

minus karne k liye formula pivot table ka disable kar sakte instead of manual formula

[@testing_applicationapps3495]

Video is good but i suggest you can use macro recording in cleaning govt data. So that next time data will clean automatically in just one click..

[@sanjibpanda5281]

Actually it is mind blowing working technique

[@Aisudash]

Thanks sir thank for your teaching

[@rajeshshah6758]

Bahut badiya laga.. I will try it at my work. Will save a lot of time. Thank you Sir.

[@sathyasai7525]

Can u please explain how can u manage as per our data
One invoice have a multiple gst rate 5,12,18 and 28
2A report showing vertical
And tally data showing horizontal

[@pushpinderanand21]

its a very very easy of doing reconciliation gr8 work boss

[@amitsaxena2326]

Sir apke according pivot table kaam kr rhi hai but ek choti c problem aa rahi hai wo ye ki invoice details double aa rahi hai jo diff to nahi hai magar alag alag hone ki wajah se difference aa rha hai....So Sir plz help me.....I'm highly obliged to you....

[@TaxFinance]

sir ap video recording kis software se karte hai...??

[@venkatasahithkancharla2472]

Brilliant technique sir

[@syedaakeeb2912]

Not like other paid versions, very best

[@mohitdhalwanshi7098]

Really helpful technique.....I want to extract two details from pivot
1. Invoices which are shown in 2A but not taken in books
2. Invoices which are not shown in 2A but taken in books
Then how can I extract these details from pivot .Can you please help on this?

[@fintaxprime]

If you are having any issue doing it manually, you can download automated utility from below link:
To download Trial Version please go to below link
www.instamojo.com/caamitjain1982/excel-utility-for-gstr-2a-reconciliation_tri/
To Buy full version at discounted price, please go to below link
www.instamojo.com/caamitjain1982/excel-utility-for-gstr-2a-reconciliation-wit/?discount=exlutl001

[@sudiptaukil9710]

Sir is it possible for same invoice no. but uploaded at a different date/month?

[@sunilgupta8576]

Amitji thanks for the presentation. GSTR2A data can be obtained from portal, but do we need to prepare data as per books in excel format as shown in presentation or it can be downloaded

[@fintaxprime]

Whatever format you want, same can be used. This format shown in this video is only suggestive.

[@revatabe7433]

Can this utility be useful if no of entries are around 1.5 lacks in a month

[@kanubhaipatel1218]

Very good video sir it is helpful in my gst itc work thank you sir

[@shivendratiwari5907]

Sir,
1.I would like to know,
If I download 2a for july month, but there was a bill for the month of july21 which was no filed by supplier in his gstr 1.
2.and this july month bill is filled by supplier in the September. 2021 in his gatr 1.
So, now I wanted to know that this invoice would be show in July month 2a Or September month 2a.?

[@ASHISHSHARMA-xl1qs]

Dear Sir,
You are done amazing things actually i am doing same things for our company but facing some issues due to lack of Technic, however now i doing with ease thanks for sharing such a nice things...i hope you will do help us to solve such problem....
Thanks a lot...May god bless you...

[@fintaxprime]

Thank you for liking my Video. Due to heavy demand, and time constraint, I have uploaded utility on below link. Please down load the same from here.
www.dropbox.com/sh/wbmpah1r2fz8gpz/AADlAALR4xWKvfcC_2KoHUZ5a?dl=0

[@krishnaprasad8086]

IN GST SITE DATA NOT PROPERLY TRANSFERRING INTO ITC AUTO-POPULATED IN GSTR2A, AND GSTR3B (CONSOLIDATED YEARLY SUMMARY) , THEN HOW CAN WE RECONCILE WITH TALLY BOOKS.

[@accountantrajatsharma2992]

Sir hmari sheet me jo CGST,SGST OR IGST wala amt h wo number of Count me a raha h jaise 1 -2 uski value nhi a rahi h plz help me

[@abhijithalder8674]

Yeah to only values ki difference mili but yeah situation ata hai ki books mai jo invoice number se data hai wohi same data 2A mai dusre patter se hai tab to woh work nahi karega,just like agar books mai invoice number hai 21-22/001, and wohi invoice 2a mai hai only 001 tab to woh data match karne mai bohot struggle karna hoga,waisa koi upay batao

[@karan151515]

But what about Invoices available in B2BA & CDNR section of GSTR2A ?

[@middleclasspeople8898]

YOUR ALL VIDEOS SUPER AND WE FORWARDED TO OUR FRIENDS & RELATIVES

[@nubhaskar3842]

In case of any mismatching in Invoice numbers how system will take care, kindly advise. Example Say Supplier Inv.002, uploaded in our records 2.

[@fintaxprime]

It is not possible through pivot. Invoice no should be same. Same has been resolved through automated utility for 2A reco. Same can be downloaded from below link:
www.bizwiz.co.in

[@nehalkadamyogi1632]

sir meri ek pareshani hai ki me pivot table bana raha hu par meri books ka record or 2a ka record party ka gst no.,name,invoce no, or value same row me nahi aa rahe hai upar niche alag se row me aa rha hai.

[@bbs200540]

It is very lebghty process. I have done this in half of your time and without using heavy tricks

[@fintaxprime]

Sir, I'm just trying to help people with the help of whatever knowledge I have. My knowledge might be limited. If you seriously have good idea, please share it with everyone so that all can get benefit out of it.

[@punitsharma7575]

Bhautik Shah so u can share with everyone bro

[@neeraj21750]

Thanks sir for this very useful video.
Thanks a lot.

[@AnandKumar-yi7tx]

As per our records and 2A records both bills show in separate Row not showing in same Row in pivot table.

[@prahladsinghal1821]

Thanks for teach us regarding 2A Reco. I will try it in my working. thanks

[@narsinga3755]

Agar invoice no. Mein formatting issue ho to, ye difference hi bataega...

[@pramodjani1125]

its very good and practical

[@shahjinal1387]

Thanks for sharing this technique 👍👍

[@priyashah1556]

Nice technique. But does it work if name of party or invoice number is exactly not same?

[@fintaxprime]

It will not work if party name or invoice no is not exactly matching. I have provided solution of this in this video: th-cam.com/video/AAZCtG5C9QQ/w-d-xo.html

[@priyapandey4368]

Sir ek hi invoice 2 bar kyu dikh raha hai means gstr ka alag and purchase ka alag please comment

[@vaibhavvispute1794]

Sir bill no same hai but as per 2A record and our record alag alag dikha raha hai
Means difference nil nahi hot

[@nikitapisal4954]

Arre sir par woh 'data as per our records' maintain karna padta hai na.. tally se waise vertical report nahi export hota koi.. agar hota hai toh give me some guidance plz.

[@vishalchauhan2907]

Bro kahi bar party name match ni hota koi formula hoga jisse ek bar me replace ho jye plz reply

[@crowntaxlearnexcel9086]

But agar dono sheets ka data aage peche ho to kia karen Example k hisab Invoice number match na hun aage peche hun to kia pehle data ko same karen.

[@gobindapaul2596]

Very useful trick.. But I got an issue with invoice date. Two similar dates are showing in my report in respect of a same invoice in different rows consecutively. One for GSTR 2A data and another one for my data.. They are not appearing in same row under the above said columns. Plz help me to sort out this...

[@kprathamesh753]

Awesome Video,help to us
Thank you sir

[@manjiri09]

Excel sheets are not always this simple. In our case I got different registered name with us (as per bill)and different as per Govt records. Any solution in this case?

[@srinuwirtings]

For that we have solution please contact us immediately. For all tax solutions.
Saral gst software is the best solution for your kind of problem. Contact us on
9160877733

[@baburamgour2417]

GSTR 2A reconciliation karne par Pivot Table me as per GSTR2A me party ka name (Legal) h or as per our books me party ka name (Trade Name) to solution kya h

[@gbbhavsar]

Sir, I am facing with mismatch invoice no for GST Reco. I have mention Inv no. 34357/06.07.18 in our record, but as per GST portal Inv no. is IGJ0KHDBX0034357, so GST sheet is not reconcile this invoice, so what is solution for this ???

[@shivamfinace]

I use this trick everyday. Thought this video was about something of more advanced level.

[@wayangankaranchosuyog1640]

GSTR2 aur GSTR 2A usme reconciliation hoga wo mujhe (jo ITC me ne claim kiya nahi hai) mujhe Sep 2018 me lena hai, jo ITC invoice gstr 2 accept kar filed kar k lene hai ya mujhe sep 18 ka Gstr3B file karne k time me bas cgst /sgst me pending ITC dal k credit lena hai

[@sasidharank7953]

An Excellent and complete tutorial
But how do treat the nonsubmitted category. Thanks and regards

[@rdpangare09]

Thank you so much sir...This is really helpful. 😊

[@fintaxprime]

Glad to know that :)

[@anishkhatri7051]

Very useful sir...i will try. Super technique thnk u sir

[@sophiemookerji4590]

Very good - excellent help for excel and 2A. Do you have a method for downloading multiple months of 2A at one time?

[@fintaxprime]

Working on the same. Will share the method soon on my channel.

[@casanaykumarsangal7259]

simply great and helping us a lot........

[@shyamallrounder]

Jo voucher ham journal mai book karte hai wo Tally 2a mai show nahi ho raha hai
Yah kaise hoga

[@viralvideoyoutube21]

wow thank you so much sir aapne aaj bohat ache tarike se samjhya

[@dineshnawathe700]

Sir but last year ka ITC jo April to sep me claim kiya hai...vo kaise pata kre ? Vo 2A me nahi milega ...because vo last year ke 2A me hai na

[@damudamodar7755]

Sir in pivot table invoice details are shown in twice how to rectify it.

[@janmahmadkhatri5241]

GOOD JOB,WAY OF TEACHING SIMPLE AND INTERESTING,CARRYON WITH THIS EFFORTS, GGOD LUCK. WHAT TO DO WITH MULTIPLE TAX RATE SCENARIO SIR IN ONE BILL ?

[@fintaxprime]

As per my opinion invoice level reconciliation is sufficient. If you need rate level also, you can add one column of rate in pivot.

[@neeraj21750]

सर मैं इसको ऑफिस में लगाकर देखा तो इसमें इतनी प्रॉब्लम आ रही हैं कि ये आपकी मास्टर शीट कामयाब नही है।
कारण ये है कि यदि टैली और पोर्टल में नाम थोड़ा भी अंतर है जैसे caps ओर small का diffrence या PVT LTD का अंतर तो अलग अलग नाम दिखा दे रही है। यदि DATE में फॉर्मेट में अंतर है जो कि स्वभाविक है तब भी बुक अलग और साइट अलग दिखा रही है।

[@mybook9305]

dear sir, I put data as per your directions, but the data for our records and as per 2a shows in different rows on the pivot table, what to do?

[@shivajijadhav8805]

Suppose there are different format of invoice no in Books and potal then what to do?

[@rrangole]

Bade kaam ki hai. Dhanyawad.

[@JAISHREERAM81275]

Thanks But can u confirm me that if as per 2a record there is proprietor name e. g. Raman kumar but as per our record name is of his firm that is v.k. enterprise then can this pivot table is useful or it will show both as different parties

[@mayurgadiya1395]

Data in pivot table for same bill no is not coming in same line. It showing me in 2 diff line as per pur reg and as per 2a

[@maheshkumar1050]

बहुत बढ़िया सर । धन्यवाद । books और 2A में अगर बिल no में थोड़ा फर्क है और amount tallied है तो यह pivot table कैसे काम करेगा ?

[@fintaxprime]

Pivot will not work if there is even minor difference. I have provided solution of this issue in this video
th-cam.com/video/AAZCtG5C9QQ/w-d-xo.html

[@balukishan2488]

Nice and excellent sir, i will try

[@sharmadarshan63]

superb technique sir.. really appreciate .. i will wait for next

[@maksudaalam4899]

Amazing video sir. Sir can u tell me what is semi colon key?

[@miteshgandhi1629]

Sir
I am a regular registered person. I have made 3 taxable purchases from same supplier during the month of October.
I have received proper Tax Invoice bearing my GSTIN no etc for these purchases.
However this is not reflecting in my GSTR 2A.
When i contacted my supplier, he told me there is no error from his end and he has uploaded these invoices in his GSTR 1.
He also took a screen shot of his B2B invoices and my invoices were there among his uploaded and processed invoices.
He also has filed his Gstr 1 for the Oct month.
What should i do now?
Please reply, thank you for your time.

[@jitenderkumaryadav642]

Excellent work

[@birjeshchaturvedi5295]

Very informative and usable. Thanks for sharing.

[@mohanengineeringworks3553]

sir invoice number match nhi ho raha 00 ke waja se aur aapke to 5 row show ho rahe me sab ke 2 ho rahe ahi

[@tanyaconstruction1004]

in my sheet invoice number i snot shorting it is giving both 2a and my book how can i solv this

[@2932DC]

Sir, GSTR-2A me aur jo hamare pass record hai. Usme Agar invoice no. Ka format me difference ho, Kya ye pivot table apply kerga?
for example:-
Invoice no.
GSTR-2A - 024
Our records - GST-024

[@fintaxprime]

Thank you for liking my Video. Pivot can not reconcile this case but I have prepared automated utility to reconcile such cases. watch my this video and see how to use this utility th-cam.com/video/vnTqvKV8isA/w-d-xo.html
Link to download the utility is given in description of this video. Same can be download from here also.
www.dropbox.com/sh/wbmpah1r2fz8gpz/AADlAALR4xWKvfcC_2KoHUZ5a?dl=0

[@shaikhnawaz3031]

Nice technique dear

[@animeshbachar4830]

Sir i am facing a problem regarding invoice date. In the pivot table it is showing same date two times in the following column one for as per our records and another for as per gst . pls give me some suggestion.

[@fintaxprime]

Could you please check date format in both the sheets. there must be some difference in it.