In Progress

Excel dashboard tool

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.

Skills: Excel, Visual Basic

See more: dashboard tool, free excel dashboard software, free excel dashboard, custom excel dashboard developers, web based excel import tool, excel dashboard macros, excel dashboard free advertising, project information excel dashboard, excel dashboard creator, programing excel dashboard, project status excel dashboard report, excel dashboard dials, crystal excel dashboard, please someone give excel dashboard, dashboard tool linux, excel pricing tool, excel vba tool reference

About the Employer:
( 5 reviews ) jaipur, India

Project ID: #29481313

Awarded to:


Hi I would love to help you with the excel VBA dashboard tool. I'm well versed with Excel VBA/macro, complex formulas, data analysis, data processing, pivot tables, and dashboard. Quality work is my priority. Hope to h More

₹7000 INR in 4 days
(38 Reviews)

12 freelancers are bidding on average ₹1458 for this job


Hi i am an Senior Excel Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating More

₹1500 INR in 1 day
(53 Reviews)

Hi, I would be glad to talk about this project "" with you. I am interested to know more about project. I will Provide you Best quality work with Great Options For 5 years I’ve worked in designing field, I highly val More

₹600 INR in 1 day
(1 Review)

Perhaps you have a project that needs to be completed, but your team either lacks the expertise or the time to do it. . Feel free to customize it to meet your needs! About Us. My self YADUVANSHIRAJIV-In my job as an Ac More

₹600 INR in 1 day
(0 Reviews)

Hello Dear I have read your project and i have understood your project.I have the experience to do this type of project earlier. I have worked many plate form [login to view URL] i have the confident to do this. if you want we c More

₹600 INR in 1 day
(0 Reviews)

please send your project excel.... I will give you your work in 4 days... I am excel expert person...and give any other work

₹1250 INR in 4 days
(0 Reviews)

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..

₹1250 INR in 7 days
(0 Reviews)

Hello, I'm kusum.I have experience of 4 years. I have checked your requirement, yes I can do it, because we already work on similar requirement on past. It will be our great pleasure to work on your project. I have ri More

₹950 INR in 3 days
(0 Reviews)

I am very honest and hard working and want to share my skill and expericend 2-3 months and good in working data entry and exel

₹1050 INR in 7 days
(0 Reviews)

Give me an opportunity to work together. I will deliver this project on time with high efficiency.

₹600 INR in 3 days
(0 Reviews)

i would like to take the project as per my experience in copy typing. i like to work on typing related fields. i assure you full satisfaction after the completion of the project and also assure timely completion of the More

₹1050 INR in 7 days
(0 Reviews)

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.

₹1050 INR in 7 days
(0 Reviews)