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 postage all come out in different places.
Product Profit Tracker is a 6-tab Excel and Google Sheets workbook for online sellers who know their revenue but not their profit, because the platform fee, the materials and the postage all come out in different places. 1 you type into, 2 that fill themselves in and 3 you set once. $7.78 once, no subscription.
Filed under pricing & inventory and bookkeeping & accounting.
Type into the highlighted cells, watch every number update itself.
You only ever type in the highlighted input cells, everything else fills itself in.
A one page setup guide inside the workbook. Enter your basics once, five minutes, done.
What you sell, set up once: sell price, unit cost, SKU, opening stock and reorder point.
One row per order: date, reference, channel, item, quantity, price each and discount. Room for 500.
Revenue, fees, cost and profit, calculated from the Orders tab.
The same dashboard on a dark background, for screens you actually look at.
Channels, fee rates and currency. Change them once and the whole workbook follows.
Enter your data; totals, flags and the dashboard update instantly.
Checked cell by cell before release. Find one and you get a fix plus a refund.
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.
Secure checkout through Etsy, no account needed here.
The Excel file and the Google Sheets link arrive immediately.
Type into the highlighted cells, every formula updates itself.
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.
Yes. The Google Sheets version is built natively, not converted: every formula, highlight and protection works the same.
Yes. $7.78 once. You keep the files forever and get free updates to this template.
Digital downloads on Etsy are generally final, but if the template doesn’t work as described and we can’t fix it for you, you get your money back. Just email support@elecart.us.
Email support@elecart.us and the person who built the template answers, usually within one business day. Etsy Messages works too.
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.
$7.78, once, 40% off. Yours forever, with free updates.
Get it on Etsy →