PLANILLAS

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

PLANILLA DE SUELDOS Y SALARIOS

CORRESPONDE AL MES DE JUNIO DE 2023


EXPRESADO EN BOLIVIANOS

FECHA DE DIAS BONO DE ANTIGÜEDAD HORAS EXTRAS FERIADOS DESCUENTOS


ITEM NOMINA CARGO INGRESO TRABAJADOS HABER BASICO TOTAL GANADO
% IMPORTE Nº IMPORTE IMPORTE AFP`s
ADMINISTRACION
1 GERENTE ADMINISTRA 6/1/2023 30 12,000.00 12,000.00 1,525.20
2 PROFESIONAL 1 6/1/2023 30 6,500.00 6,500.00 826.15
3 PROFESIONAL 2 6/1/2023 30 6,500.00 6,500.00 826.15
4 PROFESIONAL 3 6/1/2023 30 6,500.00 6,500.00 826.15
5 PROFESIONAL 4 6/1/2023 30 6,500.00 6,500.00 826.15
6 ADMINISTRATIVO 6/1/2023 30 2,362.00 2,362.00 300.21
7 ADMINISTRATIVO 6/1/2023 30 2,362.00 2,362.00 300.21
8 ADMINISTRATIVO 6/1/2023 30 2,362.00 2,362.00 300.21
9 ADMINISTRATIVO 6/1/2023 30 2,362.00 2,362.00 300.21
10 ADMINISTRATIVO 6/1/2023 30 2,362.00 2,362.00 300.21
SUBTOTAL 49,810.00 49,810.00 6,330.85

HABITACION
11 GERENTE HABITACION 6/1/2023 30 12,000.00 12,000.00 1,525.20
12 JEFES DE SERVICIO 1 6/1/2023 30 8,000.00 8,000.00 1,016.80
13 BELL BOYS 1 6/1/2023 30 4,800.00 4,800.00 610.08
14 BELL BOYS 2 6/1/2023 30 4,800.00 4,800.00 610.08
15 BELL BOYS 3 6/1/2023 30 4,800.00 4,800.00 610.08
16 BELL BOYS 4 6/1/2023 30 4,800.00 4,800.00 610.08
17 BELL BOYS 5 6/1/2023 30 4,800.00 4,800.00 610.08
18 CAMARERA 1 6/1/2023 30 2,500.00 2,500.00 317.75
19 CAMARERA 2 6/1/2023 30 2,500.00 2,500.00 317.75
20 CAMARERA 3 6/1/2023 30 2,500.00 2,500.00 317.75
21 CAMARERA 4 6/1/2023 30 2,500.00 2,500.00 317.75
22 CAMARERA 5 6/1/2023 30 2,500.00 2,500.00 317.75
23 CAMARERA 6 6/1/2023 30 2,500.00 2,500.00 317.75
24 CAMARERA 7 6/1/2023 30 2,500.00 2,500.00 317.75
25 CAMARERA 8 6/1/2023 30 2,500.00 2,500.00 317.75
26 CAMARERA 9 6/1/2023 30 2,500.00 2,500.00 317.75
27 CAMARERA 10 6/1/2023 30 2,500.00 2,500.00 317.75
SUBTOTAL 69,000.00 69,000.00 8,769.90

RESTAURANTE
28 JEFES DE SERVICIO 2 6/1/2023 30 8,000.00 8,000.00 1,016.80
29 AUXILIAR 1 6/1/2023 30 2,500.00 2,500.00 317.75
30 AUXILIAR 2 6/1/2023 30 2,500.00 2,500.00 317.75
31 AUXILIAR 3 6/1/2023 30 2,500.00 2,500.00 317.75
32 AUXILIAR 4 6/1/2023 30 2,500.00 2,500.00 317.75
33 AUXILIAR 5 6/1/2023 30 2,500.00 2,500.00 317.75
SUBTOTAL 20,500.00 20,500.00 2,605.55

SAUNA
34 JEFES DE SERVICIO 3 6/1/2023 30 8,000.00 8,000.00 1,016.80
35 AUXILIAR 6 6/1/2023 30 2,500.00 2,500.00 317.75
36 AUXILIAR 7 6/1/2023 30 2,500.00 2,500.00 317.75
37 AUXILIAR 8 6/1/2023 30 2,500.00 2,500.00 317.75
SUBTOTAL 15,500.00 15,500.00 1,970.05

LAVANDERIA
38 JEFES DE SERVICIO 4 6/1/2023 30 8,000.00 8,000.00 1,016.80
39 AUXILIAR 9 6/1/2023 30 2,500.00 2,500.00 317.75
40 AUXILIAR 10 6/1/2023 30 2,500.00 2,500.00 317.75
SUBTOTAL 13,000.00 13,000.00 1,652.30

TINTORERIA
41 AUXILIAR 11 6/1/2023 30 2,500.00 2,500.00 317.75
42 AUXILIAR 12 6/1/2023 30 2,500.00 2,500.00 317.75
SUBTOTAL 5,000.00 5,000.00 635.50

TOTAL
DESCUENTOS TOTAL LIQUIDO
DESCUENTOS PAGABLE FIRMA
ANTICIPOS RC - IVA

1,525.20 10,474.80
826.15 5,673.85
826.15 5,673.85
826.15 5,673.85
826.15 5,673.85
300.21 2,061.79
300.21 2,061.79
300.21 2,061.79
300.21 2,061.79
300.21 2,061.79
6,330.85 43,479.15

1,525.20 10,474.80
1,016.80 6,983.20
610.08 4,189.92
610.08 4,189.92
610.08 4,189.92
610.08 4,189.92
610.08 4,189.92
317.75 2,182.25
317.75 2,182.25
317.75 2,182.25
317.75 2,182.25
317.75 2,182.25
317.75 2,182.25
317.75 2,182.25
317.75 2,182.25
317.75 2,182.25
317.75 2,182.25
8,769.90 60,230.10

1,016.80 6,983.20
317.75 2,182.25
317.75 2,182.25
317.75 2,182.25
317.75 2,182.25
317.75 2,182.25
2,605.55 17,894.45

1,016.80 6,983.20
317.75 2,182.25
317.75 2,182.25
317.75 2,182.25
1,970.05 13,529.95

1,016.80 6,983.20
317.75 2,182.25
317.75 2,182.25
1,652.30 11,347.70
317.75 2,182.25
317.75 2,182.25
635.50 4,364.50
PLANILLA TRIBUTARIA
CORRESPONDE AL MES DE JUNIO DE 2
EXPRESADO EN BOLIVIANOS

IMPUESTO DEDUCCIONES SALDO A FAVOR


Nº SUELDO NETO MINIMO NO MONTO DETERMINADO
IMPONIBLE IMPONIBLE 13% 13% FISCO
S/FORM.110 13% S/2SMN +
ADMINISTRACION
1 10,475.00 4,724.00 5,751.00 748.00 910.00 614.00
2 5,674.00 4,724.00 950.00 124.00 0.00 614.00
3 5,674.00 4,724.00 950.00 124.00 0.00 614.00
4 5,674.00 4,724.00 950.00 124.00 0.00 614.00
5 5,674.00 4,724.00 950.00 124.00 0.00 614.00
6 2,062.00 0.00 0.00 0.00 0.00 0.00
7 2,062.00 0.00 0.00 0.00 0.00 0.00
8 2,062.00 0.00 0.00 0.00 0.00 0.00
9 2,062.00 0.00 0.00 0.00 0.00 0.00
10 2,062.00 0.00 0.00 0.00 0.00 0.00

HABITACION
10,475.00 4,724.00 5,751.00 748.00 585.00 614.00
6,983.00 4,724.00 2,259.00 294.00 390.00 614.00
4,190.00
4,190.00
4,190.00
4,190.00
4,190.00
2,182.00
2,182.00
2,182.00
2,182.00
2,182.00
2,182.00
2,182.00
2,182.00
2,182.00
2,182.00

RESTAURANTE
4 6,983.00 4,724.00 2,259.00 294.00 0.00 614.00
2,182.00
2,182.00
2,182.00
2,182.00
2,182.00
SAUNA
6,983.00 4,724.00 2,259.00 294.00 0.00 614.00
2,182.00
2,182.00
2,182.00

LAVANDERIA
6,983.00 4,724.00 2,259.00 294.00 0.00 614.00
2,182.00
2,182.00

TINTORERIA
2,182.00
2,182.00
PLANILLA TRIBUTARIA
RESPONDE AL MES DE JUNIO DE 2023
EXPRESADO EN BOLIVIANOS

SALDO A FAVOR SALDO DEPENDIENTE MES ANTERIOR


TOTAL SALDO RC-IVA
DEPENDIENTE DEPENDIENTE UTILIZADO
- IMPORTE ACTUALIZACION TOTAL

776.00 776.00
490.00 490.00
490.00 490.00
490.00 490.00
490.00 490.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00

451.00 451.00
710.00 710.00

320.00 320.00
320.00 320.00

320.00 320.00
SALDO DEPENDIENTE
MES SIGUIENTE

776.00
490.00
490.00
490.00
490.00
0.00
0.00
0.00
0.00
0.00

451.00
710.00

320.00
320.00

320.00
PLANILLA DE CARGAS SOCIALES
CORRESPONDE AL MES DE
EXPRESADO EN BOLIVIANOS

APORTE PATRONAL
TOTAL APORTE
ITEM NOMINA CARGO TOTAL GANADO AFP`s PROVIVIENDA CNS PATRONAL
4,71% 2% 10% 16,71%

