Cost of Goods Sold for Handmade Products: How to Work It Out
Cost of goods sold, or COGS, is the direct cost of the products you actually sold in a period. For a handmade business that means the materials, packaging and direct labour in those items. It does not include products still sitting on your shelf. You can work it out with an inventory formula for the whole period or by multiplying units sold by the cost of each unit.
The template for thisSmall Business Spreadsheet Bundle $20.30 · 30% off→
Why it matters
Sales minus COGS is your gross profit. It tells you whether your products themselves make money before overheads such as software, advertising and stall fees. If gross profit is thin, no amount of extra sales will fix the business.
What counts as COGS
| Usually included | Usually not included |
|---|---|
| Raw materials in the product | Advertising and marketing |
| Packaging the customer receives | Software and website costs |
| Delivery charges on materials | Tools and equipment |
| Direct labour to make the item | Market stall and listing fees |
| Stock bought for resale | Postage to the customer (often tracked as its own selling cost) |
Treatment varies. Whether your own labour as a sole trader counts, and how fees and postage are grouped, depends on your accounting method and tax rules. Use consistent rules for your own decisions and ask an accountant how to report it. This is not tax advice.
Method 1: the inventory formula
COGS = opening inventory + purchases - closing inventory
Inventory here means the cost value of materials and finished goods you hold.
Worked example for one quarter:
- Opening inventory: 1,200
- Purchases during the quarter: 3,400
- Closing inventory (counted at the end): 950
- COGS = 1,200 + 3,400 - 950 = 3,650
If sales for the quarter were 9,800, gross profit is 9,800 - 3,650 = 6,150, a gross margin of 62.8%.
This method needs a stock count at the start and end of each period. It captures everything, including waste and breakages, because anything not on the shelf is treated as used.
Method 2: per-unit costing
COGS = units sold x cost per unit
Work out the cost of one finished item from a bill of materials: each material and the quantity used, plus packaging and labour. If a candle costs 17.50 to make and you sold 40, COGS for candles is 40 x 17.50 = 700.
Repeat for each product and add them up. This method tells you profit per product, which the inventory formula cannot.
Which to use
- Per-unit costing is best for pricing and for seeing which products earn the most.
- The inventory formula is best as a check on the period as a whole.
- Using both is ideal. If the inventory formula gives a noticeably higher figure than per-unit costing, you have waste, breakage, uncounted samples or out-of-date material costs.
Valuing materials when prices change
If you bought wax at 6.00 a bag in January and 6.80 in March, which cost do you use? Common approaches are:
- First in, first out: assume the oldest stock is used first.
- Average cost: total spent divided by total quantity bought.
Average cost is simpler in a spreadsheet. Whichever you choose, stick with it, and check what your tax rules accept.
Do not forget these
- Waste and failed pieces. If one in ten pieces fails, each good one carries a share of that cost.
- Samples, gifts and items for photos. They used materials but produced no sale.
- Inbound delivery. A 30.00 material order with 8.00 delivery cost you 38.00.
- Small parts. Labels, thread, glue and tape add up across hundreds of items.
For resellers
If you buy finished items to resell, COGS is simpler: it is what you paid for the items you sold, including any delivery to you. An item bought for 12.00 and sold for 48.00 has a COGS of 12.00. Selling fees of 6.24 and postage of 6.50 are selling costs on top, leaving 23.26 profit.
Records you need
- A materials list with unit costs.
- A purchase log with date, supplier, quantity and cost.
- A bill of materials for each product.
- A production log of what you made and when.
- A sales log by product and channel.
- A stock count at the end of each period.
Common mistakes
- Treating all purchases as this period's cost. A big materials order makes one month look terrible and the next look brilliant. Only what was sold is COGS.
- Never counting stock. Without a count you are guessing.
- Using old costs. Update unit costs when supplier prices change.
- Leaving out packaging.
Track it without the headache
The Content Crib Maker Inventory and Profit template keeps materials and purchases, costs each product through a bill of materials including labour and packaging, and suggests a price at your target margin. It records production, sales by channel with fees and shipping, shows stock levels and produces a monthly report. It works in Excel, Google Sheets and Apple Numbers.

Skip the blank page
The Small Business Spreadsheet Bundle includes the Inventory and Profit Tracker, laid out and ready to use. $20.30, instant download.
Get the Small Business Spreadsheet BundleRelated guides
- How to Do Bookkeeping for a Small Business (Beginner Guide)
- Cash Basis vs Accrual Accounting: The Difference in Plain English
- Profit and Loss Statement for a Small Business: How to Make One
- Simple CRM Spreadsheet: What to Track and How to Set It Up
- Sales Pipeline Stages Explained (With Examples for Small Business)