Ejemplo de calculo de planilla
-
Upload
levi-alvarez -
Category
Documents
-
view
271 -
download
1
Transcript of Ejemplo de calculo de planilla
-
7/25/2019 Ejemplo de calculo de planilla
1/46
3 5 #7 ##25 27 #
ADMINISTRACION OFICINA PRIMER QUINCENA
COD. DEPTO. NOMBRE SUELDO BASE DIAS LAB.
1 1 Ada Lily Lpez Mayorga Q 4,250.00 15
2 1 Freddy Anibal Alvarado angel Q 2,4!7.04 15
3 1 Lev" Abalo$ Alvarez a$o Q 4,250.00 15
4 1 Lily %eane&' (orrayo )a*'e*o Q 3,500.00 15
5 1 )ablo +ernandez *'oa Q 2,-00.00 15
Q 17,097.04
GERENCIA PRIMER QUINCENA
COD. DEPTO. NOMBRE SUELDO BASE DIAS LAB.
- 1 Mireya del oario Agirre +errera Q 1/,200.00 30
7 1 An*el$a ano ar*ia Q 2,4!7.04 30
/ 1 Mar&a onelo (arilla Q 2,4!7.04 30
! 1 Li Alono a$ayoa Agirre Q 3,500.00 15
10 1 %oe Ma*ario Ma*ario Q 3,000.00 15
Q 29,694.08
-
7/25/2019 Ejemplo de calculo de planilla
2/46
CONDADO EL CARMEN PRIMER QUINCENA
COD. DEPTO. NOMBRE SUELDO BASE DIAS LAB.
11 2 Alvaro igober&o illa&oro ar*"a Q 4,000.00 15
12 2 a&ividad +ern6ndez Q 3,200.00 15
13 2 (ernardo Alaro (arilla Q 2,4!7.04 15
14 2 %orge dardo Lpez Q 2,4!7.04 15
15 2 8el9no (eni&e ar*"a Q 2,4!7.04 15
1- 2 alvador Lpez (arilla Q 2,4!7.04 15
17 2
1/ 2
1! 2
20 2
Q 17,188.16
LOS AMATES PRIMER QUINCENA
COD. DEPTO. NOMBRE SUELDO BASE DIAS LAB.
21 3 %orge Mynor %i$:nez Agilar Q 4,250.00 15
22 3 ladia Maribel Mon&e Morale Q 2,4!7.04 15
23 3 Q ; 0
24 3
Q 6,747.04
-
7/25/2019 Ejemplo de calculo de planilla
3/46
-
7/25/2019 Ejemplo de calculo de planilla
4/46
#31
CRETO 37-2001 TOTAL SUELDO SUELDO A PERCIBIR BONIFIC. A PERCIBIR ORAS E!TRAS
250.00 Q 4,500.00 Q 2,125.00 Q 125.00 ;
250.00 Q 2,747.04 Q 1,24/.52 Q 125.00 ;
250.00 Q 4,500.00 Q 2,125.00 Q 125.00 ;
250.00 Q 3,750.00 Q 1,750.00 Q 125.00 ;
250.00 Q 2,/50.00 Q 1,300.00 Q 125.00 ;
1,20.00 Q 18,347.04 Q 8,48.2 Q 62.00
CRETO 37-2001 TOTAL SUELDO SUELDO A PERCIBIR BONIFIC. A PERCIBIR ORAS E!TRAS
2,750.00 Q 20,!50.00 Q 1/,200.00 Q 2,77/.75 ;
250.00 Q 2,747.04 Q 2,4!7.04 Q 250.00 ;
250.00 Q 2,747.04 Q 2,4!7.04 Q 250.00 ;
250.00 Q 3,750.00 Q 1,750.00 Q 125.00 ;
250.00 Q 3,250.00 Q 1,500.00 Q 125.00 ;
3,70.00 Q 33,444.08 Q 26,444.08 Q 3,28.7
-
7/25/2019 Ejemplo de calculo de planilla
5/46
CRETO 37-2001 TOTAL SUELDO SUELDO A PERCIBIR BONIFIC. A PERCIBIR ORAS E!TRAS
250.00 Q 4,250.00 Q 2,000.00 Q 125.00 ;
250.00 Q 3,450.00 Q 1,-00.00 Q 125.00 ;
250.00 Q 2,747.04 Q 1,24/.52 Q 125.00 ;
250.00 Q 2,747.04 Q 1,24/.52 Q 125.00 ;
250.00 Q 2,747.04 Q 1,24/.52 Q 125.00 ;
250.00 Q 2,747.04 Q 1,24/.52 Q 125.00 ;
1,00.00 Q 18,688.16 Q 8,94.08 Q 70.00 -
CRETO 37-2001 TOTAL SUELDO SUELDO A PERCIBIR BONIFIC. A PERCIBIR ORAS E!TRAS
250.00 Q 4,500.00 Q 2,125.00 Q 125.00 ;
250.00 Q 2,747.04 Q 1,24/.52 Q 125.00 ;
; Q ; Q ; Q ;
00.00 Q 7,247.04 Q 3,373.2 Q 20.00 -
-
7/25/2019 Ejemplo de calculo de planilla
6/46
-
7/25/2019 Ejemplo de calculo de planilla
7/46
OR . E!T. TOTAL O. E!TRAS COMISIONES DE"EN$ADO I.$.S.S. I.$.S.S PAT.
2-.5- Q ; Q -72.00 Q 2,!22.00 Q 135.10 Q 354.3/
15.-1 Q ; Q ; Q 1,373.52 Q -0.30 Q 15/.1!
2-.5- Q ; Q ; Q 2,250.00 Q 102.-4 Q 2-!.24
21.// Q ; Q ; Q 1,/75.00 Q /4.53 Q 221.73
1-.25 Q ; Q ; Q 1,425.00 Q -2.7! Q 1-4.71
Q - Q 672.00 Q 9,84.2 Q 44.3 Q 1,168.24
OR . E!T. TOTAL O. E!TRAS COMISIONES DE"EN$ADO I.$.S.S. I.$.S.S. PAT.
113.75 Q ; Q ; Q 20,!7/.75 Q /7!.0- Q 2,305.!4
15.-1 Q ; Q ; Q 2,747.04 Q 120.-1 Q 31-.37
15.-1 Q ; Q ; Q 2,747.04 Q 120.-1 Q 31-.37
21.// Q ; Q ; Q 1,/75.00 Q /4.53 Q 221.73
1/.75 Q ; Q ; Q 1,-25.00 Q 72.45 Q 1!0.05
Q - Q - Q 29,972.83 Q 1,277.2 Q 3,30.46
-
7/25/2019 Ejemplo de calculo de planilla
8/46
OR . E!T. TOTAL O. E!TRAS COMISIONES DE"EN$ADO I.$.S.S. I.$.S.S. PAT.
25.00 Q ; Q ; Q 2,125.00 Q !-.-0 Q 253.40
20.00 Q ; Q 230.00 Q 1,!55.00 Q //.3! Q 231./-
15.-1 Q ; Q 3-0.00 Q 1,733.52 Q 77.-! Q 203./0
15.-1 Q ; Q ; Q 1,373.52 Q -0.30 Q 15/.1!
15.-1 Q ; Q ; Q 1,373.52 Q 37.4- Q 112.37
15.-1 Q ; Q ; Q 1,373.52 Q -0.30 Q 15/.1!
Q - Q 90.00 Q 9,934.08 Q 420.74 Q 1,117.80
OR . E!T. TOTAL O. E!TRAS COMISIONES DE"EN$ADO I.$.S.S. I.$.S.S. PAT.
2-.5- Q ; Q ; Q 2,250.00 Q 102.-4 Q 2-!.24
15.-1 Q ; Q ; Q 1,373.52 Q -0.30 Q 15/.1!
; Q ; Q ; Q ; Q ; Q ;
Q - Q - Q 3,623.2 Q 162.94 Q 427.42
-
7/25/2019 Ejemplo de calculo de planilla
9/46
-
7/25/2019 Ejemplo de calculo de planilla
10/46
I.S.R. PRESTAMOS OTRAS DEDUCCIONES TOTAL DEDUCCIONES LIQUIDO A RECIBIR
4-.71 Q ; Q ; Q 1/1./1 Q 2,740.1!
; Q ; Q ; Q -0.30 Q 1,313.22
14.74 Q ; Q ; Q 117.3/ Q 2,132.-2
; Q ; Q ; Q /4.53 Q 1,7!0.4/
; Q ; Q ; Q -2.7! Q 1,3-2.21
61.4 Q - Q - Q 06.80 Q 9,338.72
I.S.R. PRESTAMOS OTRAS DEDUCCIONES TOTAL DEDUCCIONES LIQUIDO A RECIBIR
/03.55 Q ; Q ; Q 1,-/2.-1 Q 1!,2!-.14
; Q ; Q ; Q 120.-1 Q 2,-2-.43
; Q ; Q ; Q 120.-1 Q 2,-2-.43
; Q ; Q ; Q /4.53 Q 1,7!0.4/
; Q ; Q ; Q 72.45 Q 1,552.55
803. Q - Q - Q 2,080.80 Q 27,892.03
A
-
7/25/2019 Ejemplo de calculo de planilla
11/46
I.S.R. PRESTAMOS OTRAS DEDUCCIONES TOTAL DEDUCCIONES LIQUIDO A RECIBIR
2./4 Q ; Q ; Q !!.44 Q 2,025.5-
; Q ; Q ; Q //.3! Q 1,/--.-1
; Q ; Q ; Q 77.-! Q 1,-55./3
; Q ; Q ; Q -0.30 Q 1,313.22
; Q ; Q ; Q 37.4- Q 1,33-.0-
; Q ; Q ; Q -0.30 Q 1,313.22
2.84 Q - Q - Q 423.8 Q 9,10.0
I.S.R. PRESTAMOS OTRAS DEDUCCIONES TOTAL DEDUCCIONES LIQUIDO A RECIBIR
14.74 Q 100.00 Q ; Q 217.3/ Q 2,032.-2
; Q ; Q ; Q -0.30 Q 1,313.22
; Q ; Q ; Q ; Q ;
14.74 Q 100.00 Q - Q 277.68 Q 3,34.84
-
7/25/2019 Ejemplo de calculo de planilla
12/46
-
7/25/2019 Ejemplo de calculo de planilla
13/46
DETALLE DE SALARIO PERIODO DEL 1&1&2016 AL 1&1&201OMPA'(A DE SER"ICIOS EL CARMEN,
NIT% 4100490-6
DE"EN$ADOS
N). E*+/) S/) B D T. O/5) B)5) 37-2001 O) I5
1 Ada Lily Lpez Mayorga Q 4,250.00 15 Q 2,125.00 Q 125.00 Q -72
2 Freddy Anibal Alvarado angel Q 2,4!7.04 15 Q 1,24/.52 Q 125.00 Q
3 Lev" Abalo$ Alvarez a$o Q 4,250.00 15 Q 2,125.00 Q 125.00 Q
4 Lily %eane&' (orrayo )a*'e*o Q 3,500.00 15 Q 1,750.00 Q 125.00 Q
5 )ablo +ernandez *'oa Q 2,-00.00 15 Q 1,300.00 Q 125.00 Q
- Mireya del oario Agirre +errera Q 1/,200.00 30 Q 1/,200.00 Q 2,77/.75 Q
7 An*el$a ano ar*ia Q 2,4!7.04 30 Q 2,4!7.04 Q 250.00 Q
/ Mar&a onelo (arilla Q 2,4!7.04 30 Q 2,4!7.04 Q 250.00 Q
! Li Alono a$ayoa Agirre Q 3,500.00 15 Q 1,750.00 Q 125.00 Q
10 Alvaro igober&o illa&oro ar*"a Q 4,000.00 15 Q 2,000.00 Q 125.00 Q
11 a&ividad +ern6ndez Q 3,200.00 15 Q 1,-00.00 Q 125.00 Q 230
12 (ernardo Alaro (arilla Q 2,4!7.04 15 Q 1,24/.52 Q 125.00 Q 3-0
13 %orge dardo Lpez Q 2,4!7.04 15 Q 1,24/.52 Q 125.00 Q
14 8el9no (eni&e ar*"a Q 2,4!7.04 15 Q 1,24/.52 Q 125.00 Q
15 alvador Lpez (arilla Q 2,4!7.04 15 Q 1,24/.52 Q 125.00 Q
1- %orge Mynor %i$:nez Agilar Q 4,250.00 15 Q 2,125.00 Q 125.00 Q
-
7/25/2019 Ejemplo de calculo de planilla
14/46
17 ladia Maribel Mon&e Morale Q 2,4!7.04 15 Q 1,24/.52 Q 125.00 Q
1/ %oe Ma*ario Ma*ario Q 3,000.00 15 Q 1,500.00 Q 125.00 Q
1!
20
TOTALES Q70,726.32 # Q 31.00 # Q 46,960.20 Q ,13.7 Q 1,2
=M
Q 9,338.72
T) + $5 Q27,892.03
T) + C)5//) E C*5 Q 9,10.0
T) + L) A* Q 3,34.84
I.$.S.S. Q 2,306.28
I.S.R. Q 882.8LA(A8 )
T) + O5 A/*5:5
-
7/25/2019 Ejemplo de calculo de planilla
15/46
DEDUCCIONES
OTAL IN$RESOS I$.S.S. I.S.R. P.&A5+. O) S/) L;/) C
-
7/25/2019 Ejemplo de calculo de planilla
16/46
1,373.52 Q -0.30 Q ; Q ; Q ; Q 1,313.22 0
1,-25.00 Q 72.45 Q ; Q ; Q ; Q 1,552.55 0
Q 3,37.9 # # Q2,306.28 # Q 882.8 # Q 100.00 # Q - # Q 0,087.09
-
7/25/2019 Ejemplo de calculo de planilla
17/46
DETALLE DE SALARIO PERIODO DEL 1&1&2016 AL 1&31&201OMPA'(A DE SER"ICIOS EL CARMEN,
NIT% 4100490-6
DE"EN$ADOS
N). E*+/) S/) B D T. O/5) B)5) 37-2001 O) I5
1 Ada Lily Lpez Mayorga Q 4,250.00 15 Q 2,125.00 Q 125.00 Q 33-
2 Freddy Anibal Alvarado angel Q 2,4!7.04 15 Q 1,24/.52 Q 125.00 Q
3 Lev" Abalo$ Alvarez a$o Q 4,250.00 15 Q 2,125.00 Q 125.00 Q
4 Lily %eane&' (orrayo )a*'e*o Q 3,500.00 15 Q 1,750.00 Q 125.00 Q 1,200
5 )ablo +ernandez *'oa Q 2,-00.00 15 Q 1,300.00 Q 125.00 Q
- Mireya del oario Agirre +errera Q ; ; Q ; Q ; Q
7 An*el$a ano ar*ia Q ; ; Q ; Q ; Q
/ Mar&a onelo (arilla Q ; ; Q ; Q ; Q
! Li Alono a$ayoa Agirre Q 3,500.00 15 Q 1,750.00 Q 125.00 Q
10 Alvaro igober&o illa&oro ar*"a Q 4,000.00 15 Q 2,000.00 Q 125.00 Q
11 a&ividad +ern6ndez Q 3,200.00 15 Q 1,-00.00 Q 125.00 Q 3-0
12 (ernardo Alaro (arilla Q 2,4!7.04 15 Q 1,24/.52 Q 125.00 Q 110
13 %orge dardo Lpez Q 2,4!7.04 15 Q 1,24/.52 Q 125.00 Q
14 8el9no (eni&e ar*"a Q 2,4!7.04 15 Q 1,24/.52 Q 125.00 Q
15 alvador Lpez (arilla Q 2,4!7.04 15 Q 1,24/.52 Q 125.00 Q
1- %orge Mynor %i$:nez Agilar Q 4,250.00 15 Q 2,125.00 Q 225.00 Q
-
7/25/2019 Ejemplo de calculo de planilla
18/46
17 ladia Maribel Mon&e Morale Q 2,4!7.04 15 Q 1,24/.52 Q 125.00 Q
1/ %oe Ma*ario Ma*ario Q 3,000.00 15 Q 1,500.00 Q 125.00 Q
1!
20
TOTALES Q47,32.24 # Q 22.00 # Q 23,766.12 Q 1,97.00 Q 2,0
=M
Q 9,386.29
T) + $5 Q 3,343.03
T) + C)5//) E C*5 Q 9,399.13
T) + L) A* Q 3,60.8
I.$.S.S. Q 1,221.9
I.S.R. Q 36.1LA(A8 )
T) + O5 A/*5:5
-
7/25/2019 Ejemplo de calculo de planilla
19/46
DEDUCCIONES
OTAL IN$RESOS I$.S.S. I.S.R. P*) O) S/) L;/)
2,5/-.00 Q 11/./7 Q ; Q 300.00 Q ; Q 2,1-7.13
1,373.52 Q -0.30 Q ; Q ; Q ; Q 1,313.22
2,250.00 Q 102.-4 Q ; Q 500.00 Q ; Q 1,-47.3-
3,075.00 Q 142.4! Q 3-.15 Q ; Q ; Q 2,/!-.37
1,425.00 Q -2.7! Q ; Q ; Q ; Q 1,3-2.21
; Q ; Q ; Q ; Q ; Q ;
; Q ; Q ; Q ; Q ; Q ;
; Q ; Q ; Q ; Q ; Q ;
1,/75.00 Q /4.53 Q ; Q ; Q ; Q 1,7!0.4/
2,125.00 Q !-.-0 Q ; Q ; Q ; Q 2,02/.40
2,0/5.00 Q !4.-7 Q ; Q ; Q ; Q 1,!!0.33
1,4/3.52 Q -5.-2 Q ; Q ; Q ; Q 1,417.!0
1,373.52 Q -0.30 Q ; Q ; Q ; Q 1,313.22
1,373.52 Q 37.4- Q ; Q ; Q ; Q 1,33-.0-
1,373.52 Q -0.30 Q ; Q ; Q ; Q 1,313.22
2,350.00 Q 102.-4 Q ; Q ; Q ; Q 2,247.3-
-
7/25/2019 Ejemplo de calculo de planilla
20/46
1,373.52 Q -0.30 Q ; Q ; Q ; Q 1,313.22
1,-25.00 Q 72.45 Q ; Q ; Q ; Q 1,552.55
Q 27,747.12 Q - # Q 1,221.9 Q 36.1 # Q 800.00 # Q - # Q 2,689.02
-
7/25/2019 Ejemplo de calculo de planilla
21/46
DETALLES DE SUELDOS PARA FACTURA MENSUAL A DESARROLLOS
PRIMER QUINCENA SE$UND
ALA 37;2001
>>AL >AL A )A>AL Q 4,51/.70 =>A )A>AL
-
7/25/2019 Ejemplo de calculo de planilla
22/46
"IDELCO, S.A.
QUINCENA
11,7!/.52
1,53-.00
13,334.52
/75.00
14,20!.52
1,-/!.4/
1,!07.//
Q 17,806.88
-
7/25/2019 Ejemplo de calculo de planilla
23/46
)
DEPARTAMENTO CODI$O CUENTA
Ad$ini&ra*ion 53501 eldo y alar
Ad$ini&ra*ion 53503 8e*re&o 37;20
Ad$ini&ra*ion 5350! o$iione
Ad$ini&ra*ion 53537 o&a )a&.
-
7/25/2019 Ejemplo de calculo de planilla
24/46
21102
TOTAL DE POLI=A
ras e ucc ones
-
7/25/2019 Ejemplo de calculo de planilla
25/46
L
-
7/25/2019 Ejemplo de calculo de planilla
26/46
Q ;
e&en*ione
-
7/25/2019 Ejemplo de calculo de planilla
27/46
Q 4-,7!1.12
Q 17,1//.1-
Q -,747.04
-
7/25/2019 Ejemplo de calculo de planilla
28/46
-
7/25/2019 Ejemplo de calculo de planilla
29/46
RESUMEN SALARIOS > PA$OS
TOTAL DE SALARIOS% Q 73,994.32
CUOTA PATRONAL% Q 9,283.44
CUOTA TRABA?ADORES% Q 3,28.23
TOTAL A PA$AR% Q 12,811.67
-
7/25/2019 Ejemplo de calculo de planilla
30/46
L I$SS
-
7/25/2019 Ejemplo de calculo de planilla
31/46
NIT NOMBRE DEL EMPLEADO
4789822 Mireya Del Rosario Aguirre Herrera de Samayoa
36154202 Alvaro Rigoberto Villatoro Garcia
23755903 Ada Lily Lopez Mayorga
16051769 Jorge Mynor Jimenez Aguilar
78436362 Lily Jeaneth orrayo !acheco
5214874 Del"ino enites Garc#a
82721769 $laudia Maribel Montes Morales
44686080 Salvador Lopez arillas
52103668 Jorge %duardo Lopez
27959058 &atividad Hernandez
54021146 ernardo Al"aro arillas
12725773 !ablo Hernandez 'choa
19682077 (reddy Anibal Alvarado Rangel
45288119 Lev# Absalom Alvarez Ramos
82092869 Ancelma $ano Garcia
82778728 Marta $onsuelo arillas
-
7/25/2019 Ejemplo de calculo de planilla
32/46
ENER
FECA DE IN$RESO S/) B
01/01/14 Q 13,169.05 Q 13,169.05 Q -
01/01/14 Q 4,000.00 Q 4,000.00 Q -
01/01/14 Q 4,250.00 Q 4,250.00 Q 336.00
01/01/14 Q 3,750.00 Q 3,750.00 Q -
01/01/14 Q 2,500.00 Q 2,500.00 Q -
01/01/14 Q 2,171.75 Q 2,171.75 Q -
01/01/14 Q 2,171.75 Q 2,171.75 Q -
01/01/14 Q 2,171.75 Q - Q -
01/01/14 Q 2,171.75 Q 2,171.75 Q -
01/01/14 Q 3,200.00 Q 3,200.00 Q 740.00
01/01/14 Q 2,171.75 Q 2,171.75 Q 380.00
01/01/14 Q 2,250.00 Q 2,250.00 Q -
01/01/14 Q 2,171.75 Q 2,171.75 Q -
01/01/14 Q 2,500.00 Q 2,500.00 Q -
01/01/14 Q 2,171.75 Q 2,171.75 Q -
01/01/14 Q 2,171.75 Q 2,171.75 Q -
### Q 0,821.30 Q 1,46.00
SUELDOBASE
ACTUAL
O) A@)
I$SS
-
7/25/2019 Ejemplo de calculo de planilla
33/46
FEBRERO
B)5:5 I$SS B)5:54 I$SS
Q 250.00 Q 636.07 Q 13,169.05 Q - Q 250.00 Q 636.07
Q 250.00 Q 193.20 Q 4,000.00 Q - Q 250.00 Q 193.20
Q 250.00 Q 221.50 Q 4,250.00 Q 336.00 Q 250.00 Q 221.50
Q 250.00 Q 181.13 Q 3,750.00 Q - Q 250.00 Q 181.13
Q 250.00 Q 120.75 Q 2,500.00 Q - Q 250.00 Q 120.75
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q - Q - Q - Q - Q - Q -
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 250.00 Q 190.30 Q 3,200.00 Q 680.00 Q 250.00 Q 187.40
Q 250.00 Q 123.25 Q 2,171.75 Q 720.00 Q 250.00 Q 139.67
Q 250.00 Q 108.68 Q 2,250.00 Q - Q 250.00 Q 108.68
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 250.00 Q 120.75 Q 2,500.00 Q - Q 250.00 Q 120.75
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 3,70.00 ### ### Q 1,736.00 Q 3,70.00 ###
S/)
B2
O)A@)
I$SS3
-
7/25/2019 Ejemplo de calculo de planilla
34/46
MAR=O A
B)5:58 I$SS9
Q 13,169.05 Q - Q 250.00 Q 636.07 Q 13,169.05 Q -
Q 4,000.00 Q - Q 250.00 Q 193.20 Q 4,000.00 Q -
Q 4,250.00 Q 336.00 Q 250.00 Q 221.50 Q 4,250.00 Q 336.00
Q 3,750.00 Q - Q 250.00 Q 181.13 Q 3,750.00 Q -
Q 2,500.00 Q - Q 250.00 Q 120.75 Q 2,500.00 Q -
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 2,171.75 Q -
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 2,171.75 Q -
Q - Q - Q - Q - Q - Q -
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 2,171.75 Q -
Q 3,200.00 Q 660.00 Q 250.00 Q 186.44 Q 3,200.00 Q 740.00
Q 2,171.75 Q 690.00 Q 250.00 Q 138.22 Q 2,171.75 Q 740.00
Q 2,250.00 Q - Q 250.00 Q 108.68 Q 2,250.00 Q -
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 2,171.75 Q -
Q 2,500.00 Q - Q 250.00 Q 120.75 Q 2,500.00 Q -
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 2,171.75 Q -
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 2,171.75 Q -
### Q 1,686.00 Q 3,70.00 ### ### Q 1,816.00
S/)
B6
O)A@)
I$SS7
S/)
B10
O)A@) I$SS11
-
7/25/2019 Ejemplo de calculo de planilla
35/46
RIL MA>O
B)5:512 I$SS13 B)5:516 I$SS17
Q 250.00 Q 636.07 Q 13,169.05 Q - Q 250.00 Q 636.07
Q 250.00 Q 193.20 Q 4,000.00 Q - Q 250.00 Q 193.20
Q 250.00 Q 221.50 Q 4,250.00 Q 672.00 Q 250.00 Q 237.73
Q 250.00 Q 181.13 Q 3,750.00 Q - Q 250.00 Q 181.13
Q 250.00 Q 120.75 Q 2,500.00 Q - Q 250.00 Q 120.75
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q - Q - Q 2,099.36 Q - Q 241.67 Q 101.40
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 250.00 Q 190.30 Q 3,200.00 Q 740.00 Q 250.00 Q 190.30
Q 250.00 Q 140.64 Q 2,171.75 Q 780.00 Q 250.00 Q 142.57
Q 250.00 Q 108.68 Q 2,250.00 Q - Q 250.00 Q 108.68
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 250.00 Q 120.75 Q 2,500.00 Q - Q 250.00 Q 120.75
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 3,70.00 ### ### Q 2,192.00 Q 3,991.67 ###
S/)
B14
O)A@) I$SS1
A
-
7/25/2019 Ejemplo de calculo de planilla
36/46
?UNIO ?
B)5:520 I$SS21
Q 13,169.05 Q - Q 250.00 Q 636.07 Q 13,169.05 Q -
Q 4,000.00 Q - Q 250.00 Q 193.20 Q 4,000.00 Q -
Q 4,250.00 Q 672.00 Q 250.00 Q 237.73 Q 4,250.00 Q 672.00
Q 3,750.00 Q - Q 250.00 Q 181.13 Q 3,750.00 Q -
Q 2,500.00 Q - Q 250.00 Q 120.75 Q 2,500.00 Q -
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 2,171.75 Q -
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 2,171.75 Q -
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 2,171.75 Q -
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 2,171.75 Q -
Q 3,200.00 Q 700.00 Q 250.00 Q 188.37 Q 3,200.00 Q 770.00
Q 2,171.75 Q 820.00 Q 250.00 Q 144.50 Q 2,171.75 Q 850.00
Q 2,250.00 Q - Q 250.00 Q 108.68 Q 2,250.00 Q -
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 2,171.75 Q -
Q 2,500.00 Q - Q 250.00 Q 120.75 Q 2,500.00 Q -
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 2,171.75 Q -
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 2,171.75 Q -
### Q 2,192.00 Q 4,000.00 ### ### Q 2,292.00
S/)
B18
O)A@) I$SS19
S/)
B22
O)A@) I$SS23
-
7/25/2019 Ejemplo de calculo de planilla
37/46
LIO A$OSTO
B)5:524 I$SS2 B)5:528 I$SS29
Q 250.00 Q 636.07 Q 13,169.05 Q - Q 250.00 Q 636.07
Q 250.00 Q 193.20 Q 4,000.00 Q - Q 250.00 Q 193.20
Q 250.00 Q 237.73 Q 4,250.00 Q 672.00 Q 250.00 Q 237.73
Q 250.00 Q 181.13 Q 3,750.00 Q - Q 250.00 Q 181.13
Q 250.00 Q 120.75 Q 2,500.00 Q - Q 250.00 Q 120.75
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 250.00 Q 191.75 Q 3,200.00 Q 330.00 Q 250.00 Q 170.50
Q 250.00 Q 145.95 Q 2,171.75 Q 840.00 Q 250.00 Q 145.47
Q 250.00 Q 108.68 Q 2,250.00 Q - Q 250.00 Q 108.68
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 250.00 Q 120.75 Q 2,500.00 Q - Q 250.00 Q 120.75
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 4,000.00 ### ### Q 1,842.00 Q 4,000.00 ###
S/)
B26
O)A@) I$SS27
A
-
7/25/2019 Ejemplo de calculo de planilla
38/46
SEPTIEMBRE OC
B)5:532 I$SS33
Q 13,169.05 Q - Q 250.00 Q 636.07 Q 13,169.05 Q -
Q 4,000.00 Q - Q 250.00 Q 193.20 Q 4,000.00 Q -
Q 4,250.00 Q 672.00 Q 250.00 Q 237.73 Q 4,250.00 Q 672.00
Q 3,750.00 Q - Q 250.00 Q 181.13 Q 3,750.00 Q -
Q 2,500.00 Q - Q 250.00 Q 120.75 Q 2,500.00 Q -
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 2,171.75 Q -
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 2,171.75 Q -
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 2,171.75 Q -
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 2,171.75 Q -
Q 3,200.00 Q 710.00 Q 250.00 Q 188.85 Q 3,200.00 Q 770.00
Q 2,171.75 Q 760.00 Q 250.00 Q 141.60 Q 2,171.75 Q 850.00
Q 2,250.00 Q - Q 250.00 Q 108.68 Q 2,250.00 Q -
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 2,171.75 Q -
Q 2,500.00 Q - Q 250.00 Q 120.75 Q 2,500.00 Q -
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 2,171.75 Q -
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 2,171.75 Q -
### Q 2,142.00 Q 4,000.00 ### ### Q 2,292.00
S/)
B30
O)A@) I$SS31
S/)
B34
O)A@) I$SS3
-
7/25/2019 Ejemplo de calculo de planilla
39/46
UBRE NO"IEMBRE
B)5:536 I$SS37 B)5:540 I$SS41
Q 250.00 Q 636.07 Q 13,169.05 Q - Q 250.00 Q 636.07
Q 250.00 Q 193.20 Q 4,000.00 Q - Q 250.00 Q 193.20
Q 250.00 Q 237.73 Q 4,250.00 Q 672.00 Q 250.00 Q 237.73
Q 250.00 Q 181.13 Q 3,750.00 Q - Q 250.00 Q 181.13
Q 250.00 Q 120.75 Q 2,500.00 Q - Q 250.00 Q 120.75
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 250.00 Q 191.75 Q 3,200.00 Q 680.00 Q 250.00 Q 187.40
Q 250.00 Q 145.95 Q 2,171.75 Q 730.00 Q 250.00 Q 140.15
Q 250.00 Q 108.68 Q 2,250.00 Q - Q 250.00 Q 108.68
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 250.00 Q 120.75 Q 2,500.00 Q - Q 250.00 Q 120.75
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 250.00 Q 104.90 Q 2,171.75 Q - Q 250.00 Q 104.90
Q 4,000.00 ### ### Q 2,082.00 Q 4,000.00 ###
S/)
B38
O)A@) I$SS39
A
-
7/25/2019 Ejemplo de calculo de planilla
40/46
DICIEMBRE
B)5:544 I$SS4
Q 13,169.05 Q - Q 250.00 Q 636.07 Q 3,000.00
Q 4,000.00 Q - Q 250.00 Q 193.20 Q 3,000.00
Q 4,250.00 Q 672.00 Q 250.00 Q 237.73 Q 3,000.00
Q 3,750.00 Q - Q 250.00 Q 181.13 Q 3,000.00
Q 2,500.00 Q - Q 250.00 Q 120.75 Q 3,000.00
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 3,000.00
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 3,000.00
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 1,991.67
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 3,000.00
Q 3,200.00 Q 710.00 Q 250.00 Q 188.85 Q 3,000.00
Q 2,171.75 Q 790.00 Q 250.00 Q 143.05 Q 3,000.00
Q 2,250.00 Q - Q 250.00 Q 108.68 Q 3,000.00
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 3,000.00
Q 2,500.00 Q - Q 250.00 Q 120.75 Q 3,000.00
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 3,000.00
Q 2,171.75 Q - Q 250.00 Q 104.90 Q 3,000.00
### Q 2,172.00 Q 4,000.00 ### Q - Q 46,991.67
S/)
B42
O)A@) I$SS43
BONIFICACION
20 ANUAL
-
7/25/2019 Ejemplo de calculo de planilla
41/46
RENTAS BRUTAS
BONO 14 A$UINALDO
Q 13,169.05 Q 13,169.05 Q - Q 187,366.70 Q 187,366.70
Q 4,000.00 Q 4,000.00 Q - Q 59,000.00 Q 59,000.00
Q 4,250.00 Q 4,250.00 Q 8,064.00 Q 70,564.00 Q 70,564.00
Q 3,750.00 Q 3,750.00 Q - Q 55,500.00 Q 55,500.00
Q 2,500.00 Q 2,500.00 Q - Q 38,000.00 Q 38,000.00
Q 2,122.88 Q 2,171.75 Q - Q 33,355.63 Q 33,355.63
Q 2,122.88 Q 2,171.75 Q - Q 33,355.63 Q 33,355.63
Q 357.00 Q 1,267.35 Q - Q 20,917.63 Q 20,917.63
Q 2,122.88 Q 2,171.75 Q - Q 33,355.63 Q 33,355.63
Q 3,200.00 Q 3,200.00 Q - Q 47,800.00 Q 47,800.00
Q 2,122.88 Q 2,171.75 Q - Q 33,355.63 Q 33,355.63
Q 2,250.00 Q 2,250.00 Q - Q 34,500.00 Q 34,500.00
Q 2,122.88 Q 2,171.75 Q - Q 33,355.63 Q 33,355.63
Q 2,500.00 Q 2,500.00 Q - Q 38,000.00 Q 38,000.00
Q 2,122.88 Q 2,171.75 Q - Q 33,355.63 Q 33,355.63
Q 2,122.88 Q 2,171.75 Q - Q 33,355.63 Q 33,355.63
Q0,836.21 Q 2,088.6 Q 8,064.00 Q 78,137.74 ###
OTROS
IN$RESOS
RENTA BRUTA
POR PATRONO
TOTAL RENTABRUTA EN
ESTEPERIODO
-
7/25/2019 Ejemplo de calculo de planilla
42/46
DETERMINACION RENTA NETA
A$UINALDO47 BONO 1448
Q 13,169.05 Q 13,169.05 Q 26,338.10 Q 161,028.60 Q 48,000.00
Q 4,000.00 Q 4,000.00 Q 8,000.00 Q 51,000.00 Q 48,000.00
Q 4,250.00 Q 4,250.00 Q 8,500.00 Q 62,064.00 Q 48,000.00
Q 3,750.00 Q 3,750.00 Q 7,500.00 Q 48,000.00 Q 48,000.00
Q 2,500.00 Q 2,500.00 Q 5,000.00 Q 33,000.00 Q 48,000.00
Q 2,171.75 Q 2,122.88 Q 4,294.63 Q 29,061.00 Q 48,000.00
Q 2,171.75 Q 2,122.88 Q 4,294.63 Q 29,061.00 Q 48,000.00
Q 1,267.35 Q 357.00 Q 1,624.35 Q 19,293.28 Q 48,000.00
Q 2,171.75 Q 2,122.88 Q 4,294.63 Q 29,061.00 Q 48,000.00
Q 3,200.00 Q 3,200.00 Q 6,400.00 Q 41,400.00 Q 48,000.00
Q 2,171.75 Q 2,122.88 Q 4,294.63 Q 29,061.00 Q 48,000.00
Q 2,250.00 Q 2,250.00 Q 4,500.00 Q 30,000.00 Q 48,000.00
Q 2,171.75 Q 2,122.88 Q 4,294.63 Q 29,061.00 Q 48,000.00
Q 2,500.00 Q 2,500.00 Q 5,000.00 Q 33,000.00 Q 48,000.00
Q 2,171.75 Q 2,122.88 Q 4,294.63 Q 29,061.00 Q 48,000.00
Q 2,171.75 Q 2,122.88 Q 4,294.63 Q 29,061.00 Q 48,000.00
Q 2,088.6 Q 0,836.21 ### ### Q 768,000.00
RENTAS
E!ENTAS
RENTA
NETA
DEDUCCION
PERSONAL
-
7/25/2019 Ejemplo de calculo de planilla
43/46
DEDUCCIONES UIDACION DEL IMPUEST
I$SS ANUAL
Q 7,632.78 Q 55,632.78 Q 105,395.82 Q 5,269.79 Q0.00
Q 2,318.40 Q 50,318.40 Q 681.60 Q 34.08 Q0.00
Q 2,852.88 Q 50,852.88 Q 11,211.12 Q 560.56 Q0.00
Q 2,173.50 Q 50,173.50 Q - Q - Q0.00
Q 1,449.00 Q 49,449.00 Q - Q - Q0.00
Q 1,258.75 Q 49,258.75 Q - Q - Q0.00
Q 1,258.75 Q 49,258.75 Q - Q - Q0.00
Q 835.67 Q 48,835.67 Q - Q - Q0.00
Q 1,258.75 Q 49,258.75 Q - Q - Q0.00
Q 2,252.23 Q 50,252.23 Q - Q - Q0.00
Q 1,691.03 Q 49,691.03 Q - Q - Q0.00
Q 1,304.10 Q 49,304.10 Q - Q - Q0.00
Q 1,258.75 Q 49,258.75 Q - Q - Q0.00
Q 1,449.00 Q 49,449.00 Q - Q - Q0.00
Q 1,258.75 Q 49,258.75 Q - Q - Q0.00
Q 1,258.75 Q 49,258.75 Q - Q - Q0.00
Q 31,11.07 Q 799,11.07 Q 117,288.4 Q ,864.43 Q -
TOTAL
DEDUCCIONES
RENTA
IMPONIBLE
IMPUESTOANUAL APA$AR
RETENCIONES
PRACTICADAS
-
7/25/2019 Ejemplo de calculo de planilla
44/46
O O RETENCION EN E!CE TOTAL IN$RESOS E I$SS
S/) B
Q 5,269.79 Q - Q 15/,02/.-0 Q ; Q 3,000.00
Q 34.08 Q - Q 4/,000.00 Q ; Q 3,000.00
Q 560.56 Q - Q 51,000.00 Q -,720.00 Q 3,000.00
Q - Q - Q 45,000.00 Q ; Q 3,000.00
Q - Q - Q 30,000.00 Q ; Q 3,000.00
Q - Q - Q 2-,0-1.00 Q ; Q 3,000.00
Q - Q - Q 2-,0-1.00 Q ; Q 3,000.00
Q - Q - Q 17,301.-1 Q ; Q 1,!!1.-7
Q - Q - Q 2-,0-1.00 Q ; Q 3,000.00
Q - Q - Q 3/,400.00 Q /,230.00 Q 3,000.00
Q - Q - Q 2-,0-1.00 Q /,!50.00 Q 3,000.00
Q - Q - Q 27,000.00 Q ; Q 3,000.00
Q - Q - Q 2-,0-1.00 Q ; Q 3,000.00
Q - Q - Q 30,000.00 Q ; Q 3,000.00
Q - Q - Q 2-,0-1.00 Q ; Q 3,000.00
Q - Q - Q 2-,0-1.00 Q ; Q 3,000.00
Q ,864.43 Q - Q627,17.21 ### ###
IMPUESTO
PENDIENTE
IMPUESTO ADE"OL"ER POR
EL PATRONO
O)A@)
I$SS
B)5:
5
-
7/25/2019 Ejemplo de calculo de planilla
45/46
013 CALCULO IS
I$SS S/) B R5 N
Q 7,-32.7/ Q 15/,02/.-0 Q ; Q 3,000.00 Q 15/,02/.-0 Q 4/,000.00
Q 2,31/.40 Q 4/,000.00 Q ; Q 3,000.00 Q 4/,000.00 Q 4/,000.00
Q 2,7/7.// Q 51,000.00 Q -,720.00 Q 3,000.00 Q 57,720.00 Q 4/,000.00
Q 2,173.50 Q 45,000.00 Q ; Q 3,000.00 Q 45,000.00 Q 4/,000.00
Q 1,44!.00 Q 30,000.00 Q ; Q 3,000.00 Q 30,000.00 Q 4/,000.00
Q 1,25/.75 Q 2-,0-1.00 Q ; Q 3,000.00 Q 2-,0-1.00 Q 4/,000.00
Q 1,25/.75 Q 2-,0-1.00 Q ; Q 3,000.00 Q 2-,0-1.00 Q 4/,000.00
Q /35.-7 Q 17,301.-1 Q ; Q 1,!!1.-7 Q 17,301.-1 Q 4/,000.00
Q 1,25/.75 Q 2-,0-1.00 Q ; Q 3,000.00 Q 2-,0-1.00 Q 4/,000.00
Q 2,252.23 Q 3/,400.00 Q /,230.00 Q 3,000.00 Q 4-,-30.00 Q 4/,000.00
Q 1,-!1.03 Q 2-,0-1.00 Q /,!50.00 Q 3,000.00 Q 35,011.00 Q 4/,000.00
Q 1,304.10 Q 27,000.00 Q ; Q 3,000.00 Q 27,000.00 Q 4/,000.00
Q 1,25/.75 Q 2-,0-1.00 Q ; Q 3,000.00 Q 2-,0-1.00 Q 4/,000.00
Q 1,44!.00 Q 30,000.00 Q ; Q 3,000.00 Q 30,000.00 Q 4/,000.00
Q 1,25/.75 Q 2-,0-1.00 Q ; Q 3,000.00 Q 2-,0-1.00 Q 4/,000.00
Q 1,25/.75 Q 2-,0-1.00 Q ; Q 3,000.00 Q 2-,0-1.00 Q 4/,000.00
### Q627,17.21 ### ### Q61,07.21 ###
O)A@)
I$SS
B)5)
5 I55)
D/:5
L
-
7/25/2019 Ejemplo de calculo de planilla
46/46
R ASALARIADO
I$SS O) A5 M5
Q 7,-32.7/ Q ; Q 55,-32.7/ ### Q 5,11!.7! Q426.6 rrB50!Q 2,31/.40 Q ; Q 50,31/.40 Q ; Q ; Q - rrB50!Q 2,7/7.// Q ; Q 50,7/7.// Q 6,932.12 Q 34-.-1 Q 28.88 rrB50!Q 2,173.50 Q ; Q 50,173.50 Q ; Q ; Q - rrB50!Q 1,44!.00 Q ; Q 4!,44!.00 Q ; Q ; Q - rrB50!Q 1,25/.75 Q ; Q 4!,25/.75 Q ; Q ; Q - rrB50!Q 1,25/.75 Q ; Q 4!,25/.75 Q ; Q ; Q - rrB50!Q /35.-7 Q ; Q 4/,/35.-7 Q ; Q ; Q - rrB50!Q 1,25/.75 Q ; Q 4!,25/.75 Q ; Q ; Q - rrB50!Q 2,252.23 Q ; Q 50,252.23 Q ; Q ; Q - rrB50!Q 1,-!1.03 Q ; Q 4!,-!1.03 Q ; Q ; Q - rrB50!Q 1,304.10 Q ; Q 4!,304.10 Q ; Q ; Q - rrB50!Q 1,25/.75 Q ; Q 4!,25/.75 Q ; Q ; Q - rrB50!Q 1,44!.00 Q ; Q 4!,44!.00 Q ; Q ; Q - rrB50!Q 1,25/.75 Q ; Q 4!,25/.75 Q ; Q ; Q - rrB50!
Q 1,25/.75 Q ; Q 4!,25/.75 Q ; Q ; Q - rrB50!### Q - ### ### Q,466.40 Q 4.3
T)
D/)5
R5
I*+)5
DESCUENTOMENSUAL