Great video. I use a very similar spreadsheet but I'm a little behind in adding my inventory to it! I have a column for tracking if an item is in my booth as I have some inventory in storage waiting for an appropriate season.
I'm always behind too 😅 I should add a column to note where it is! Especially now that the number is getting so high. I've also scrolled the whole list just to remember what I have and knowing if it is at the booth or not would be a big help! Now I'm considering a column for season too since I have some fall things I pulled out a few weeks ago!!
Thank you so much for this! I think adding the date that you put it up for sale would be very useful. Or at least the date that you log it. That way you can see which items leave the shelves fastest. A piece that sells for a lot more than your purchase price but you’ve had to pay the booth cost at a consignment shop for an extended period of time isn’t actually as profitable as it may look on a spreadsheet without knowing the date it came into your inventory or went onto the shelf. The date you put it on the shelf combined with how long it stays on the shelf and the approximate square footage could help you determine what the cost was to keep that piece at the consignment shop. Another column that I think might be useful is approximate square footage of an item. Paying for booth space means that the size of an item is really important. And if you’re holding some items in storage before you put them in the booth, how much that storage space costs compared to the size of the item matters. You created this video a while ago, and I would really love to hear what other columns you would go back and add yourself that you think would’ve been useful in hindsight. My opinion is speculation, but I’d like to hear what your experience tells you.
What do you do about tracking mileage? Is that something you keep on a different spreadsheet for the sake of tax time when you write off related business expenses?
Great video - I'm just getting started and not ready to sell but already collecting. I need to begin keeping an inventory as I've collected quite a bit. The spreadsheet is great but is view only; how do I access it to add my own inventory/name/etc.? Thank you!
Hi, super helpful. I'm just going official booth this next month! Quick question, I see in your amazon link that you have a webcam. Is that something you keep in your booth?
Hi! Very exciting that you're starting a booth next month! It is not, the store I'm at does have cameras, but I don't have one in my booth. I haven't had an issue with theft and my first thought is that I would spend waaaayyyy too much time just watching people shop. It would be a great way to see what's actually drawing people's attention though!
Thank you for sharing, this is what i needed for my new booth! It would be nice to be able to add in the monthly booth rent, stoe 7% commission and calculate it into the profit/loss column. What are your thought on this? Thank you!
Hi! Yes, I do add the percent commission on my personal sheet. I also add in the 3% they charge for credit cards. I just assume everyone will use a credit card then I can be surprised when they do not. The rent is harder to add in because it would need to be divided by the number of things you sold that month, so you wouldn't be able to add it until the end of the month. Hope you're having a blast with your new booth!!
Hi, great inventory video. Can you tell me the name of the POS program the antique mall uses? The owner of the mall where I have a booth is looking for a program to use. Thanks, Trish
I keep those on a separate spreadsheet sheet. I have a row for each month with overall sales, rent, other fees (vendors pay the credit card fee at our store) and the cost of the product. That way I can subtract all of those things from sales to see the profit. I haven't started tracking millage! I need to do that this year!!
I just logged the items as a garage sale so I could keep track of where I was successfully finding things that sell. I'm not sure how this would be officially recorded though.
Happy it was helpful! I account for the cost of the item, any materials like paint or glue to fix it, the 10% that the antique store takes and the 3% I cover if someone uses a credit card 😳 it seems like a lot, but it's only a problem if you don't account for it when pricing your items!
Another thing you can do is print off labels/price tags by merging those three columns; Item number, description, and price in the Avery app.
You are a lifesaver!! This is exactly what I need for my new reselling business! Thank you! Thank you! Thank you! 🎉🎉🎉
You're welcome! I hope it helps!!
Great video. I use a very similar spreadsheet but I'm a little behind in adding my inventory to it! I have a column for tracking if an item is in my booth as I have some inventory in storage waiting for an appropriate season.
I'm always behind too 😅 I should add a column to note where it is! Especially now that the number is getting so high. I've also scrolled the whole list just to remember what I have and knowing if it is at the booth or not would be a big help! Now I'm considering a column for season too since I have some fall things I pulled out a few weeks ago!!
Thank you so much for this!
I think adding the date that you put it up for sale would be very useful. Or at least the date that you log it.
That way you can see which items leave the shelves fastest.
A piece that sells for a lot more than your purchase price but you’ve had to pay the booth cost at a consignment shop for an extended period of time isn’t actually as profitable as it may look on a spreadsheet without knowing the date it came into your inventory or went onto the shelf. The date you put it on the shelf combined with how long it stays on the shelf and the approximate square footage could help you determine what the cost was to keep that piece at the consignment shop.
Another column that I think might be useful is approximate square footage of an item. Paying for booth space means that the size of an item is really important. And if you’re holding some items in storage before you put them in the booth, how much that storage space costs compared to the size of the item matters.
You created this video a while ago, and I would really love to hear what other columns you would go back and add yourself that you think would’ve been useful in hindsight. My opinion is speculation, but I’d like to hear what your experience tells you.
This is so awesome! Thank you, I’ve been wanting something like this to help me get organized!
What do you do about tracking mileage? Is that something you keep on a different spreadsheet for the sake of tax time when you write off related business expenses?
Thank you this makes it so much easier than when I thought it was going to be
Thanks Laura! I just used an excel spread sheet for my booth but I might look into this one!
They're almost exactly the same, but you can use google sheets anywhere since it's we based. Even offline, but they're really similar!
Great info! Thank you; I definitely took notes! Do you have or will have videos regarding bookkeeping for antique booth business?
Thanks! I love the bookkeeping idea. I'm still working through a lot of that myself but I'll add it on the list to share!
Maybe I just missed it in the video, but I'm not 100% clear on the column labeled "Potential". Would you clarify for me please? Thanks for your help!
thank you! really helpful to know your process and way of thinking!
Great video - I'm just getting started and not ready to sell but already collecting. I need to begin keeping an inventory as I've collected quite a bit. The spreadsheet is great but is view only; how do I access it to add my own inventory/name/etc.? Thank you!
Happy it was helpful! You'll need to highlight all, copy and paste in a new spreadsheet to be able to use it yourself.
Do you have a formula for the percentage of sold amount to the cost of goods? Ty
I can't wait to use this!!! I am opening my own booth next week and was trying to find something to track inventory,
Hi, super helpful. I'm just going official booth this next month! Quick question, I see in your amazon link that you have a webcam. Is that something you keep in your booth?
Hi! Very exciting that you're starting a booth next month! It is not, the store I'm at does have cameras, but I don't have one in my booth. I haven't had an issue with theft and my first thought is that I would spend waaaayyyy too much time just watching people shop. It would be a great way to see what's actually drawing people's attention though!
Thank you for sharing, this is what i needed for my new booth! It would be nice to be able to add in the monthly booth rent, stoe 7% commission and calculate it into the profit/loss column. What are your thought on this? Thank you!
Hi! Yes, I do add the percent commission on my personal sheet. I also add in the 3% they charge for credit cards. I just assume everyone will use a credit card then I can be surprised when they do not. The rent is harder to add in because it would need to be divided by the number of things you sold that month, so you wouldn't be able to add it until the end of the month. Hope you're having a blast with your new booth!!
Hi, great inventory video. Can you tell me the name of the POS program the antique mall uses? The owner of the mall where I have a booth is looking for a program to use. Thanks, Trish
Hi Trish! They use Antique Soft. It's basic, and I really enjoy having it!
What about your other expenses? Such as your booth rental and mileage. Do you have a tab for that?
I keep those on a separate spreadsheet sheet. I have a row for each month with overall sales, rent, other fees (vendors pay the credit card fee at our store) and the cost of the product. That way I can subtract all of those things from sales to see the profit. I haven't started tracking millage! I need to do that this year!!
@@lauraatoakstreetexchange a video and link for this spreadsheet would be wonderful, if you have time for that. Thank you for the information ☺️
Thank you so much for sharing! This is exactly what we were looking for today
I'm happy it was helpful!!
How do you keep recipes for your purchases (garage sales)? Are they required incase you get audited?
I just logged the items as a garage sale so I could keep track of where I was successfully finding things that sell. I'm not sure how this would be officially recorded though.
This is so helpful. What exactly are the expenses?
Happy it was helpful! I account for the cost of the item, any materials like paint or glue to fix it, the 10% that the antique store takes and the 3% I cover if someone uses a credit card 😳 it seems like a lot, but it's only a problem if you don't account for it when pricing your items!
This was so helpful. Thank you for sharing the link. 🦋
Thanks! I'm happy you liked it!
What was the stores software that you pay the $5 extra for to stay aware of items sold?
It is called Antique Soft. I don't know how wide spread it is and it is basic, but it works and I'm happy to have it!
Just the form we need for our booth. How to get a copy. Thanks
Here's the link, let me know if you have any issues! docs.google.com/spreadsheets/d/1ijrnyoP8grOwCFdsqtVKLsrn1NhDmXe--eNky8Sqz0Q/edit?usp=sharing
I'm late to this video, but these are some helpful tips. Thank you for sharing!
The link at the bottom may help too
I would love a copy of this please! Thank you so much!
Thank you so much ❤
Happy it helped!!
Fantastic information
not necessary ,