BroraSys All articles
Systems Integration

Integration Debt Is Quietly Taxing Your SME — Here Is How to Audit It

BroraSys
Integration Debt Is Quietly Taxing Your SME — Here Is How to Audit It

Photo: Francisclarke, CC BY-SA 4.0, via Wikimedia Commons

Most UK SMEs do not set out to build a fragmented technology estate. They buy a CRM because sales needs one, an accounting package because the bookkeeper prefers it, a stock system because the warehouse cannot work from spreadsheets, and a support desk because customers expect faster responses. Each decision is defensible in isolation. The problem is cumulative: every new tool adds another set of credentials, records and reporting rules that must be reconciled with everything already in place.

Integration debt is the operational equivalent of technical debt. It is the accumulated cost of connections that were never designed, are maintained by hand, or depend on one person remembering to export a CSV. It rarely appears as a line item. It shows up as duplicated customer records, month-end delays, stock counts that disagree with the website, and finance teams chasing spreadsheets instead of analysing them.

Why integration debt accumulates

Procurement usually happens one department at a time. Sales buys a CRM, operations buys a fulfilment tool, finance keeps the accounting system, and marketing adds another platform for campaigns. Each team may have followed a sensible process, but few SMEs have a single owner for cross-system data. Trials become production systems. Spreadsheet workarounds become permanent. A vendor says it integrates with Xero or Sage, and the business assumes that means a live, reliable connection rather than a periodic export.

UK compliance adds another layer. Making Tax Digital, RTI payroll reporting and ecommerce accounting all depend on clean data moving between systems. A tool can be excellent for one team and still be a poor fit for the business if it cannot exchange core records with the systems that finance and operations rely on.

The hidden costs are usually human

Integration debt is often described as a technology problem, but its day-to-day cost is labour. Staff rekey orders from an online shop into accounting software. Someone reconciles Stripe payouts against invoices by hand. A customer changes address in the CRM but not in the finance system. A manager waits until month-end for a report that should be available daily.

There are secondary costs too. Manual transfers increase error rates and make audit trails weaker. Sensitive data gets copied into personal spreadsheets or email inboxes, which complicates UK GDPR compliance. Reporting lags behind trading conditions. And when the one person who understands the workaround leaves, the business discovers that its processes were held together by familiarity rather than design.

A five-step audit framework

A useful audit does not need a large consultancy engagement. It needs a clear inventory, a map of critical data flows and an honest assessment of where manual effort is hiding.

Step 1: Inventory every system and data store

List SaaS subscriptions, on-premise software, spreadsheets that act as systems of record, and any shared mailboxes used for processing. Include the owner, cost, purpose and whether the tool holds customer, supplier, financial or employee data.

Step 2: Map the core data flows

Trace six record types: customer, supplier, product or service, invoice, payment and employee. For each flow, record the source system, destination system, direction, method and frequency. Mark whether the connection is native, API-based, file-based or manual.

Step 3: Score integration health

Use a simple table to separate healthy connections from fragile ones.

Signal Healthy At risk
Connection method Native sync or documented API CSV export, email or manual entry
Ownership Named owner with monitoring Nobody, or one person informally
Failure visibility Alerts, logs and retry process Discovered at month-end
Data matching Shared identifiers and validation Free-text matching and duplicates

Step 4: Quantify the cost

Estimate hours spent each week on manual transfer, reconciliation and correction. Multiply by a realistic hourly cost, then add the cost of delayed cash collection and reporting errors. Even a modest estimate often justifies proper integration work.

Step 5: Decide what to retire, replace or connect

Not every system needs to remain. Some tools overlap. Some should be retired. Some should be integrated properly. A few manual controls may be acceptable temporarily, but they should be documented, owned and reviewed rather than left invisible.

Procurement should start with integration

Before buying new software, require answers to a short set of questions. Which existing systems must it exchange data with? Does it provide documented APIs and webhooks? Can it use single sign-on and role-based access? Is there a sandbox for testing? What are the API rate limits and export options? Who supports the integration? Can all data be exported cleanly if the contract ends? What is the total cost including middleware, consultancy and internal time?

A feature checklist is not enough. The right question is whether the tool will reduce or increase the number of manual handoffs in the business.

Make integration debt visible

Keep a simple integration register. For each connection, record the systems involved, the data exchanged, the method, the owner and the last review date. Review it quarterly and whenever a system changes. This does not require a large IT team; it requires discipline and a named owner.

BroraSys's view is that integration debt should be managed like any other operational risk. It is not a reason to stop buying software. It is a reason to buy deliberately, test connections before they become critical and treat data flows as part of the business process rather than an afterthought.

All Articles

Related Articles

MTD for Income Tax: What Smaller UK Firms Should Test Before the £30,000 Threshold

MTD for Income Tax: What Smaller UK Firms Should Test Before the £30,000 Threshold