Inventory & Stock Reports
Stock ledger audit, Goods Received Notes tracking, and returns logs
Stock Live Audit
Stock Value (Cost)
Rs. 684,455.00
Stock Value (Retail)
Rs. 874,085.00
Remaining Stock Qty
2,286 units
Audit Status
19 Discrepancies
Filtered Count
22
Filtered Cost Value
Rs. 684,455.00
| SKU / Code | Product Name | GRN In | Sold Out | Returned | Damaged | Calculated | Remaining Stock | Counted Stock | Variance | Variance Value | Unit Cost | Total Cost Asset |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BGLBG130 |
Lemon Bubble Gum
BUBBLE GUM
|
15 | 7 | 0 | 0 | 8 | 8 |
|
0 | Rs. 0.00 | Rs. 2,340.00 | Rs. 18,720.00 |
| CCDC35 |
Classic Dino Chocolate 35pcs
CHOCOLATE
|
20 | 13 | 0 | 0 | 7 | 6 |
|
0 | Rs. 0.00 | Rs. 2,205.00 | Rs. 15,435.00 |
| CSBC100 |
Super Beans Chocolate 100pcs
CHOCOLATE
|
15 | 12 | 0 | 0 | 3 | 1 |
|
-3 | Rs. -8,100.00 | Rs. 2,700.00 | Rs. 0.00 |
| EDIP |
I Power Energy
DRINKS
|
1528 | 793 | +13 | 0 | 748 | 573 |
|
-728 | Rs. -229,320.00 | Rs. 315.00 | Rs. 6,300.00 |
| ERKE24 |
King Egg 24pcs
EGG RANGE
|
10 | 13 | +2 | 0 | -1 | 1 |
|
+1 | Rs. 4,272.00 | Rs. 4,272.00 | Rs. 0.00 |
| EROE60 |
Owl Egg 60pcs
EGG RANGE
|
10 | 10 | 0 | 0 | 0 | 0 |
|
0 | Rs. 0.00 | Rs. 5,400.00 | Rs. 0.00 |
| EDBCF |
Beauty Collagen Female
ENERGY DRINKS
|
600 | 336 | +9 | 0 | 273 | 252 |
|
+35 | Rs. 11,200.00 | Rs. 320.00 | Rs. 98,560.00 |
| EDBCM |
Beauty Collagen Male
ENERGY DRINKS
|
600 | 322 | +11 | 0 | 289 | 260 |
|
+13 | Rs. 4,160.00 | Rs. 320.00 | Rs. 96,640.00 |
| EDB |
Bocca Energy
ENERGY DRINKS
|
480 | 87 | +2 | 0 | 395 | 388 |
|
+7 | Rs. 2,870.00 | Rs. 410.00 | Rs. 164,820.00 |
| EDR |
Roar Energy
ENERGY DRINKS
|
960 | 353 | +13 | 0 | 620 | 569 |
|
-1 | Rs. -320.00 | Rs. 320.00 | Rs. 198,080.00 |
| LCMT75 |
Milk Toffee 75pcs
LOCAL CONFECTIONERY
|
50 | 46 | 0 | 0 | 4 | 0 |
|
-4 | Rs. -2,360.00 | Rs. 590.00 | Rs. 0.00 |
| LCMS75 |
Murukku Small 75pcs
LOCAL CONFECTIONERY
|
50 | 40 | 0 | 0 | 10 | 0 |
|
-10 | Rs. -5,900.00 | Rs. 590.00 | Rs. 0.00 |
| LCL100 |
Creamy Lollipop 100pcs
LOLLIPOP
|
10 | 9 | 0 | 0 | 1 | 0 |
|
-1 | Rs. -4,500.00 | Rs. 4,500.00 | Rs. 0.00 |
| LHPL50 |
Hop Pop Lollipop 50pcs
LOLLIPOP
|
10 | 1 | 0 | 0 | 9 | 9 |
|
+1 | Rs. 5,350.00 | Rs. 5,350.00 | Rs. 53,500.00 |
| LSL |
Stand Lollipop 60pcs
LOLLIPOP
|
10 | 9 | 0 | 0 | 1 | 1 |
|
+1 | Rs. 5,400.00 | Rs. 5,400.00 | Rs. 10,800.00 |
| EDMC |
Moji Classic
MOJI
|
0 | 77 | 0 | 0 | -77 | 248 |
|
+325 | Rs. 0.00 | Rs. 0.00 | Rs. 0.00 |
| EDMD |
Moji Delight
MOJI
|
0 | 65 | 0 | 0 | -65 | 203 |
|
+268 | Rs. 0.00 | Rs. 0.00 | Rs. 0.00 |
| EDMK |
Moji Kiss
MOJI
|
0 | 72 | 0 | 0 | -72 | 151 |
|
+223 | Rs. 0.00 | Rs. 0.00 | Rs. 0.00 |
| TCR200 |
Candy Rush 200pcs
TOFFEE
|
15 | 8 | 0 | 0 | 7 | 6 |
|
-1 | Rs. -3,600.00 | Rs. 3,600.00 | Rs. 21,600.00 |
| WCCW24 |
Chocopik Crispy Wafer 24pcs
WAFER CHOCOLATE
|
15 | 11 | 0 | 0 | 4 | 3 |
|
-4 | Rs. -12,864.00 | Rs. 3,216.00 | Rs. 0.00 |
| WCHFWS12 |
Happy Finger Wafer Sticks 12pcs
WAFER CHOCOLATE
|
25 | 20 | 0 | 0 | 5 | 2 |
|
-5 | Rs. -5,340.00 | Rs. 1,068.00 | Rs. 0.00 |
| WCPWC24 |
Pochinki Wafer Chocolate
WAFER CHOCOLATE
|
10 | 7 | 0 | 0 | 3 | 1 |
|
-3 | Rs. -9,648.00 | Rs. 3,216.00 | Rs. 0.00 |
| Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Rs. 0.00 | - | Rs. 0.00 | |
Supplier Receipts Log (GRN)
| GRN ID | Ref Number | Supplier Name | Received Date | Payment Method | Unique Items | Total Cost Value | Actions |
|---|---|---|---|---|---|---|---|
| #13 | Shak Tea | 2026-07-07 | Credit | 1 Products | Rs. 315,000.00 | ||
| #12 | 1326 | Ramanathan Vicneswaran | 2026-04-29 | Bank Transfer | 19 Products | Rs. 1,643,340.00 |
Customer Sales Returns
| Return ID | Customer | Sales Rep | Date | Refund Value |
|---|---|---|---|---|
| #6 |
RS BAKERS
Retuned because those are not sold for a month
|
System/Admin | 2026-06-19 19:23 | Rs. 6,370.00 |
| #5 |
CAFE HANSALI
Retuned because those are not sold for a month
|
System/Admin | 2026-06-19 19:07 | Rs. 6,695.00 |
| #4 |
RATIONAL PHARMACY
No notes
|
System/Admin | 2026-06-02 18:16 | Rs. 2,410.00 |
| #3 |
NIMSARA STORES
Rejected
|
System/Admin | 2026-05-18 19:41 | Rs. 3,916.00 |
| #2 |
NIMSARA STORES
Rejected
|
System/Admin | 2026-05-18 19:38 | Rs. 3,916.00 |
Damaged Stock Ledger
| Product SKU | Product Name | Quantity | Loss Valuation | Logged Time |
|---|---|---|---|---|
| No damaged items recorded in ledger | ||||