Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

Month End

Month-End Reconciliations with Power Query

By Jeff Lenning | June 9, 2026 |

Month-end reconciliations are a fact of life for anyone managing financial data. Whether we are comparing Shopify orders against QuickBooks invoices, matching a bank statement to a check register, or verifying inventory counts, the core task is always the same: take two lists and find what does not match. In this tutorial, we walk through…