Excel PAY AS YOU EARN (PAYE) FORTNIGHT TAX CALCULATOR

H

Hailey & Hayden

New Member
Joined
May 21, 2010
Messages
4
Excel PAY AS YOU EARN (PAYE) FORTNIGHT TAX CALCULATOR

Hi i manage to design a payroll spreadsheet for my company of +- 60 employees. The spredsheet works fine,The only thing is when i deduct tax i have to do it manually everything else is automatic. i have a fortnight tax DEDUCTION table 2010 on paper. It has all the different amount I must deduct salaries per fortnight.
Its literally hundreds of amounts with different salaries.
So how do i insert all that amounts into my spreadsheet so that when i enter the employee hours it calculates and deducts automatically.
Any help will be appreciated. Thank you
Regards
Sherman
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Sort by date Sort by votes
The first thing you would need to do is to put all the amounts into your spreadsheet - if you only have paper then scanning and doing an OCR might be the only way but have a word with your local tax office as they will probably provide it in digital format to insert directly and provide updates too.
Once in there, you should be able to use a statement to point to the sheet with the tax amounts and calculate the final amounts automatically using vlookup.
 
Upvote 0
Kentman said:
The first thing you would need to do is to put all the amounts into your spreadsheet - if you only have paper then scanning and doing an OCR might be the only way but have a word with your local tax office as they will probably provide it in digital format to insert directly and provide updates too.
Once in there, you should be able to use a statement to point to the sheet with the tax amounts and calculate the final amounts automatically using vlookup.
Click to expand...
can you give me an example of how i can do that. I have it all on a excel speadsheat.
 
Upvote 0
H&H,

It's difficult to give you an example as I don't know what your data looks like - it might be a good idea if you can show us some of this, including the tax lookups - just copy and paste it into your response, the board will have a better idea what formulas to use. Make sure you don't include any personal information.
 
Upvote 0
Welcome to the Board!

If you PM me your e-mail address I can send you the board's HTML Maker, which will let you post screen shots.
 
Upvote 0
Smitty said:
Welcome to the Board!

If you PM me your e-mail address I can send you the board's HTML Maker, which will let you post screen shots.
Click to expand...

Removed e-mail address - It's not safe in this or any other public forum
 
Last edited by a moderator:
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Solved
The tax man loves his little games!
2
Replies
11
Views
989
etaf
etaf
B
  • Question
Help for an amateur please
Replies
4
Views
324
Peter_SSs
Peter_SSs
S
  • Question
Automatic accrual calculations by day with accrual rate?
Replies
0
Views
235
Sunshine8790
S
simonkingston
  • Question
Extracting brackets from Pay for different Calculations
Replies
5
Views
433
Dave Patton
D
A
  • Question
Calculate Optimum Duration in Loan
Replies
1
Views
323
anuradhagrewal
A

Forum statistics

Threads
1,214,793
Messages
6,121,614
Members
449,039
Latest member
Mbone Mathonsi

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top