ABSENSI

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 25

REKAP ABSENSI HARIAN

NOVEMBER
NO NAME 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

1 DANDI

2 POPI AMELIA

3 RANTI PEBIOLA

4 HANA SASKIA WILAR

SUBTOTAL

DECEMBER
NO NAME 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

1 RANTI PEBIOLA (BOB) 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1


2 HANA SASKIA WILAR 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1

3 HAMDANI

4 RIO TARUNA

5 LUKMANUL HAKIM

SUBTOTAL

NO NAME 1 2 3 4 5 6 7 8
JANUARI 2024
9 10 11 12 13 14 15 16 17 18 19
SHIRLEY 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1 RANTI PEBIOLA 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1
2 HANA SASKIA WILAR 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
3 HAMDANI 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1
4 RIO TARUNA 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
5 LUKMANUL HAKIM 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
6 BEN 1
7 ROHMAN 1
8 HANDRI
9 STEVEN
10 DIKI
11 AHMAD
12 MAULANA
13 JIMMY
14 THOMAS
15 ILHAM
16 ABDUL GANI
17 FANDI

SUBTOTAL

NO NAME 1 2 3 4 5 6 7 8
FEBRUARI 2024
9 10 11 12 13 14 15 16 17 18 19
0 SHIRLEY 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1 RANTI PEBIOLA 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1
2 HANA SASKIA WILAR 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1
3 HAMDANI 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
4 RIO TARUNA 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
5 LUKMANUL HAKIM 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
6 BEN 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
7 ROHMAN 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
8 HANDRI 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
9 STEVEN 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
10 DIKI 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
11 AHMAD 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
12 MAULANA 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
13 JIMMY 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
14 THOMAS 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
15 ILHAM 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
16 ABDUL GANI 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
17 FANDI 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
18 DAVID 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
19 SITI 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
20 ALDO 1 1
21 JAROT 1 1
22 KURNIA 1 1
23
24
25
26
SUBTOTAL

MARET 2024
NO NAME 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
0 SHIRLEY 1 1 1
1 RANTI PEBIOLA 1 1 0
2 HANA SASKIA WILAR 1 1 1
3 HAMDANI 1 1 1
4 RIO TARUNA 1 1 1
5 LUKMANUL HAKIM 1 1 1
6 BEN 1 1 1
7 ROHMAN 1 1 1
8 HANDRI 1 1 1
9 STEVEN 1 1 1
10 DIKI 1 1 1
11 AHMAD 1 1 1
12 MAULANA 1 1 1
13 JIMMY 1 1 1
14 THOMAS 1 1 1
15 ILHAM 1 1 1
16 ABDUL GANI 1 1 1
17 FANDI 1 1 1
18 DAVID 1 1 1
19 SITI 1 1 1
20 ALDO 1 1 1
21 JAROT 1 1 1
22 KURNIA 1 1 1
23
24
25
26
SUBTOTAL
RIAN

BER
20 21 22 23 24 25 26 27 28 29 30 31 TOTAL TOTAL

1 1 1 1 4 $ 113.2

1 1 1 1 4 $ 113.2

1 1 1 1 4 $ 113.2

1 1 1 1 4 $ 113.2

$ 792.4

BER
20 21 22 23 24 25 26 27 28 29 30 31 TOTAL TOTAL

1 1 1 1 1 1 1 1 1 1 1 1 31 $ 650.0 610
1 1 1 1 1 1 1 1 1 1 1 1 29 $ 572.0 600

1 1 1 1 1 5 $ 101.5 79

1 1 1 1 1 5 $ 101.5 79

1 1 1 1 1 5 $ 101.5

$ 2,376.5

