Skip to content
Sales and clients

Three versions of one client: why your Excel contact list costs you

A two-year-old phone number, an invoice sent to the wrong address and a colleague calling the wrong person. See how contact chaos starts and how one client record ends it.

Small business owner frowning at a contact spreadsheet on a laptop, with sticky notes and a phone on the desk
In this article
  1. How contact chaos starts
  2. What it really costs you
  3. What order looks like in practice
  4. What changes in invoicing
  5. How to switch without a big project
  6. What the day looks like once it is solved

A client calls to say the invoice went to the old address. You check the spreadsheet and the address is right. You check the invoicing program and it shows a different one. The email signature has a third. Nobody did anything wrong. Every detail simply lives in a different place and gets updated at a different time.

Almost every company that grew step by step knows this. The client list starts as one sheet in Excel, a year later there are three versions, and nobody knows which one is current.

How contact chaos starts

Nobody chooses it on purpose. It builds up through small steps that make sense at the time:

  • A salesperson saves a number in their phone because they need it right now.
  • The bookkeeper creates a separate spreadsheet so invoice details are correct.
  • A colleague sends a quote, and the new contact person stays only in their inbox.
  • A client moves offices but only tells the person they happened to call.

A few months later you have three versions of one client. None is completely wrong and none is completely right.

What it really costs you

The cost never shows up on an invoice, so it is easy to underestimate.

  • Retyping. You enter the same data several times: in the sheet, in invoicing, in the quote.
  • Errors on documents. A wrong company ID, an old address or incorrect payment terms mean corrected invoices and explanations.
  • Time spent searching. Who is the decision maker at this client? Which rate applies since January? You look for the answer in three windows.
  • Dependence on one person. When a colleague leaves or is on holiday, part of what you know about clients goes with them.

None of these losses appears as a single line in your reports. That is why the chaos is usually fixed only after an embarrassing mistake.

What order looks like in practice

The principle is simple: each client has one record and everyone works with the same one. According to the Clients module page on andromia.com, this is how it works in Andromia:

One record per client

For a company you keep the company ID, tax ID and VAT ID, for a private person the first and last name. Notes and custom fields come on top.

Data from the register

You enter the company ID or name, and tax numbers and address are filled in from the company register. No retyping, no typos.

Contact persons

You add people to the client with their role, email and phone, and mark one as the main contact. The team knows who to call.

Addresses, payment terms and rates

The delivery address can differ from the correspondence address. A client has its own payment terms, default currency and billing email. The hourly rate applies from a chosen day, old rates stay in the history, and you can schedule a change in advance.

Two colleagues looking at a clear client list on one screen

What changes in invoicing

The biggest difference shows when you create a new invoice. You pick the client from the list, and their details and payment terms fill in on their own. The invoice takes them from the client record, so there is no old address to pull in.

If something changes, you update it in one place. The next invoice already uses the new version.

How to switch without a big project

You do not need a week of downtime. This approach works well:

  1. Pick the source you trust most (usually the bookkeeper's sheet or your invoicing program).
  2. Start with the most important clients, the ones you invoice regularly.
  3. For each, fill in the register data by company ID and check the main contact.
  4. Add the others gradually, whenever you issue them a document or they call.
  5. Leave the old sheet read-only and archive it after a while.

If you already have years of data in another system, get in touch. When you switch, we will help you move the data, so you do not have to retype anything.

What the day looks like once it is solved

A client calls and you open their record. The main contact, address and payment terms are right in front of you. You issue the invoice in a minute without wondering whether the address is correct. The colleague on holiday left you order, not a puzzle.

The Clients module is included in the Basic, Team and Complete plans. The trial lasts 14 days free of charge and runs on the Complete plan, so you can try everything. Take a look at the Clients module or create a trial account right away.

Slovak business generates data Start putting it to use

Look up your first company today, or arrange a demo for your whole team.

Sample Company s.r.o.Search
Free searchNo sign-up
Book a demo