Poshmark, eBay & Mercari Reseller Inventory Spreadsheet
UPDATE: This post has been updated to include Mercari & a Misc Costs Tab!
After almost two years of selling on Poshmark, I have realized how important a Reseller Inventory Spreadsheet is! I have also begun to feel more confident as a seller and decided to branch out to selling on eBay! If you’ve sold on eBbay before, you know the nuances of the shipping costs & how their fees are calculated, but I’ll talk more about that later!
This is a very detailed post on how to use the inventory tracker sheet I created! To get the most out of this post, it would be best for you to first download the spreadsheet. You can do that here!
The first tab I will walk you through is the ‘Inventory Tracker’ tab of my excel file. Inventory management is a requirement in any reseller spreadsheet to run your business! I put in dummy data just to show how it will look and flow through.
The first step is to fill in the top section to the left. First, input your shop name. The only input that impacts the actual tracker is the sales tax. At first I wasn’t factoring this into my profit analysis and realized I should have been! Simply input the state you are purchasing your items for resale in cell C3 and this will populate the total investment column F.
When filling out the actual tracker section, input the item, where it was purchased, when it was purchased and the price paid! The formula will automatically calculate the total plus sales tax.
The only columns that require your input are in BLUE!
After the item is input into the sheet, you can track if it’s been listed on eBay and Poshmark and if it has sold. Once it has sold, input the Platform it sold on in Column J and the sale price into the in Column K.
If your item sold on Poshmark, Column L will automatically calculate the Poshmark fee. Input any shipping discount offered into Column M and Column R will automatically calculate the total payout you will receive. Column S will calculate your profit, based on what you paid for the item. Lastly, input the date sold into Column T to show how many days it took for you to sell your item!
An important thing to note, the eBay Fee calculation assumes the standard 12.9% fee!
If your item sold on eBay, then input the Sales Tax charged to the buyer into Column N. This is the main thing I dislike about eBay sales. The fee the seller is charged is calculated on the total, including the sales tax the buyer pays. To find this amount, navigate to the Order Details and look at the right hand side. There will be a breakdown of the total, with the tax amount. Include this amount in Column N.
Next, input the Shipping Amount Charged into Column O. This should be the amount the buyer paid. Column P will then calculate the eBay fee. Input the Actual Shipping Costs into Column Q. Finally, Column R will automatically calculate the total payout you will receive. Column S will calculate your profit, based on what you paid for the item. Lastly, input the date sold into Column T to show how many days it took for you to sell your item!
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!
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 E6).
Next, Input the Platform you are considering the offer on. Input the Shipping Discount offered.
Then, input the Offer Amount. Lastly, for eBay offers, input the state the buyer is located in.
As I previously mentioned, eBay can be a real pain when it comes to calculating fees. For that reason, the Offer Calculator is only able to calculate an estimate. It assumes a standard sales tax based on the buyer’s state whereas eBay calculates based on specific regions. So far, I have only had it be off a few cents, so it still does the job! For more details on how eBay fees are calculated, go here!
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.
I also created a ‘Sales Analysis’ tab to keep track of my overall expenses and profits. The data in this tab populates from the Inventory Tracker tab, so you won’t need to update anything.
I have created a FULL version of the Reseller Inventory Spreadsheet that you can get for free using the below form! I created three free reseller template options, a Poshmark only version , a Poshmark + Mecari version, and a Poshmark + eBay version. If you have any questions on the spreadsheet, how to use it, or would like to see any changes in it, just leave me a comment below!
If you’re looking for tips on how to start selling on Poshmark, check out this Post!