0% found this document useful (0 votes)
13 views6 pages

Nómina de Trabajadores y Cálculo de Impuestos

This payroll register lists the names, identification numbers, wages, bonuses, and taxes for various employees. It includes information such as base pay, overtime hours and pay, marginal tax rates, fixed tax amounts, subsidies, and total taxes owed for two sample employees: Jacqueline Avila Guzman and Erick Jair Alejandro Mayoral. It also provides daily wage rates, days worked, salaries, and overtime hours for additional employees.
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
0% found this document useful (0 votes)
13 views6 pages

Nómina de Trabajadores y Cálculo de Impuestos

This payroll register lists the names, identification numbers, wages, bonuses, and taxes for various employees. It includes information such as base pay, overtime hours and pay, marginal tax rates, fixed tax amounts, subsidies, and total taxes owed for two sample employees: Jacqueline Avila Guzman and Erick Jair Alejandro Mayoral. It also provides daily wage rates, days worked, salaries, and overtime hours for additional employees.
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

CLAVE DEL TRABAJADOR NOMBRE DEL TRABAJADOR RFC DEL TRABAJADOR

K090 JACQUELINE AVILA GUZMAN AIGJ011228-MC2


W333 ERICK JAIR ALEJANDRO MAYORAL AEME991119-HG8
Ñ099 ABRIL ADALIZ LIQUIDANO HERNANDEZ LIHA020510-MG7
Q771 VALERIA MARTINEZ NAVA MANV020311-MG1
J080 ANDREA CATALAN NAVARRETE CANA020617-9DM
E999 YAZMIN MELCHOR FAUSTINO MEFY020808-MGRL
Z233 MILTON SALGADO ESTRADA SAEM021023-HG9
F101 JUAN JESUS MARTINEZ NAVARRETE MANJ001226-HG0
O900 CARLOS HERNANDEZ TERRERO HETC020817-GR5
X636 JOAN ALBERTO TORRES ARELLANOS TOAJ020329-FU5
N061 NAOMI JAZMIN GARCIA LEAL GALN021106-MGA2
E678 EDWIN MEZA RAMOS MERE020609-GA4
M567 ERICK JAIR MORALES CRUZ MOCE021129-AH5
R564 RODRIGO JIMENEZ EUGENIO JIER021221-G09
G234 GIOVANNA NAZARIO ORTIZ NAOG020912-VA7
Z233 MILTON SALGADO ESTRADA SAEM021023-HG9
H198 ELENA CORTEZ DOLORES CODT0280831-KJ1
N873 NOELY MANRRIQUE OLEA MAON020908-LL4
J367 JAIR EMILIANO RUDECINDO FELIX MJSK087361-12F
N456 ANDREA NAVARRETE LAGUNAS NALA09317-J48

ISR JACQUELINE AVILA GUZMAN ERICK JAIR ALEJANDRO

BASE PARA EL CALCULO $ 3,525.00 $ 4,243.13


(-)LIMITE INFERIOR $ 2,422.81 $ 2,422.81
(=)EXCEDENTE SOBRE EL LIMITE
$ 1,102.19 $ 1,820.32
INFERIOR
% SOBRE EL EXCEDENTE 10.88% 10.88%
(=) IMPUESTO MARGINAL $ 119.92 $ 198.05
(+) CUOTA FIJA $ 142.20 $ 142.20
(=) IMPUESTO MARGINAL $ 262.12 $ 340.25
(-) SUBSIDIO PARA EL EMPLEO $ 107.40 $ -
(=) IMPUESTO A PAGAR $ 154.72 $ 340.25
CUOTA DIARIA DIAS TRABAJADOS SUELDO NO. DE HRS EXTS. DOBLES

$ 150.00 15 $ 2,250.00 9
$ 155.00 14 $ 2,170.00 12
$ 160.00 11 $ 1,760.00 11
$ 165.00 10 $ 1,650.00 13
$ 170.00 12 $ 2,040.00 9
$ 175.00 9 $ 1,575.00 10
$ 180.00 7 $ 1,260.00 17
$ 185.00 13 $ 2,405.00 18
$ 190.00 8 $ 1,520.00 12
$ 195.00 7 $ 1,365.00 10
$ 150.00 15 $ 2,250.00 6
$ 200.00 15 $ 3,000.00 12
$ 320.00 15 $ 4,800.00 16
$ 250.00 15 $ 3,750.00 9
$ 480.00 15 $ 7,200.00 17
$ 220.00 15 $ 3,300.00 6
$ 333.00 15 $ 4,995.00 5
$ 500.00 15 $ 7,500.00 0
$ 450.00 15 $ 6,750.00 7
$ 220.00 15 $ 3,300.00 9

ABRIL LIQUIDANO VALERIA MARTINEZ ANDREA CATALAN YAZMIN MELCHOR

$ 4,520.00 $ 5,135.63 $ 4,802.50 $ 5,184.38


$ 4,257.91 $ 4,949.56 $ 4,257.91 $ 4,949.56
$ 262.09 $ 186.07 $ 544.59 $ 234.82
16% 17.92% 16% 17.92%
$ 41.93 $ 33.34 $ 87.13 $ 42.08
$ 341.85 $ 452.55 $ 341.85 $ 452.55
$ 383.78 $ 485.89 $ 428.98 $ 494.63
$ - $ - $ - $ -
$ 383.78 $ 485.89 $ 428.98 $ 494.63
VICTORIA SECRET
NÓMINA CORRESPONDIENTE ALPERIODO: 1 AL 15 DE MARZO

