Why the same thing gets entered twice, and drifts
Two copies of the same information, kept by hand, cannot stay identical for long.
Retyping the same customer into two systems is the obvious cost. The two records quietly disagreeing later is the larger one.
Not every business has this problem, and some should leave it alone.
Most of these can be done better. Whether it's worth doing is a separate question. What follows is one common form of the problem, described in general terms, because your version will differ. These are possible challenges, not a description of your business, and some should be left exactly as they are. If it sounds like your week, that's worth a conversation.
Watch: The Books Agree and the Details Do Not
Sound familiar?
- A customer's details were updated in one system and not the other.
- Nobody can say which of two systems is the current authority for a given fact.
- A quote went out at last quarter's price because the system used hadn't been updated.
- Answering an ordinary question means checking two places and picking one.
The idea in short
A business runs two systems that each need to know about the same thing, a customer, a job, a price, and somebody enters it twice by hand. The doubled typing is the obvious cost and the smaller one.
The drift
A phone number gets updated in whichever system was open. A price change gets applied to the urgent side immediately and the other side later, or not at all. Each of those is a reasonable act in the moment. Together they produce two records that disagree, with no indication that they do, and no way to tell which is current without asking someone.
What disagreement costs
Any question touching both systems now needs checking both and picking one. Work gets done against the wrong copy: a quote at last quarter's price, a confirmation to an outdated address, with nobody having made an error in the moment they used it. And any report combining the two systems inherits every disagreement between them, with no audit able to resolve it, because both sources are equally plausible.
What changes
The fix is not necessarily to merge the systems. What matters is deciding which one is the authority for each piece of information, writing that decision down, and putting a standing comparison between them that reports disagreements without altering either side. The comparison doesn't stop the drift; it makes it visible within a week instead of within a year, which is the entire difference between a small correction and an archaeology project.
Questions worth asking about your own operation
- For each piece of shared information, which system is supposed to be the authority?
- How would a disagreement between the two systems actually be noticed today?
- Has a quote or confirmation ever gone out using the wrong copy?
If this sounds familiar
Bring me the version you actually have. I'll learn how the process really works before I suggest anything. If it isn't worth changing, or isn't a fit for me, I'll say so. Talk through a problem