Keep a clear record of every scheduled visit. This visitation tracker compares planned and actual pickup and return times, calculates minutes late and hours of parenting time, and turns your log into a yearly dashboard of visits kept and missed.
Who this template is for
- Parents documenting parenting time
- Grandparents and relatives with visitation
- Parents tracking missed or late exchanges
Features
- Visits log (400 lines): visit date, return date, planned and actual pickup and return times, location and notes.
- Automatic calculations: minutes late at pickup and total hours together, including overnight and weekend visits.
- 8 color-coded statuses: Completed, Late pickup, Late return, Shortened, Missed, Cancelled by the other parent, Cancelled by me and Rescheduled.
- Yearly dashboard: visits kept, missed or cancelled, percentage kept, hours together and average lateness.
- Month-by-month table, status breakdown and a kept-vs-missed chart.
- Printable paper log to fill in by hand and copy in later. No macros.
How to use it
- Download the file and open it in Excel or upload it to Google Sheets.
- After each visit, add the dates and the planned and actual times on the Visits tab.
- Choose a status and add a short, factual note.
- Pick a year on the Dashboard to review the totals.
What’s included
- 1 .xlsx file with 4 tabs: Start Here, Dashboard, Visits and Printable Log.
- Sample visits so you can see how it works (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
Does it handle weekend visits?
Yes. Enter a return date and the hours are calculated across the whole weekend.
Can I track more than one year?
Yes. Keep logging in the same file and switch the year on the Dashboard.
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.