Scribd Logo
Upload

Welcome to Scribd!

  • 10 views

    Tablas Dinamicas

    Uploaded by

    cindy_18ut
    The document is a sales register listing 39 sales transactions between January and December 2012. It includes details like the sale number, date, customer, amount sold, taxes, and payment method. The totals at the bottom sum the sales by month, customer, and payment method. In 2012 there were 39 sales totaling $18,716 in amount sold, $3,369 in taxes, and $22,085 in total sales. The largest customers by total sales were Ponce Rojas Miguel, Suspendores S.A.C., and Color Tech E.I.R.L. The majority of sales were credit sales, with contado or cash sales making up the remainder.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd

    Tablas Dinamicas

    Uploaded by

    cindy_18ut
    10 views6 pages
    The document is a sales register listing 39 sales transactions between January and December 2012. It includes details like the sale number, date, customer, amount sold, taxes, and payment method. The totals at the bottom sum the sales by month, customer, and payment method. In 2012 there were 39 sales totaling $18,716 in amount sold, $3,369 in taxes, and $22,085 in total sales. The largest customers by total sales were Ponce Rojas Miguel, Suspendores S.A.C., and Color Tech E.I.R.L. The majority of sales were credit sales, with contado or cash sales making up the remainder.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document is a sales register listing 39 sales transactions between January and December 2012. It includes details like the sale number, date, customer, amount sold, taxes, and payment method. The totals at the bottom sum the sales by month, customer, and payment method. In 2012 there were 39 sales totaling $18,716 in amount sold, $3,369 in taxes, and $22,085 in total sales. The largest customers by total sales were Ponce Rojas Miguel, Suspendores S.A.C., and Color Tech E.I.R.L. The majority of sales were credit sales, with contado or cash sales making up the remainder.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    10 views6 pages

    Tablas Dinamicas

    Uploaded by

    cindy_18ut
    The document is a sales register listing 39 sales transactions between January and December 2012. It includes details like the sale number, date, customer, amount sold, taxes, and payment method. The totals at the bottom sum the sales by month, customer, and payment method. In 2012 there were 39 sales totaling $18,716 in amount sold, $3,369 in taxes, and $22,085 in total sales. The largest customers by total sales were Ponce Rojas Miguel, Suspendores S.A.C., and Color Tech E.I.R.L. The majority of sales were credit sales, with contado or cash sales making up the remainder.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 6

    REGISTRO DE VENTAS

    N
    0001
    0002
    0003
    0004
    0005
    0006
    0007
    0008
    0009
    0010
    0011
    0012
    0013
    0014
    0015
    0016
    0017
    0018
    0019
    0020
    0021
    0022
    0023
    0024
    0025
    0026
    0027
    0028
    0029
    0030
    0031
    0032
    0033
    0034
    0035
    0036
    0037
    0038
    0039

    F_Emis
    1/2/2012
    1/25/2012
    1/30/2012
    2/5/2012
    2/20/2012
    2/29/2012
    3/2/2012
    3/15/2012
    3/20/2012
    4/1/2012
    4/15/2012
    4/30/2012
    5/2/2012
    5/15/2012
    5/25/2012
    6/2/2012
    2/17/2012
    2/18/2012
    7/1/2012
    7/20/2012
    7/31/2012
    8/1/2012
    8/10/2012
    8/28/2012
    9/1/2012
    9/15/2012
    9/30/2012
    10/1/2012
    10/15/2012
    10/30/2012
    11/5/2012
    11/20/2012
    11/30/2012
    12/1/2012
    12/15/2012
    12/20/2012
    12/22/2012
    12/23/2012
    12/24/2012

    Mes
    Ene
    Ene
    Ene
    Feb
    Feb
    Feb
    Mar
    Mar
    Mar
    Abr
    Abr
    Abr
    May
    May
    May
    Jun
    Jun
    Jun
    Jul
    Jul
    Jul
    Agt
    Agt
    Agt
    Set
    Set
    Set
    Oct
    Oct
    Oct
    Nov
    Nov
    Nov
    Dic
    Dic
    Dic
    Dic
    Dic
    Dic

    N_Fact
    25401
    25402
    25403
    25404
    25405
    25406
    25407
    25408
    25409
    25410
    25411
    25412
    25413
    25414
    25415
    25416
    25417
    25418
    25419
    25420
    25421
    25422
    25423
    25424
    25425
    25426
    25427
    25428
    25429
    25430
    25431
    25432
    25433
    25434
    25435
    25436
    25437
    25438
    25439

    RUC
    20512701001
    20470593301
    15214442431
    20512701001
    20470593301
    15214442431
    20512701001
    15214442431
    20508535601
    20512701001
    20470593301
    15214442431
    20512701001
    20470593301
    15214442431
    20512701001
    20470593301
    15214442431
    20470593301
    15214442431
    20508535601
    15214442431
    20512701001
    20470593301
    20470593301
    15214442431
    20512701001
    20470593301
    15214442431
    20512701001
    20470593301
    15214442431
    20512701001
    20470593301
    15214442431
    20508535601
    15214442431
    20508535601
    20512701001

    Cliente
    COLOR TECH E.I.R.L
    SUSPENSORES S.A.C
    PONCE ROJAS MIGUEL
    COLOR TECH E.I.R.L
    SUSPENSORES S.A.C
    PONCE ROJAS MIGUEL
    COLOR TECH E.I.R.L
    PONCE ROJAS MIGUEL
    METANZA E.I.R.L
    COLOR TECH E.I.R.L
    SUSPENSORES S.A.C
    PONCE ROJAS MIGUEL
    COLOR TECH E.I.R.L
    SUSPENSORES S.A.C
    PONCE ROJAS MIGUEL
    COLOR TECH E.I.R.L
    SUSPENSORES S.A.C
    PONCE ROJAS MIGUEL
    SUSPENSORES S.A.C
    PONCE ROJAS MIGUEL
    METANZA E.I.R.L
    PONCE ROJAS MIGUEL
    COLOR TECH E.I.R.L
    SUSPENSORES S.A.C
    SUSPENSORES S.A.C
    PONCE ROJAS MIGUEL
    COLOR TECH E.I.R.L
    SUSPENSORES S.A.C
    PONCE ROJAS MIGUEL
    COLOR TECH E.I.R.L
    SUSPENSORES S.A.C
    PONCE ROJAS MIGUEL
    COLOR TECH E.I.R.L
    SUSPENSORES S.A.C
    PONCE ROJAS MIGUEL
    METANZA E.I.R.L
    PONCE ROJAS MIGUEL
    METANZA E.I.R.L
    COLOR TECH E.I.R.L
    TOTAL ANUAL S/.

    VV
    271.19
    466.10
    694.92
    457.63
    440.68
    211.86
    423.73
    677.97
    830.51
    652.54
    661.02
    648.31
    754.24
    805.08
    296.61
    381.36
    459.32
    423.73
    338.98
    754.24
    550.85
    198.31
    292.37
    386.44
    480.51
    754.24
    740.68
    648.31
    460.17
    200.85
    464.41
    433.90
    215.25
    207.63
    458.47
    215.25
    218.64
    582.20
    557.63
    18716.13

    IGV
    48.81
    83.90
    125.09
    82.37
    79.32
    38.13
    76.27
    122.03
    149.49
    117.46
    118.98
    116.70
    135.76
    144.91
    53.39
    68.64
    82.68
    76.27
    61.02
    135.76
    99.15
    35.70
    52.63
    69.56
    86.49
    135.76
    133.32
    116.70
    82.83
    36.15
    83.59
    78.10
    38.75
    37.37
    82.52
    38.75
    39.36
    104.80
    100.37
    3368.88

    PV
    320.00
    550.00
    820.00
    540.00
    520.00
    250.00
    500.00
    800.00
    980.00
    770.00
    780.00
    765.00
    890.00
    950.00
    350.00
    450.00
    542.00
    500.00
    400.00
    890.00
    650.00
    234.00
    345.00
    456.00
    567.00
    890.00
    874.00
    765.00
    543.00
    237.00
    548.00
    512.00
    254.00
    245.00
    541.00
    254.00
    258.00
    687.00
    658.00
    22085.00

    C_Venta
    Crdito
    Contado
    Contado
    Contado
    Contado
    Contado
    Contado
    Crdito
    Crdito
    Crdito
    Contado
    Contado
    Contado
    Contado
    Crdito
    Crdito
    Crdito
    Contado
    Contado
    Contado
    Contado
    Crdito
    Crdito
    Crdito
    Crdito
    Contado
    Contado
    Crdito
    Crdito
    Crdito
    Contado
    Contado
    Contado
    Crdito
    Crdito
    Crdito
    Contado
    Contado
    Crdito

    Suma de VV
    RUC
    15214442431
    20470593301
    20508535601
    20512701001
    Total general

    Cliente
    PONCE ROJAS MIGUEL
    SUSPENSORES S.A.C
    METANZA E.I.R.L
    COLOR TECH E.I.R.L

    Mes
    Ene
    Feb
    Mar
    Abr
    May
    694.92 211.86 677.97 648.31 296.61
    466.1 440.68
    661.02 805.08
    830.51
    271.19 457.63 423.73 652.54 754.24
    1432.21 1110.17 1932.21 1961.87 1855.93

    Jun
    Jul
    Oct
    Nov
    Dic
    Agt
    Set
    Total general
    423.73 754.24 460.17
    433.9 677.11 198.31 754.24
    6231.37
    459.32 338.98 648.31 464.41 207.63 386.44 480.51
    5358.48
    550.85
    797.45
    2178.81
    381.36
    200.85 215.25 557.63 292.37 740.68
    4947.47
    1264.41 1644.07 1309.33 1113.56 2239.82 877.12 1975.43
    18716.13

    Suma de PV
    C_Venta
    Contado
    Crdito
    Total general

    Mes
    Ene
    Feb Mar Abr May Jun Jul Oct Nov Dic Agt Set
    1370 1310 500 1545 1840 500 1940
    1314 945
    1764
    320
    1780 770 350 992
    1545
    1698 1035 567
    1690 1310 2280 2315 2190 1492 1940 1545 1314 2643 1035 2331

    Total general
    13028
    9057
    22085

    You might also like