2024
20 21 22 23 24 25 26 27 28 29 30 31 TOTAL TOTAL
1 1 1 1 1 1 1 1 1 1 1 1 31 $ 800.0
1 1 1 0 1 1 1 1 1 1 1 1 29 $ 790.0
1 1 1 0 1 1 1 1 1 1 1 1 30 $ 790.0
1 1 1 1 1 1 1 1 1 1 1 1 30 $ 730.0
1 1 1 1 1 1 1 1 1 1 1 1 31 $ 490.0
1 1 1 1 1 1 1 1 1 1 1 1 31 $ 700.0
1 1 1 1 1 1 1 1 1 1 1 1 13 $ 368.0
1 1 1 1 1 1 1 1 1 1 1 1 13 $ 368.0
1 1 1 1 1 1 1 1 8 $ 226.4
1 1 1 1 1 1 1 1 8 $ 226.4
1 1 1 1 1 1 1 1 8 $ 226.4
1 1 1 1 1 1 6 $ 169.8
1 1 1 1 1 1 6 $ 169.8
1 1 1 1 1 1 6 $ 169.8
1 1 1 3 $ 85.0
1 1 1 3 $ 85.0
1 1 1 3 $ 85.0
1 1 1 3 $ 85.0

$ 6,564.6

2024
20 21 22 23 24 25 26 27 28 29 30 31 TOTAL TOTAL
1 1 1 1 1 1 1 1 1 1 29
1 1 1 1 0 1 1 1 1 1 27 $950.00 786.8
1 1 1 1 1 1 1 0 1 1 27 $950.00 886.8
1 1 1 1 1 0 1 1 1 1 27 $900 840
0 0 0 0 0 0 0 0 0 0 0 $0
1 1 1 1 1 1 1 1 1 1 29 $900
1 1 1 1 1 1 1 1 1 1 29 $850
1 1 1 1 1 1 1 1 1 1 29 $850
1 1 1 1 1 1 1 1 1 1 29 $850
1 1 1 1 1 1 1 1 1 1 29 $850
1 1 1 1 1 1 1 1 1 1 29 $850
1 1 1 1 1 1 1 1 1 1 29 $850
1 1 1 1 1 1 1 1 1 1 29 $850
1 0 1 1 1 1 1 1 1 1 28 $850 821.7
1 1 1 1 1 1 1 1 1 1 29 $850
1 1 1 1 1 1 1 1 1 1 29 $850
1 1 1 1 1 1 1 1 1 1 29 $850
1 1 1 1 1 1 1 1 1 1 29 $850
1 1 1 1 1 1 1 1 1 1 26 $736
1 1 1 1 1 1 1 1 1 1 26 $736
1 1 1 1 1 1 1 1 1 1 12 $339.60
1 1 1 1 1 1 1 1 1 1 12 $339.60
1 1 1 1 1 1 1 1 1 1 12 $339.60
0
0
0
0

2024
20 21 22 23 24 25 26 27 28 29 30 31 TOTAL TOTAL
3
2 $950.00
3 $950.00
3 $900
3 $0
3 $900
3 $850
3 $850
3 $850
3 $850
3 $850
3 $850
3 $850
3 $850
3 $850
3 $850
3 $850
3 $850
3 $736
3 $736
3 $339.60
3 $339.60
3 $339.60
0
0
0
0
salary : $850/month

(cut loan money $100x2)


( cut loan money $100x2), not working not permission $50, late more than 45 minutes cut salary 1 day ($28)

(work only 5 days, 1 day late work 30 minutes fined $40)

(work only 5 days, 1 day late work 30 minutes fined $40)

(work only 5 days, 1 day late work 30 minutes fined $40)


LOAN AND FINED WHILE W
DATE NAME TOTAL LOAN DATE

5-Dec-23 YUDHISTIRA PRATAMA $60 8-Jan-24


