Inventory system (mini inventory)
It would be nice to have "mini" inventory, in which I can receive good for sales, maintain a stock. And it would be nicer, if it is "connected" to invoice, so I can invoice my customers for goods they bought.
Most small businesses need to do inventory. Be able to do a point of sale (cash register) based on items in inventory. Inventory should have amount on hand, minimum amount, standard pricing and purchase cost etc. I would use this if it had inventory. I both sell and rent items.
where it tracks item stocks, COGS, Sales and supports Invoicing and creating PO.
This request is understandable and useful for some users. However, to be honest this won’t be implemented in GnuCash for quite some time (read: years) to come. GnuCash in its current design is targeted towards a home user or small business user, where the financial book-keeping is available. An additional inventory system (beyond using stock accounts not for stocks but for pieces of inventory) is a completely new system, which is not planned and easily possible in GnuCash for some years to come. Because of this, we have to decline this request for now.
Marcus Wolschon commented
I have done that using 1 account+1 currency per good and it worked fine.
(With lots of automation via jGnucashLib since this gets VERY verbose.)
Sorry for resurrecting this idea.
The one and only reason I continue to use QuickBooks v5, dating back to 1997, is because it has basic inventory management. You may wish to categorise QuickBooks as ERP rather than "accounting", yet I continue to use it, and not GnuCash, because it has basic inventory management. Furthermore, I can presume millions (MILLIONS !!) of other users are in the same position. So, please consider what the user community requests, rather than what fits nicely into a category called "accounting" software. No other open source "accounting" software such as QuickBooks exist, so stop wasting time and seize the opportunity to become the solution of choice for many (Millions ??) of others currently forced to use a propriety solution such as QuickBooks.
Sorry for being so forceful and direct, yet I share the same viewpoint as others that GnuCash is a really good program but falls short of what users want because of ideology.
Great idea indeed! with inventory GNU Cash will be irresistable!!!
Igalo Mne commented
Please, edit the title so that it doesn´t say ´mini´, we want complete solution, not just mini inventory. INVENTORY is one of the few things GnuCash misses to be a COMPLETE accounting solution.
Hedley Finger commented
I disagree that a starting inventory system is too complex. For a starter, just record purchases of items and quantities, and use the averaging system of determining cost of items. If you have received an order from a customer, you can just keep the order in a folder until the SKUs come in. Then just sell them and update the quantity, Cost of Sale, and Inventory.
Julian Roberts commented
Wow, inventory always sounds easy but just is not... However much I would like this I reckon the focus should stay on accounts - so much to do man!
ERP is too complex for a small and medium scale businesses like retail and franchise businesses which maintains moderate but many types of items. I don't believe GnuCash is just limited to Personal Finance Manager tool for it already include a Business Menu where you can create invoice, billing and voucher for employees. So, I do highly believe that adding inventory module will make it a complete and powerful package...
Sorry I would tend to disagree... Adding such modules will make GnuCash more of an ERP software which means it will be less of a Personal Finance Manager as described by its developers.
If you really want such Please try using ERP Softwares like the one I use Dolibarr
This is why peachtree still wins me.
If mini inventory feature isn't included, then at best gnucash is suitable for service oriented industry where no stock is involved.
Yes, one could write up an invoice based on the items sold, but then the selling price will have to be looked up at an excel file, too many to and fros between gnucash and another program.
I do agree that mini inventory is a PITA, you can't stop at only 1 part of the inventory system.
Vladimir Bashkirtsev commented
Every bit of great work starts small.
My partner (professional accountant) looked at GnuCash and said she would not use because it does not have inventory per se. However I (professional programmer) had second thoughts: what if we will declare each product as a commodity and have subtree of accounts where each separate account represent separate SKU? So I have got my PHP scripts which I use to run online shop to add/modify DB records as needed automatically and in effect I now have mini-inventory system.
So in effect GnuCash has all necessary elements to keep track of inventory. We just need a way which can associate inventory subaccounts with records in invoice and this should be relatively simple.
Yes! it may require a lot of work but this would make GnuCash a very powerful and complete accounting software.
Admincstim (Core Developer, GnuCash) commented
Implementing a inventory system is a giant amount of work here. I'm rather inclined to decline this feature proposal, because it requires a whole lot of additional other features.