The Estate Spreadsheet That Never Quite Balanced

The situation

Vesna had already tried to do this herself, twice, before she called our office. Her father died in Simcoe with a modest estate, a house, some savings, a small line of credit, and a will that named Vesna as executor and left a specific, deliberately modest amount, ten thousand dollars, to her sister Kumari, from whom their father had been estranged for close to fifteen years. The rest was to go to Vesna. Their father had explained the small legacy to Vesna before he died: he did not want to cut Kumari out entirely, because an outright exclusion of a child, he had been told, tends to look like an oversight or a grudge and invites exactly the kind of challenge a small, deliberate gift is meant to head off.

Vesna's first attempt was a spreadsheet, built from bank statements and the house's assessed value, meant to work out what was left for her once Kumari's ten thousand dollars and the outstanding debts were paid. It did not balance. Her second attempt involved a free online estate calculator and a call to her father's bank, which gave her an account balance that did not match what she remembered seeing on his most recent statement. Frustrated, she paid herself a partial distribution anyway, roughly forty thousand dollars, reasoning that even in the worst version of her numbers, that much was clearly hers, and she needed the money to cover expenses she had been carrying since her father's death.

The estate, once everything was eventually accounted for, sat somewhere between three hundred and six hundred thousand dollars, mostly in the house. Vesna worked as a forklift operator, a steady but modest income, and had never handled anything like an estate before. Kumari, a letter carrier, had not been in contact with their father in years, following a falling out neither sister fully discussed even with each other, but she was owed her ten thousand dollars regardless of the history, and she was watching the process from a distance, waiting.

By the time Vesna came to us, she had already made that partial distribution to herself, already told Kumari a rough timeline for her payment based on numbers Vesna no longer fully trusted, and already spent hours trying to find where her spreadsheet went wrong without success. She was not looking for a second opinion on the will. She wanted someone to tell her why the numbers would not add up, and whether the forty thousand dollars she had already taken was going to be a problem.

The gap nobody had noticed

The imbalance in Vesna's spreadsheet came from a line of credit secured against the house that her father had drawn on more heavily in his last two years than anyone in the family realized. Vesna knew the line of credit existed. What she did not know, because the statements she had been working from were incomplete, was that the balance had grown substantially, used to cover a period of medical costs and home repairs their father had never mentioned to either daughter. The house's equity, the figure Vesna's whole plan depended on, was meaningfully lower than she had assumed.

There was a second gap layered under the first. A small joint account, opened years earlier with a family friend, Nuwan, who had helped their father with errands and paperwork in his final years, held a modest sum that Vesna had initially assumed was part of the estate. On its face, a joint account with a right of survivorship simply passes to the surviving holder outside the estate, but that is not automatic once the account was opened between a parent and someone other than a spouse. Ontario law presumes, in that situation, that the surviving holder receives the funds in trust for the estate rather than outright, and that presumption has to be rebutted with real evidence of what the father actually intended before Nuwan's claim to the money could be accepted. The account's opening file and the bank's own notes from when it was set up showed the father had told the bank plainly that the account was meant to help Nuwan cover errands and expenses on his behalf during his lifetime, with the remaining balance intended as Nuwan's afterward, which was enough contemporaneous evidence to rebut the presumption. Vesna had included that account in her early spreadsheet as an estate asset regardless, inflating her own expected share by an amount that, once the presumption was properly worked through, was never actually available to distribute.

Put together, the estate was worth less than Vesna's own math had told her, twice over: once because the debt against the house was bigger than she knew, and again because an asset she had counted as available was never part of the estate at all. The forty thousand dollar distribution she had already paid herself, reasonable against her original numbers, was no longer clearly safe against the corrected ones. An executor who distributes estate funds before the accounting is settled, and turns out to have taken more than the estate can support once debts and correct valuations are accounted for, can be personally liable to repay the difference, to creditors or to other beneficiaries, including Kumari.

None of this reflected anything dishonest in what Vesna had done. It reflected the ordinary risk of an executor working from partial bank statements and an outdated understanding of a parent's finances, treating a spreadsheet built on incomplete information as though it were a settled account. The gap was not visible until someone pulled the full history of the line of credit and checked the joint account's actual ownership, two steps Vesna's own efforts had not included.

