1.0perpuity-2017.xls

  • Uploaded by: Judel
  • 0
  • 0
  • June 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View 1.0perpuity-2017.xls as PDF for free.

More details

  • Words: 1,216
  • Pages: 4
PERPUITY AQUA DESIGN INC PAYROLL For the period:

JAN 1 - DEC 31 2018

Date: JAN.31,2018 NAME

DAYS OF WORK

RATE

ADDITIONAL

TOTAL REGULAR WAGE

COLA

OVERTIME

1 Manes, Matthew Israel O.

26.00

961.54

25,000.00

260.00

2 Iglopas, Kris Anne F.

26.00

769.23

20,000.00

260.00

3 Mendeja, Ian Ceaser Sl.

26.00

769.23

20,000.00

260.00

4 Siez, Judelyn D.

26.00

769.23

20,000.00

260.00

5 Tumang, Mariel Angela

26.00

769.23

20,000.00

6 Denajeba, Keziah Anne T.

26.00

769.23

7 Designer

26.00

8 Designer 9 Reeptionist 10 Driver

OTHER CHARGES

SSS

PHIL. HEALTH

PAG-IBIG

-

25,260.00

580.80

347.33

100.00

-

20,260.00

580.80

278.58

100.00

-

20,260.00

580.80

278.58

20,260.00

580.80

260.00

20,260.00

20,000.00

260.00

576.92

15,000.00

26.00

576.92

26.00 26.00

3,120.00

Total LATE

SIGNATURE

290,782.45

###

959.38

231,607.42

###

100.00

959.38

231,607.42

###

278.58

100.00

959.38

231,607.42

###

580.80

278.58

100.00

959.38

231,607.42

###

20,260.00

580.80

278.58

100.00

959.38

231,607.45

###

260.00

15,260.00

562.65

209.83

100.00

872.48

172,650.22

###

15,000.00

260.00

15,260.00

562.65

209.83

100.00

872.48

172,650.22

###

512.00

13,312.00

260.00

13,572.00

490.05

186.62

100.00

776.67

153,543.96

###

512.00

13,312.00

260.00

13,572.00

490.05

186.62

100.00

776.67

153,543.96

73,834.20

32,915.52

13,200.00

-

2,179,487.89

-

-

31,200.00

-

-

-

2,210,687.89

-

-

119,949.72 Approved by: __________

Prepared by: _________

NET AMOUNT PAID ANNUALY

TOTAL DEDUCTIONS

CASH ADVANCE

1,028.13

-

TOTAL

DEDUCTIONS

TOTAL GROSS PAY & BENEFITS

ALLOWANCE

Recommending Approval: __________ PAYROLL ENTRIES ACCOUNT ID 6110 6111 6112 1213 1212 1214 2141 2142 2132 2144 2143 6211 1011

GL DESCRIPTION Salaries Basi Salaries Basic - Service & Adm Salaries Bas Salaries Basic-COLA&Allowances Salaries OT-H Salaries OT-Hol-Others Late Deduction AR Employees-Charges SSS Premiums Payable Phil Health Premiums Payable Pag-ibig Premiums Payable Withholding Tax Payable Cash Advance Other Charges Employee Meals and Lodging Cash in Bank -

DEBIT CREDIT 2,179,487.89 31,200.00 -

2,210,687.89

73,834.20 32,915.52 13,200.00 2,090,738.17 2,210,687.89 -

2,090,738.17

-

PERPUITY AQUA DESIGN INC PAYROLL For the period:

JAN 1 - DEC 31 2018

Date: JAN.31,2018 NAME

DAYS OF WORK

RATE

ADDITIONAL

TOTAL REGULAR WAGE

COLA

OVERTIME

1 Manes, Matthew Israel O.

26.00

961.54

25,000.00

260.00

2 Iglopas, Kris Anne F.

26.00

769.23

20,000.00

260.00

3 Mendeja, Ian Ceaser Sl.

26.00

769.23

20,000.00

260.00

4 Siez, Judelyn D.

26.00

769.23

20,000.00

260.00

5 Tumang, Mariel Angela

26.00

769.23

20,000.00

6 Denajeba, Keziah Anne T.

26.00

769.23

7 Designer

26.00

8 Designer 9 Reeptionist 10 Driver

OTHER CHARGES

SSS

PHIL. HEALTH

25,260.00

580.80

347.33

100.00

-

20,260.00

580.80

278.58

