A spreadsheet is a perfectly good way to start a service business. It is free, flexible and you already know how to use it. For a while it does everything you need. Then, gradually, it starts to cost you time and money in ways that are easy to miss.
Signs the spreadsheet has stopped working
- More than one person edits it, and you are never sure which copy is current.
- You check it before every "yes" and still worry about double bookings.
- Working out who owes what means checking the sheet against your bank account.
- Inquiries live in your inbox, bookings in the sheet and deposits somewhere else.
- Following up quiet leads depends entirely on you remembering.
- Nobody else could run the business for a week if you were away.
None of these is a disaster on its own. Together they add up to hours every week, and the occasional expensive mistake.
Decide what to move
You do not need to move everything. Move what you will use, and archive the rest.
Customers
Names, emails, phone numbers and any notes that matter for future work. Past customers are worth bringing across because they book again and recommend you to friends.
Future bookings
Every confirmed booking from today onwards, with the date, times, venue, package, price and anything you have promised. These matter most. Leaving one behind is how a double booking happens in your first week.
Money owed
For each future booking, what has been paid and what is still due, with the due dates. Get this right before you stop using the old sheet, because chasing a customer for a balance they have already paid is a poor start.
Packages and prices
Your current packages, extras and peak-date rules. This is a good moment to tidy them up and retire the packages nobody buys.
Open inquiries
Leads you are still talking to, with where they came from and what you last said to them.
Clean the data first
Whatever is messy in the spreadsheet will be messy in the new system. An hour of tidying before you import saves many hours afterwards.
- Keep one row per customer and one column per kind of detail. Split a "name and phone" column into two.
- Remove duplicates, or at least mark them, so the same couple does not appear twice.
- Write dates the same way all the way down.
- Put amounts in their own columns as plain numbers, without currency symbols or notes.
- Delete test rows and anything you would not want a colleague to read.
Then save the cleaned sheet as a CSV file. Most software reads CSV, and it drops formatting that can confuse an import.
Run both side by side, briefly
For a short period, often two to four weeks, keep the spreadsheet as a reference while all new work goes into the new system. Do not enter bookings in both. Double entry is where mistakes creep in, and it delays the moment the new system becomes the single place everyone trusts.
During those weeks, check the new system against the old sheet: every future date present, every balance correct, every package priced as before. Once you have checked them all, archive the spreadsheet and stop opening it.
Pick a quiet time to start. A Monday in your slow season is far better than the week before your busiest weekend.
Tell the team
If other people take bookings, work events or answer the phone, they need to know what is changing and when. Give them a date from which the new system is the only place bookings go. Show each person the few things they will actually do in it, rather than every feature. Make it easy to ask questions in the first few weeks, and expect plenty.
Customers rarely need an announcement. What they will notice is clearer quotes, an easier way to pay and fewer emails asking for details they have already given you.
Doing this in Occanovo
Occanovo reads a CSV file or rows pasted from a spreadsheet, matches the columns from their headings, and shows who is new, who is already in your list and who appears twice before anything is saved. Imported leads never get the instant reply or follow-up reminders, and you can undo an import for seven days. The moving from another tool page walks through it, and you can try everything free with no card (see pricing).