Customer tracking in Excel or a CRM: which one, and when

Example scenario: Picture a furniture maker in İzmir. The owner has kept dealers and key customers in a single Excel file for years. He opens it, he updates it, he remembers it. It works because the owner of the record and its only user are the same person.

Then a sales rep is hired, and later a second one. The file moves to a shared folder. One day two people quote the same customer different prices; each has looked at the copy they opened. Nobody can say who changed which cell, or when. Excel has done its job; the file, though, is built for one person's habits.

At this point most companies try to fix the file: colour codes, locked columns, a column for the name of whoever last updated it. These help for a while. But the rule depends on everyone who opens the file following it, and in a busy week that is the first thing to go.

There is no reason to look down on Excel. Think of a newly founded consultancy: a handful of corporate clients, occasional meetings, and one partner running all of it. Setting up a CRM there would add the weight of a habit with nothing to show for it.

The things Excel does well are real too: a quick list, a price calculation, a list of event attendees. Those can stay in Excel after a CRM arrives. The decision here is only about where the customer record lives; Excel stays in the company. If you are staying with the spreadsheet, give the file one owner and make every row carry the next step with its date. A row without a date just sits there as a record; it prompts nobody to act.

Apart from cost, the rows in the table where Excel falls behind all lead to the same place: the record depends on a person. At the İzmir furniture maker, which dealer is paying late and which has asked about the new model lives in the owner's head, not in the file. A CRM cannot know this by itself; it gives that knowledge a place to be written and a date to remind you of the next step.

• The same customer appears twice in the file, spelled two different ways.
• When a rep goes on leave, nobody knows where their customers stand.
• Customers write on WhatsApp, by email, and by phone, and only one of these makes it into the file.
• Once a quote is sent, nobody remembers when to follow it up.
• The manager cannot see the state of things without waiting for the month-end sheet.

No single event is a reason to switch on its own. When several happen in the same month, the root of the problem is that the record depends on a person, and the layout of the file does not change that. However tidy you make the file, it will not tell you the next step. Note these events on a sheet of paper for a month. If the list stays short, the spreadsheet is doing its job; if it grows, the decision has in effect already been made.

On the manager's side the same problem has another face: an Excel report is right on the day it is made and dated the next. We looked at this from the angle of a decision screen in the limits of the Excel report.

A CRM does not keep records by itself. If the team does not open the card and write the note, the screen stays empty. If the old file is left open after setup, the team updates both places and both end up incomplete. There is also a settling-in period. The team may slow down a little in the first days; that is normal. Agreeing with the team before setup which fields will be required shortens it. If you have made the decision, we gathered what to check, in order, in the CRM migration checklist.

Then there is the question of expectations. A CRM does not sell; it reminds the rep of what they forgot and shows the manager what they would otherwise have to ask. A team expecting sales to rise by themselves after the move will be disappointed. The measure of the move is that lost quotes and unanswered customers are now visible.

Contacts, tasks, opportunities, quotes, contracts, and files sit in separate tabs on the card. Messages, calls, and email link to the same person, and the date of the last contact is clear. X AI reminds you of follow-ups and brings pending work forward in the morning report; the decision stays with you. You can read how the card works on the Corex360 CRM module page.

For the İzmir furniture maker, day one looks like this: the dealers in the file have been moved onto cards, and the sales reps open their own customers' cards and write the next step on each. The next morning, who calls which dealer is on the card.

If one person keeps the list and your customer traffic is light, you may not need Corex360 today. In that case keep your file in order, and let us talk again when events such as two different answers to the same customer, or a salesperson's customers left without an owner during leave, start to happen.