What we did

1. Requested the complete line of credit history directly from the bank, going back several years rather than relying on the most recent statement Vesna had been working from, which revealed the true scope of the borrowing against the house and the actual equity remaining in the estate once the balance was properly totalled.
2. Investigated whether the joint account held with Nuwan was actually outside the estate, rather than assuming survivorship settled the question. Because the account was opened between a parent and a non-spouse, Ontario law presumes the funds are held in trust for the estate unless the survivor can show the parent genuinely intended a gift, so we obtained the bank's account-opening file and its internal notes to see what the father had told the bank at the time, which let us confirm, rather than assume, the money legitimately belonged to Nuwan.
3. Obtained an updated valuation of the house from a local appraiser to replace the informal estimate Vesna's spreadsheet had relied on, giving the rebuilt accounting a defensible figure for the estate's largest asset rather than a guess based on nearby listings Vesna had found online.
4. Rebuilt the estate accounting from source documents, working directly from bank and title records rather than Vesna's spreadsheet, to establish an accurate picture of what the estate actually contained once the debt, the correct house value, and the joint account were all correctly treated together.
5. Assessed the exposure created by the early distribution, reviewing whether the forty thousand dollars Vesna had already paid herself exceeded what the corrected accounting showed she was entitled to, and explaining plainly, with the numbers laid out side by side, what her personal liability looked like now that the gap was visible.
6. Advised Vesna to hold further distributions until the full accounting was settled, preventing a second premature payment from compounding the first before the true size of the debt and the joint account correction were even confirmed. We explained why that caution matters for an executor specifically: distributing again on numbers still under review would have made any eventual shortfall larger and harder to unwind, and would have weakened her position if a beneficiary or creditor later questioned how carefully she had handled the estate.
7. Communicated the corrected numbers to Kumari directly, explaining the delay honestly and walking through why the original timeline no longer held, rather than letting an inaccurate estimate stand unexplained until the payment itself was late. Being upfront about the accounting problem, before Kumari had any reason to ask, reduced the risk that she would read the slower pace as an attempt to shortchange or stall her, and kept the relationship between the sisters from souring over a delay that was really about getting the numbers right.
8. Arranged a repayment plan for the shortfall, since the corrected accounting showed Vesna's earlier distribution had left her ahead of what she was actually owed, structuring a schedule that let her repay the difference from her own income over several months rather than requiring an immediate lump sum she did not have, before finalizing the accounts and completing distribution to Kumari in full.

The outcome

Kumari received her ten thousand dollar legacy in full, on the timeline the corrected accounting supported, and the deliberate strategy behind that modest gift held: she did not challenge the will, and the estate closed without litigation. That part of the plan worked exactly as their father had intended when he chose a small, specific amount over excluding Kumari outright, and the honest explanation of the delay appears to have mattered as much as the payment itself in keeping her from reading the slower timeline as bad faith.

Vesna's position was harder. The corrected accounting showed her actual entitlement was several thousand dollars less than the forty thousand she had already taken, once the true size of the line of credit and the joint account correction were both factored in. She repaid the difference over several months rather than all at once, an outcome that cost her real money and required an uncomfortable conversation with her own family about a mistake made in good faith. It was not the clean result she had hoped for when she first sat down with her spreadsheet the week after the funeral.

What was contained, rather than avoided, was the larger risk: a personal liability claim from Kumari or from a creditor, arising months or years later once someone else noticed the same gap Vesna's own efforts had missed. Acting to correct the accounting before distribution finished, rather than after a dispute forced the issue, meant the shortfall was resolved quietly and on Vesna's own terms, at a cost she could manage rather than one imposed on her later by a formal claim and the added expense of defending it.

Vesna later said the hardest part was not the repayment itself but realizing how close she had come to a bigger problem without ever intending to do anything wrong. Nuwan was never drawn into a dispute over the joint account, since its treatment had been correctly identified before any transfer or distribution touched it, leaving that relationship, and the rest of the estate, undisturbed by the accounting error that had caused everything else.

What you can learn from this