Excellent Video explaining in a very simple yet effective way. Easy to follow and learn. This can be implemented for all repetitive reconciliations and save lot of time.
Highly appreciate you explaination there is a dout if the ERP balance is of previous month and cerdited in the bank in current month how to reconcile the statement
we appreciate your efforts. Sir, requesting you to make a video on reconciling books of accounts with GSTR2A/2B. There are multiple elements and many possibilities so reconciling is bit difficult. It would be of great help to professionals. Hint is to export from tally > apply power query > then > export from gst portal > apply power query > and without much change in format of the data > reco is done. Thanks in advance.
One more Qu? please If the Bank or Creditor sent me his Statement and I have My Own PQ sheet how to manage the reconciliation process please ? Shall I put it in the same fail PQ in work sheet then import data or what ?Please advice ?
But if there is reconciliation between our books and let say Creditor boos we have to fill all of his information from creditor book in excel sheet or its possible to import it as excel to power query to reconcile am i right ? Correct me if I'm wrong
Sir the above video is about BRS.this can be done easily LeftANti and Rightanti Not only BRS ,any Reconciliatio can be done easily by LEFTANTI and RightANtii..yu pl try and upload a new video since the above seems difficult..Sir where will i find Projects realting to MSexcel.pl guide me.thank yu
Excellent Video explaining in a very simple yet effective way. Easy to follow and learn. This can be implemented for all repetitive reconciliations and save lot of time.
Eye-opener!
Thank you @Excelism CA Saran sir for this wonderful and practical insight.
You are a genious hahah. Never thougth to do that way!
Thank you. Consider Subscribing.
Excellent Work Sir. Thank You.
Wonderful Concept. Ur awesome videos sir.
very useful tips
Best Video
Highly appreciate you explaination there is a dout if the ERP balance is of previous month and cerdited in the bank in current month how to reconcile the statement
Excellent brother
Mind blowing
Fantastic
Beautifully explained 👌 - thanks very much
please try to provide excel file if possible , great video btw :)
we appreciate your efforts. Sir, requesting you to make a video on reconciling books of accounts with GSTR2A/2B. There are multiple elements and many possibilities so reconciling is bit difficult. It would be of great help to professionals. Hint is to export from tally > apply power query > then > export from gst portal > apply power query > and without much change in format of the data > reco is done.
Thanks in advance.
I am going to make it on my channel
Nice one sir how we have to do for reconciliation of date reference no and amount total 3 columns
Great sir
Worderful ❤️
Thank you 🌹
Thankss
Nice Sir
awesome video
How to setup bank reconciliation with powerquery if the reference isn't approximatively the same, please?
e.g: reference of the firm W is F.004 yet the reference of bank is F//004, so what to reconcile in this case, please?
Very useful! Thanks :-)
good work , I want to understand why is bank and ERP data have no negative values?
One more Qu? please If the Bank or Creditor sent me his Statement and I have My Own PQ sheet how to manage the reconciliation process please ? Shall I put it in the same fail PQ in work sheet then import data or what ?Please advice ?
How to reconcile with multiple columns?
But if there is reconciliation between our books and let say Creditor boos we have to fill all of his information from creditor book in excel sheet or its possible to import it as excel to power query to reconcile am i right ? Correct me if I'm wrong
You are correct
Greetings from Yemen
Is this example file available for download? Thanks.
Can u please share this excel file for practice ?
Nice concept but very complex, it has many process. Can u give us an simpler alternative pls?.
This is a complete automation.
I have already uploaded a video on the same using Consolidate Feature and Filter.. pls watch the same.
@@TheExcelism sure thank you for prompt response. And also thank you for educating us.
Most welcome Mr.Rohan
Sir the above video is about BRS.this can be done easily LeftANti and Rightanti Not only BRS ,any Reconciliatio can be done easily by LEFTANTI and RightANtii..yu pl try and upload a new video since the above seems difficult..Sir where will i find Projects
realting to MSexcel.pl guide me.thank yu
After merge new option ok button is disabled , is there any problem is there
How to check decimal value.? I try to run the query but decimal value not showing why?
if i am taking 60000 records merge new option is not working ,there is any limit in power query
No limit. It should work.
How many rows data it was allowed
Unlimited