N FACT NOMBRE EMPLEADO NOMBRE CLIENTE SUCURSAL FECHA HORA

1 JUAN PERES SENA SUR 5-Ene.-2019 8:00:00

2 PEDRO LOPEZ CONFACOR SUR 6-Feb.-2019 9:00:00
3 JOSE MANTINEZ VANIPLAX S.A.S CENTRO 7-Feb.-2019 10:00:00
4 DIEGO PERES PINTUCO S.A.S NORTE 8-Feb.-2019 11:00:00
5 LUISA ORTEGA SENA NORTE 9-Mar.-2019 12:00:00
6 LUIS RAMOS CONFACOR CENTRO 10-Mar.-2019 13:00:00
7 JOSE RAMOS VANIPLAX S.A.S SUR 11-Abr.-2019 14:00:00
8 DIEGO ORTEGA LOS MELLOS S.A.S CENTRO 12-Abr.-2019 15:00:00
9 DIEGO PERES LA ESTACION S.A.S NORTE 13-Abr.-2019 16:00:00
10 LUISA ORTEGA TEXACO NORTE 14-May.-2019 17:00:00
11 LUIS RAMOS TERPEL CENTRO 15-May.-2019 18:00:00
12 JOSE RAMOS VALLEJO S.A.S NORTE 16-Jun.-2019 19:00:00
13 GINA USTA SENA NORTE 17-Jun.-2019 20:00:00
14 DARIO ORTEGA CONFACOR CENTRO 18-Jun.-2019 21:00:00
15 PABLO JARAMILLO VANIPLAX S.A.S SUR 19-Ago.-2019 22:00:00
16 DIEGO PERES CONFACOR CENTRO 20-Ago.-2019 23:00:00
17 LUISA ORTEGA VANIPLAX S.A.S SUR 21-Sep.-2019 0:00:00
18 PEDRO LOPEZ LOS MELLOS S.A.S SUR 22-Sep.-2019 1:00:00
19 JOSE MANTINEZ LA ESTACION S.A.S CENTRO 23-Oct.-2019 2:00:00
20 ROCIO MEDINA SENA NORTE 24-Oct.-2019 3:00:00
VALOR VENTA RETEFUENTE IVA TOTAL PAGAR
575,000 20,125 109,250 664,125
600,000 21,000 114,000 693,000
650,000 22,750 123,500 750,750
680,000 23,800 129,200 785,400
700,000 24,500 133,000 808,500
750,000 26,250 142,500 866,250
770,000 26,950 146,300 889,350
800,000 28,000 152,000 924,000
820,000 28,700 155,800 947,100
980,000 34,300 186,200 1,131,900
1,900,000 66,500 361,000 2,194,500
1,950,000 68,250 370,500 2,252,250
2,890,000 101,150 549,100 3,337,950
3,790,000 132,650 720,100 4,377,450
3,680,000 128,800 699,200 4,250,400
2,550,000 89,250 484,500 2,945,250
4,650,000 162,750 883,500 5,370,750
3,000,000 105,000 570,000 3,465,000
2,970,000 103,950 564,300 3,430,350
4,870,000 170,450 925,300 5,624,850
Suma de TOTAL PAGAR SUCURSAL
NOMBRE EMPLEADO FECHA CENTRO NORTE SUR
DARIO ORTEGA 4,377,450
18-Jun.-2019 4,377,450
GINA USTA 3,337,950
17-Jun.-2019 3,337,950
JOSE RAMOS 2,252,250
11-Abr.-2019
16-Jun.-2019 2,252,250
JUAN PERES 664,125
5-Ene.-2019 664,125
LUISA ORTEGA 1,940,400 5,370,750
14-May.-2019 1,131,900
21-Sep.-2019 5,370,750
9-Mar.-2019 808,500
PABLO JARAMILLO
19-Ago.-2019
Total Result 4,377,450 7,530,600 6,034,875
SUR Total Result
4,377,450
4,377,450
3,337,950
3,337,950
889,350 3,141,600
889,350 889,350
2,252,250
664,125
664,125
7,311,150
1,131,900
5,370,750
808,500
4,250,400 4,250,400
4,250,400 4,250,400
5,139,750 23,082,675
Suma de TOTAL PAGAR SUCURSAL
NOMBRE CLIENTE CENTRO NORTE SUR
CONFACOR 8,188,950
LA ESTACION S.A.S 3,430,350 947,100
LOS MELLOS S.A.S 924,000
PINTUCO S.A.S 785,400
SENA 9,771,300 664,125
TERPEL 2,194,500
TEXACO 1,131,900
VALLEJO S.A.S 2,252,250
VANIPLAX S.A.S 750,750 5,370,750
Total Result 15,488,550 14,887,950 6,034,875
SUR Total Result
693,000 8,881,950
4,377,450
3,465,000 4,389,000
785,400
10,435,425
2,194,500
1,131,900
2,252,250
5,139,750 11,261,250
9,297,750 45,709,125
SUCURSAL - all -

