Thank you sir this is amazing trick Instead of vba you used power query this is amazing I had ever seen before with this now I has click the bell icon for new updates Thank you once again
Very Well Done CA Kapil Sir. I had a format of Vlookup. But there was one problem that I suppose to findout the Mismatch Invoice Mannualy even though I got the mismatch in partywise. Your effort will save most of the Professionals' valuable time. Thank you so much sir shareing the knowledge & the Excel Sheet as well. You have done the fabulous job Sir. Please share the file.
Superb... Very nicely explained. Invoice Number is main cause of the problem. How to deal with this ? Please explain. Thank you so much. Please give download link.
I got following error in DATE field. UNABLE TO PARSE INPUT PROVIDED AS DATE FIELD. While changing format to DATE, it gives above error in power query. I took data from 2B. By default DATE is in TEXT format. I have tried using =Datevalue() formula to convert it beforehand but it is a bit time consuming. If you could provide solution for DATE field, it would be of great help.
Thank you so much sit. I didn't know about this trick. It is really so amazing. Thank you...
Thank you sir this is amazing trick Instead of vba you used power query this is amazing I had ever seen before with this now I has click the bell icon for new updates Thank you once again
Time saving and skill developing method so far i have seen. Thank you so much Sir for making such insightful videos for us.
Thanks stay tune for more updates
Super se bhi upar
Very Well Done CA Kapil Sir. I had a format of Vlookup. But there was one problem that I suppose to findout the Mismatch Invoice Mannualy even though I got the mismatch in partywise. Your effort will save most of the Professionals' valuable time. Thank you so much sir shareing the knowledge & the Excel Sheet as well. You have done the fabulous job Sir. Please share the file.
Will upload
WHEN?
Sir
Very Good Information Very Useful for us.
Thank you we love your channel.
Amazing Reco - Never seen such a type of reco
Thank you so much for this videos sir. It is practically very useful and efficient.
Hats off to you sir !!
You taught us such a wonderful way to reco
Sir thanks a lot pls don't stop upload next one .. if any invoice number change that kind sir.
ahaaa , great video 😶 I'm going to share this with my principal
Appreciated, Nice Explanation.
VERY USEFUL & TIME SAVING RECONCILATION VIDEO.KINDLY UPLOAD THE EXCEL FILE
Send your mail id
@@cakapilsachdev
Air do u got excel file can share with me
@@cakapilsachdev hello sir
Very good video sir👌
Great efforts sir🙌🙌
Thans
Very helpful - Thank You Sir
great work bro thanks
Superb...
Very nicely explained.
Invoice Number is main cause of the problem. How to deal with this ?
Please explain.
Thank you so much.
Please give download link.
Will explain in next video
Very Good. Thank You.
Sir I liked u❤
Wow very nice
GRT!!! Very useful and time-saving but where is the practice file?
Very useful sir
So beautiful
I have Microsoft Excel 2007 pls suggest me what can I do. Work like this
Great efforts sir
Thanks
Sir if the invoice number mismatch between 2b and books then it recognize by this process.another qs is from your reco sheet how much itc i can claim.
Sir I have prepared the data
But kindly guide how to summarise data where we can find invoice number mismatch between books amd 2B
Hello, thats great please share excel query
Nice video thanks sir.
Sir Thanks for your video. Please share Practice sheet
But sir, where is the excel file for download
Invoice number mismatch ko power query se kaise thik kre iske upar ek video banaiye sir.
Make more videos sir
great video sir... Sir can make video how to prepare schedule 3 balancesheet using advanced tools in excel
Sure
@@cakapilsachdev sir there is one problem .. When we put invoice and party names it make two rows ...uppar nichee... Barabar nhi aate invoices..
BEST TOOL GREAT EFFORTS
PLZ SEND THE TOOL
You can also create it’s very easy just prepare it by watching video side by side
Sir What if there is some mismatch in INVOICE NO ??
please make video on clause 44 - tax audit reporting
sir where is the second video for tackling invoice number issue
super sir can you share file
Fabulous
Thanks
Thank you sir
👍
Bhai apka pass ha Excel sheet
How to make this same sheet with invoice no. Of Gstr2a and Books are different
Use fussy lookup
is this method is useful for invoice number and invoice date not equal in books and 2b.
For that I have other video
Great Sir
But If My Invoice Same But In Bookes invoice No 252 but On Portal invoice No is FPPL/22-23/252 Hiw can handle this type problem
Check my other video that has solution
sir gstr 2b merge nhi hori h ek saat saari sheet wo btao na plzz
Call me I will explain
SIR PLZ MAKE SOME NEW VIDEOS REGARDING ACCOUNTING
HELLO SIR
PLEASE ALSO MAKE VIDEO TO RECONCILE GSTR9 & GSTR 9C
Ok
very best gstr2 reconciliation by excel please share the file
I got following error in DATE field.
UNABLE TO PARSE INPUT PROVIDED AS DATE FIELD.
While changing format to DATE, it gives above error in power query.
I took data from 2B. By default DATE is in TEXT format.
I have tried using =Datevalue() formula to convert it beforehand but it is a bit time consuming.
If you could provide solution for DATE field, it would be of great help.
Please connect me after 17th we will discuss and resolve
To good
But sir jab invoice number main format alag aye tab kese match hoga
No. For that there is another method. I will explain in next video
@@cakapilsachdev muze invoice number main problem ari hai
Will let you know in next video
Too good, thanks
Can you share the excel file pls
Yes
Do you got the excel file can you send with me
Plz sir send me Excel file
Sir please upload Excel sheet
SIR I AM NOT ABLE TO THAT
FROM POWER QUERY
Thank You Sir very time saving Can we use fuzzymatch in invoice no in (Left Anti & Right Anti) for approx match
Yes
Sir, from where I can download the excel file
You can prepare by watching my video
After merging didn't get any data
Call me will explain
Sir, can i have this excel file
Practise file ,how to get
IF U HAVE THE VIDEO OF GSTR-9 & 9C PLEASE SEND ME THE LINK FOR THE SAME.
फाईल कहां है बोलकर देते नहीं हो क्यों !
Sir kaha hai power query sir aao bol rhe hai mai apko send kar dunga
Sir, please share the file
Please share excel file!
sir plz share debit note and credit note
Sir please share Exal file
Sir Pls upload Excel
Already uploaded
If mismatch in Invoice number,
How will do reconcile
Next video
@@cakapilsachdev any vedio for Mismatch Invoice Problem when Invoice Same but formate Not Same as per Portal
GSTR 2B se reconciliation nhi kiya??
plz share file 2AReco
Sir Please send Excel file format
If Data Have Credit Note Debit Note
Sir excel sheet download kaise kre ye
You can prepare. It’s very easy
Could you please get link to download the file?
You can easily prepare by watching video side by side
@@cakapilsachdev I don't have the same data set. Why not post M code if you don't want to share the file?
Can you share the link of excel file
You can easily prepare by watching videos
sir plz send excel file sir plz
Too good plz send me Excel file
You can easily prepare it by watching video side by side
SIR KINDLY SEND EXCEL FILE PLZ
Send me excel sheet
can you please share the excel file
You can prepare easily by watching videos
Can you give excel sheet
You can create it easily
You can easily prepare it
can u share the file pls
You can easily prepare it by watching video side by side
Sir How I can I contact you, I need your help
please shrar the exel file
You can prepare it easily just video and do it side by side
Send me files
Will upload tomorrow
@@cakapilsachdev Have you uploaded Sir..? Not Vailable yet. Pls do the needful.
Thank you sir
can u please share the file
Yes sure
@@cakapilsachdev how we can connect and get this file