What does this skill do?

The E-commerce Skill Real Profit Dashboard generates the complete structure of a financial dashboard for online stores, breaking down gross revenue, product costs, shipping, platform fees, advertising, and taxes. It calculates the net profit from each sale and the break-even ROAS by advertising channel, so that entrepreneurs can stop confusing revenue with profit and make scaling decisions based on actual margins.

P&L por Unidad
A step-by-step breakdown from the selling price to the profit per order, after subtracting VAT, COGS, shipping, and payment gateway fees.
Equilibrium ROAS
Calculate the minimum profitable ROAS for Facebook Ads and TikTok Ads so you don't lose money when scaling up your ad budget.
P&L Mensual Completo
A table containing all the lines from the monthly statement, ready to be filled in with actual data from your store.
Key Metrics from the Dashboard
8 key metrics for daily monitoring: orders, net revenue, contribution margin, ROAS by channel, and net income.

Usage examples

🧴 Perfume Store
Create a real profit dashboard for my perfume store: price €45, COGS €12, shipping €6.50, Stripe 1.4% + €0.25, Shopify €29/month + 2%, Facebook €800/month, TikTok €400/month.
🎯 Break-even ROAS
Calculate the break-even ROAS for my Facebook Ads and TikTok Ads campaigns if my contribution margin is 40% of the net price.
📅 P&L mensual Shopify
Genera la estructura de P&L mensual completa para mi tienda Shopify incluyendo tarifas de plataforma, pasarela de pago y tasa de devolución del 5%.
📊 Metrics Dashboard
Design a dashboard in Google Sheets with the 8 key metrics to track the actual profitability of my e-commerce business.

Features

Breakdown by unit P&L paso a paso desde el precio de venta hasta el beneficio neto, restando impuestos, COGS, envío, tarifas y publicidad.
Automatic ROAS Balancing Calculate the minimum profitable ROAS by advertising channel to determine when to scale up without losing money.
P&L mensual estructurado A complete table containing all the lines from the monthly statement, ready to be filled in with actual store data.
Google Sheets Template Tab structure and formulas with autocomplete logic for setting up the panel in a spreadsheet.
8 Essential Metrics Orders, gross revenue, net revenue, contribution margin, advertising spend, ROAS by channel, operating income, and net income.

Frequently asked questions

No. Although the examples use Shopify, the structure works with any e-commerce platform. Just replace the platform and payment gateway fees with your own.
You need your contribution margin per unit (net price minus COGS, shipping, and fees). With that information, the skill automatically calculates the minimum ROAS by advertising channel.
The formulas are compatible with Google Sheets and Excel. The skill provides the tab structure and formulas that you can implement in either tool.
Yes. Replace the placeholders in square brackets in the prompt with your actual costs, rates, and advertising channels, and the AI will generate a customized dashboard.
E-commerce Actual Profit Dashboard — Actual Profitability with Claude AI

¿Prefieres escuchar el contenido? Genera la narración de audio con un clic.