Automation 2 min read
How to stop re-keying data between your CRM, accounts and job system
Typing the same customer, order or job into two or three systems is the most common manual job we find. Here is how to connect them so it is typed once.
If we had to pick one job that costs small businesses the most hours, it would be this: typing the same information into more than one system. The customer goes into the CRM, then into the accounts package, then into the job system, by two or three different people, with two or three slightly different spellings.
Why it happens
Each system was bought to solve its own problem, and nobody was asked to make them talk to each other. So a person became the connection. It works, which is why it never gets fixed, but it costs hours every week and it is where the typing mistakes come from.
Decide which system owns what
Before connecting anything, decide the one place each piece of information is typed. Usually the CRM owns the customer, the job or order system owns the work, and the accounts package owns the money. Everything else gets its copy automatically from the owner. Writing this down takes half an hour and settles arguments for years.
Connect them
Most modern systems have a way to connect to them, and many pairs already have a built-in link (Xero and a good number of CRMs, for example). Where they do not, an automation platform or a small purpose-built integration carries the record across the moment it is created or changed. The rule is simple: when something is typed in the owner, it appears in the others within seconds, without a person.
Deal with the old data once
Three systems with three spellings of each customer need tidying before the connection goes live, or the automation will cheerfully create duplicates. This is dull, it is a one-off, and it is worth doing properly. We match the records, agree which version is right, and fix them in one pass.
Take out the steps that only existed because of the re-keying
Once the record flows automatically, a surprising number of checks and approvals turn out to have existed only to catch typing errors. They can go too. In one professional services firm, connecting the CRM to the practice and billing systems removed two approval steps that nobody could explain, and cut the admin per new client by forty per cent.
What it costs and what it gives back
Connecting two systems is typically a couple of weeks' work. The payback is the hours of typing, the mistakes that stop happening, and the fact that your systems finally agree with each other. If this is your business, book a free call and tell us which systems are involved.