TFR Calculation in Excel in Italian | Severance Pay, ISTAT Revaluation, Separate Taxation, 70% Advance

How much severance pay have you accrued and how much do you have left? Enter your dates and salary: the spreadsheet calculates your annual contributions, revaluation, and estimated net income.

WHAT DOES IT DO
• Annual severance pay (salary / 13.5 minus the 0.50% contribution to the INPS Guarantee Fund)
• Revaluation of the set-aside fund: 1.5% fixed + 75% of the ISTAT FOI index, with a substitute tax of 17%
• ISTAT table 2000-2036 already filled in: update one number per year
• Gross accrued and net TFR estimated with separate taxation (average IRPEF rate on the reference income, 2026 brackets)
• Pension fund option: reduced taxation 15% → 9%
• Advance: maximum 70% after 8 years, with tax and net of the requested amount

DETAILS
• .xlsx file in Italian, works with Excel, LibreOffice and Google Sheets
• Up to 40 years of service, partial years proportional to the months, different remuneration for each year
• Instructions included, pre-filled example

NOTE
Digital product: no physical items are shipped. Indicative estimate with 2026 rules and rates: it does not replace a labor consultant or the employer's official calculation.
Created with the help of AI tools and verified by hand.