Cost of Goods Sold Calculator
Calculate cost of goods sold using beginning inventory, purchases and ending inventory to estimate the direct cost of items sold.
Overview
Use this Cost of Goods Sold Calculator to estimate the direct cost of inventory sold during a period. Enter your beginning inventory, purchases, purchase returns, ending inventory and sales revenue to see your cost of goods sold, gross profit and gross margin.
How it works
The calculator follows a common accounting formula. It first adjusts purchases by subtracting purchase returns and allowances to get net purchases. It then adds net purchases to beginning inventory to find goods available for sale. Finally, it subtracts ending inventory to estimate cost of goods sold. If you enter sales revenue, it also calculates gross profit and gross margin for a simple profitability view.
How to use this calculator
- 1Enter the value of beginning inventory for the period.
- 2Add the total purchases made during the period.
- 3Enter any purchase returns or supplier allowances.
- 4Enter the ending inventory value at the close of the period.
- 5Add total sales revenue to estimate gross profit and margin.
- 6Review the calculated cost of goods sold and related results.
Example Calculation
Beginning Inventory
$10,000
Purchases During Period
$25,000
Purchase Returns and Allowances
$1,000
Ending Inventory
$8,000
Sales Revenue
$45,000
Cost of Goods Sold
$26,000
With beginning inventory of 10000, purchases of 25000, returns of 1000 and ending inventory of 8000, net purchases are 24000 and cost of goods sold is 26000. With sales revenue of 45000, estimated gross profit is 19000 and gross margin is about 42.2%.
Frequently asked questions
What does this calculator estimate?
It estimates cost of goods sold using beginning inventory, purchases, purchase returns and ending inventory. It can also show gross profit and gross margin if you enter sales revenue.
What is the formula for cost of goods sold?
A common formula is beginning inventory plus net purchases minus ending inventory. Net purchases are purchases less purchase returns and allowances.
Do I need to enter sales revenue?
Sales revenue is needed only if you want to estimate gross profit and gross margin. The core cost of goods sold calculation uses inventory and purchase figures.
What is included in cost of goods sold?
Cost of goods sold generally includes direct inventory costs tied to products sold. It usually does not include indirect overhead, marketing costs or administrative expenses unless your accounting method treats them differently.
Why might my accounting records show a different result?
Differences can happen because of inventory valuation methods, timing of transactions, freight treatment, write-downs, manufacturing costs or incomplete data.
Can I use this calculator for any business?
It is most useful for businesses that buy, make or resell inventory. Service businesses without inventory may not use cost of goods sold in the same way.
Explore Related Calculators
Assumptions and warnings
Assumptions
- The calculation uses the standard formula: beginning inventory plus net purchases minus ending inventory.
- Inventory values are entered using the same accounting method and valuation basis throughout the period.
- Sales revenue is used only to estimate gross profit and gross margin.
- Results are estimates and should be checked against your accounting records.
Warnings
- This calculator provides an estimate only and is not accounting or financial advice.
- Accurate results depend on correct inventory valuation and complete purchase records.