Description
Copy
Stop juggling multiple spreadsheets for your small business. This all-in-one Inventory Tracker & Business Management Spreadsheet puts your products, orders, customers, finances, and pricing in one powerful workbook — with an auto-updating dashboard that gives you a complete picture of your business at a glance.
Designed for Etsy sellers, handmade product creators, resellers, and anyone running a product-based small business.
━━━━━━━━━━━━━━━━━━━━━━━
📦 WHAT’S INSIDE — 12 AUTOMATED TABS
━━━━━━━━━━━━━━━━━━━━━━━
📖 Instructions — Step-by-step setup guide with color legend and navigation links
⚙️ Setup — Enter your business name, currency, tax rate, and customize all categories
📦 Product Inventory — Track finished goods with SKU, quantity, cost, price, and auto stock status
🧵 Raw Materials — Monitor supplies with reorder alerts and supplier info
📋 Order Tracker — Log orders with auto-calculated tax, subtotals, and totals
👥 Customer Database — Build a CRM with contact info, order count, and lifetime spend
💰 Transactions — Full income & expense ledger with running balance
🧮 Price Calculator — Break down material + labor + overhead costs to find your ideal selling price
📄 Invoice Generator — Professional invoice template that pulls your business info automatically
📅 Bill Calendar — Never miss a bill — track recurring expenses with due dates and status
📊 Monthly Report — 12-month P&L summary with Income vs Expenses and Profit Trend charts
📈 Dashboard — 7 KPI cards + 4 auto-updating charts for a complete business overview
━━━━━━━━━━━━━━━━━━━━━━━
✨ KEY FEATURES
━━━━━━━━━━━━━━━━━━━━━━━
✅ Fully automated — Formulas calculate totals, profit margins, tax, and running balances
✅ Auto stock alerts — Color-coded status (🟢 In Stock / 🟡 Low Stock / 🔴 Out of Stock)
✅ 6 dashboard charts — Inventory status, top products, revenue vs expenses, order status, and more
✅ 7 KPI cards — Revenue, expenses, profit, margin, orders, products, and inventory value
✅ 9+ dropdown menus — Consistent data entry for status, categories, and payment methods
✅ Clickable navigation — Purple sidebar on every tab for instant tab-to-tab jumping
✅ Frozen headers — Scroll through data without losing sight of column labels
✅ Pre-filled sample data — See exactly how to use each tab from the moment you open the file
✅ User Guide PDF included — 12-page branded guide with step-by-step instructions and FAQ
━━━━━━━━━━━━━━━━━━━━━━━
🎯 PERFECT FOR
━━━━━━━━━━━━━━━━━━━━━━━
→ Etsy sellers managing handmade products
→ Small business owners tracking inventory and orders
→ Resellers on eBay, Amazon, Shopify, or Poshmark
→ Craft businesses managing raw materials and pricing
→ Freelancers and side-hustlers who need simple bookkeeping
→ Anyone who wants a professional all-in-one business spreadsheet
━━━━━━━━━━━━━━━━━━━━━━━
📂 WHAT YOU’LL RECEIVE
━━━━━━━━━━━━━━━━━━━━━━━
1× Inventory Tracker Spreadsheet (.xlsx file)
1× User Guide PDF (12 pages, full instructions)
━━━━━━━━━━━━━━━━━━━━━━━
💻 COMPATIBILITY
━━━━━━━━━━━━━━━━━━━━━━━
✔ Microsoft Excel (Office 365, 2019, 2021+)
✔ Google Sheets (upload to Drive and open)
✔ WPS Office
✔ Works on Mac, Windows, iPad, and Chromebook
✔ All formulas, charts, dropdowns, and formatting are compatible
━━━━━━━━━━━━━━━━━━━━━━━
🛒 HOW TO USE
━━━━━━━━━━━━━━━━━━━━━━━
1. Purchase and download the .xlsx file instantly
2. Open in Excel or upload to Google Sheets
3. Go to the Setup tab — enter your business name, currency, and tax rate
4. Start adding your products, orders, and transactions
5. Watch your Dashboard and Reports update automatically!
━━━━━━━━━━━━━━━━━━━━━━━
⚠️ PLEASE NOTE: This is a digital download — no physical product will be shipped. All sales are final. If you have any questions or issues, please message us at contact@7fish.org and we’ll be happy to help!
💜 If this spreadsheet helps your business, we’d love a review — it means the world to our small shop!
www.7fish.org | contact@7fish.org
Reviews
There are no reviews yet.