A Free Co-Parenting Expense Tracker (Google Sheets Template)
Shared expenses — medical copays, school fees, activities, clothes — are a top source of co-parenting conflict, and almost always for the same reason: there’s no single, trusted record of what was spent, how it’s split, and who’s paid. A free Google Sheet solves that completely, and the transparency itself defuses most money arguments before they start.
Download the free starter template (CSV) — open it in Google Sheets (File → Import) or Excel and adapt it, or build your own with the steps below.
The columns you need
Keep it simple. These columns cover almost every situation:
| Column | What it’s for |
|---|---|
| Date | When the expense happened |
| Description | What it was (e.g., “School registration fee”) |
| Category | Medical, School, Clothing, Activities, etc. |
| Paid by | Which parent actually paid |
| Amount | The total cost |
| Split % (you) | Your share of the split (e.g., 50) |
| You paid | Amount you paid (0 if the other parent paid) |
| Your share | What you owe on this expense = Amount × Split% |
| Running balance | The rolling total of who owes whom |
| Notes | Receipt saved? Anything to flag |
The one formula that does the work
The running balance is what makes this powerful — it always shows the current tally so no one has to reconstruct months of receipts.
For each row, the amount that shifts the balance in your favor is what you paid minus your share (if you paid more than your share, the other parent owes you the difference). So:
- In “Your share”:
= Amount * (Split% / 100) - In “Running balance” (first row):
= [You paid] - [Your share] - In “Running balance” (every row after):
= [previous running balance] + [You paid] - [Your share]
A positive running balance means your co-parent owes you that amount; a negative number means you owe them. That’s it — the sheet keeps a live answer to “who owes whom?”
Set it up as a shared record
- Import the template into Google Sheets (or start a blank sheet with the columns above).
- Share it with your co-parent (Share → add their email → Editor if you both log expenses, or Viewer if only one of you does).
- Agree the ground rules once: the split percentage, which categories count as shared, whether receipts are required, and how often you settle up (monthly is common).
- Log expenses as they happen, not in a monthly scramble — a shared, current record is what keeps it fair.
Rules that keep money from becoming conflict
- Agree the split and categories in writing first. Most disputes are about whether something is shared, not the math.
- Attach or note receipts for anything significant.
- Settle up on a regular cadence so balances never grow into a fight.
- Keep the notes factual. It’s a ledger, not a place for commentary.
What a spreadsheet doesn’t do
- It’s a record between the two of you, not certified court documentation. For legal proceedings, keep receipts and consider an app with certified records.
- It doesn’t move money — pair it with whatever payment method you already use.
- It relies on both parents keeping it honest and current.
For cooperative co-parents, none of that is a dealbreaker — a transparent, shared, free ledger is often all you need, and the openness alone prevents a lot of conflict. If you need certified records or built-in payments, see how the dedicated apps compare.
Bottom line
A free Google Sheet with a running balance turns co-parenting money from a recurring argument into a shared, transparent fact. Download the starter template, agree on your split, and log as you go — it’s one of the highest-impact free tools for reducing conflict.
Frequently asked questions
How do I track co-parenting expenses for free?
Use a shared Google Sheet. Log each shared child expense with the date, amount, category, how it's split, and who paid. Add one formula for a running balance so the sheet always shows who owes whom. It's free, transparent, and works on any device. You can start from our free template.
How should co-parents split expenses?
Many parents split shared child costs 50/50, but some use an income-proportional split (for example, 60/40) if that's in their agreement. The key is to agree on the split and the categories in advance, write it down, and apply it consistently — the spreadsheet just makes that visible and fair.
Is a spreadsheet enough, or do I need an app?
For transparent tracking between cooperative parents, a spreadsheet is genuinely enough and it's free. If you need court-ready documentation, built-in payments, or a record that can't be edited after the fact, a dedicated co-parenting app with expense features may be worth it.