Sample text in [brackets], replace with yours · Accounting & Small Business Spreadsheets
Cost Sheet Format (Excel & PDF)
Materials, labour and overheads build up to prime cost, works cost, cost of production, cost of sales and sales, in total and per unit.
Opens in your browser. No Excel needed, no signup.
Free for personal and commercial use · No watermark · Updated November 2026
Guide
About this cost sheet template
A cost sheet shows how the cost of a product builds up over a period, from raw materials to the selling price. Direct materials, direct labour and direct expenses make the prime cost; adding factory overheads and the change in work-in-progress gives the works (factory) cost; office and administration overheads give the cost of production; adjusting finished goods stock gives the cost of goods sold; and selling and distribution overheads give the cost of sales. Add the profit to reach sales. This sheet shows every level in total and per unit, and works out profit from the margin you set.
How to prepare a cost sheet
- 1
Click "Edit online", or download the Excel file.
- 2
Enter the number of units produced and sold, and your profit margin on cost, at the top.
- 3
Fill in materials, labour, direct expenses and each group of overheads in the yellow cells.
- 4
Enter opening and closing stocks of raw materials, work-in-progress and finished goods (closing stocks as negatives).
- 5
Read prime cost, works cost, cost of production, cost of sales, profit, sales and cost per unit, which all update automatically.
Tips for cost sheets
Keep costs in the right group
Factory rent belongs in works overheads; office rent in administration; delivery and advertising in selling and distribution.
Leave out non-cost items
Income tax, dividends, donations and losses on selling assets are not product costs and do not belong in a cost sheet.
Use per-unit figures to price
The cost of sales per unit is the minimum price before profit. Compare it with your selling price.
Profit on cost vs on sales
This sheet takes the margin as a % of cost. 20% on cost equals 16.7% on sales.
Frequently Asked Questions
Tools that help
Excel to PDF
Convert Excel spreadsheets to PDF with all sheets preserved
PDF to Excel
Extract tables from PDF into editable Excel spreadsheets
Percentage Calculator
Calculate percentages, increase, decrease, and ratios
Discount Calculator
Find final price after discount and savings amount















