Cost of Goods Sold Calculator
Type your stock at the start and end of the period and what you bought, to see what the goods you sold cost you.
Any currency: type its 3-letter code, e.g. USD, NGN, KES, ZAR.
Stock at cost at the start of the period.
Goods bought for resale during the period.
Stock at cost at the end of the period.
To see gross profit and margin.
Amounts in USD.
| Goods available for sale | 1,010,000.00 |
|---|---|
| Less closing stock | 250,000.00 |
| Cost of goods sold | 760,000.00 |
| Gross profit | 240,000.00 |
- Formula: cost of goods sold = opening stock + purchases + freight and other direct costs − purchase returns − closing stock. Gross profit = sales − cost of goods sold.
- Use the same stock valuation (at cost) at the start and the end.
Results are estimates to help you plan.
A guide to cost of goods sold
What the calculator is for
Cost of goods sold (COGS), also called cost of sales, is what the goods you sold in a period cost you. It is the figure you take away from sales to find gross profit, so a shop, wholesaler or distributor needs it to know whether its prices leave enough to pay rent, wages and other running costs.
How it is worked out
You start with the stock you had at the beginning of the period, add what you bought (and the freight and other direct costs of getting it to you), take away anything you returned to suppliers, and take away the stock still on the shelves at the end. What is left is the cost of what was sold. This is the same layout as the cost of goods sold section of the US tax authority's small-business guide (IRS Publication 334): inventory at the beginning, plus purchases and other costs, minus inventory at the end.
How to use it: an example
A hardware shop starts the year with stock worth KES 200,000 at cost. During the year it buys KES 800,000 of goods, pays KES 20,000 in transport to bring them in and returns KES 10,000 of faulty items. At the year end, stock worth KES 250,000 is left. Its cost of goods sold is KES 760,000. With sales of KES 1,000,000, gross profit is KES 240,000 and the gross margin 24.00%.
Counting stock
- Value stock at what it cost you, not at the selling price.
- Use the same method at the start and the end of the period, or the result will be off.
- Count stock on the last day of the period, before new deliveries are added.
- Leave out goods taken for personal or family use, or count them separately.
When the answer looks wrong
If closing stock is more than the stock you had plus what you bought, the calculator shows an error: something is missing, such as a purchase that was not recorded or a stock count at selling prices. If the goods sold cost more than the sales, the calculator shows a loss on the goods sold.
Using the result
Put the cost of goods sold into the Profit Margin Calculator to see your operating and net margins, or into the Inventory Turnover Calculatorto see how fast your stock sells.
What is not included
Running costs such as rent, salaries and marketing are not part of cost of goods sold; they come after gross profit. Results are estimates to help you plan, not accounts for tax.
Questions
Is cost of goods sold the same as purchases?
Only if your stock did not change. If you bought more than you sold, part of the purchases is still in stock and is not a cost of the goods sold yet.
Should transport costs be included?
Yes, the cost of bringing goods to your shop or store (freight in) is part of their cost. Transport for delivering to customers is a running cost instead.
Can I use it for a month instead of a year?
Yes. Use the stock at the start and end of the month and that month's purchases.