Cost of Goods Sold Calculator

How do you calculate cost of goods sold?

A cost of goods sold calculator works out the cost of the goods a business sold in a period from its inventory counts and purchases: beginning inventory, plus net purchases, minus ending inventory. Whatever was available and is no longer on the shelf was sold. It is the periodic formula of IRS Schedule C Part III and Form 1125-A.

With the defaults: $70,000 of beginning inventory + $610,000 of net purchases ($612,000 of purchases + $6,000 of freight-in − $8,000 of returns) = $680,000 of goods available for sale; less $80,000 still on hand = $600,000 of cost of goods sold.

Freight-in, the shipping you pay to bring stock in, is part of the cost of the inventory (FASB ASC 330), so it is added to purchases. Purchase returns and allowances, goods sent back or price reductions from suppliers, come off. For a manufacturer, the formula is the same but the additions are raw materials used, direct labour and manufacturing overhead rather than merchandise purchases.

What does not go into cost of goods sold: selling expenses, administrative salaries, marketing, office rent and depreciation of non-manufacturing assets. Those are operating expenses; they reduce operating profit, not gross profit. Enter net sales in Advanced and the calculator shows gross profit: $900,000 of sales less $600,000 of cost of goods sold is $300,000, a 33.3% gross margin.

How do you calculate COGS for a manufacturer?

For a manufacturer, total production cost is the sum of three components. Raw materials used is the cost of materials consumed in production (beginning raw materials inventory plus raw-material purchases minus ending raw-material inventory). Direct labour is the wages and salaries of workers who directly produce the goods — not supervisors or support staff, who go into manufacturing overhead.

Manufacturing overhead is everything else the factory needs: rent, utilities, equipment depreciation, indirect labour, factory insurance. You then apply the periodic formula to finished-goods inventory: beginning finished-goods inventory plus total production cost minus ending finished-goods inventory equals COGS. Note that two levels of inventory exist — a raw-materials level and a finished-goods level — and this calculator handles the finished-goods level. If you need raw materials used, compute it separately (beginning raw materials plus raw-material purchases minus ending raw materials) and enter that figure.

With the manufacturer defaults: $40,000 of raw materials used + $15,000 of direct labour + $8,000 of overhead = $63,000 of cost of goods manufactured; $20,000 of beginning finished goods + $63,000 − $12,000 of ending finished goods = $71,000 of cost of goods sold. Uniform capitalization (IRC 263A) requires some producers and resellers to add more indirect costs to inventory; the calculator does not model it, so enter overhead that already includes any such adjustment.

Is cost of goods sold the same as cost of sales?

For a business that sells goods, usually yes: income statements use cost of goods sold, cost of sales and cost of revenue for the same line. Service businesses with no inventory say cost of sales or cost of revenue for the direct cost of delivering the service, which is measured directly rather than with the inventory formula.

IRS Schedule C and Form 1125-A use cost of goods sold. For this calculator the distinction does not affect the arithmetic — the periodic formula is the same. If your business is primarily a service business with no physical inventory, your "cost of sales" is not the opening/closing inventory formula but a direct measurement of delivery costs; this calculator is designed for businesses that carry physical inventory.

What are the common COGS mistakes and limits?

The most common mistake is forgetting that the costing method changes the ending-inventory number — and therefore COGS. FIFO (first in, first out) assigns the cost of the oldest purchases to COGS; LIFO (last in, first out) assigns the most recent costs; weighted average uses the average cost of all units available.

In a period of rising prices, FIFO produces lower COGS and higher taxable profit; LIFO produces higher COGS and lower taxable profit. LIFO is a tax election (Form 970) that requires IRS consent and must be consistently applied. This calculator does not compute ending inventory — you enter the value your accounting system or physical count gives you under your chosen method.

A second common mistake is including operating expenses in cost of goods sold. Office rent, the owner’s salary, sales commissions and advertising reduce operating profit, not gross profit; putting them in the cost of goods sold understates gross margin and distorts every ratio built on it, including inventory turnover.

A negative COGS result means your ending inventory value exceeds beginning inventory plus all additions — this can happen after a write-up of inventory or if figures from different periods are mixed. The result is mathematically correct but almost always signals a data entry error; check your period boundaries.