Business

CRM for a Small Business: Excel, Off-the-Shelf CRM or Custom CRM?

CRM for a Small Business: Excel, Off-the-Shelf CRM or Custom CRM?

Almost every small business has some kind of CRM, even if it does not call it that. Sometimes it is an Excel spreadsheet of clients, sometimes a Google Sheet of inquiries, and sometimes a notebook, an inbox and the owner’s memory. The question is not whether you need a record of clients and jobs, but which tool fits your size, the way you work and your plans.

In this article we give an honest comparison of three options: spreadsheets (Excel or Google Sheets), off-the-shelf SaaS CRM systems and a custom CRM. Each has its place, and for many companies the right answer is the simplest one.

What does a small business actually need to track?

Before choosing a tool, define what you want to know at any given moment. For most small businesses, that is:

  • Clients and contacts: company, contact person, phone, email, notes, source (referral, Google, social media).
  • Inquiries: who got in touch, when, about what, and what stage the conversation is at.
  • Quotes: what was offered, when, for what amount and whether it was accepted.
  • Jobs or projects: what was agreed, who is working on it, deadlines and status.
  • Invoices and payments: what has been invoiced, what has been paid, what is overdue.
  • Reminders: when to call, when to resend a quote, when a contract or subscription expires.

If you can find this information quickly today, your system works. If you have to dig through emails, messages and several spreadsheets, it is time for a change. We wrote more generally about choosing a CRM in our article CRM systems: how to choose the right one for your company.

Excel or Google Sheets: when is it enough?

A spreadsheet is a great place to start. It is free or already paid for, everyone knows how to use it and you can adapt it in a few minutes. For a business of one or two people with a smaller number of clients, a well-organized spreadsheet is often perfectly sufficient.

Advantages of spreadsheets

No extra cost, no learning curve, complete flexibility with columns, easy filtering and sorting, the data stays with you.

Limitations of spreadsheets

No automatic reminders, formulas break and rows get deleted easily, it is hard to link one client to multiple jobs and payments, several people working at once creates confusion, no per-client change history.

What are the signs you have outgrown Excel?

  • You have several spreadsheets that reference each other (clients, jobs, payments) and you keep reconciling them by hand.
  • The same client is entered in several places with different details.
  • You forget to follow up on quotes you sent because nothing reminds you.
  • You cannot quickly answer “who owes us how much” or “which quotes are waiting for a reply”.
  • Several people work in the same spreadsheet, and someone ends up overwriting someone else’s changes.
  • The same data is retyped from the contact form into the spreadsheet, then into the quote, then into the invoice.

Tip:
Before you give up on your spreadsheet, try tidying it up: one sheet per entity (clients, jobs, payments), a unique client ID, drop-down lists for statuses and frozen header rows. Sometimes that is enough for another year of work, and a later migration becomes much easier.

Off-the-shelf CRM (SaaS): who is it for?

Off-the-shelf CRM systems such as HubSpot, Pipedrive or Zoho CRM run in the browser, are paid for by subscription and offer ready-made features: a sales pipeline, reminders, email integration, reports and a mobile app. Some have free basic plans with limitations, others offer a trial period, and plans are mostly billed per user per month. Pricing changes often, so check the current terms directly with the vendor.

When is an off-the-shelf CRM a good choice?

  • Your sales process is standard: inquiry, contact, quote, deal.
  • You want to start right away, without development.
  • Your team is willing to adapt the way it works to the tool.
  • You do not need deeper integration with local software (accounting, fiscalization, online store).

Where do off-the-shelf CRMs fall short?

Problems usually come with time. The price grows with the number of users and the features you need, and advanced options are often in more expensive plans. Local specifics, such as invoicing in KM (convertible marks) in the local format, connecting to local accounting programs or special steps in your business, are rarely supported without additional tools. Many teams end up with a CRM where they use a small part of the features while still running the rest of the business in spreadsheets.

Custom CRM: when does it pay off?

A custom CRM is a system developed for the way you work. It has only the fields, statuses and screens you need, and it can be connected to your website, invoicing and other tools. It is not the right option for every company, but for some it is the only one that truly fits.

It makes sense if

You have a specific process that off-the-shelf tools do not cover, you need integrations with your website, online store or local software, you want the data on your own server, you have a long-term growth plan.

It does not make sense if

Your process still changes every month, you are a one-person team with a small number of clients, there is nobody to define what the system should do.

Another advantage of a custom solution is that it can grow gradually: you start with clients and jobs, and later add quotes, invoices, reports or a client portal. To see what such systems look like, visit our CRM systems page, and for the broader possibilities, our page on custom solutions.

If off-the-shelf tools do not cover your process, see how we build custom web solutions for companies in Bosnia and Herzegovina.

What does the comparison look like in one table?

Criterion Excel / Sheets Off-the-shelf CRM Custom CRM
Upfront cost Minimal Low, subscription Development
Time to get started Immediately Quick Depends on the project
Fit with your process High, but manual Medium Complete
Reminders and automation Limited Good As needed
Integrations with local tools Manual Limited As required
Data ownership With you With the service provider With you
Multiple users Poor Good Good, with roles

A real-world example: from an Excel spreadsheet to an in-house CRM

