Nothing Special   »   [go: up one dir, main page]

Salesactivity Jan

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 7

FromDate : 01/01/2023

ToDate : 31/01/2023
Company : ALL
Salesman : ALL
Route : ALL
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date GrossAmount Discount ClmYesDis SalTaxAmount

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
01/01/2023 77,442.51 100.00 0.00 7,895.76
02/01/2023 955,568.81 450.00 0.00 87,087.31
03/01/2023 2,466,747.80 2,750.00 5,290.00 261,049.79
04/01/2023 3,718,074.45 3,550.00 6,460.00 382,821.12
05/01/2023 4,382,275.18 9,950.00 30,955.00 463,906.78
07/01/2023 3,482,587.43 3,750.00 7,800.00 361,660.46 4
09/01/2023 2,297,749.07 900.00 5,880.00 248,390.97
10/01/2023 2,292,779.08 2,350.00 6,140.00 260,469.86
11/01/2023 2,761,814.76 3,250.00 7,520.00 293,846.80 1
12/01/2023 1,997,260.66 2,200.00 6,260.00 197,201.83 1
13/01/2023 3,008,270.88 6,100.00 11,020.00 314,008.29
14/01/2023 1,869,113.76 1,800.00 5,924.00 190,258.62 4
16/01/2023 1,593,909.61 250.00 9,368.00 147,538.68 4
17/01/2023 2,695,801.94 2,975.00 9,912.00 287,500.01 2
18/01/2023 2,270,493.27 900.00 10,720.00 225,432.25 2
19/01/2023 1,576,959.65 900.00 6,928.00 158,982.66 2
20/01/2023 2,531,161.64 2,850.00 10,864.00 279,607.57 1
21/01/2023 3,456,433.45 13,950.00 14,990.00 355,197.93 2
23/01/2023 2,473,161.16 1,600.00 37,880.00 222,104.98 1
24/01/2023 1,983,837.81 450.00 7,850.00 209,672.49
25/01/2023 2,640,647.15 3,000.00 22,910.00 261,982.06 1
26/01/2023 2,594,249.28 3,600.00 14,300.00 294,367.68 2
27/01/2023 2,811,840.41 3,225.00 42,341.00 285,479.98
28/01/2023 3,275,891.72 4,140.00 75,989.00 328,394.97 1
30/01/2023 5,892,642.54 20,900.00 61,283.98 704,565.80 1
31/01/2023 2,799,886.50 7,500.00 24,225.95 336,281.81
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 67,906,600.52 103,390.00 442,810.93 7,165,706.46
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
User Name SDS
Date 21/02/2023
MIHINDU HOLDINGS (PVT) LTD
Sales Activity Report

-----------------------------------------------------------------
ReturnGross Return Return RtnTaxAmt
Disc ClmYesDis
-----------------------------------------------------------------
4,650.94 0.00 0.00 400.83 72,7
1,386.79 0.00 0.00 180.89 954,1
7,670.74 0.00 0.00 353.10 2,459,0
2,958.90 0.00 0.00 385.94 3,715,1
9,028.13 0.00 0.00 585.00 4,373,2
40,695.97 0.00 0.00 5,308.17 3,441,8
7,231.67 0.00 0.00 126.27 2,290,5
8,199.75 0.00 0.00 514.59 2,284,5
14,056.90 0.00 0.00 1,083.57 2,747,7
15,311.11 0.00 0.00 1,433.11 1,981,9
8,346.65 0.00 0.00 696.39 2,999,9
45,472.12 0.00 0.00 341.80 1,823,6
45,955.22 0.00 0.00 2,521.20 1,547,9
27,243.64 0.00 0.00 2,136.16 2,668,5
29,900.27 0.00 0.00 492.19 2,240,5
23,093.55 0.00 0.00 1,836.66 1,553,8
12,837.15 0.00 0.00 1,394.53 2,518,3
28,815.75 0.00 0.00 1,277.45 3,427,6
11,387.52 0.00 0.00 736.47 2,461,7
1,406.07 0.00 0.00 0.00 1,982,4
18,554.79 0.00 0.00 2,195.32 2,622,0
26,128.32 0.00 0.00 989.20 2,568,1
8,952.22 0.00 0.00 367.08 2,802,8
11,976.82 0.00 0.00 1,457.78 3,263,9
19,758.07 0.00 0.00 2,105.29 5,872,8
0.00 0.00 0.00 0.00 2,799,8
-----------------------------------------------------------------
431,019.06 0.00 0.00 28,918.99 67,475
-----------------------------------------------------------------
Retailer : ALL
Retailer Category Level Value : ALL
Retailer Category Level : ALL
Retailer Value Classification : ALL

Netsales(S-R) MT Cash Cheque Credit


Charge

72,791.58 0.0362300 0.00 0.00 72,791.50


954,182.02 0.5167820 0.00 0.00 954,183.00
2,459,077.06 1.1965260 1,901,065.00 243,330.00 314,686.00
3,715,115.55 1.7356280 0.00 0.00 0.00
4,373,247.05 2.5195600 3,305,884.50 409,238.00 4,373,246.50
3,441,891.46 1.7140670 0.00 0.00 3,441,897.00
2,290,517.40 1.1928970 0.00 0.00 2,290,513.00
2,284,579.33 1.1701170 0.00 0.00 2,284,585.00
2,747,757.86 1.3423400 0.00 0.00 2,747,761.00
1,981,949.55 1.1209650 0.00 0.00 1,987,008.00
2,999,924.23 1.5640390 0.00 0.00 3,001,143.00
1,823,641.64 0.9502240 0.00 0.00 1,858,738.50
1,547,954.40 0.9917510 0.00 0.00 1,543,136.00
2,668,558.30 1.3431080 0.00 0.00 2,668,562.50
2,240,593.00 1.2106330 0.00 0.00 2,240,598.00
1,553,866.11 0.9029500 0.00 0.00 1,553,863.50
2,518,324.49 1.2782770 0.00 0.00 2,518,323.50
3,427,617.70 1.7906910 0.00 0.00 179,171.50
2,461,773.64 1.6975500 2,144,061.50 1,067,843.00 2,461,777.50
1,982,431.74 1.1005800 0.00 0.00 1,982,441.50
2,622,092.36 1.5065650 0.00 0.00 2,622,087.00
2,568,120.96 1.3038970 0.00 0.00 677,609.50
2,802,888.19 1.7413180 1,541,614.00 348,891.00 774,835.00
3,263,914.90 2.1752590 1,617,318.00 410,736.00 7,277.00
5,872,884.47 3.0499270 2,663,621.00 600,300.00 36,686.00 -1
2,799,886.50 1.4162890 3,966,915.00 1,905,991.00 2,799,886.50

67,475,581.49 36.5681700 17,140,479.00 4,986,329.00 45,392,807.50 -2


Over Under
Charge

-12.00 102.00
0.00 1.00
0.00 4.00
-0.50 0.00
-0.50 1.00
-6.50 97.50
-1.00 332.00
0.00 1.00
-2.00 3.00
0.00 0.00
-1.50 1,774.50
-10.50 152.00
-246.00 193.00
-23.50 380.50
-4.50 21.50
-12.00 234.50
-21.50 163.00
-92.00 13.50
-20.00 98.50
-1.50 2.00
-0.50 377.50
-24.50 4.00
-10.50 1.50
-16.00 387.00
-1,905.00 566.50
-14.00 143.50

-2,426.00 5,054.50
Page 1 of 1

You might also like