I will build a custom excel inventory tracker with reorder alerts
Excel and CSV Automation
About this Gig
If you're tracking stock on paper or in a spreadsheet that doesn't calculate anything, I'll build a custom Excel inventory tracker around your product list.
Log what comes in and out, and the workbook automatically calculates current stock and flags items at your reorder point - no macros, no VBA, no add-ins.
WHAT YOU GET
A workbook built around YOUR product list and reorder logic, not a generic template
Formula-only design - works the same on Windows and Mac, no "enable macros" prompt
A short plain-language guide for day-to-day use
HOW I WORK
Built with AI-assisted development (Claude Code) for speed, but I confirm requirements first, design test cases (empty rows, duplicate codes, zero/negative quantities), and check the file before delivery. Built on your data, not copy-pasted.
GOOD TO KNOW
I can work directly from Japanese-language product lists if relevant. Send your product list (even a rough draft) and reorder threshold so I can confirm scope first.
NOT COVERED: barcode/POS integration, real-time multi-system sync, payroll or accounting integration.
Message me your product count and how you track stock, and I'll confirm the right package.
Technology:
Excel
Expertise:
Data manipulation
FAQ
Do I need to enable macros?
No - this is built entirely with formulas, no VBA/macros required.
Can it integrate with a barcode scanner or POS system?
Not in this gig - this is a manual-entry spreadsheet tracker, not a live system integration.
What if I have more SKUs than the Premium limit?
Message me your product count first for a custom quote.
Will it work on Mac?
Yes, the formulas are Mac-compatible; message me your Excel version if you're unsure.
What do you need from me to start?
A product list (even a rough one), your typical reorder threshold, and how you currently track stock - "on paper" is a fine starting point.