A small web studio ran its business in a single Excel spreadsheet for years: each row was one job, with columns for the client, description, amount, invoice date and payment status. While there were few jobs, the system worked. Over time, problems familiar to many companies appeared: the same client in several rows with different details, quotes in a separate folder with no link to jobs, payments tracked by manually coloring cells and the recurring question “has this been paid?”.

Instead of a large off-the-shelf system, the studio built a simple in-house CRM with just five parts: clients, jobs, quotes, invoices and payments. Every job is linked to a client, every invoice to a job, and payments are recorded against the invoice, so the outstanding balance calculates itself. A quote is generated as a PDF from the same system and, once accepted, becomes a job with one click. The existing Excel spreadsheet was cleaned up and imported, so no history was lost.

The biggest difference was not the new features, but having a single source of truth. An overview of open quotes, unpaid invoices and active jobs is available instantly, without searching through spreadsheets and emails.

What can you learn from this example?

  • Start small: five well-connected parts are worth more than a system with a hundred features nobody uses.
  • Relationships matter more than fields: the real value is that the client, job, invoice and payment are linked, so the reports build themselves.
  • Do not throw away your history: cleaned-up data from Excel is the foundation of the new system, not junk to leave behind.
  • Integrations come later: connecting to the contact form on your website or to your accounting can be added once the foundation is working, for example through API integrations.

How do you move from Excel to a CRM without chaos?

  1. 1

    List what you actually use

    Go through the spreadsheet and mark the columns that are filled in regularly. Whatever nobody uses, do not migrate.

  2. 2

    Clean up the data

    Merge duplicate clients and standardize company names, date formats and statuses. This is the most tedious step, but the most important one.

  3. 3

    Separate the entities

    Clients, jobs and payments should be separate sheets with unique IDs linking them. That way, importing into any CRM comes down to mapping columns.

  4. 4

    Trial import and parallel running

    Import the data, check it against a few clients you know well, and run both systems for a short time until you are sure everything is in place.

  5. 5

    Lock the old spreadsheet

    Once the CRM is up and running, archive the old spreadsheet as read-only. Two active systems are worse than one bad one.

Who owns the data, and what does the law say?

A CRM contains personal data: names, phone numbers, email addresses and communication history. In 2025, Bosnia and Herzegovina adopted a new Law on Personal Data Protection (Zakon o zaštiti ličnih podataka, Official Gazette of BiH, “Službeni glasnik BiH” No. 12/25), aligned with the GDPR, which has applied since October 2025. This means you need to know what data you keep, why, for how long and who has access to it, regardless of the tool.

  • With an off-the-shelf CRM: check where the data is stored, what data processing agreement the service provider offers and how you can export the data if you decide to leave.
  • With spreadsheets: be careful about who has the link or a copy of the file, and do not send spreadsheets containing client data by email.
  • With a custom CRM: the data is on your server, but you are responsible for backups, access and security.

For your company’s specific obligations, consult a lawyer or the competent personal data protection authority. You will also find general privacy guidelines in our article GDPR and privacy on the web.

Warning:
Before choosing an off-the-shelf CRM, check whether you can export all your data in a standard format (CSV or Excel), including notes and history. If exporting is not simple, switching to another system later can be expensive and slow.

How do you make the decision?

If you are a small business with a simple process, start with a well-organized spreadsheet. If you need more people in the system and a standard sales flow, try an off-the-shelf CRM during a trial period. If your business does not fit ready-made templates, or you need connections to your website, online store and invoicing, consider a custom CRM, together with process automation that eliminates manual retyping.

A CRM that follows the way you work

NEVIS develops custom CRM systems for small and medium-sized businesses: clients, inquiries, quotes, jobs and payments in one place, including migration of your existing data from Excel. Timelines depend on the project and the scope of features.


Request a quote

Frequently asked questions

Is Excel enough as a CRM for a small business?

For a business with one or two people and a smaller number of clients, a well-organized spreadsheet is often enough. Problems arise when several people work in it at the same time, or when you need reminders or links between clients, deals and payments.

What are the signs that a business needs a real CRM?

Duplicate clients, several spreadsheets you reconcile by hand, forgotten quotes with no reminders, and no quick way to see who owes you how much. If you recognize yourself in several of these points, it is time for a change.

Are off-the-shelf CRM systems free?

Some, like HubSpot and Zoho CRM, have free basic plans with limitations, while most advanced plans are paid per user per month. Pricing changes, so check the current terms with the vendor.

How do you move data from Excel to a CRM?

Remove duplicates, standardize formats, and split clients, deals and payments into separate sheets with unique IDs. Then do a trial import, run both systems in parallel for a short time, and finally lock the old spreadsheet.

Who owns the data in a CRM?

You are responsible for your clients' personal data regardless of the tool. With an off-the-shelf CRM, check where the data is stored and how you can export it. With a custom solution, the data is on your server, but you are responsible for backups and security.

Related articles

More in Business
Quote in 24 hours

Need help with your website or online store?

Briefly describe what you need. We send a quote within 24 hours, with no obligation.

  • Reply within 24 hours
  • 30 days of support after launch
  • Everything is yours: code, design and domain
Either one is enough.

No obligation. We reply within 24 hours.

Protected by reCAPTCHA. The Google Privacy Policy and Terms of Service apply.