Back to Insights
IntegrationYesterdayJustin Pennington

Count the Keystrokes: A One-Week Audit of Your Copy-Paste Tax

Count the Keystrokes: A One-Week Audit of Your Copy-Paste Tax

Somewhere in your company, a person is reading a number off one screen and typing it into another. An order from the website goes into the ERP by hand. A won deal in the CRM becomes a manually created customer record. A supplier invoice gets keyed into accounting, then keyed again into a spreadsheet someone built because the report they need doesn't exist.

Nobody put this work in a budget. It grew in the gaps between systems that were bought at different times for different reasons. And because it's spread thin across a dozen people's days, it never shows up as a line item — it shows up as "we need another hire."

Before you approve that hire, spend one week counting keystrokes.

Why Re-Keying Stays Invisible

Manual data movement — sometimes called swivel-chair work, because the operator physically turns from one screen to another — is uniquely good at hiding.

It hides because it's fragmented. Fifteen minutes here, twenty there, spread across sales ops, accounting, purchasing, and customer service. No single instance is worth escalating.

It hides because the people doing it are competent. They've built shortcuts, keyboard macros, and personal checklists. The work looks smooth from the outside, which makes it easy to assume it's efficient.

And it hides because it's been normalized. Ask why orders are entered twice and you'll often get a version of "that's just how it works." The person who knew the actual reason left two years ago.

The Audit: One Week, One Log

You don't need a consultant to start this. You need a shared spreadsheet and honest participation from the people closest to the work.

For five business days, ask every person who touches operational data to log each time they move information from one system to another by hand. One row per handoff type, not per instance. Capture:

  • Source and destination — where the data comes from, where it goes, including spreadsheets and email as legitimate "systems"
  • Trigger and volume — what starts the task, and roughly how many times per week
  • Minutes per instance — their estimate, not a stopwatch study
  • What breaks when it's wrong — a late shipment, a wrong invoice, a bad forecast
  • Who else touches it — whether the same data gets re-entered downstream by someone else

That last column is where the surprises live. The same order number often gets typed four or five times across a company's lifecycle. Each retyping is a new opportunity for a transposed digit.

Read the Log for Two Costs, Not One

The obvious cost is time. Multiply volume by minutes and you have hours per week, which converts easily into a number your leadership team understands.

The bigger cost is usually error and reconciliation. When the same fact lives in two systems and is synced by a human, the two systems drift. Then someone has to figure out which one is right. That detective work — chasing down why the CRM says one thing and the ERP says another — rarely gets logged as data entry, but it's a direct consequence of it.

So add a second read of the log: for each handoff, what does it cost when it goes wrong, and how long does it take to notice? A handoff that fails silently for a month is more dangerous than one that fails loudly every day.

Rank Before You Build

Not every handoff deserves an integration. Rank them by three factors together: total hours, error blast radius, and stability of the process.

High-volume, high-consequence, stable processes are your first integrations. Order-to-fulfillment, quote-to-customer-record, invoice-to-ledger — these are well-trodden paths with clear rules and clean success criteria.

Leave alone the handoffs that are low volume, judgment-heavy, or attached to a process you're about to change anyway. Automating a bad process just makes it fail faster. And be honest about the ones that exist only because a report is missing — sometimes the fix isn't an integration, it's a dashboard.

The Part Most Teams Skip

Once data flows automatically, someone still has to own what happens when a record fails validation. Automated integrations don't remove the human — they change the human's job from typing to exception handling. That's a much better job, but only if you design for it: a place failures land, an alert with enough context to act on, and a named owner.

Without that, you've replaced visible manual work with invisible silent failure, and you'll discover the gap during month-end close.

Where This Leads

Most mid-market companies we work with are running a handful of good systems that simply don't talk to each other. The fix isn't always a new platform. Often it's connective tissue: well-scoped integrations, clear ownership of each data flow, and a single place where the whole picture comes together.

If your audit turns up more hours than you expected — or you'd rather have someone experienced run it with you — that's a conversation worth having. Reach out to Infraxio and bring your log. We'll help you decide what to connect first, what to leave alone, and what your systems should actually look like a year from now.