Guide

Migrating Old Client and Sales Records to New Software

It is possible not to lose the past when moving to new software. CSV preparation, back-dated records and verification steps.

· 5 min read

The most common reason owners give for putting off the move is the question "what will happen to my old records?" The answer: the client list is imported in bulk, and past sales and payments are entered one by one with their dates. You do not have to move everything; setting priorities right is enough.

Client list: bulk import with CSV

  1. In Excel, arrange the columns like this: Full Name, Phone (required), Email, Gender, Birth Date, Address, Note, Registration Date.
  2. Merge rows that contain the same phone twice.
  3. Save the file as "CSV (semicolon separated)".
  4. Upload it with Clients > Import; up to 1000 rows are taken in one go.
  5. On the result screen see the added, skipped (already registered) and faulty rows; fix the faulty ones and upload again.

Why is the Registration Date column important?

If you enter the registration date, clients open with their real registration dates, not "added today". This keeps "how long have they been our client" accurate, along with any loyalty work you do later.

Past sales and payments

Enter active packages and sales still being paid with their real dates. A user with the back-dated record permission can set the sale and payment date in the past; the package validity period also starts from the sale date. A future-dated record cannot be entered.

What should you not move?

  • Closed sales of one-time clients who came years ago
  • Old packages that are already completed and fully paid (a summary is enough)
  • Suspicious or faulty phone numbers (clean them first)

Verification

After the import, pick 10-15 clients at random and compare them with the old record: are the phone, remaining sessions and remaining balance the same? When you see consistency, turn the notebook or Excel file into an archive to look things up in.

Move your client list into Clivio

Start Your 7-Day Free Trial

Take your business digital today

Try it free for 7 days. No setup fee, no credit card needed.