Data
N FACT Suma de VALOR VENTA Suma de RETEFUENTE Suma de IVA
1 575,000 20,125 109,250
2 600,000 21,000 114,000
3 650,000 22,750 123,500
4 680,000 23,800 129,200
5 700,000 24,500 133,000
6 750,000 26,250 142,500
7 770,000 26,950 146,300
8 800,000 28,000 152,000
9 820,000 28,700 155,800
10 980,000 34,300 186,200
11 1,900,000 66,500 361,000
12 1,950,000 68,250 370,500
13 2,890,000 101,150 549,100
14 3,790,000 132,650 720,100
15 3,680,000 128,800 699,200
16 2,550,000 89,250 484,500
17 4,650,000 162,750 883,500
18 3,000,000 105,000 570,000
19 2,970,000 103,950 564,300
20 4,870,000 170,450 925,300
Total Result 39,575,000 1,385,125 7,519,250
 Max Min
Suma de TOTAL PAGAR 5,624,850 664,125
664,125 Promedio
693,000 2,285,456
750,750
785,400
808,500
866,250
889,350
924,000
947,100
1,131,900
2,194,500
2,252,250
3,337,950
4,377,450
4,250,400
2,945,250
5,370,750
3,465,000
3,430,350
5,624,850
45,709,125
FECHA - all -

NOMBRE EMPLEADO Suma de TOTAL PAGAR Conisíon

DARIO ORTEGA 4,377,450 NOCUMPLE
DIEGO ORTEGA 924,000 NOCUMPLE
DIEGO PERES 4,677,750 NOCUMPLE
GINA USTA 3,337,950 NOCUMPLE
JOSE MANTINEZ 4,181,100 NOCUMPLE
JOSE RAMOS 3,141,600 NOCUMPLE
JUAN PERES 664,125 NOCUMPLE
LUIS RAMOS 3,060,750 NOCUMPLE
LUISA ORTEGA 7,311,150 731,115
PABLO JARAMILLO 4,250,400 NOCUMPLE
PEDRO LOPEZ 4,158,000 NOCUMPLE
ROCIO MEDINA 5,624,850 562,485
Total Result 45,709,125 4,570,913
50000000
45,709,125
45,709,12
45000000
Suma de Suma de TOTAL PAGAR Conisíon
40000000
Etiquetas de fila 562,485 731,115 4,570,913
DARIO ORTEGA
35000000 32,773,
DIEGO ORTEGA
30000000
DIEGO PERES
GINA USTA
25000000
JOSE MANTINEZ
20000000
JOSE RAMOS
JUAN PERES
15000000
LUIS RAMOS
10000000
LUISA ORTEGA 7,311,150 ### 7,311,150
4,677,750 5,624,850 5,624,850
4,377,450
PABLO JARAMILLO 4,181,100 4,250,400 4,158,000
5000000 3,337,950 3,141,600 3,060,750
PEDRO LOPEZ 924,000 664,125
0
ROCIO MEDINA EZ
5,624,850 l t
GA GA ES TA OS ES OS GA LL
O
PE
Z
IN
A ra ul
E
TotalRgeneral
T T E
PE R U S
T IN
A M PE R M T E
M
I
LO D
45,709,125
E e ne
R es
O OR O NA AN R
AN RA OR RA O M lg al
TotalO Result O EG GI M SE IS A
5,624,850 JA DR### 45,709,125
IO ta ot
RI EG DI
S E J O J U
LU U I S
O P E O C T o T
DA DI JO L B L R
PA
 45,709,125
