Divorce and Asset Division Planner Spreadsheet

About this template

This divorce planner gathers everything a couple owns and owes onto one page, then shows what any proposed split leaves each person with in actual money. It is for people working through a separation who want a clear, shared picture of the figures to take to their solicitors and to each other.

Please read: This arranges your own figures so that two people and their solicitors are looking at one page instead of four. It does not know what a court would order, it does not know your jurisdiction, and a pension is not a bank account however neatly the column adds up. It is not legal advice. Take the page to someone who can tell you what it means.

Assets and debts in one table

The Settlement tab is the heart of this divorce spreadsheet. It holds 80 lines for everything owned and owed, side by side.

• What each item is, what kind it is, what it is worth and whose name it is in
• Debts entered in the same table, shown negative and in red, and netted off the assets
• Total assets, total debts and the net position across the top

Keeping debts in the same list matters. An asset division worked out on assets alone leaves half of the picture out.

A split per line, in money

Instead of one percentage for everything, each line gets its own share to person A, and you can edit it. Two columns then show what that share comes to in money for each side, and both update the moment you move any percentage. The worked example splits the house evenly and the two pensions differently, which is how a real property split often looks.

The overall split, live

At the top, the sheet shows A and B as a share of the whole net figure. A line-by-line agreement that felt even can turn out to be 47/53 once everything is added up, and this is where you see it.

Tasks and bills for the year

A separation still comes with a year of ordinary admin, so the workbook keeps that in the same place as the numbers.

• Tasks: the jobs to get done, so the divorce organizer side is covered too
• Bills: the bills that still need paying
• Dashboard: reads all of it
• Start Here and Setup: a few minutes of guided setup

It works just as well as a separation planner before anything is formal.

Works with

• Microsoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice
• Google Sheets with a free Google account. The Google Sheets version is a real workbook you copy, not a PDF with a link in it.
• No dynamic arrays, no macros, no add-ins and no subscription

What you download

• Two Excel files: a worked example with a house, two pensions split differently and a mortgage, and a blank copy
• The instruction guide, which has one-click links to the Google Sheets versions
• The terms of use as a PDF

Your files are ready as soon as payment clears. The planner is for personal use on your own devices, so please do not share or resell the files. Questions? Get in touch through our contact page.

Frequently asked questions

Do I need Excel, or can I use Google Sheets?

Either. The download has Excel files for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.

Can different assets be split differently?

Yes. Every line has its own percentage to A, so the house can be split one way and the pensions another, and the money each side gets updates as you change it.

Where do debts go?

In the same table as the assets. They show as negative figures in red and are netted off, so the net position at the top includes them.

Will it tell me what a court would award?

No. It arranges the figures you enter and does not know your jurisdiction or what a court would order. It is not legal advice, so take the page to someone qualified.

How many items can I list?

The Settlement tab has 80 lines for assets and debts together.