A spreadsheet arrived by courier and changed the closing math

The situation

The letter arrived by courier on a Tuesday, ninety-one days after closing, a date Halina had circled on her calendar because it was the deadline written into the purchase agreement for the seller to deliver a final working capital statement. She opened it expecting a routine reconciliation. Instead she found a one-page cover letter and a spreadsheet showing a working capital figure close to the estimate used at closing, with inventory listed at a value that did not match anything she had seen during due diligence.

Halina, a veterinary technician for most of her working life, had spent three years building savings and lining up investors before she bought this business: an auto parts distributor operating out of a Fort Erie warehouse, run for two decades by Agus before he decided to retire. Halina lived several provinces away and had no plans to relocate; the deal, and the business afterward, would be managed remotely, with a general manager she was hiring to run day-to-day operations on the ground. This was her first acquisition of any kind, and she had leaned hard on our office through diligence precisely because she could not be in Fort Erie to look at the boxes herself.

The purchase agreement had used a standard working capital adjustment mechanism: a target working capital figure was agreed at signing, based on historical averages, and a true-up happened after closing once the actual balance sheet on the closing date was finalized. If the real number came in below target, the purchase price would be reduced; if it came in above, Halina would owe more. The spreadsheet Agus's accountant had sent showed working capital almost exactly at target, which on its face meant no adjustment was owed either way.

What caught Halina's eye, reviewing the spreadsheet over a video call with her new general manager, Rizki, was a line item for inventory that valued a large batch of older parts, some for vehicle models that had not been sold new in over a decade, at close to full cost. Rizki, who had worked as a factory technician before Halina hired him to run the warehouse floor, recognized several of the part numbers immediately as stock that had been sitting untouched in the back of the warehouse since before the sale, unsellable at anything close to the price on the sheet.

What was actually at stake

The dollar figure at issue was not small. The disputed inventory, valued at cost on the seller's spreadsheet, represented a meaningful slice of the total working capital figure in a transaction that had closed in the low double-digit millions. If the obsolete stock had been valued properly, the true working capital on the closing date would have come in well under the agreed target, meaning the purchase price should have been reduced by a substantial amount. Getting this wrong in the seller's favour meant Halina had effectively overpaid for inventory that could not be sold.

More was at stake than the number itself. The purchase agreement's dispute mechanism gave each side a limited window to challenge the closing statement, with an independent accountant available to resolve disagreements the parties could not settle themselves. Miss that window, and the seller's figure would ordinarily stand even if it was wrong; courts take deemed-acceptance deadlines like this one seriously. How complete a bar that is still depends on how the clause itself is written, and a figure produced by fraud or an obvious arithmetic error is a different question from one a buyer simply failed to challenge in time. Halina, managing the file from out of province and relying entirely on documents and calls, needed to move quickly and precisely, because a dispute raised late or raised without solid support could be dismissed on procedure before it was ever considered on the merits.

Agus, for his part, was relying on the fact that he no longer controlled the business and had limited visibility into what Rizki or anyone else on the ground might find. His accountant had prepared the closing statement from the company's general ledger, which recorded the inventory at its historical cost, a figure that is standard for accounting purposes but says nothing about whether the goods could actually be sold. Nothing in that ledger flagged the stock as obsolete, because nobody at the company had ever formally written it down, even though staff on the floor had known for years that it was effectively dead weight.

The core issue was a gap between what accounting records show and what a purchase agreement's working capital definition is actually meant to measure: the real, realizable value of the assets changing hands. A working capital adjustment exists precisely to correct for the risk that a seller's numbers, drawn straight from the books, do not reflect reality on the closing date. Whether that definition in this particular agreement captured obsolescence, and whether Halina could prove it, was the entire dispute.

There was also a practical constraint shaping how the dispute could be run. Halina was not in Fort Erie, had never walked the warehouse herself, and had no independent way to verify a seller's claim without relying on people she had only recently hired. That meant the dispute could not be built on her own observations; it had to be built on documentation strong enough to stand on its own, produced by people on the ground whose credibility she could vouch for but whose work she could not personally check line by line. Getting that documentation right, quickly and within the contractual deadline, mattered as much as the legal argument itself.

What we did

