Hey I started using manager a couple months ago n everything is great so far thanks for creating such a great software. I only had one issue which is calculating cogs. The way I calculate it is opening stock +purchases -closing stock but I don’t know how to automatically get the opening and closing stock figure generated. Also I only do cash purchase of inventory in which I first enter the items in inventory then buy them by spending from my bank…this doesnt generate a purchases figure at all.
So basically I want to know how to set up my chart of accounts so cogs is calculated as opening stock+purchases-closing stock?
I dont know if this can solve your problem, but this is what i do.
create inventory items for purchased goods and sold goods
create a purchase invoice for what you buy, which includes the inventory details.
make a goods receipt for the items
create a production order
make a sale invoice
make a delivery note.
the items would show up properly inventory on hand under Assets would come up, inventory sales and inventory cost would show up in P/L
you can create a separate account group “Cost Of Goods Sold” as an expense and then move the “inventory - cost” account under it,
and a “operating income” group to move inventory sales under it
If you are creating inventory items, it does not matter whether you record their purchases with a purchase invoice or cash payment. The asset value of inventory purchases first appears in Inventory on hand. When you sell it, its cost is automatically transferred to Inventory - cost and the associated income to Inventory - sales. If you want to see cost of goods sold with that name, you can do as @spandan888 suggested, adding a group, or just rename the Inventory - cost account. Whatever it is called, and however it is displayed, Inventory - cost is the cost of goods sold.