Free · Excel + Google Sheets · No macros

Free Co-Parenting Calendar Template (Excel)

This free co-parenting calendar assigns each day of the month to Parent A or Parent B, then calculates nights per parent and the percentage split automatically. A separate Shared Expenses sheet splits costs by percentage and shows what each parent owes the other. It's an informational tracking tool, not a custody agreement. Works in Excel and Google Sheets.

Download free template

What's in the co-parenting calendar template

The workbook has two tabs. Custody Calendar has one row prefilled per day of the month, 1 through 31 - assign Parent A or Parent B to each day and add exchange notes as needed. Nights per parent and the % split calculate automatically below the table.

Shared Expenses logs every shared cost - amount, who paid, and the percentage the other parent owes - with the owed amount, totals paid per parent, and the net amount owed to each parent calculating automatically.

% split stays blank, not a divide-by-zero error, until at least one day is assigned - so an empty calendar never shows a misleading 0% or 100%.

Real calculation, not a bricked-together spreadsheet

Custody X Change's page walks through how to build a custody calendar in Excel yourself, then pushes toward their own paid software - it doesn't hand you a working file. bestinterest.app offers a solid free Google Sheet with night credits, but no native Excel version and no printable summary. The Etsy 'Green Planner' listing is a paid, simply-styled calendar with little automated calculation documented.

This file arrives with the nights-per-parent count and the % split already calculating from your entries - and it adds a shared-expenses tab with automatic owed-amount math that none of those alternatives include.

Shared expenses: who owes whom, automatically

Splitting costs 50/50 - or any other percentage - across two households is normally tracked in a separate note or a running mental tally. Here, each shared expense row calculates exactly what the non-paying parent owes, and the summary nets it out into one 'owed to Parent A' or 'owed to Parent B' figure.

Split % doesn't have to be 50/50 on every row - enter whatever percentage applies to that specific expense (school fees, medical costs, activities).

Who this template is for and its limits

Co-parents who want a simple, neutral way to track the custody schedule and shared costs day to day or month to month, without paying for custody-management software.

This is an informational tracking tool, not a custody agreement, legal document or mediation filing - always follow your actual parenting plan or court order, and use this only to track and document what was already agreed.

How to use it

  1. Assign Parent A or Parent B to each prefilled day on Custody Calendar.
  2. Nights per parent and % split calculate automatically below the table.
  3. Log shared expenses with who paid and the % owed - owed amounts calculate automatically on Shared Expenses.

Frequently asked questions

Is this a legal custody agreement?

No. This is an informational tracking tool, not a custody agreement - always follow your actual parenting plan or court order and use this only to track what was agreed.

Does it calculate nights per parent automatically?

Yes. Assign a parent to each day and the summary counts nights per parent and calculates the % split automatically.

How are shared expenses split?

You enter who paid and the percentage the other parent owes for that expense - it doesn't have to be 50/50 every time. The owed amount and the net owed to each parent calculate automatically.

Can I use this in Google Sheets?

Yes. Upload the downloaded file to Google Drive, open it, and choose File > Save as Google Sheets - the formulas keep working.

What's the usage license?

Personal use. It's not meant to be resold or redistributed as a template product.

Related free templates