How to Automate Bank Reconciliation using Power Query in Excel

Bank Reconciliation is still a highly manual process in the accounting world. In this video, we will cover steps on how to automate our bank reconciliation using Power Query in excel.

In this video, we will learn how to automate bank reconciliation by creating a template to run our reports. For subsequent months, we would only need to change the source data and click refresh to update the bank recon. And we are done!

I know we do reconcile not only a single bank account but many bank accounts. We can imagine how much time we can save just by using Power Query to automate this process.

The solution is not a one-size-fits-all because we all book transactions differently. But bank transactions is somewhat consistent in recording our transactions.

The ideas presented here will help you jumpstart your process automation just by using the user interface inside Power Query.

To follow along, you can access the files used in this video in the link below.

https://drive.google.com/drive/folder...