E-commerce Bookkeeping & Pricing Dashboard β Profit & COGS Calculator (Excel & Google Sheets)
Selling online but not sure if you're actually making money? π¦
Between platform cuts, payment fees, shipping, packaging and materials, your "profit" can quietly disappear. This dashboard reveals your TRUE net profit β and tells you exactly what to charge so every product actually pays.
Built for Etsy, Shopify, Amazon and market sellers. Replaces messy notebooks and pricey accounting apps.
ββββββββββ
**WHAT MAKES IT DIFFERENT**
It works like an app, not a spreadsheet. Type only in the coloured cells; every formula is locked. Your Profit & Loss builds itself β zero manual maths.
ββββββββββ
**WHAT'S INSIDE**
β’ Product Pricing & COGS calculator β true cost, break-even & suggested price per item
β’ Profit margin check β green/red so you never sell at a loss again
β’ Income & expense ledger β log sales and costs in seconds (dropdowns included)
β’ Automated P&L dashboard β revenue, COGS, fees, expenses, net profit & margin
β’ Charts: monthly revenue vs expenses, expenses by category, sales by channel
β’ Setup tab for your own categories, channels & tax rate
ββββββββββ
**WHY YOU'LL LOVE IT**
β’ Works in Excel AND Google Sheets
β’ No macros, no subscription, no monthly fees
β’ Locked & protected β impossible to break by accident
β’ One purchase, yours forever + free lifetime updates
ββββββββββ
**PERFECT FOR**
Etsy sellers, Shopify & Amazon sellers, candle/soap/resin/craft makers, print-on-demand and any small product business that wants to finally know its numbers.
ββββββββββ
**HOW IT WORKS**
1. Open in Excel or make your Google Sheets copy.
2. Set your categories, price your products, and log sales & expenses.
3. Watch your Profit & Loss and margins update instantly.
ββββββββββ
**INSTANT DOWNLOAD**
Delivered as a ZIP with the Excel file, a 1-click Google Sheets link, a user guide and a read-me. Nothing is shipped.
ββββββββββ
**NOTE**
For bookkeeping and pricing guidance β not a substitute for professional tax/accounting advice.
Know your numbers. Price with confidence. Keep more of what you earn. π