1. Welcome sheet is empty for my use.
2. There are 2 input sheets Seller Input and Main Input. Main input is sheet where i will paste output copied from first sheet merger sheet.
3. seller input is sheet where input given later and work when update button clicked.
4. In seller input in SKU coloum all SKU's will come which are in main Input but not repedatly and Purchase cost will be taken fron here SKU wise and will come in order sheet. same thing with percentage.
5. In order Sheet only two kinds of orders will come,
[login to view URL] order id, order item id,SKU set which only have "Sale" type and doesnt have "return" Type.
[login to view URL] an order id, order item id,SKU set have both sale and return type then we will less the return type QTY from same orders id, order item id,SKU set Sale type QTY if any QTY remains other than "0" ex:1,2,3 in that situation all coloumns amt from sale and return type will get sum and only sale type will come.
6. In returns sheet all those same order id, order item id,SKU set will come which QTY remains "0" according to "5.B" Point. sale and return type both will come.
7. User have to select month or multiple months can be selected from analysis sheet.
8. In Orders sheet only selected month's sale from "buyer invoice date" coloum will come.
9. In orders sheet ITC is "Taxes On Market Fee" from same Orders Sheet.
10. In orders sheet "Paid tax" is sum of Coloums "IGST Amount,CGST Amount,SGST Amount" from same orders sheet.
11. In order sheet "Purchase" will come from SKU wise from input seller sheet and will gets multiplied to QTY of same row.
12. Purchase ITC in order sheet is Percentage amt of Purchase coloum in order sheet sku wise.
13. Receivable coloum in orders sheet is sum of Coloums "H" To "V".
14. Profit coloum in orders sheet is "Receivables Less Paid Tax Less Purchase"
15. In payment sheet will take settlement date coloum and show selected month's or [login to view URL] amt and claim id will not come in return type. claim amt and claim id will come sepratly only if claim id come in selected month setlement id
16. two new types will be added in this excel "topup" and "redeem" they will come in payments sheet only. these "topup" and "redeem" type rows will have settlement id, settlement date,settlement amt. this will show accourding to selected month.
17. Expected price will come of those orders which are in order sheet and selected month but those orders doesnt have settlement id in that condition their cell background will be red and recent received amt of that sku will come there this will be known as expected receivable.
12 фрилансеров(-а) готовы выполнить эту работу в среднем за ₹1458
Hello I have read your work proposal clearly and I understand that what you want. I am experienced in data entry work so I can done your work with full accuracy and minimum time . Thanks..
I have experience & certificate of excel [login to view URL] to your requirements I am ready for [login to view URL] if you believe in me or you think I can do this work so I am prepare to me this work which make me confident.thanks.