This video shows how you can make use of power query to perform financial account reconciliations that are capable of resizing themselves according to the data that is provided. It’s a relatively long video as it contains all the steps required to perform the process.
All of this is available within excel so please dig in.
The source files are contained here :-
https://dataspinner5-my.sharepoint.com/personal/roryneary_dataspinner5_onmicrosoft_com/_layouts/15/guestaccess.aspx?folderid=0aabfd2f2cf9744b8acfe3cd660b1b906&authkey=AZOYODxZ-LYHm_FXHADBdS8&e=1ba6253140b14ae78e7863f415895a4c
You can download power query (Excel 2013) here:
https://www.microsoft.com/en-us/download/details.aspx?id=39379
If you have Excel 2016 you should not need to do any downloads.
Please drop me feedback if you find this useful.