A repeatable Excel macro workflow can import a bank CSV, clean dates and amounts, normalize merchant names, apply categories, ...
Credits to QB-Core for the original script, I merely edited to be used for another job. Job will need to be edited via config and main.lua, open both and search for "changeme" then set your desired ...