Fermé

very simple stock system in excel

I am looking for a really simple stock management system. Nothing complex at all – this is what we do on paper which we need converting to excel. Needs to look like a Windows package with a load of drop down boxes.

1. Date stock arrived, who owns the stock (we have several customers), description of the stock, Image of the stock (optional), cost of the stock, quantity of the stock, location of the stock (we have 100 bays where we store stock so, if a member of staff needs to find a stock item, they should be able to input the description and the system will tell them where it is). When we enter a product we don’t want to add a retail price as many items are sold on ebay and we will never know what they sell for.

2. We should be able to search on product code, description, stock type (sofa, table, chest etc etc – we are a furniture company) or similar. It should be able to find items on the database if we don’t know the full product code – ie – if we search on table belonging to customer A – it should show all tables they have in stock so we can select the one we are looking for.

3. When we sell a stock item – we need to be able to put a buyers reference (ie name and address, telephone number, ebay name), what sold and how much it sold for. We need to be able to add the delivery element. For instance an items sells for £50 with £20 delivery – the invoice should show £70. We will need to report on delivery separate from furniture – see below.

4. When an items sells – we also have to record payment type (cash, cheque, paypal, credit/debit card, transfer)

5. When we sell an item – we have a few processes before its finished. IE – when an item sells it goes into pending until its paid, once paid it moves to processing, when its delivered it goes into completed. I need to be able to move live orders through the process

6. When an item books in – we need to show the item as Paid For or On Account – we have to be able to select from a dropdown list – the account name we owe for the stock. We can set all of these up manually.

7. We also have a delivery company – when we have a delivery job where there is no stock involved – we have to be able to create an invoice for the that and report on it.

8. There are items we sell for other people where we get 25% of te selling price and 100% of the delivery fee. I need to be able to show this and it needs to be separate from the general sales as otherwise it will reduce my margin. The delivery element will go to the delivery report though.

Reports

These are a sample of the reports we need top product

1. Value and quantity of all stock in warehouse

2. Value and quantity of stock per customer

3. Value and quantity of stock per type

4. Sales per date range

5. Sales per customer

6. Graphs to show stock levels broken down per customer

7. Graphs to show sales broken down per product type

8. Run a payment report so we can analysise how people pay

9. We should be able to search on jobs in pending and processing – it should show us customer names, postcodes, product types and tel numbers.

10. 10. Report on people we owe for stock – see 7 above.

11. Show the revenue for delivery see section 8 above.

12. We need to be able to backup to a flash drive at the touch of a button.

13. Once backed up – I would like to take the flash home and update the system I will be running at home.

14. Whenever invoices are produced we should be able to select print or pdf. When we print we need to be asked how many copies we need.

15. I need a running GP%, stock figure per customer, sales per month showing on the front screen so I can always track the performance

the best process is to adapt an ebay [package you already have. i will need to add stock to see if it will work in my business.

Compétences : Saisie de Données, Excel

Voir plus : stock card excel, stock card sample excel, stock system excel, sample stock card excel, excel stock system, simple stock system excel, excel stock card, simple stock system, stock card excel sample, simple stock card sample excel, excel system stock account, excel stock database, simple stock database excel, simple stock excel, create stock card excel, excel product stock system, simple stock management system excel, stock card system excel, simple excel system, work in retail, work home data entry no fee, work from no home system, work from home type jobs, work from home sales jobs, work from home retail jobs

Concernant l'employeur :
( 2 commentaires ) stockton, United Kingdom

N° du projet : #2365106

18 freelance ont fait une offre moyenne de 145 £ pour ce travail

SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

250 £ GBP en 7 jours
(23 Commentaires)
5.5
Teloquence

Consider it done. Check your PM for my bid details.

250 £ GBP en 4 jours
(49 Commentaires)
5.2
NSExpert

Hi. I can get this done for you with excellence. Ready to start. Thanks Neha

75 £ GBP en 7 jours
(17 Commentaires)
5.2
binaryromel

##### Excel expert here! Please check PM. #####

220 £ GBP en 5 jours
(42 Commentaires)
5.1
MDavidCrompton

Hi, I have worked on conversion, manipulation and analysis of Excel for 30 years and have completed several freelancer projects, PLEASE CHECK FEEDBACK. Example in PM. I am UK based, on GMT time, available on skype and Plus

200 £ GBP en 14 jours
(23 Commentaires)
4.9
srinichal

Ready to discuss more details

250 £ GBP en 5 jours
(10 Commentaires)
4.7
naveenvarthaan

Hi, I already did a similar project for ROCKBOTTOMRETIAL UK. Its a kind of stock management tool. I have attached the file. Please give a trial at it and I will modify it with all features you expect. Waiting Plus

100 £ GBP en 3 jours
(13 Commentaires)
4.2
Rampage4Services

Hi, I'm interested in working on this project. I have a strong experience working on excel and have created a few such reports and tools using Excel in my professional work as well as for other freelance custo Plus

250 £ GBP en 10 jours
(2 Commentaires)
3.5
Naumaan

Please check the details in PM

20 £ GBP en 1 jour
(6 Commentaires)
3.4
rohitpithisaria

HI I WOULD LIKE TO APPLY FOR THE JOB POSTED BY YOU. THANKS YOU ROHIT

125 £ GBP en 7 jours
(5 Commentaires)
3.3
premiumjobs001r

more details

250 £ GBP en 10 jours
(0 Commentaires)
0.0
devsupport22

I have done many similar projects in my professional career

60 £ GBP en 5 jours
(0 Commentaires)
0.0
sureshbabur

I have 10+ years of experience in building Utility tools using Excel vba and Access. So kindly do consider me for this project. I am ready work for this.

100 £ GBP en 3 jours
(0 Commentaires)
0.0
pareshpaul234

I intend to perform such suitable kind of job which I like best. I am sure to accomplish accurately. With Regards.

75 £ GBP en 3 jours
(0 Commentaires)
0.0
masifnawaz

Dear Sir, I have all the solutions you require. I have 7+ years experience of Computer applications. I guess that I am very much suitable person for this job. I can show you my previous work if Plus

100 £ GBP en 3 jours
(1 Commentaire)
0.0
meghavilekar26

New freelancer, have 19 years experience / sound knowledge of excel.

30 £ GBP en 7 jours
(0 Commentaires)
0.0
yveakp

Hello. I am interested by this job.

180 £ GBP en 10 jours
(0 Commentaires)
0.0
mtchinthaka

Dear Sir, Did similar projects. please check PMB.

75 £ GBP en 7 jours
(0 Commentaires)
0.0