Message:

<p>[QUOTE=&quot;bercrystal, post: 483287, member: 88&quot;][USER=1629]@LIbraryLady[/USER] - I have used an Excel set up from the very beginning back in 2001.</p><p><br /></p><p>Every year I copy the existing inventory list &amp; then go through to delete all items that have been sold that year. The copied list is renamed as &quot;Inventory 2019&quot; &amp; the old one becomes &quot;Final Inventory 2018&quot;. </p><p><br /></p><p>I have all of my inventories on my computer&#039;s hard drive (also on my portable hard drive in case of total meltdown <img src="styles/default/xenforo/clear.png" class="mceSmilieSprite mceSmilie45" alt=":facepalm:" unselectable="on" unselectable="on" /><img src="styles/default/xenforo/clear.png" class="mceSmilieSprite mceSmilie45" alt=":facepalm:" unselectable="on" unselectable="on" />) so it is very easy to go back as many years as I need to to search &amp; find whatever I am looking for at the time. </p><p><br /></p><p>A lot of what I sell carries over from year to year because I buy a lot of multi-item lots. For instance it may take me a year or 2 or more to sell a complete set of dishes or glassware. I usually make my money back by selling a few pieces &amp; the rest is technically gravy. So unlike Marie I don&#039;t start each year with a totally clean slate. </p><p><br /></p><p>Since I had to provide a dollar amount of inventory on hand this made it very easy to do. I would just highlight the one column to give me the exact amount that was still here.</p><p><br /></p><p>Column A - I assign everything an inventory number starting with 100. If it is a multi item purchase the numbers are followed by letters (100-A, 100-B, etc.). This was of more use when I had a booth &amp; sold at shows, but it is just easier to keep the same format. </p><p><br /></p><p>Column B - The date the item(s) were purchased.</p><p><br /></p><p>Column C - A brief description of the item.</p><p><br /></p><p>Column D - If it is a multi-item purchase the total price is written here. (A few years back I started to do these numbers in red until I had exceeded the amount I had paid. After I had made my money back the numbers were changed to green. I use to delete the original amount but doing it the new way helped me decide if it was time to cut bait on the items left without having to refer back to previous inventory lists to see how much I had made on the lot. It also gives me a little visual boost seeing lots of green numbers. <img src="styles/default/xenforo/clear.png" class="mceSmilieSprite mceSmilie49" alt=":happy:" unselectable="on" unselectable="on" /><img src="styles/default/xenforo/clear.png" class="mceSmilieSprite mceSmilie49" alt=":happy:" unselectable="on" unselectable="on" /><img src="styles/default/xenforo/clear.png" class="mceSmilieSprite mceSmilie49" alt=":happy:" unselectable="on" unselectable="on" />)</p><p><br /></p><p>Column E - This column is for individual pieces or the amounts assigned to multi-item purchases.</p><p><br /></p><p>Column F -My original price for the item. (This column was more important when I had a booth. Now I just put in a number slightly over what I had paid or for the most part 4.99-E which is as low as I go on eBay. <img src="styles/default/xenforo/smilies/tongue.png" class="mceSmilie" alt=":p" unselectable="on" /><img src="styles/default/xenforo/smilies/tongue.png" class="mceSmilie" alt=":p" unselectable="on" /><img src="styles/default/xenforo/smilies/tongue.png" class="mceSmilie" alt=":p" unselectable="on" />)</p><p><br /></p><p>Column G - My actual selling price for the item.</p><p><br /></p><p>Column H - The date the item was sold.</p><p><br /></p><p>Column I - The difference between what I had paid for the item &amp; what it eventually sold for in the end.</p><p><br /></p><p>I also keep track of multi-item lots from year to year in the next couple of columns. This also helps me easily decide when it is just not worth hanging onto or trying to sell the last item or two. </p><p><br /></p><p>Hope this helps out you or anyone else who needs to keep track of inventory.&nbsp; <img src="styles/default/xenforo/smilies/biggrin.png" class="mceSmilie" alt=":D" unselectable="on" /><img src="styles/default/xenforo/smilies/biggrin.png" class="mceSmilie" alt=":D" unselectable="on" />[/QUOTE]</p><p><br /></p>

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in