PERCEPCIONES
HRS. EXTS. DOBLES NO. DE HRS EXTS. TRIPLES HRS. EXTS. TRIPLES DIAS PRIMA DOMINICAL

337.5 10 562.5 0
465 11 639.375 1
440 12 720 2
536.25 13 804.375 0
382.5 14 892.5 1
437.5 15 984.375 2
765 16 1080 0
832.5 17 1179.375 1
570 18 1282.5 2
487.5 19 1389.375 0
225 0 0 0
600 3 225 0
1280 1 120 0
562.5 2 187.5 0
2040 3 540 0
330 0 0 2
416.25 0 0 0
0 0 0 0
787.5 0 0 0
495 4 330 0

MILTON SALGADO JUAN MARTINEZ CARLOS HERNANDEZ JOAN ARELLANO

$ 5,355.00 $ 7,608.13 $ 5,557.50 $ 6,264.38


$ 4,949.56 $ 5,925.91 $ 4,949.56 $ 5,925.91
$ 405.44 $ 1,682.22 $ 607.94 $ 338.47
17.92% 21.36% 17.92% 21.36%
$ 72.65 $ 359.32 $ 108.94 $ 72.30
$ 452.55 $ 627.60 $ 452.55 $ 627.60
$ 525.20 $ 986.92 $ 561.49 $ 699.90
$ - $ - $ - $ -
$ 525.20 $ 986.92 $ 561.49 $ 699.90
RZO

PRIMA DOMINICAL DIAS COMPESACION POR DESCANSO OBLIGATORIO

0 0
38.75 1
80 2
0 3
42.5 0
87.5 1
0 2
46.25 3
95 0
0 1
0 0
0 0
0 0
0 0
0 0
110 1
0 0
0 1
0 0
0 1

NAOMI GARCIA EDWIN MEZA

$ 2,475.00 $ 3,825.00
$ 2,422.81 $ 2,422.81
$ 52.19 $ 1,402.19
10.88% 10.88%
$ 5.68 $ 152.56
$ 142.20 $ 142.20
$ 147.88 $ 294.76
$ 160.35 $ -
-$ 12.47 $ 294.76
COMPENSACION POR DESCANSO
DIAS DE VACACIONES PRIMA VACACIONAL DIAS DE AGUINALDO
OBLIGATORIO
0 6 $ 225.00 1
310 8 $ 310.00 2
640 10 $ 400.00 3
990 12 $ 495.00 4
0 14 $ 595.00 5
350 16 $ 700.00 6
720 6 $ 270.00 7
1110 8 $ 370.00 9
0 12 $ 570.00 8
390 14 $ 682.50 10
0 0 $ - 0
0 0 $ - 0
0 0 $ - 0
0 0 $ - 0
0 0 $ - 0
440 0 $ - 0
0 12 $ 999.00 0
1000 0 $ - 15
0 10 $ 1,125.00 0
440 0 $ - 0

ERICK MORALES RODRIGO JIMNEZ GIOVANNA NAZARIO MILTON SALGADO

$ 6,200.00 $ 4,500.00 $ 9,780.00 $ 4,180.00


$ 5,925.91 $ 4,257.91 $ 5,925.91 $ 2,422.81
$ 274.09 $ 242.09 $ 3,854.09 $ 1,757.19
21.36% 16% 21.36% 10.88%
$ 58.55 $ 38.73 $ 823.23 $ 191.18
$ 627.60 $ 341.85 $ 627.60 $ 142.20
$ 686.15 $ 380.58 $ 1,450.83 $ 333.38
$ - $ - $ - $ -
$ 686.15 $ 380.58 $ 1,450.83 $ 333.38
AGUINALDO PERCEPCIONES

$ 150.00 $ 3,525.00
$ 310.00 $ 4,243.13
$ 480.00 $ 4,520.00
$ 660.00 $ 5,135.63
$ 850.00 $ 4,802.50
$ 1,050.00 $ 5,184.38
$ 1,260.00 $ 5,355.00
$ 1,665.00 $ 7,608.13
$ 1,520.00 $ 5,557.50
$ 1,950.00 $ 6,264.38
$ - $ 2,475.00
$ - $ 3,825.00
$ - $ 6,200.00
$ - $ 4,500.00
$ - $ 9,780.00
$ - $ 4,180.00
$ - $ 6,410.25
$ 7,500.00 $ 16,000.00
$ - $ 8,662.50
$ - $ 4,565.00

ELENA CORTEZ NOELY MANRRIQUE JAIR RUDECINDO ANDREA NAVARRETE

$ 6,410.25 $ 16,000.00 $ 8,662.50 $ 4,565.00


$ 5,925.91 $ 11,951.86 $ 5,925.91 $ 4,257.91
$ 484.34 $ 4,048.14 $ 2,736.59 $ 307.09
21.36% 23.52% 21.36% 21.36%
$ 103.46 $ 952.12 $ 584.54 $ 65.59
$ 627.60 $ 1,914.75 $ 627.60 $ 627.60
$ 731.06 $ 2,866.87 $ 1,212.14 $ 693.19
$ - $ - $ - $ -
$ 731.06 $ 2,866.87 $ 1,212.14 $ 693.19

You might also like