Time-Off Liability Accrual with Vacation & PTO Proration
Seed: Employee table (hire_date, accrual_rate, balance), formula: ProratedAccrual = AccrualRate*FTE*MonthsInPeriod/12ADVERTISEMENT - IN-ARTICLE
Implementation Guide
Calculates vacation/PTO liabilities by employee, accounting for accrual policies, carryovers, caps, and termination payouts. Produces monthly liability accrual schedules, journal entries, and projected cash-out scenarios under various severance assumptions. Supports country-specific rules (carryover limits, payout caps) and a review sheet to identify employees exceeding policy thresholds. Useful for HR and finance to provision appropriate liabilities and for auditors to sample calculations.
💡 Expert Q&A Insights
Q: \
How to handle negative balances?\" \"
Q: Flag negatives in the review sheet; apply company policy for advance time or require manager approval.\"\n\"
Can it calculate expected cash-out for layoff scenarios?\" \"