What frightens business owners most when changing systems is not learning the new one, it is the fear of losing years of data. Migrating data to a new system can be done safely if you follow a clear order, and that is what we do on every project.
What to move, and what to leave
Not everything is worth moving. Split your data into three:
- Essential, must move: customers, items, suppliers, staff, opening balances.
- Historic, for reference: old invoices, enough to keep as files or a read-only record.
- Worthless: duplicates, discontinued items, customers with no activity for years.
The steps
1. Take stock of what you have
Where does your data live today? Excel files, an old program, paper books, staff phones. List every source and who owns it.
2. Clean before you move
This is the most important step. Look for duplicates ("Mohammed Ali" and "Mohammed Ali "), empty fields, phone numbers in different formats (968 or +968 or no code), and items with several names. Moving dirty data moves the problem with it.
3. Standardise the formats
One code per item, one phone format, one date format, and rials with three decimals.
4. Trial with a small batch
Move a hundred customers and a hundred items first and review them by eye. Mistakes are cheap here.
5. Opening balances
Choose a changeover date (often the first of the month) and record customer, supplier, stock, cash and bank balances as of that day. Check them against the last trial balance.
6. Run both systems in parallel
For two weeks to a month, enter in the new system and compare results with the old: sales, stock and balances. When they match with full confidence, stop the old one.
7. Keep a full copy
Do not delete the original. Keep a copy of every old file and its database in a safe place.
Common mistakes
| Mistake | Result |
|---|---|
| Moving files without cleaning | Duplicate customers and mismatched balances |
| Changing systems mid-month | Hard to reconcile |
| Switching the old one off at once | Nothing to compare against when something is wrong |
| Relying on one person who knows the files | Work stops if they are away |
What we do
We ask for your files as they are, and we clean them with you, move them and run the comparison, because this step is part of building the system, not an extra. See examples of an inventory system and a customer system, then build your spec or contact us and send us a sample of your files.
A simple clean-up sheet before moving
| Field | Check | Quick tool |
|---|---|---|
| Name | Duplicates, extra spaces, variant letters | Sort alphabetically then review |
| Phone | One format with country code | Bulk replace |
| Valid format | Filter | |
| Item | One code and one name | Duplicate list |
| Prices | In rials with three decimals | Cell formatting |
| Dates | One format | Convert text to date |
A hypothetical example: a shop moving three thousand customers
(Illustrative figures.) Cleaning finds 400 duplicate records, 250 with no phone and 90 with numbers in mixed formats. After cleaning about 2,300 valid customers remain. It moves a hundred trial customers and compares balances, then the rest. The result is a system with real customers and not inflated numbers, and WhatsApp campaigns that actually arrive.
Security during the move
Files holding customer data should not be sent through public chat apps or unencrypted email. Use an agreed secure channel, delete temporary copies afterwards, and limit who reaches the files. Remember that personal data falls under Oman's personal data protection law.
Common questions
What do I do with the old Excel files afterwards?
Keep a full read-only copy in a safe place for a sensible period, and stop editing them so two versions of the truth do not appear.