GSTR-2A/2B With PURCHASE RECONCILIATION in Excel

[@S-mv6gk]

Ab tak ki sbse best reconciliation sheet....shandar👍

[@nisargj7524]

I deeply respect your skills and intellect that is a combination of Excel and the GST Law..... Thanks for making this easy.!!!

[@anuragshukla1193]

waah sir Maja aa gya video dekh kar its really very useful for beginners

[@camayurtaiilor3422]

Can’t believe that it’s easy to reconcile till the date. Thanks for such amazing video. 🙏

[@ABHISHEK-237]

But sir what about cgst , sgst qnd igst amout

[@cakapilsachdev]

You can also do with that

[@mohdyousuf3130]

sir ye is
date format ke bare m bataye please

[@poulomidevroy6265]

Thank you so much sir for this video. I have watched many other reconcilliation videos but yours is the best that i have come across. Very easily understandable

[@dirghangiamit9997]

Thank you so much, it is really so effective, simple , time saving with 1000% accuracy. I have tried many style but never before this. Thank you so much again.

[@cakapilsachdev]

You are welcome 😊

[@Gopal_Sarda]

​@@cakapilsachdevthanku for the video. One question if party name not every party, some party ka name different hain like slight variations hain toh phir kese match karwaye?

[@User30user]

Pivot table m month kaise aa gya

[@tedway]

Excellent Work Buddy
God Bless You
Keep your videos posted ❤🎉

[@vlogwithyatishkandhari6293]

Aapne sahi use Kiya pivot table ka. Thankyu for use of presenting pivot table like this

[@ShubhamPawar-t9y]

Your story telling skills are good , i loved explanation, keep going sir

[@mohdyousuf3130]

Sir first for thanks
This video
Aap reconciliation sabse best aour easy hai

[@kundanbachke1441]

Sir you have taught a very complex scene,
Don't worry I have shared your videos to many, and all have appreciated about your technique, thank you so much,
Keep posting such great educational content wish your Channel a very bright future in the field of finance and taxation.

[@cakapilsachdev]

Sure

[@preetichaudhary5566]

Amazing Explanation. Really, very helpful

[@carubinkumarsarkar]

Best explanation

[@Ntech-jv7qf]

Thank you CA kapil sir .
I used to waste 4 to 5 hour in matching . Now it takes around 1 hour or so

[@babulalgupta3472]

Nice and Easy reconciliation

[@pushkarvaishnav1838]

Best video for 2b reco

[@User30user]

Sir pivot table filed m ...row filter m... apka month kaise aara h mera to ni aara

[@abhishekverma-dx7hr]

Very helpful video sir thanks a lot

[@KUMAR-bu9dw]

Trillion plus likes from my side sir

[@vimalkharva9725]

Great technique for reco

[@girishraddy6049]

Really fantastic sir.

[@cakapilsachdev]

Many thanks

[@lampandlight4715]

Very useful
Thank you sir

[@ratanbanerjee9783]

Simply awesome you have done

[@cakapilsachdev]

Thanks

[@cakapilsachdev]

Thanks

[@abhijeetsalvi3843]

Kamaal he yaar sir
Tysm🙏💐

[@vishalktrade]

Great teaching

[@cakapilsachdev]

Thanks

[@dhparmar2810]

Excellent

[@zindagi1safar-loan486]

Nice Sir

[@nileshkudav9814]

Superb sir

[@BadalKumar-gn7zv]

Excellent sir ..........

[@rakshagangwar7470]

amazing thanks

[@pawanhedaoo9417]

Amazing Work Sir

[@kansingh5968]

Nice video

[@r.kvideo6147]

Best Reconciliation ever seen

[@thehonestfeelings3162]

Amazing video sir 😀😀
Thanks for sharing. It was much much efficient than using vlookup

[@cakapilsachdev]

Please share as much as you can

[@decorousbuddy8238]

Vlookup se kese hoti h reconciliation

[@HariBodduna]

Fantastic sir.

[@binodkharel8799]

good video

[@GauravYadav-tq7iy]

Very nice

[@bhardwaj7272]

U R Specialist

[@vinodkumaryadav2733]

Very helpful

[@VivekKumar-qs3oq]

Thank you so much sir 😮

[@dashingaadil]

Really awesome sir

[@cakapilsachdev]

Thanks

[@ExpertSafetySolutions]

Amazing Explanation. Thank you

[@dhaneshsen2035]

Method of teaching is very impressive. Keep going Kapil !!

[@cakapilsachdev]

Thanks

[@varnikavaidehisharma6199]

Thank you sir, it really work well

[@hardikvyas7080]

Sir, which shortcut key did you use for negative numbers to positive numbers in pivot table?

[@cakapilsachdev]

Multiple by -1 by using paste special

[@SEEMASEEMA-yb2fl]

Thank you So much Sir. Thank you Thank you Thankyou 🎉

[@ratnakarraut4496]

sir jab 2b or books reco karta hu ta koi koi party same coloumn me nehi aa raha he

[@KaranKumar-gx9kf]

Thanku sir ji vary

[@ajayvlogs6534]

Sir agar name party name mismatch ho to Invoice Mismatch ki tarah...

[@RahulRaj-yl7yy]

Sir apny 2A apny monthly download krky usko merge kra h ek sheet pr ?

[@bhagwaanhirananndani6308]

Sir, I am not able to get result where -1 x -1 formula. Grand total is adding figures, difference in 2A and books. Please explain.

[@vikashgarg1269]

Sir,book value nhi as rhi after copy pivot table,, iske liye kia kerna hai

[@prashanthps6395]

Thank you very much sir.
Please share 3B working video...

[@gunjankarna4663]

