Your Data Is in Prison. AI Has the Keys.

A business owner showed me a spreadsheet that had been part of his rental operation for years. It tracked equipment, but he wanted to know whether the process it supported could become an application.

He wasn’t starting from scratch. He’d built a way to run the business with tools he knew, solving problems as they came up. The spreadsheet worked. Yet answering a question such as “Which equipment will need service soon?” still took more effort than it should.

That’s a familiar stage in the life of a business. You have the information. You’ve been collecting it for years. But putting it to work means opening files, comparing records, and relying on someone who remembers how the whole system fits together. The information is there, but it’s locked behind files, formats and memory.

Most business owners don’t even see the bars.

When “it works” stops being enough

Spreadsheets are excellent tools. They’re flexible, familiar, and often exactly what a business needs. A small operation can go a long way with a well-designed workbook.

But businesses grow around their tools. One spreadsheet becomes several. Someone adds a tab, a formula, and a separate file for an exception the original system couldn’t handle. Another person starts keeping notes in a folder. Before long, the business has a makeshift information system that nobody set out to build.

You can still get the job done. The harder question is what that process costs you—and what it prevents you from seeing.

What important question can your business answer only by hunting through files or asking the person who knows where everything is?

For the rental business owner, it might be which items need maintenance before they go out again. For another owner, it might be which estimates never received a follow-up, which jobs actually make money, or which regular customers have stopped buying.

The answers may already exist. They just aren’t easy to reach.

Your records could be doing more

Most business records are created to complete an immediate task. You enter an invoice to bill a customer. You log a repair to document the work. You save an estimate so you can send a price.

Once that task is done, the record often goes quiet. Yet the same information might help you make the next decision.

Consider a few possibilities:

• Old quotes and estimates. A business may have hundreds of proposals saved in email or accounting software. Looking across them could reveal which prospects never received a follow-up, or which types of work are quoted frequently but seldom accepted. The useful result isn’t a bigger pile of reports. It’s knowing where a timely, appropriate conversation or a change in pricing might help.

• Service and repair records. A repair log tells you what happened to one piece of equipment. Connected with inventory and scheduling information, it could help you see what needs attention next, which items cause repeated downtime, and whether a repair should happen before the next booking.

• Invoices and job costs. Revenue alone can make a busy job look successful. Compare the estimate with the final labour, materials, and other costs, and a different picture may emerge. An owner could discover a type of work that regularly takes longer than expected and adjust how future jobs are priced.

• Customer questions and complaints. One question may seem routine. The same question asked 50 times could point to confusing instructions, a missing service, or something customers need help choosing. Records kept to resolve individual issues can also show what the business should improve.

• Purchasing records. Past orders can help an owner anticipate supplies that run short at the same time every season. They may also reveal dependence on a single supplier for something the business cannot operate without. Seeing that pattern early gives the owner options.

• Sales and booking history. When does demand usually rise? Which products tend to sell together? Which customers used to buy regularly but have gone quiet? Patterns like these can inform staffing, inventory, and relevant follow-up—if the information can be found and understood.

The point is not to collect every possible fact about your business. It’s to ask better questions of the information you already have.

The relationships hidden in your records

Some of the most valuable information in a business isn’t about equipment or costs. It’s about people.

An accounting system, for example, may contain years of customer history. Those entries are more than names and addresses: they show what people bought, when they bought it, and perhaps what they may need again.

There are also people in those records who helped build your business: customers who came back year after year, suppliers who solved a problem when you were in a bind, and contacts who sent a friend or colleague your way. When their names are scattered across invoices, email, and old files, it is easy to lose touch simply because there is no clear view of the relationship. Bringing that history together can help you remember who supported you, what mattered to them, and when a thoughtful check-in or a genuine thank-you would be welcome.

That is a different use of data from chasing a quick sale. A business might notice that a long-time customer has gone quiet and reach out to see how things are going, or recognize a referral partner whose introductions deserve appreciation. Good records help make those conversations personal and timely. The aim is to strengthen relationships you have earned.

Think about the usefulness of a “buy again” suggestion. A customer who previously purchased a consumable item may appreciate a reminder when they’re already placing another order. A service business might be able to flag maintenance that is coming due. A supplier might notice that a customer regularly reorders a part at a particular time of year.

A relevant suggestion can be helpful because it grows out of an actual relationship. Your own records are a promising place to look before paying for a list of strangers.

But an existing relationship is not blanket permission to market to someone. A customer who bought from you years ago may not want messages today. How you use contact information must respect the person’s choices and Canada’s Anti-Spam Legislation (CASL). Trust is part of the value in those records; careless outreach can spend it quickly.

Where AI fits

AI can help a business examine what it has, spot inconsistencies, explore patterns, and imagine a better way to work. It can help turn a plain-language question—“What equipment is due for service next month?”—into a useful view of the records. It may also help design a workflow or build a small application around a process that has outgrown its spreadsheet.

But AI cannot make unreliable information reliable by wishing it so. If maintenance dates are missing, customer names are duplicated, or nobody agrees what a field means, those problems need attention. A useful system also needs sensible access controls, careful testing, and people who understand the decisions it supports.

That’s why “AI has the keys” doesn’t mean handing the business over to a machine. The business owner decides which door is worth opening. AI is one tool that can make the work of opening it more practical.

Nor does every business need expensive custom software. Sometimes the answer is a cleaner spreadsheet. Sometimes it’s an existing application that fits the job. Sometimes a database, dashboard, or purpose-built tool is worth the investment. The right choice starts with the problem, not the technology.

Start with one question

You don’t have to rebuild your entire business to find out what your data could do.

Start with a question you struggle to answer today. Pick one that matters: a decision you make often, a surprise you would like to prevent, or an opportunity you suspect you’re missing.

Then find out where the relevant information lives. Is it complete? Does it agree across your files and systems? How much manual work does it take to turn it into an answer?

A small pilot can show what’s possible. For the rental business owner, that might be a clear list of equipment due for service in the coming weeks. Once that works and earns trust, he can decide what else the system should do.

The information you’ve collected is an asset, and it shouldn’t stay locked up. If it only tells you what happened after you go looking for it, you’re getting a fraction of its value. Used well, it can help you see what should happen next.

I work with the trades more than any other sector, and this is often the first project I suggest.