Typing Data Twice: Why the Same Details Sit in Three Lists and Where You Enter Them Only Once

The same details sit in three lists because each list started at a different step in your business, and none of them knows about the others. A one-week tally shows you which transfers you repeat. Then you enter each detail once, where it first arrives, and every other step reads it from there.

Why do the same details end up in several of your lists?

Each list started at a different step in your business, and none of them knows about the others. You had a notepad for enquiries, a spreadsheet for planning and a template for quotes. Each of these made sense on its own. Together they give you three places for a single detail.

Here's how that plays out for you. A customer calls, and you write their name, address and measurements on a slip of paper. In the evening you copy everything into the list. The next morning you type it into the quote. That's three entries for one piece of information. If the customer changes their phone number, you have to change it in three places. After that, you can't be sure which version is right.

Every copy of a detail is one more place where it can go wrong for you.

How do you find out which details you type more than once?

A tally sheet kept for one working week will show you. Put a sheet of paper next to your keyboard. Every time you type something that's already written down somewhere else, make a mark. Four columns are enough: which detail, where it came from, where it went, and whether you had to fix a mistake along the way.

After five days, go through the sheet. The row with the most marks is your most expensive transfer. Multiply its marks by the minutes each entry takes, and you'll see what this duplication costs you every week. The correction column shows you which transfer produces your typos.

You might be thinking: I know all that without a tally sheet. But the tally sheet shows you exactly the transfers you no longer notice, because they've long since become routine. I describe how to find these inconspicuous tasks across your whole business in Which Process in Your Business Costs the Most Time Without You Noticing?.

Where should a detail be entered only once?

Enter it where it first comes into your business. For customer data that's the enquiry. For measurements it's the survey on site. At that point you enter the detail once, completely and digitally. Every later step reads it from there instead of writing it out again.

In your example, that means you record the measurements straight into the list instead of on a slip of paper first. The quote pulls the name, address and measurements from that list. Three entries become one. If the phone number changes, you change it in one place. The rule behind it is one detail, one origin, and as many places reading it as you like.

Only now is it worth asking whether to automate. Automation here means a fixed rule takes over the transfer you've been doing by hand. That works once the transfer always runs the same way. If you automate before the tally, the rule just copies your three lists faster instead of merging them into one.

Whether your lists are in order comes down to one decision you make: where each detail belongs. If you want to make this way of deciding stick beyond your business too, sign up for the free challenge at impruvement.com/en/challenge. It takes four days and gives you a concrete first step in Become → Do → Have.