1. Pulled the exact adjustment language from the purchase agreement to confirm how working capital was defined and whether the definition required inventory to be valued at net realizable value rather than at cost. The agreement did include a net realizable value standard, which gave Halina a contractual basis to challenge the seller's cost-based figures directly, rather than just a factual disagreement about quality. Without that specific language the claim would have had far less traction, since a plain cost-based definition leaves a seller's book figures difficult to dispute on principle alone.
2. Directed Rizki to conduct a physical count and age analysis of the disputed inventory, part number by part number, cross-referenced against sales history for each item over the prior several years, with notes on condition and packaging for anything that looked stale. This turned Rizki's on-the-floor observation into a documented, dated record showing which items had not moved in years and were unlikely to sell at anything beyond scrap or liquidation value.
3. Retained an independent valuator with automotive parts experience to assess a fair realizable value for the obsolete stock rather than relying on an internal estimate, since our office needed a credible, defensible number that the seller's side could not simply dismiss as self-interested guesswork produced by Halina's own team after the fact, and that could stand on its own if the matter ever reached the independent accountant.
4. Drafted a formal notice of dispute within the agreement's window, laying out the specific inventory items at issue, the net realizable value standard in the contract, and the valuator's findings, which preserved Halina's right to challenge the statement and put the seller on formal, written notice of the exact basis for the claim before any deadline could be argued to have lapsed.
5. Opened direct negotiation with Agus's counsel before triggering the agreement's independent accountant process, on the view that a negotiated resolution would be faster and cheaper than a formal reference, and shared the valuation report early to make clear the claim was substantiated rather than speculative, which shifted the conversation from whether a problem existed at all to how large the correction needed to be.
6. Modelled several settlement scenarios for Halina, showing the range of likely outcomes between the seller's original figure and the full amount supported by the valuation, so she could weigh a negotiated middle ground against the added cost, delay, and uncertainty of pushing the dispute all the way to a formal reference under the independent accountant process instead. Managing the file remotely, she needed the range in plain dollar terms to make the call herself, rather than guessing at what a recommendation actually meant.
7. Finalized a revised working capital statement once Agus's side accepted the valuator's core findings, converting the dispute into a straightforward amendment to the closing statement rather than a drawn-out arbitration. This kept Halina's costs proportionate to what was actually at stake and avoided the added expense and delay of formally engaging the independent accountant named in the agreement, while still producing a document with the same binding effect as one that had gone through the full reference process.
8. Coordinated every step through short written updates to Halina rather than relying on lengthy calls across time zones, since managing a dispute remotely meant she needed to be able to review and approve each decision on her own schedule, without the process stalling while everyone waited for a shared meeting slot that suited a lawyer, a general manager, and an owner three time zones apart.

The outcome

Agus's counsel, after reviewing the valuation report and the sales history Rizki had assembled, agreed to a revised working capital figure that reduced the purchase price by an amount close to the full value of the obsolete inventory claim. The adjustment was paid by way of a reduction against amounts still owing under a vendor take-back note that had been part of the original financing, which made settlement straightforward without requiring a fresh payment from either side.

Halina did not recover every dollar she initially thought the inventory issue might be worth; the negotiated figure landed slightly below the valuator's highest estimate, reflecting the usual give-and-take of a settled dispute rather than a fully litigated one. But the outcome corrected the core problem: the price she paid now reflects inventory she can actually sell, not stock that was effectively worthless dressed up at historical cost.

The process also validated the value of putting someone she trusted on the ground. Halina has since told us that without Rizki's willingness to walk the warehouse aisles and flag what looked wrong, the obsolete inventory would likely have sat unnoticed in the numbers indefinitely. She has since changed her onboarding process for future hires to include an inventory walkthrough in the first weeks after any future purchase, working capital adjustment or not.

The distance between Halina and the business she bought turned out to matter less than she had worried it would, mostly because the dispute mechanism in the purchase agreement did not require her physical presence, only accurate information and a timely response. What it did require was trustworthy people willing to look closely at what they were handed, and a lawyer who could turn what they found into a claim that held up under the agreement's own terms. The deal closed remotely and the dispute was resolved the same way, without Halina needing to set foot in the Fort Erie warehouse at any point in the process.

What you can learn from this