Payroll Spread Sheet
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. | |||||||||||||||