A cost sheet is a statement that lists every cost of making a product during a set period and shows the cost of each unit. Cost accountants use it to set prices and spot where money goes. Business owners use it for the same reasons.
Take a workshop that makes 500 wooden stools a month and sells each for $130. Without a cost sheet, the owner can’t tell if $130 covers wood, wages, rent, and delivery. With one, the answer takes minutes.
This guide explains the meaning, format, and formulas, then walks through a full example and an Excel layout. It also shows where Expense 365 fits in.
- A cost sheet lists every cost of making a product and shows the cost per unit
- It has four stages: prime cost, factory cost, cost of production, and cost of sales
- You prepare it by totaling direct costs, adding shared costs like rent and power, and dividing by units made
- Expense 365 doesn’t build the sheet, but it keeps expense data organized and synced to your accounting software
What Is a Cost Sheet?
A cost sheet, also called a statement of cost, is a report that groups all costs of a product or job into stages and shows the total and per-unit cost for a period. It starts with direct costs, adds overheads, and ends with cost of sales and profit.
In cost accounting, the cost sheet is the main output of the costing process. Accountants record each cost, label it direct or indirect, and present it in a fixed order. Financial statements report the whole company’s results. A cost sheet reports what one product costs.
What Is the Purpose of a Cost Sheet?
The purpose of a cost sheet is to show what a product really costs, so you can set a selling price that covers expenses and earns a profit. It also supports cost control, cost analysis, and budgeting by showing which cost group grows fastest from one period to the next.
The importance of a cost sheet shows up in five places:
- Pricing: shows the lowest price that still covers every cost
- Cost control: flags which cost group grew since last period
- Decisions: shows whether to make a part in-house or buy it
- Quotes: gives a tested cost base for bids and tenders
- Planning: turns past figures into next period’s estimates
What Are the Main Components of a Cost Sheet?
A cost sheet has four main components: prime cost, factory overheads, office and administration overheads and selling and distribution overheads. Each layer adds to the one before it, so you can see the cost at every stage of production. These are the elements of a cost sheet.
Direct costs trace to one product, such as wood or a carpenter’s wages. Indirect costs support production as a whole, such as factory rent. Cost allocation spreads indirect costs across units using a fixed basis, like direct labor hours.
Prime cost is direct materials, direct labor, and direct expenses added together. Direct expenses include costs like a design royalty or tooling hired for one order. It sets the minimum direct cost you must recover on each unit sold.
Factory cost, also called works cost, is prime cost plus factory overheads. Overheads are indirect costs, such as factory rent, power, indirect labor and machine depreciation.
Cost of production is factory cost plus office and administration overheads, such as office salaries and stationery.
These cover marketing, sales commissions, and delivery. Add them to cost of production to get cost of sales.
What Are the Different Types of Cost Sheets?
There are two main types of cost sheets: historical and estimated. A historical cost sheet records costs a business has already spent. An estimated cost sheet predicts costs before production starts, so you can price a job or plan a budget.
A business prepares it after production, using actual figures. It’s the most common type, and it shows what each unit really cost.
A business prepares it before production, using forecasts. Comparing it with the historical sheet later reveals where actual costs ran over plan.
What Is the Standard Cost Sheet Format?
The standard cost sheet format lists costs in stages, from prime cost down to profit, with a total column and a cost per unit column. Each stage builds on the last, so the layout reads like a staircase. Use it as a cost sheet template for any product.
|
Particulars |
Total ($) |
Per unit ($) |
|
Direct materials consumed |
|
|
|
Direct labor |
|
|
|
Direct expenses |
|
|
|
Prime cost |
|
|
|
Add: factory overheads |
|
|
|
Factory cost |
|
|
|
Add: office and administration overheads |
|
|
|
Cost of production |
|
|
|
Add: selling and distribution overheads |
|
|
|
Cost of sales |
|
|
|
Profit |
|
|
|
Sales |
|
|
How to Prepare a Cost Sheet Step by Step?
To prepare a cost sheet, list your direct costs first, then add overheads stage by stage, and finish by dividing by units produced. Use records from one fixed period, such as a month. Here’s the cost sheet preparation process in six steps.
- Pick the period and count the units produced, such as 500 stools in March
- Work out materials consumed: opening stock plus purchases minus closing stock
- Add direct labor and direct expenses to reach prime cost
- Allocate factory overheads and add them to get factory cost
- Add office and administration overheads to reach cost of production
- Add selling and distribution overheads for cost of sales, then compare it with sales to find profit
Many costs can’t be traced to one product. Allocate them using a fixed basis, such as a percentage of direct labor or machine hours. Use the same basis every period so comparisons stay fair.
What Are the Important Cost Sheet Formulas?
Six formulas drive a cost sheet: prime cost, factory cost, cost of production, cost of sales, profit, and cost per unit. Five are simple addition or subtraction. Only cost per unit needs division. A setup formula for materials consumed feeds the first line.
|
Item |
Formula |
|
Materials consumed |
Opening stock + Purchases − Closing stock |
|
Prime cost |
Direct materials + Direct labor + Direct expenses |
|
Factory cost |
Prime cost + Factory overheads |
|
Cost of production |
Factory cost + Office and administration overheads |
|
Cost of sales |
Cost of production + Selling and distribution overheads |
|
Profit |
Sales − Cost of sales |
|
Cost per unit |
Cost of production ÷ Units produced |
What Is an Example of a Cost Sheet?
Here’s a worked cost sheet example for a small workshop that made and sold 500 wooden stools in March. The workshop spent $98 to make each stool and $106 to make and sell it, leaving $24 profit per unit. The figures are illustrative.
Materials consumed: $4,000 opening stock + $22,000 purchases − $6,000 closing stock = $20,000.
Particulars | Total ($) | Per unit ($) |
Direct materials consumed | 20,000 | 40.00 |
Direct labor | 12,000 | 24.00 |
Direct expenses | 3,000 | 6.00 |
Prime cost | 35,000 | 70.00 |
Add: factory overheads | 9,000 | 18.00 |
Factory cost | 44,000 | 88.00 |
Add: office and administration overheads | 5,000 | 10.00 |
Cost of production | 49,000 | 98.00 |
Add: selling and distribution overheads | 4,000 | 8.00 |
Cost of sales | 53,000 | 106.00 |
Profit | 12,000 | 24.00 |
Sales (500 units at $130) | 65,000 | 130.00 |
The $9,000 of factory overheads came from rent ($3,000), power ($1,500), indirect labor ($2,500), and depreciation ($2,000). A $500 saving on power would cut cost per unit by $1.
How to Create a Cost Sheet in Excel?
To create a cost sheet in Excel, set up three columns for particulars, total, and cost per unit, enter each cost line in order, and use formulas for every subtotal. Excel recalculates the sheet when you change an input, so you can test prices quickly.
- Type the line items from the format table into column A, with headings in row 1
- Enter the period’s costs in column B and the units produced in B14
- Use formulas for each subtotal, as shown below
- Fill column C with the total divided by units produced
- Save the file as your cost sheet template and copy it each period
Pull overhead and direct expense totals from your expense records instead of retyping them. Expense categorization in a tool like Expense 365 makes those totals quick to find.
What Are the Benefits and Limitations of a Cost Sheet?
A cost sheet gives clear per-unit costs, better pricing, and tighter cost control. Its limits are that it relies on accurate records, can’t predict price changes, and takes time to maintain. Used with up-to-date data, the benefits usually outweigh the effort.
Benefits of a cost sheet?
- Pricing: shows the lowest price that still covers all costs
- Cost control: highlights which cost group grew from last period
- Comparison: lets you compare periods, products, or estimates against actuals
- Decision support: shows whether a new product line or shift pays off.
Limitations of a cost sheet?
- Accuracy: wrong inputs give wrong results, and overhead allocation involves judgment
- Timing: it reports a closed period, so cost changes show up late
- Effort: manual updates in spreadsheets take hours and invite errors
How Does Expense 365 Support Accurate Cost Sheet Preparation?
Expense 365 is Microsoft 365-native expense management software. It doesn’t build a cost sheet itself, but it keeps expense data accurate, categorized, and synced to your accounting software. Cost accountants then get clean overhead and direct expense figures to work from.
- Accounting software integration: sends approved expenses and reimbursements to QuickBooks, Xero, or Zoho Books for financial reporting
- Business expense tracking: records expenses in one place, so finance teams find cost data fast
- Expense categorization: groups spend into categories that support cost allocation and analysis
- Automated expense approvals: routes expenses for review before they reach your financial records
- Expense reporting: gives accounting teams organized data, including Power BI dashboards, for cost statements and spend analysis
Connecting Expense 365 with your accounting software reduces manual data entry and keeps expense records consistent. Your accounting team can then combine this data with production and inventory records to prepare accurate cost sheets.
Conclusion
A cost sheet turns scattered cost records into one statement that shows what each unit costs and what it earns. Build it in four stages, from prime cost to cost of sales, divide by units produced, and review it every period for cost control.
Start with the Excel layout above. Then check that the expense figures going into it are accurate, categorized, and approved. Expense 365 helps by syncing business expenses to your accounting software, so your finance team isn’t retyping overhead totals.
Ready to optimize your expense management with Expense 365?
Frequently Asked Questions
What is the difference between a cost sheet and a financial statement?
A cost sheet is an internal report that breaks down what a product costs, so managers can price and control spending. Financial statements, such as the income statement and balance sheet, report the whole company’s results to owners, lenders, and tax authorities. You can prepare one whenever you need it. Financial statements follow a set reporting cycle.
What is the difference between direct and indirect costs?
Direct costs link to one product, such as fabric in a shirt or a tailor’s wages. Indirect costs support the whole operation, such as factory rent, power, or a supervisor’s salary. Direct costs go straight into prime cost. Indirect costs are shared across units through overhead allocation, often as a percentage of direct labor.
Is a cost sheet only for manufacturing businesses?
No. Manufacturers use it most because they have clear material, labor, and factory costs. Service businesses can use the same layout, swapping materials for supplies and tracking labor hours and overheads per job. Any business that prices work or wants to see where its money goes can use one.
How do you calculate cost per unit from a cost sheet?
Divide the total cost for the period by the units produced. Use cost of production for the cost to make each unit. Use cost of sales if you also want selling and distribution costs included. In the example above, $49,000 divided by 500 stools gives $98 per unit.
Can expense management software prepare a cost sheet?
Not by itself. A cost sheet also needs production data, such as material usage and units made, which usually sits in costing or inventory records. Expense management software helps by capturing, categorizing, and approving spend, then syncing it to your accounting system. Your overhead and direct expense figures start out accurate.
