I will create an excel inventory tracker with stock and reorder formulas

United States

I speak English

Supplier price lists into usable Excel and CSV

I help small businesses organize supplier product data into usable Excel and CSV files. My focus is preserving product identifiers, keeping source references and flagging unclear values. I use AI-assi...
About this Gig

Know what is in stock and which products need attention. I will customize a simple Excel inventory tracker for one stock location.


$35 includes one XLSX worksheet with capacity for 100 unique products, your business title, agreed column labels, and setup of up to 20 product rows from your clean data. Delivery: 3 days. One revision within the original scope.


Seven formula types: stock on hand, reorder status, reorder gap, stock value per item, product count, reorder count and total stock value. Row formulas are copied across the 100 product rows. Includes editable opening/received/issued quantities, reorder levels and unit costs, conditional highlights and brief instructions.


You enter quantities manually. No live stock sync, transaction ledger, FIFO costing, forecasting, barcode scanning, VBA/macros, store integrations or multiple locations. Please message me before ordering if you need more.


I use AI-assisted tools and check formulas with sample inputs. Gallery data is fictional demonstration work, not client results.

Platform:

Excel

Development technology:

Other

Expertise:

Formatting

•

Formulas

•

Data validation

My Portfolio