How a Spreadsheet Settled a Fergus Supply Dispute

The situation

Anjali called our office on a Tuesday evening, twelve days before a mediation session she had barely had a hand in preparing for. Her voice was steady but fast: the case had been running for almost a year, the mediation date was fixed by the court's schedule, and the lawyer who had been carrying the file had recently stepped back without much notice. She wanted to know, plainly, whether twelve days was enough time to get ready, and she wanted an honest answer rather than reassurance.

Anjali and Joao ran a small electrical supply company out of Fergus, buying switchgear and wiring components in bulk and reselling them to contractors across the region. Their largest account that year had been a mid-size commercial build managed by a general contracting company under the direction of a project manager named Ines, who had placed close to $300,000 in orders over eight months. When the project ran into delays on site, Ines's company began withholding payment on the later invoices, arguing that some material had arrived late and caused costs of its own. What had started as a routine supplier relationship, with steady orders and on-time payment for years, had turned into the largest financial dispute either Anjali or Joao had ever faced.

Neither Anjali nor Joao had been through a lawsuit before. Anjali worked rotating shifts as a firefighter and ran the supply company's books on her days off; Joao, an electrician by trade, handled deliveries and technical specifications and had a good working relationship with most of the contractors on their client list, including, until the dispute began, Ines. The file had moved slowly through the court's pre-trial process for most of a year, with the case management judge eventually directing the parties to mediation before a trial date would be set. Through most of that year, Anjali had assumed the previous lawyer was keeping the administrative side of the file in order, an assumption that turned out to be only partly true.

What Anjali did not fully understand until she called us was that a procedural deadline earlier in the file, for exchanging the list of documents relevant to the damages claim, had already passed without a proper response being filed. It had not ended the case, but it left them heading into mediation without an organized financial record, and it had already cost them some credibility with the other side and, she suspected, with the mediator who would read the file cold. She had also just learned, days before calling us, that the previous lawyer had not prepared any draft brief at all, meaning the mediation was now less than two weeks away with essentially nothing written down.

The legal problem

The dispute itself was arithmetic wrapped in a contract claim. Ines's company owed roughly $210,000 across a string of unpaid invoices for materials that had, by the paper trail, actually been delivered. In response, they had raised a counterclaim of about $65,000, arguing that late shipments on two occasions had pushed their own subtrades back and cost them money. Combined, the unpaid invoices and the counterclaim put roughly $270,000 in play at mediation, comfortably inside what a mediated settlement could realistically resolve without a trial, though nowhere near small enough for either side to walk away from without a serious negotiation.

Mediation is a structured, non-binding settlement meeting: a neutral mediator spends a day moving between rooms, testing each side's position, and looking for a number both sides can live with. Nothing said in the room is binding unless both sides sign an agreement at the end, and either side can walk away at any point. It works well when the parties trust the numbers on the table. It works badly when one side's figures look improvised, because a mediator has no power to test evidence the way a trial would, and will not press a party toward a settlement built on numbers that do not hold together. A mediator who senses that one side's own file is disorganized has little basis to lean on the other side to move.

Because the earlier document deadline had passed without compliance, the file lacked the court-imposed structure that normally forces a supplier's records into order well before mediation. That meant the mediation brief itself would be the first real opportunity to lay the financial picture out clearly. If it read as one more unverified assertion in a dispute that had already gone sideways procedurally, the mediator would have little reason to press Ines's side to move, and Ines's side would have little reason to believe the number was firm.

Many mediation briefs are written as legal argument: a recitation of the contract terms, the correspondence history, and each side's position on who breached what. That approach earns its keep when liability is genuinely contested down to the wire. Here it was not. The real fight was arithmetic — which invoices had actually been paid, which deliveries were genuinely late against the agreed schedule, what those two late deliveries had plausibly cost the contractor, and what interest had accrued in the meantime. A narrative-heavy brief risked burying that arithmetic under argument the mediator would have to work to unpack.

What we did

