All posts

Back Office Automation: What the Work Actually Is, and Which Part Is Worth Automating First

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.

··19 min read
Back Office Automation: What the Work Actually Is, and Which Part Is Worth Automating First

Back office automation is making the recurring administrative work behind a business run without a person doing each step by hand: pulling data out of the systems it sits in, reshaping it into the form the next step expects, applying the rules that decide what is fine and what needs a second look, and producing the file, entry or report that somebody downstream is waiting on. It is not a product category, and it is not a smaller version of replacing your finance system. Almost every page written on this term is a list of ten vendors with a feature grid underneath.

That page is useful if you have already decided what to automate. Nobody arrives at this term having decided. They arrive because close is taking a day longer than last year and one person is doing most of that day.

What back office work actually is

Front office is the work a customer sees. Back office is everything that has to be true for the front office to function: the close, the reconciliations, the reporting, onboarding, checking invoices against what was received, moving data between systems that have no reason to be strangers but are. Listing the processes teaches you nothing, because the list differs at every company. The shape is the same everywhere.

The input arrives in a form you do not control. An export from a system somebody else owns. A workbook a regional team fills in, mostly correctly. An email with an attachment, sent when the sender remembers. You are downstream of decisions made by people who have never thought about your process.

The rules exist and are not written anywhere. Amounts under a threshold get cleared without review. This account code is always excluded. Anything from that one entity arrives in a different date format and has to be fixed first. Everyone doing the job knows this. No document says it.

The deadline belongs to someone else. Working day three. Every Monday by eleven. Before the board pack goes out. Which is why back office work is stressful in a way volume alone never explains: it is not hard, it just cannot be late and it cannot be wrong.

Put those together and the day looks the same across finance, operations and HR. Log in, run a report, download it, open a workbook, paste the block in, run a lookup, notice three rows that look wrong, message two people, wait, fix them, reformat, send. Two hours on a good day. Half of that is data movement. The other half is judgment, and the judgment is what nobody can hand over.


Why back office work resists automation

Nothing in the paragraph above is technically difficult. Every step is something a computer has done reliably for thirty years. The resistance comes from somewhere else.

The specification does not exist. What exists is a workbook with nested conditions in it, a folder naming convention two people understand, and a person who has run the process long enough to stop thinking about it consciously. Ask them to describe what they do and you get the happy path in ninety seconds. The other rules surface only when a real case hits them, which is why requirements workshops produce documents wrong in exactly the ways that matter. Same wall that stops spreadsheet projects, covered in Excel automation.

The exceptions are the job. The mechanical portion of most back office processes is quick. What eats the morning is the row that does not match, the entity that submitted late, the invoice with the wrong purchase order reference. Automating the quick part is a real gain and a much smaller one than the demo implied.

Nobody owns the whole chain. Finance owns the workbook, IT owns the source system, operations owns the deadline. When it breaks in the middle, whoever is most inconvenienced fixes it, almost always the person running it. Which is also why it never reaches anyone who could fund a fix.

One back office process drawn end to end: a system export, an emailed workbook, a hand maintained mapping tab, and the three points where a person applies a rule that exists nowhere in writing.
One back office process drawn end to end: a system export, an emailed workbook, a hand maintained mapping tab, and the three points where a person applies a rule that exists nowhere in writing.

The process moves without announcing it. A director asks a new question in March and a column appears. An entity restructures and its reference codes change. The source system upgrades and its export gains a header row. None of these are events anyone logs, and each one quietly invalidates something an automation assumed.

Then the failure mode that should decide your whole evaluation. A manual process has a person looking at the output who notices when a total is odd. Automation removes the person and, unless somebody deliberately designed for it, removes the noticing too. It keeps running, on schedule, producing a wrong number, until a human looks. Ask about that path before anything else. Most demos are a happy path with confident narration over it.


The five realistic options

Two of these are not software, and leaving them out is what makes vendor pages on this term useless. For a lot of readers the first two are the right answer.

Hire someone

The most common thing organisations actually do, and not the wrong call as often as automation vendors suggest.

