Every office has a job nobody has given a name to: opening one program in the morning and typing the list on screen into another program one item at a time. Downloading the bank statement and posting it into accounting, copying the order list from a marketplace panel and pasting it into a dispatch file, transferring the Excel file in an incoming email into the system row by row. This work usually sits with one person, and when that person goes on leave the work stops. Nobody sees it as a process, because it is written in no procedure and appears in no report. Yet it takes hours during the day, produces errors in the tiredness at the end of a shift, and where the error was made is often only noticed weeks later, when a reconciliation fails to match.
The right answer to this work is usually integration: the two systems are connected and the data is not carried by hand. In the field, though, that is not always possible. The program in use was written years ago and has no external interface (API); the firm that wrote it cannot be reached, or does not want to do the development. Sometimes the development quote that comes back is higher than the cost of doing the job by hand for a year. Sometimes the licence agreement forbids writing directly to the database, and sometimes writing to it reduces the support cover. Sometimes the system is going to be replaced soon anyway and investing in integration with it today makes no sense. In short, the right door is closed, but the work carries on being done the same way every morning.
Robotic process automation (RPA) comes in at exactly this point. RPA is a software robot that takes the steps a person performs on screen — opening the window, clicking the field, typing the data, pressing save, downloading the list — binds them to rules and runs them repeatably. The robot uses the target system's interface just as a user would; that is why no change has to be made in that program and no update has to be requested. The robot has its own user account and its own permission boundary, when it will run is tied to a schedule, and every step it takes is recorded. When it meets a screen it was not expecting, it does not carry on; it stops and hands the job over to a person. The robot is thereby set up not as one employee's shortcut but as an auditable component of the system.
The condition for setting this work up honestly is to say up front what RPA is not. If the target system has an interface (API), the right solution is integration, not RPA; integration runs faster, costs less to build and is far more robust. RPA, by contrast, depends on the screen: when the system changes its screen layout in an update, the robot stops and needs maintenance. That maintenance burden is a fact of the work and is written into the project from the start. Moreover, robotising a badly designed process does not fix it, it only speeds up the error; that is why we strip the unnecessary steps out of the process before moving to a robot. We recommend RPA not as a permanent architecture but as a bridge that works where integration is not possible.