Scribd
Upload
14 views6 pages

Current Stock and Sales Report

The document summarizes the current stock of 20 items with their item codes, descriptions, prices, quantities of inward and outward stock movements, and current stock levels. It shows a total inward quantity of 8500 and a total outward quantity of 5275. Purchase and sale details are also provided with invoice numbers, dates, item codes, descriptions, prices, and totals.

Uploaded by

mahamunir68888
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
14 views6 pages

Current Stock and Sales Report

The document summarizes the current stock of 20 items with their item codes, descriptions, prices, quantities of inward and outward stock movements, and current stock levels. It shows a total inward quantity of 8500 and a total outward quantity of 5275. Purchase and sale details are also provided with invoice numbers, dates, item codes, descriptions, prices, and totals.

Uploaded by

mahamunir68888
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

Current Stock Report

Master Detail
Sr. No. Item Code Description Price Inward Outward Current
1 101 Gents Perfume 100 10 5 5
2 102 Ladies Perfume 200 0 0 0
3 103 Babies Diapers 300 5 0 5
4 104 Cosmetics 500 0 0 0
5 105 Spray 600 10 8 2
6
7
8
106
107
108
700
840
966
0
0
0
0
0
0
0
0
0
Purch
9 109 100 0 0 0
10
11
12
110
111
112
1200
1400
100
0
0
0
0
0
5
0
0
-5
Sale
13 113 500 0 0 0
14 114 300 0 0 0
15 115 400 0 0 0
16 116 600 0 0 0
17 117 500 0 0 0
18 118 400 0 0 0
19 119 600 0 0 0
20 120 800 0 0 0
Total Inward
8500

Total Outward
5275

Purchase
Sale
Sr. No Purchase Invoice No. Date Item Code Description Price
1 123 1/1/2020 101 Gents Perfume 100
2 25463 2/2/2020 105 Spray 600
3 103 Babies Diapers 300
4 104 Cosmetics 500
5
6
7
8
9
10
11
12
13
14
15
16
17
Total

Return to Stock
Sheet
Column1 Qty Value
10 1000
10 6000
5 1500

8500
Sr. No Sale Invoice No. Date Item Code Description Price Sale Price
1 123 1/1/2020 101 Gents Perfume 100 95
2 25463 2/2/2020 105 Spray 600 550
3 112 0 100 80
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Total

Return to Stock
Sheet
Qty Value
5 475
8 4400
5 400
0
0
0
0
0
0
0
0
0
0
0
0
0
0
5275

You might also like