inventory management examples or links

Rick Copple rick at copplecleaningservice.com
Mon Feb 12 08:49:52 EST 2018


I have an inventory of books I keep on a spreadsheet. I've designed the spreadsheet to give me an average cost that I can then plug into gnucash.  Do you want a screenshot of my inventory account? I could probably get to that this afternoon central time.

Rick Copple

On Feb 12, 2018, 6:26 AM, at 6:26 AM, Bert Heijne <BertHeijne at outlook.com> wrote:
>Hello All.
>
>This is a nice treat about Inventory but are there some “real examples”
>or “ putting it all together”  of gnucash for Inventory or stock of
>goods management?
>And how this is covered with the invoice.
>I now that gnu cash is not build for that but small stock would be nice
>Woocommerce webshop is in construction so this will be covered mostly
>by WC.
>
>Would be nice to see some real samples in gnucash to study.
>Any links or G search links  would be nice
>
>Gr. Bert
>
>Verzonden met Windows Mail
>
>Van: Robert Heller<mailto:heller at deepsoft.com>
>Verzonden: ‎zondag‎ ‎11‎ ‎februari‎ ‎2018 ‎17‎:‎15
>Aan:
>stepbystepfarm at dialup4less.com<mailto:stepbystepfarm at dialup4less.com>
>CC: gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>
>
>At Sun, 11 Feb 2018 10:55:58 -0500 stepbystepfarm at dialup4less.com
>wrote:
>
>>
>> On 2/11/2018 9:03 AM, Robert Heller wrote:
>> > At Sun, 11 Feb 2018 08:15:56 +0100 Jeff Abrahamson <jeff at p27.eu>
>wrote:
>> > ....... transfer
>> > "money" from the vegetable account to a bank account (income when
>you sell
>> > vegetables) and when you transfer money from a bank account to the
>vegetable
>> > account (an expense when you buy vegetables). *I* do this which my
>inventory
>> > of thumb drives. GnuCash does not have "inventory" accounts or any
>way of
>> > dealing with inventory as such
>> Inventory MANAGEMENT is something else (gnucash lacks this but that
>> belongs in an inventory system*, not "general ledger".
>
>Yes, I understand.
>
>>
>> But you are saying that gnucash does not support inventory value and
>> cost accounting and that is simply not so.
>
>Only in the sense of not specificly labeling things as "inventory value
>and
>cost accounting". You are right, one can use gnucash to "manage"
>inventory
>value and cost accounting. From the point of a newbie, there isn't a
>specific
>menu of things relating to inventory value and cost accounting, so
>there is
>the *appearence* of a of lack of support for inventory. My intent was
>to point
>the OP in "right direction", one that is not obvious. Inventory value
>and cost
>accounting is handled in GnuCash under "other names" -- it is a matter
>of
>understanding that inventory is really a kind of asset (that is bought
>and
>sold) and can (should) be treated as such, at which point all of pieces
>fall
>into place. The OP wanted to treat his inventory as income or expense
>and that
>what was confusing (to him).
>
>>
>> Let's say incidental to its main activity an organization sells
>various
>> things (tee shirts, coffee mugs, etc.) as a fund raiser. You create
>> under Assets (after "current assets" and "fixed assets") a parent
>> "Inventory of goods". Under that might be accounts (more likely also
>> parents as batches of goods might have different basis) for "tee
>> shirts", "coffee mugs", etc. When the organization buys a new batch
>of
>> tee shirts that is a debit to "tee shirts" (or as I mentioned,
>perhaps
>> "tee shirts batch 4" --- the account description can include what the
>> unit price was for this batch) and a credit to checking << note: we
>get
>> confused using the supposedly more user friendly terms worrying about
>> what sort of "transfer" this is). Each sale of a tee shirt not only
>> debits cash and credits "sale of tee shirts" for the sale price but
>also
>> debits "cost of goods sold" and credits the inventory account "tee
>> shirts batch N" for the unit cost of batch N << going to be a policy
>> decision whether to simply use FIFO or to actually worry about from
>> which batch that shirt came. Maybe BOTH come into play. To use your
>> example, thumb drives, you might have 8 Gb drives (batches of those)
>and
>> 16 Gb drives (batches of those) so you might want under "thumb
>drives"
>> children "8 Gb drives" and "16 Gb drives" and under each of those
>"batch
>> 1, batch2, etc. and use FIFO there >>
>>
>>
>>
>> Michael D Novack
>>
>> * The data kept here things like "number on hand", "physical location
>> where shelved", "reorder point", etc.
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>>
>
>--
>Robert Heller             -- 978-544-6933
>Deepwoods Software        -- Custom Software Services
>http://www.deepsoft.com/  -- Linux Administration Services
>heller at deepsoft.com       -- Webhosting Services
>
>_______________________________________________
>gnucash-user mailing list
>gnucash-user at gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-----
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
>_______________________________________________
>gnucash-user mailing list
>gnucash-user at gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-----
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.


More information about the gnucash-user mailing list