Running a Repair Shop on Spreadsheets

Every repair shop starts on a spreadsheet. Yours, mine, the guy across town with the neon sign. Day one, you make columns for name, phone, device, problem, and price, and you are in business. Here is the part nobody selling software says out loud: it works. Genuinely. You took in every device yourself, so you remember every device. It costs nothing, loads instantly, and never makes you watch an onboarding video. Spreadsheets got your shop this far. They deserve respect, not a sales pitch.

But they have a failure curve, gradual, then sudden, and it breaks in the same places at almost every shop. Here is the tour.

Intake: the passcode nobody can read

A customer drops off an iPhone at 9:40 on a Tuesday. The passcode goes on the paper ticket, scribbled while the phone is ringing and someone else is asking about a charging port. At 2:00, your tech picks up the device and stares at the ticket. Is that a 4 or a 9? Is the 1 actually a 7? He tries twice, stops before the phone locks itself for an hour, and calls the customer, who is at work and not answering. The repair is done by 2:15. Nobody can get into the phone.

The spreadsheet has a row for this job. The passcode is not in it. The passcode is on paper, and paper has a half-life of about a day in a working shop.

Status: the sheet lives on one PC

The sheet lives on the front counter machine, because that is where intake happens. You are at the bench, ten minutes into a heat gun job, when the phone rings. “Hi, just checking on my laptop?” You set the board down, walk up front, wiggle the mouse, scroll to row 214, and report that it is waiting on a part. Walk back. The board has cooled. Start over.

That call takes four minutes, you get a handful of them a day, and every one is a question the customer would answer themselves if the answer lived anywhere they could see it.

Communication: the texts leave with the tech

Your best tech texts customers from his personal phone. You let it slide because it works, customers love him, approvals come back fast. Then he moves to Arizona. The new tech inherits the bench but not the threads. Every quote, every “yes, go ahead and replace it,” every photo of water damage that justified a charge, all of it lives in a phone that no longer works at your shop. Three weeks later a customer disputes a $280 repair, and your proof is in Arizona.

Money: the deposit lives in a cell

The $50 deposit goes in column H. The invoice is a Word template, Save As, customer’s last name, print. At month end the card terminal says you took one number and the spreadsheet says another, and the difference is hiding somewhere in fourteen Word docs, two refunds nobody noted, and one cell somebody overwrote sorting the sheet without selecting all the columns. You will find it eventually, on a Sunday, with a calculator and a bad attitude.

Memory: the customer from last year

A man walks in and swears you replaced this exact screen eight months ago and it should be under warranty. Maybe you did. That would be in “REPAIRS 2025,” a different file, sorted by a column that no longer exists, where his name is spelled two different ways. Your options: eat a screen you maybe should not, or argue with a customer while holding no evidence. Both cost money. One also costs the customer.

Reporting: revenue is a guess

Tax time. Or just a Tuesday when you wonder whether board-level work actually makes money or just makes you feel skilled. Revenue is whatever the SUM at the bottom claims, minus the rows from the week you were slammed and nobody typed anything. Hours are a photo of the whiteboard. Payroll is not a calculation, it is a negotiation. You are running a real business on numbers you would not accept from a parts supplier.

The tipping point is not size

Those scenes share one thing, and it is not ticket volume. A spreadsheet survives almost any volume as long as exactly one person uses it. The day it dies is the day you hire your first tech, or your spouse starts covering Saturdays, and two people need the same information at the same moment. One of you has the file open. The other gets the locked-for-editing warning, or worse, a second copy, and now there is a “REPAIRS FINAL v3 (Conflicted copy)” and nobody knows which one is true.

The spreadsheet was a single-player tool all along. You never noticed, because you were the only player.

What “a system” actually means

Not enterprise software. Not a six-week rollout. A system just means each breaking point finally has a home:

• Intake becomes repair tickets: the passcode is typed once, attached to the device, legible forever, next to the intake photos that settle “that scratch was already there.”
• Status calls stop because status automations text the customer when the state changes, and a customer portal lets them check on the laptop at 11 p.m. without calling anyone.
• Texts become messages on the ticket, sent from the shop’s number. When a tech leaves, the threads stay.
• The deposit and the invoice live in one place with invoices and payments, so the month reconciles itself instead of reconciling you.
• Last year’s customer is one search away, with every repair and warranty date attached to their name, and a merge tool for the duplicate spellings you brought with you.
• And reports turn revenue into a number instead of a guess, and payroll hours into a time clock instead of an argument.

The switch is smaller than you think. Your spreadsheet exports to CSV, the importer reads CSV, and CSV is CSV. A typical spreadsheet import runs in an afternoon, with a preview before anything commits and a rollback if it lands wrong. It turns out the sheet was a decent export format all along.

Keep it, until the day you can’t

The honest ending: if you are doing five tickets a week, keep the spreadsheet, with our blessing. It is the right tool, and we would tell you that to your face. But the day it is twenty, start counting: the walks to the front PC, the locked file, the eaten warranty screens, the Sunday with the calculator. The sheet is not free anymore. It is just unbilled.

When that day comes, start free, import the sheet, and give it the retirement it earned.