| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | DATE | PRODUCT ID | QUANTITY | SALE TYPE | PAYMENT MODE | DISCOUNT % | PRODUCT | CATEGORY | UOM | BUYING PRIZE | SELLING PRICE | TOTAL BUYING VALUE | TOTAL SELLING VALUE | DAY | MONTH | YEAR | ||||||||||
2 | 1/1/2021 | P0024 | 9 | Wholesaler | Online | 0.0% | Product24 | Category03 | Ft | $144.00 | $156.96 | $1,296.00 | $1,412.64 | 1 | Jan | 2021 | ||||||||||
3 | 1/2/2021 | P0038 | 15 | Online | Cash | 0.0% | Product38 | Category05 | Kg | $72.00 | $79.92 | $1,080.00 | $1,198.80 | 2 | Jan | 2021 | ||||||||||
4 | 1/2/2021 | P0013 | 6 | Direct Sales | Cash | 0.0% | Product13 | Category02 | Kg | $112.00 | $122.08 | $672.00 | $732.48 | 2 | Jan | 2021 | ||||||||||
5 | 1/3/2021 | P0004 | 5 | Direct Sales | Online | 0.0% | Product04 | Category01 | Lt | $44.00 | $48.84 | $220.00 | $244.20 | 3 | Jan | 2021 | ||||||||||
6 | 1/4/2021 | P0035 | 12 | Online | Online | 0.0% | Product35 | Category04 | No. | $5.00 | $6.70 | $60.00 | $80.40 | 4 | Jan | 2021 | ||||||||||
7 | 1/9/2021 | P0031 | 1 | Direct Sales | Cash | 0.0% | Product31 | Category04 | Kg | $93.00 | $104.16 | $93.00 | $104.16 | 9 | Jan | 2021 | ||||||||||
8 | 1/9/2021 | P0003 | 8 | Direct Sales | Cash | 0.0% | Product03 | Category01 | Kg | $71.00 | $80.94 | $568.00 | $647.52 | 9 | Jan | 2021 | ||||||||||
9 | 1/9/2021 | P0025 | 4 | Direct Sales | Online | 0.0% | Product25 | Category03 | No. | $7.00 | $8.33 | $28.00 | $33.32 | 9 | Jan | 2021 | ||||||||||
10 | 1/11/2021 | P0037 | 3 | Direct Sales | Cash | 0.0% | Product37 | Category05 | Kg | $67.00 | $85.76 | $201.00 | $257.28 | 11 | Jan | 2021 | ||||||||||
11 | 1/11/2021 | P0014 | 4 | Wholesaler | Online | 0.0% | Product14 | Category02 | Kg | $112.00 | $146.72 | $448.00 | $586.88 | 11 | Jan | 2021 | ||||||||||
12 | 1/11/2021 | P0042 | 4 | Direct Sales | Online | 0.0% | Product42 | Category05 | Ft | $120.00 | $162.00 | $480.00 | $648.00 | 11 | Jan | 2021 | ||||||||||
13 | 1/12/2021 | P0042 | 10 | Online | Cash | 0.0% | Product42 | Category05 | Ft | $120.00 | $162.00 | $1,200.00 | $1,620.00 | 12 | Jan | 2021 | ||||||||||
14 | 1/18/2021 | P0044 | 13 | Direct Sales | Online | 0.0% | Product44 | Category05 | Kg | $76.00 | $82.08 | $988.00 | $1,067.04 | 18 | Jan | 2021 | ||||||||||
15 | 1/18/2021 | P0023 | 3 | Online | Cash | 0.0% | Product23 | Category03 | Ft | $141.00 | $149.46 | $423.00 | $448.38 | 18 | Jan | 2021 | ||||||||||
16 | 1/19/2021 | P0035 | 6 | Direct Sales | Cash | 0.0% | Product35 | Category04 | No. | $5.00 | $6.70 | $30.00 | $40.20 | 19 | Jan | 2021 | ||||||||||
17 | 1/20/2021 | P0034 | 4 | Direct Sales | Cash | 0.0% | Product34 | Category04 | Lt | $55.00 | $58.30 | $220.00 | $233.20 | 20 | Jan | 2021 | ||||||||||
18 | 1/20/2021 | P0020 | 4 | Direct Sales | Cash | 0.0% | Product20 | Category03 | Lt | $61.00 | $76.25 | $244.00 | $305.00 | 20 | Jan | 2021 | ||||||||||
19 | 1/21/2021 | P0004 | 15 | Wholesaler | Cash | 0.0% | Product04 | Category01 | Lt | $44.00 | $48.84 | $660.00 | $732.60 | 21 | Jan | 2021 | ||||||||||
20 | 1/21/2021 | P0003 | 9 | Direct Sales | Online | 0.0% | Product03 | Category01 | Kg | $71.00 | $80.94 | $639.00 | $728.46 | 21 | Jan | 2021 | ||||||||||
21 | 1/21/2021 | P0042 | 6 | Direct Sales | Online | 0.0% | Product42 | Category05 | Ft | $120.00 | $162.00 | $720.00 | $972.00 | 21 | Jan | 2021 | ||||||||||
22 | 1/25/2021 | P0034 | 6 | Direct Sales | Cash | 0.0% | Product34 | Category04 | Lt | $55.00 | $58.30 | $330.00 | $349.80 | 25 | Jan | 2021 | ||||||||||
23 | 1/25/2021 | P0035 | 7 | Direct Sales | Online | 0.0% | Product35 | Category04 | No. | $5.00 | $6.70 | $35.00 | $46.90 | 25 | Jan | 2021 | ||||||||||
24 | 1/25/2021 | P0031 | 14 | Direct Sales | Online | 0.0% | Product31 | Category04 | Kg | $93.00 | $104.16 | $1,302.00 | $1,458.24 | 25 | Jan | 2021 | ||||||||||
25 | 1/26/2021 | P0044 | 9 | Wholesaler | Cash | 0.0% | Product44 | Category05 | Kg | $76.00 | $82.08 | $684.00 | $738.72 | 26 | Jan | 2021 | ||||||||||
26 | 1/26/2021 | P0006 | 7 | Online | Cash | 0.0% | Product06 | Category01 | Kg | $75.00 | $85.50 | $525.00 | $598.50 | 26 | Jan | 2021 | ||||||||||
27 | 1/26/2021 | P0001 | 7 | Online | Online | 0.0% | Product01 | Category01 | Kg | $98.00 | $103.88 | $686.00 | $727.16 | 26 | Jan | 2021 | ||||||||||
28 | 1/27/2021 | P0040 | 7 | Wholesaler | Online | 0.0% | Product40 | Category05 | Kg | $90.00 | $115.20 | $630.00 | $806.40 | 27 | Jan | 2021 | ||||||||||
29 | 1/27/2021 | P0032 | 3 | Wholesaler | Online | 0.0% | Product32 | Category04 | Kg | $89.00 | $117.48 | $267.00 | $352.44 | 27 | Jan | 2021 | ||||||||||
30 | 1/28/2021 | P0004 | 10 | Online | Cash | 0.0% | Product04 | Category01 | Lt | $44.00 | $48.84 | $440.00 | $488.40 | 28 | Jan | 2021 | ||||||||||
31 | 1/28/2021 | P0029 | 2 | Direct Sales | Cash | 0.0% | Product29 | Category04 | Lt | $47.00 | $53.11 | $94.00 | $106.22 | 28 | Jan | 2021 | ||||||||||
32 | 2/2/2021 | P0010 | 7 | Online | Online | 0.0% | Product10 | Category02 | Ft | $148.00 | $164.28 | $1,036.00 | $1,149.96 | 2 | Feb | 2021 | ||||||||||
33 | 2/3/2021 | P0016 | 13 | Direct Sales | Online | 0.0% | Product16 | Category02 | No. | $13.00 | $16.64 | $169.00 | $216.32 | 3 | Feb | 2021 | ||||||||||
34 | 2/3/2021 | P0022 | 2 | Wholesaler | Cash | 0.0% | Product22 | Category03 | Ft | $121.00 | $141.57 | $242.00 | $283.14 | 3 | Feb | 2021 | ||||||||||
35 | 2/4/2021 | P0037 | 4 | Online | Online | 0.0% | Product37 | Category05 | Kg | $67.00 | $85.76 | $268.00 | $343.04 | 4 | Feb | 2021 | ||||||||||
36 | 2/5/2021 | P0043 | 7 | Online | Cash | 0.0% | Product43 | Category05 | Kg | $67.00 | $83.08 | $469.00 | $581.56 | 5 | Feb | 2021 | ||||||||||
37 | 2/5/2021 | P0005 | 1 | Direct Sales | Cash | 0.0% | Product05 | Category01 | Ft | $133.00 | $155.61 | $133.00 | $155.61 | 5 | Feb | 2021 | ||||||||||
38 | 2/5/2021 | P0043 | 9 | Direct Sales | Cash | 0.0% | Product43 | Category05 | Kg | $67.00 | $83.08 | $603.00 | $747.72 | 5 | Feb | 2021 | ||||||||||
39 | 2/6/2021 | P0035 | 1 | Direct Sales | Cash | 0.0% | Product35 | Category04 | No. | $5.00 | $6.70 | $5.00 | $6.70 | 6 | Feb | 2021 | ||||||||||
40 | 2/9/2021 | P0034 | 14 | Direct Sales | Online | 0.0% | Product34 | Category04 | Lt | $55.00 | $58.30 | $770.00 | $816.20 | 9 | Feb | 2021 | ||||||||||
41 | 2/12/2021 | P0008 | 7 | Direct Sales | Cash | 0.0% | Product08 | Category01 | Kg | $83.00 | $94.62 | $581.00 | $662.34 | 12 | Feb | 2021 | ||||||||||
42 | 2/12/2021 | P0023 | 9 | Online | Cash | 0.0% | Product23 | Category03 | Ft | $141.00 | $149.46 | $1,269.00 | $1,345.14 | 12 | Feb | 2021 | ||||||||||
43 | 2/15/2021 | P0027 | 4 | Direct Sales | Online | 0.0% | Product27 | Category04 | Lt | $48.00 | $57.12 | $192.00 | $228.48 | 15 | Feb | 2021 | ||||||||||
44 | 2/18/2021 | P0015 | 6 | Online | Cash | 0.0% | Product15 | Category02 | No. | $12.00 | $15.72 | $72.00 | $94.32 | 18 | Feb | 2021 | ||||||||||
45 | 2/20/2021 | P0030 | 11 | Online | Cash | 0.0% | Product30 | Category04 | Ft | $148.00 | $201.28 | $1,628.00 | $2,214.08 | 20 | Feb | 2021 | ||||||||||
46 | 2/22/2021 | P0013 | 5 | Online | Cash | 0.0% | Product13 | Category02 | Kg | $112.00 | $122.08 | $560.00 | $610.40 | 22 | Feb | 2021 | ||||||||||
47 | 2/23/2021 | P0025 | 3 | Direct Sales | Cash | 0.0% | Product25 | Category03 | No. | $7.00 | $8.33 | $21.00 | $24.99 | 23 | Feb | 2021 | ||||||||||
48 | 2/23/2021 | P0005 | 2 | Direct Sales | Online | 0.0% | Product05 | Category01 | Ft | $133.00 | $155.61 | $266.00 | $311.22 | 23 | Feb | 2021 | ||||||||||
49 | 2/25/2021 | P0002 | 4 | Wholesaler | Online | 0.0% | Product02 | Category01 | Kg | $105.00 | $142.80 | $420.00 | $571.20 | 25 | Feb | 2021 | ||||||||||
50 | 2/25/2021 | P0032 | 11 | Online | Cash | 0.0% | Product32 | Category04 | Kg | $89.00 | $117.48 | $979.00 | $1,292.28 | 25 | Feb | 2021 | ||||||||||
51 | 2/25/2021 | P0030 | 2 | Direct Sales | Online | 0.0% | Product30 | Category04 | Ft | $148.00 | $201.28 | $296.00 | $402.56 | 25 | Feb | 2021 | ||||||||||
52 | 2/27/2021 | P0018 | 11 | Wholesaler | Online | 0.0% | Product18 | Category02 | No. | $37.00 | $49.21 | $407.00 | $541.31 | 27 | Feb | 2021 | ||||||||||
53 | 3/3/2021 | P0011 | 1 | Direct Sales | Online | 0.0% | Product11 | Category02 | Lt | $44.00 | $48.40 | $44.00 | $48.40 | 3 | Mar | 2021 | ||||||||||
54 | 3/7/2021 | P0021 | 9 | Direct Sales | Cash | 0.0% | Product21 | Category03 | Ft | $126.00 | $162.54 | $1,134.00 | $1,462.86 | 7 | Mar | 2021 | ||||||||||
55 | 3/8/2021 | P0027 | 6 | Online | Cash | 0.0% | Product27 | Category04 | Lt | $48.00 | $57.12 | $288.00 | $342.72 | 8 | Mar | 2021 | ||||||||||
56 | 3/8/2021 | P0044 | 9 | Online | Online | 0.0% | Product44 | Category05 | Kg | $76.00 | $82.08 | $684.00 | $738.72 | 8 | Mar | 2021 | ||||||||||
57 | 3/9/2021 | P0029 | 6 | Wholesaler | Online | 0.0% | Product29 | Category04 | Lt | $47.00 | $53.11 | $282.00 | $318.66 | 9 | Mar | 2021 | ||||||||||
58 | 3/11/2021 | P0025 | 11 | Direct Sales | Cash | 0.0% | Product25 | Category03 | No. | $7.00 | $8.33 | $77.00 | $91.63 | 11 | Mar | 2021 | ||||||||||
59 | 3/13/2021 | P0028 | 10 | Wholesaler | Cash | 0.0% | Product28 | Category04 | No. | $37.00 | $41.81 | $370.00 | $418.10 | 13 | Mar | 2021 | ||||||||||
60 | 3/15/2021 | P0039 | 11 | Online | Cash | 0.0% | Product39 | Category05 | No. | $37.00 | $42.55 | $407.00 | $468.05 | 15 | Mar | 2021 | ||||||||||
61 | 3/16/2021 | P0012 | 14 | Direct Sales | Cash | 0.0% | Product12 | Category02 | Kg | $73.00 | $94.17 | $1,022.00 | $1,318.38 | 16 | Mar | 2021 | ||||||||||
62 | 3/18/2021 | P0042 | 8 | Wholesaler | Cash | 0.0% | Product42 | Category05 | Ft | $120.00 | $162.00 | $960.00 | $1,296.00 | 18 | Mar | 2021 | ||||||||||
63 | 3/19/2021 | P0028 | 9 | Online | Cash | 0.0% | Product28 | Category04 | No. | $37.00 | $41.81 | $333.00 | $376.29 | 19 | Mar | 2021 | ||||||||||
64 | 3/21/2021 | P0020 | 13 | Online | Online | 0.0% | Product20 | Category03 | Lt | $61.00 | $76.25 | $793.00 | $991.25 | 21 | Mar | 2021 | ||||||||||
65 | 3/21/2021 | P0039 | 7 | Direct Sales | Online | 0.0% | Product39 | Category05 | No. | $37.00 | $42.55 | $259.00 | $297.85 | 21 | Mar | 2021 | ||||||||||
66 | 3/22/2021 | P0002 | 8 | Online | Online | 0.0% | Product02 | Category01 | Kg | $105.00 | $142.80 | $840.00 | $1,142.40 | 22 | Mar | 2021 | ||||||||||
67 | 3/22/2021 | P0012 | 4 | Online | Online | 0.0% | Product12 | Category02 | Kg | $73.00 | $94.17 | $292.00 | $376.68 | 22 | Mar | 2021 | ||||||||||
68 | 3/25/2021 | P0024 | 14 | Online | Cash | 0.0% | Product24 | Category03 | Ft | $144.00 | $156.96 | $2,016.00 | $2,197.44 | 25 | Mar | 2021 | ||||||||||
69 | 3/25/2021 | P0006 | 4 | Direct Sales | Cash | 0.0% | Product06 | Category01 | Kg | $75.00 | $85.50 | $300.00 | $342.00 | 25 | Mar | 2021 | ||||||||||
70 | 3/25/2021 | P0029 | 8 | Direct Sales | Cash | 0.0% | Product29 | Category04 | Lt | $47.00 | $53.11 | $376.00 | $424.88 | 25 | Mar | 2021 | ||||||||||
71 | 3/25/2021 | P0038 | 2 | Direct Sales | Online | 0.0% | Product38 | Category05 | Kg | $72.00 | $79.92 | $144.00 | $159.84 | 25 | Mar | 2021 | ||||||||||
72 | 3/26/2021 | P0001 | 4 | Direct Sales | Cash | 0.0% | Product01 | Category01 | Kg | $98.00 | $103.88 | $392.00 | $415.52 | 26 | Mar | 2021 | ||||||||||
73 | 3/26/2021 | P0042 | 1 | Direct Sales | Cash | 0.0% | Product42 | Category05 | Ft | $120.00 | $162.00 | $120.00 | $162.00 | 26 | Mar | 2021 | ||||||||||
74 | 3/26/2021 | P0010 | 9 | Direct Sales | Online | 0.0% | Product10 | Category02 | Ft | $148.00 | $164.28 | $1,332.00 | $1,478.52 | 26 | Mar | 2021 | ||||||||||
75 | 3/27/2021 | P0030 | 3 | Direct Sales | Online | 0.0% | Product30 | Category04 | Ft | $148.00 | $201.28 | $444.00 | $603.84 | 27 | Mar | 2021 | ||||||||||
76 | 3/28/2021 | P0007 | 8 | Online | Cash | 0.0% | Product07 | Category01 | Lt | $43.00 | $47.73 | $344.00 | $381.84 | 28 | Mar | 2021 | ||||||||||
77 | 3/30/2021 | P0038 | 1 | Online | Cash | 0.0% | Product38 | Category05 | Kg | $72.00 | $79.92 | $72.00 | $79.92 | 30 | Mar | 2021 | ||||||||||
78 | 3/31/2021 | P0042 | 3 | Direct Sales | Cash | 0.0% | Product42 | Category05 | Ft | $120.00 | $162.00 | $360.00 | $486.00 | 31 | Mar | 2021 | ||||||||||
79 | 4/4/2021 | P0040 | 4 | Direct Sales | Cash | 0.0% | Product40 | Category05 | Kg | $90.00 | $115.20 | $360.00 | $460.80 | 4 | Apr | 2021 | ||||||||||
80 | 4/4/2021 | P0009 | 9 | Online | Cash | 0.0% | Product09 | Category01 | No. | $6.00 | $7.86 | $54.00 | $70.74 | 4 | Apr | 2021 | ||||||||||
81 | 4/5/2021 | P0031 | 15 | Online | Online | 0.0% | Product31 | Category04 | Kg | $93.00 | $104.16 | $1,395.00 | $1,562.40 | 5 | Apr | 2021 | ||||||||||
82 | 4/9/2021 | P0005 | 3 | Online | Online | 0.0% | Product05 | Category01 | Ft | $133.00 | $155.61 | $399.00 | $466.83 | 9 | Apr | 2021 | ||||||||||
83 | 4/10/2021 | P0022 | 14 | Direct Sales | Online | 0.0% | Product22 | Category03 | Ft | $121.00 | $141.57 | $1,694.00 | $1,981.98 | 10 | Apr | 2021 | ||||||||||
84 | 4/12/2021 | P0037 | 3 | Direct Sales | Cash | 0.0% | Product37 | Category05 | Kg | $67.00 | $85.76 | $201.00 | $257.28 | 12 | Apr | 2021 | ||||||||||
85 | 4/12/2021 | P0029 | 4 | Direct Sales | Online | 0.0% | Product29 | Category04 | Lt | $47.00 | $53.11 | $188.00 | $212.44 | 12 | Apr | 2021 | ||||||||||
86 | 4/12/2021 | P0027 | 9 | Direct Sales | Online | 0.0% | Product27 | Category04 | Lt | $48.00 | $57.12 | $432.00 | $514.08 | 12 | Apr | 2021 | ||||||||||
87 | 4/12/2021 | P0033 | 13 | Direct Sales | Cash | 0.0% | Product33 | Category04 | Kg | $95.00 | $119.70 | $1,235.00 | $1,556.10 | 12 | Apr | 2021 | ||||||||||
88 | 4/15/2021 | P0017 | 3 | Direct Sales | Online | 0.0% | Product17 | Category02 | Ft | $134.00 | $156.78 | $402.00 | $470.34 | 15 | Apr | 2021 | ||||||||||
89 | 4/16/2021 | P0018 | 15 | Direct Sales | Cash | 0.0% | Product18 | Category02 | No. | $37.00 | $49.21 | $555.00 | $738.15 | 16 | Apr | 2021 | ||||||||||
90 | 4/18/2021 | P0038 | 9 | Wholesaler | Online | 0.0% | Product38 | Category05 | Kg | $72.00 | $79.92 | $648.00 | $719.28 | 18 | Apr | 2021 | ||||||||||
91 | 4/18/2021 | P0019 | 13 | Direct Sales | Cash | 0.0% | Product19 | Category02 | Ft | $150.00 | $210.00 | $1,950.00 | $2,730.00 | 18 | Apr | 2021 | ||||||||||
92 | 4/23/2021 | P0042 | 6 | Direct Sales | Online | 0.0% | Product42 | Category05 | Ft | $120.00 | $162.00 | $720.00 | $972.00 | 23 | Apr | 2021 | ||||||||||
93 | 4/23/2021 | P0028 | 10 | Direct Sales | Online | 0.0% | Product28 | Category04 | No. | $37.00 | $41.81 | $370.00 | $418.10 | 23 | Apr | 2021 | ||||||||||
94 | 4/24/2021 | P0030 | 2 | Online | Online | 0.0% | Product30 | Category04 | Ft | $148.00 | $201.28 | $296.00 | $402.56 | 24 | Apr | 2021 | ||||||||||
95 | 4/26/2021 | P0037 | 3 | Direct Sales | Online | 0.0% | Product37 | Category05 | Kg | $67.00 | $85.76 | $201.00 | $257.28 | 26 | Apr | 2021 | ||||||||||
96 | 4/29/2021 | P0030 | 7 | Direct Sales | Online | 0.0% | Product30 | Category04 | Ft | $148.00 | $201.28 | $1,036.00 | $1,408.96 | 29 | Apr | 2021 | ||||||||||
97 | 4/30/2021 | P0029 | 1 | Direct Sales | Online | 0.0% | Product29 | Category04 | Lt | $47.00 | $53.11 | $47.00 | $53.11 | 30 | Apr | 2021 | ||||||||||
98 | 5/1/2021 | P0018 | 3 | Online | Cash | 0.0% | Product18 | Category02 | No. | $37.00 | $49.21 | $111.00 | $147.63 | 1 | May | 2021 | ||||||||||
99 | 5/1/2021 | P0042 | 1 | Online | Cash | 0.0% | Product42 | Category05 | Ft | $120.00 | $162.00 | $120.00 | $162.00 | 1 | May | 2021 | ||||||||||
100 | 5/3/2021 | P0034 | 3 | Online | Online | 0.0% | Product34 | Category04 | Lt | $55.00 | $58.30 | $165.00 | $174.90 | 3 | May | 2021 |