Home›Templates›Accounting & Small Business Spreadsheets›Cost Sheet
Preview of the Cost Sheet template

Sample text in [brackets], replace with yours · Accounting & Small Business Spreadsheets

Free template

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.

✓ A4✓ Total + per unit✓ Profit % on cost✓ Excel & PDF

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. 1

    Click "Edit online", or download the Excel file.

  2. 2

    Enter the number of units produced and sold, and your profit margin on cost, at the top.

  3. 3

    Fill in materials, labour, direct expenses and each group of overheads in the yellow cells.

  4. 4

    Enter opening and closing stocks of raw materials, work-in-progress and finished goods (closing stocks as negatives).

  5. 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

Yes. Download the Excel or PDF version, or edit it online for free, with no signup and no watermark.

Prime cost is direct materials consumed plus direct labour plus direct expenses, the costs that can be traced straight to the product.

Opening work-in-progress was partly made last period and closing work-in-progress is not finished yet, so they are adjusted to get the factory cost of the goods completed in this period.

Yes. Leave the materials and stock lines at zero and use labour and overheads; the per-unit column then gives cost per job or per client.

Tools that help

📗

Excel to PDF

Convert Excel spreadsheets to PDF with all sheets preserved

Use Tool→
📊

PDF to Excel

Extract tables from PDF into editable Excel spreadsheets

Use Tool→
%

Percentage Calculator

Calculate percentages, increase, decrease, and ratios

Use Tool→
🏷️

Discount Calculator

Find final price after discount and savings amount

Use Tool→

More accounting & small business spreadsheets

Expense Report template preview

Expense Report

Claim business expenses with category totals and advances.

ExcelPDF
Inventory / Stock Sheet template preview

Inventory / Stock Sheet

Stock in, stock out, closing stock and reorder alerts.

ExcelPDF
Monthly Business Budget template preview

Monthly Business Budget

Budget vs actual for income and expenses, with profit.

ExcelPDF
Cash Book template preview

Cash Book

Daily cash in and out with a running balance.

ExcelPDF
Price List template preview

Price List

Products and services by category, with discounts.

ExcelPDF
Daily Sales Report template preview

Daily Sales Report

Bills, payment methods and end-of-day cash check.

ExcelPDF
Salary Sheet (Payroll) template preview

Salary Sheet (Payroll)

Monthly payroll for all staff: gross, deductions, net pay.

ExcelPDF
Project Plan (Gantt Chart) template preview

Project Plan (Gantt Chart)

Tasks, owners, dates and a 12-week Gantt chart.

ExcelPDF
Income & Expense Tracker template preview

Income & Expense Tracker

Small business money in and out, running balance, profit by category.

ExcelPDF
Profit and Loss Statement template preview

Profit and Loss Statement

Income statement with gross, operating and net profit.

ExcelPDF
Balance Sheet template preview

Balance Sheet

Assets, liabilities and equity with a balance check.

ExcelPDF
Trial Balance template preview

Trial Balance

Every ledger balance in debit and credit, with totals that must agree.

ExcelPDF
Trading Account template preview

Trading Account

Dr/Cr trading account that works out gross profit or gross loss.

ExcelPDF
Cash Flow Statement template preview

Cash Flow Statement

Indirect-method cash flow: operating, investing and financing.

ExcelPDF
Bank Reconciliation Statement template preview

Bank Reconciliation Statement

Match the cash book to the bank statement, with an automatic check.

ExcelPDF
Ledger template preview

Ledger

Ledger account with running Dr/Cr balance, plus a T-format sheet.

ExcelPDF