12,000.00 565.20 240.00 1,200.00 2,005.20


6,500.00 306.15 130.00 650.00 1,086.15
6,500.00 306.15 130.00 650.00 1,086.15
6,500.00 306.15 130.00 650.00 1,086.15
6,500.00 306.15 130.00 650.00 1,086.15
2,362.00 111.25 47.24 236.20 394.69
2,362.00 111.25 47.24 236.20 394.69
2,362.00 111.25 47.24 236.20 394.69
2,362.00 111.25 47.24 236.20 394.69
2,362.00 111.25 47.24 236.20 394.69
SUBTOTAL 2,346.05 996.20 4,981.00 8,323.25

12,000.00 565.20 240.00 1,200.00 2,005.20


8,000.00 376.80 160.00 800.00 1,336.80
4,800.00 226.08 96.00 480.00 802.08
4,800.00 226.08 96.00 480.00 802.08
4,800.00 226.08 96.00 480.00 802.08
4,800.00 226.08 96.00 480.00 802.08
4,800.00 226.08 96.00 480.00 802.08
2,500.00 117.75 50.00 250.00 417.75
2,500.00 117.75 50.00 250.00 417.75
2,500.00 117.75 50.00 250.00 417.75
2,500.00 117.75 50.00 250.00 417.75
2,500.00 117.75 50.00 250.00 417.75
2,500.00 117.75 50.00 250.00 417.75
2,500.00 117.75 50.00 250.00 417.75
2,500.00 117.75 50.00 250.00 417.75
2,500.00 117.75 50.00 250.00 417.75
2,500.00 117.75 50.00 250.00 417.75
SUBTOTAL 69,000.00 3,249.90 1,380.00 6,900.00 11,529.90

