A spreadsheet can do the math, but it cannot tell you whether the numbers going in are current or complete. It also cannot tell you whether everyone at the table is looking at the same numbers.
This does not mean throwing your spreadsheet away. If you built a good one, keep using it for what it does well. The point is only that it may not work well as the record of the settlement. Below is where it can fall short, and some options for each problem.
Count The Copies
The first problem is the attachment. Once you email a workbook, there are two copies. Once the lawyers have it, there may be four.
For example, let’s say that you send a workbook on Monday. On Wednesday, the wife’s lawyer updates the 401(k) balance in her copy. On Friday, the husband’s lawyer changes the support term in his. Both are reasonable edits, and nobody did anything wrong. At the next session, three people have three different totals.
Now you spend the first hour working out whose number is right. Your client pays for that hour, and a question about it on the bill would not be unusual.
Do this instead. Keep one master file, and let only one person change it. Put a version date on every page that leaves your office. If someone wants a change, they ask for it, and you make it.
Check The Formulas
A spreadsheet error does not announce itself. A range misses the row that you inserted last week. A number gets typed over a formula. The total still looks like a total.
This has happened at a national level. In England and Wales, an online version of Form E, the financial statement used in divorce cases, had a faulty formula. Its calculator failed to deduct certain liabilities, so it showed the wrong net assets figure. The Ministry of Justice reported 3,638 cases with the faulty version, including 2,235 closed cases. It also said the error may not have changed those outcomes, because the form is only part of the evidence. Those are English rules and an English form. The point is that a form used by thousands of people carried a bad formula on two separate occasions over several years.
Some people will tell you that a spreadsheet has no history at all. That is not quite right anymore. Current versions of Excel have a Show Changes feature that lists who changed a cell, when they did it, and the earlier value. Use it. But it only helps if everyone works in the same file. It cannot tell you what somebody did in a copy on their own laptop.
Before any number goes to a client, it may help to check these things:
- Totals – Add the main totals a second way, even on a calculator.
- Typed Numbers – Look for typed numbers sitting where a formula should be.
- A Second Reader – Have someone who did not build the file trace one figure from the statement to the final page.
Check The Year
A template carries old law forward quietly. This error can be hard to spot, because the math in the file is still correct.
Below are some of the things that go stale:
- Tax Amounts – The IRS adjusts many amounts every year. For 2026, the standard deduction is $16,100 for a single filer, $24,150 for a head of household and $32,200 on a joint return. Check for later changes.
- Filing Status – Marital status is decided on the last day of the tax year. A decree signed on December 31 and one signed on January 2 can produce very different projections.
- Alimony – Under an agreement made after 2018, alimony is not deductible by the payer and is not income to the recipient. Older instruments can follow the old rule, so do not copy the treatment from an old matter.
- Child Support – Federal rules require each state to review its child support guidelines at least once every four years. If you hard-coded a formula, check that it still matches your state’s current guideline.
Show What The Number Is Made Of
A spreadsheet treats a dollar as a dollar. Your client should not.
For example, let’s say that one spouse gets $100,000 in a savings account and the other gets $100,000 in a 401(k). The sheet shows an even split. It is not even. The money in the 401(k) will generally be taxed when it comes out, and the savings account has no such bill waiting.
The same thing happens with property. When one spouse transfers property to the other as part of a divorce, the person who receives it generally takes the same tax basis. A stock position worth $100,000 with a $20,000 basis carries a tax bill that does not appear in a value column.
The sheet also does not know about dates outside the file. Equity awards vest on their own schedule. A QDRO has to go to the plan administrator, who decides whether it qualifies within what federal guidance calls a reasonable period of time. If your sheet assumes the retirement money moves next month, say so on the page.
One option is to add a column for tax treatment and a column for basis to every asset line. Yes, that means more work up front. It also means fewer surprises after your client signs.
Date Every Balance
Every balance in a spreadsheet was typed by someone on some day. It starts getting old as soon as the next statement closes.
Next to each balance, one option is to put the statement date and the page it came from. If a balance is more than a statement or two old, mark it. Then anyone reading the sheet can see what is firm and what needs a fresh look.
Be Careful What You Attach
A settlement workbook often holds account numbers, income detail and business records for two people. Once you attach it to an email, you cannot take it back.
If you are a lawyer, read ABA Formal Opinion 477R on protecting client communications, and then check your own state’s guidance.
If you are a mediator, there is one more trap. The Model Standards of Conduct for Mediators say that what you learn in a private session should not be passed on without that person’s consent. A tab that you built during a caucus can do exactly that if it stays in the file you send to both sides. Do not reuse that file. Check your state’s rules too, because they vary.
Below are some habits that may help:
- Clean Copy – Send a PDF of what the person needs to see, and keep the working file with you.
- Strip The Extras – Remove account numbers that the reader does not need, and check for hidden tabs and rows.
- Secure Delivery – Use a secure portal or encrypted email for anything sensitive.
Start With One Closed File
Pull a matter that you closed this year and open the last version of the spreadsheet. Pick three figures from the final agreement, and trace each one back to a statement. Then check the tax year in the template. You will know quickly whether your file needs repairs before your next client sees it.
See what your last matter missed. Bring VennBoard one closed matter. We’ll run an accuracy audit against the final outcome. If the readout is useful, you can start a no-cost 3-month pilot on live matters. Invite three colleagues, and when they join, you get 3 more months free. Start my pilot
This article is general information, not legal, tax or financial advice. Rules vary by state.
Related:
- What should you ask for in divorce discovery?
- How much should you discount a retirement account for taxes?
- What did the 2017 tax law change for divorce, and what still applies?
- How do you divide RSUs and bonuses in a divorce?