Administration File, in excel or similar:
General info:
I sell products through various ecommerce channels. Website, amazon, bolcom and etsy are the most important.
I would like to get a better overview of my administration by using an extensive excel spreadsheet file with possible macros and graphs.
Please see examples. Overview per platform, per month, numbers. but also costs, shipping costs, platform (sales) costs and purchasing.
These are the most important indicators in my buying/selling process, I have unique products that make marketing costs less than 5% of my turnover. per day, per month, per platform etc I want to see this.
Business info:
I sell felt pennants that are sent around the world by letter post. These are custom made with different designs that I design myself. Think of a football team, and then different designs for each team. I can also have different products per team.(Think of ice hockey pucks, pennants, flags, or metal license plates for example).
I have less than 5 different types of products. Pennants, wall decor license plates, NHL Pucks, NFL helmets, Flags.
Details:
Currently I have 1 overview tab with everything, which gets more and more undoable. I lose a lot of time administrating my deals, stock, and income per platform/product etc. Goal is to automate this more and get a better overview of purchasing costs and postage costs(my 2 biggest costs).
Also to get a better overview per platform and per product in maybe dashboards or simple graphs. Showing per product, per productgroup per month or so.
Solution:
Looking for a solution that can help me centralize all my streams of income (amazon, bolcom, webshop tec.) in 1 excel file and monitor everything here. Get an overview of my purchasing costs, postage costs, income per stream, per product etc. So I can better steer my business to be more effective cost wise and revenue wise.
Can be done in gdocs or excel. Would like to get insights via KPIs or indicators in graphs (like power Bi for example).
If done well there will be more work in the future, hopefully towards a longterm partnership!
Language can be dutch or English.
- See example file
WOULD LIKE TO SEE RELEVANT PROJECT EXAMPLES, RECENT FILES, SCREENSHOTS AND EXAMPLES OF FILES MADE AND ADMINISTRATIONS HELPING TO SETUP. AUTOMATED AS MUCH AS POSSIBLE
Good day, I have read everything & happy to discuss further, as we wanted to ask few questions.
Please click on chat button to discuss further and we can then estimate it accordingly.
For now, ignore the bid amount, as we still need to discuss thru' chat & finalize the scope of work.
Look forward to hearing from you thru' chat.
Regards,
Yasir
LEADconcept
"""""""""""""""""'EXCEL INVENTORY SHEET""""""""""""""""""
"Sir,
I am an Excel Advanced Level Expert. This is basic work for me. I can complete this project with added quality.
About me
I am a Chartered Accountant with more than 4 years of experience from the worlds leading Accountancy and auditing firm ""PWC"". I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. It is my Sixth month here and I have 115+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates.
Note. The price is negotiable.
I will be available for any query round the clock even if the project is completed.
Regards
Arman Kakar "
Hello there
Iam Excel expert level with top rating done projects before I can done this within short time also i can provide previous samples for make you understanding better about me and my skills.
When do you need this finished? I understand how annoying it is and can get this fixed for you quickly! Please see the sample I fixed. I look forward to working on this project with you.
Regards
ILYAS
Hi Hope you are doing good,
I can perfectly help you with that in quick turnaround.
I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project.
Kind Regards
Arun
Hello:
After reading in detail the requirements of your project and concluding that they match my areas of knowledge and skills, I would like to introduce myself.
My name is Anthony Muñoz and I am the lead engineer for DS Pro IT agency. I have worked for over 10 years in Backend and software development and have successfully done multiple jobs on this and other Freelance platforms. It will be a pleasure to work together to make your project a reality.
Please feel free to contact me. I´m looking forward to working with you. I really appreciate your time and remain attentive to any request or question.
Greetings
Dear Client, Yes, I see your requirement & I can do it same as per your required in excel format. Can you share with me your file! Let's do start and share with me more information as soon as possible.
hey
i have read your discription and i have a need job and i have a best experience on your profession data entry excel
and i have a best perfamance
regards..
Sattar A.
my name is mosin yaseen. I have studied your job description with full concentration and come to knw that you need a virtual assistant to asset your job with some requirement you have mentioned in your description .I would like to apply myself for the vacant post as i have possessed the qualities .it would be great experience if you pick me for your job with full trust. Thank you
Hi There,
I am a data entry professional and having experience of more than 10yrs. I have read your details carefully. I can assist you on this project. If you hire me I will not disappoint you.
Many thanks,
i am able to do this ,acctually i have experience on store management and workshop management also worked with the billing area where i have also handel the full billing part along with all payment types like cash or card.
am really very excited tp do this work. I want you to give this work to me so that i can express my self properly.I assure you that am not gonna disappoint you in any manner so trust me and rather that it's your decision so decide .
thankyou
Honestly, I possess all the skills and experience that you're looking for. I'm pretty confident that I am the best candidate for this job role. It's not just my background in the past projects, but also my people skills, which will be applicable in this position
Looking forward to a challenging position in a large and reputable company where my potentials can be invested to the full extent. Besides I'm willing to share broad teamwork based on sound planning & creativity especially in projects management under time constraint in a highly professional way with modern techniques.
HII, I’M AN ENTHUSIASTIC DATA ENTRY SPECIALIST. I CAN INPUT DATA WITH ACCURACY IN A REASONABLE DELIVERY TIME.
I CAN DO ANY KIND OF DATA ENTRY MAY BE IT IS PDF TO WORD/EXCEL OR COLLECTION OF DATA FROM ANY SITE FOLLOWED BY FILLING THE SPREADSHEET. I CAN ALSO TRANSFER DATA FROM ONE WEBSITE TO ANOTHER AS PER YOUR INSTRUCTIONS.
I AM A DEDICATED AND FULL-TIME FREELANCING IS MY PROFESSION. AWARD ME THIS PROJECT SO THAT I CAN IMMEDIATELY START TO WORK.
BEST REGARDS,
Hello! I didn`t see no example file to this project, but i have experience with such needs. I work as Executive assistant and tasks like yours is what i do all the time. Chat me and i ll send you screeshots. Have a nice day!
Well, I have experience in working with different editing apps most importantly Excel worksheet, Microsoft word document and Power point. I can create micro and graphs in all of this editing sites within a short period of time. I can also operate on google docs and i am very fluent in English that is why I think I am the most suitable candidate for this job. Thank you.
I am proficient in excel, and i have experience of 15 years in supply cgain management.
I am worink on excel since last 15 years.
So i can complete this project.
I am working as merchandiser and stock manager with a export company since last 5 years. I have done inventory management work and satisfied the clients. i have also done cost budget analysis of various products in my company. Currently i am looking for a work form home. I can provide you with sample work analysis of your sale based on e-commerce platform. I also segregate your cost sheet according to sales based on each platform. I will make it in excel in such a way that it will by provide data in next period automatically. I am assure you that your administrative burden will release and you can focus solely on sales. Waiting for your positive response.
I have previous experience working with projects that had similar problems to yours. I also have excellent communication skills and further technical knowledge that would be an asset to your company. The mix of technical and team skills I bring to the table make me an ideal fit for this role.