Moving from spreadsheets to Odoo: a data migration checklist
Most Odoo projects that go wrong, go wrong on the data. Here is a practical order of work for moving from spreadsheets, with a sign-off at the end.
For a clearing and forwarding business, everything revolves around the job file: the shipment, its documents, the people who touched it and the money that moved. When the file lives in email threads and spreadsheets, delays and disputes follow. Here is what to expect from software built for the job.
A job should start when the enquiry arrives and stay one connected record until the final invoice. That means the quotation, the shipment and containers, the documents, the duty and other costs, and the customer invoice all link back to the same job. When someone asks "where is this one?", the answer is one click, not five messages.
Every job type needs a different set of documents. Good software gives each job a checklist, shows what is received, what is missing and what is waiting for review, and keeps versions so you can see what changed. It should also separate an uploaded file from a verified one. A document that arrived is not the same as a document that has been checked.
Clearing agents handle money on behalf of clients: duties, port charges, deposits. Software should make the difference visible between your own charges and costs you pay and recover, and track client funds so you know what has been received and what has been spent. Mixing these up is how margins quietly disappear.
Your customers should be able to see their shipments, documents and invoices. They should never see your cost prices or margin. Ask any vendor, including us, how this is enforced and how it is tested.
Software should say what is known, not what is hoped. A planned arrival, a reported arrival and a confirmed arrival are three different things. A good system labels each one and shows where the information came from, so you do not promise customers something you only assumed.
Customers phone because they cannot see what is happening. Give them a way to see the status of their own jobs and receive updates by the channel they prefer, with their consent, and the volume of "any news?" calls drops.
Tax and customs rules change. Software should make it easy to keep your invoices and records in order, but check current requirements with the tax authority and your accountant rather than relying on a vendor's summary.
We build FreightOS, a freight operating system on Odoo covering many of the areas above: jobs, documents, customs entries, sea, air and road, warehouse, billing and a customer portal. It is currently in pilot with a Nairobi logistics company, and we will tell you plainly what is built today and what is not. If you would like a walkthrough, ask us for a demo.
Most Odoo projects that go wrong, go wrong on the data. Here is a practical order of work for moving from spreadsheets, with a sign-off at the end.
The partner matters more than the software. These eight questions show quickly whether a partner will deliver, and what they will leave you with.
Book a free consultation and we will tell you honestly whether Odoo fits your business.