Product Profit Tracker
What each order actually made, after fees.
For online sellers who know their revenue but not their profit, because the platform fee, the materials and the shipping all come out in different places.
Product Profit Tracker is a 6-tab Excel and Google Sheets workbook. 1 you type into, 2 calculated from those and 3 you set once. No macros, so it opens without a security warning.
- Dashboard Revenue, fees, cost and profit, calculated from the Orders tab.
- Dashboard (Dark) The same dashboard on a dark background, for screens you actually look at.
- Orders One row per order: date, reference, channel, item, quantity, price each and discount. Room for 500.
Filed under pricing & inventory and bookkeeping & accounting.
5 of the 6 tabs, exactly as they look in the file. Click a tab to look inside.
Sound familiar?
What's inside, tab by tab
You only ever type in the highlighted input cells. Everything else is calculated from what you type.
| Tab | What you do | What it does |
|---|---|---|
| Tab 1Start Here | Set once, never again | A one page setup guide inside the workbook. Enter your basics once, in about 5 to 10 minutes. |
| Tab 2Dashboard | Calculated for you | Revenue, fees, cost and profit, calculated from the Orders tab. |
| Tab 3Dashboard (Dark) | Calculated for you | The same dashboard on a dark background, for screens you actually look at. |
| Tab 4Orders | You type here | One row per order: date, reference, channel, item, quantity, price each and discount. Room for 500. |
| Tab 5Items | Set once, never again | What you sell, set up once: sell price, unit cost, SKU, opening stock and reorder point. |
| Tab 6Settings & Lists | Set once, never again | Channels, fee rates and currency. Change them once and the whole workbook follows. |
Want one quick number first? Three free tools run in your browser, no sign-up: the margin and markup calculator converts margin to markup and prices for a margin after fees, the Etsy fee calculator shows what one sale keeps after Etsy fees, and the break-even calculator finds the sales you need to cover fixed costs.
Good to know
Etsy's 6.5% fee is charged on shipping too
Etsy's 6.5% transaction fee is charged on the shipping you charge as well as the item price, according to Etsy's help page Fees and Taxes for Selling. So offering free shipping by raising the price costs you almost exactly the same fee. The Orders tab works the same way. Each order's revenue is quantity times price, less any discount, plus the shipping the buyer paid, and the transaction fee is taken from that whole amount before your materials and real shipping cost come off.
Built like software, priced like a spreadsheet
Enter your data; totals, flags and the dashboard update instantly.
Checked cell by cell before release. Find one and we will fix it.
Formula cells are protected. You can only type where typing is safe.
Both versions in every purchase. No converting, no broken references.
Clean report pages for your records, your accountant, or your next meeting.
Delivered by Etsy the moment you pay. Free updates to this template forever.
How it works
Secure checkout through Etsy, no account needed here.
The Excel file and the Google Sheets link arrive immediately.
Type into the highlighted cells and every total is calculated from what you typed.
Questions, answered
Do I need a paid Excel version?
Any desktop Excel from 2016 onward works, including Microsoft 365. If you don’t have Excel at all, use the included Google Sheets version. It’s free.
Does it fully work in Google Sheets?
Yes. The Google Sheets version is made from the same file as the Excel one and checked in Google Sheets before release. Every formula uses functions that work the same in both.
Is this a one-time purchase?
Yes. One payment, no subscription. You keep the files forever and get free updates to this template.
What does it not do?
It does not import a CSV, connect to your shop or buy postage. You type your orders in, with the costs your shop does not know about: materials, postage and fees.
What’s the refund policy?
Refunds follow Etsy’s rules for digital downloads. If a template doesn’t work as described, email support@elecart.us and we will fix it.
What if I get stuck?
Email support@elecart.us and the person who built the template answers, usually within one business day. Etsy Messages works too.
How much data can it handle?
Input tabs are sized generously and tested with full sample data: enough for years of typical use. Need more room? Duplicate the file per year, or email support for an extended version.
What each order actually made, after fees.
$2.69, once, 70% off until Nov 28. Yours forever, with free updates.
Get it on Etsy →
