Share this content
0
942

HMRC PAYE Calculation Vs PAYE Calculation Manually

Need HMRC PAYE Calculator in excel. So that i can understand the calculations and values better

I was trying to calculate PAYE in excel but it is not matching with PAYE Calculator available on HMRC website. Can anyone help me with this calculation or provide such excel 

Replies

Please login or register to join the discussion.

avatar
By Jholm
22nd May 2018 16:19

What figures are you trying to calculate?

Thanks (0)
avatar
By Arihant
to Jholm
22nd May 2018 16:58

Hey, I am trying to calculate per month PAYE figures. But that aren't matching the PAYE Calculator

Thanks (0)
22nd May 2018 17:10

A few pence out ?

It could be in the roundings.

Why are you doing something so eccentric ?

Thanks (1)
avatar
By Arihant
to lionofludesch
23rd May 2018 07:53

I was trying to understand the logic behind the HMRC calculation and create an offline excel calculator. Anyways I got the logic behind that. Thanks

Thanks (0)
avatar
By Jholm
23rd May 2018 09:12

Divided your relevant personal allowance, rate bands, etc by 12 and do the same for NIC bands...? Always a good start. How far out are you?

Thanks (0)
to Jholm
23rd May 2018 09:46

Yeah, but don't forget that a code of 1150 actually gives you £11509 of allowances, not £11500,

Thanks (1)
avatar
By Arihant
to lionofludesch
23rd May 2018 09:49

Yes, and even we have to take upper limit of basic rate as 46,359 instead of 46,350.

Thanks (0)
to Arihant
24th May 2018 08:51

Well, I think you're on the wrong track there.

You need to be thinking about the width of the BR band.

Not everyone has a tax code of 1150L.

Thanks (0)
Share this content