Comment Calculer les Provisions pour Retraite en Fin d'Année avec Excel

How to Calculate Year-End Retirement Provisions with Excel – Senegalese Payroll In this video, we address a crucial topic for businesses: calculating year-end retirement provisions. You will learn how to anticipate severance payments for your employees using an automated Excel tool. 📊 Calculation Method: We assume that all employees will retire on December 31st of the current year. This method allows companies to properly provision for retirement benefits, in accordance with **Article 84 of the National Interprofessional Collective Bargaining Agreement of Senegal**. This article stipulates that upon retirement, a special allowance is paid to employees by the employer. 🔍 Content: Explanation of Article 84 concerning retirement benefits and Article 80 for calculating severance pay, with a focus on the calculation percentages. Detailed demonstration of Excel formulas to automate this calculation based on each employee's years of service. Tips for adapting this tool to your company and optimizing your year-end provisions. Don't miss this video! Whether you're a payroll manager or HR manager, this method will help you effectively manage year-end provisions for retirements and comply with legal obligations in Senegal. 🔔 Subscribe to La Paie Sénégalaise for more practical payroll management tips! Contact: [email protected]