software-sob-medida

Is your business running on spreadsheets? Seven signs to consider custom software

The request lives in a spreadsheet, its owner was notified in a message and approval is buried in an email. Answering a progress question means searching three places.

The request lives in a spreadsheet, its owner was notified in a message and approval is buried in an email. Answering a progress question means searching three places. Spreadsheets are useful; the difficulty starts when the file can no longer represent the rules and responsibilities of the operation. Before commissioning software, identify the control that is actually missing.

Seven signals in one real workflow

Look for competing versions of a record; approvals that happen outside the file; formulas only one person understands; unrestricted access despite different roles; changes that cannot be explained; repeated copying into another tool; and work that stops when its owner is away. These are observations, not a purchasing score. One access-control problem may matter more than several organisational annoyances.

Describe the consequence of each signal: a request approved against old information, an unassigned task or a discrepancy nobody can trace. Do not invent a financial loss without measuring the work involved. If most problems concern unclear ownership, agree responsibilities before buying a system.

Map the task before selecting a tool

Choose a process such as requesting a purchase. Write down who starts it, which information is required, who checks it, who approves it and what happens after rejection. Include an actual exception and its current workaround. This exercise improves the workflow even if you keep an existing tool.

DecisionUseful evidence
What is the main record?Request, owner and identifier
Which change needs approval?Explicit rule and decision-maker
Which information is restricted?Roles allowed to read or change it
How can a discrepancy be checked?Original source, date and history

In a hypothetical purchasing workflow, clear states and an assigned owner may remove some confusion. If approval must lock subsequent changes and retain history, evaluate a workflow feature or an application rather than adding another column. A prototype should demonstrate this transition, including rejection and reopening, before the scope expands.

Build the missing capability

Custom software can centralise records, validate transitions and enforce permissions on the server. It also introduces maintenance, recovery and support responsibilities. A configured product with a carefully scoped integration may be a better choice for a simple operation.

My custom software service can turn your process map into rules, interfaces and acceptance criteria, compare options and plan incremental delivery. The operations dashboard demonstration only shows a table, a filter and calculations using fictional data. It is not evidence of a production approval system.

Prepare for a useful scope discussion

Bring an anonymised example, one exception and the roles that need access. Explain what must survive the transition. Avoid sharing customer details or credentials. These inputs support a concrete estimate instead of a vague promise to deliver a certain number of screens.

Sources and further reading

About the author and editorial process

Rafael de Sanzio Nonato develops websites, web applications and integrations independently. Scope and responsibilities are agreed for each engagement.

Prepared with AI assistance. Examples are hypothetical unless explicitly documented. Publication is subject to the author's editorial approval.

Approach and responsibilities →

Map the workflow your spreadsheets cannot control

Describe the task requiring competing versions, approvals or checks outside the file. I can assess that workflow and propose explicit rules and history.

Map the workflow your spreadsheets cannot control ↗