Scribd
Upload
33 views15 pages

Employee Payroll and Allowances 2023

1) This document provides payroll information for employees of Las Encinas Bank for the month. 2) It includes a list of employees, their positions, monthly salaries, basic pay, deductions, and other pay such as allowances. 3) The document also shows totals for gross pay, deductions, employer contributions, and net pay for all employees.

Uploaded by

Roldan Arca Pagapos
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
33 views15 pages

Employee Payroll and Allowances 2023

1) This document provides payroll information for employees of Las Encinas Bank for the month. 2) It includes a list of employees, their positions, monthly salaries, basic pay, deductions, and other pay such as allowances. 3) The document also shows totals for gross pay, deductions, employer contributions, and net pay for all employees.

Uploaded by

Roldan Arca Pagapos
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Payroll period

EMPLOYEE ID NO. NAME OF EMPLOYEE

1 Exposito, Ester

2 Montesinos, Lucresia

3 Munoz, Ander

4 Osuna, Guzman

5 Pando, Cayetana

6 Shana, Nadia

7 Dominguez, Samuel

8 Corbero, Tokyo

9 Murillo, Racquel

10 Flores, Nairobi

11 Herran, Rio

12 Lorente, Denver

13 Gatzambide, Monica

14 Alonso, Berlin

15 Parker, Alison

Total

TABLE OF OTHER PAY


Rice Allowance
Medical Allowance
Food Allowance
Uniform Allowance
Vacation Pay
Christmas Bonus
13th Month Pay
Las Encin
POSITION MONTHLY SALARY BASIC PAY

Senior Financial Analyst 90,000.00 45,000.00


Audit Manager 56,500.00 28,250.00
Senior Teller 125,000.00 62,500.00
Customer Service Representative 32,000.00 16,000.00
Bank teller 23,400.00 11,700.00
Head Teller 26,000.00 13,000.00
Internal Auditor 43,000.00 21,500.00
Bank Teller 23,400.00 11,700.00
Loan Officer 27,000.00 13,500.00
Phone Banker 36,500.00 18,250.00
Security Personel 20,000.00 10,000.00
Bank Manager 200,000.00 100,000.00
Collector 22,000.00 11,000.00
Credit Records Custodian 21,000.00 10,500.00
Microfinance Account Officer 25,000.00 12,500.00

385,400.00
Las Encinas Bank
OVER/ (UNDER) TIME
OTHER PAY
PAY

PARTICULARS AMOUNT EXCESS

Medical Allowance 250.00


Rice Allowance 2,000.00

(2,000.00) Rice Allowance 1,500.00

(800.00) Uniform Allowance 500.00

3,500.00 Vacation Pay 5,000.00

3,000.00 Medical Allowance 100.00


Rice Allowance 1,000.00

750.00 Uniform Allowance 500.00


Rice Allowance 1,200.00

(300.00) Rice Allowance 1,500.00

3,000.00 Rice Allowance 1,000.00


13th Month Pay 90,000.00

900.00 Rice Allowance 2,000.00

500.00 Vacation Pay 3,000.00


Rice Allowance 2,000.00

8,550.00 111,550.00
GROSS PAY EMPLOYEE'S DEDUCTIONS

SSS CONT EE PHILHEATH PAG-IBIG WITHHOLDING


TAXABLE PAY
SHARE EE SHARE EE SHARE TAX
45,250.00 620.00 437.50 900.00 43,042.50 8,329.52

30,250.00 620.00 350.00 1,130.00 26,150.00 3,620.75


62,000.00 620.00 437.50 2,500.00 58,942.50 13,099.52
15,700.00 620.00 200.00 640.00 14,540.00 824.60
20,200.00 460.00 137.50 468.00 10,634.50 43.50
16,100.00 520.00 162.50 520.00 11,797.50 276.10
22,500.00 620.00 262.50 860.00 19,757.50 2,022.63
12,950.00 460.00 137.50 468.00 10,634.50 43.50
14,700.00 540.00 162.50 540.00 12,257.50 368.10
19,450.00 620.00 225.00 730.00 16,675.00 1,252.00
14,000.00 400.00 125.00 400.00 9,075.00 -
190,000.00 620.00 437.50 4,000.00 94,942.50 24,130.71
13,900.00 440.00 137.50 440.00 9,982.50 -
14,000.00 420.00 125.00 420.00 9,535.00 -
14,500.00 500.00 150.00 500.00 11,350.00 186.60

505,500.00 8,080.00 3,487.50 14,516.00 359,316.50 54,197.53


