I will create an inventory spreadsheet in excel and google sheets
Excel and Google Sheets Spreadsheets for Small Businesses
About this Gig
Stop guessing what's on your shelves. I'll set up a clean, easy inventory spreadsheet that tells you what you have, what it's worth and what to reorder.
HOW IT WORKS
You log stock movements (purchases, sales, returns, adjustments). The spreadsheet calculates everything else for you: stock on hand, stock value, margins and status.
WHAT YOU GET
- Dashboard: stock value, items to reorder, out-of-stock, last 30 days sales and gross profit, month-by-month results and a chart
- Products list with automatic status: OK / Reorder / Out of stock
- Reorder list that fills itself, with supplier, suggested quantity and estimated cost
- Drop-down lists, so no typos
- 4 color themes included
WORKS EVERYWHERE
Microsoft Excel (2007 and newer, Windows and Mac), Google Sheets and Apple Numbers. No macros, no add-ons, no monthly subscription. Your data stays yours.
PERFECT FOR
Small shops, Etsy and Shopify sellers, makers, home-based businesses and anyone who has outgrown a simple item list.
Not sure which package fits? Send me a message before ordering. I usually reply within a few hours.
Platform:
Excel
•
Google Sheets
Development technology:
Excel
•
VLOOKUP
Expertise:
Formatting
•
Formulas
•
Dashboard
•
Charts
•
Data validation
My Portfolio
FAQ
Does it work in Google Sheets and on Mac?
Yes. It works in Excel 2007 and newer (Windows and Mac), Google Sheets and Apple Numbers. No macros or add-ons.
Can you load my current product list?
Yes. Standard and Premium include loading your products from your file (Excel, CSV or Google Sheets).
Can it connect to Shopify, Etsy or QuickBooks?
It doesn't sync live. You can paste exported sales into the Stock Movements tab and everything updates.
Is there a monthly fee?
No. It's a one-time purchase and the file is yours.
How many products can it hold?
The file comes with 200 product rows and 1,000 movement rows, and I can expand it on Premium.

