| Sr. No. |
Item
Name
(sorting) |
Description
Size - Packaging (will automatically come) |
Per
Unit selling
Price |
Total no of units
sold |
No of Cartons sold |
Total
Sale Price
(no of units x
Per Unit Price) |
Goods returned (no of cartons) |
Goods returned qty (by default it should be "0") |
Date of goods returned
(sorting) |
Goods returned net value (goods returned qty x per unit selling price |
Reson of return |
net cartons sold (after goods returned) |
net qty sold (after goods returned) |
Net
Sale
(net qty sold x
Per Unit Price |
Profit/loss
follow (FIFO - first in first out based on shipping) |
|
| 1. |
Spoon |
20 cms |
12 pcs |
50 (enter manually) |
(enter manually)
|
70/12= 5.83
5 is the whole number, so we take 5 cartons.. Then we do
5 (cartons) x 12 (packaging)
= 60
70 (from left side column)-60=10
This is balance no of loose pieces. |
70 x 50=3,500 |
1 (mannualy enter) |
1 x 12 = 12 (this will also affect stock in hand)
(keep editable) |
select date |
50 x 12 = 600 |
will type mannually |
5-1 = 4 |
Total no of units sold - Goods returned qty
60 - 12= 48
(this will also affect stock in hand) |
50 x 48 = 2400 |
Net sale (-) total Cost price (will come from stock in hand - "Avg cost price as of that date ") |
Delete / Edit |