Do you have this spreadsheet available for purchase? Idk you may say it at the end. I’m about halfway through so sorry if you say it later or in another video. I’d be interested in a copy 😍😍
Hi Sarah!! I actually do now - and I’ve updated it a bit to make it more useful :) It’s $20 and I’ll share it with you on Google drive. You can email me at laurakdavis21@gmail.com! ❤️
This is so helpful. I’m going to create something like this for my items. I sell craft supplies on eBay and Etsy and books on Mercari, so my system might be slightly different but this is a great idea! Thanks for sharing.
Very organized BUT try taking in account the amount of time you spent with not so necessary info entered here such as (how many days it took to sell) and account that as COST of doing business as well. You may find that while organization is key - going over the board with it will cost you money.
Hi Laura just found your video and just wanted to let you know that you are doing such a good job, I'm still learning how to do an inventory spreadsheet and I liked how you explained what you do,I'm going to try to start working on it. Keep up the good job.
Watch your video halfway, hopefully I don't miss anything. I just thought the spreadsheet details thing is not necessary and time consuming. A lot of time when you buy for one place, you just do an aggregate of how much you pay, and when you sell something, there is really no need to write down every single detail. eBay provide report for you weekly - which you can take: the sales amount, fees, etc. Postage is again aggregate, for example if you ahve an account with post office or carrier. The easiest way to do is to have one file for sale, you can write down weekly amount, then another spreadsheet for list of expenses: date, what expense it is then amount. Your system may be good if you accepting consignment from someone.
Excellent tutorial! Very helpful., thanks for sharing. I have a mother load of inventory to catalogue and list and this info will help me to edit my spread sheets.
THIS IS SO BADASS!!! I am super detailed when tracking things and THIS is exactly what I tried to create 2 years ago. I guess i'm not as well versed in EXCEL hahaha I'm a lightweight as far as knowing you to create these formulas. BUT THIS IS WHAT I WISH I COULD DO. Thanks for sharing it. I can't believe it
Rosalva Vasquez I have thought about it, I just have to figure out the logistics! Thank you for watching, I’ll let you know if I release a template in the future ☺️
What type of shelves do you have? They look cool. I just got a bit confused when you put the price of items in one place then list the total of $21.44 as an expense. It only becomes an expense when it’s actually sold hence cost of goods sold. Did I get this wrong? I need to start this but feel really overwhelmed starting…..just subscribed to your channel
Margo Schembre thank you!! I actually recently started using Mogi Beth’s, which you can buy for $25 on her website. She has formulas in there to automate a lot of what I was doing by hand - so useful!
@@LooksbyLaura ha!! That's what I use! Yours just looked more detailed in terms of tracking. Did you add fields to the MB one? Or are you using it as is?
Margo Schembre I did customize it a bit. I added category, brand, and size because I like tracking that information. I cut out date purchased because I realized it was more work that wasn’t totally necessary - date listed is much more valuable! It was tricky to add columns though, since a lot of her formulas are really specific to her spreadsheet, so it did take a couple hours
This was by far my favorite inventory and budgeting video so far. Newbie here and am grateful to have finally found a spreadsheet that I like! Thank you!! 💜🤍🤍💜
That is so smart for the eBay portion. I’ve been trying to figure it out since sometimes I paid less for shipping when purchasing the label then what the buyer paid since eBay does the discounted shipping.
Ebay can be such a hassle for tracking purposes! Sometimes I promote a listing too, so I have to remember to calculate that in. I usually double check my numbers once a month with the sell page on eBay to make sure everything is pretty accurate 👍🏼
Do you recycle your inventory number bags that your store in your bins once an item sells? Great video. I have an overwhelming spreadsheet and even bought one that keeps the inventory averages etc. you made it look so easy. It’s a ton of work and daunting at times!!
CK Robinson thank you so much! I’m still always trying to improve my system and spreadsheet so things don’t feel redundant. I do keep and reuse the inventory bags. If I have too many bags, I know I need to go thrifting!
I'm only 5 min in and I'm already excited about your system and how detailed it is. I need a spreadsheet like this I am new and haven't started yet I'm just getting mu stuff together. Do you offer your spreadsheet for sale at all? Thank you thank you thank you for this video.
Wow super organized. Love your spreadsheets! How many different sheets do you have. Ibe been reselling almost 2 yeats and have never implemented one and wanna start.
NikPikThrift thank you!! I just have the spreadsheet I showed but it has about 10 different tabs lol 😆 it was a lot of time on the front end but it is so worth it to me to have it now and maintaining it is super quick and easy.
Diane Schultz not at the moment - I’ve been using Mogi Beth’s with some alterations (some of the extra info I have in mine mixed with her awesome formulas). Hers is $25! I might offer one in the future, but definitely recommend hers
I do not currently, but I have considered it. Right now my shipping station is at home, so I just go to the unit (it’s less than a mile away) and package everything at home. I only ship 3 times a week, so it’s manageable.
Love, Love the video. However, can't really see all the tabs and excel formulas you use on each spreadsheet. Would really like to see another vidoe on your spreadsheets from beginning to end of your process.
Hello, I have been trying to come up with a system to keep track. I haven’t sold many things yet, but filed for an extension on taxes 23. If it’s still available, I would really love to purchase your system. Also, does it have a column for sales tax paid when purchasing items?
I love your video… I’m definitely going to use your ideas. I do have one question what size a plastic bag do you use? I lived in Boston and recently moved to Texas. Awesome that your New Englander.
Thank you so much for watching! I use gallon bags typically, but also have a larger size for bulkier sweaters/jackets, etc. The gallon bags work for almost everything though - jeans, dresses, tops :)
Can you send me a copy of your basic spreadsheet just categories and column titles (no $ info ) not sure I can figure out the formulas because I don’t know excel but will see. Thanks
Hi! I think it’s totally up to you, but I started this process when I had over 100 items in inventory. At that point, it was hard to keep track of where everything was without a system. I did keep track of how much I spent on inventory from day 1 though!
Question for me personally as I am thinking about a storage unit, is your unit climate controlled? I'm afraid to get one that is not climate controlled because of mold and other environmental damage. I know they are more expensive, but I just feel I have no choice. Could I get your thoughts on this? Thanks in advance, Kim
Kimberly Robinson This was something I went back and forth on too! Mine is climate controlled. I talked to the manager of the storage unit and he said for clothes and shoes, he does recommend going with a climate controlled unit. It keeps the clothes from humidity and sometimes that can create an odor which would be such a nightmare to have to deal with! It’s a little pricier but I think it’s worth it for the peace of mind 👍🏼
Does anyone know if you sell items on Facebook marketplace let's say for example clothing like in this video, can you consider yourself a home-based business, can you get an assumed name or LLC? I don't quite how know how this works when it comes to Facebook marketplace.
Hi, a new sub is here supporting your channel. You are so organized! 👍 I sell once in a while and know good organization is a key. I would like to have a spreadsheet template like yours if it’s possible. Good luck with your eBay and RU-vid businesses! 👍❤️
Fa2z SA thank you for watching and supporting my channel! ❤️ I actually recently started using Mogi Beth’s. She has some formulas in hers that automate what I was doing by hand - huge time saver! You can buy hers on her website for $25 🙌🏼
Love this video. Thank you so much. I don't see a link, are you using business google or personal google sheets? Also is this free to use, I only found ones that cost money?
Diane Schultz mine is down the street! I can walk there in 15 mins or drive in 3. I paid a little extra for the closest possible unit instead of paying less for one farther away, and I’m SO glad I made that decision
seems like a lot of work, have you since streamlined this? just seems like a lot of wasted time, esp if your data input is not already in the csv format that ebay requires to make draft listings