Reseller Profit Tracker Spreadsheet
Track your sales, fees, and true profit across Poshmark, eBay, Mercari, and more.
If you’re reselling online, you know the feeling: You sell an item… and it feels like you made money.
But after marketplace fees, shipping costs, and the cost of the item itself, it’s surprisingly hard to know what you actually earned.
That’s exactly why I created this Reseller Profit Tracker Spreadsheet.
This simple but powerful spreadsheet helps you track every sale, calculate your true profit, and see how your reselling business is performing over time.
Whether you sell on Poshmark, Mercari, eBay, or multiple platforms, this spreadsheet helps you stay organized and understand your numbers.
What This Spreadsheet Helps You Track
The Reseller Profit Tracker automatically calculates key metrics so you can focus on selling, not doing math.
No more guessing whether a sale was actually profitable.
Track details for every item including:
- Item description
- Platform sold on
- Purchase cost
- Sale price
- Shipping cost
- Marketplace fees
- Total profit
Built-In Reseller Dashboard
The spreadsheet also includes a performance dashboard so you can see how your reselling business is doing at a glance.
The dashboard includes:
- Total yearly revenue
- Total yearly profit
- Current year vs prior year sales comparison
- Monthly sales tracking
- Platform sales breakdown
This makes it easy to understand your business performance without creating your own reports.
This Spreadsheet is Perfect for:
This spreadsheet is ideal for:
- Poshmark sellers
- eBay resellers
- Mercari sellers
- Facebook Marketplace flippers
- Anyone reselling clothing, furniture, or thrifted items
If you sell items online and want to track profit and performance, this spreadsheet will save you time.
Why Track Reselling Profits?
Many resellers track sales… but not profit.
This spreadsheet helps you understand:
- Which items make the most money
- Which platforms perform best
- How your business is growing over time
Once you start tracking these numbers, you’ll be able to make much better sourcing decisions.
Start Tracking Your Reselling Business Today
If you’re serious about reselling, understanding your numbers is one of the best things you can do for your business.
Download the Reseller Profit Tracker Spreadsheet and start tracking your sales, fees, and profit today.
After purchase you’ll receive an instant download of the spreadsheet so you can start tracking your sales immediately.
Inventory Tracker Tab
The Inventory Tracker tab is where you will spend most of your time. This tab feeds into the Dashboards.Â
Only edit the columns in YELLOW.
 First, input you Shop Name & your State Sales Tax in cells C1 & C2. Input the Item Name, Purchased From, Date Listed, and Purchase Price. Column G will automatically calculate the total investment cost (purchase price + sales tax). Â
Next, for “Listed?” input “Y” if you have listed the item on all platforms. I utilize this tool to track if I have purchased an item but not listed it. Â
For column I, input “Y” if sold. Otherwise, leave blank. In column J, input the Platform the item was sold on. Finally, in column K input the Sale Price.Â
For Poshmark, Mercari, or any other platform (ex. Facebook Marketplace), input the fee you were charged. Additionally input any shipping discount you offered as this will reduce your payout / profit.Â
Input the total shipping charged and the total eBay fee you incurred.
If the shipping charged differs from the actual shipping costs, input actual shipping in column P.Â
Finally, input the date sold to calculate total days to sell.Â
Offer Calculator
Once you have filled in the Inventory tab, the Offer Calculator tab can be used! I learned quickly that making and receiving offers is a big part of reselling. I wanted to ensure when I was reviewing offers, that I understand how much profit I would receive. So, I created the Offer Calculator.
This tab has two calculators side by side, in order to compare platforms & offers. For example, sometimes a higher offer with a shipping discount actually results in a lower profit. This tab will show you that.
To get started, navigate to the ‘Fees’ Tab.Â
The Offer Calculator uses this tab to estimate fees you will pay. Marketplace fees change frequently, so the spreadsheet allows you to enter and adjust your own fee percentages.
This means you can quickly update the sheet if platforms change their fee structures.
Each item you entered on the Inventory Tab will have an item number associated with it. To begin, input the Item Number into the top row (cell C10 / F10).Â
Next, Input the Platform you are considering the offer on. Input the Shipping Discount offered or the Shipping the buyer will pay (if applicable).Â
Then, input the Offer Amount. Lastly, for eBay, input estimate sales tax.
eBay uses Sales Tax in their fee calculations. For that reason, the Offer Calculator is only able to calculate an estimate. If you can estimate the sales tax a buyer will pay, input that here. If you are unsure, leave it blank.
 For more details on how eBay fees are calculated, go here!Â
