Inventory management excel sheet, stock management, automated, visualisation -- 4

已完成 已发布的 1 年前 货到付款
已完成 货到付款

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.

PHP 数据处理 数据输入 会计 Excel

项目ID: #35817829

关于项目

45个方案 远程项目 活跃的1 年前

授予:

(0条评论)
0.0

有45名威客正在参与此工作的竞标,均价$30/小时

developersshop

Hi There, Getting on the "Inventory management excel sheet, stock management, automated, visualisation -- 4" first page of Google can be done by implementing Search Engine Optimization (SEO) changes to your website. 更多

$250 USD 在4天内
(150条评论)
6.7
BitLabs

Hello, I have gone through your outsourced requirements " Inventory management excel sheet, stock management, automated, visualisation -- 4 " and have analyzed that I have right skills ( PHP Data Processing Data En 更多

$20 USD 在7天内
(130条评论)
6.8
dheerajjshetty19

Hi, We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on Accounting Please come over chat and discuss your requ 更多

$14 USD 在2天内
(63条评论)
5.6
remuslupinhp

Hi, I understood what you need. Basically for your task, I would suggest one consolidated spreadsheet, with a few columns of product type, purchasing cost, postage cost, abroad postage cost, platform, platform cost a 更多

$50 USD 在7天内
(5条评论)
3.7
AhDardear

Dear, I have reviewed your Excel tool requirements carfully, I believe I am your perfect candidate and it's my pleasure to apply and offer my services. I am a certified data analyst, Tableau and PowerBI developer wi 更多

$100 USD 在7天内
(10条评论)
3.3
AvirupSamanta21

I am a professional data entry operator. I have two years of experience in this field.I am weating for you's every time .I am excited to take your project . And I try to give my best performance. and finished very fir 更多

$11 USD 在4天内
(0条评论)
0.0
huracanence1988

Trabajo Como Programador Con Experiencia Comprovable Actualmente Trabajo Exel full Soluciones De Prblemas data

$20 USD 在7天内
(0条评论)
0.0
mariam610

Hello there I'd love to work on your project immediately. I'm professional in Microsoft Word and Excel. I have 4 years of experience in this matters. Looking forward to hearing from you.

$20USD 在1天里
(0条评论)
0.0
jeanouya

Hello! My name is Jean and I'm an accountant with two years of freshly graduated experience, my speed of learning and my desire for perfection are my greatest assets. I'm waiting for our next interview. Sincerely,

$25 USD 在7天内
(0条评论)
0.0
hbscience2008

Get free sample. I am ready to deliver within 24 hrs. I provide native Arabic translation. Hello I am interested in your project. I have excellent experience of this activity and skills. I will do it with the highest q 更多

$10 USD 在7天内
(0条评论)
0.0
mohamedattia2015

Hi Dear, Hope you’re doing great! I am available to do this job for you. I clearly understand your all job requirements. That's simple and very easy task and I am happy to assist you. I am waiting for your response. T 更多

$20 USD 在3天内
(0条评论)
0.0
emon142250

I'm a good Data entier and I have some experience about this. I am an admission candidate student .

$20 USD 在7天内
(0条评论)
0.0
sofianngrum

This job actually suits with my capability. Because this is my first time, so i don't bud to high but still working my best

$20 USD 在7天内
(0条评论)
0.0
palkashish22

Hi , I am interesting to do the work and be efficient .I would like to try to work as per your requirement and expectation . let me knew about more detail of the project

$28 USD 在7天内
(0条评论)
0.0
Shahfahad0314

Hi sir I am expert in excel and data entry I well do this project very good Thank you

$15 USD 在3天内
(0条评论)
0.0
imanoayroudo

I am an informatics engineer and I have worked with save the children for two years as a data entry and data management of beneficiaries information

$20 USD 在7天内
(0条评论)
0.0
swetajha3009

GREETINGS, As I am a cost and management , I can centralize all streams of income in one excel and can also guide you in cost reduction. I assure you the satisfaction. We can discuss more details in inbox.

$15 USD 在7天内
(0条评论)
0.0
syahidahbaharin

Greeting, hope you have a nice day ahead. I have read your requirement and I have experience in Excel, data entry and data processing. Hope we can work together.

$20 USD 在7天内
(0条评论)
0.0
menfer2012

Manejo (Excel/Macros/VBA), creo sistemas básicos para generar reportes de ventas, basándose en cálculos comparativos, contables y administrativos.

$20 USD 在7天内
(0条评论)
0.0
satyjeetdhawale4

Hi sir, I'm interested in your project. I have done many projects related to your project. I have 2 year experience in Excel. So please contact me I want to know more about your project.

$20 USD 在7天内
(0条评论)
0.0