How Does Cost of Goods work

Back Top Previous Next

The Stock On Hand and Cost of Goods Sold functions in Jim2 are extremely flexible and reliable for maintaining an accurate stock control system.

 

As there are different types of stock in Jim2, not all stock is treated in the same way when purchasing and selling.

 

As Labour and Applies types of stock cannot be purchased, they do not have any bearing on the stock on hand or the cost of goods sold. Depleting, special and non depleting can be purchased and therefore create general ledger entries.

 

Depleting and special stock

When purchasing depleting and/or special stock, the purchase values will be entered into the stock on hand asset accounts for each stock record using the Stock GL Groups set up and added to each stock record. These Stock GL Groups will have a purchase (asset) account, a cost of goods sold (cogs) account and an income account for each group.

 

Special Stock covers stock where costs from the supplier will fluctuate. Special stock is also uniquely purchased for a specific job. The cost of goods will be taken across to the job when the stock is added, hence it uses the Exact COGS rather than the Last COGS.

 

Non depleting stock

As non depleting stock is classed as stock not required to track quantities or values, when this stock is purchased the value goes straight into the cost of goods sold account as chosen in the Stock GL Group for that stock record – not a purchase asset account. This method of dealing with non depleting stock allows for keeping an accurate stock on hand values within the general ledger and Jim2.

 

Info

The use of non depleting stock within a business should be kept to a minimum as it doesn't keep an on hand quantity or value.

 

Expenses applied to purchase orders

If an expense order is applied to a purchase order, it will disregard the general ledger account selected (select a general ledger account, as this is a mandatory field) and use the expenses on purchases account, and from there be distributed to the correct stock on hand Stock GL Group accounts.

 

Once a purchase or expense order (whichever is last) is finished, the expense amount goes into the expenses on unfinished purchase orders account – then splits the expense into depleting, special and non depleting.

 

Depleting and special expense amounts go into the related asset purchase account(s).

 

Expense orders have no impact on journal stock, and the journal stock amounts will be ignored for the purposes of distributing COGS.

 

Non depleting expense amounts will be transferred to the non depleting cost of goods sold (COGS) account(s).

 

Once sold, the depleting and special COGS are transferred to the related COGS account for that stock. This is the COGS (price + expenses).

 

Manufacturing COGS

Once a job is manufactured, it creates a purchase order on the status of Finish, which moves the raw material dollar values into the related stock on hand account for that manufactured stock. The COGS with Applies and Labour can display in the purchase order to use for pricing, but use Price (raw materials – depleting and special stock only) for COGS.

 

Once the product is sold and transferred from stock on hand, the price or price + expenses are moved into the related COGS account.

 

Average PO COGs + Markup/Margin

This stock pricing calculation method allows setting the selling price to be Average PO COGS + Markup or Average PO COGS + Margin.

 

set calc methods

 

The Average PO COGS changes only at point of purchase – not at point of selling as per the normal Avg COGS + Markup or Avg COGS + Margin methods.

 

This is strictly the average cost price paid for this stock, including on-costs/landed costs. Jim2 will recalculate this figure each time a purchase order is finished.

 

To understand how this works follow the example below:

 

Action

Qty in Stock

Purchase Price

Average PO COGS

Purchase 10 units

10

$10.00

$10.00

Sell 5 units

5


$10.00

Purchase 10 units

15

$20.00        

$15.00        

Sell 10 Units

5


$15.00

 

Info

This pricing method is only for the calculation of actual selling prices. The COGS posted to the general ledger at point of selling is the correct FIFO (actual) cost of goods.

 

Further information

Purchases Security

Debtors Purchase Orders

Expenses at a Glance

Purchases at a Glance

Expenses Tab on POs

How PO Status Affects the GL

Purchases/Expenses Status

Purchase/Expense Order Header

Purchase/Expense Order Footer Tabs

Purchase/Expense Comment Grid

Purchase Order Approval Process

Purchase Order Stock Grid

Purchase Order Reports

Purchase Order List

Purchase/Expense Preview Pane

Purchase List Header

Expense Order Stock Grid

Opening Balance Purchase Order

Add a Negative Expense Order

Add a Purchase Order

Add a Document to an Order

Add an Amount to a PO when Finished at $0

Add an Expense Order

Add Backorder Purchase Order

Add Comments to a Purchase/Expense Order

Add Freight to a Purchase Order

Add Stock to a Purchase Order

Add Vendor Discount

Auto Create a Purchase Order

Create a PO from a Similar PO

Create a PO Template

Create a Purchase Order List

Enter Serial Numbers

Fix Incorrect Pricing after PO Finished

Handle Employee Reimbursements

Handle a Credit for Freight Charged

Link a Job to a Purchase Order

Link Expenses to a Purchase Order

Print a Purchase/Expense Order

Progress Payments on Purchase Orders

Purchase Consignment Stock

Receive Consignment Stock

Receive Stock

Record One Invoice Number on Multiple POs

Record Overseas Purchases, GST, Import Costs

Return to Vendor

Round up Supplier Invoices

Scan Stock into a Purchase Order

Staff Purchases

Unprint Purchase/Expense

Vendor Price Breaks

View or Edit a Purchase/Expense