Inventory management with GNU Cash

[Mayank Bhatia]

Hi ,

I know this question has been asked many times but I have not seen a
satisfactory answer yet.

I am trying to setup GNU cash for my wife's business. She makes handmade
jewelry and sells it on etsy and art/craft shows. I tried the pre-defined
asset types but none of them are suitable. What I want is an inventory
account type and each new item going as a transaction under it, rather than
creating new accounts for each item.

I tried stock account but it is not suitable either (it requires me to
create a new Stock type for each item). That can go out of had quickly.
Some people have suggested that I maintain inventory in separate excel file
and then at the end of the month transfer COGS and taxes to different
accounts. Isnt there a better way?

thanks
Mayank