Eye-opener! Thank you @Excelism CA Saran sir for this wonderful and practical insight.

Beautifully explained 👌 - thanks very much

Excellent Work Sir. Thank You.

Wonderful Concept. Ur awesome videos sir.

Very useful! Thanks :-)

Excellent brother

Mind blowing

Great sir

very useful tips

Thank you 🌹

Best Video

Worderful ❤️

Fantastic

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

You are a genious hahah. Never thougth to do that way!

@TheExcelism

8 ай бұрын

Thank you. Consider Subscribing.

Nice Sir

Thankss

please try to provide excel file if possible , great video btw :)

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 ?

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.

@ManuSharmaCA

2 жыл бұрын

I am going to make it on my channel

good work , I want to understand why is bank and ERP data have no negative values?

Nice one sir how we have to do for reconciliation of date reference no and amount total 3 columns

After merge new option ok button is disabled , is there any problem is there

Is this example file available for download? Thanks.

How to reconcile with multiple columns?

awesome video How to setup bank reconciliation with powerquery if the reference isn't approximatively the same, please?

@hasinarafenoarisoa7063

3 жыл бұрын

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?

How to check decimal value.? I try to run the query but decimal value not showing why?

Can u please share this excel file for practice ?

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

@TheExcelism

Жыл бұрын

You are correct

@mahmoudalshami1557

Жыл бұрын

Greetings from Yemen

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

Nice concept but very complex, it has many process. Can u give us an simpler alternative pls?.

@TheExcelism

3 жыл бұрын

This is a complete automation. I have already uploaded a video on the same using Consolidate Feature and Filter.. pls watch the same.

@CARohanAgarwal

3 жыл бұрын

@@TheExcelism sure thank you for prompt response. And also thank you for educating us.

@TheExcelism

3 жыл бұрын

Most welcome Mr.Rohan

if i am taking 60000 records merge new option is not working ,there is any limit in power query

@TheExcelism

Жыл бұрын

No limit. It should work.

How many rows data it was allowed

@TheExcelism

Жыл бұрын

Unlimited