I will create a purchase order, supplier tracking and inventory management spreadsheet
Dutch inspired Canva brand kit
About this Gig
Chaotic orders and inventory gaps cost money. Stop juggling paper or mismatched files!
I design a tailored Excel workbook to solve your tracking headaches. Whether you juggle multiple suppliers or need real-time stock levels, you'll get a single dashboard linking Purchase Orders, Supplier Info and Inventory. My spreadsheets organize items into clear categories, track quantities automatically, and highlight when to reorder. Imagine clicking a product and instantly seeing total orders, spent, and remaining stock.
I'm an Excel specialist with years of experience building functional, user-friendly spreadsheets. Your sheet will include: clean tables, dropdowns for suppliers, pivot reports for summary (e.g. monthly spend, low-stock alerts), and visual charts. You can customize categories and formats easily. All formulas and links are documented so you can update it yourself later.
Why choose me?
- Fast delivery and clear communication. Ive helped businesses streamline procurement without expensive software. Youll own the final file and I can guide you on any adjustments.
Ready to save time and avoid stockouts? Click Order now lets build your automated PO & inventory tracker.
Platform:
Excel
•
Google Sheets
•
VBA
Development technology:
VBA
•
Google Apps Script
•
Excel
Expertise:
Formatting
•
Forms
•
Formulas
•
Functions
•
Macros
Other Data Processing Services I Offer
FAQ
What do I get in each package?
Basic: One-sheet tracker (PO form + inventory list) with simple cleanup. Standard: Multiple sheets (POs, inventory, supplier table) plus 2 charts and pivot summary. Premium: Full dashboard, up to 5 POs, 4 charts, polished layout, and automation options (forms/scripts)
Can I use Google Sheets?
Yes. I primarily deliver in Excel, but you can request a Google Sheets version. Formulas and charts work similarly. Premium can include a Google Apps Script for automation if needed.
Are macros or scripts included?
Basic/Standard do not include macros. Premium allows simple automation (e.g. auto-calculations, data import). Complex VBA or macros are extra.
Will it be editable?
Absolutely. You’ll receive a fully unlocked Excel file. Formulas and links are transparent. You can edit categories, add products or change layouts as needed.
What do you need from me?
Provide your product list (names/SKUs), current stock levels, and supplier details (names, prices). Describe any desired reports (e.g. stock report, spending chart) and color/theme preferences.
Can you handle large inventories?
Yes. Even thousands of items can be managed. For large data, I’ll optimize formulas and may use efficient Excel features (tables, filters) to keep things fast.
How many revisions are included?
Basic includes 1 revision, Standard 2, Premium 3. Revisions cover clarifications and small tweaks. Major scope changes would be extra.
Do you provide formulas documentation?
Yes. I include comments or a brief guide on how key formulas work so you can maintain or extend them later.