1. Rebuilt the invoice and delivery timeline from source documents. We went back to Anjali and Joao's own delivery slips, purchase orders, and bank records rather than relying on the summary the previous lawyer had assembled, because a mediator and opposing counsel needed to see numbers that traced to primary documents, not a secondhand tally that could be second-guessed. That groundwork also caught a handful of invoices the earlier summary had miscoded, which mattered once the total became the centerpiece of the brief.
2. Separated the genuinely late deliveries from the disputed ones. Of roughly a dozen shipments referenced in correspondence, only two had documented delivery dates later than the agreed schedule. Isolating those two meant the counterclaim could be tested on its actual scope instead of treated, as Ines's side had been framing it, as a blanket offset against everything owed on the account.
3. Filed the overdue document list immediately, late but complete. Rather than leave the missed deadline unaddressed and hope it went unnoticed, we filed a complete response with a short, factual explanation for the delay, which reduced the risk that the mediator or opposing counsel would treat the gap as evidence the underlying claim itself was disorganized or unreliable. Closing that gap before mediation meant the session could focus on the actual dispute instead of the file's procedural history.
4. Built a single reconciling spreadsheet covering every invoice, payment, and disputed charge. Each line tied an invoice number to a delivery date, a payment or non-payment, and, where relevant, a note on the counterclaim, with running totals that updated automatically. This became the spine of the brief, letting a reader verify the $270,000 figure in minutes rather than take it on faith or re-derive it from a narrative.
5. Wrote a mediation brief organized around the spreadsheet, not around legal argument. The narrative sections were kept short and functional, explaining the contract terms only enough to frame the numbers correctly. The spreadsheet, not the prose, carried the weight of the submission, and the brief was written so a reader could check any figure against the underlying document referenced beside it.
6. Prepared Anjali and Joao for direct questions from the mediator. We ran through likely questions about the two late deliveries and the reasoning behind the interest calculation, so neither of them would be caught improvising an answer that contradicted the brief or undercut the credibility the reconciled numbers had built. A confident, consistent answer in the room does more to hold a number together than the strongest spreadsheet, if the person being asked has never rehearsed saying it out loud.
7. Set a realistic settlement range and a walk-away point before the session began. Going in with an agreed floor, discussed and confirmed with Anjali and Joao the evening before, meant decisions made under time pressure in a mediation room reflected a plan made calmly in advance, not a reaction to whatever number the other side opened with. That preparation kept the negotiation grounded in the reconciled figures rather than in whatever momentum built up over the course of the day.
8. Coordinated with opposing counsel ahead of time on the exchange of documents. We shared the reconciling spreadsheet and its supporting records two days before the session, rather than saving it as a surprise, on the reasoning that a mediator responds better to parties who appear to be negotiating in good faith than to parties who ambush one another with new material on the day.

The outcome

The mediation ran a full day. By early afternoon, the reconciling spreadsheet had done what it was built to do: opposing counsel's own review of the numbers landed close to our figure, which narrowed the session to a real negotiation over the two disputed deliveries rather than a dispute over the underlying total. That is the outcome a numbers-first brief is meant to produce, and here it worked. The mediator later told us privately that having a document both sides could check against, rather than two competing narratives, was what let the session move as quickly as it did.

The parties settled that day. Ines's company agreed to pay approximately $250,000 of the roughly $270,000 in dispute, accepting a modest reduction tied to one of the two late deliveries while conceding the other had not actually caused the delay it originally claimed. Anjali and Joao gave up a small amount of the interest they were technically owed in exchange for immediate payment and an end to the file, a trade they were glad to make once it was framed as cash now against a marginal amount later.

For a business that had gone almost a year without full payment on a major account, the settlement resolved the immediate cash-flow problem and avoided a trial that could have taken another year and cost more, win or lose, than the amount still in dispute. It also let Anjali and Joao rebuild the working relationship with Ines's company on new terms, since the two businesses were likely to cross paths again on future projects in the region and neither wanted the dispute to follow them into the next bid.

Anjali later said the twelve days before mediation had been the most useful two weeks of the entire case — not because the underlying facts changed, but because the numbers finally did the arguing instead of the lawyers. She has since changed how her own company documents deliveries and invoices, keeping a running reconciliation from the start rather than waiting for a dispute to force one.

What you can learn from this