100.00

-

20,260.00

580.80

278.58

20,260.00

580.80

260.00

20,260.00

20,000.00

260.00

576.92

15,000.00

26.00

576.92

26.00 26.00

780.00

Total

PAG-IBIG

-

LATE

SIGNATURE

72,695.61

###

959.38

57,901.85

###

100.00

959.38

57,901.85

###

278.58

100.00

959.38

57,901.85

###

580.80

278.58

100.00

959.38

57,901.85

###

20,260.00

580.80

278.58

100.00

959.38

57,901.86

###

260.00

15,260.00

562.65

209.83

100.00

872.48

43,162.55

###

15,000.00

260.00

15,260.00

562.65

209.83

100.00

872.48

43,162.55

###

512.00

13,312.00

260.00

13,572.00

490.05

186.62

100.00

776.67

38,385.99

###

512.00

13,312.00

260.00

13,572.00

490.05

186.62

100.00

776.67

38,385.99

18,458.55

8,228.88

3,300.00

-

544,871.97

-

-

7,800.00

-

-

-

552,671.97

-

-

29,987.43 Approved by: __________

Prepared by: _________

NET AMOUNT PAID ANNUALY

TOTAL DEDUCTIONS

CASH ADVANCE

1,028.13

-

TOTAL

DEDUCTIONS

TOTAL GROSS PAY & BENEFITS

ALLOWANCE

Recommending Approval: __________ PAYROLL ENTRIES ACCOUNT ID 6110 6111 6112 1213 1212 1214 2141 2142 2132 2144 2143 6211 1011

GL DESCRIPTION Salaries Basi Salaries Basic - Service & Adm Salaries Bas Salaries Basic-COLA&Allowances Salaries OT-H Salaries OT-Hol-Others Late Deduction AR Employees-Charges SSS Premiums Payable Phil Health Premiums Payable Pag-ibig Premiums Payable Withholding Tax Payable Cash Advance Other Charges Employee Meals and Lodging Cash in Bank -

DEBIT

CREDIT 544,871.97 7,800.00 -

552,671.97

18,458.55 8,228.88 3,300.00 514,832.22 544,819.65 7,852.32

514,832.22

-

PERPUITY AQUA DESIGN INC PAYROLL For the period:

JAN 1 - DEC 31 2018

Date: JAN.31,2018 NAME

DAYS OF WORK

RATE

ADDITIONAL

TOTAL REGULAR WAGE

COLA

OVERTIME

1 Manes, Matthew Israel O.

26.00

961.54

25,000.00

260.00

2 Iglopas, Kris Anne F.

26.00

769.23

20,000.00

260.00

3 Mendeja, Ian Ceaser Sl.

26.00

769.23

20,000.00

260.00

4 Siez, Judelyn D.

26.00

769.23

20,000.00

260.00

5 Tumang, Mariel Angela

26.00

769.23

20,000.00

6 Denajeba, Keziah Anne T.

26.00

769.23

7 Designer

26.00

8 Designer 9 Reeptionist 10 Driver

OTHER CHARGES

SSS

PHIL. HEALTH

PAG-IBIG

-

25,260.00

800.00

347.33

100.00

-

20,260.00

800.00

278.58

100.00

-

20,260.00

800.00

278.58

20,260.00

800.00

260.00

20,260.00

20,000.00

260.00

576.92

15,000.00

26.00

576.92

26.00 26.00

2,340.00

Total LATE

SIGNATURE

216,114.04

###

1,178.58

171,732.76

###

100.00

1,178.58

171,732.76

###

278.58

100.00

1,178.58

171,732.76

###

800.00

278.58

100.00

1,178.58

171,732.76

###

20,260.00

800.00

278.58

100.00

1,178.58

171,732.79

###

260.00

15,260.00

620.00

209.83

100.00

929.83

128,971.51

###

15,000.00

260.00

15,260.00

620.00

209.83

100.00

929.83

128,971.51

###

512.00

13,312.00

260.00

13,572.00

540.00

186.62

100.00

826.62

114,708.42

###

512.00

13,312.00

260.00

13,572.00

540.00

186.62

100.00

826.62

114,708.42

69,660.00

24,686.64

9,900.00

-

1,634,615.92

-

-

23,400.00

-

-

-

1,658,015.92

-

-

104,246.64 Approved by: __________

Prepared by: _________

NET AMOUNT PAID ANNUALY

TOTAL DEDUCTIONS

