Handmade Seller Profit & Inventory System

KNOW WHAT YOU REALLY MAKE.

WHY THIS ONE

• Everything in one file: real cost per item, suggested price per selling channel, order log, inventory with reorder alerts, expenses and a monthly profit and loss. No add-ons to buy.
• Built for real use: gray cells are the only place you type, and formulas are protected so nothing breaks.
• A Start Here tab walks you through setup in minutes.
• Buy once: no subscription, no app, no monthly fee.

A pricing, profit and inventory system for handmade sellers: candles, jewelry, soap, crochet, prints, woodwork, anything you make. Find out what each product really costs, what to charge on Etsy, your own site or at a craft fair, and what you actually made each month.

WHAT IT DOES

• Materials: what you buy (pack size, pack price), cost per unit, starting stock. ON HAND counts down automatically as you log orders, and the Status says REORDER or OUT.
• Products: materials per item, your time, packaging and overhead give the TOTAL COST per item.
• SUGGESTED PRICE for your target profit margin, after the fees of where you sell it. Type your own price to see its real profit and margin.
• Editable fee table, started for you: Etsy (6.5% transaction + 3% + $0.25 processing + $0.20 listing), Etsy Offsite Ads sales, Shopify, Square in person, and cash sales. Add any other place you sell.
• Orders: one row per sale. Fees (including Etsy's fee on shipping), materials, shipping you paid and profit fill in.
• Etsy import: download Etsy's Order Items file and paste it in. Fees, materials, inventory and monthly profit fill in by themselves, with no retyping.
• Expenses: ads, shop plan, booth fees, tools.
• Monthly Profit: sales, fees, costs and profit for every month, plus alerts for products losing money or below your target margin.
• Overview dashboard: sales, profit, margin, a profit-by-month chart and what needs attention.
• A Start Here tab with step-by-step instructions.

WHAT THIS IS NOT (no surprises)

• Not connected to Etsy or Shopify: you paste Etsy's order file (or type orders) yourself.
• Not tax software and not tax advice: give the yearly totals to your tax preparer.
• Fee rates change: check them on the Channels tab against your own account.

Works In: Google Sheets (free Google account) on a computer or phone, AND Microsoft Excel: a tested Excel version (.xlsx) is included for Excel 365, Excel 2021 or newer, and free Excel for the web.

What You Get: a PDF with a link to make your own copy in your Google Drive, plus a download link for the Excel version. Digital product.

Great for: Etsy Seller Tool, Profit Calculator, Pricing Calculator, Etsy Fee Calculator, Inventory Tracker, Handmade Business, Small Shop Tracker, Craft Fair Pricing, Product Pricing, Seller Spreadsheet, Shop Bookkeeping, Etsy Planner, Google Sheets