8,000.00 376.80 160.00 800.00 1,336.80


2,500.00 117.75 50.00 250.00 417.75
2,500.00 117.75 50.00 250.00 417.75
2,500.00 117.75 50.00 250.00 417.75
2,500.00 117.75 50.00 250.00 417.75
2,500.00 117.75 50.00 250.00 417.75
SUBTOTAL 20,500.00 965.55 410.00 2,050.00 3,425.55

8,000.00 376.80 160.00 800.00 1,336.80


2,500.00 117.75 50.00 250.00 417.75
2,500.00 117.75 50.00 250.00 417.75
2,500.00 117.75 50.00 250.00 417.75
SUBTOTAL 15,500.00 730.05 310.00 1,550.00 2,590.05

8,000.00 376.80 160.00 800.00 1,336.80


2,500.00 117.75 50.00 250.00 417.75
2,500.00 117.75 50.00 250.00 417.75
SUBTOTAL 13,000.00 612.30 260.00 1,300.00 2,172.30

2,500.00 117.75 50.00 250.00 417.75


2,500.00 117.75 50.00 250.00 417.75
SUBTOTAL 5,000.00 235.50 100.00 500.00 835.50
S
DE

BENEFICIOS SOCIALES
TOTAL CARGAS
TOTAL BENEFICIOS SOCIALES
AGUINALDO INDEMNIZACION SOCIALES 16,66%
8,33% 8,33% 33,37%

999.60 999.60 1,999.20 4,004.40


541.45 541.45 1,082.90 2,169.05
541.45 541.45 1,082.90 2,169.05
541.45 541.45 1,082.90 2,169.05
541.45 541.45 1,082.90 2,169.05
196.75 196.75 393.51 788.20
196.75 196.75 393.51 788.20
196.75 196.75 393.51 788.20
196.75 196.75 393.51 788.20
196.75 196.75 393.51 788.20
4,149.17 4,149.17 8,298.35 16,621.60

999.60 999.60 1,999.20 4,004.40


666.40 666.40 1,332.80 2,669.60
399.84 399.84 799.68 1,601.76
399.84 399.84 799.68 1,601.76
399.84 399.84 799.68 1,601.76
399.84 399.84 799.68 1,601.76
399.84 399.84 799.68 1,601.76
208.25 208.25 416.50 834.25
208.25 208.25 416.50 834.25
208.25 208.25 416.50 834.25
208.25 208.25 416.50 834.25
208.25 208.25 416.50 834.25
208.25 208.25 416.50 834.25
208.25 208.25 416.50 834.25
208.25 208.25 416.50 834.25
208.25 208.25 416.50 834.25
208.25 208.25 416.50 834.25
5,747.70 5,747.70 11,495.40 23,025.30

666.40 666.40 1,332.80 2,669.60


208.25 208.25 416.50 834.25
208.25 208.25 416.50 834.25
208.25 208.25 416.50 834.25
208.25 208.25 416.50 834.25
208.25 208.25 416.50 834.25
1,707.65 1,707.65 3,415.30 6,840.85

666.40 666.40 1,332.80 2,669.60


208.25 208.25 416.50 834.25
208.25 208.25 416.50 834.25
208.25 208.25 416.50 834.25
1,291.15 1,291.15 2,582.30 5,172.35

666.40 666.40 1,332.80 2,669.60


208.25 208.25 416.50 834.25
208.25 208.25 416.50 834.25
1,082.90 1,082.90 2,165.80 4,338.10

208.25 208.25 416.50 834.25


208.25 208.25 416.50 834.25
416.50 416.50 833.00 1,668.50

You might also like