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.

 

Click Here To Download G-Payroll Spread Sheet