15-Dec-23 YUDHISTIRA PRATAMA $60 23-Jan-24
24-Dec-23 YUDHISTIRA PRATAMA $210 2.6.8 JAN
24-Dec-23 CAN SYABILL $100 2.6.8 JAN
29-Jan-24 HANDRI $100 13-Jan-24
29-Jan-24 STEVEN $100 22-Jan-24
29-Jan-24 DIKI $100 14-Jan-24
1-Feb-24 AHMAD $100 9-Feb-24
1-Feb-24 MAULANA $100 9-Feb-24
1-Feb-24 JIMMY $100 9-Feb-24
1-Feb-24 THOMAS $100 9-Feb-24
1-Feb-24 ILHAM $100 9-Feb-24
1-Feb-24 DUL $100 9-Feb-24
1-Feb-24 FANDI $100 11-Feb-24
1-Feb-24 BOB $100 12-Feb-24
1-Feb-24 BECCA $100 12-Feb-24
1-Feb-24 LUKMAN $100 14-Feb-24
1-Feb-24 HAMDANI $100 14-Feb-24
1-Feb-24 RIO TARUNA $100 14-Feb-24
1-Mar-24 HANA SASKIA WILAR $100
1-Mar-24 LUKMAN $100
1-Mar-24 ROHMAN $100
1-Mar-24 HANDRI $100
1-Mar-24 STEVEN $50
1-Mar-24 DIKI $100
1-Mar-24 AHMAD $100
1-Mar-24 MAULANA $50
1-Mar-24 JIMMY $100
1-Mar-24 THOMAS $100
1-Mar-24 ILHAM $100
1-Mar-24 DUL $50
1-Mar-24 FANDI $50
1-Mar-24 DAVID $50
1-Mar-24 SITI $100
1-Mar-24 ALDO $100
1-Mar-24 JAROT $100
1-Mar-24 HAMDANI $100
1-Mar-24 KURNIA $100
TOTAL $1,650

already paid
cut salary this month
run away
cut next month
NED WHILE WORKING
NAME TOTAL FINED

LUKMAN $50 SALAH RESI


RIO TARUNA $200 SALAH RESI 4 X
BOB $110 TERLAMBAT 3x dan tidak masuk tanggal 23
BECCA $110 TERLAMBAT 3x dan tidak masuk tanggal 23
RIO TARUNA $60 TELAT 3 KALI
LUKMAN $20 TELAT 1X
HAMDANI $20 TERLAMBAT
HANDRI $100 SALAH RESI 2X
DUL $50 SALAH RESI
FANDI $50 SALAH RESI
MAULANA $50 SALAH RESI
AHMAD $50 SALAH RESI KOMBINASI
JIMMY $100 KACA PECAH
DIKI $50 SALAH RESI
DIKI $50 SALAH RESI
HANDRI $50 SALAH RESI
DUL $50 SALAH RESI
HANDRI $50 SALAH RESI
DAVID $50 SALAH RESI

selesai/ sudah di potong


Date DAILY COUNT OF TEAM BONUSES Percentage Amount

Goreng 1 15% $22.50


Goreng 2 15% $22.50 Isi ulang Rp.20.000.000
25-Dec-23
Receptionist 1 30% $45
Killer 40% $60
TOTAL $150 plus bonus natal

Date DAILY COUNT OF TEAM BONUSES Percentage Amount

Actor 1 7.5% $1.50


Actor 2 7.5% $1.50
Actor 3 7.5% $1.50
4-Jan-24
Actor 4 7.5% $1.50
Receptionist 1 30.0% $6 Isi ulang Rp.13.000.000
Killer 40.0% $8
TOTAL $20
Isi ulang Rp.20.000.000

Isi ulang Rp.13.000.000


Employee Salary Adjustment Form
JANUARY
SALARY ETC
Job code Name
How many days Total Loan money
001 RANTI PEBIOLA 29 $ 790.0 $100
002 HANA SASKIA 30 $ 790.0 $100
003 HAMDANI 30 $ 730.0 $100
004 RIO TARUNA 31 $ 490.0 $0
005 LUKMAN 31 $ 700.0 $80
006 BEN 13 $ 368.0 0
007 ROHMAN 13 $ 368.0 0
008 HANDRI 8 $ 226.4 $100
009 STEVEN 8 $ 226.4 $100
010 DIKI 8 $ 226.4 $100
011 AHMAD 6 $ 169.8 $100
012 MAULANA 6 $ 169.8 $100
013 JIMMY 6 $ 169.8 $100
014 THOMAS 3 $ 85.0 $100
015 ILHAM 3 $ 85.0 $100
016 ABDUL GANI 3 $ 85.0 $100
017 FANDI 3 $ 85.0 $100
TOTAL 231 $ 5,764.6 $ 1,380.0

Employee Salary Adjustment Form


