How to Automate Import of CBS Bank Statement into Excel via Power Query

Detailed tutorial on how to import Bank Statement received during audit, which is in textual format in Excel for further analysis & reporting. Power Query is used to record steps for one-click automation of the import steps, which can be re-used for multiple files having same structure

[@gospelmoto2833]

Exactly what I was looking for. Thanks so much. It was helpful. You got a new sub here.

[@ravim9183]

very good place to learn learning..

[@gokulnaththeboss08]

This channel is God for article assistant for CA students

[@SaqibAliJan]

I really found your videos very helpful. Keep up the good work.

[@anandabojanb]

Very useful sir Thankyou

[@85MA]

Sir I hv a bank statement in pdf but the automation didn't work for me.. showing Expression Error says the key didn't match with the rows in the table.. sir how to fix this.. request for resque plz

[@ExcelKida]

For PDF there is a separate video on the channel. Will recommend to watch that. This method I demonstrated is specifically for statement generated by back end system of banks

[@nebox1923]

@@ExcelKida which video can you send link?