Etsy Seller Spreadsheet Modelo Essentials
Track Etsy shop orders, revenue, fees, and profit. Monitor shop performance with sales data and expense tracking in one place.
O Que Está Incluído
- 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
- Registre ate 150 vendas com data, numero do pedido, produto, quantidade, preco de venda, frete cobrado, taxas do Etsy e custo do produto
- Painel com 6 cartoes de KPI: receita total, lucro total, margem de lucro, total de pedidos, valor medio do pedido e produto mais vendido
- Planilha de Lucratividade por Produto mostrando receita, custo do produto, lucro bruto, margem e unidades vendidas por produto
- Planilha de Vendas Mensais acompanhando receita, pedidos, valor medio do pedido e lucro ao longo de todos os 12 meses com dados de tendencia
- Acompanhamento de Estoque com lista de produtos, unidades em estoque, ponto de reposicao, quantidade de reposicao e indicador de status do estoque
Pré-visualização
Veja o que tem dentro desta planilha
Como Usar Esta Planilha de 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.
Criadas com Claude AI. Aperfeiçoadas por nós.
Usamos Claude AI para criar cada planilha, após uma pesquisa aprofundada. Depois, nossa equipe entra em ação. Refinamos o layout, testamos exaustivamente cada fórmula, corrigimos casos extremos e polimos o design até que pareça algo que nós mesmos usaríamos. A IA nos leva 80% do caminho. Os últimos 20% são puro julgamento humano.
Perguntas Frequentes
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.
Como abrir no Google Sheets?
Envie o arquivo .xlsx para o Google Drive e abra com o Google Sheets. Todas as fórmulas e formatações serão preservadas.
Mais modelos Essentials de Business Finance
Procurando planilhas premium?
Nossas planilhas pagas incluem painéis avançados com várias abas, gráficos nativos do Excel e atualizações contínuas.