From paper to my own ERP

I started with jobs
on paper too. I went through Excel. Now I've taken it into my own hands.

A macro-enabled template for tracking jobs, customers, and parts — the same one I used in my workshop for years.
And the story of why I finally left it and built Sigma System. Read on below.

Download the free Excel template
Již stáhlo 164 lidí — bez registrace, zdarma

How Sigma System came to be

This isn't marketing. It's a true story of how, as a service technician, I looked for a system to track jobs — and in the end had to write one myself.

1
Phase 1 — Beginnings (2012)

📋 Paper job book

At 18 I started repairing cars and kept my records the classic way — an A4 notebook, pens, a binder.

Paper tolerates everything, but paper doesn't catch mistakes. At every weekly or monthly check I found discrepancies: a crown here, a crown there — and then spent an hour looking for where it happened. The more jobs piled up, the more chaos there was.

“A customer called asking where his job was. I was flipping through papers. That's when I knew this is not how to work.”

2
Phase 2 — Excel with macros (2013)

📊 Excel with macros — better, but still with gaps

Like a modern person, I sat down at the computer and started in Excel. First a simple spreadsheet with basic job tracking. Then it needed more: stock, quotes, a vehicle card, a client card. VBA macros arrived — click a button and data moved between sheets, the job sheet generated itself. I was proud of it.

But there were still problems with data consistency, formats drifted apart, and compatibility between computers was creaking. When the file ballooned, I said to myself: enough.

"Excel is a great tool — for spreadsheets. But managing a whole workshop's jobs isn't what it's for."

3
Phase 3 — My own records → Sigma System (from 2014)

⚡ Step by step, I wrote my own system from A to Z

About a year later I stopped just filling in spreadsheets and gradually started programming my own electronic records. Simple at first, with new features added year after year — until it became an application for managing the whole business, which later got the name Sigma System. Today it covers everything from sole-proprietor records and customers through quotes and jobs to a detailed vehicle card with interval tracking (oil, STK, air conditioning). Every feature came from a real need of the workshop. The system also tracks contracts, calibrations, inspections — anything a given trade requires.

It didn't stop at functionality — the app has undergone an internal OWASP Top 10 security audit, it handles GDPR, and data is stored in a secure data center in the EU. Because workshops entrust me with data about their customers and jobs, and they take that seriously.

"In the end I had a system that does exactly what I need — nothing more, nothing less."

4
Phase 4 — Multi-industry SaaS

🔧 A friend from a metalworking shop wanted it too

A friend from a metalworking shop saw the system and really liked it. He said: "I'd need this too — but I don't have cars, I have jobs and materials." I offered it to him, added his trade, and the first system outside car repair was born. Then an electrician got in touch, then other tradespeople, such as a gardener. Each had slightly different specifics — different modules, different terminology.

That's how a single auto repair system became a multi-trade SaaS — today Sigma System covers over 26 trades, from auto repair to gardeners.

5
Phase 5 — Language versions

🇵🇱 Release to the public and the road to Poland

When people started talking about the system, it was time to release it to the public. And it went further than I expected — through acquaintances and their acquaintances it reached Poland indirectly, people in construction I had never met. They needed the same thing, only in Polish and with Polish specifics (different invoices, different VAT, a different trade). That produced the first language version and the first foreign trade in the system.

Today Sigma System is going beyond borders. Language versions (CS / SK / PL / EN) and industry localization are part of the long-term plan, because workshops all over Central Europe face the same problems with paper and Excel.

I'm proud of what I created. And it's not just one forgotten app in a drawer — 26 trades, 4 languages (CS / SK / PL / EN), hundreds of workshops and tradespeople across Central Europe. Every one of them started the same way I did — with paper or Excel. Every one of them wanted something that simply works.

Tomáš Gončár — founder
🔧
Tomáš Gončár
Owner of the Togo Servis car repair shop, Vratimov
Own records since 2014 · Sigma System 2022–present
  • In the car world since 2012
  • Went through it himself: paper → Excel → his own ERP
  • I develop Sigma System for my own shop too
  • Every feature came from a real workshop need