NS EMPLOYER'S SHARE
NET PAY
SSS CONT PHILHEALTH PAG-IBIG ER
LOANS ADVANCES
ER SHARE ER SHARE SHARE

20,000.00 14,962.98 1,240.00 437.50 900.00

10,000.00 14,529.25 1,240.00 350.00 565.00

30,000.00 6,000.00 9,342.98 1,240.00 437.50 1,250.00

10,000.00 3,415.40 1,240.00 200.00 320.00

5,000.00 14,091.00 920.00 137.50 234.00

14,621.40 1,040.00 162.50 260.00

15,000.00 3,734.88 1,240.00 262.50 430.00

11,841.00 920.00 137.50 234.00

13,089.40 1,080.00 162.50 270.00

16,623.00 1,240.00 225.00 365.00

5,000.00 8,075.00 800.00 125.00 200.00

50,000.00 110,811.79 1,240.00 437.50 2,000.00

3,000.00 9,882.50 880.00 137.50 220.00

13,035.00 840.00 125.00 210.00

5,000.00 8,163.40 1,000.00 150.00 250.00

120,000.00 39,000.00 266,218.98 16,160.00 3,487.50 7,708.00


HARE TOTAL LIABILITIES

TOTAL SSS PHILHEALTH PAG-IBIG BIR TOTAL

2,577.50 1,860.00 875.00 1,800.00 8,329.52 12,864.52


2,155.00 1,860.00 700.00 1,695.00 3,620.75 7,875.75
2,927.50 1,860.00 875.00 3,750.00 13,099.52 19,584.52
1,760.00 1,860.00 400.00 960.00 824.60 4,044.60
1,291.50 1,380.00 275.00 702.00 43.50 2,400.50
1,462.50 1,560.00 325.00 780.00 276.10 2,941.10
1,932.50 1,860.00 525.00 1,290.00 2,022.63 5,697.63
1,291.50 1,380.00 275.00 702.00 43.50 2,400.50
1,512.50 1,620.00 325.00 810.00 368.10 3,123.10
1,830.00 1,860.00 450.00 1,095.00 1,252.00 4,657.00
1,125.00 1,200.00 250.00 600.00 - 2,050.00
3,677.50 1,860.00 875.00 6,000.00 24,130.71 32,865.71
1,237.50 1,320.00 275.00 660.00 - 2,255.00
1,175.00 1,260.00 250.00 630.00 - 2,140.00
1,400.00 1,500.00 300.00 750.00 186.60 2,736.60

27,355.50 24,240.00 6,975.00 22,224.00 54,197.53 107,636.53


Name of employee Exposito, Ester
Rice Allowance
Medical allowance
Food Allowance
Uniform allowance
Vacation pay
Christmas Bonus
13th Month Pay
SSS Contribution Table
Monthly Employer Employee
Salary Range Total
Credit ER EE
- 2,250 2,000 160.00 80.00 240.00
2,250 2,750 2,500 200.00 100.00 300.00
2,750 3,250 3,000 240.00 120.00 360.00
3,250 3,750 3,500 280.00 140.00 420.00
3,750 4,250 4,000 320.00 160.00 480.00
4,250 4,750 4,500 360.00 180.00 540.00
4,750 5,250 5,000 400.00 200.00 600.00
5,250 5,750 5,500 440.00 220.00 660.00
5,750 6,250 6,000 480.00 240.00 720.00
6,250 6,750 6,500 520.00 260.00 780.00
6,750 7,250 7,000 560.00 280.00 840.00
7,250 7,750 7,500 600.00 300.00 900.00
7,750 8,250 8,000 640.00 320.00 960.00
8,250 8,750 8,500 680.00 340.00 1,020.00
8,750 9,250 9,000 720.00 360.00 1,080.00
9,250 9,750 9,500 760.00 380.00 1,140.00
9,750 10,250 10,000 800.00 400.00 1,200.00
10,250 10,750 10,500 840.00 420.00 1,260.00
10,750 11,250 11,000 880.00 440.00 1,320.00
11,250 11,750 11,500 920.00 460.00 1,380.00
11,750 12,250 12,000 960.00 480.00 1,440.00
12,250 12,750 12,500 1,000.00 500.00 1,500.00
12,750 13,250 13,000 1,040.00 520.00 1,560.00
13,250 13,750 13,500 1,080.00 540.00 1,620.00

13,750 14,250 14,000 1,120.00 560.00 1,680.00


