COGS Calculator

COGS = Beginning Inventory + Purchases - Ending Inventory. Beginning Inventory is the value of all sellable inventory held at the start of the accounting period (typically a month, quarter, or year). Purchases are the total cost of additional inventory acquired during the period, including freight, import duties, and direct handling costs, but excluding any non-inventory expenses like marketing or administrative fees. Ending Inventory is the value of unsold inventory at the period's close, physically counted or estimated using a consistent method (FIFO, LIFO, or weighted average). This formula derives COGS by tracking the flow of inventory: the goods available for sale (beginning + purchases) minus what remains unsold equals what was actually sold. It aligns with the matching principle in accounting, ensuring that the cost of generating revenue is recognized in the same period as the revenue itself. COGS excludes indirect costs (e.g., rent, salaries) and is critical for calculating gross profit (Revenue - COGS) and gross margin. Accurate COGS requires precise inventory valuation; errors in any variable distort margins and tax liabilities.

A 'good' COGS number is relative to your revenue and industry. Typically, COGS as a percentage of revenue (cost of goods sold ratio) ranges from 40-80% for product-based businesses, but this varies widely: service businesses may have near-zero COGS, while grocery stores might run 70-85%. Lower COGS relative to revenue means higher gross margins, which is generally favorable but not always—extremely low COGS could indicate understocking or undervaluing inventory. Interpret COGS by tracking trends over time: a rising COGS percentage may signal supplier price increases, theft, waste, or inventory write-offs. Compare your COGS ratio to your own historical data rather than unverified industry averages. For accurate interpretation, ensure consistent inventory valuation methods (FIFO, LIFO, or average cost) across periods. Remember, COGS only includes direct costs; a low COGS doesn't guarantee net profit if operating expenses are high.

Common mistakes include: (1) Including indirect costs like marketing, rent, or salaries in COGS, which inflates the figure and misrepresents gross profit. (2) Using inconsistent inventory valuation methods between periods (e.g., switching from FIFO to LIFO without adjustment), causing non-comparable numbers. (3) Forgetting to include freight-in, import duties, or handling costs in purchases, understating COGS. (4) Failing to adjust for inventory shrinkage (theft, damage, spoilage) by not doing regular physical counts, leading to inaccurate ending inventory. (5) Misclassifying consignment inventory (goods held but not owned) as owned inventory. Edge cases: Businesses with large returns may need to adjust COGS for returned goods; subscription or digital products with zero physical inventory require different tracking. Always reconcile COGS with actual cash flow to catch errors.

Beginning Inventory

The value of all sellable inventory owned at the start of an accounting period.

Ending Inventory

The value of unsold inventory at the end of an accounting period, determined by physical count or estimation.

Purchases

The total cost of inventory acquired during a period, including freight, duties, and direct handling fees.

Gross Profit

Revenue minus cost of goods sold, representing the profit from core operations before operating expenses.

FIFO (First-In, First-Out)

An inventory valuation method assuming the oldest items are sold first, affecting COGS and ending inventory values.