How to use Power Query to clean expense reports before month-end

Power Query has been one of the few Excel tools that actually saved me time during close, but only after I stopped trying to make it do accounting judgment. I use it for cleanup, not for deciding the books. The setup that worked for me starts with a raw folder. Credit card exports, reimbursement reports, and vendor downloads all go there untouched. I connect Power Query to the folder, promote the…