Marital Balance Sheet Template (Excel + Google Sheets, Free)
What's inside the marital balance sheet template
The workbook has one Assets & Debts sheet, up to 100 rows. Each row is one item - a house, a retirement account, a credit card balance - with a type (Asset or Debt) and an attribution (Spouse A, Spouse B, Joint, or To divide).
Net effect calculates automatically for every row: an asset adds to the total, a debt subtracts from it. Because attribution and net effect are separate columns, you can re-attribute an item without re-typing its value - just change the dropdown.
This works for any state, unlike the single-state .xlsx forms from individual family-law firms found in top search results - you enter your own state's community-property or equitable-distribution split manually via the attribution column.
Community vs. separate property, and marital debt
Whether your state follows community property or equitable distribution, the underlying task is the same: sort every asset and debt into what belongs to each spouse individually, what's joint, and what's still being negotiated.
Marital debt gets the same attribution treatment as assets - a credit card balance attributed to Spouse A reduces that spouse's net worth in the summary, exactly the way debt reduces net worth in real life.
Every free law-firm .xlsx we found in search results uses a manual fill-in-the-blank column layout for the split; this template's SUMIF-driven summary calculates each spouse's running total automatically instead.
Settlement summary and the equalization gap
The summary below the table shows Spouse A's net worth, Spouse B's net worth, joint net worth, items still to divide, and total marital net worth - all calculated automatically from your attribution and value entries.
It also calculates the equalization gap (Spouse A's net worth minus Spouse B's) and the equalization payment needed to bring both spouses to an equal net worth - a dashboard feature none of the free law-firm or divorce-finance downloads in search results include; only a $99 paid Etsy listing offers comparable polish, without this automation.
Who this template is for
People going through a divorce or separation who need an organized starting point to list assets and debts, propose a split, and see the numbers behind a settlement discussion before involving attorneys or mediators.
This is an informational worksheet, not legal or financial advice. Property division rules vary significantly by state - consult an attorney before relying on this template for an actual settlement or court filing.
How to use it
- List every asset and debt: item name, type (Asset or Debt), attribution, and value.
- Net effect calculates automatically - debts subtract, assets add.
- Check the summary for each spouse's net worth and the equalization payment needed for a 50/50 split.
Download the free Marital Balance Sheet Template (Excel + Google Sheets, Free)
No spam — template updates and new free templates only. Unsubscribe anytime.
Frequently asked questions
Is this legal or financial advice?
No. This is an informational worksheet, not legal or financial advice - property division rules vary by state, so consult an attorney before relying on it for a settlement.
Does it work for any state?
Yes, structurally. The attribution dropdown (Spouse A / Spouse B / Joint / To divide) works whether your state follows community property or equitable distribution - you apply your state's rules when you choose each item's attribution.
What is the equalization payment?
It's the amount one spouse would need to pay the other so both end up with equal net worth, calculated as half the gap between Spouse A's and Spouse B's net worth. It's a negotiation starting point, not a court-ready figure.
Can I use this in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. The attribution dropdowns and summary formulas keep working.
How many assets and debts can I list?
Up to 100 rows on the Assets & Debts sheet - enough for most household balance sheets, including multiple accounts, properties and debts.
What's the usage license?
Personal use. It's not meant to be resold or redistributed as a template product.