I will create a google sheets inventory tracker with an automated dashboard

Philippines

I speak English, Tagalog

Google Sheets and Excel Specialist, Business Dashboards and Automation

I help businesses stay organized and manage data efficiently through practical spreadsheet solutions and administrative support. With experience in project coordination, logistics, and Amazon account ...
About this Gig

Need an easier way to manage your business inventory?


I will create a user-friendly Google Sheets Inventory Tracker designed to help small businesses monitor stock levels, track inventory movements, and stay organized.


WHAT'S INCLUDED:


  • Interactive Dashboard with inventory KPIs and category charts
  • Product Database supporting up to 100 SKUs
  • Stock-In and Stock-Out transaction monitoring
  • Inventory Summary with automatic calculations
  • Real-time available stock and inventory valuation
  • Low Stock and Out-of-Stock alerts
  • Active and Phase-Out product monitoring
  • Reorder level tracking
  • 152 selectable currencies
  • Customizable company name and product categories


KEY FEATURES:


  1. Automated formulas and calculations
  2. Dropdown menus for easier data entry
  3. Automatic product name lookup
  4. Organized inventory records
  5. Easy-to-understand dashboard and reports


CAPACITY:


  • 100 Products / SKUs
  • 1,000 Stock-In transactions
  • 1,000 Stock-Out transactions


PERFECT FOR:


Small businesses, online sellers, retailers, and entrepreneurs who want a simple and organized way to manage their inventory.


Get your inventory under control with a practical Google Sheets solution!

Platform:

Google Sheets

Development technology:

Google Apps Script

Expertise:

Formatting

•

Pivot tables

•

Formulas

•

Functions

•

Dashboard