14,250 14,750 14,500 1,160.00 580.00 1,740.00
14,750 15,250 15,000 1,200.00 600.00 1,800.00
15,250 15,750 15,500 1,240.00 620.00 1,860.00
Phil-Health Contributions (Effective January 2020)
Salary Range Salary Base Employer Employee Total
- 9,000 8,000.00 100.00 100.00 200.00
9,000 10,000 9,000.00 112.50 112.50 225.00
10,000 11,000 10,000.00 125.00 125.00 250.00
11,000 12,000 11,000.00 137.50 137.50 275.00
12,000 13,000 12,000.00 150.00 150.00 300.00
13,000 14,000 13,000.00 162.50 162.50 325.00
14,000 15,000 14,000.00 175.00 175.00 350.00
15,000 16,000 15,000.00 187.50 187.50 375.00
16,000 17,000 16,000.00 200.00 200.00 400.00
17,000 18,000 17,000.00 212.50 212.50 425.00
18,000 19,000 18,000.00 225.00 225.00 450.00
19,000 20,000 19,000.00 237.50 237.50 475.00
20,000 21,000 20,000.00 250.00 250.00 500.00
21,000 22,000 21,000.00 262.50 262.50 525.00
22,000 23,000 22,000.00 275.00 275.00 550.00
23,000 24,000 23,000.00 287.50 287.50 575.00
24,000 25,000 24,000.00 300.00 300.00 600.00
25,000 26,000 25,000.00 312.50 312.50 625.00
26,000 27,000 26,000.00 325.00 325.00 650.00
27,000 28,000 27,000.00 337.50 337.50 675.00
28,000 29,000 28,000.00 350.00 350.00 700.00
29,000 30,000 29,000.00 362.50 362.50 725.00
30,000 31,000 30,000.00 375.00 375.00 750.00
31,000 32,000 31,000.00 387.50 387.50 775.00
32,000 33,000 32,000.00 400.00 400.00 800.00
33,000 34,000 33,000.00 412.50 412.50 825.00
34,000 35,000 34,000.00 425.00 425.00 850.00
35,000 Over 35,000.00 437.50 437.50 875.00
Semi-Monthly Tax Table
Over Not Over Basic plus
- 10,417.00 - 0%
10,417.00 16,667.00 - 20%
16,667.00 33,333.00 1,250.00 25%
33,333.00 83,333.00 5,416.67 30%
83,333.00 333,333.00 20,415.67 32%
333,333.00 - 100,417.67 35%

Employee Taxable Income Basic pay Rate


1 Exposito, Ester 43,043 5,416.67 30%
2 Montesinos, Lucresia 26,150 1,250.00 25%
3 Munoz, Ander 58,943 5,416.67 30%
4 Osuna, Guzman 14,540 - 20%
5 Pando, Cayetana 10,635 - 20%
6 Shana, Nadia 11,798 - 20%
7 Dominguez, Samuel 19,758 1,250.00 25%
8 Corbero, Tokyo 10,635 - 20%
9 Murillo, Racquel 12,258 - 20%
10 Flores, Nairobi 16,675 1,250.00 25%
11 Herran, Rio 9,075 - 0%
12 Lorente, Denver 94,943 20,415.67 32%
13 Gatzambide, Monica 9,983 - 0%
14 Alonso, Berlin 9,535 - 0%
15 Parker, Alison 11,350 - 20%
e
of excess over
-
10,417.00
16,667.00
33,333.00
83,333.00
333,333.00

excess over Additional IncomeTax


33,333.00 2,912.85 8,329.52
16,667.00 2,370.75 3,620.75
33,333.00 7,682.85 13,099.52
10,417.00 824.60 824.60
10,417.00 43.50 43.50
10,417.00 276.10 276.10
16,667.00 772.63 2,022.63
10,417.00 43.50 43.50
10,417.00 368.10 368.10
16,667.00 2.00 1,252.00
- - -
83,333.00 3,715.04 24,130.71
- - -
- - -
10,417.00 186.60 186.60
Las Encinas Bank
Name of employee Exposito, Ester
Position #N/A

Earnings Amount
Basic Pay BASIC PAY
Rice Allowance
Medical Allowance
Food Allowance
Uniform Allowance
Vacation Pay
Christmas Bonus
13th Month Pay

Total
Net Pay :
In words :
ncinas Bank
Employee ID number #NAME?
Branch Iloilo City

Deductions Amount
SSS Contribution
Philhealth Contribution
Pag-Ibig
Withholding Tax
Cash Advances EMPLOYEE'S DEDUCTIONS

Signature Over Printed Name

You might also like