I have Attached G-Payroll Spreadh Sheet
Mango’s payroll tool |
|
Back to intro | |||||||||||||
Insert your tax band information in the yellow cells below | |||||||||||||||
(The example data entered is for Uganda) | |||||||||||||||
Bands | Rate | Bands | Rate | Additional | |||||||||||
From | To | % | – | % | |||||||||||
0 | A | 0% | A | 130,000 | 10% | W | |||||||||
A | B | W | B | 235,000 | 20% | X | 10,500 | ||||||||
B | C | X | C | 410,000 | 30% | Y | 45,500 | ||||||||
C | D | Y | D | Z | |||||||||||
D | Gross | X | |||||||||||||
Monthly gross pay | 1,500,000 | N | |||||||||||||
% | |||||||||||||||
Employees Social security | 5 | Ees | (If the Employees’ contribution is a fixed amount, write the figure in D14 and adjust the formula) | ||||||||||||
Employers Social security | 10 | Ers | (If the Employers’ contribution is a fixed amount, write the figure in D14 and adjust the formula) | ||||||||||||
PAYE Formula: | =(VLOOKUP(N,Tax,2)*(N-VLOOKUP(N,Tax,1)))+VLOOKUP(N,Tax,4) | (‘Tax’ in this formula refers to table E5:H10) | |||||||||||||
Net pay formula: | N-PAYE-(N*Ees%) | ||||||||||||||
Test calculation: | |||||||||||||||
1. Fill in all the yellow cells with sample figures | |||||||||||||||
2. Check if the blue figures below are as you expect | |||||||||||||||
PAYE: | 372,500 | ||||||||||||||
Net pay: | 1,052,500 | ||||||||||||||
3. If it is correct as you expect, you can proceed to use or adapt the following payroll page | |||||||||||||||
4. If it is not correct, you may need to amend the formula for your particular country. Kindly notify Mango. |
Click Here To Download G-Payroll Spread Sheet
Whenever a company announces employee training session for skills development then it is supposed to…
If you are planning to immediately resign from your job but you can have your…
If you have been invited to serve in an honorary position at any institution and…
Violating the policy of the company will not be accepted by any organization and if…
Whether it is poor performance or unprofessional behavior that you have experienced at the restaurant…
If there is retaliation that you have observed in a particular team or department then…