Etsy Seller Spreadsheet | Excel + Google Sheets | Order Tracker, Inventory, Pricing and Profit Dashboard

🧵 Run the making side and the money side of your handmade business from one connected workbook. Handmade Business HQ helps Etsy sellers, makers and small product businesses track orders, materials, finished stock, product costs, pricing, invoices, income, expenses and tasks in one calm place.

Add an order once and the workbook helps you see what needs shipping, what stock is moving, what needs reordering and how your business is performing. Sample GBP data is included so you can see the system working before replacing it with your own.

📚 WHAT'S INSIDE (16 connected tabs)
📍 Start Here - quick setup guide and clear workbook map
📊 Business Dashboard - live KPIs, orders to ship, revenue, profit, stock and monthly charts
🛍️ Order Tracker - customer, channel, payment, totals and ship-by dates in one place
📦 Order Items - keep every product line and quantity linked to its order
🗓️ Order Calendar - see the month at a glance and highlight upcoming shipping dates
🧶 Materials Inventory - track raw materials, on-hand levels, reorder points and stock value
📋 Product Inventory - keep finished products, prices and available stock together
🧾 Recipe & Unit Cost - build each product from materials and labour
🔗 Recipe Lines - add and edit the ingredients behind each product recipe
💷 Pricing Calculator - compare cost, fees, profit margin and recommended selling price
👥 Customers - keep customer details and order history organised
🧾 Invoice Generator - select an order and create a clean one-page invoice automatically
💳 Money Log - record sales and business costs in one simple ledger
📈 Profit Summary - view monthly income, expenses, profit, margin and channel mix
✅ Task Tracker - stay on top of priority, status, due dates and days left
⚙️ Settings - edit your business details, pricing defaults and dropdown lists

✨ WHY YOU'LL LOVE IT
• Designed for handmade businesses, Etsy sellers, market sellers and product-based side hustles
• Track raw materials and finished products side by side
• Build your own recipes, include labour and fees, then see a recommended price
• Keep every order, payment status and ship-by date visible
• Create an invoice from an existing order without retyping the details
• Use the dashboard to see revenue, profit, open orders, tasks and low stock at a glance
• Works in Microsoft Excel and can be uploaded to Google Sheets
• Every tab is fully editable, with sample data and built-in dropdowns to make setup easier

📥 WHAT YOU GET
• 1 Excel workbook (.xlsx), fully formatted with formulas, dashboards and charts
• 16 connected, buyer-editable tabs for orders, inventory, pricing, invoicing, profit and tasks
• GBP sample data that you can replace with your own figures and currency
• Instant digital download, use it year after year as your business grows

📥 HOW IT WORKS
1. Buy and download the workbook instantly.
2. Open it in Excel or upload it to Google Sheets.
3. Update Settings with your business details, then add your own orders, materials, products and costs.
4. Watch the dashboard, stock values, pricing and profit views update as you work.

⚠️ PLEASE READ BEFORE BUYING
• This is a digital product. No physical item will be shipped.
• You will need Microsoft Excel or a free Google account for Google Sheets.
• This workbook is a business organisation tool, not financial, accounting or tax advice.
• Sample figures are shown in GBP (£) and can be edited to suit your business.
• For personal business use only. This template cannot be resold, shared or redistributed.
• Due to the digital nature of this product, all sales are final. If anything is not working, message me and I will gladly help.

🌐 More spreadsheets and planners at sagepennystudio.com
© For personal use only. Please do not share, resell or redistribute these files.
💬 Questions? Send me a message any time, I am happy to help.