Tax and NI
Tax and NI
19-07-2016, 01:46 PM
Does anyone know an excel formalu for deduction of tax and NI from an amount?
I spoke to my manager at work today and gave all the dates and time I am going to to do overtime, and she advised to me to create a spreadsheet and keep a personal spreadsheet of overtime ive done, with NI and tax deductions, and she said not to trust the company to get it right.
come up with the spreadsheet, just need to work out how much NI and tax in a simple formula, ill keep working on it, but if anyone knows of one, help please !
[COLOR="Gray"]December 2008: Crashed Lexus IS200 - Cat B Write Off
August 2009: Crashed Vauxhall Astra - Minor Damage DIY Repair
November 2009: Crashed Vauxhall Astra - Scratches To Bumper No Repair Required
February 2010: Other Party Crashed Into Astra - Extensive Damage To Rear -Settled With Third Party's Insurance
Anyone dare To Predict The Future?[/COLOR]
Hi everyone !
Does anyone know an excel formalu for deduction of tax and NI from an amount?
I spoke to my manager at work today and gave all the dates and time I am going to to do overtime, and she advised to me to create a spreadsheet and keep a personal spreadsheet of overtime ive done, with NI and tax deductions, and she said not to trust the company to get it right.
come up with the spreadsheet, just need to work out how much NI and tax in a simple formula, ill keep working on it, but if anyone knows of one, help please !
[COLOR="Gray"]December 2008: Crashed Lexus IS200 - Cat B Write Off
August 2009: Crashed Vauxhall Astra - Minor Damage DIY Repair
November 2009: Crashed Vauxhall Astra - Scratches To Bumper No Repair Required
February 2010: Other Party Crashed Into Astra - Extensive Damage To Rear -Settled With Third Party's Insurance
Anyone dare To Predict The Future?[/COLOR]
19-07-2016, 01:52 PM
should do everything you need..
LEXUS IS200 Sport Navigator - 140.8db
Kenwood DNX 8220 BT - Custom OEM Screen Conversion - PS2 - Epic 150
Front: MB Quart QSC216 / Centre: MB Quart PKH110 / Rear:MB Quart RUA213 / Sub: MB Quart PWH 302 x 2 / AMPS: JL 1000/1 - JL 300/4
http://listentotaxman.com/
should do everything you need..
LEXUS IS200 Sport Navigator - 140.8db
Kenwood DNX 8220 BT - Custom OEM Screen Conversion - PS2 - Epic 150
Front: MB Quart QSC216 / Centre: MB Quart PKH110 / Rear:MB Quart RUA213 / Sub: MB Quart PWH 302 x 2 / AMPS: JL 1000/1 - JL 300/4
19-07-2016, 01:54 PM
[COLOR="Gray"]December 2008: Crashed Lexus IS200 - Cat B Write Off
August 2009: Crashed Vauxhall Astra - Minor Damage DIY Repair
November 2009: Crashed Vauxhall Astra - Scratches To Bumper No Repair Required
February 2010: Other Party Crashed Into Astra - Extensive Damage To Rear -Settled With Third Party's Insurance
Anyone dare To Predict The Future?[/COLOR]
oh wicked, i googled it and some of the info was soo complicating !
[COLOR="Gray"]December 2008: Crashed Lexus IS200 - Cat B Write Off
August 2009: Crashed Vauxhall Astra - Minor Damage DIY Repair
November 2009: Crashed Vauxhall Astra - Scratches To Bumper No Repair Required
February 2010: Other Party Crashed Into Astra - Extensive Damage To Rear -Settled With Third Party's Insurance
Anyone dare To Predict The Future?[/COLOR]
20-07-2016, 01:11 AM
hock:
Lexus IS200 Mods--TTE Supercharger, Tein Superstreet Coilovers & EDFC, 6000K HID Lights, HKS Silent High Power Exhaust, DBA Front Discs, Kenwood DNX9240 Head Unit, 19" Rims, TRD Kit, FIGS Bonnet Struts, Greddy Pillar Pod & Defi Gauges, TTE Red ARBS . And Been To WIM twice
All you need to know is the Tax Man will screw you all the time hock:
Lexus IS200 Mods--TTE Supercharger, Tein Superstreet Coilovers & EDFC, 6000K HID Lights, HKS Silent High Power Exhaust, DBA Front Discs, Kenwood DNX9240 Head Unit, 19" Rims, TRD Kit, FIGS Bonnet Struts, Greddy Pillar Pod & Defi Gauges, TTE Red ARBS . And Been To WIM twice
20-07-2016, 02:30 AM
2002 '02' IS200 SE Auto - DVD Satnav with Voice Activation - [COLOR="Blue"]Strathcaron Blue - Parking Sensors - 5000K HIDs with Anti-Glare Bulbs - PIAA 6500K Main Beams - LED Sidelights - Mirror/Sunroof Closure - TTE Styling Kit - 18" Styling Kit Alloys with nitrogen filled Goodyear Eagle F1 Asymmetric Tyres - Bluetouch Multimedia Kit - Gromaudio AUX in - Black painted calipers with silver Lexus decals - 12 LED Dome Light - 96 LED Boot Light - Stainless Steel Sport Sill Plates - PIAA Silicone Wipers[/COLOR]
That's actually quite a useful calculator for a lot of people - as an accountant I'm used to it but can imagine tax rules can be a bit of a pain!
2002 '02' IS200 SE Auto - DVD Satnav with Voice Activation - [COLOR="Blue"]Strathcaron Blue - Parking Sensors - 5000K HIDs with Anti-Glare Bulbs - PIAA 6500K Main Beams - LED Sidelights - Mirror/Sunroof Closure - TTE Styling Kit - 18" Styling Kit Alloys with nitrogen filled Goodyear Eagle F1 Asymmetric Tyres - Bluetouch Multimedia Kit - Gromaudio AUX in - Black painted calipers with silver Lexus decals - 12 LED Dome Light - 96 LED Boot Light - Stainless Steel Sport Sill Plates - PIAA Silicone Wipers[/COLOR]
20-07-2016, 07:15 AM
Mr Mole All you need to know is the Tax Man will screw you all the time
according to that, they going to screw me big styles !
between 700-1000 per month !
[COLOR="Gray"]December 2008: Crashed Lexus IS200 - Cat B Write Off
August 2009: Crashed Vauxhall Astra - Minor Damage DIY Repair
November 2009: Crashed Vauxhall Astra - Scratches To Bumper No Repair Required
February 2010: Other Party Crashed Into Astra - Extensive Damage To Rear -Settled With Third Party's Insurance
Anyone dare To Predict The Future?[/COLOR]
Mr Mole All you need to know is the Tax Man will screw you all the time
according to that, they going to screw me big styles !
between 700-1000 per month !
[COLOR="Gray"]December 2008: Crashed Lexus IS200 - Cat B Write Off
August 2009: Crashed Vauxhall Astra - Minor Damage DIY Repair
November 2009: Crashed Vauxhall Astra - Scratches To Bumper No Repair Required
February 2010: Other Party Crashed Into Astra - Extensive Damage To Rear -Settled With Third Party's Insurance
Anyone dare To Predict The Future?[/COLOR]
20-07-2016, 07:22 AM
Your have your personnel tax allowance.
Your saving or shares.
From what your already said (hourly rate in another post)i am guessing a figure in the area between 25-30% of your total earned would be correct for tax and national insurance.
However i not a accountant and that or your HR should be a better starting postion.
Your need different things taken into account when working out tax.
Your have your personnel tax allowance.
Your saving or shares.
From what your already said (hourly rate in another post)i am guessing a figure in the area between 25-30% of your total earned would be correct for tax and national insurance.
However i not a accountant and that or your HR should be a better starting postion.
20-07-2016, 07:24 AM
our HR are the people my manager are saying not to be trusted ! lol
im just going to do as much as i can, and then see how much they take, atleast now i wont be shocked on pay day !
[COLOR="Gray"]December 2008: Crashed Lexus IS200 - Cat B Write Off
August 2009: Crashed Vauxhall Astra - Minor Damage DIY Repair
November 2009: Crashed Vauxhall Astra - Scratches To Bumper No Repair Required
February 2010: Other Party Crashed Into Astra - Extensive Damage To Rear -Settled With Third Party's Insurance
Anyone dare To Predict The Future?[/COLOR]
i think that website gives a rough idea which i wanted,
our HR are the people my manager are saying not to be trusted ! lol
im just going to do as much as i can, and then see how much they take, atleast now i wont be shocked on pay day !
[COLOR="Gray"]December 2008: Crashed Lexus IS200 - Cat B Write Off
August 2009: Crashed Vauxhall Astra - Minor Damage DIY Repair
November 2009: Crashed Vauxhall Astra - Scratches To Bumper No Repair Required
February 2010: Other Party Crashed Into Astra - Extensive Damage To Rear -Settled With Third Party's Insurance
Anyone dare To Predict The Future?[/COLOR]
27-07-2016, 06:20 AM
I love my accountant he explains things is English, which I find rare in the accountancy industry.
"Life's goal is not to arrive safely at the grave in a well preserved body. But, rather to skid in sideways........
totally worn out and broken, shouting 'Holy ****, WHAT A RIDE!'"
FirebirdPhil
27-07-2016, 06:20 AM #9Tax law is something I must admit to hate. If you want I can run your details through my payroll program - it is 100% accurate.
I love my accountant he explains things is English, which I find rare in the accountancy industry.
"Life's goal is not to arrive safely at the grave in a well preserved body. But, rather to skid in sideways........
totally worn out and broken, shouting 'Holy ****, WHAT A RIDE!'"
27-07-2016, 08:58 AM
2tongues Tax law is something I must admit to hate. If you want I can run your details through my payroll program - it is 100% accurate.
I love my accountant he explains things is English, which I find rare in the accountancy industry.
thanks for the offer i will continue with my overtime this month, and let you know what I should get before deductions by the end of the month as they not going to pay my until end of october, so then i wont be shocked.
ive already done 47.5 hours of overtime 6 days at a rate of 15.56, which for me almost two months pay
[COLOR="Gray"]December 2008: Crashed Lexus IS200 - Cat B Write Off
August 2009: Crashed Vauxhall Astra - Minor Damage DIY Repair
November 2009: Crashed Vauxhall Astra - Scratches To Bumper No Repair Required
February 2010: Other Party Crashed Into Astra - Extensive Damage To Rear -Settled With Third Party's Insurance
Anyone dare To Predict The Future?[/COLOR]
2tongues Tax law is something I must admit to hate. If you want I can run your details through my payroll program - it is 100% accurate.
I love my accountant he explains things is English, which I find rare in the accountancy industry.
thanks for the offer i will continue with my overtime this month, and let you know what I should get before deductions by the end of the month as they not going to pay my until end of october, so then i wont be shocked.
ive already done 47.5 hours of overtime 6 days at a rate of 15.56, which for me almost two months pay
[COLOR="Gray"]December 2008: Crashed Lexus IS200 - Cat B Write Off
August 2009: Crashed Vauxhall Astra - Minor Damage DIY Repair
November 2009: Crashed Vauxhall Astra - Scratches To Bumper No Repair Required
February 2010: Other Party Crashed Into Astra - Extensive Damage To Rear -Settled With Third Party's Insurance
Anyone dare To Predict The Future?[/COLOR]
Recently Browsing
4 Guest(s)
4 Guest(s)
Recently Browsing
4 Guest(s)
4 Guest(s)