Build an interactive, shareable, inventory control spreadsheet




Ca Ankit India


AwardedDec 31, 2017
We want to have a simple to use spreadsheet for inventory control that can be used on ipad and android tablet - Google sheets, maybe?

We have around 60 products, which each have from one to six sizes. We purchase the raw product from numerous vendors, and sell within 24 hours. The inventory totals must be updated frequently during the workday. We will have 5,000 to 10,000 items on hand, available for sales to only 2 customers - not to general public.

We need a spreadsheet so that workers can keep track of current inventory, purchase orders pending receipt from vendors, orders from customers pending to fill and ship, and excess stock.

We have started keeping track using a spreadsheet, but this requires physical counts. We use Quickbooks for accounting, but inventory adjustments must be done in the office, not on the work floor, and require exporting to a spreadsheet, and must be formatted to be useful.

Spreadsheet needs to show: 1) pending orders, 2) pending receipts from vendors (purchase orders), 3) stock on hand.

Spreadsheet must be shareable and usable on ipad, android tablet, and windows 10 pc.

Every user must be able to: 1) add inventory, 2) delete inventory (unusable), 3) move inventory from one size to another size.

We use Microsoft Excel.

Skills & Expertise Required

Google Spreadsheets Excel 

Project closed for bidding!

Share this project with your friends

Similar Projects

Google spreadsheet formulas

I would like to link several documents to one mastersheet Google spreasheet. I want to copy only some datas in the master spreasdheet.

I am in a hurry about that. I need to do some more

Hourly, $18.00

Google Sheet/Excel expert needed to...

I'm looking to have one unique health tracking sheet that takes daily totals from two products I use - Oura Ring & Muse 2. These should automatically average the totals at the bottom of the page. It' more

Hourly, $28.00

Virtual Assistant cum Project Manag...

We are seeking a Virtual Assistant:
1) familiar with Facebook page and customer handling
2) familiar with eCommerce platforms order processing and product listing management
3) with some more

Hourly, $14.00

Do Research for partiqular companie...

Find 10 companies in ukraine close to polnish border, who are doing the transpormation of multivans like Volkswagen T5/6 from 'transporter' to 'multivan'. Addionaly collect informations about the more

Hourly, $14.00

Assistant to CEO/Founder + Strategi...

I am the Founder/CEO. Due to growth in my business, I am unable to stay on top of my inbox and customer support.

I'm looking for a long-term work relationship, someone that I can trust more

Hourly, $16.00

Here are our top professional picks for you to hire

Data Analyst /Statistiican
Data Analytics Statistics Statistical Analysis 
$0 /hr
E-commerce Executive
$5 /hr
Software Engineer
PHP Laravel Framework Yii 
$9 /hr
Data Entry, virtual assistant, Customer services and Mechanical Designing.
Data Entry Data Modeling Business Development 
$11 /hr
Quality Analyst
Data Entry Internet Research Microsoft Excel 
$2 /hr
Seeking assignment in content editing, content writing, content formatting and proof reading.
Data Entry MS Office Excel 
$2 /hr
Financial Accounting BookKeeping Accounting 
$17 /hr
Data Analyst
Excel Experts Microsoft Power BI Microsoft Power BI Data Visualization 
$26 /hr
Content Writing 3D Modelling Technical Writing 
$4 /hr
To view more profile join Toogit

Get Started