EDIT: There are some Poshers who have already pointed out there needed to be an update due to the commission in the ‘Poshmark cut’ column. If you’ve already DL the spreadsheet and want the updated one. It’s been uploaded and fixed here. However if you have already downloaded it, and still see $0.00 in the Poshmark cut portion, then please update the spreadsheet with this formula: =IF(D4<15,2.95,D4*0.2) in the “Poshmark Cut” column.
It’s finally here! Probably one of the most requested items on this blog for people that have massive inventories. I wrote a post 2 years ago, and people have been requesting this so much, so I am happy to announce that I’ve made it available to everyone….after 2 years. Thanks for the patience! I have worked for awhile to get this right with all the formulas perfectly balanced, so don’t eff with the shaded columns. I am chucking this up for free, because unlike other Poshers who’ve charged for their advice and mentorship, I don’t. However, one thing I do ask for in return is you leave me a comment at the end of this post if you did DL it, any questions, comments, suggestions, Thank You’s, and FU’s would be greatly appreciated!
Here it is ladies in all it’s glory! The coveted Poshmark Inventory Workbook for your accounting pleasure. I highlight all the key parts to it in the video below so that you yourself can be a small business rockstar at the end of the day.
The DLable copy you see above and below is completely blank ready for you to start filling in. AGAIN DO NOT FILL IN THE PINK COLUMNS. They have formulas already in them so if you overwrite them, then it won’t pre-calculate it for you.
I hope this tool becomes useful to you, it’s made things incredibly easy for me to keep track of how much all of my listings are. I explain a lot in the video, so if I am missing anything please let me know!
Download the spreadsheet for FREE here: Poshmark Inventory Workbook
EDIT 2: Please note that this is one that I personally use. It’s simplified to the max, but it’s also very user friendly and easy to use. One thing that it doesn’t have yet is bundling capabilities, that I can attempt to construct later on, but for now, you may have to adjust accordingly. This is version 1.0 I plan on updating it soon with more functionality, but its just a quick simple solution to managing your closet if you aren’t looking to have something too hard core for now.
Thanks so much for reading!
Stay Healthy,
-E
Thanks Ediza! I was about to create my own spreadsheet and wanted to see if there was already one out there– and I found yours! I sell mostly my own stuff, but have started to resell items I find to see how that goes, I think this will help me catalogue it all! Thanks again!!
-@missjois on PM
LikeLike
Recently stumbled across your blog and I love it! Thank you so much for the inventory workbook. I have downloaded and plan on utilizing. I think it will be a great tool for keeping me accountable and on track. You Rock!
LikeLiked by 1 person
The link for the spreadsheet doesn’t seem to be working
LikeLike
No worries! Let me fix the link! Give me a sec!
LikeLike
Ok it’s been fixed! You are able to upload it now!
LikeLike
Thank you very much!! The workbook is perfect for me as a beginner.
LikeLike
Thank you so much! You’re a hero. ❤
LikeLike
Thanks! Share with your other Poshers!
LikeLike
I’m working on this excel sheet is currently on my summer to do list now that I have the extra time. Thanks so much for putting this together and making it available for all of us!
LikeLiked by 1 person
Yes of course!!
LikeLike
Thank you so much Ediza! I’m new at Poshmark and this was one of the first things I was thinking of when I decided to finally take the leap and do this 🙂 I just started trying to create a spreadsheet but decided to check other Poshers advice. It’s very kind of you to help others this way. Love and Peace to you!
LikeLike
Thank you so much for this, Ediza! I really appreciate the time & effort you put into it! Looking forward to connecting with you on PM! XO @rockettcollins
LikeLiked by 1 person
Thanks so much! I have been considering branching into a Posh Boutique after great success selling my own clothes. I read this post and the packaging post and both have given me an awesome idea of where to start. 🙂
LikeLiked by 1 person
Wow! Thank you so much for sharing this worksheet. Not sure if you attempted anything with the bundling feature. But I have a suggestion. Because buyers now have the opportunity to make offers on bundles each bundle is going to have a different % off. Perhaps if you just added a column for “Bundle % Off” that may easily(?) help! 🙂
LikeLiked by 1 person
I am doing some modifications on it! Good suggestion!
LikeLike
I am soo glad I found you on youtube! Thank you!!! I’m new to poshmark and you have been such a big help! You’re awesome!!!
LikeLiked by 1 person
Thank you so very much for sharing this amazing worksheet. I had been doing one of my own but it was no where near as great as yours is. Thank you, thank you, thank you.
LikeLiked by 1 person
I just need you to know. . .I WORSHIP THE GROUND YOU WALK ON! You’re so sweet to share all of your knowledge!
LikeLiked by 1 person
Awe! You’re too kind! If you know of any other posters that need it just point them my way!
LikeLike
This is very helpful, thank you so much.
LikeLike
You are amazing for creating this! Question… At the bottom for the tabs “master”, “month 1” and “month 2″… how do I create more, like to have more months?
LikeLike
Right click and hit copy and then paste to the tab next to it, if not then copy month 1 and start a new tab!
LikeLike
Thank you for this. I just don’t have the time to do one from scratch.
LikeLike
I just downloaded your spreadsheet and watched your tutorial. Thank you so so so much for sharing this with us! I love the format of your spreadsheet and cannot wait to start using it.
LikeLiked by 1 person
Good luck!
LikeLike
Going to try your sheet! It’s very similar to mine but yours is a better format. Thank you!!
LikeLiked by 1 person
Wow!!!! Thank you, thank you, thank you! This is amazing!!!! I know you put a lot of hard work into this! I’m excel challenged – so I really appreciate it! 🙂
LikeLiked by 1 person
Make sure to watch the video if you need help!
LikeLike
Sadly does not work in Numbers for MAC 😦
LikeLike
Sadly it does not, it’s only for Excel 😭
LikeLike
I’m having a hard time completing the rest of the months and the bottom of the spreadsheet. I’m trying to copy and paste, but it is not like Month 1 and 2. Any suggestions?
LikeLike
Did you watch the video? You would need to cut the whole row out and paste it to the month it sold in.
LikeLike
Thank you so much for this! I’ve been Poshing for a little over a month now. Sales have been picking up now that I’ve been getting more into it, and I’ve really wanted to track to see if I’m actually making money. I’m sure this will keep me in the loop and financially sound 🙂 . Than you!!!
LikeLike
Thank you so much for the free spreadsheet! I just started poshing and I wanted to track my progress. Thank you for your help!
LikeLike
Of course! Thanks for reading!
LikeLike
Thanks so much for the spreadsheet, Ediza! Have any Mac users had any problems creating the hyperlinks in the Excel spreadsheet? It won’t work for me. I was so thrilled when I saw this post!
LikeLiked by 1 person
I have a Mac and have no problem hyperlinking it. I think after I put the link I hit the space bar and it automatically does it for me. BUT you may want to check the excel version, hope that helps!
LikeLike
Thanks so much for sharing! I’ve been casually “flipping” stuff online for years. Now that I’m getting serious about it, I need to get more organized. There aren’t enough hours in the day to indulge my OCD organizing AND be a single mom. This spreadsheet is a fantastic blessing! Looking forward to checking out other posts and learning more from your expertise. Great job using your super powers for good!
Hugs!
Betsy
LikeLike
LOVE THIS! This has really helped me, one other thing I’m having trouble with is keeping org. with the shipping. Do you have any tips……..? Thanks so much again for the awesome DL.
LikeLike
I actually have a neat video that you can watch on shipping etiquette! https://healthygirlfashion.com/2016/07/17/poshmark-shipping-etiquette-video/
LikeLike
MY GOD this is incredible! And so insanely generous that you gave this out to us for free! I’ve been searching the stores looking for the perfect ledger and haven’t found one. This is by far the raddest most helpful thing ever. Thank you so so much!!!
LikeLike
Good I’m so glad you can use it!! Also, please check out the video too that goes with it, it’ll help guide you through filling it out!
LikeLike
Thank you so so much! You are amazing and I can’t wait to get started with it!
LikeLiked by 1 person
Love this! Time to get my organized spreadsheet game on! Thank you so much for sharing, this is a much better start than what I created months ago (and then never used), I’ll take this and run with it 🙂
LikeLike
Melissa! That sounds great! I can’t wait to hear the outcome, time to get organized girl!!! 😘
LikeLike
*poshing
LikeLike
Thank you so much for this! I just downloaded it and I’m filling in all my info. I’m super excited to have such a great program to track my earnings.
LikeLiked by 1 person
Yeah! I’m glad! Happy pushing!
LikeLike
Thanks! This is super helpful. Hope to meet you at Poshfest!
LikeLiked by 1 person
Oh yes! We will need to meet at Poshfest!!!
LikeLike
THANK YOU THANK YOU THANK YOU THANK YOU! Such an essential tool! Thank you for making this accessible AND with the formula’s already added for easy management for the less tech savvy. So grateful. If I have any questions will definitely let you know. Thank you!
LikeLike
You are welcome! Enjoy!!
LikeLike
Thank you so much for making this! 💕
LikeLiked by 1 person
You are most welcome!
LikeLike
fantastic – so much better than my spreadsheet! thank you 🙂
LikeLiked by 1 person
I’m glad! Enjoy!
LikeLike
Thank you so much!!! I’m going to start using & appreciate your sharing this template with others! 👍🏼🙋🏼😘
LikeLiked by 1 person
Of course! If you have any questions let me know!
LikeLike
Thank you so much! You are the best ever! I’ve been dying for something like this!
LikeLiked by 1 person
You are most welcome!! Thanks for reading! 😘
LikeLike
Thanks so much for this tool! I was just creating an excel spreadsheet myself today- this is UBER helpful!! xoxo
LikeLike
I’m glad! You can add and customize how you want, it’s a great stepping stone for your own spreadsheet!
LikeLike