I will create an excel inventory tracker with low stock alerts

India

I speak Hindi, English, Tamil

Excel Tracker and Dashboard Builder

I am a B.Com graduate with professional experience in Tally, billing, GST invoicing, sales and purchase entries, stock management, and basic Excel reporting. Along with my accounting experience, I ha...
About this Gig

Do you track your shops stock in a notebook or a messy sheet? I will set up a clean Excel inventory tracker so you can always see what you have, what is running low and what to reorder.

WHAT YOU GET

  • Items sheet to list your products with a reorder level for each
  • Stock In and Stock Out sheets to record every purchase and sale
  • Current stock that updates by itself
  • Automatic status: OK, REORDER or OUT OF STOCK
  • A dashboard with totals and a reorder list
  • Room to add your own columns

WHO IT IS FOR

Small shops, home businesses, online sellers and anyone who handles stock and wants a simple system without paid software.

HOW IT WORKS

Send me your product list and what you would like to track. I will customize the file with your items and categories and send it ready to use, with a short guide on how to enter data.

PLEASE NOTE

This is an Excel template and tracker. It does not connect to billing software or generate invoices.

Message me before ordering if you want something specific added.

Platform:

Excel

Development technology:

Excel

Expertise:

Formulas

•

Dashboard

•

Charts

•

Data validation

My Portfolio