Current Year / Prior Year Revenue Dashboards
The good news for these tabs? They automatically calculate based on inputs from the Inventory Tracker Tab. Both tabs show the same data, one for the current year and one for the prior year.Â
These tabs will automatically update as the year changes. Â
If you are like me, and have to keep all of the data for tax purposes, the PY tab will be your best friend.
Platform Dashboard
This shows a comparison for current year sales across the platforms. This tab is automatically populated. You can input the year you want to compare in the top Fiscal Year box (C2).
Misc. Costs
I have had a number of requests for ways to track misc. business expenses. I created this simple tab where you can input Misc. Business Expenses.Â
This tab will auto calculate total Misc. Costs, total Misc. Costs in Prior Year and total Misc. Costs in the current fiscal year.Â
Please note all spreadsheets offer up to 5,000 line items.Â
See Exactly How Much You're Making
Many resellers underestimate how much fees impact their profit.
This spreadsheet helps you calculate: Sale Price – Cost of Item – Platform Fees – Shipping = True Profit
No more guessing.
Hi! I’ve been following your blog for a while now and finally got the courage to go ahead and give you a shout out from Atascocita Texas! Just wanted to say keep up the fantastic job!
How do you unprotect the spreadsheet?
send us an email! We’ll help :) wellshetriedblog@gmail.com
Enjoyed the post
Hi,
Do you have spreadsheet with all three platforms on it? Poshmark, Mecari and eBay?
Hi! The Poshmark + Ebay has Mecari added in as well! Apologies, I will correct the label on that one :) Hope it helps!!
Hi there, I’m trying to download one of the templates. I put my email in but when I click “download”, it just takes me to a page saying “thanks for joining the crew” but nothing actually downloads :(
Send us an email & we will get a copy emailed to you! (wellshetriedblog@gmail.com)
How do I download the spreadsheet? Can you help?
My email is usersavvy1@gmail.com
Thanks,
Venkata
Will send to you via email!
I don’t know if the people who made this still keep up with this spreadsheet, but I feel like it’s super off with profits from an item. I should be profiting around $13, but it says $18. Anyone know what’s happening?
Hi Taylor! We do keep up with the spreadsheet – why don’t you send it to our email (wellshetriedblog@gmail.com) and we can help you out. Thanks!
Hello,
I am selling on Mercari only right now but the spreadsheets don’t calculate and subtract the seller fees for Mercari, am I doing something wrong?
Hi Taryn! Make sure you are marking the item as sold (i.e. selecting a “y” in the “Sold?” column). The formulas are set up to only calculate once the item sells.. if that doesn’t fix it, send us an email at wellshetriedblog@gmail.com and we’ll help you out! :)
Hello,
Thank you for sharing the inventory spreadsheet, it’s been a great tool!
Recently Poshmark changed their shipping rates to $7.97 which also changes the shipping discount. Can you update the spreadsheet to reflect those changes? Also, Is it possible to have a column for listed date as well as purchase date because most times my purchase date is not the same day I list an item. The ” Days to Sell” column isn’t accurate in my case. For example I purchased an item on January 29th but I did not list it until February 13th and it sold the same day within a few minutes. However, calculating from the purchase date would be 16 days but it really sold same day. Or maybe the purchase date is more for tax purposes?
Thank you in advance!
Hey! Give us an email at wellshetriedblog@gmail.com – if you don’t mind sending your sheet to us we can make those changes for you! We are planning to publish a post walking through how to update the fees / rates since they seem to be forever changing! But in the meantime, happy to make those updates directly in your sheet!
Will do! Sounds good. I’ll send i t over shortly.
Thank you!
When will I receive the spreadsheet I purchased??
Hi Courtney – sent you an email! It should have automatically sent to you but I emailed over a copy! Let me know if you have any other issues!!
Hello!
Appreciate the work you put into this spreadsheet. Thank you! I have the ebay, posh/mercari spreadsheet and the sales analysis page is not calculating correctly, specifically for ebay and the total cost of purchases cell. I just started entering info and I can already see an issue. It has me at $43.31 an the actual total entered so far is $320.49. The spreadsheet is protected, so I cannot do any trouble shooting. Any suggestions?
Also, I may have an old version as the ebay fee was formulated at 12.9%, but I was able to change that easily. I just downloaded this last month.
Thanks,
Juli
Hi Juli – sending you an email! I should be able to help :)!