When your spreadsheet becomes the business

Almost every business we work with has one. A spreadsheet that started as a quick list of jobs, customers, or inventory, and quietly became the thing the whole operation runs on. It has a dozen tabs, colors that mean something, and one person who really understands it.

Spreadsheets are a great way to start. They’re flexible, everyone already has one, and they cost nothing. The trouble is that they don’t tell you when you’ve outgrown them. You find out when something goes wrong.

Signs it has outgrown itself

• Only one person really knows how it works. If they’re out sick or leave, the business slows down while everyone else tries to figure out what column K means.
• People keep overwriting each other. Two people edit the same file, someone saves an old copy, and a week of updates disappears. Or there are three versions named “FINAL” and nobody is sure which one is current.
• You’re typing the same thing twice. A job goes into the spreadsheet, then into the invoice, then into an email to the crew. Every copy is a chance for a typo.
• Everyone can see everything. The sheet with job schedules also has pay rates, customer phone numbers, or margins, and there’s no clean way to show each person only their part.
• Simple questions take an afternoon. “How many jobs did we do in March?” or “Which customers haven’t been back in a year?” means filtering, copying, and hoping the formulas held.
• It doesn’t work on a phone. People in the field can’t update it, so someone transcribes their notes later.

One or two of these is normal. If you nodded at four, the spreadsheet is costing you real time every week.

What a web app replaces it with

A web app is a private website your team logs into. It does the job your spreadsheet was doing, but it’s built around how your business actually works instead of rows and columns.

• Everyone works from the same live data. No copies, no “which version.” Two people can work at once without stepping on each other.
• Each person sees what they need. A crew lead sees today’s jobs. The office sees billing. The owner sees everything.
• Entry happens once. A job entered in the morning can fill in its own invoice and show up on the crew’s schedule, without anyone re-typing it.
• Answers are a click away. The reports you rebuild by hand every month become a page that’s always up to date.
• It works on a phone. Crews can update a job from the truck.

We build these with Django, a mature, secure framework that powers some very large sites. It’s also very good at small, practical tools like this.

What the switch actually looks like

People worry this means a huge project and a painful changeover. It usually doesn’t.

1. We start with your spreadsheet. It’s the best spec there is, because it shows exactly what you track and how you use it.
2. We build the smallest useful version first. Often that’s just the one tab everyone fights over.
3. We bring your existing data in, so nobody starts from a blank screen.
4. We add the rest in steps once the first part is earning its keep.

You can keep exporting to a spreadsheet whenever you want one. The difference is that it becomes a report you pull, not the system everything depends on.

Have a spreadsheet that’s starting to run you? Send us a description of it and we will tell you honestly whether it’s worth turning into an app yet.