How back-office work actually gets automated, and where it stalls.

Task mining records clicks, keystrokes and app switches on a small sample of desktops. It was built to ration expensive automation. Here are its seven real limitations, where it still earns its place, and what replaces it now that building a bot costs a fraction of what it did.

Every CoE hits the point where the ideas sheet runs thin. I watched one company bring in task mining to refill it, get a beautiful map of its work, and then stop automating a few months later. The pipeline was never short of ideas. It was short of build capacity.

Macros, Power Query, Office Scripts, Python and RPA all automate Excel, and each has a real best fit. The reason Excel automation projects stall is not the mechanics. It is that nobody can state the rules the workbook already enforces.

The monthly MIS pack looks like the most automatable job in the back office. Same report, same systems, every month. It resists automation anyway, because three jobs with completely different automation profiles get assembled into one file.

Every page on this term is written by an accounting software vendor and ends at automatic transaction matching. Matching is the part that demos well. The reconciliation is the pile of items that did not match, and that is where the hours go.

Back office work is not one process. It is recurring cross-system work held together by rules nobody wrote down. That is why the tool comparison is the wrong place to start, and why picking the right first process matters more than picking the right tool.