Most small businesses don't run on one system. They run on a handful of tools held together by people. An order comes in by email, someone types it into a spreadsheet, someone else copies it into the shipping tool, and at the end of the week somebody rebuilds the same report by hand.
None of it feels like a problem, because each step only takes a minute. That's exactly why it's easy to miss. Here's how to see that busywork clearly, what it really costs, and how to decide what's worth fixing first.
What copy-paste work looks like
You probably have some of this already. It tends to show up as:
- Orders or bookings re-typed from email, a web form, or a marketplace into a spreadsheet or another tool.
- The same customer entered twice: once in your invoicing tool, once in your email list, and maybe again in a CRM.
- Status updates by hand. A customer asks "where's my order?" and someone has to go look it up in three places before replying.
- Weekly or monthly reports rebuilt from scratch, by exporting, pasting, and fixing formulas that broke since last time.
- Spreadsheets that only one person understands, with a tab called "FINAL v3 (use this one)".
- Sticky notes and memory. Steps that only happen because someone remembers to do them.
If you read that list and thought "that's just how it works here," that's normal. Most of these habits started as a quick fix and quietly became part of the job.
Why it costs more than time
The obvious cost is minutes. A few minutes per order, per customer, per report adds up over a year, and you can estimate it yourself (more on that below). But in my experience the bigger costs are the ones that don't show up on a timesheet.
Mistakes. Every time information is re-typed, there's a chance it changes on the way. A wrong digit in a phone number, a missed line on an order, a price from the old list. These are small errors with real consequences: a refund, a reshipment, an awkward phone call.
Delays. Copy-paste work waits for a person to get to it. Orders sit until someone has time to enter them. Customers wait for answers that a system could have given instantly.
Single points of failure. When a process lives in one person's head, it stops when they're sick, on vacation, or busy with something urgent. If you've ever dreaded someone's day off, this is why.
Hidden decisions. When the numbers come from a hand-built report, you tend to look at them less often, and trust them a little less. That makes it harder to see what's actually working.
Your attention. Busywork crowds out the work only you can do: talking to customers, improving your product, planning ahead.
A simple way to find it
You don't need software for this part, just a notebook or a shared doc and one normal week.
- Write down every hand-off. Each time someone copies information from one place to another, note what it was, where it came from, and where it went.
- Note how often and how long. A rough count is fine: "about 15 times a week, 3 minutes each."
- Note what happens when it goes wrong. A typo in an internal note is minor. A typo in a shipping address costs you money and a customer's trust.
- Ask the people doing it. The person who does the task every day usually knows exactly where it hurts, and often has an idea for fixing it.
At the end of the week, you'll have a short list of real tasks with real numbers attached, instead of a vague feeling that things take too long.
To turn it into a rough yearly cost, multiply: times per week × minutes each × 52, then divide by 60 for hours. Do it with your own numbers. It's often a surprise.
What to fix first
Not everything should be automated. A good first candidate is:
- Frequent. It happens daily or weekly, not twice a year.
- Rule-based. The steps are the same every time, without much judgment.
- Painful when it fails. A mistake costs money, time, or a customer.
Start with the task that checks all three boxes. If something only happens once a quarter, a clear written checklist may be all it needs. If something needs real judgment every time, keep a person in charge and make their job easier instead of replacing it.
Fixes don't have to be big
When people hear "automation," they picture an expensive custom system. Often the fix is much smaller:
- Connect the tools you already have so information moves on its own, for example a web form that lands directly in your spreadsheet or CRM instead of an inbox.
- Pick one place where the truth lives. If customer details live in one system and everything else reads from it, you stop entering them twice.
- Replace the fragile spreadsheet with a simple internal tool that has the right fields, checks, and permissions.
- Write it down. Even before anything is automated, a one-page checklist takes a process out of one person's head.
Sometimes a custom app really is the right answer, especially when off-the-shelf tools almost fit but not quite. I wrote more about that in Website or web app? What your business needs. But it's usually worth trying the smallest fix first.
A good place to start this week
Pick one process that annoys everyone, track it for a week using the steps above, and look at the numbers together. That conversation alone often makes the next step obvious.
This is the kind of work I enjoy most: understanding how a business actually runs, then building the simplest thing that removes the friction. If you'd like help, take a look at how I approach business systems and automation, start with a systems audit, or book a free 30-minute consult and walk me through the process that's slowing you down.