Automate Bank Reconciliations with Excel Power Query Power Query is a data connection technology that enables you to discover, connect, combine, and refine data sources to meet your analysis needs. How the Excel tool can help you handle bank reconciliations – 1. Go to the Get & Transform Data group on the Data tab of the Excel Ribbon 2. Import 2 tables into Power Query 3. Select one of the tables and then click on the Merge dropdown on the Home tab and click on Merge Queries as New 4. Merge dialog box will open, where the two tables and fields may be selected 5. Several join kinds will open; Left Anti (“left” is the top table and “right” is the bottom one). It creates a table where records in the top table do not have a corresponding item in the second table. Click OK. 6. There is an icon to the right of the final field header. Clicking on this and selecting the correct fields generates the table. 7. Repeating this entire process and using the Right Anti join creates the other half of the reconciliation. 8. Now, Appending (Home tab) and closing & loading these two tables will produce the report. 9. At last, Close & Load this data back into Excel, click Refresh All on the Data tab and a new report would be completed in a flash.