45,709,125

NOCUMPLE Total Result

4,377,450
32,773,125 4,377,450
924,000 924,000
4,677,750 4,677,750
3,337,950 3,337,950
Conisíon 562,485
4,181,100 4,181,100
731,115
3,141,600 3,141,600
4,570,913
664,125 664,125
NOCUMPLE
3,060,750 3,060,750
7,311,150 7,311,150
5,624,850 5,624,850
158,000 4,250,400 4,250,400
4,158,000 4,158,000
Z A a l lt 5,624,850
DIN ner e su
E ge lR 45,709,125
M al ta
I O t o
T32,773,125 91,418,250
C To
FECHA - multiple -
Total
SUCURSAL Suma de TOTAL PAGAR
CENTRO 750,750 2,500,000 2,229,150
NORTE 785,400
SUR 693,000 2,000,000
Total Result 2,229,150
1,500,000

1,000,000 750,750 785,400

693,000

500,000

0
CENTRO NORTE SUR Total Result
 Total
2,229,150

Suma de TOTAL PAGAR

693,000

SUR Total Result

NOMBRE EMPLEADO Suma de TOTAL PAGAR Comisión
DARIO ORTEGA 4,377,450 NOCUMPLE 35000000
DIEGO ORTEGA 924,000 NOCUMPLE
30000000
DIEGO PERES 4,677,750 NOCUMPLE
GINA USTA 3,337,950 NOCUMPLE 25000000
JOSE MANTINEZ 4,181,100 NOCUMPLE
20000000
JOSE RAMOS 3,141,600 NOCUMPLE
JUAN PERES 664,125 NOCUMPLE 15000000
LUIS RAMOS 3,060,750 NOCUMPLE
10000000
LUISA ORTEGA 7,311,150 731,115
PABLO JARAMILLO 4,250,400 NOCUMPLE 5000000
PEDRO LOPEZ 4,158,000 NOCUMPLE
0
ROCIO MEDINA 5,624,850 562,485 S
GA GA ERE T
Total Result 45,709,125 4,570,913 RTE RTE P US
O O A
IO GO GIN
R IEGO DIE SE
DA D JO
 Suma de Suma de TOTAL PAGAR
35000000 Comisión
Etiquetas de fila 562,485 731,115 NOCUMPLE Total Result
30000000
DARIO ORTEGA 4,377,450 4,377,450
DIEGO
25000000 ORTEGA 924,000 924,000
DIEGO PERES 4,677,750 4,677,750
20000000
GINA USTA 3,337,950 3,337,950
JOSE MANTINEZ
15000000 4,181,100 4,181,100
Comisión 562,485
JOSE RAMOS 3,141,600 731,115
3,141,600
10000000
JUAN PERES 664,125 NOCUMPLE
664,125
LUIS RAMOS
5000000 3,060,750 3,060,750
LUISA ORTEGA ### 7,311,150
0
PABLO JARAMILLO 4,250,400 4,250,400
GA G A ES STA NEZ O S ES S GA LO EZ N A ult
PEDRO LOPEZ E E ER I R O E IL P I s
e4,158,000 4,158,000
RT ORT O P A
U NT RA
M PE AM ORT AM O L
O ED lR
O IN A E A N R R M ta
ROCIOIOMEDINA O EG G M OS JU IS A 5,624,850
A R O To 5,624,850
A R IEG DI SE J LU LUIS LO J P ED OCI
Total
D ResultD JO B5,624,850 R ### 32,773,125 45,709,125
PA
sión 562,485
115
UMPLE