Last Updated on March 22, 2026 by Distance Parent
Tracking shared expenses among two co-parents and an adult child is significantly easier with a dedicated three-way expense-tracking spreadsheet that all parties can see in real time.
Tracking expenses and money exchanges in a way that all parties can see is a challenge in any long-distance co-parenting relationship. A longtime Distance Parent community member shares this:
In an earlier post about using free online tools to manage long-distance parenting, I linked to my easy-to-use expense tracking spreadsheet. That expense spreadsheet got my co-parent and me through ten years of co-parenting. I’d call that withstanding the tests of time AND challenging co-parenting. You can have a copy for free if you’d like. Go get it, I’ll wait.
However, when my son went off to college, we started splitting expenses three ways. That meant we needed a new, improved way to track expenses. Enter the new expense tracking spreadsheet.
But although this spreadsheet is borderline magical, there are a few reasons it works for us. So first, before the shiny new spreadsheet, here is why it works for us:
Full Transparency in Expense Tracking
The underlying principle is full transparency. All three parties can see how money is changing hands and being spent at any time. If there is anything anyone wants to handle privately, a gift, for example, that is completely fine. It simply does not go in the sheet and has no effect on the numbers.
Limited Editing Power
A key to making this work is that while everyone can see the spreadsheet, only one person edits it. Both co-parents have a long history of reading spreadsheets and intuitively understand this structure. The adult child took a little longer to get comfortable with it, occasionally wanting to make a change that would have broken the calculations. But having one editor keeps the data clean and the numbers trustworthy.
Spreadsheets are not for everyone. The goal is not to create a system that requires everyone to be equally fluent; it is to create one that everyone can see and trust.
Everything into the Expense Tracking Spreadsheet, Always
The answer to every question about money is “let us look at the spreadsheet.” The answer to every “Did you send me money for X?” is “Is it in the spreadsheet?”
This approach eliminates the back-and-forth of recreating financial history from memory. For a young adult learning to manage their own money for the first time, having a single reference point that shows which receipts have been submitted, how much money is coming from each parent, and for what, and the full transaction history behind every entry is genuinely valuable. It builds financial literacy alongside co-parenting transparency.
The Three-Person Expense Tracking Spreadsheet
It looks a little complicated, but it’s easy to get the hang of. Here’s the link so you can see it and make a copy.
Once you have it, mouse over the column headings to see a note on how each column works and when to use it. The notes column describes the reasoning behind each line item so you can see how a variety of scenarios are handled.
All shaded columns auto-calculate. That is the real value of the spreadsheet: no manual calculation is required. Enter who paid what and who owes how much, and the spreadsheet creates a running tally of who owes what to whom.
This spreadsheet was built for a co-parent and adult child trio, but it works for any three-way expense-splitting arrangement.
How to Use This Alongside Other Long-Distance Parenting Financial Tools
This spreadsheet works best as part of a broader financial planning approach. For the full annual planning process, including budgeting for travel, court costs, and child support, see How to Plan for Long Distance Parenting: The Complete Annual Guide.
For strategies on reducing the travel costs that typically make up the largest share of long-distance parenting expenses, see How to Save Money on Long Distance Parenting Travel.
And for two-person co-parenting expense tracking, see two-person expense spreadsheet template.
Frequently Asked Questions
A shared spreadsheet that all parties can view in real time is one of the most effective tools for tracking co-parent expenses. It eliminates disputes about what was paid, when, and by whom by creating a single source of truth that everyone can reference.
A three-person expense-tracking spreadsheet that records who paid what and automatically calculates running balances is the most practical approach. The key principles are full transparency so all three parties can see the numbers, a single editor to keep the data clean, and a consistent habit of entering everything into the spreadsheet rather than tracking some expenses separately.
Yes. While it was built for a co-parent and adult-child arrangement, the three-person expense-tracking spreadsheet works for any trio splitting shared expenses for roommates, family members, or any other group of three who need a transparent shared record of money exchanges.
The spreadsheet is available here. Click the link and make a copy to your own Google Drive. You do not need to request access, and your copy is entirely your own to edit.
The two-person co-parent expense spreadsheet is a simpler version designed for tracking shared expenses between two co-parents without an adult child in the mix. It uses the same transparency principles and has been used successfully in real co-parenting arrangements for over ten years.
Last updated: March 17th, 2026.