Genuinely good at: variety, judgment, and chasing other people. A person handles the entity that submitted a broken file by ringing them up. They notice that this month's figure looks strange without anyone specifying what strange means.

The ceiling is that it does not compound. You have bought capacity and the cost is the same next year. The process knowledge now lives in two heads instead of one, which feels like resilience until both leave inside a quarter. The new person learns by watching, so they inherit the undocumented rules along with the ones that stopped being necessary years ago.

Best fit: growing volume, varied work, budget for headcount, no appetite for a project.

Outsource it

Hand the process to a provider who runs it at scale with a documented method and a service level.

Genuinely good at: cost per transaction at high volume, coverage across time zones, and taking a well defined process off your plate permanently. A provider who has run a process for a hundred clients is often better at it than you are.

The ceiling is the transition, the same wall wearing a different jacket. To hand a process over you have to write it down, the exact thing nobody has done, and it is now on a deadline with a contract behind it. The documented part goes across cleanly and the remainder comes back as queries, so your side is still handling exceptions with a longer loop and less context. Ask any provider how long stabilisation takes. The honest ones give a real number.

Best fit: high volume, stable process, willing to fund the documentation properly.

RPA through a Center of Excellence

Robotic process automation drives applications the way a person does, which makes it the right technology for exactly this work. A properly run CoE gives you scheduling, controlled handling of sign in details, audit logs, version control and an exception queue somebody is paid to watch. That last one is worth more than most of the feature list, and anyone dismissing RPA has never had to keep a production automation alive.

The ceiling is economics, not capability. An RPA developer trusted with production processes is a real salary, and a CoE queue is prioritised by volume and criticality, which is the correct way to prioritise it. A process one person runs for four hours a week does not clear that bar, will not clear it next year either, and the CoE is not being obtuse when it says no. That structural leftover is the last mile, and it exists in every mature programme regardless of how good the programme is.

RPA also replays steps without understanding them, so the specification problem does not go away. It relocates into a business analyst's document that goes stale the week after signoff.

Best fit: high volume, multiple systems, real audit requirements, funded, owned by a CoE afterwards.

No-code and workflow builders

Connectors, triggers and a drag and drop canvas. Genuinely useful software, and the category has matured a lot.

Genuinely good at: work that already lives in systems with proper interfaces, triggered by an event, moving clean structured data between them. New record here creates a record there and notifies a channel. If your back office runs on modern applications that all expose an API, do this before considering anything heavier.

Where it stops is that back office work is mostly file shaped and screen shaped rather than API shaped. The report downloaded from a portal with no interface, the workbook a regional team emails in, the legacy system that predates anyone thinking about integration. And the moment a judgment call enters the flow you get conditions nested five deep, the same unreadable specification on a new canvas. Nobody keeps a register either, so when one of two hundred accumulated flows breaks, nobody can say what depended on it.

Best fit: modern systems with real interfaces, event driven, structured data, low judgment.

GPA: build from what the person already does

Guerrilla Process Automation starts from the thing the other four routes work around. The person who runs the process is the only complete record of it, so build from what they actually do rather than from a document about what they say they do.

The tooling watches the work instead of interviewing about it. I² Recorder records the browser side: which elements get used, in what order, what gets typed where, and which of those actions carry the real decision. Debrief does the same for the workbook, reading structure, formulas, lookups and mapping tabs to work out what rules the file already enforces, then asking about what it cannot infer. Deputy covers the case the others handle badly, where the automation cannot resolve something and needs to stop, hand to a person, and resume rather than fail the run. Vigil keeps the register, so what exists and what ran is visible rather than folkloric.

All of it runs on infrastructure IT has already approved, and the person who builds it is the person who runs the process. We call that person a Guerrilla Practitioner, and the point of the role is that they do not become a developer to do this. Why this is a distinct category rather than a rebrand is argued in RPA vs no-code vs GPA.

