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.
I’m looking for a spreadsheet to keep track of inventory, sales and taxes for reselling on eBay and Facebook Marketplace. On the Pro version, would I be able to use the “Other” tab for FBM? Thank you!
Hi! The “Other” is definitely meant to be a “catch all” for any other platforms needed – however I decided to take a shot at making an eBay + Facebook spreadsheet! I added it to the options for purchase (no pressure for you to do so at all!).
I have never sold on Facebook myself so I created the formulas based on what I could find through google :) If you do decide to try it out and have any issues at all, you can definitely email me (wellshetriedblog@gmail.com) and I’ll make sure I get it right!
Thank you & good luck reselling :)
Rachel
I only sell on Poshmark and Mercari at the time but plan to expand to eBay. Would you recommend purchasing the sheet for all platforms?
Yes! You just wouldn’t fill out the eBay section until you expand sales to there! Also, if you wanted to try the Posh / Mercari Only version for now and decide to expand later, you can send us an email (wellshetriedblog@gmail.com) and I will send you the version with eBay.. only issue here is you’d then have to transfer data over which can be a bit annoying :)
Recently purchased the Reseller Spreadsheet Pro as I was very unhappy with GingerMarvins spreadsheet support.
I am not using Excel but have installed into Google Sheets and Libre Office. I am experiencing lost cells and cells that are not populating. Some cells do not match up with what you have shown in your tutorial.
Can we start a dialog so I can give you more exact information?
Thank you in advance for any help you can offer!
Hi! Send me an email (wellshetriedblog@gmail.com) with the link and I can get it squared away for you!