Etsy Seller Spreadsheet Essentials 模板
Track Etsy shop orders, revenue, fees, and profit. Monitor shop performance with sales data and expense tracking in one place.
包含内容
- Dashboard with shop performance metrics showing total orders, gross revenue, total fees, and net profit
- Order log with columns for order date, item name, sale price, shipping collected, and quantity sold per order
- Profit calculation per order subtracting Etsy listing fees, transaction fees, payment processing, and shipping costs
- Fee tracking columns including Etsy listing fee, 6.5% transaction fee, payment processing fee, and advertising costs
- Monthly sales summaries with color-coded input cells (yellow) and auto-calculated profit figures (blue)
- Works in Microsoft Excel, Google Sheets, and LibreOffice Calc with no setup required
Need more from this template?
The Essentials version covers everyday tracking. Ultimate goes further with multi-entity support, scenario analysis, and ultimate-grade reporting.
- Dashboard with shop performance metrics showing total orders, gross revenue, total fees, and net profit
- Order log with columns for order date, item name, sale price, shipping collected, and quantity sold per order
- Profit calculation per order subtracting Etsy listing fees, transaction fees, payment processing, and shipping costs
- Fee tracking columns including Etsy listing fee, 6.5% transaction fee, payment processing fee, and advertising costs
- 记录多达150笔销售，包含日期、订单号、产品、数量、售价、收取的运费、Etsy 费用和销货成本
- 仪表盘包含6个KPI卡片：总收入、总利润、利润率、总订单数、平均订单金额和热销产品
- 产品盈利能力表，显示每个产品的收入、销货成本、毛利润、利润率和已售数量
- 月度销售表，追踪12个月的收入、订单数、平均订单金额和利润，包含趋势数据
- 库存追踪器，包含产品列表、库存数量、再订购点、再订购数量和库存状态标记
预览
查看此模板的内容
如何使用这个Etsy Seller Spreadsheet模板
Log each order
Enter the order date, item name, sale price, shipping collected, and quantity for every Etsy sale.
Enter fees per order
Record the Etsy listing fee, transaction fee, payment processing fee, and any advertising costs for each order.
Add shipping costs
Enter your actual shipping cost per order. The template calculates net profit after all fees and shipping are deducted.
Review shop performance
The dashboard shows total orders, gross revenue, total fees, shipping costs, and net profit for your Etsy shop.
由 Claude AI 构建，经我们精心打磨。
我们使用 Claude AI 在深入研究后起草每个模板。然后由团队接手，优化布局、全面测试每个公式、修复边界情况，并打磨设计，直到达到我们自己愿意使用的标准。AI 完成了 80% 的工作，最后 20% 靠的是人工判断。
常见问题
What Etsy fees does it track?
The template tracks listing fees, the 6.5% transaction fee, payment processing fees, and optional advertising costs. Enter each fee per order.
Does it calculate profit per item?
Yes. Each order row shows revenue minus all fees and shipping to display the net profit for that specific sale.
Can I track material costs?
Add a materials or cost-of-goods column to track what each item costs to make. This gives a true profit figure including production costs.
Does it work for digital products?
Yes. Digital products have no shipping costs, so leave shipping fields blank. The fee calculations work the same way.
如何在 Google Sheets 中打开？
将 .xlsx 文件上传到 Google Drive，然后使用 Google Sheets 打开。所有公式和格式都会保留。