Spreadsheets Versus Case Tracking Software

The email arrives at 9.40 pm: “I never received that letter. You are targeting my unit.” A director opens the shared spreadsheet, another searches their sent items, and the photo is somewhere in a WhatsApp thread. This is where spreadsheets versus case tracking software stops being a question about convenience. It becomes a question of whether the corporation can produce a clear, dated record before anyone has to reconstruct one.

For a self-managed Ontario condominium corporation, the better file usually wins the practical argument. It helps the board respond consistently, brief counsel efficiently if needed, and spend fewer evenings looking through old inboxes.

Start with a file you can hand to the next director

Before changing tools, use this document inventory for every compliance matter. It is useful whether the issue concerns noise, parking, storage, alterations, pets, or another rule or declaration requirement.

Record the unit number, the concern raised, the applicable declaration, by-law or rule, and the date the concern was first observed. Keep the original photo or supporting material, including its date and location where available. Keep each compliance letter in its sent form, proof of delivery or attempted delivery, every owner response, and notes of each follow-up.

Add the board decision behind each escalation. If the matter was discussed at a meeting, retain the relevant meeting record. Section 17(3) of the Condominium Act, 1998 requires the corporation to take all reasonable steps to ensure that unit owners comply with the Act, declaration, by-laws and rules. A record should show the reasonable steps the board actually took, not merely the outcome it wanted.

Finally, keep a simple chronology. Someone unfamiliar with the matter should be able to see what happened, when it happened, what was sent, how it was delivered, and what response followed. That is the minimum useful file when a director leaves, an owner disputes notice, or a CAT Notice of Case arrives.

A sample first compliance letter

A first letter should be factual, specific and proportionate. It should not overstate the corporation’s authority or make conclusions the evidence does not support. Here is a practical structure a board can adapt to its own declaration, by-laws and rules:

> Re: Compliance concern for Unit [number] > > Dear [unit owner], > > The corporation has received or observed the following concern: [plain description of the conduct or condition]. The concern was recorded on [date(s)] at [location]. > > The corporation asks that you review [the relevant declaration, by-law or rule] and take the following steps by [date]: [requested action]. > > The corporation’s request is made in light of its obligation under section 17(3) of the Condominium Act, 1998 to take reasonable steps to ensure compliance. Depending on the facts, sections 117 and 119 may also be relevant. Section 117 addresses conditions or activities likely to cause damage or injury, while section 119 requires owners and occupiers to comply with the Act, declaration, by-laws and rules. > > If you believe the information is incomplete or incorrect, please respond by [date] with any relevant details. The board will consider your response before deciding whether further action is required. > > Sincerely, > > [Name and office] > For the board of directors

The letter does not replace the corporation’s governing documents. Nor should it promise a remedy. If the declaration contains indemnification provisions, the corporation may need legal advice about cost recovery and the circumstances in which it applies. The declaration and counsel govern.

Where a spreadsheet works, and where it starts to fail

A spreadsheet is not inherently careless. For a small number of routine matters, it can provide a useful register: unit, issue, date opened, next step, status. It is inexpensive, familiar and quick to set up. A disciplined secretary can make it work for a while.

The weakness is that a spreadsheet usually records a summary, while the evidence lives elsewhere. The photo is in a director’s mobile phone. The letter is in Word. Delivery confirmation is in an email account. An owner’s response is in a text message. Meeting context is in separate minutes. The spreadsheet becomes an index to records that may no longer be accessible.

That gap matters when the question changes from “What is outstanding?” to “What did the corporation know and do on 14 May?” A row marked “letter sent” does not show the letter’s wording, its attachments, its delivery status, or whether the owner replied. It also does not reliably show who changed the row and why.

The risk rises when several directors share the work. One person updates the spreadsheet, another sends the letter, and a third takes the photograph. Each may be acting reasonably. But the resulting file can still be incomplete. When a treasurer or secretary resigns, the corporation may discover that the working record was in a personal Gmail account rather than in the corporation’s records.

Section 55 creates statutory record obligations, and access requests can put pressure on scattered administration. A board does not need a complicated system. It needs a consistent one that preserves the records it creates and makes them retrievable.

Spreadsheets versus case tracking software: the practical difference

Case tracking software is useful when it keeps the case together rather than simply creating another place to type notes. The central question is not whether it has more features. It is whether a new director can open one matter and understand the record without searching several systems.

For compliance work, that means evidence captured with the matter, letters generated from a consistent template, delivery recorded, owner responses retained, and dated follow-up reminders. It also means a history that shows the course of the file. An append-only audit trail is especially helpful because entries cannot be edited from inside the application after the fact, while the board can still add later information or corrections as new entries.

That structure helps with consistency. If two units raise the same issue, the board can see the steps it took in each file rather than relying on memory. Consistency does not mean identical treatment regardless of facts. It means the board can explain the relevant facts, the governing provision, the notice given and the decision made.

This is also where photos need more than a filename. A picture taken at the time of an observation, retained with GPS and timestamp information, is easier to place in a chronology than an image forwarded repeatedly between directors. It is still evidence to assess in context, not a substitute for judgement.

What the board should expect from a case record

A useful system should reduce administrative uncertainty, not add a new layer of work. For each matter, look for a record that joins observation, correspondence, delivery, response and follow-up. It should also make handover straightforward when board roles change.

YardRule is built for self-managed Ontario condominium corporations of up to 100 units. It keeps GPS-stamped, timestamped photos, compliance-letter templates, delivery tracking, owner responses, 30-, 60- and 90-day reminders, meeting packs and an append-only history in the same case file. It is not a replacement for counsel, but it gives counsel a more orderly file if advice becomes necessary.

The pricing is straightforward: $49 per month for up to 25 units, or $490 annually, and $99 per month for up to 100 units. Boards can use a 30-day full-product pilot without a credit card. If the corporation stops paying, its record remains readable and exportable. That matters to volunteer boards that should not have to choose between retaining their history and continuing a subscription.

When the record may be tested

Not every disagreement becomes formal. Many are resolved after a clear notice and a fair opportunity to respond. But a file should be built as if a director who was not present will need to understand it later.

For disputes within CAT’s jurisdiction, a Notice of Case changes the board’s workload quickly. CAT filing stages can involve $200 fees, alongside the time required to organise materials and respond. A chronological record can keep that work focused on the facts rather than on recovering correspondence.

Some compliance questions may instead involve the Superior Court of Justice under section 134. Others may concern the corporation’s duty to enforce or the owner’s obligations under sections 117, 119 or 132. The route depends on the issue. A tracking system cannot decide that question, but it can ensure the board has the documents, dates and delivery history ready before anyone asks for them.

The practical next step is modest: open your last three compliance files and see whether each contains the original evidence, the exact letter sent, delivery information, the owner’s response and a clear chronology. If not, the board does not need more heroic spreadsheet maintenance. It needs a record that can survive a handover.

This article is general information, not legal advice. Your corporation’s declaration and legal counsel govern.