CASH ADVANCE

1,247.33

-

TOTAL

DEDUCTIONS

TOTAL GROSS PAY & BENEFITS

ALLOWANCE

Recommending Approval: __________ PAYROLL ENTRIES ACCOUNT ID 6110 6111 6112 1213 1212 1214 2141 2142 2132 2144 2143 6211 1011

GL DESCRIPTION Salaries Basi Salaries Basic - Service & Adm Salaries Bas Salaries Basic-COLA&Allowances Salaries OT-H Salaries OT-Hol-Others Late Deduction AR Employees-Charges SSS Premiums Payable Phil Health Premiums Payable Pag-ibig Premiums Payable Withholding Tax Payable Cash Advance Other Charges Employee Meals and Lodging Cash in Bank -

DEBIT CREDIT 1,634,615.92 23,400.00 -

1,658,015.92

69,660.00 24,686.64 9,900.00 1,550,979.79 1,655,226.43 2,789.49

1,550,979.79

-

PERPUITY AQUA DESIGN INC PAYROLL For the period:

JAN 1 - DEC 31 2018

Date: JAN.31,2018 NAME

DAYS OF WORK

RATE

ADDITIONAL

TOTAL REGULAR WAGE

COLA

OVERTIME

1 Manes, Matthew Israel O.

26.00

961.54

25,000.00

260.00

2 Iglopas, Kris Anne F.

26.00

769.23

20,000.00

260.00

3 Mendeja, Ian Ceaser Sl.

26.00

769.23

20,000.00

260.00

4 Siez, Judelyn D.

26.00

769.23

20,000.00

260.00

5 Tumang, Mariel Angela

26.00

769.23

20,000.00

6 Denajeba, Keziah Anne T.

26.00

769.23

7 Designer

26.00

8 Designer 9 Reeptionist 10 Driver

OTHER CHARGES

SSS

PHIL. HEALTH

PAG-IBIG

-

25,260.00

800.00

347.33

100.00

-

20,260.00

800.00

278.58

100.00

-

20,260.00

800.00

278.58

20,260.00

800.00

260.00

20,260.00

20,000.00

260.00

576.92

15,000.00

26.00

576.92

26.00 26.00

3,120.00

Total LATE

SIGNATURE

288,152.05

###

1,178.58

228,977.02

###

100.00

1,178.58

228,977.02

###

278.58

100.00

1,178.58

228,977.02

###

800.00

278.58

100.00

1,178.58

228,977.02

###

20,260.00

800.00

278.58

100.00

1,178.58

228,977.05

###

260.00

15,260.00

620.00

209.83

100.00

929.83

171,962.02

###

15,000.00

260.00

15,260.00

620.00

209.83

100.00

929.83

171,962.02

###

512.00

13,312.00

260.00

13,572.00

540.00

186.62

100.00

826.62

152,944.56

###

512.00

13,312.00

260.00

13,572.00

540.00

186.62

100.00

826.62

152,944.56

92,880.00

32,915.52

13,200.00

-

2,179,487.89

-

-

31,200.00

-

-

-

2,210,687.89

-

-

138,995.52 Approved by: __________

Prepared by: _________

NET AMOUNT PAID ANNUALY

TOTAL DEDUCTIONS

CASH ADVANCE

1,247.33

-

TOTAL

DEDUCTIONS

TOTAL GROSS PAY & BENEFITS

ALLOWANCE

Recommending Approval: __________ PAYROLL ENTRIES ACCOUNT ID 6110 6111 6112 1213 1212 1214 2141 2142 2132 2144 2143 6211 1011

GL DESCRIPTION Salaries Basi Salaries Basic - Service & Adm Salaries Bas Salaries Basic-COLA&Allowances Salaries OT-H Salaries OT-Hol-Others Late Deduction AR Employees-Charges SSS Premiums Payable Phil Health Premiums Payable Pag-ibig Premiums Payable Withholding Tax Payable Cash Advance Other Charges Employee Meals and Lodging Cash in Bank -

DEBIT CREDIT 2,179,487.89 31,200.00 -

2,210,687.89

92,880.00 32,915.52 13,200.00 2,071,692.37 2,210,687.89 -

2,071,692.37

-

More Documents from "Judel"

Ar 6789-.xlsx
June 2020 1
Book1.xlsx
June 2020 1
1.0perpuity-2017.xls
June 2020 3
%.xlsx
June 2020 10