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.

5 Comments
  1. firaangi 4 years ago

    Excellent Technique, wonderful explanation Thanks

  2. jazzista1967 4 years ago

    Great example. It gave an idea on a recon project with hundreds of rows coming from several tables. Thanks

  3. VIRAT JONEJA 2 years ago

    Thanks

  4. Martin Short 2 years ago

    This looks fantastic and will save me loads and loads of time. I tried implementing it in a reconciliation project but came unstuck when I found that "Conditional Column" under "Add Column" is completely missing. I tried upgrading Excel 2016 to no avail. Any ideas?

  5. tikkki25 1 year ago

    Great example

Leave a reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

©2021 TDG - We Are Back Baby!

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending
or

Log in with your credentials

or    

Forgot your details?

or

Create Account