
Every business has them: small, persistent problems that nobody planned for and everybody works around. The spreadsheet that only one person understands. The order that gets typed into three systems. The report that takes a whole Friday to assemble. Individually they look harmless. Together they quietly consume hundreds of hours a year, introduce errors and make growth harder than it needs to be.
Custom software is not always the answer — sometimes a configuration change or an off-the-shelf tool is better. But for a surprising number of everyday problems, a small, well-built piece of software makes the issue simply disappear. Here are twelve of the most common ones we see, how to recognise them and what the solution typically looks like.
Key takeaways
- Most “technology problems” in small businesses are really data problems: information lives in the wrong place or is entered more than once.
- The best candidates for custom software are frequent, rule-based tasks that are specific to how you work.
- Small internal tools often pay for themselves within months, without replacing your existing systems.
- Start with one painful process, measure the time it costs, and solve that before thinking about a big platform.
1. The spreadsheet that runs the business
The symptom: a critical spreadsheet — orders, stock, schedules, pricing — that has grown for years. It has hidden tabs, fragile formulas and one person who “knows how it works”. Two people cannot edit it safely at the same time, and nobody is sure which version is current.
The fix: a simple web application with a proper database, user accounts and permissions, an edit history and validation rules. Users keep a familiar table-like interface, but data cannot be accidentally overwritten and everyone sees the same truth. Importing the existing spreadsheet is usually the first step, so nothing is lost.
2. Typing the same data into several systems
The symptom: a new customer is entered in the CRM, then the accounting software, then the project tool, then the newsletter platform. Each copy drifts out of date and typos multiply.
The fix: an integration layer that treats one system as the source of truth and synchronises the others through their APIs. Often this does not even require a user interface — it is a small service running in the background. See our guide on business process automation for how to choose which flows to connect first.
3. Reports that take a day to build
The symptom: every week or month somebody exports CSV files from several tools, pastes them into a workbook, fixes the formatting and emails a PDF. The report is late, manual and occasionally wrong.
The fix: an automated pipeline that collects the data on a schedule and feeds a live dashboard. Managers see current numbers whenever they want, and the person who used to build the report gets their Friday back.
4. Leads that fall through the cracks
The symptom: enquiries arrive by web form, email, phone and social media. Some get answered quickly, some wait days, some are never answered at all. Nobody knows the conversion rate.
The fix: a single intake process that captures every lead in one place, assigns an owner, sets follow-up reminders and records the outcome. This can be built around an existing CRM or as a lightweight custom tool if your sales process is unusual.
5. Quotes that take too long
The symptom: preparing a quote means looking up prices, calculating materials or hours, applying discounts and formatting a document. It takes an hour, and customers who wait go elsewhere.
The fix: a quoting calculator that encodes your pricing rules, produces a professional PDF in seconds and stores every quote for follow-up. Rules change? Update them once, centrally, instead of in a dozen templates.
6. Scheduling chaos
The symptom: appointments, field visits or shifts are managed with a shared calendar, a whiteboard and many phone calls. Double bookings happen, and last-minute changes are not communicated.
The fix: a scheduling tool tailored to your constraints — skills, locations, equipment, travel time — with automatic confirmations and reminders by email or SMS. For many businesses, a configured booking platform is enough; custom software is worth it when your rules are complex.
7. “Where is my order?” calls
The symptom: customers call or email to ask about status, and staff have to look it up in several places before answering.
The fix: a customer portal or automatic status notifications triggered by real events in your system. Every avoided call is time saved on both sides, and customers trust a company that tells them what is happening before they ask.
8. Paper forms and manual approvals
The symptom: purchase requests, holiday requests, inspection checklists or delivery notes still travel on paper or as email attachments. Approvals get stuck in inboxes.
The fix: digital forms with built-in validation, routed automatically to the right approver, with mobile access and an audit trail. Field staff can complete checklists on a phone, even offline, with photos attached.
9. Inventory you cannot trust
The symptom: the system says there are 40 units, the shelf says 12. Sales promise stock you do not have, or you over-order to be safe.
The fix: barcode or QR scanning at every movement, integration with your sales channels, and alerts for low stock. Accurate inventory frees cash tied up in safety stock and prevents disappointed customers.
10. Onboarding and offboarding by memory
The symptom: when someone joins, accounts and equipment are set up from memory and something is always forgotten. When someone leaves, their access is not always removed — a serious security risk.
The fix: a checklist-driven workflow that creates accounts, assigns licences and requests equipment automatically, and reverses everything on departure. This connects naturally with the controls in our cybersecurity checklist.
11. Knowledge locked in people’s heads
The symptom: answers to common questions live in the heads of a few experienced employees, who are constantly interrupted. When they are on holiday, work slows down.
The fix: a searchable internal knowledge base, often combined with an AI assistant that answers questions from your own documents. Our article on practical AI for small businesses explains when this works well and when it does not.
12. Customer self-service that does not exist
The symptom: customers must email you to download an invoice, change an address, renew a subscription or book a repeat service.
The fix: a secure self-service portal. It takes routine work off your team and gives customers the 24/7 convenience they expect from larger companies.
How to decide what to fix first
You probably recognised more than one problem. Do not try to solve them all at once. Instead, score each one on three questions:
- Frequency: how often does it happen per week?
- Cost: how many minutes does it take each time, and what does an error cost?
- Specificity: is the process specific to your business, or is it something a standard tool already does well?
Multiply frequency by time to get the hours lost per year. Problems that are frequent, time-consuming and specific to your business are the strongest candidates for custom software. Problems that are generic are usually better solved by buying a tool — our build vs buy framework helps you decide.
| Problem | Usually solved by | Typical effort |
|---|---|---|
| Double data entry | Integration / automation | Days to 2 weeks |
| Manual reporting | Data pipeline + dashboard | 1–3 weeks |
| Spreadsheet as database | Small web app | 3–8 weeks |
| Complex quoting or scheduling | Custom tool | 4–10 weeks |
| Customer self-service | Portal (custom or configured) | 6–12 weeks |
What a good first project looks like
The most successful first projects are small and measurable. For example: “Reduce the time to produce a quote from 45 minutes to 5” or “Eliminate re-typing of web orders into accounting”. They are delivered in weeks, not months, and they build confidence — and budget — for the next improvement.
That is why we start custom work with a short, fixed-price Discovery & Blueprint: it turns a frustration into a costed plan you can act on, with or without us.
Frequently asked questions
Is custom software only for large companies?
No. Modern frameworks and cloud hosting make small, focused applications affordable for businesses of any size. Many useful internal tools cost less than a year of the subscriptions they replace.
Will custom software replace our existing tools?
Usually not. Most projects connect and extend the tools you already use rather than replacing them, which keeps cost and disruption low.
How do we avoid depending on one developer?
Insist on code in a repository you own, documentation, automated tests and mainstream technologies. That way any competent team can take over.
How long does a typical small tool take to build?
Focused internal tools are often delivered in four to eight weeks, including design, testing and training.
The bottom line
Everyday problems deserve attention precisely because they are everyday: their cost compounds. Pick the one that annoys your team the most, measure it, and fix it properly. If you would like a second opinion on where to start, tell us about it — the first conversation is free.