Three honest notes. None of it is downloadable today: I² Recorder ships first, Debrief follows, the rest come after. GPA does not remove the need for someone to confirm the rules, it changes who confirms and when. And the fit is narrower than the enthusiasm suggests, which the table tries to be straight about.

Best fit: recurring, real judgment in it, no developer available, too small to ever get funded.


How the options compare

HireOutsourceRPA via CoENo-code buildersGPA
Who does the work afterA new person on your teamA provider's teamA scheduled bot, watched by the CoEThe flow, unattendedThe automation, with the practitioner watching
Time to runningWeeks to hire, months to competenceMonths, including transitionWeeks of build, after the queueDays, if the systems have interfacesHours to days
What it costsSalary, every year, foreverPer transaction, plus transitionLicence, developer, CoE capacitySubscription per user or per taskSubscription, no developer
When the process changesAbsorbs it without being askedA change request and a lead timeA ticket, then the CoE queue againYou edit the flow, if you built itAdapts where it can, asks where it cannot
Where the process knowledge sits afterIn two heads instead of oneIn the provider's runbook, off your siteIn the bot, plus a document going staleIn the canvas, readable but shallowIn a stated, reviewable description of the rules
What breaks itAttrition, leave, a bad quarterScope drift, anything undocumentedScreen and portal changes, expired sign in detailsAnything without an interface, judgment casesAmbiguity, which it flags rather than guesses past
Handles judgment casesYes, this is the reason to hireOnly the ones written into the contractOnly via an exception queue somebody staffsPoorly, and it degrades fastStops and asks, by design
Best fitVaried, growing, high judgmentHigh volume, stable, documentableHigh volume, cross system, fundedModern systems, event driven, clean dataRecurring, unfunded, real logic, no developer

One row does more work than the others: where the process knowledge sits afterwards. Every route here produces something that functions in month one. The difference shows up in month fourteen, when the builder has moved teams and the source system has changed its export twice.


What this looks like in real work

The monthly consolidation

Five entities, five workbooks, one summary. Same template when it was issued, not the same file any more. One added a row above the header, one renamed a sheet, one is still on last year's version and nobody noticed because their totals happened to be right. The automation has to be relaxed about harmless variation and loud about the rest, and telling those apart is judgment rather than parsing.

The recurring reconciliation

Two sources that should agree. The work is deciding what agreement means: exact match on reference, or amount within a tolerance, or amount and date but not reference because one system truncates the field. The tolerance is a business rule, chosen years ago, written down nowhere. That is the subject of bank reconciliation automation, and the shape repeats across intercompany, inventory and payroll.

The report five people wait on

Same figures, three audiences. A one page summary for the director, full detail with exceptions flagged for operations, and a group template that must not be modified. Calculation once, presentation three times, and presentation is what most automation approaches throw away. MIS report automation covers why the formatting layer is harder than the numbers.

The one that only breaks at quarter end

Fine for eleven weeks. In the twelfth an extra step appears, an adjustment gets posted, a different approval is needed. Whoever runs it knows and handles it without comment. Whoever automated it built in a normal month and found out a fortnight late.


How to pick the first process

Getting this wrong is the most expensive mistake available here, and it is not a tooling decision. Six questions, in order. The first you answer honestly usually settles it.

1. Does it run on a schedule you could put in a calendar? Monthly, weekly, every Tuesday. If it runs when someone asks, it is not a first candidate, because you cannot tell whether it worked without watching it, and watching it is what you wanted to stop doing.

2. Can the person who runs it state the rules out loud in ten minutes? Actually try this, on a real recent case rather than the process in general. If ten minutes gets you a clear set of rules, any of the five options will work and you choose on cost and maintenance. If it does not, that gap is the project, whatever tool you buy.

3. How much of each run needs a human decision? A small fraction and straight through automation is realistic, with the remainder queued for review. If it is most of the run, the process needs a person with support rather than replacing, and hiring is the more honest answer.

4. Do you control the shape of the input? Not the values, the shape. If the file comes from a system somebody else owns, or a team fills in a template by hand, assume it will change without warning and pick an approach that matches on names rather than positions.

