Inventory & Invoice Tracker Spreadsheet | Google Sheets Reseller Template | Small Business Bookkeeping & Sales Tracker

Inventory Tracker Spreadsheet for Google Sheets

Perfect for resellers and small business owners, this all-in-one Inventory Tracker Spreadsheet helps you stay on top of your stock, purchases, suppliers, and sales — all in one easy-to-use Google Sheets file.

Whether you’re managing a growing product catalog or just starting your resale business, this tracker simplifies your inventory management and bookkeeping. The spreadsheet updates automatically as you enter purchases and sales, so you’ll always know your stock levels and reorder needs at a glance.

What’s Included (8 Tabs Total):

✅ Instructions – Step-by-step guide to using the sheet

✅ Set Up – Enter your product categories (auto-linked to dropdowns)

✅ Suppliers – Log supplier contact details (used across the spreadsheet)

✅ Inventory – Add product names, SKUs, categories, and more

✅ Purchases – Track order quantities, suppliers, delivery status, and notes

✅ Sales – Log sales, shipping status, and returns

✅ Sales Dashboard – Auto-generated monthly sales stats by product & category

✅ Stock Dashboard – See what’s out of stock, low stock, or on order

Key Features:

– Built in drop-down menus for faster data entry

– Auto-calculating inventory based on purchases and sales

– Dashboards for quick analysis and decision-making

– Easy to customize for any product-based business

– Works on Google Sheets – no software needed

– Compatible with small, medium, and large reseller businesses

Who It’s For:

– This spreadsheet is perfect for:

– Resellers on Etsy, eBay, Poshmark, Amazon, and more

– Small business owners tracking physical inventory

– Bookkeepers managing stock and sales data

– Anyone who wants a simple, organized inventory system

Not sure if this is the right tool for you? Watch our instructions video here: