IMPORTANT!

The PAYE calculator requires that you enable macros for functionality. Instructions are provided in the file for the procedure required to enable macros.
The 'Employee tax calculator' reflects the changes announced by the 2021 Budget announced on October 13th 2020. This file will work in Excel 2010 and greater. All of the other files will work in Excel 2003 and greater.
I welcome your feedback, especially suggestions for making the PAYE calculator better or easier to use! E-mail me or sign the guestbook

Current release number: 2014-21.03

Change log:

2014-21.03

The following improvements were introduced in version 2014-21.03:
• Updated the percentages used by the 'My statistics' tool to calculate how taxes are spent from the whereyourmoneygoes.gov.ie website.
• Added a feature which allows the user to add shortcuts to an easily accessible 'My shortcuts' hub.
• Added a check which runs when the calculator is opened if 'auto-updates alerts' is set to 'Off' (the default setting) and which allows the user to toggle this setting to 'On'.

2014-21.02

The following improvements were introduced in version 2014-21.02:
• Added the revised USC and PRSI thresholds in respect of minimum wage employees
• Corrected error impacting the calculation of prior year USC

2014-21.01

The following features and improvements were introduced in version 2014-21.01:
• Enhanced the following premium calculator features: net-to-gross calculation; setting tax status [cumulative, W1/M1 or emergency bases]; manually editing income and deduction values; deductions pie-chart; editing tax credits or cut-off points during a year.
• Added option to allow premium users to reduce workbook size by deleting images and shapes used only by the free-version.
• [USER REQUESTED] Added capability to allow a user to modify standard tax credits or cut-off point (e.g. for items such as flat rate expenses or tax repayment plans).
• Added new resource to cater for e-bike and pedal bike thresholds introduced with effect from 1 August 2020 (cycle-to-work deductions).
• Enhanced the 'prior year settings' panel to include option to exclude salary sacrifice items from prior year calculations.
• Added a 'beta tool' feature which allows users to see how the introduction of 'pension auto-enrolment' will impact their net pay.
• Added new (and improved existing) help resources and web links.
• Fixed various bugs, implemented code performance improvements and added higher quality images and icons.

2014-20.06

The following features and improvements were introduced in version 2014-20.06:
• Added data to cater for employer PRSI impact of agreed increase in the hourly rate of the Minimum Wage.
• Fixed a bug impacting manual edits of PRSI class (Premium users only).
• Added new and improved help resources.
• Fixed various formula bugs.
• UPDATE: Added data for revised USC thresholds (effective from 1 February 2020) as announced 10th January 2020.

2014-20.05

The following features and improvements were introduced in version 2014-20.05:
• Improved the visibility of showing the 'bonus as net amount' feature
• Updated the help files relating to the above feature
• Added an 'Auto-move' property to the 'All settings' panel so that it would move if content was obscured.

2014-20.04

The following features and improvements were introduced in version 2014-20.04:
• Improved visibility of how available updates are alerted to the user by popup notification when the calculator is opened.
• Enhanced Help panel content by enabling the addition of an 'Additional information' pane to the base of the main help panel if required. This additional panel can contain links to external websites or run macros as needed to supplement the main help text.

2014-20.03

PREMIUM USERS:
• User can more easily view a mini deductions pie chart from the annual summary section of the 'Start here' sheet.
• Allow the user to manually change his/her PRSI class. This may be useful for certain public sector roles if the calculator determined PRSI class is incorrect.
• Corrected an error which impacted the PRSI percentage value displayed on the deductions chart.

ALL USERS:
• Implemented a tax saving tip highlighting how a user might increase his/her take home pay by taking a paycut but save a greater amount on PRSI deductions.
• Improvements to the 'Quick tour' feature (ensures that certain images are hidden on start of tour).
• Improvements to the opening routines procedures.
• Enhanced prominence of how the 'fast accrual' setting is displayed (only relevant to pension levy/ ASC calculations for certain public sector staff).
• Corrected an error on the panel showing tax/ levies deducted from annual bonus.

2014-20.02


• Fixed a bug affecting data validation of 'Net to gross' section.
• Minor interface improvements

2014-20.01

All users:

• Interface changes- more subdued colours, larger font size, some icons are larger.
• 'Quick guide' displayed on first time the workbook is opened.
• Amendments to Public Sector pension deductions to allow for non-standard working weeks for staff recruited post 6 April 1995.
• Fixed a bug affecting spouse calculations where spouse was employed in public sector.
• Updated percentage spending by government department for 2019.
• Employer contributions to three common types of pension fund ('Occupational', 'PRSA' or 'RAC') can now be included with relevant tax treatment (if any) as a benefit-in-kind properly handled.
• PRSI exemption (applies mainly to staff posted to Ireland on relatively short term contracts) provided for.