5. What happens if it silently produces a wrong number? If somebody downstream would spot it, you have a safety net. If it goes into a board pack unchecked, the automation has to stop and ask by design from day one, not as a later hardening exercise.

6. Who maintains this in eighteen months? Say an actual name. If the honest answer is the person who built it and they are on a fixed term contract, choose the route that leaves the logic readable by somebody else, even if it is slower to build.

One more thing, and it runs against instinct. Do not start with the process everyone hates most. It is hated because it is full of judgment, undocumented exceptions and other people's lateness, exactly the properties that make automation hard. Start with the dull predictable one nobody complains about. That one finishes, and finishing earns you the room to attempt the difficult one.


Frequently asked questions

What is back office automation?

Back office automation is making recurring administrative work run without a person doing each step by hand: pulling data out of the systems it sits in, reshaping it, applying the rules that decide what is fine and what needs a look, and producing the output someone downstream is waiting on.

What counts as back office work?

Anything that keeps the business running but never touches a customer directly. Month end close, reconciliations, management reporting, vendor and employee onboarding, payroll inputs, invoice checking, data entry between systems that do not talk to each other.

Which back office process should you automate first?

The one that runs on a predictable schedule, whose rules the person running it can state out loud in ten minutes, and where a wrong output would be noticed rather than quietly filed. Not the most painful one. That one is painful because it is full of judgment.

Why do back office automation projects fail?

Because the process was never written down anywhere except in the head of the person who runs it. Building the automation is the straightforward half. Getting someone to state rules they have applied by reflex for years is the half that stalls.

Is it cheaper to outsource back office work or automate it?

Outsourcing is cheaper to start and does not compound. Automation costs more upfront and gets cheaper every month it runs. Both need the same thing first, a written description of the process, and that requirement usually decides the outcome.

What is the difference between back office automation and RPA?

RPA is one way of doing back office automation. Back office automation is the goal. RPA drives applications the way a person does, and it is the right tool when the work is high volume, cross system, and funded well enough to have a developer behind it.

Can you automate a process that is not documented?

Only if the tool builds its own description of the process from what actually happens: what the person clicks, which values move where, what the workbook already calculates. If the tool needs a specification handed to it, then writing that specification becomes the project.

How long does back office automation take?

The build is hours to weeks depending on the route. What sets the timeline is agreeing what the process does, which takes anywhere from an afternoon to several months. Ask any vendor for a timeline excluding requirements gathering, then ask what requirements gathering looks like.

Do you need IT approval to automate back office work?

For anything touching company data, yes. IT approves the environment: what software runs on the machine, where sign in details are held, what can reach the network. Once that is approved you are not raising a ticket per process. The real risk is automation nobody has a register of.

What happens when a back office automation breaks?

That depends entirely on whether anyone designed for it. A well built automation stops, says what it could not resolve, and waits. A badly built one carries on and produces a confident wrong number. Ask about the failure path before you ask about the features.

Where to go from here

Your process is mostly one workbook.

Start at Excel automation and give Power Query two hours before you buy anything. A lot of back office work is a data shaping job wearing a costume.

Your process is matching two sources against each other.

Bank reconciliation automation covers how matching rules get decided and why the tolerance is the hard part. If the output is a recurring pack rather than a match, MIS report automation fits better.

You took this to the CoE and it did not clear the bar.

That outcome is structural, not a judgment about your process. What GPA is explains where the leftover work sits, and RPA vs no-code vs GPA is the honest comparison of who builds what and who owns it after.

You run or advise a CoE and this reads like your rejection pile.

Robotic. Agentic. Guerrilla. sets out the three categories and why the current agent conversation only addresses two.

You want the tooling.

I² Recorder ships first, Debrief behind it. Nothing is downloadable today and we are not going to pretend otherwise. For early access, sign up on the Guerrilla Bots homepage and describe the process you would point it at first. Pre-launch, that is what decides what gets built.

Pranav Neeli

Twelve years building enterprise automation. Accenture, EY, Fossil, Alcon, HP. Now building Guerrilla Bots.