SOURCE: Vacation Tracker TITLE: Year-end PTO liability for finance URL: https://vacationtracker.io/ai-prompt-library/liability/ LANG: en PUBLISHED: 2026-11-19 UPDATED: 2026-11-19 SUMMARY: Calculate PTO liability by department with Claude or ChatGPT. Your AI joins live leave balances with your payroll file and writes the summary. # Year-end PTO liability for finance Payroll file + Vacation Tracker ยท Reports Your AI pulls every vacation balance from Vacation Tracker, applies the daily rates from your payroll export, and writes the PTO liability summary finance asks for, by department. ## What you ask ``` Pull every vacation balance as of Dec 31. Using daily rates from your payroll export, calculate our PTO liability by department, show what changes if we cap rollover at 5 days, and write a one-page summary for finance. ``` Attach the file in your AI tool before you send. It stays in your AI conversation. ## Before you start - Who it's for: People Ops - Plan: Core or Complete - Safety: Read-only. Pay data stays in your AI conversation and isn't sent to Vacation Tracker. - Works in: Claude (https://vacationtracker.io/integrations/mcp/claude/), ChatGPT (https://vacationtracker.io/integrations/mcp/chatgpt/), Gemini (https://vacationtracker.io/integrations/mcp/gemini/), Copilot (https://vacationtracker.io/integrations/mcp/copilot-studio/), Grok (https://vacationtracker.io/integrations/mcp/grok/), Perplexity (https://vacationtracker.io/integrations/mcp/perplexity/), Cursor (https://vacationtracker.io/integrations/mcp/cursor/), Windsurf (https://vacationtracker.io/integrations/mcp/windsurf/), Cline (https://vacationtracker.io/integrations/mcp/cline/) ## What your AI does - Joins balances with your payroll file - Does the math by department - Writes the finance summary ## What it touches in Vacation Tracker - Reads: Lists everyone - Reads: Reads each balance ## What you get back (Sample workspace. People and numbers are made up.) AI: Total liability: $412,800 across 118 people. Engineering is 41% of it. Capping rollover at 5 days lowers it by about $96,000. The one-page summary is ready. ## Try these report prompts next - Get a Monday leave briefing (https://vacationtracker.io/ai-prompt-library/monday-briefing/): Coverage risks, stuck requests and upcoming holidays, every Monday in five bullets. - Year in review: how your team took time off (https://vacationtracker.io/ai-prompt-library/year-review/): Charts leave by team and month, with the outliers worth a conversation. - Spot people who haven't had a real break (https://vacationtracker.io/ai-prompt-library/no-break/): Finds people who haven't had a real break and suggests dates for each.