Download the Excel template for jobs

The same template I used in my workshop for years. It has macros for the job sheet, customer records, and a repair status overview. If Excel still works for you — take it, it's free.

📊

Job tracking — Excel template (.xlsm)

Sheets: Customers · Jobs · Parts · Repair status · Job sheet (print)
Macros: automatic job ID, labor price calculation, job sheet printing
Proven in practice in a car repair shop · Works in Microsoft Excel 2016+

Stáhnout zdarma (.xlsm) Již stáhlo 164 lidí

Macros work reliably only in Microsoft Excel. You need to enable macros when opening. No registration, no email.

6 things Excel simply can't do

Excel is a great tool — for spreadsheets. But managing jobs in a workshop takes more. Here are the things I ran into every day.

📱

Not accessible from mobile

Under a car, in the paint shop, on the way to a customer — you don't have a computer with you. Excel on a phone is unusable, especially with macros.

👥

One file = one user

Colleagues can't work at the same time. Whoever has the file open, the others wait. With another technician it stops working.

💥

A deleted macro = lost data

Excel can be broken with a single click. Without a backup from today, you lose your jobs. It happened to me. It taught me a lesson.

📱

No SMS to the customer

“Where is my job?” — the customer calls every hour. Excel won't help you with an automatic notice that the work is done.

🧾

Invoice by hand, separately

An invoice isn't generated from a job sheet in Excel. You retype the data into an invoicing program or Word. A waste of time.

📊

No real-time overview

How many jobs are open today? How much money is waiting to be paid out? In Excel you'll find out — after 10 minutes of filtering.

Excel vs. Sigma System

Features 📊 Excel (template) ⚡ Sigma System
Job tracking ✓ Yes ✓ Yes, online
Mobile access (phone) ✗ Practically no ✓ Full-featured
Multiple users at once ✗ No ✓ Unlimited
SMS to the customer ✗ No ✓ Automatically
Invoice in one click ✗ No ✓ PDF by email
Inspection reminders, service book ✗ No ✓ Included
Data backup ✗ Manual, risk of loss ✓ Automatically, daily
Price Free Starter Free for free
Tip for switching

You don't have to switch all at once. Download the Excel template and use it. When you feel you're hitting its limits (mobile, a colleague, SMS) — create a Starter Free account in Sigma System. You import customers from CSV and retype jobs in an afternoon.

Switch from Excel to a system?

Job management Free job management ERP for small businesses Free CRM
free

Starter Free — Sigma System for free

The basic plan is free. No time limit. If it doesn't suit you, you can always go back to Excel. The template stays with you.

Try the demo
  • No commitment
  • Data in a secure data center in the EU
  • Access from phone and computer

FAQ

Is the Excel template really free?

Yes, no strings attached. You download it, adapt it to your needs, and use it as long as you like. We don't ask for your email or phone number.

Does the template work in LibreOffice or Google Sheets?

The template is in .xlsm format (Excel with macros). Macros work reliably only in Microsoft Excel 2016+. In LibreOffice or Google Sheets the basic spreadsheet opens, but the macros (job sheet, calculations) won't run.

How do I move data from Excel to Sigma System?

Customers can be bulk-imported from a CSV file. The easiest way to bring in historical jobs is to enter the last 3–6 months by hand — it usually takes one afternoon. You can keep older history in Excel as an archive.

What can Sigma System do that Excel can't?

Mobile access from anywhere, multiple users at once without conflicts, automatic SMS to the customer when a job is finished, an invoice from a job in one click as a PDF by email, history for every vehicle and customer, a real-time job overview on the dashboard — and your data is backed up, so you can never delete a file by accident.

How much does Sigma System cost?

Starter Free is free. Paid plans (Garáž, Pracant, Mistr) start at 390 Kč/month and add SMS, advanced invoicing, and priority support. Detailed pricing is at sigmasystem.cz/#cenik.