Case Software Versus Spreadsheets for Boards

An owner replies, “I never received that letter,” and a director opens the shared spreadsheet. The date is there, but the attachment is in somebody’s personal inbox, the photographs were sent by WhatsApp, and no one can say who followed up. That is the practical difference in case software versus spreadsheets: not whether your board can make a list, but whether it can produce a clear record when the list is challenged.

For a self-managed Ontario condominium corporation, the question is rarely about buying more technology. It is about avoiding a lost evening spent reconstructing a compliance file from email threads, Word documents and former directors’ mobile phones.

Start with a compliance letter your board can stand behind

Before comparing systems, it helps to have a letter structure that does not overstate the corporation’s position. The following is a general-information starting point for a routine rule or declaration concern. Adapt it to the facts, your declaration, by-laws and rules.

> Subject: Compliance concern - [unit number and issue] > Date: [date] > > Dear [unit owner name], > > The corporation has received or recorded information concerning [plain description of the observed issue] at or connected with Unit [number] on [date or dates]. The relevant provision is [quote or identify the declaration, by-law or rule]. > > Section 119 of the Condominium Act, 1998 requires owners to comply with the Act, the declaration, by-laws and rules. Please take the following step by [reasonable date]: [specific requested action]. > > If you believe this notice is incomplete or incorrect, please provide your response and any relevant information in writing by [date]. The board will add your response to the compliance record and consider it before deciding on any further step. > > Where applicable, the corporation reserves its rights under the declaration’s indemnification provisions in respect of costs it is entitled to recover. > > Sincerely, > [Name and role], for the board of directors

The wording matters. A board should identify the actual provision, the observed facts and the action requested. It should not treat a disputed allegation as established fact, or describe a cost as payable unless the declaration and circumstances support recovery.

Section 117 may be relevant where the facts concern conduct likely to damage property or cause injury, illness or nuisance. It is not a catch-all citation for every rule concern. Section 119 is often the more direct compliance provision, but the declaration, by-laws and rules still determine what the owner was required to do. A measured letter gives the owner a chance to respond and gives the board a cleaner next step if the issue continues.

Where spreadsheets stop being enough

A spreadsheet can be perfectly adequate for a low-stakes task with one owner, one letter and one director. It can record a unit number, a date and a status. Many volunteer boards begin there for good reason.

The weakness appears when the record needs to tell a sequence of events. A spreadsheet usually points elsewhere for the evidence: photographs in a mobile phone library, letters in a Word folder, delivery confirmation in email, responses in another inbox and meeting decisions in minutes. The board then relies on memory to connect the pieces.

That creates three familiar problems. First, the record can become person-dependent. When the secretary resigns, their Gmail account may contain the only copy of a response or proof of delivery. Second, the timing is difficult to verify. A row saying “letter sent” does not show the version sent, when it was delivered or whether a follow-up was due. Third, consistent treatment is harder to demonstrate when different directors keep different notes.

A spreadsheet is also easy to revise without preserving why a status changed. That is useful for ordinary working documents, but less useful when an owner alleges selective enforcement and the board needs to show what it knew, when it knew it and what it did next.

The comparison that matters

| Board task | Spreadsheet and email approach | Case software approach | |---|---|---| | Record an observation | Enter a note and find the photo later | Store the observation with a timestamped, GPS-recorded photo | | Send a compliance letter | Save a Word version, then email it | Generate a consistent letter and retain the sent version | | Show delivery | Search a mailbox or ask the sender | Keep a delivery record alongside the notice | | Track the owner’s response | Forward messages between directors | Keep the response in the same matter record | | Explain board decisions | Reconstruct the timeline for a meeting | Prepare a chronological file and meeting pack |

The point is not that every issue needs a formal proceeding. Most do not. The point is that the file should be ready before anyone asks for it.

What a defensible board record contains

A useful compliance record begins with the source of the obligation. Keep the relevant declaration, by-law or rule provision with the matter, not merely a shorthand label such as “noise” or “parking”. Add the factual record: dated photographs where appropriate, reports received, and notes that distinguish what a director observed from what someone else reported.

Next, keep every communication in sequence. That includes the first courtesy reminder, the formal compliance letter, delivery details and the owner’s reply. If an owner says they did not receive a notice, the board should be able to identify the version sent, the delivery method and the result without searching several accounts.

Then record decisions, not just outcomes. If the board considered a response and chose to allow more time, note the decision date and reason. If it chose not to proceed, retain that decision too. Consistency does not mean every situation produces the same result. It means the board can show that it considered comparable facts through a recognisable process.

Finally, preserve the history. Section 17(3) sets out the board’s duty to manage the affairs of the corporation, while section 55 addresses records that owners may inspect, subject to the Act’s rules. A compliance file is not automatically a document to circulate freely, but it should be organised with record obligations, privacy and access questions in mind. Ask counsel where an access request, privilege or sensitive information creates uncertainty.

When the matter reaches the Tribunal

A CAT Notice of Case changes the board’s workload quickly. The issue is no longer simply whether a reminder was sent. Directors may need to assemble documents, answer deadlines and explain the chronology to one another without reinventing it. CAT filing fees can total $200 across its stages, but the larger cost for a volunteer board is often the time spent finding and ordering the record.

Not every compliance concern belongs before the CAT, and some disputes may require another process. Section 132 deals with mediation and arbitration provisions, while section 134 addresses court enforcement. The right route depends on the subject matter, the governing documents and the facts. The board’s immediate job is more basic: preserve the material, avoid editorialising and make sure the timeline is complete.

This is also where an append-only history has practical value. It does not decide the dispute and it does not make a record court-proof. It does allow the board to see additions and actions in sequence rather than relying on a document that can be quietly overwritten. The better file usually wins attention first because it lets everyone understand what happened.

A practical threshold for moving beyond the spreadsheet

Consider changing systems when your corporation has more than one active matter, more than one director handling correspondence, or a recurring concern that may require follow-up at 30, 60 and 90 days. The same applies when your board is leaving a management company, preparing for AGM season, or facing the upcoming 1 July 2027 notice-compliance changes.

YardRule is built for self-managed Ontario corporations of up to 100 units. It keeps photos, letters, delivery records, owner responses, escalation reminders and board-ready matter packs together, with an append-only audit trail. Its public pricing is $49 per month for up to 25 units, or $99 per month for up to 100 units. A 30-day full-product pilot requires no card, and if the corporation stops paying, its record remains readable and exportable.

That does not mean a board must abandon every spreadsheet. A spreadsheet may still be useful for a simple overview or a temporary register. The better division is straightforward: use the spreadsheet for summary tracking if you wish, but keep the evidence, notices, responses and decisions in the file where the board can retrieve them as one record.

Before your next compliance letter, test one question: if the director who sent it resigned tomorrow, could another director produce the complete file in ten minutes? If not, the board has identified the gap worth fixing.

This article and any related guides are general information, not legal advice. Your corporation’s declaration and counsel govern.