But what happens when party's name is different in book and different in 2b like some leedger were named like party's creditor and in 2b there's only a party's name

[@bhupeshkumarsharma2456]

2A & Books me Party name Differences hone per ye trik kam nhi karta hai. Books & 2B me Party ka nam Same Kaise kare ??

[@123messi10]

One thing we can do is if there are limited parties, just use text filter, “contains” and manually change the names as there must be some sort of resemblance(should take 10-15 mins) and use control+h.
if possible ask the party’s accountant to change their names on tally or any other softwares for the future.

[@Chandhrashekhar-cc9eu]

Well said

[@SatyendraVarma]

nicely explained.

[@cakapilsachdev]

Thanks

[@kafeelahmad6937]

Best Reconciliation sheet

[@cakapilsachdev]

Thanks

[@bijaykumarmishra7689]

Thank you sir it is a very necessary job

[@vikashgarg1269]

Thank you sir ho gyi reconcile

[@radhikasarowgi1682]

2nd pivot table mai group selection q nhi ho raha hai?

[@brijkishorkumar7696]

Amazing sir
But kya ham GST number ko base mankar reconcile kar sakte hai

[@cakapilsachdev]

Yes its better

[@mrhelltechnical]

sir mane gst le rakhi hai or mane kuch bhi buy or sell nahi kiya hai to me kaise gstr2a ko fill karu

[@rajendrabendre6635]

Great ! Thank you so much sir

[@vinodkumaryadav2733]

Thanks lot

[@vilomtiwari5548]

Thank you sir

[@ashishjindal52]

SIR JOB PIVORT TABLE USE KIYA 2B OR BOOKS K DONO BOOKS SAME SAME COLOMN ME NEHI AAA RAHA

[@cakapilsachdev]

Keep type in columns

[@supriyodutta6671]

Can any1 tell me why sir is using (-1) multiplication strategy in the 2A. ?

[@cakapilsachdev]

To make matching GSTN zero

[@rakhiverma2553]

Thanks sir

[@ganeshbamane4694]

what will do if there is difference in party name also pls suggest any trick for that also.

[@cakapilsachdev]

Use GSTN

[@ganeshbamane4694]

@@cakapilsachdev thanks sir very help full

[@saddada123]

Nice

[@tushardhingra29]

Sir please make more such videos

[@JASBIRSINGH-t8m]

THANX SIR BUT I HAVE ONE QUIERY I HAVE MORE DIFF SHEETS IN MY CLIENTS I CAN RECONCILE MANUALLY TEL ME HOW CAN ALL DIFF SHEETS VALUES DIRECTY TFR IN ONE EXCEL SHEET

[@jsrjhamitrawat]

Jai shree ram jai shree hanuman baba🌻🌻 🌹🌹🚩🚩

[@प्रवीणकुमार-ब2भ]

Sir thanks

[@ajju_joshi]

सर एक ऑडिट करना है कर दोगे..?

[@pranshu7283]

Hello Sir Ji your student from IT OC batch. Thanks!

[@cakapilsachdev]

Welcome

[@ajitthakur8836]

Thank you so much sir

[@thespiritualkanojia6573]

Are you taking classes online?

[@cakapilsachdev]

Not yet started

[@STUNMANmusic]

❤

[@ankurshah1072]

Jor dar sir

[@cakapilsachdev]

Please share all batchmates of ITT

[@ankurshah1072]

Send me vedio on mail

[@cakapilsachdev]

Please RUclips link it will help me to promote my channel

[@ankurshah1072]

@@cakapilsachdev send me filed

[@ankurshah1072]

Please

[@sachindutta1405]

Plz share Working sheet also

[@SEEMASEEMA-yb2fl]

Sir Mere Laptop pe Analyser nhi Show Ho Raha hai 😞

[@paritoshdhapke1992]

sir date year and month wise not able to do , pls help

[@MukundPinkuCentralComedy]

Sir debit note ka reconciliation kaise karenge

[@ganeshshrestha821]

Please suggest for gstr1 and 3b too...

[@cakapilsachdev]

Sure

[@VijayBhati-cc4bp]

Heading main to months nahi tha fir pivot main kaise aaya sir

[@ratnakarraut4496]

mujhe kya karna hoga kiunki kisi kisi me m/s karke laga he

[@Videhmiwal]

Use, replace Ctr+F
Enter word jo badalna h... Next row me blank hi tehne dena h.
And press entr

[@vakarali8765]

👍

[@RohitKumar-ev4yq]

Thanks 🙏

[@AMXRajatYT]

Pivot table mei months kaise aa gaye

[@Entertainment-he1gx]

Aur jo 2018_2020tak ka 2a download hi nahi ho raha hai to uska kya kiya jye

[@kavirajbarotji989]

Please esa hi video ek mahina ka banao sir jo books or 2b ma monthly karte hai

[@Kaamkicheezz]

Sir ye Ms Excel ka kaun sa version hai

[@cakapilsachdev]

Office 365

[@dineshacharya3781]

Thank you

[@RandomRaj2401]

Best ever

[@cakapilsachdev]

Thanks

[@VickyKhan-cc5hw]

BUT SIR HOW TO RECONCILE WITH GST NUMBER,

[@subhendu012]

Party's CR note figure how I calculate in 2B Or BOOKS MINUS FIGURE

[@indianbrute]

Your technique is absolutely fantastic, interesting and time saving. But I wish you slow down a bit while dictating and showing your jugglery with mouse & clicks. Simply put, you are too fast.

[@ajjujackson7138]

Thoda shlow smajhate to jyada mja aata

[@PrateekAgarwal-c2x]

you can do that more easily using finexo gstr2 reco tools which is also 100% free without any limits.