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. 684,455.00
Remaining Stock Qty
1,684 units
Audit Status
15 Discrepancies
Filtered Count
19
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 | 6 | 0 | 0 | 9 | 9 |
|
-1 | Rs. -2,340.00 | Rs. 2,340.00 | Rs. 18,720.00 |
| CCDC35 |
Classic Dino Chocolate 35pcs
CHOCOLATE
|
20 | 12 | 0 | 0 | 8 | 7 |
|
-1 | Rs. -2,205.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 |
| ERKE24 |
King Egg 24pcs
EGG RANGE
|
10 | 12 | +2 | 0 | 0 | 2 |
|
0 | Rs. 0.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 | 275 | 0 | 0 | 325 | 315 |
|
-17 | Rs. -5,440.00 | Rs. 320.00 | Rs. 98,560.00 |
| EDBCM |
Beauty Collagen Male
ENERGY DRINKS
|
600 | 274 | +2 | 0 | 328 | 317 |
|
-26 | Rs. -8,320.00 | Rs. 320.00 | Rs. 96,640.00 |
| EDB |
Bocca Energy
ENERGY DRINKS
|
480 | 75 | +2 | 0 | 407 | 397 |
|
-5 | Rs. -2,050.00 | Rs. 410.00 | Rs. 164,820.00 |
| EDIP |
I Power Energy
ENERGY DRINKS
|
528 | 417 | +2 | 0 | 113 | 104 |
|
-93 | Rs. -29,295.00 | Rs. 315.00 | Rs. 6,300.00 |
| EDR |
Roar Energy
ENERGY DRINKS
|
960 | 304 | +1 | 0 | 657 | 654 |
|
-38 | Rs. -12,160.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 | 1 |
|
-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 | 0 | 0 | 0 | 10 | 10 |
|
0 | Rs. 0.00 | Rs. 5,350.00 | Rs. 53,500.00 |
| LSL |
Stand Lollipop 60pcs
LOLLIPOP
|
10 | 8 | 0 | 0 | 2 | 2 |
|
0 | Rs. 0.00 | Rs. 5,400.00 | Rs. 10,800.00 |
| TCR200 |
Candy Rush 200pcs
TOFFEE
|
15 | 7 | 0 | 0 | 8 | 7 |
|
-2 | Rs. -7,200.00 | Rs. 3,600.00 | Rs. 21,600.00 |
| WCCW24 |
Chocopik Crispy Wafer 24pcs
WAFER CHOCOLATE
|
15 | 10 | 0 | 0 | 5 | 4 |
|
-5 | Rs. -16,080.00 | Rs. 3,216.00 | Rs. 0.00 |
| WCHFWS12 |
Happy Finger Wafer Sticks 12pcs
WAFER CHOCOLATE
|
25 | 20 | 0 | 0 | 5 | 1 |
|
-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 |
|---|---|---|---|---|---|---|---|
| #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 |
|---|---|---|---|---|
| #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 | ||||