Excel drop Down List Programming for a Restaurant
$30-250 USD
Paid on delivery
I need to create an Excel spreadsheet for a restaurant to enter invoices. Each invoice could have different accounts on it (food, supplies, chemical, etc.) and there are several invoices each day.
I'm picturing a template for each invoice that uses drop down lists to select which account the product belongs to. You would enter the vendor info, date, invoice number and check number. You would then have 6-8 lines, each with a drop down list, where you could enter your product. So for one invoice, line 1 could be food for $50, line 2 could be supplies for $25 and line 3 could be chemicals for $25. There will be several invoices each day and I need this repeated all 7 days of the week. Each account would have to be totaled on our daily sales report.
I would like to have it set up so that there is only one template displayed on an invoice entry tab and you have the option of adding as many templates as you need. For validation I would like it set up so that you can't add a new template unless the previous one is correctly totaled, meaning if the invoice amount is $100 and you have $110 in product listed it won't let you go ahead without fixing it. The invoice total would have to match the total of the line items.
I have a daily sales report set up and I would like to incorporate this into it. I have attached our current spreadsheet with what I have started. If you look at the Tuesday tab you can see how we're currently entering invoices. The problem is when we have an invoice with multiple accounts you have to enter the info in different areas. Our bookeeper then has to put them all together to book the check.
Project ID: #916795
About the project
Awarded to:
23 freelancers are bidding on average $116 for this job
I build extremely complex spreadsheets for my company. I am an industrial engineer and can develop an effective solution to your problem. I can probably accelerate the schedule to 7 days if needed.
Hi, Ready to start immediately. Committed for long term assignments. Await for your Response ASAP. Thanks,
Hi, I have many experience in excel, i can validate, code in VBA script. So pls give me this project, i will do it with high quality.
Hello, Sir, I am a Experienced Data entry specialist. Have much interest in your project. I had done similar projects .Thanks .
Hi, I am interested in the said project. Looking forward working with you soon. God bless. kind regards, roselyn
I can finish this project in five days, I have background on Accounting and have full knowledge on Excel.
I'm very experience in excel program. Provide me what should I do, you will be excited of my work.
I will create a program that you offer. results will be in accordance with what you have meant. I will send the results on january 23.
I can do this as you need. I can solve the problems effectively using excel programming.
In the field of Accounts for may years now,can do this work daily for you and any other you may request.
