excel templets

i need a excel template with microcs or formulas and look ups in different ways

as i do small retail buisenss of online business with snap deal i am not abel to understand the account so need a simple excel temp let to compare my sales paymets ,returns and pending payments .

>> example -1 {sales }i sheet i have ten suborder ids of sales ,

>> no 2{ returnes} ,in that 3 have being returned to me in rto or issue case

>> no 3 {payments }in this i got the payments for 4 products

>> no 4 {pending payments } which i have to recive the payments

>> So I would like u to make such a easy templets. Which can. Help u and Us to understand the account

>> If I update all the slp or suporder coder and update the sales then automatically. Every thing should be done. Example

>> If I write slp or suborder code in returns then all it should. Make in sales as red Colour and rest should pending payments should Being shown. In the pending payment panel and. Pending payments panels

>> Same as. If I updates of suborder. Of the payments in the payment panel then it should calculate all and then. It should change the colour of paid amount should turn to yellow in the sales panel Rest same as above I mean should be shows in sales. And Payment and pending payments should be showed

>> in the pending. Of returns and. Payments

>> If I want to check. What is pending then I need to open only one that is pending. It will show me clearly what is pending similarly all. But. In the sales panel total account should be their. From starting to end to track in further if required

AND MAIN THING EVERY PANEL SHOULD HAVE. TH COMMISSION . INSURANCE AND ALL OTHER. TAXES SERVICE CHAGES. THAT WILL BE VERY TRANSPARENT TO UNDERSTAND.

IF U CAN MAKE THIS I WILL BE VERY THANKFUL TO U.

THANKS IN ADVANCE.

>>

Excel Microsoft Office Modèles Shopify Modèles

Nº du projet : #8478673

À propos du projet