See the whole year of parenting time on a single page. This parenting time log lets you mark every scheduled day with one letter — used, late, ended early, declined or no-show — and instantly counts each month and the year, including the share of scheduled time that was actually used.
Who this template is for
- Parents documenting how scheduled time is used
- Co-parents tracking late or missed exchanges
- Parents organizing records for mediation or a lawyer
Features
- Full-year grid: 12 months × 31 days on one landscape page, for any year from 2024 to 2040.
- 5 simple codes from a drop-down: U used, L late, E ended early, D declined, N no-show, each with its own color.
- Weekends shaded and dates that don’t exist (like February 30) blocked out automatically.
- Monthly and yearly totals for every code and the % of scheduled time used, with months under 80% highlighted.
- Stacked chart of logged days by month.
- Notes tab for dated, factual notes: what happened, how you were contacted and a reference to any message or screenshot.
How to use it
- Download the file and open it in Excel or upload it to Google Sheets.
- Pick the year at the top of the Year Log.
- For each scheduled parenting day, choose a code in the grid.
- Add a short note for late, declined or no-show days on the Notes tab.
What’s included
- 1 .xlsx file with 3 tabs: Start Here, Year Log and Notes.
- Four months of sample entries (delete them to start fresh).
Compatibility
Works in Microsoft Excel (desktop, Mac and Excel online) and Google Sheets. No add-ons or macros required.
FAQ
How is the % of time used calculated?
Used, late and ended-early days divided by all logged days for that month or year.
Can I use it for several years?
Save one copy per year: clear the codes and pick the new year.
Is this legal advice?
No. It is a record-keeping tool. Keep entries factual and ask a family lawyer how to use your records.
Does it work in the free version of Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. A free Google account is all you need.
Can I use it on a Mac, iPad or phone?
Yes. It works in Excel for Mac and Windows, Excel online and the Google Sheets app. For editing, a computer or tablet is the most comfortable.
How do I get the file?
Right after checkout you get a download link on the confirmation page and by email.
More templates like this: Co-Parenting Templates.
This is a digital product. No physical item will be shipped.
Reviews
There are no reviews yet.