FEBRUARY
SALARY ETC
Job code Name
How many days Total Loan money
001 RANTI PEBIOLA 27 $ 746.8 $100
002 HANA SASKIA 27 $ 646.8 $200
003 HAMDANI 27 $ 600.0 $200
004 RIO TARUNA 0 $ - $0
005 LUKMAN 29 $ 600.0 $200
006 BEN 29 $ 650.0 0
007 ROHMAN 29 $ 700.0 $100
008 HANDRI 29 $ 450.0 $200
009 STEVEN 29 $ 600.0 $150
010 DIKI 29 $ 450.0 $200
011 AHMAD 29 $ 520.0 $200
012 MAULANA 29 $ 610.0 $150
013 JIMMY 29 $ 421.7 $200
014 THOMAS 29 $ 540.0 $200
015 ILHAM 29 $ 550.0 $200
016 ABDUL GANI 29 $ 560.0 $150
017 FANDI 29 $ 610.0 $150
018 DAVID 26 $ 496.0 $150
019 SITI 26 $ 536.0 $100
020 ALDO 12 $ 339.6 $100
021 JAROT 12 $ 339.6 $100
022 KURNIA 12 $ 339.6 $100
TOTAL 458 $ 9,255.3 $ 2,600.0
ETC
Fined
$110
$110
$20
$260 004 will cut his salary $400 for fined
70
0
0
0
0
0
0
0
0
0
0
0
0
$ 570.0

cut loan next month

ETC
Fined
$40
$40
$40
$0
$100
$250
$50
$200
$100
$200
$130
$90
$200
$110
$100
$140
$90
$90
$100
$0
$0
$0
$ 1,880.0
11-Feb-24

FINED DAILY GROUPS AMMOUNT AMMOUNT AMMOUNT AMMOUNT AMMOUNT

RANTI PEBIOLA $ 20.0 $ 20.0 $ 20.0 $ 20.0


HANA SASKIA $ 20.0
HAMDANI $ 20.0
RIO TARUNA $ 20.0 $ 20.0 $ 20.0 $ 20.0
LUKMAN $ 20.0 $ 20.0 $ 20.0 $ 40.0
BEN $ 50.0 $ 50.0 $ 50.0 $ 50.0 $ 50.0
ROHMAN $ 20.0
HANDRI $ 20.0 $ 20.0 $ 20.0 $ 20.0
STEVEN $ 20.0 $ 20.0 $ 20.0 $ 20.0
DIKI $ 20.0 $ 20.0 $ 20.0 $ 20.0
AHMAD $ 20.0 $ 20.0 $ 20.0 $ 20.0
MAULANA $ 20.0
JIMMY $ 20.0 $ 20.0 $ 20.0 $ 20.0
THOMAS $ 20.0 $ 20.0 $ 20.0 $ 20.0
ILHAM $ 20.0 $ 20.0 $ 20.0 $ 20.0
ABDUL GANI $ 20.0
FANDI $ 20.0
DAVID $ 20.0
SITI $ 20.0 $ 20.0 $ 20.0 $ 20.0
TOTAL $ 270.0 $ 270.0 $ 250.0 $ 410.0 $ 90.0
11-Feb-24

AMMOUNT AMMOUNT AMMOUNT AMMOUNT AMMOUNT AMMOUNT AMMOUNT

$ 20.0
$ 20.0
$ 20.0
$ 20.0
$ 40.0
$ 50.0
$ 30.0
$ 20.0
$ 20.0
$ 20.0

$ 20.0
$ 20.0
$ 30.0
$ 20.0
$ 20.0
$ 20.0
$ 20.0
$ 20.0
$ 430.0 $ - $ - $ - $ - $ - $ -
NAMA 15-Feb 1-Mar 15-Mar 1-Apr

RANTI PEBIOLA √ √
HANA SASKIA √ √
HAMDANI √ √
ROHMAN × ×
HANDRI × ×
STEVEN × ×
DIKI × ×
AHMAD × ×
MAULANA × ×
JIMMY × ×
THOMAS × ×
ILHAM × ×
ABDUL GANI × ×
FANDI × ×
SITI × ×
SHIRLEY SUDAH DAPAT TGL 15 FEB √ √
15-Apr 1-May 15-May 1-Jun 15-Jun

You might also like