*Long post but worth it if you value your income which I imagine you do.*

Providing a link here to an Excel spreadsheet I made that calculates what your PAYE/Tax, USC, PRSI should be. Calculates your net pay after those deductions and breaks it down into weekly, fortnightly and monthly pay. Also calculates what percentage, of your gross pay, your net/take home pay is. Obviously if your net pay is 70% of your gross pay, your overall deductions between PAYE, USC & PRSI amounts to 30% taxation overall really. Amend salary figure and tax credits figure as necessary to calculate your own figures.

If you’re self employed you won’t have 3400 worth of credits as 1700 of them are for PAYE credit if you have an employer. Also if you have other credits, e.g. single person child carer credit for example, find out what that credit amounts to and add it on as appropriate for each credit.

This Excel file is only valid for **2022 rates** i.e. up to 36,800 at 20% tax rate band, 3400 tax credits for PAYE workers (1700 personal tax credit + 1700 PAYE tax credit), USC bands and such. You can download the file and in future years amend the thresholds for tax rate, USC rates and such.

I’ve left the salary figure as 696204.52 which, it took me a long time to discover manually, is the **minimum** salary you would need to earn, at least with standard PAYE credits, before **50%** of your gross salary would go on PAYE, USC and PRSI combined. There is **no** standard **50%** **tax** rate band as a great many people seem to think. If you’re losing around that amount out of your salary – check with Revenue that you aren’t being emergency-taxed as it just simply isn’t normal or right for you to be getting taxed anywhere near that much…

Before anyone might feel the urge to argue with me over anything, I researched all the rate bands, credits etc. etc. and have prior experience of having worked in Revenue in the past for my sins. So I know I have put this Excel file together accurately thanks to a bit of knowledge about coding also – although most people probably could code Excel how they wanted to with a bit of Googling really.

Therefore, if you check what you should be earning as your net pay – and you’re earning less than it – there’s either an issue with your company’s **payroll** (or **accountant** if *self employed*) **or Revenue** and you can look to get previous years reviewed (as far back as 4 years) for a **refund** of your overpayment. Claim back *anything* you can – medical expenses… Anything. Better off in your pocket and it costs enough in the first place… Just make sure you have receipts just in case they challenge you on it.

Anyway, if you want to try it out and download the file, the link is [here.](https://docs.google.com/spreadsheets/d/1o9FZuoOL1KUddFLfB01WlROgQEA7KG_-/edit?usp=sharing&ouid=104017150157631585404&rtpof=true&sd=true) To download it, click on file, download and use file type **”Microsoft Excel (.xlsx)”.**

P.S. Just as an aside – do **not** automatically believe these companies trying to get you to pay them to request a tax refund on your behalf. There are **plenty** of employers who miscalculate employees’ tax and they end up having an underpayment and owe money to Revenue as a result of their employers’ pay roll sections not knowing what they’re doing. ***Plenty.*** So when they say “Our clients get an average tax refund of €1,000!” and it sounds too good to be true – that’s because it probably is. So don’t chance that unless you know for sure you **are** due a refund which you should know from this excel file once the year is out and you know what you earned and paid in tax etc. on your gross pay for the whole year!

Cheers folks.

7 comments
  1. I don’t think anyone thinks tax is 50%. I think a lot of people are aware that they are paying over 50% on their marginal income.

    Thanks for sharing this.

Leave a Reply