How to create an Inventory?

[stetbooks]

Is there any sort of coaching in the seller area for how to create an Inventory of my ebay items? I see this on the seller hub under the Listings tab, and no information on how to make one, or what the benefit is.
I'd like to be able to track my CoGS within my eBay reports rather than go 3rd party, and I was hoping this would be a solution.

[coolections]

EXCELL works great.

[caldreamer]

You need to create Excel spreadsheet and assign inventory# to all your merchandise.  Spreadsheet should include (date you listed item, inventory#, description, cost of goods, date sold, EBAY order#).   You keep same spreadsheet (year after year) and just keep adding/subtracting cost of goods.

When you file Federal income tax (as a business) you need to know inventory on hand (1/1 beginning inventory and 12/31 ending inventory).   

[pennysdream]

Good Morning. 

Everyone does things just a little different.  However, what I found worked best for me...

I use excel.  I found a really basic inventory template on MSOFFICE.  and "adjusted" it to meet my needs. 

If you don't have office, Google Sheets can do the same thing.  

If you are new to excel, there are some REALLY GREAT Tutorial on YouTube.  When searching for help on YouTube, make sure they are using close to the same version you are.  There have been LOTS of upgrades (or screwed up) changes to excel the last couple of years.