A co-parenting expense tracker that does the split math for you
The Co-Parenting Expense & Records Log is a shared child-expense and records workbook for two households. Your written agreement may say some costs are split 50/50, some 60/40, and one child’s activity differently again — and it is easy to end up keeping that in a notes app, a string of texts, and a spreadsheet that needs hand math on every row. The workbook keeps all of it in one file and does the arithmetic.
Log what was paid, who paid it, and which child it was for. The workbook applies the split you agreed for that kind of expense, works out each parent’s share, nets every reimbursement against it, and keeps one running figure for who owes whom. It also counts overnights against your regular schedule, alternates the holidays by year, and keeps the communication, document and handover records that tend to get lost.
It works in Excel and Google Sheets — delivered as an .xlsx plus a one-click “Make a copy” Google Sheets link, so both parents can work from one shared copy.
How do you split child expenses when the percentages differ?
The Setup tab names the two parents and up to 4 children, and holds a split table: 12 expense categories — child care, uninsured medical and dental, health insurance, therapy, tuition, school supplies, tutoring, activities, summer camp, clothing, phones and technology, and other agreed extras — each with the percentage from your agreement for the parent named first on Setup. Any category can carry an override per child, for the case where one child’s activity is shared differently.
On the Expense Ledger, each of the 150 rows looks up its own category and child, shows which rule it used, and splits the amount into each parent’s share. The workbook does not decide the percentages. It applies the ones you enter, the same way every time.
Who owes whom? One running balance, both directions
Payments go on the Reimbursements tab — 100 rows, each linked to the expense it pays toward, whether it covers it in full, in part, or goes on account. The Balance tab nets every share and every payment in both directions into one line (“Jordan owes Casey…” in the fictional example), then breaks it down by parent, by category, by child and month by month, and checks that the two parents’ positions mirror each other.
A Check column on the ledger flags a repayment recorded as coming from the parent who paid the original expense, or a repayment larger than what was owed — two mistakes that can quietly move a balance the wrong way.
Counting overnights: scheduled versus actual
Enter your regular 14-day pattern once. The Parenting Time tab lays out a row for every day of the year, fills in the scheduled parent (or the holiday rotation’s parent), and lets you mark only the nights that changed and why — a swap, a make-up night, a missed visit, illness, travel. It counts each parent’s scheduled and actual overnights so far, their share of actual time, the full-year schedule, and the changed nights by reason.
The Holiday Rotation tab lists each holiday and school break with its even-year and odd-year parent; the tracking year decides who has it this year and next, counts the nights, and checks the dates for overlaps.
The records that usually get lost
- Communication Log (150 rows): date, method, who raised it, what was asked, what came back, and a follow-up date. It counts days open and flags anything overdue.
- Records Index (60 requests): report cards, insurance statements, school calendars, activity schedules — who you asked, when it is due, whether it arrived, and where it is filed.
- Handover Checklist: the items that travel between homes down the side and 26 dated handovers across the top. It counts how often each item goes missing and names the one that goes missing most.
A year-end summary you can hand to someone
The Year-End Summary pulls every tab onto one tab for the tracking year: what each parent paid and owed under the split table, payments sent, spending by category and by child, overnights scheduled and actual, communication by month, and the open items as of the date you set on Setup. It is organized so a mediator, attorney or tax preparer can read it — they give the advice; this gives them the numbers.
Try the split math first, free
If you want to see the arithmetic before you buy anything, the free Co-Parenting Shared Expense Ledger is one spreadsheet tab: log each shared child expense and who paid it, set one agreed split for everything, and it keeps a running balance of who owes whom. It opens on the first three months of the same fictional example family, and it is a direct download with no email and no account.
What it deliberately leaves out is everything above: one split for every expense instead of a different split per category and per child, and no payments, parenting-time, holiday, message, document or year-end records. When one percentage stops describing your agreement, that is the point this workbook is for.
Own it, don’t rent it
Instead of a co-parenting app you subscribe to, this is a file you buy once: no app account and no renewal. Keep your own copy, or share one Google Sheets copy between both homes (each of you signs in with your own Google account).
What this workbook is not
It organizes your records and does arithmetic on the figures you enter. It does not calculate child support, interpret a parenting plan or court order, or give legal, tax or financial advice. It is an editable spreadsheet — treat it as your own organized notes, and ask your attorney or mediator whether any record is useful in a legal matter. The example family (Jordan, Casey, Maya and Leo) is fictional.