Premium version only:

• Menu on all worksheets now allow for navigation to a payslip.
• Users can now set the length of their non-standard working week durations to include half day options e.g. "Show me the net pay impact if I work a 3-and-a-half day week for 1 or more pay periods."
• Users can also generate a single report showing the annual and per period pay impact of a non-standard working week for ALL working week durations between 1 day to 6 days a week in half-day increments.
• Improved error handling for deductions chart.
• Added additional resources to the FAQ menu on the 'Net pay calculations' worksheet.

2014-19.09

This version adds additional help resources and alerts (e.g. help for 'How can I reduce top rate tax?') as well as various bug fixes, user interface and performance improvements.

2014-19.08


• This version corrects an error in the calculation of gross bonuses required for a 'bonus-as-net' target and also for the Additional Superannuation Contribution for certain public servants.
• It also enhances the 'Quick tax settings' panel by including an estimated tax credits entitlements link (to show the user the expected tax credits s/he is entitled to based on user specified settings).
• Other miscellaneous bug fixes and performance improvements.

2014-19.07


• This version corrects an error in the calculation of pension deductions for public servants.

2014-19.06


• This version includes the adjustments to the pension deductions for certain public servant staff arising from the increase in the weekly state pension effective from 25th March 2019.
• Some minor improvements to sheet navigation on the 'Detailed calculations' sheet (premium version)
• Additional Help resources
• Various bug fixes and code enhancements.

2014-19.05


• Improved handling of non-standard bases of calculation (premium version only)
• Additional tax saving tip for dual income couples regarding availability of Home carer tax credit in specified circumstances.
• Additional Help resources
• Various bug fixes and code enhancements.

2014-19.04


• Included ability to treat a bonus as a 'net of tax' value (premium version only).
• Fixed a data connection error which caused data lists to not download.
• Fixed an error for company directors which impacted their PRSI classification.

2014-19.03


• Included 'Community employment' option in employment sector.
• Fixed an error in how premium version activation codes are evaluated.
• Minor interface improvements to the 'All settings' menu.
• Various bug fixes and code enhancements.

2014-19.02


• This version introduces various interface and performance improvements and bug fixes.

2014-19.01

This version introduces the following features:
• Simple to use 'tax settings' panel
• Statistical data showing how taxes are spent, user's 'tax free day' and user's average tax rates
• Improved fine-tuning of pension and PHI deductions if the deduction is specified as a percentage of pay
• General bug fixes, help resources and interface enhancements

2014-18.07

This version introduces the following features:
• 'Benefits-in-kind' calculator (premium version only)
• 'Simple version' of the calculator
• Various interface enhancements, performance improvements and bug fixes

2014-18.06

This version updates the Old Age Pension value (which changed March 26th and is used when calculating certain Public Sector pension deductions).

2014-18.05

This version corrects an error which impacted on the manual edit of post tax deductions values.

2014-18.04

This version includes the 'minimum PRSI liability' which applies to Class S company directors earning between €5000 and €12500 in 2018. Thanks to PN for notifying me of same.

2014-18.03

New features
• Introduced ability to display number of PRSI contribution weeks per pay period.
• Implemented an income disregard for USC purposes (for legally enforceable maintenance payments).
• Implemented handling of PRSI class changeover if an employee turns 66 (class J PRSI from pensionable age if still an employee).

Improved features
• PHI, Pension and cycle-to-work limits better handled.
• Additional help panel resources.
• Improvements to functions used to determine appropriate PRSI class.
• Changes to the workbook closing process.

Error corrections
• Corrected an error for comparative tax credits of company directors.
• Corrected conditional formatting errors affecting identification of manually edited values.

2014-18.02

This update corrects the USC rates applying if a full medical card is held.

2014-18.01

This update handles the tax years 2014 to 2018 inclusive.

2014-17.03

This corrects an error in the calculation of tax credits for a spouse whose employment status is set to 'Private sector- Company Director'.

2014-17.02

This corrects an error in the public sector pension related deduction thresholds for 2017 and in the named range used to calculate a spouse's bonus value.

2014-17.01

This is a rewrite of the old calculator and handles tax years 2014 to 2017 inclusive.