A notebook and a spreadsheet have one big advantage: they are free for the first few years. The trouble starts when your job history becomes valuable. A customer asks, “What did you do to my bike last year?” and you flip pages. Your accountant wants last month’s totals and you add up a column by hand. A technician asks whether the part for that scooter has arrived, and the answer is in a text message from last week.
This article is a plan for switching: what to move, what to leave behind, in what order, and how long it takes.
What running a shop on paper costs
Here are three costs you can put a number on. The numbers below are an example, not a statistic. They assume your own time is worth $40 per hour and a 22-day working month. Swap in your own figures.
- “Is it ready?” calls. 20 calls a day at 3 minutes each is one hour a day. Over 22 days that is 22 hours, or about $880 a month spent answering a question the work order already knows the answer to.
- Hunting for device history. 15 minutes a day of flipping pages, calling and scrolling messages is about 5.5 hours, or roughly $220 a month. In busy season, double it.
- Disputes about condition at intake. One unrecorded scratch on a screen or a rim can cost as much as a new part. Without a written record of the device’s condition, you cannot settle it.
That example adds up to about $1,100 a month in time that mostly disappears after the first month on a system. There is also a cost that is harder to measure: jobs that are finished but never billed, because someone picked up a device before a price was written down.
What to move first
Not everything deserves to be moved. In order of importance:
- Customers with phone numbers. This is the list you use to reach people, and the one asset you cannot rebuild from anything else. Name, phone and email are enough.
- Open work orders. Whatever is on your shelves today: what came in, when, for how much, in what condition. Either close these in the old system or move them deliberately.
- Your price list. If it lives in your head, now is the time to write it down. SerwisOS industry presets include a starter price list that you edit to match your prices. Treat it as a starting point.
- Customers’ devices with serial numbers. Frame numbers, IMEI numbers, VINs and serial numbers are what turn separate jobs into a history.
- Closed jobs from last year. Leave them where they are and look them up only if there is a dispute. Nobody reads them in daily practice.
A common mistake is trying to move everything at once. The migration drags on for three months and you end up running two systems forever.
The week you switch
A plan for seven days, without pausing intake:
- Monday and Tuesday: Create your account in the sign-up wizard, enter company details and opening hours, and review the preset price list against your real prices.
- Wednesday: Enter or import customers. A thousand customers is an evening of work in a spreadsheet. Load the spreadsheet as an XLSX or CSV file yourself in the panel (Settings, Data import): customers, devices, the service price list, parts and job history, with a preview of errors and duplicates before saving. Save an old XLS file as XLSX or CSV first. An unusual format or a large database is moved by our team: contact us.
- Thursday: Devices and open work orders. Every device on the shelf gets a record and every open job gets a stage.
- Friday: A test intake with a real customer. Fill in the intake fields, take down the amount, and send a test email update to your own address.
- Weekend: Check what drifted. Fix stages and fill in missing prices.
From the following Monday, new work orders exist only in the system. Keep the old notebook in a drawer in case of a dispute about history. Agree on one rule with your team: nobody takes in a device “on a slip of paper and I will enter it later,” because the entering-later step never happens.
Also name one person who answers the team’s questions during the first week, so nobody drifts back to the notebook whenever something is unclear.
Prepare three files before you start
Before you move anything, export or write down three things from your old setup: the customer list (name, phone, email), the list of open jobs, and the price list. Even if you enter everything by hand, these three files cut the work roughly in half. See the migration page for how we handle moving data.
Take a few minutes to deal with duplicates in the customer list. The same phone number saved as “John K. Smith” and “Smith, John” becomes two records after the move, and the device history splits in two. In a spreadsheet, sort by phone number and merge the matches. It is easier to do in the old file, where you can compare rows side by side.
What else goes wrong in a spreadsheet
A spreadsheet is a fine tool for one-off reports and a poor foundation for several people working together. These are the problems shops describe before they switch:
- Two files and no single truth. The owner keeps jobs, the technician keeps devices, and nobody knows which file is newer. After the busy season, merging takes longer than the season did.
- The formula that ate a total. One typo in a sum formula and half a month of numbers is wrong. Nobody notices because “the spreadsheet calculated it.”
- History in text messages. What you agreed with the customer (“an aftermarket part is fine,” “email me, don’t call”) sits in threads on personal phones. When a dispute comes, the messages are gone along with the old phone.
- Consent on paper. A box of signed forms works until you need to find one specific person’s form. In the system, a privacy consent record has a date and the version of the text the customer agreed to.
None of these is about the repair itself. They are about the information around it, and that takes your evenings.
Two traps to avoid
Work order numbering. Do not continue the old numbering “seamlessly” without writing it down. The new system numbers work orders in its own series. Note the date from which the new numbering applies. Your accountant, and any future dispute, will thank you.
Photos of old jobs. If you have photos of device condition on a shop phone, move them while you are re-entering jobs. A photo from last year settles an argument about a scratch faster than any note.
You can create an account with the full core (work orders, customers, devices, price list) in the sign-up wizard. The starting cost is zero, with no limit on work orders, and plan details are on the pricing page. Want to estimate how long it would take to move your data? Write to us and send a sample of your spreadsheet.