A repeatable Excel macro workflow can import a bank CSV, clean dates and amounts, normalize merchant names, apply categories, ...
Use formulas instead of Power Query for tidy files, with a visible source path and clear parameters that teammates can review ...